9337: --
9338: l_date := SYSDATE;
9339:
9340: --
9341: l_user_id := fnd_global.user_id;
9342: l_login_id := fnd_global.login_id;
9343:
9344: IF l_login_id = -1 THEN
9345: l_login_id := fnd_global.conc_login_id;
9338: l_date := SYSDATE;
9339:
9340: --
9341: l_user_id := fnd_global.user_id;
9342: l_login_id := fnd_global.login_id;
9343:
9344: IF l_login_id = -1 THEN
9345: l_login_id := fnd_global.conc_login_id;
9346: END IF;
9341: l_user_id := fnd_global.user_id;
9342: l_login_id := fnd_global.login_id;
9343:
9344: IF l_login_id = -1 THEN
9345: l_login_id := fnd_global.conc_login_id;
9346: END IF;
9347:
9348: l_request_id := fnd_global.conc_request_id;
9349: l_prog_appl_id := fnd_global.prog_appl_id;
9344: IF l_login_id = -1 THEN
9345: l_login_id := fnd_global.conc_login_id;
9346: END IF;
9347:
9348: l_request_id := fnd_global.conc_request_id;
9349: l_prog_appl_id := fnd_global.prog_appl_id;
9350: l_program_id := fnd_global.conc_program_id;
9351: --
9352:
9345: l_login_id := fnd_global.conc_login_id;
9346: END IF;
9347:
9348: l_request_id := fnd_global.conc_request_id;
9349: l_prog_appl_id := fnd_global.prog_appl_id;
9350: l_program_id := fnd_global.conc_program_id;
9351: --
9352:
9353: IF (l_debug = 1) THEN
9346: END IF;
9347:
9348: l_request_id := fnd_global.conc_request_id;
9349: l_prog_appl_id := fnd_global.prog_appl_id;
9350: l_program_id := fnd_global.conc_program_id;
9351: --
9352:
9353: IF (l_debug = 1) THEN
9354: debug_print(' Before inserting record');
11523: -- obtain program and user info
11524: l_date := SYSDATE;
11525:
11526: --
11527: l_user_id := fnd_global.user_id;
11528: l_login_id := fnd_global.login_id;
11529:
11530: IF l_login_id = -1 THEN
11531: l_login_id := fnd_global.conc_login_id;
11524: l_date := SYSDATE;
11525:
11526: --
11527: l_user_id := fnd_global.user_id;
11528: l_login_id := fnd_global.login_id;
11529:
11530: IF l_login_id = -1 THEN
11531: l_login_id := fnd_global.conc_login_id;
11532: END IF;
11527: l_user_id := fnd_global.user_id;
11528: l_login_id := fnd_global.login_id;
11529:
11530: IF l_login_id = -1 THEN
11531: l_login_id := fnd_global.conc_login_id;
11532: END IF;
11533:
11534: l_request_id := fnd_global.conc_request_id;
11535: l_prog_appl_id := fnd_global.prog_appl_id;
11530: IF l_login_id = -1 THEN
11531: l_login_id := fnd_global.conc_login_id;
11532: END IF;
11533:
11534: l_request_id := fnd_global.conc_request_id;
11535: l_prog_appl_id := fnd_global.prog_appl_id;
11536: l_program_id := fnd_global.conc_program_id;
11537: --
11538: -- update the table
11531: l_login_id := fnd_global.conc_login_id;
11532: END IF;
11533:
11534: l_request_id := fnd_global.conc_request_id;
11535: l_prog_appl_id := fnd_global.prog_appl_id;
11536: l_program_id := fnd_global.conc_program_id;
11537: --
11538: -- update the table
11539: IF (l_debug = 1) THEN
11532: END IF;
11533:
11534: l_request_id := fnd_global.conc_request_id;
11535: l_prog_appl_id := fnd_global.prog_appl_id;
11536: l_program_id := fnd_global.conc_program_id;
11537: --
11538: -- update the table
11539: IF (l_debug = 1) THEN
11540: debug_print('Calling mtl_reservations_pkg.update_row');
12293: -- obtain program and user info
12294: l_date := SYSDATE;
12295:
12296: --
12297: l_user_id := fnd_global.user_id;
12298: l_login_id := fnd_global.login_id;
12299:
12300: IF l_login_id = -1 THEN
12301: l_login_id := fnd_global.conc_login_id;
12294: l_date := SYSDATE;
12295:
12296: --
12297: l_user_id := fnd_global.user_id;
12298: l_login_id := fnd_global.login_id;
12299:
12300: IF l_login_id = -1 THEN
12301: l_login_id := fnd_global.conc_login_id;
12302: END IF;
12297: l_user_id := fnd_global.user_id;
12298: l_login_id := fnd_global.login_id;
12299:
12300: IF l_login_id = -1 THEN
12301: l_login_id := fnd_global.conc_login_id;
12302: END IF;
12303:
12304: l_request_id := fnd_global.conc_request_id;
12305: l_prog_appl_id := fnd_global.prog_appl_id;
12300: IF l_login_id = -1 THEN
12301: l_login_id := fnd_global.conc_login_id;
12302: END IF;
12303:
12304: l_request_id := fnd_global.conc_request_id;
12305: l_prog_appl_id := fnd_global.prog_appl_id;
12306: l_program_id := fnd_global.conc_program_id;
12307:
12308: --Adding an extra check to make sure that relieve reservations does not
12301: l_login_id := fnd_global.conc_login_id;
12302: END IF;
12303:
12304: l_request_id := fnd_global.conc_request_id;
12305: l_prog_appl_id := fnd_global.prog_appl_id;
12306: l_program_id := fnd_global.conc_program_id;
12307:
12308: --Adding an extra check to make sure that relieve reservations does not
12309: -- update the record to a negative quantity.
12302: END IF;
12303:
12304: l_request_id := fnd_global.conc_request_id;
12305: l_prog_appl_id := fnd_global.prog_appl_id;
12306: l_program_id := fnd_global.conc_program_id;
12307:
12308: --Adding an extra check to make sure that relieve reservations does not
12309: -- update the record to a negative quantity.
12310: IF (l_debug = 1) THEN
14174: -- obtain program and user info
14175: l_date := SYSDATE;
14176:
14177: --
14178: l_user_id := fnd_global.user_id;
14179: l_login_id := fnd_global.login_id;
14180:
14181: IF l_login_id = -1 THEN
14182: l_login_id := fnd_global.conc_login_id;
14175: l_date := SYSDATE;
14176:
14177: --
14178: l_user_id := fnd_global.user_id;
14179: l_login_id := fnd_global.login_id;
14180:
14181: IF l_login_id = -1 THEN
14182: l_login_id := fnd_global.conc_login_id;
14183: END IF;
14178: l_user_id := fnd_global.user_id;
14179: l_login_id := fnd_global.login_id;
14180:
14181: IF l_login_id = -1 THEN
14182: l_login_id := fnd_global.conc_login_id;
14183: END IF;
14184:
14185: l_request_id := fnd_global.conc_request_id;
14186: l_prog_appl_id := fnd_global.prog_appl_id;
14181: IF l_login_id = -1 THEN
14182: l_login_id := fnd_global.conc_login_id;
14183: END IF;
14184:
14185: l_request_id := fnd_global.conc_request_id;
14186: l_prog_appl_id := fnd_global.prog_appl_id;
14187: l_program_id := fnd_global.conc_program_id;
14188:
14189: --
14182: l_login_id := fnd_global.conc_login_id;
14183: END IF;
14184:
14185: l_request_id := fnd_global.conc_request_id;
14186: l_prog_appl_id := fnd_global.prog_appl_id;
14187: l_program_id := fnd_global.conc_program_id;
14188:
14189: --
14190: -- actions based on l_transfer_all and l_to_row_exist
14183: END IF;
14184:
14185: l_request_id := fnd_global.conc_request_id;
14186: l_prog_appl_id := fnd_global.prog_appl_id;
14187: l_program_id := fnd_global.conc_program_id;
14188:
14189: --
14190: -- actions based on l_transfer_all and l_to_row_exist
14191: -- l_transfer_all l_to_row_exist from row to row