26: l_loginid NUMBER;
27:
28: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
29: BEGIN
30: l_userid := fnd_global.user_id;
31: l_loginid := fnd_global.login_id;
32:
33: insert into WMS_ASN_DETAILS (
34: GROUP_ID ,
27:
28: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
29: BEGIN
30: l_userid := fnd_global.user_id;
31: l_loginid := fnd_global.login_id;
32:
33: insert into WMS_ASN_DETAILS (
34: GROUP_ID ,
35: SHIPMENT_NUM ,
97:
98: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
99: BEGIN
100:
101: l_userid := fnd_global.user_id;
102: l_loginid := fnd_global.login_id;
103:
104: Begin
105: select 1 into l_exists
98: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
99: BEGIN
100:
101: l_userid := fnd_global.user_id;
102: l_loginid := fnd_global.login_id;
103:
104: Begin
105: select 1 into l_exists
106: from WMS_ASN_DETAILS
139:
140: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
141: BEGIN
142:
143: l_userid := fnd_global.user_id;
144: l_loginid := fnd_global.login_id;
145:
146: Begin
147: select 1 into l_exists
140: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
141: BEGIN
142:
143: l_userid := fnd_global.user_id;
144: l_loginid := fnd_global.login_id;
145:
146: Begin
147: select 1 into l_exists
148: from WMS_ASN_DETAILS