eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_RECEIVE_PVT dependencies on FND_LOG

Line 82: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

78: -- Standard Start of API savepoint
79: SAVEPOINT sp_receive_item;
80:
81:
82: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
83: THEN
84: fnd_log.STRING (fnd_log.level_procedure,
85: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM.BEGIN',
86: 'Entered RECEIVE_ITEM'

Line 84: fnd_log.STRING (fnd_log.level_procedure,

80:
81:
82: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
83: THEN
84: fnd_log.STRING (fnd_log.level_procedure,
85: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM.BEGIN',
86: 'Entered RECEIVE_ITEM'
87: );
88: END IF;

Line 91: fnd_log.level_statement,

87: );
88: END IF;
89:
90: dump_receive_tbl ( p_receive_tbl,
91: fnd_log.level_statement,
92: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM.BEGIN'
93: );
94: IF fnd_api.to_boolean (p_init_msg_list)
95: THEN

Line 116: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

112:
113: /**********Program logic ******************/
114:
115: --Validate all the records in the input table.
116: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
117: THEN
118: fnd_log.STRING (fnd_log.level_event,
119: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM',
120: 'Validating Input'

Line 118: fnd_log.STRING (fnd_log.level_event,

114:
115: --Validate all the records in the input table.
116: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
117: THEN
118: fnd_log.STRING (fnd_log.level_event,
119: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM',
120: 'Validating Input'
121: );
122: END IF;

Line 172: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

168: -- end bug#9058678,subhat.
169: END LOOP;
170:
171: --------POpulate the interface tables.
172: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
173: THEN
174: fnd_log.STRING (fnd_log.level_event,
175: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM',
176: 'Populating Interface tables'

Line 174: fnd_log.STRING (fnd_log.level_event,

170:
171: --------POpulate the interface tables.
172: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
173: THEN
174: fnd_log.STRING (fnd_log.level_event,
175: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM',
176: 'Populating Interface tables'
177: );
178: END IF;

Line 197: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

193: RAISE fnd_api.g_exc_error;
194: END IF;
195:
196: -- Call request online to invoke receiving processsor in online mode.
197: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
198: THEN
199: fnd_log.STRING (fnd_log.level_event,
200: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM',
201: 'Calling the receive api online'

Line 199: fnd_log.STRING (fnd_log.level_event,

195:
196: -- Call request online to invoke receiving processsor in online mode.
197: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
198: THEN
199: fnd_log.STRING (fnd_log.level_event,
200: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM',
201: 'Calling the receive api online'
202: );
203: END IF;

Line 220: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

216: THEN
217: RAISE fnd_api.g_exc_error;
218: END IF;
219:
220: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
221: THEN
222: fnd_log.STRING
223: (fnd_log.level_event,
224: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM',

Line 222: fnd_log.STRING

218: END IF;
219:
220: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
221: THEN
222: fnd_log.STRING
223: (fnd_log.level_event,
224: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM',
225: 'Checking the errors in interface tables after the receive process'
226: );

Line 223: (fnd_log.level_event,

219:
220: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
221: THEN
222: fnd_log.STRING
223: (fnd_log.level_event,
224: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM',
225: 'Checking the errors in interface tables after the receive process'
226: );
227: END IF;

Line 260: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

256: -- Standard call to get message count and IF count is get message info.
257: fnd_msg_pub.count_and_get (p_count => x_msg_count,
258: p_data => x_msg_data);
259:
260: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
261: THEN
262: fnd_log.STRING (fnd_log.level_procedure,
263: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM.END',
264: 'Leaving RECEIVE_ITEM'

Line 262: fnd_log.STRING (fnd_log.level_procedure,

258: p_data => x_msg_data);
259:
260: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
261: THEN
262: fnd_log.STRING (fnd_log.level_procedure,
263: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM.END',
264: 'Leaving RECEIVE_ITEM'
265: );
266: END IF;

Line 291: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)

287: );
288: end if;
289: *****************************/
290:
291: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
292: THEN
293: fnd_log.STRING (fnd_log.level_error,
294: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM',
295: 'EXC_ERROR in Receive_Item[' || x_msg_data || ']'

Line 293: fnd_log.STRING (fnd_log.level_error,

289: *****************************/
290:
291: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
292: THEN
293: fnd_log.STRING (fnd_log.level_error,
294: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM',
295: 'EXC_ERROR in Receive_Item[' || x_msg_data || ']'
296: );
297: END IF;

Line 305: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

301: ROLLBACK TO sp_receive_item;
302: fnd_msg_pub.count_and_get (p_count => x_msg_count,
303: p_data => x_msg_data);
304:
305: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
306: THEN
307: fnd_log.STRING (fnd_log.level_exception,
308: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM',
309: 'EXC_UNEXPECTED_ERROR in Receive_Item[' || x_msg_data || ']'

Line 307: fnd_log.STRING (fnd_log.level_exception,

303: p_data => x_msg_data);
304:
305: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
306: THEN
307: fnd_log.STRING (fnd_log.level_exception,
308: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM',
309: 'EXC_UNEXPECTED_ERROR in Receive_Item[' || x_msg_data || ']'
310: );
311: END IF;

Line 325: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

321:
322: fnd_msg_pub.count_and_get (p_count => x_msg_count,
323: p_data => x_msg_data);
324:
325: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
326: THEN
327: fnd_log.STRING (fnd_log.level_unexpected,
328: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM',
329: 'SQL Message in Receive_Item[' || SQLERRM || ']'

Line 327: fnd_log.STRING (fnd_log.level_unexpected,

323: p_data => x_msg_data);
324:
325: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
326: THEN
327: fnd_log.STRING (fnd_log.level_unexpected,
328: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM',
329: 'SQL Message in Receive_Item[' || SQLERRM || ']'
330: );
331: END IF;

Line 400: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

396:
397: BEGIN
398:
399:
400: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
401: THEN
402: fnd_log.STRING
403: (fnd_log.level_procedure,
404: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS.BEGIN',

Line 402: fnd_log.STRING

398:
399:
400: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
401: THEN
402: fnd_log.STRING
403: (fnd_log.level_procedure,
404: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS.BEGIN',
405: 'Entered Populate_Rcv_Intf_Tbls'
406: );

Line 403: (fnd_log.level_procedure,

399:
400: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
401: THEN
402: fnd_log.STRING
403: (fnd_log.level_procedure,
404: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS.BEGIN',
405: 'Entered Populate_Rcv_Intf_Tbls'
406: );
407: END IF;

Line 431: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

427: -- initialize return status
428: x_return_status := fnd_api.g_ret_sts_success;
429:
430: ---Program logic.......
431: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
432: THEN
433: fnd_log.STRING (fnd_log.level_event,
434: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
435: 'Inserting header interface table data'

Line 433: fnd_log.STRING (fnd_log.level_event,

429:
430: ---Program logic.......
431: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
432: THEN
433: fnd_log.STRING (fnd_log.level_event,
434: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
435: 'Inserting header interface table data'
436: );
437: END IF;

Line 509: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

505: -- bug fix for performance bug 4277749 end
506:
507: IF (exec_flag)
508: THEN
509: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
510: THEN
511: fnd_log.STRING
512: (fnd_log.level_event,
513: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',

Line 511: fnd_log.STRING

507: IF (exec_flag)
508: THEN
509: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
510: THEN
511: fnd_log.STRING
512: (fnd_log.level_event,
513: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
514: 'Calling execute immediate with sql['
515: || sql_str

Line 512: (fnd_log.level_event,

508: THEN
509: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
510: THEN
511: fnd_log.STRING
512: (fnd_log.level_event,
513: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
514: 'Calling execute immediate with sql['
515: || sql_str
516: || ']'

Line 524: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

520: -- bug fix for performance bug 4277749 , added using clause
521: EXECUTE IMMEDIATE sql_str using l_hdr_intf_id;
522: END IF;
523:
524: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
525: THEN
526: fnd_log.STRING (fnd_log.level_event,
527: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
528: 'Inserting transactions interface table data'

Line 526: fnd_log.STRING (fnd_log.level_event,

522: END IF;
523:
524: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
525: THEN
526: fnd_log.STRING (fnd_log.level_event,
527: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
528: 'Inserting transactions interface table data'
529: );
530: END IF;

Line 718: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

714: sql_str :=
715: ' UPDATE RCV_TRANSACTIONS_INTERFACE SET OE_ORDER_NUM = :1'
716: || ' WHERE INTERFACE_TRANSACTION_ID=:2' ;
717:
718: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
719: THEN
720: fnd_log.STRING
721: (fnd_log.level_event,
722: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',

Line 720: fnd_log.STRING

716: || ' WHERE INTERFACE_TRANSACTION_ID=:2' ;
717:
718: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
719: THEN
720: fnd_log.STRING
721: (fnd_log.level_event,
722: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
723: 'Calling execute immediate with sql['
724: || sql_str

Line 721: (fnd_log.level_event,

717:
718: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
719: THEN
720: fnd_log.STRING
721: (fnd_log.level_event,
722: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
723: 'Calling execute immediate with sql['
724: || sql_str
725: || ']'

Line 735: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

731:
732: /**********************Commented for 4277749
733: IF (sql_str IS NOT NULL)
734: THEN
735: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
736: THEN
737: fnd_log.STRING
738: (fnd_log.level_event,
739: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',

Line 737: fnd_log.STRING

733: IF (sql_str IS NOT NULL)
734: THEN
735: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
736: THEN
737: fnd_log.STRING
738: (fnd_log.level_event,
739: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
740: 'Calling execute immediate with sql['
741: || sql_str

Line 738: (fnd_log.level_event,

734: THEN
735: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
736: THEN
737: fnd_log.STRING
738: (fnd_log.level_event,
739: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
740: 'Calling execute immediate with sql['
741: || sql_str
742: || ']'

Line 761: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

757: ELSE
758: l_txn_tmp_id := l_intf_txn_id;
759: END IF;
760:
761: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
762: THEN
763: fnd_log.STRING
764: (fnd_log.level_event,
765: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',

Line 763: fnd_log.STRING

759: END IF;
760:
761: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
762: THEN
763: fnd_log.STRING
764: (fnd_log.level_event,
765: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
766: 'Inserting lot interface table data for ['
767: || l_intf_txn_id

Line 764: (fnd_log.level_event,

760:
761: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
762: THEN
763: fnd_log.STRING
764: (fnd_log.level_event,
765: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
766: 'Inserting lot interface table data for ['
767: || l_intf_txn_id
768: || ']lot number['

Line 803: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

799: -- bug fix for performance bug 4277749 changed the where clause
800: -- to use using clause
801: || ' Where transaction_interface_id = :1';
802:
803: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
804: THEN
805: fnd_log.STRING
806: (fnd_log.level_event,
807: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',

Line 805: fnd_log.STRING

801: || ' Where transaction_interface_id = :1';
802:
803: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
804: THEN
805: fnd_log.STRING
806: (fnd_log.level_event,
807: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
808: 'Calling execute immediate with sql['
809: || sql_str

Line 806: (fnd_log.level_event,

802:
803: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
804: THEN
805: fnd_log.STRING
806: (fnd_log.level_event,
807: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
808: 'Calling execute immediate with sql['
809: || sql_str
810: || ']'

Line 829: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

825: THEN
826: l_txn_tmp_id := l_intf_txn_id;
827: END IF;
828:
829: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
830: THEN
831: fnd_log.STRING
832: (fnd_log.level_event,
833: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',

Line 831: fnd_log.STRING

827: END IF;
828:
829: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
830: THEN
831: fnd_log.STRING
832: (fnd_log.level_event,
833: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
834: 'Inserting serial interface table data for ['
835: || l_intf_txn_id

Line 832: (fnd_log.level_event,

828:
829: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
830: THEN
831: fnd_log.STRING
832: (fnd_log.level_event,
833: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
834: 'Inserting serial interface table data for ['
835: || l_intf_txn_id
836: || ']serial number['

Line 870: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

866: -- bug fix for performance bug 4277749 changed the where clause
867: -- to use using clause
868: || ' Where transaction_interface_id = :1';
869:
870: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
871: THEN
872: fnd_log.STRING
873: (fnd_log.level_event,
874: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',

Line 872: fnd_log.STRING

868: || ' Where transaction_interface_id = :1';
869:
870: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
871: THEN
872: fnd_log.STRING
873: (fnd_log.level_event,
874: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
875: 'Calling execute immediate with sql['
876: || sql_str

Line 873: (fnd_log.level_event,

869:
870: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
871: THEN
872: fnd_log.STRING
873: (fnd_log.level_event,
874: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
875: 'Calling execute immediate with sql['
876: || sql_str
877: || ']'

Line 893: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

889: -- Standard call to get message count and IF count is get message info.
890: fnd_msg_pub.count_and_get (p_count => x_msg_count,
891: p_data => x_msg_data);
892:
893: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
894: THEN
895: fnd_log.STRING (fnd_log.level_procedure,
896: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
897: 'Leaving POPULATE_RCV_INTF_TBLS'

Line 895: fnd_log.STRING (fnd_log.level_procedure,

891: p_data => x_msg_data);
892:
893: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
894: THEN
895: fnd_log.STRING (fnd_log.level_procedure,
896: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
897: 'Leaving POPULATE_RCV_INTF_TBLS'
898: );
899: END IF;

Line 912: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)

908: ROLLBACK ;
909: fnd_msg_pub.count_and_get (p_count => x_msg_count,
910: p_data => x_msg_data);
911:
912: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
913: THEN
914: fnd_log.STRING
915: (fnd_log.level_error,
916: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',

Line 914: fnd_log.STRING

910: p_data => x_msg_data);
911:
912: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
913: THEN
914: fnd_log.STRING
915: (fnd_log.level_error,
916: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
917: 'EXC_EXC_ERROR in populate rcv intf tbls [' || x_msg_data || ']'
918: );

Line 915: (fnd_log.level_error,

911:
912: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
913: THEN
914: fnd_log.STRING
915: (fnd_log.level_error,
916: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
917: 'EXC_EXC_ERROR in populate rcv intf tbls [' || x_msg_data || ']'
918: );
919: END IF;

Line 927: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

923: ROLLBACK ;
924: fnd_msg_pub.count_and_get (p_count => x_msg_count,
925: p_data => x_msg_data);
926:
927: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
928: THEN
929: fnd_log.STRING
930: (fnd_log.level_exception,
931: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',

Line 929: fnd_log.STRING

925: p_data => x_msg_data);
926:
927: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
928: THEN
929: fnd_log.STRING
930: (fnd_log.level_exception,
931: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
932: 'EXC_UNEXPECTED_ERROR in populate rcv intf tbls[' || x_msg_data || ']'
933: );

Line 930: (fnd_log.level_exception,

926:
927: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
928: THEN
929: fnd_log.STRING
930: (fnd_log.level_exception,
931: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
932: 'EXC_UNEXPECTED_ERROR in populate rcv intf tbls[' || x_msg_data || ']'
933: );
934: END IF;

Line 948: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

944:
945: fnd_msg_pub.count_and_get (p_count => x_msg_count,
946: p_data => x_msg_data);
947:
948: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
949: THEN
950: fnd_log.STRING
951: (fnd_log.level_unexpected,
952: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',

Line 950: fnd_log.STRING

946: p_data => x_msg_data);
947:
948: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
949: THEN
950: fnd_log.STRING
951: (fnd_log.level_unexpected,
952: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
953: 'SQL Message in populate rcv intf tbls[' || SQLERRM || ']'
954: );

Line 951: (fnd_log.level_unexpected,

947:
948: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
949: THEN
950: fnd_log.STRING
951: (fnd_log.level_unexpected,
952: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
953: 'SQL Message in populate rcv intf tbls[' || SQLERRM || ']'
954: );
955: END IF;

Line 1035: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1031: l_req_id NUMBER;
1032: BEGIN
1033:
1034:
1035: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1036: THEN
1037: fnd_log.STRING (fnd_log.level_procedure,
1038: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE.BEGIN',
1039: 'Entered RCV_REQ_ONLINE'

Line 1037: fnd_log.STRING (fnd_log.level_procedure,

1033:
1034:
1035: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1036: THEN
1037: fnd_log.STRING (fnd_log.level_procedure,
1038: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE.BEGIN',
1039: 'Entered RCV_REQ_ONLINE'
1040: );
1041: END IF;

Line 1072: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

1068: /*
1069: ** Set the cursor style to working
1070: */
1071:
1072: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1073: THEN
1074: fnd_log.STRING (fnd_log.level_event,
1075: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1076: 'Calling receiving processor with req group id['

Line 1074: fnd_log.STRING (fnd_log.level_event,

1070: */
1071:
1072: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1073: THEN
1074: fnd_log.STRING (fnd_log.level_event,
1075: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1076: 'Calling receiving processor with req group id['
1077: || p_request_group_id
1078: || ']'

Line 1100: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

1096: NULL, NULL, NULL, NULL, NULL, NULL,
1097: NULL, NULL, NULL, NULL, NULL, NULL
1098: );
1099:
1100: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1101: THEN
1102: fnd_log.STRING (fnd_log.level_event,
1103: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1104: 'receiving processor, rc=['

Line 1102: fnd_log.STRING (fnd_log.level_event,

1098: );
1099:
1100: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1101: THEN
1102: fnd_log.STRING (fnd_log.level_event,
1103: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1104: 'receiving processor, rc=['
1105: || l_ret_code
1106: || '],message['

Line 1115: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)

1111: );
1112: END IF;
1113:
1114: IF l_ret_code <> 0 THEN
1115: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
1116: THEN
1117: FOR l_index IN 1 .. fnd_msg_pub.count_msg
1118: LOOP
1119: fnd_msg_pub.get (p_msg_index => l_index,

Line 1124: fnd_log.STRING (fnd_log.level_error,

1120: p_encoded => 'F',
1121: p_data => l_MESSAGE,
1122: p_msg_index_out => l_msg_index_out
1123: );
1124: fnd_log.STRING (fnd_log.level_error,
1125: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1126: 'receiving processor, error[' || l_MESSAGE || ']'
1127: );
1128: END LOOP;

Line 1149: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

1145: THEN
1146: NULL;
1147: ELSIF (l_ret_code = 1)
1148: THEN
1149: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1150: THEN
1151: fnd_log.STRING (fnd_log.level_event,
1152: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1153: 'fnd_trnasaction.synchronous TIMED OUT'

Line 1151: fnd_log.STRING (fnd_log.level_event,

1147: ELSIF (l_ret_code = 1)
1148: THEN
1149: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1150: THEN
1151: fnd_log.STRING (fnd_log.level_event,
1152: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1153: 'fnd_trnasaction.synchronous TIMED OUT'
1154: );
1155: END IF;

Line 1176: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

1172: x_return_status := fnd_api.g_ret_sts_error;
1173: END IF;
1174: ELSIF (l_Ret_code = 2)
1175: THEN
1176: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1177: THEN
1178: fnd_log.STRING
1179: (fnd_log.level_event,
1180: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',

Line 1178: fnd_log.STRING

1174: ELSIF (l_Ret_code = 2)
1175: THEN
1176: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1177: THEN
1178: fnd_log.STRING
1179: (fnd_log.level_event,
1180: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1181: 'fnd_trnasaction.synchronous: no concurrent manager available,groupid['
1182: || TO_CHAR (p_request_group_id)

Line 1179: (fnd_log.level_event,

1175: THEN
1176: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1177: THEN
1178: fnd_log.STRING
1179: (fnd_log.level_event,
1180: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1181: 'fnd_trnasaction.synchronous: no concurrent manager available,groupid['
1182: || TO_CHAR (p_request_group_id)
1183: || ']'

Line 1189: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1185: END IF;
1186:
1187: IF (check_group_id (p_request_group_id))
1188: THEN
1189: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1190: THEN
1191: fnd_log.STRING (fnd_log.level_statement,
1192: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1193: 'Adding FND message, groupid['

Line 1191: fnd_log.STRING (fnd_log.level_statement,

1187: IF (check_group_id (p_request_group_id))
1188: THEN
1189: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1190: THEN
1191: fnd_log.STRING (fnd_log.level_statement,
1192: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1193: 'Adding FND message, groupid['
1194: || TO_CHAR (p_request_group_id)
1195: || ']'

Line 1210: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)

1206: fnd_message.set_token ('PROGRAM', l_str2);
1207: fnd_message.set_token ('REQUEST', p_request_group_id);
1208: fnd_message.set_token ('REASON', l_str1);
1209:
1210: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
1211: THEN
1212: fnd_log.MESSAGE (fnd_log.level_error,
1213: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE');
1214: END IF;

Line 1212: fnd_log.MESSAGE (fnd_log.level_error,

1208: fnd_message.set_token ('REASON', l_str1);
1209:
1210: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
1211: THEN
1212: fnd_log.MESSAGE (fnd_log.level_error,
1213: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE');
1214: END IF;
1215:
1216: fnd_msg_pub.ADD;

Line 1221: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

1217: x_return_status := fnd_api.g_ret_sts_error;
1218: END IF;
1219: ELSIF (l_ret_code = 3 OR (l_outcome IN ('WARNING', 'ERROR')))
1220: THEN
1221: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1222: THEN
1223: fnd_log.STRING (fnd_log.level_event,
1224: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1225: 'fnd_synschronous:rc['

Line 1223: fnd_log.STRING (fnd_log.level_event,

1219: ELSIF (l_ret_code = 3 OR (l_outcome IN ('WARNING', 'ERROR')))
1220: THEN
1221: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1222: THEN
1223: fnd_log.STRING (fnd_log.level_event,
1224: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1225: 'fnd_synschronous:rc['
1226: || l_Ret_code
1227: || '],outcome['

Line 1361: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

1357: FND_MESSAGE.SET_NAME('CSD','CSD_AUTO_RCV_ERROR');
1358: FND_MESSAGE.SET_TOKEN('RCV_ERROR',l_Str1);
1359: FND_MSG_PUB.add;
1360:
1361: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1362: THEN
1363: fnd_log.STRING (fnd_log.level_event,
1364: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1365: 'fnd_trnasaction.synchronous:[' || l_str1 || ']'

Line 1363: fnd_log.STRING (fnd_log.level_event,

1359: FND_MSG_PUB.add;
1360:
1361: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1362: THEN
1363: fnd_log.STRING (fnd_log.level_event,
1364: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1365: 'fnd_trnasaction.synchronous:[' || l_str1 || ']'
1366: );
1367: END IF;

Line 1400: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1396: -- Standard call to get message count and IF count is get message info.
1397: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1398: p_data => x_msg_data);
1399:
1400: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1401: THEN
1402: fnd_log.STRING (fnd_log.level_procedure,
1403: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE.END',
1404: 'Leaving RCV_REQ_ONLINE'

Line 1402: fnd_log.STRING (fnd_log.level_procedure,

1398: p_data => x_msg_data);
1399:
1400: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1401: THEN
1402: fnd_log.STRING (fnd_log.level_procedure,
1403: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE.END',
1404: 'Leaving RCV_REQ_ONLINE'
1405: );
1406: END IF;

Line 1415: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)

1411: ROLLBACK TO sp_rcv_req_online;
1412: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1413: p_data => x_msg_data);
1414:
1415: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
1416: THEN
1417: fnd_log.STRING (fnd_log.level_error,
1418: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1419: 'EXC_ERROR[' || x_msg_data || ']'

Line 1417: fnd_log.STRING (fnd_log.level_error,

1413: p_data => x_msg_data);
1414:
1415: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
1416: THEN
1417: fnd_log.STRING (fnd_log.level_error,
1418: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1419: 'EXC_ERROR[' || x_msg_data || ']'
1420: );
1421: END IF;

Line 1429: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

1425: ROLLBACK TO sp_rcv_req_online;
1426: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1427: p_data => x_msg_data);
1428:
1429: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1430: THEN
1431: fnd_log.STRING (fnd_log.level_exception,
1432: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1433: 'EXC_UNEXPECTED_ERROR in RCV_REQ_ONLINE[' || x_msg_data || ']'

Line 1431: fnd_log.STRING (fnd_log.level_exception,

1427: p_data => x_msg_data);
1428:
1429: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1430: THEN
1431: fnd_log.STRING (fnd_log.level_exception,
1432: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1433: 'EXC_UNEXPECTED_ERROR in RCV_REQ_ONLINE[' || x_msg_data || ']'
1434: );
1435: END IF;

Line 1449: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

1445:
1446: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1447: p_data => x_msg_data);
1448:
1449: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1450: THEN
1451: fnd_log.STRING (fnd_log.level_unexpected,
1452: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1453: 'SQL Error MEssage in RCV_REQ_ONLINE[' || SQLERRM || ']'

Line 1451: fnd_log.STRING (fnd_log.level_unexpected,

1447: p_data => x_msg_data);
1448:
1449: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1450: THEN
1451: fnd_log.STRING (fnd_log.level_unexpected,
1452: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1453: 'SQL Error MEssage in RCV_REQ_ONLINE[' || SQLERRM || ']'
1454: );
1455: END IF;

Line 1494: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1490: FROM RCV_TRANSACTIONS_INTERFACE
1491: WHERE GROUP_ID = p_group_id;
1492: BEGIN
1493:
1494: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1495: THEN
1496: fnd_log.STRING (fnd_log.level_procedure,
1497: 'CSD.PLSQL.CSD_RECEIVE_PVT.DELETE_INTF_TBLS.BEGIN',
1498: 'Entered Delete_Intf_Tbls'

Line 1496: fnd_log.STRING (fnd_log.level_procedure,

1492: BEGIN
1493:
1494: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1495: THEN
1496: fnd_log.STRING (fnd_log.level_procedure,
1497: 'CSD.PLSQL.CSD_RECEIVE_PVT.DELETE_INTF_TBLS.BEGIN',
1498: 'Entered Delete_Intf_Tbls'
1499: );
1500: END IF;

Line 1559: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

1555: END;
1556: END LOOP;
1557:
1558: ----------------------------------------------Delete from headers table.
1559: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1560: THEN
1561: fnd_log.STRING (fnd_log.level_event,
1562: 'CSD.PLSQL.CSD_RECEIVE_PVT.DELETE_INTF_TBLS',
1563: 'Deleting from the headers table'

Line 1561: fnd_log.STRING (fnd_log.level_event,

1557:
1558: ----------------------------------------------Delete from headers table.
1559: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1560: THEN
1561: fnd_log.STRING (fnd_log.level_event,
1562: 'CSD.PLSQL.CSD_RECEIVE_PVT.DELETE_INTF_TBLS',
1563: 'Deleting from the headers table'
1564: );
1565: END IF;

Line 1579: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

1575: THEN
1576: RAISE fnd_api.g_exc_unexpected_error;
1577: END;
1578: ----------------------------------------------Delete from the detail txn records.
1579: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1580: THEN
1581: fnd_log.STRING (fnd_log.level_event,
1582: 'CSD.PLSQL.CSD_RECEIVE_PVT.DELETE_INTF_TBLS',
1583: 'Deleting from the detail table'

Line 1581: fnd_log.STRING (fnd_log.level_event,

1577: END;
1578: ----------------------------------------------Delete from the detail txn records.
1579: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1580: THEN
1581: fnd_log.STRING (fnd_log.level_event,
1582: 'CSD.PLSQL.CSD_RECEIVE_PVT.DELETE_INTF_TBLS',
1583: 'Deleting from the detail table'
1584: );
1585: END IF;

Line 1602: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1598:
1599:
1600: COMMIT;
1601:
1602: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1603: THEN
1604: fnd_log.STRING (fnd_log.level_procedure,
1605: 'CSD.PLSQL.CSD_RECEIVE_PVT.DELETE_INTF_TBLS.END',
1606: 'Leaving DELETE_INTF_TBLS'

Line 1604: fnd_log.STRING (fnd_log.level_procedure,

1600: COMMIT;
1601:
1602: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1603: THEN
1604: fnd_log.STRING (fnd_log.level_procedure,
1605: 'CSD.PLSQL.CSD_RECEIVE_PVT.DELETE_INTF_TBLS.END',
1606: 'Leaving DELETE_INTF_TBLS'
1607: );
1608: END IF;

Line 1614: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

1610: WHEN fnd_api.g_exc_unexpected_error
1611: THEN
1612: x_return_status := fnd_api.g_ret_sts_unexp_error;
1613: ROLLBACK ;
1614: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1615: THEN
1616: fnd_log.STRING (fnd_log.level_exception,
1617: 'CSD.PLSQL.CSD_RECEIVE_PVT.DELETE_INTF_TBLS',
1618: 'EXC_UNEXPECTED_ERROR in delete_intf_tbls'

Line 1616: fnd_log.STRING (fnd_log.level_exception,

1612: x_return_status := fnd_api.g_ret_sts_unexp_error;
1613: ROLLBACK ;
1614: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1615: THEN
1616: fnd_log.STRING (fnd_log.level_exception,
1617: 'CSD.PLSQL.CSD_RECEIVE_PVT.DELETE_INTF_TBLS',
1618: 'EXC_UNEXPECTED_ERROR in delete_intf_tbls'
1619: );
1620: END IF;

Line 1631: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

1627: THEN
1628: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1629: END IF;
1630:
1631: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1632: THEN
1633: fnd_log.STRING (fnd_log.level_unexpected,
1634: 'CSD.PLSQL.CSD_RECEIVE_PVT.DELETE_INTF_TBLS',
1635: 'SQL Message in delete_intf_tbls[' || SQLERRM || ']'

Line 1633: fnd_log.STRING (fnd_log.level_unexpected,

1629: END IF;
1630:
1631: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1632: THEN
1633: fnd_log.STRING (fnd_log.level_unexpected,
1634: 'CSD.PLSQL.CSD_RECEIVE_PVT.DELETE_INTF_TBLS',
1635: 'SQL Message in delete_intf_tbls[' || SQLERRM || ']'
1636: );
1637: END IF;

Line 1653: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1649: RETURN BOOLEAN
1650: IS
1651: l_rec_count NUMBER := 0;
1652: BEGIN
1653: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1654: THEN
1655: fnd_log.STRING (fnd_log.level_procedure,
1656: 'CSD.PLSQL.CSD_RECEIVE_PVT.CHECK_GROUP_ID.BEGIN',
1657: 'Entered check_group_id, groupid[' || p_group_id

Line 1655: fnd_log.STRING (fnd_log.level_procedure,

1651: l_rec_count NUMBER := 0;
1652: BEGIN
1653: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1654: THEN
1655: fnd_log.STRING (fnd_log.level_procedure,
1656: 'CSD.PLSQL.CSD_RECEIVE_PVT.CHECK_GROUP_ID.BEGIN',
1657: 'Entered check_group_id, groupid[' || p_group_id
1658: || ']'
1659: );

Line 1669: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1665: WHERE GROUP_ID = p_group_id;
1666:
1667: IF (l_rec_count = 0)
1668: THEN
1669: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1670: THEN
1671: fnd_log.STRING (fnd_log.level_procedure,
1672: 'CSD.PLSQL.CSD_RECEIVE_PVT.CHECK_GROUP_ID.END',
1673: 'returning false from check_group_id'

Line 1671: fnd_log.STRING (fnd_log.level_procedure,

1667: IF (l_rec_count = 0)
1668: THEN
1669: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1670: THEN
1671: fnd_log.STRING (fnd_log.level_procedure,
1672: 'CSD.PLSQL.CSD_RECEIVE_PVT.CHECK_GROUP_ID.END',
1673: 'returning false from check_group_id'
1674: );
1675: END IF;

Line 1679: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1675: END IF;
1676:
1677: RETURN (FALSE);
1678: ELSE
1679: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1680: THEN
1681: fnd_log.STRING (fnd_log.level_procedure,
1682: 'CSD.PLSQL.CSD_RECEIVE_PVT.CHECK_GROUP_ID.END',
1683: 'returning true from check_group_id'

Line 1681: fnd_log.STRING (fnd_log.level_procedure,

1677: RETURN (FALSE);
1678: ELSE
1679: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1680: THEN
1681: fnd_log.STRING (fnd_log.level_procedure,
1682: 'CSD.PLSQL.CSD_RECEIVE_PVT.CHECK_GROUP_ID.END',
1683: 'returning true from check_group_id'
1684: );
1685: END IF;

Line 1713: IF (p_level >= fnd_log.g_current_runtime_level)

1709: i INTEGER;
1710: BEGIN
1711: FOR i IN p_receive_tbl.FIRST .. p_receive_tbl.LAST
1712: LOOP
1713: IF (p_level >= fnd_log.g_current_runtime_level)
1714: THEN
1715: fnd_log.STRING (p_level, p_module,
1716: TO_CHAR (i)
1717: || ':'

Line 1715: fnd_log.STRING (p_level, p_module,

1711: FOR i IN p_receive_tbl.FIRST .. p_receive_tbl.LAST
1712: LOOP
1713: IF (p_level >= fnd_log.g_current_runtime_level)
1714: THEN
1715: fnd_log.STRING (p_level, p_module,
1716: TO_CHAR (i)
1717: || ':'
1718: || TO_CHAR (p_receive_tbl (i).customer_id)
1719: );

Line 1720: fnd_log.STRING (p_level, p_module,

1716: TO_CHAR (i)
1717: || ':'
1718: || TO_CHAR (p_receive_tbl (i).customer_id)
1719: );
1720: fnd_log.STRING (p_level, p_module,
1721: TO_CHAR (i)
1722: || ':'
1723: || TO_CHAR (p_receive_tbl (i).customer_site_id)
1724: );

Line 1725: fnd_log.STRING (p_level, p_module,

1721: TO_CHAR (i)
1722: || ':'
1723: || TO_CHAR (p_receive_tbl (i).customer_site_id)
1724: );
1725: fnd_log.STRING (p_level, p_module,
1726: TO_CHAR (i)
1727: || ':'
1728: || TO_CHAR (p_receive_tbl (i).employee_id)
1729: );

Line 1730: fnd_log.STRING (p_level,

1726: TO_CHAR (i)
1727: || ':'
1728: || TO_CHAR (p_receive_tbl (i).employee_id)
1729: );
1730: fnd_log.STRING (p_level,
1731: p_module,
1732: TO_CHAR (i)
1733: || ':'
1734: || TO_CHAR (p_receive_tbl (i).quantity)

Line 1736: fnd_log.STRING (p_level,

1732: TO_CHAR (i)
1733: || ':'
1734: || TO_CHAR (p_receive_tbl (i).quantity)
1735: );
1736: fnd_log.STRING (p_level,
1737: p_module,
1738: TO_CHAR (i) || ':' || p_receive_tbl (i).uom_code
1739: );
1740: fnd_log.STRING (p_level,

Line 1740: fnd_log.STRING (p_level,

1736: fnd_log.STRING (p_level,
1737: p_module,
1738: TO_CHAR (i) || ':' || p_receive_tbl (i).uom_code
1739: );
1740: fnd_log.STRING (p_level,
1741: p_module,
1742: TO_CHAR (i)
1743: || ':'
1744: || TO_CHAR (p_receive_tbl (i).inventory_item_id)

Line 1746: fnd_log.STRING (p_level,

1742: TO_CHAR (i)
1743: || ':'
1744: || TO_CHAR (p_receive_tbl (i).inventory_item_id)
1745: );
1746: fnd_log.STRING (p_level,
1747: p_module,
1748: TO_CHAR (i) || ':' || p_receive_tbl (i).item_revision
1749: );
1750: fnd_log.STRING (p_level,

Line 1750: fnd_log.STRING (p_level,

1746: fnd_log.STRING (p_level,
1747: p_module,
1748: TO_CHAR (i) || ':' || p_receive_tbl (i).item_revision
1749: );
1750: fnd_log.STRING (p_level,
1751: p_module,
1752: TO_CHAR (i)
1753: || ':'
1754: || TO_CHAR (p_receive_tbl (i).to_organization_id)

Line 1756: fnd_log.STRING (p_level,

1752: TO_CHAR (i)
1753: || ':'
1754: || TO_CHAR (p_receive_tbl (i).to_organization_id)
1755: );
1756: fnd_log.STRING (p_level,
1757: p_module,
1758: TO_CHAR (i)
1759: || ':'
1760: || p_receive_tbl (i).destination_type_code

Line 1762: fnd_log.STRING (p_level,

1758: TO_CHAR (i)
1759: || ':'
1760: || p_receive_tbl (i).destination_type_code
1761: );
1762: fnd_log.STRING (p_level,
1763: p_module,
1764: TO_CHAR (i) || ':' || p_receive_tbl (i).subinventory
1765: );
1766: fnd_log.STRING (p_level,

Line 1766: fnd_log.STRING (p_level,

1762: fnd_log.STRING (p_level,
1763: p_module,
1764: TO_CHAR (i) || ':' || p_receive_tbl (i).subinventory
1765: );
1766: fnd_log.STRING (p_level,
1767: p_module,
1768: TO_CHAR (i)
1769: || ':'
1770: || TO_CHAR (p_receive_tbl (i).locator_id)

Line 1772: fnd_log.STRING (p_level,

1768: TO_CHAR (i)
1769: || ':'
1770: || TO_CHAR (p_receive_tbl (i).locator_id)
1771: );
1772: fnd_log.STRING (p_level,
1773: p_module,
1774: TO_CHAR (i)
1775: || ':'
1776: || TO_CHAR (p_receive_tbl (i).deliver_to_location_id)

Line 1778: fnd_log.STRING (p_level,

1774: TO_CHAR (i)
1775: || ':'
1776: || TO_CHAR (p_receive_tbl (i).deliver_to_location_id)
1777: );
1778: fnd_log.STRING (p_level,
1779: p_module,
1780: TO_CHAR (i)
1781: || ':'
1782: || TO_CHAR (p_receive_tbl (i).requisition_number)

Line 1784: fnd_log.STRING (p_level,

1780: TO_CHAR (i)
1781: || ':'
1782: || TO_CHAR (p_receive_tbl (i).requisition_number)
1783: );
1784: fnd_log.STRING (p_level,
1785: p_module,
1786: TO_CHAR (i)
1787: || ':'
1788: || TO_CHAR (p_receive_tbl (i).order_header_id)

Line 1790: fnd_log.STRING (p_level,

1786: TO_CHAR (i)
1787: || ':'
1788: || TO_CHAR (p_receive_tbl (i).order_header_id)
1789: );
1790: fnd_log.STRING (p_level,
1791: p_module,
1792: TO_CHAR (i)
1793: || ':'
1794: || TO_CHAR (p_receive_tbl (i).order_line_id)

Line 1796: fnd_log.STRING (p_level,

1792: TO_CHAR (i)
1793: || ':'
1794: || TO_CHAR (p_receive_tbl (i).order_line_id)
1795: );
1796: fnd_log.STRING (p_level,
1797: p_module,
1798: TO_CHAR (i) || ':' || p_receive_tbl (i).order_number
1799: );
1800: fnd_log.STRING (p_level,

Line 1800: fnd_log.STRING (p_level,

1796: fnd_log.STRING (p_level,
1797: p_module,
1798: TO_CHAR (i) || ':' || p_receive_tbl (i).order_number
1799: );
1800: fnd_log.STRING (p_level,
1801: p_module,
1802: TO_CHAR (i) || ':' || p_receive_tbl (i).doc_number
1803: );
1804: fnd_log.STRING (p_level,

Line 1804: fnd_log.STRING (p_level,

1800: fnd_log.STRING (p_level,
1801: p_module,
1802: TO_CHAR (i) || ':' || p_receive_tbl (i).doc_number
1803: );
1804: fnd_log.STRING (p_level,
1805: p_module,
1806: TO_CHAR (i)
1807: || ':'
1808: || p_receive_tbl (i).internal_order_flag

Line 1810: fnd_log.STRING (p_level,

1806: TO_CHAR (i)
1807: || ':'
1808: || p_receive_tbl (i).internal_order_flag
1809: );
1810: fnd_log.STRING (p_level,
1811: p_module,
1812: TO_CHAR (i)
1813: || ':'
1814: || TO_CHAR (p_receive_tbl (i).from_organization_id)

Line 1816: fnd_log.STRING (p_level,

1812: TO_CHAR (i)
1813: || ':'
1814: || TO_CHAR (p_receive_tbl (i).from_organization_id)
1815: );
1816: fnd_log.STRING (p_level,
1817: p_module,
1818: TO_CHAR (i)
1819: || ':'
1820: || TO_CHAR (p_receive_tbl (i).expected_receipt_date)

Line 1822: fnd_log.STRING (p_level,

1818: TO_CHAR (i)
1819: || ':'
1820: || TO_CHAR (p_receive_tbl (i).expected_receipt_date)
1821: );
1822: fnd_log.STRING (p_level,
1823: p_module,
1824: TO_CHAR (i)
1825: || ':'
1826: || TO_CHAR (p_receive_tbl (i).transaction_date)

Line 1828: fnd_log.STRING (p_level,

1824: TO_CHAR (i)
1825: || ':'
1826: || TO_CHAR (p_receive_tbl (i).transaction_date)
1827: );
1828: fnd_log.STRING (p_level,
1829: p_module,
1830: TO_CHAR (i)
1831: || ':'
1832: || TO_CHAR (p_receive_tbl (i).ship_to_location_id)

Line 1858: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)

1854: p_data => l_msg,
1855: p_msg_index_out => l_index_out
1856: );
1857:
1858: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
1859: THEN
1860: fnd_log.STRING (fnd_log.level_error,
1861: 'CSD.PLSQL.CSD_RECEIVE_PVT.log_error_stack',
1862: 'error[' || l_msg || ']'

Line 1860: fnd_log.STRING (fnd_log.level_error,

1856: );
1857:
1858: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
1859: THEN
1860: fnd_log.STRING (fnd_log.level_error,
1861: 'CSD.PLSQL.CSD_RECEIVE_PVT.log_error_stack',
1862: 'error[' || l_msg || ']'
1863: );
1864: END IF;