APPS.CSD_MASS_RCV_PVT dependencies on FND_LOG

Line 96: l_debug_level := fnd_log.g_current_runtime_level;

92:
93: SAVEPOINT sp_mass_create_ro;
94:
95: l_return_status := fnd_api.g_ret_sts_success;
96: l_debug_level := fnd_log.g_current_runtime_level;
97: l_stmt_level := fnd_log.level_statement;
98: l_event_level := fnd_log.level_event;
99: c_draft_Status := 'D';
100:

Line 97: l_stmt_level := fnd_log.level_statement;

93: SAVEPOINT sp_mass_create_ro;
94:
95: l_return_status := fnd_api.g_ret_sts_success;
96: l_debug_level := fnd_log.g_current_runtime_level;
97: l_stmt_level := fnd_log.level_statement;
98: l_event_level := fnd_log.level_event;
99: c_draft_Status := 'D';
100:
101: IF (fnd_log.level_procedure >= l_debug_level)

Line 98: l_event_level := fnd_log.level_event;

94:
95: l_return_status := fnd_api.g_ret_sts_success;
96: l_debug_level := fnd_log.g_current_runtime_level;
97: l_stmt_level := fnd_log.level_statement;
98: l_event_level := fnd_log.level_event;
99: c_draft_Status := 'D';
100:
101: IF (fnd_log.level_procedure >= l_debug_level)
102: THEN

Line 101: IF (fnd_log.level_procedure >= l_debug_level)

97: l_stmt_level := fnd_log.level_statement;
98: l_event_level := fnd_log.level_event;
99: c_draft_Status := 'D';
100:
101: IF (fnd_log.level_procedure >= l_debug_level)
102: THEN
103: fnd_log.STRING (fnd_log.level_procedure,
104: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO.BEGIN',
105: '-------------Entered Mass_Create_RO----------------'

Line 103: fnd_log.STRING (fnd_log.level_procedure,

99: c_draft_Status := 'D';
100:
101: IF (fnd_log.level_procedure >= l_debug_level)
102: THEN
103: fnd_log.STRING (fnd_log.level_procedure,
104: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO.BEGIN',
105: '-------------Entered Mass_Create_RO----------------'
106: );
107: END IF;

Line 133: fnd_log.STRING (l_event_level,

129: -- Purge the errors from generic errors table
130: --Delete records from the CSD_GENRIC_ERRMSGS table.
131: IF (l_event_level >= l_debug_level)
132: THEN
133: fnd_log.STRING (l_event_level,
134: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',
135: '-----purging the previous processing errors----'
136: );
137: END IF;

Line 157: fnd_log.STRING

153:
154:
155: IF (l_event_level >= l_debug_level)
156: THEN
157: fnd_log.STRING
158: (l_event_level,
159: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',
160: '---after the call to CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS-----'
161: );

Line 183: fnd_log.STRING (l_event_level,

179: END IF;
180:
181: IF (l_event_level >= l_debug_level)
182: THEN
183: fnd_log.STRING (l_event_level,
184: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',
185: '-----------------Creating product transactions------------'
186: );
187: END IF;

Line 206: fnd_log.STRING (l_stmt_level,

202: END IF;
203:
204: IF (l_stmt_level >= l_debug_level)
205: THEN
206: fnd_log.STRING (l_stmt_level,
207: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',
208: 'Count of product transactions created=['
209: || l_prod_txn_tbl.COUNT
210: || ']'

Line 224: fnd_log.STRING (l_event_level,

220: l_count_sn_success := 0;
221:
222: IF (l_event_level >= l_debug_level)
223: THEN
224: fnd_log.STRING (l_event_level,
225: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',
226: '---------------Start processing for repair lineid=['
227: || p_repair_order_line_id
228: || ']------------'

Line 239: fnd_log.STRING (l_stmt_level,

235: l_count_sn := l_count_sn + 1;
236:
237: IF (l_stmt_level >= l_debug_level)
238: THEN
239: fnd_log.STRING (l_stmt_level,
240: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',
241: 'Serial Number=['
242: || l_repair_order_sn_rec.serial_number
243: || ']'

Line 245: fnd_log.STRING (l_stmt_level,

241: 'Serial Number=['
242: || l_repair_order_sn_rec.serial_number
243: || ']'
244: );
245: fnd_log.STRING (l_stmt_level,
246: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',
247: 'Instance id=['
248: || TO_CHAR
249: (l_repair_order_sn_rec.instance_id

Line 282: fnd_log.STRING (l_event_level,

278: IF (l_return_status = fnd_api.g_ret_sts_success)
279: THEN
280: IF (l_event_level >= l_debug_level)
281: THEN
282: fnd_log.STRING (l_event_level,
283: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',
284: 'Created the new repair order, repair line id=['
285: || l_new_repln_id
286: || ']'

Line 329: fnd_log.STRING (l_event_level,

325: END LOOP;
326:
327: IF (l_event_level >= l_debug_level)
328: THEN
329: fnd_log.STRING (l_event_level,
330: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',
331: 'No. of serial numbers processed successfully=['
332: || TO_CHAR (l_count_sn_success)
333: || ']'

Line 349: fnd_log.STRING (l_event_level,

345: l_count_sn := l_ro_qty;
346:
347: IF (l_event_level >= l_debug_level)
348: THEN
349: fnd_log.STRING (l_event_level,
350: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',
351: 'Num of blank sn being added= ['
352: || TO_CHAR (l_count_sn_blank)
353: || ']'

Line 424: fnd_log.STRING (l_event_level,

420: END IF;
421:
422: IF (l_event_level >= l_debug_level)
423: THEN
424: fnd_log.STRING (l_event_level,
425: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',
426: 'Created the new repair order, repair line id=['
427: || l_new_repln_id
428: || ']'

Line 447: fnd_log.STRING (l_event_level,

443:
444: --Delete record from CSD_REPAIRS for the input p_repair_order_line_id.
445: IF (l_event_level >= l_debug_level)
446: THEN
447: fnd_log.STRING (l_event_level,
448: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',
449: 'l_count_sn_success['
450: || l_count_sn_success
451: || ']l_count_sn['

Line 461: fnd_log.STRING (l_event_level,

457: IF (l_count_sn_success = l_count_sn)
458: THEN
459: IF (l_event_level >= l_debug_level)
460: THEN
461: fnd_log.STRING (l_event_level,
462: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',
463: 'deleting the draft repair order'
464: );
465: END IF;

Line 482: fnd_log.STRING (l_event_level,

478: -- Update the repair order quantity. This condition occurrs when
479: -- only some of the serial numbers are processed.
480: IF (l_event_level >= l_debug_level)
481: THEN
482: fnd_log.STRING (l_event_level,
483: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',
484: 'Updating the CSD_REPAIRS table quantity'
485: );
486: END IF;

Line 508: IF (fnd_log.level_procedure >= l_debug_level)

504: -- Standard call to get message count and IF count is get message info.
505: fnd_msg_pub.count_and_get (p_count => x_msg_count,
506: p_data => x_msg_data);
507:
508: IF (fnd_log.level_procedure >= l_debug_level)
509: THEN
510: fnd_log.STRING (fnd_log.level_procedure,
511: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO.END',
512: 'Leaving Mass_Create_RO'

Line 510: fnd_log.STRING (fnd_log.level_procedure,

506: p_data => x_msg_data);
507:
508: IF (fnd_log.level_procedure >= l_debug_level)
509: THEN
510: fnd_log.STRING (fnd_log.level_procedure,
511: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO.END',
512: 'Leaving Mass_Create_RO'
513: );
514: END IF;

Line 525: IF (fnd_log.level_error >= l_debug_level)

521: fnd_msg_pub.count_and_get (p_count => x_msg_count,
522: p_data => x_msg_data
523: );
524:
525: IF (fnd_log.level_error >= l_debug_level)
526: THEN
527: fnd_log.STRING (fnd_log.level_error,
528: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',
529: 'EXC_ERROR[' || x_msg_data || ']'

Line 527: fnd_log.STRING (fnd_log.level_error,

523: );
524:
525: IF (fnd_log.level_error >= l_debug_level)
526: THEN
527: fnd_log.STRING (fnd_log.level_error,
528: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',
529: 'EXC_ERROR[' || x_msg_data || ']'
530: );
531: END IF;

Line 540: IF (fnd_log.level_exception >= l_debug_level)

536: fnd_msg_pub.count_and_get (p_count => x_msg_count,
537: p_data => x_msg_data
538: );
539:
540: IF (fnd_log.level_exception >= l_debug_level)
541: THEN
542: fnd_log.STRING (fnd_log.level_exception,
543: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',
544: 'EXC_UNEXP_ERROR[' || x_msg_data || ']'

Line 542: fnd_log.STRING (fnd_log.level_exception,

538: );
539:
540: IF (fnd_log.level_exception >= l_debug_level)
541: THEN
542: fnd_log.STRING (fnd_log.level_exception,
543: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',
544: 'EXC_UNEXP_ERROR[' || x_msg_data || ']'
545: );
546: END IF;

Line 561: IF (fnd_log.level_unexpected >= l_debug_level)

557: fnd_msg_pub.count_and_get (p_count => x_msg_count,
558: p_data => x_msg_data
559: );
560:
561: IF (fnd_log.level_unexpected >= l_debug_level)
562: THEN
563: fnd_log.STRING (fnd_log.level_unexpected,
564: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',
565: 'SQL MEssage[' || SQLERRM || ']'

Line 563: fnd_log.STRING (fnd_log.level_unexpected,

559: );
560:
561: IF (fnd_log.level_unexpected >= l_debug_level)
562: THEN
563: fnd_log.STRING (fnd_log.level_unexpected,
564: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',
565: 'SQL MEssage[' || SQLERRM || ']'
566: );
567: END IF;

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

633: FROM csd_repairs
634: WHERE repair_line_id = p_repln_id;
635:
636: BEGIN
637: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
638: THEN
639: fnd_log.STRING (fnd_log.level_procedure,
640: 'CSD.PLSQL.CSD_MASS_RCV_PVT.PROCESS_RO.BEGIN',
641: 'Entering Process_RO'

Line 639: fnd_log.STRING (fnd_log.level_procedure,

635:
636: BEGIN
637: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
638: THEN
639: fnd_log.STRING (fnd_log.level_procedure,
640: 'CSD.PLSQL.CSD_MASS_RCV_PVT.PROCESS_RO.BEGIN',
641: 'Entering Process_RO'
642: );
643: END IF;

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

666: x_return_status := fnd_api.g_ret_sts_success;
667:
668: -- Get the repair order line details and populate the repair orde record
669: --
670: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
671: THEN
672: fnd_log.STRING (fnd_log.level_event,
673: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
674: '--------------Fetching repair order details for[='

Line 672: fnd_log.STRING (fnd_log.level_event,

668: -- Get the repair order line details and populate the repair orde record
669: --
670: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
671: THEN
672: fnd_log.STRING (fnd_log.level_event,
673: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
674: '--------------Fetching repair order details for[='
675: || p_repair_line_id
676: || ']---------------'

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

756:
757: CLOSE cur_repair_order;
758:
759: --Get the repair type ref and populate product txn table
760: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
761: THEN
762: fnd_log.STRING (fnd_log.level_event,
763: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
764: '------------------Fetching repair type ref for[='

Line 762: fnd_log.STRING (fnd_log.level_event,

758:
759: --Get the repair type ref and populate product txn table
760: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
761: THEN
762: fnd_log.STRING (fnd_log.level_event,
763: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
764: '------------------Fetching repair type ref for[='
765: || l_repair_order_rec.repair_type_id
766: || ']----------------'

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

800: FND_MSG_PUB.ADD;
801: RAISE FND_API.G_EXC_ERROR;
802: END IF;
803: */
804: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
805: THEN
806: fnd_log.STRING (fnd_log.level_event,
807: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
808: '------------------Calling csd_repairs_pvt.create_repair_order'

Line 806: fnd_log.STRING (fnd_log.level_event,

802: END IF;
803: */
804: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
805: THEN
806: fnd_log.STRING (fnd_log.level_event,
807: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
808: '------------------Calling csd_repairs_pvt.create_repair_order'
809: );
810: END IF;

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

830:
831: --Update Repair order line id in the record p_repair_Order_rec and prod txn table
832: l_repair_order_rec.repair_number := l_repair_number;
833:
834: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
835: THEN
836: fnd_log.STRING (fnd_log.level_statement,
837: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
838: '------------------New repair order number=[' || l_repair_number || ']'

Line 836: fnd_log.STRING (fnd_log.level_statement,

832: l_repair_order_rec.repair_number := l_repair_number;
833:
834: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
835: THEN
836: fnd_log.STRING (fnd_log.level_statement,
837: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
838: '------------------New repair order number=[' || l_repair_number || ']'
839: );
840: END IF;

Line 871: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level

867: p_prod_txn_tbl (i).repair_line_id := x_new_repln_id;
868: p_prod_txn_tbl (i).product_transaction_id := NULL;
869:
870: --l_product_Txn_Rec := p_prod_txn_tbl(i);
871: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level
872: )
873: THEN
874: fnd_log.STRING (fnd_log.level_statement,
875: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',

Line 874: fnd_log.STRING (fnd_log.level_statement,

870: --l_product_Txn_Rec := p_prod_txn_tbl(i);
871: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level
872: )
873: THEN
874: fnd_log.STRING (fnd_log.level_statement,
875: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
876: 'Calling Create_Product_Txn for['
877: || p_prod_txn_tbl (i).source_serial_number
878: || ']'

Line 900: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level

896: --Rollback to Save point Process_RO
897: RAISE fnd_api.g_exc_error;
898: END IF;
899:
900: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level
901: )
902: THEN
903: fnd_log.STRING (fnd_log.level_statement,
904: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',

Line 903: fnd_log.STRING (fnd_log.level_statement,

899:
900: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level
901: )
902: THEN
903: fnd_log.STRING (fnd_log.level_statement,
904: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
905: 'After Create_product_txn['
906: || l_repair_order_rec.serial_number
907: || ']'

Line 928: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

924: x_msg_count => x_msg_count,
925: x_msg_data => x_msg_data
926: );
927:
928: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
929: fnd_log.STRING (fnd_log.level_statement,
930: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
931: 'After Create_default_product_txn['
932: || l_repair_order_rec.serial_number|| ']');

Line 929: fnd_log.STRING (fnd_log.level_statement,

925: x_msg_data => x_msg_data
926: );
927:
928: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
929: fnd_log.STRING (fnd_log.level_statement,
930: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
931: 'After Create_default_product_txn['
932: || l_repair_order_rec.serial_number|| ']');
933: END IF;

Line 953: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

949: x_return_status => l_return_status,
950: x_msg_count => l_msg_count,
951: x_msg_data => l_msg_data
952: );
953: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
954: fnd_log.STRING (fnd_log.level_statement,
955: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
956: 'After CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO['
957: || x_new_repln_id || ']');

Line 954: fnd_log.STRING (fnd_log.level_statement,

950: x_msg_count => l_msg_count,
951: x_msg_data => l_msg_data
952: );
953: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
954: fnd_log.STRING (fnd_log.level_statement,
955: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
956: 'After CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO['
957: || x_new_repln_id || ']');
958: END IF;

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

962: END IF;
963:
964:
965: --Delete the processed serial number from CSD_MASS_RO_SN if exists.
966: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
967: THEN
968: fnd_log.STRING (fnd_log.level_statement,
969: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
970: 'Deleting CSD_MASS_RO_SN record sn=['

Line 968: fnd_log.STRING (fnd_log.level_statement,

964:
965: --Delete the processed serial number from CSD_MASS_RO_SN if exists.
966: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
967: THEN
968: fnd_log.STRING (fnd_log.level_statement,
969: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
970: 'Deleting CSD_MASS_RO_SN record sn=['
971: || NVL (l_repair_order_rec.serial_number, '')
972: || ']'

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

974: END IF;
975:
976: IF (NVL (l_repair_order_rec.serial_number, '-') <> '-')
977: THEN
978: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
979: THEN
980: fnd_log.STRING (fnd_log.level_statement,
981: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
982: 'Deleting CSD_MASS_RO_SN record '

Line 980: fnd_log.STRING (fnd_log.level_statement,

976: IF (NVL (l_repair_order_rec.serial_number, '-') <> '-')
977: THEN
978: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
979: THEN
980: fnd_log.STRING (fnd_log.level_statement,
981: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
982: 'Deleting CSD_MASS_RO_SN record '
983: );
984: END IF;

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

997: -- Standard call to get message count and IF count is get message info.
998: fnd_msg_pub.count_and_get (p_count => x_msg_count,
999: p_data => x_msg_data);
1000:
1001: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1002: THEN
1003: fnd_log.STRING (fnd_log.level_procedure,
1004: 'CSD.PLSQL.CSD_MASS_RCV_PVT.PROCESS_RO.END',
1005: 'Leaving Process_RO'

Line 1003: fnd_log.STRING (fnd_log.level_procedure,

999: p_data => x_msg_data);
1000:
1001: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1002: THEN
1003: fnd_log.STRING (fnd_log.level_procedure,
1004: 'CSD.PLSQL.CSD_MASS_RCV_PVT.PROCESS_RO.END',
1005: 'Leaving Process_RO'
1006: );
1007: END IF;

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

1013: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1014: p_data => x_msg_data
1015: );
1016:
1017: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
1018: THEN
1019: fnd_log.STRING (fnd_log.level_error,
1020: 'CSD.PLSQL.CSD_MASS_RCV_PVT.PROCESS_RO',
1021: 'EXC_ERROR[' || x_msg_data || ']'

Line 1019: fnd_log.STRING (fnd_log.level_error,

1015: );
1016:
1017: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
1018: THEN
1019: fnd_log.STRING (fnd_log.level_error,
1020: 'CSD.PLSQL.CSD_MASS_RCV_PVT.PROCESS_RO',
1021: 'EXC_ERROR[' || x_msg_data || ']'
1022: );
1023: END IF;

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

1028: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1029: p_data => x_msg_data
1030: );
1031:
1032: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1033: THEN
1034: fnd_log.STRING (fnd_log.level_exception,
1035: 'CSD.PLSQL.CSD_MASS_RCV_PVT.PROCESS_RO',
1036: 'EXC_UNEXP_ERROR[' || x_msg_data || ']'

Line 1034: fnd_log.STRING (fnd_log.level_exception,

1030: );
1031:
1032: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1033: THEN
1034: fnd_log.STRING (fnd_log.level_exception,
1035: 'CSD.PLSQL.CSD_MASS_RCV_PVT.PROCESS_RO',
1036: 'EXC_UNEXP_ERROR[' || x_msg_data || ']'
1037: );
1038: END IF;

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

1049: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1050: p_data => x_msg_data
1051: );
1052:
1053: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1054: THEN
1055: fnd_log.STRING (fnd_log.level_exception,
1056: 'CSD.PLSQL.CSD_MASS_RCV_PVT.PROCESS_RO',
1057: 'SQL MEssage[' || SQLERRM || ']'

Line 1055: fnd_log.STRING (fnd_log.level_exception,

1051: );
1052:
1053: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1054: THEN
1055: fnd_log.STRING (fnd_log.level_exception,
1056: 'CSD.PLSQL.CSD_MASS_RCV_PVT.PROCESS_RO',
1057: 'SQL MEssage[' || SQLERRM || ']'
1058: );
1059: END IF;

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

1206: l_estimate_detail_id NUMBER;
1207: l_booked_flag VARCHAR2 (1);
1208: l_transaction_type_id NUMBER;
1209: BEGIN
1210: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1211: THEN
1212: fnd_log.STRING
1213: (fnd_log.level_procedure,
1214: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN.BEGIN',

Line 1212: fnd_log.STRING

1208: l_transaction_type_id NUMBER;
1209: BEGIN
1210: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1211: THEN
1212: fnd_log.STRING
1213: (fnd_log.level_procedure,
1214: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN.BEGIN',
1215: 'Entered CREATE_PRODUCT_TXN'
1216: );

Line 1213: (fnd_log.level_procedure,

1209: BEGIN
1210: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1211: THEN
1212: fnd_log.STRING
1213: (fnd_log.level_procedure,
1214: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN.BEGIN',
1215: 'Entered CREATE_PRODUCT_TXN'
1216: );
1217: END IF;

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

1215: 'Entered CREATE_PRODUCT_TXN'
1216: );
1217: END IF;
1218:
1219: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1220: THEN
1221: fnd_log.STRING (fnd_log.level_statement,
1222: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1223: 'Processing Serial Number:=['

Line 1221: fnd_log.STRING (fnd_log.level_statement,

1217: END IF;
1218:
1219: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1220: THEN
1221: fnd_log.STRING (fnd_log.level_statement,
1222: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1223: 'Processing Serial Number:=['
1224: || p_product_txn_rec.source_serial_number
1225: || ']'

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

1251: --and Price_list_Id.
1252: --Validate the parameters, Repair_line_id, action_type, action_code and Prod_Txn_Status
1253:
1254: ---------------------------------------------------------------------------------1
1255: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1256: THEN
1257: fnd_log.STRING (fnd_log.level_statement,
1258: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1259: 'Before calling validate_product_txn_Rec'

Line 1257: fnd_log.STRING (fnd_log.level_statement,

1253:
1254: ---------------------------------------------------------------------------------1
1255: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1256: THEN
1257: fnd_log.STRING (fnd_log.level_statement,
1258: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1259: 'Before calling validate_product_txn_Rec'
1260: );
1261: END IF;

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

1289: END IF;
1290:
1291: CLOSE cur_ro_details;
1292:
1293: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1294: THEN
1295: fnd_log.STRING (fnd_log.level_statement,
1296: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1297: 'l_incident_id =' || l_incident_id

Line 1295: fnd_log.STRING (fnd_log.level_statement,

1291: CLOSE cur_ro_details;
1292:
1293: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1294: THEN
1295: fnd_log.STRING (fnd_log.level_statement,
1296: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1297: 'l_incident_id =' || l_incident_id
1298: );
1299: END IF;

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

1302: -- Get the business process id
1303: l_bus_process_id :=
1304: csd_process_util.get_bus_process (p_product_txn_rec.repair_line_id);
1305:
1306: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1307: THEN
1308: fnd_log.STRING (fnd_log.level_statement,
1309: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1310: 'l_bus_process_id =' || l_bus_process_id

Line 1308: fnd_log.STRING (fnd_log.level_statement,

1304: csd_process_util.get_bus_process (p_product_txn_rec.repair_line_id);
1305:
1306: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1307: THEN
1308: fnd_log.STRING (fnd_log.level_statement,
1309: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1310: 'l_bus_process_id =' || l_bus_process_id
1311: );
1312: END IF;

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

1317: fnd_api.g_miss_num
1318: THEN
1319: l_bus_process_id := p_product_txn_rec.business_process_id;
1320: ELSE
1321: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1322: THEN
1323: fnd_log.STRING
1324: (fnd_log.level_statement,
1325: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',

Line 1323: fnd_log.STRING

1319: l_bus_process_id := p_product_txn_rec.business_process_id;
1320: ELSE
1321: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1322: THEN
1323: fnd_log.STRING
1324: (fnd_log.level_statement,
1325: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1326: 'Business process Id does not exist '
1327: );

Line 1324: (fnd_log.level_statement,

1320: ELSE
1321: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1322: THEN
1323: fnd_log.STRING
1324: (fnd_log.level_statement,
1325: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1326: 'Business process Id does not exist '
1327: );
1328: END IF;

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

1342: INTO l_transaction_type_id;
1343:
1344: IF (cur_txn_type_id%NOTFOUND)
1345: THEN
1346: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1347: THEN
1348: fnd_log.STRING
1349: (fnd_log.level_statement,
1350: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',

Line 1348: fnd_log.STRING

1344: IF (cur_txn_type_id%NOTFOUND)
1345: THEN
1346: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1347: THEN
1348: fnd_log.STRING
1349: (fnd_log.level_statement,
1350: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1351: 'No Row found for the txn_billing_type_id='
1352: || TO_CHAR (p_product_txn_rec.txn_billing_type_id)

Line 1349: (fnd_log.level_statement,

1345: THEN
1346: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1347: THEN
1348: fnd_log.STRING
1349: (fnd_log.level_statement,
1350: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1351: 'No Row found for the txn_billing_type_id='
1352: || TO_CHAR (p_product_txn_rec.txn_billing_type_id)
1353: );

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

1361: CLOSE cur_txn_type_id;
1362:
1363: p_product_txn_rec.transaction_type_id := l_transaction_type_id;
1364:
1365: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1366: THEN
1367: fnd_log.STRING (fnd_log.level_statement,
1368: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1369: 'p_product_txn_rec.transaction_type_id :'

Line 1367: fnd_log.STRING (fnd_log.level_statement,

1363: p_product_txn_rec.transaction_type_id := l_transaction_type_id;
1364:
1365: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1366: THEN
1367: fnd_log.STRING (fnd_log.level_statement,
1368: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1369: 'p_product_txn_rec.transaction_type_id :'
1370: || TO_CHAR (p_product_txn_rec.transaction_type_id)
1371: );

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

1374:
1375: ---------------------------------------------------------------------------------4
1376: --If the contract id is not null, derive the coverage details from oks_ent_coverages_v, oks_ent_txn_groups_v for the
1377: --given contract id and business process id.
1378: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1379: THEN
1380: fnd_log.STRING (fnd_log.level_statement,
1381: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1382: 'contract_line_id =' || p_product_txn_rec.contract_id

Line 1380: fnd_log.STRING (fnd_log.level_statement,

1376: --If the contract id is not null, derive the coverage details from oks_ent_coverages_v, oks_ent_txn_groups_v for the
1377: --given contract id and business process id.
1378: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1379: THEN
1380: fnd_log.STRING (fnd_log.level_statement,
1381: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1382: 'contract_line_id =' || p_product_txn_rec.contract_id
1383: );
1384: END IF;

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

1402: p_product_txn_rec.contract_id
1403: );
1404: fnd_msg_pub.ADD;
1405:
1406: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1407: THEN
1408: fnd_log.STRING
1409: (fnd_log.level_statement,
1410: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',

Line 1408: fnd_log.STRING

1404: fnd_msg_pub.ADD;
1405:
1406: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1407: THEN
1408: fnd_log.STRING
1409: (fnd_log.level_statement,
1410: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1411: 'Contract Line Id missing'
1412: );

Line 1409: (fnd_log.level_statement,

1405:
1406: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1407: THEN
1408: fnd_log.STRING
1409: (fnd_log.level_statement,
1410: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1411: 'Contract Line Id missing'
1412: );
1413: END IF;

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

1464: THEN
1465: RAISE fnd_api.g_exc_error;
1466: END IF;
1467:
1468: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1469: THEN
1470: fnd_log.STRING (fnd_log.level_statement,
1471: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1472: 'l_line_type_id =' || l_line_type_id

Line 1470: fnd_log.STRING (fnd_log.level_statement,

1466: END IF;
1467:
1468: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1469: THEN
1470: fnd_log.STRING (fnd_log.level_statement,
1471: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1472: 'l_line_type_id =' || l_line_type_id
1473: );
1474: fnd_log.STRING (fnd_log.level_statement,

Line 1474: fnd_log.STRING (fnd_log.level_statement,

1470: fnd_log.STRING (fnd_log.level_statement,
1471: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1472: 'l_line_type_id =' || l_line_type_id
1473: );
1474: fnd_log.STRING (fnd_log.level_statement,
1475: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1476: 'l_line_category_code ='
1477: || l_line_category_code
1478: );

Line 1479: fnd_log.STRING (fnd_log.level_statement,

1475: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1476: 'l_line_category_code ='
1477: || l_line_category_code
1478: );
1479: fnd_log.STRING (fnd_log.level_statement,
1480: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1481: 'p_product_txn_rec.price_list_id ='
1482: || p_product_txn_rec.price_list_id
1483: );

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

1515: p_product_txn_rec.inventory_item_id
1516: );
1517: fnd_msg_pub.ADD;
1518:
1519: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1520: THEN
1521: fnd_log.STRING
1522: (fnd_log.level_statement,
1523: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',

Line 1521: fnd_log.STRING

1517: fnd_msg_pub.ADD;
1518:
1519: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1520: THEN
1521: fnd_log.STRING
1522: (fnd_log.level_statement,
1523: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1524: 'Serial Number missing for inventory_item_id='
1525: || p_product_txn_rec.inventory_item_id

Line 1522: (fnd_log.level_statement,

1518:
1519: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1520: THEN
1521: fnd_log.STRING
1522: (fnd_log.level_statement,
1523: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1524: 'Serial Number missing for inventory_item_id='
1525: || p_product_txn_rec.inventory_item_id
1526: );

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

1555: END IF;
1556:
1557: CLOSE cur_pricelist_details;
1558:
1559: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1560: THEN
1561: fnd_log.STRING (fnd_log.level_statement,
1562: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1563: 'l_curr_code =' || l_curr_code

Line 1561: fnd_log.STRING (fnd_log.level_statement,

1557: CLOSE cur_pricelist_details;
1558:
1559: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1560: THEN
1561: fnd_log.STRING (fnd_log.level_statement,
1562: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1563: 'l_curr_code =' || l_curr_code
1564: );
1565: END IF;

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

1570: l_add_to_same_order := p_add_to_order_flag;
1571: l_order_header_id := null;
1572:
1573: -- If the source is RMA then process differently
1574: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1575: THEN
1576: fnd_log.STRING (fnd_log.level_statement,
1577: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1578: 'orignal source ref=[' || l_orig_src_reference || ']'

Line 1576: fnd_log.STRING (fnd_log.level_statement,

1572:
1573: -- If the source is RMA then process differently
1574: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1575: THEN
1576: fnd_log.STRING (fnd_log.level_statement,
1577: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1578: 'orignal source ref=[' || l_orig_src_reference || ']'
1579: );
1580: fnd_log.STRING (fnd_log.level_statement,

Line 1580: fnd_log.STRING (fnd_log.level_statement,

1576: fnd_log.STRING (fnd_log.level_statement,
1577: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1578: 'orignal source ref=[' || l_orig_src_reference || ']'
1579: );
1580: fnd_log.STRING (fnd_log.level_statement,
1581: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1582: 'l_add_to_same_order=[' || l_add_to_same_order || ']'
1583: );
1584: END IF;

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

1591:
1592: FETCH cur_order_header
1593: INTO l_order_header_id;
1594:
1595: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1596: THEN
1597: IF (cur_order_header%NOTFOUND)
1598: THEN
1599: fnd_log.STRING

Line 1599: fnd_log.STRING

1595: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1596: THEN
1597: IF (cur_order_header%NOTFOUND)
1598: THEN
1599: fnd_log.STRING
1600: (fnd_log.level_statement,
1601: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1602: 'Getting max order header id failed '
1603: );

Line 1600: (fnd_log.level_statement,

1596: THEN
1597: IF (cur_order_header%NOTFOUND)
1598: THEN
1599: fnd_log.STRING
1600: (fnd_log.level_statement,
1601: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1602: 'Getting max order header id failed '
1603: );
1604: ELSE

Line 1605: fnd_log.STRING

1601: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1602: 'Getting max order header id failed '
1603: );
1604: ELSE
1605: fnd_log.STRING
1606: (fnd_log.level_statement,
1607: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1608: 'Order header id[' || l_order_header_id || ']'
1609: );

Line 1606: (fnd_log.level_statement,

1602: 'Getting max order header id failed '
1603: );
1604: ELSE
1605: fnd_log.STRING
1606: (fnd_log.level_statement,
1607: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1608: 'Order header id[' || l_order_header_id || ']'
1609: );
1610: END IF;

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

1638: p_product_txn_rec.line_type_id := l_line_type_id;
1639: p_product_txn_rec.currency_code := l_curr_code;
1640: p_product_txn_rec.line_category_code := l_line_category_code;
1641:
1642: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1643: THEN
1644: fnd_log.STRING (fnd_log.level_statement,
1645: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1646: 'Convert product txn rec to charges rec'

Line 1644: fnd_log.STRING (fnd_log.level_statement,

1640: p_product_txn_rec.line_category_code := l_line_category_code;
1641:
1642: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1643: THEN
1644: fnd_log.STRING (fnd_log.level_statement,
1645: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1646: 'Convert product txn rec to charges rec'
1647: );
1648: END IF;

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

1660: );
1661:
1662: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1663: THEN
1664: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1665: THEN
1666: fnd_log.STRING (fnd_log.level_statement,
1667: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1668: 'sql error[' || SQLERRM || ']'

Line 1666: fnd_log.STRING (fnd_log.level_statement,

1662: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1663: THEN
1664: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1665: THEN
1666: fnd_log.STRING (fnd_log.level_statement,
1667: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1668: 'sql error[' || SQLERRM || ']'
1669: );
1670: END IF;

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

1677:
1678: ---------------------------------------------------------------------------------11
1679: --Call CSD_PROCESS_PVT.PROCESS_CHARGE_LINES with 'CREATE' as input parameter to create charge line.
1680: --Update estimate_Detail_id in the Product_Txn_rec.
1681: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1682: THEN
1683: fnd_log.STRING
1684: (fnd_log.level_statement,
1685: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',

Line 1683: fnd_log.STRING

1679: --Call CSD_PROCESS_PVT.PROCESS_CHARGE_LINES with 'CREATE' as input parameter to create charge line.
1680: --Update estimate_Detail_id in the Product_Txn_rec.
1681: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1682: THEN
1683: fnd_log.STRING
1684: (fnd_log.level_statement,
1685: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1686: 'Calling process_charge_lines to create charge lines '
1687: );

Line 1684: (fnd_log.level_statement,

1680: --Update estimate_Detail_id in the Product_Txn_rec.
1681: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1682: THEN
1683: fnd_log.STRING
1684: (fnd_log.level_statement,
1685: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1686: 'Calling process_charge_lines to create charge lines '
1687: );
1688: END IF;

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

1701: );
1702:
1703: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1704: THEN
1705: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1706: THEN
1707: fnd_log.STRING (fnd_log.level_statement,
1708: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1709: 'Error[' || SUBSTR (x_msg_data, 1, 200) || ']'

Line 1707: fnd_log.STRING (fnd_log.level_statement,

1703: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1704: THEN
1705: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1706: THEN
1707: fnd_log.STRING (fnd_log.level_statement,
1708: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1709: 'Error[' || SUBSTR (x_msg_data, 1, 200) || ']'
1710: );
1711: END IF;

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

1712:
1713: RAISE fnd_api.g_exc_error;
1714: END IF;
1715:
1716: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1717: THEN
1718: fnd_log.STRING (fnd_log.level_statement,
1719: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1720: 'Created charge line[' || l_estimate_detail_id || ']'

Line 1718: fnd_log.STRING (fnd_log.level_statement,

1714: END IF;
1715:
1716: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1717: THEN
1718: fnd_log.STRING (fnd_log.level_statement,
1719: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1720: 'Created charge line[' || l_estimate_detail_id || ']'
1721: );
1722: END IF;

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

1723:
1724: ---------------------------------------------------------------------------------12
1725: --Call CSD_PRODUCT_TRANSACTIONS_PKG.INSERT_ROW to add a product transaction record.
1726: --Update product_transaction_id in the Product_Txn_Rec.
1727: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1728: THEN
1729: fnd_log.STRING (fnd_log.level_statement,
1730: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1731: 'Creating product txn rec ..'

Line 1729: fnd_log.STRING (fnd_log.level_statement,

1725: --Call CSD_PRODUCT_TRANSACTIONS_PKG.INSERT_ROW to add a product transaction record.
1726: --Update product_transaction_id in the Product_Txn_Rec.
1727: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1728: THEN
1729: fnd_log.STRING (fnd_log.level_statement,
1730: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1731: 'Creating product txn rec ..'
1732: );
1733: END IF;

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

1792: THEN
1793: RAISE fnd_api.g_exc_error;
1794: END IF;
1795:
1796: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1797: THEN
1798: fnd_log.STRING (fnd_log.level_statement,
1799: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1800: 'PRODUCT_TRANSACTION_ID='

Line 1798: fnd_log.STRING (fnd_log.level_statement,

1794: END IF;
1795:
1796: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1797: THEN
1798: fnd_log.STRING (fnd_log.level_statement,
1799: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1800: 'PRODUCT_TRANSACTION_ID='
1801: || p_product_txn_rec.product_transaction_id
1802: );

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

1813: --raise exception, else proceed to next step.
1814: ------------------------------------------------------------------------------------
1815: IF (p_product_txn_rec.interface_to_om_flag = 'Y')
1816: THEN
1817: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1818: THEN
1819: fnd_log.STRING
1820: (fnd_log.level_statement,
1821: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',

Line 1819: fnd_log.STRING

1815: IF (p_product_txn_rec.interface_to_om_flag = 'Y')
1816: THEN
1817: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1818: THEN
1819: fnd_log.STRING
1820: (fnd_log.level_statement,
1821: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1822: 'Call CSD_PROCESS_PVT.APPLY_CONTRACT to apply contract '
1823: );

Line 1820: (fnd_log.level_statement,

1816: THEN
1817: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1818: THEN
1819: fnd_log.STRING
1820: (fnd_log.level_statement,
1821: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1822: 'Call CSD_PROCESS_PVT.APPLY_CONTRACT to apply contract '
1823: );
1824: END IF;

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

1835: );
1836:
1837: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1838: THEN
1839: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1840: THEN
1841: fnd_log.STRING
1842: (fnd_log.level_statement,
1843: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',

Line 1841: fnd_log.STRING

1837: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1838: THEN
1839: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1840: THEN
1841: fnd_log.STRING
1842: (fnd_log.level_statement,
1843: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1844: 'apply_contract failed['
1845: || SUBSTR (x_msg_data, 1, 200)

Line 1842: (fnd_log.level_statement,

1838: THEN
1839: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1840: THEN
1841: fnd_log.STRING
1842: (fnd_log.level_statement,
1843: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1844: 'apply_contract failed['
1845: || SUBSTR (x_msg_data, 1, 200)
1846: || ']'

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

1870: l_prod_txn_status := 'SUBMITTED';
1871: l_booked_flag := 'N';
1872: END IF;
1873:
1874: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1875: THEN
1876: fnd_log.STRING (fnd_log.level_statement,
1877: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1878: 'calling CSD_PROCESS_PVT.PROCESS_SALES_ORDER to interface '

Line 1876: fnd_log.STRING (fnd_log.level_statement,

1872: END IF;
1873:
1874: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1875: THEN
1876: fnd_log.STRING (fnd_log.level_statement,
1877: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1878: 'calling CSD_PROCESS_PVT.PROCESS_SALES_ORDER to interface '
1879: || 'Charge line without booking'
1880: );

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

1898: x_msg_count => x_msg_count,
1899: x_msg_data => x_msg_data );
1900:
1901: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1902: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1903: THEN
1904: fnd_log.STRING (fnd_log.level_statement,
1905: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1906: 'process_sales_order failed['||x_msg_data||']');

Line 1904: fnd_log.STRING (fnd_log.level_statement,

1900:
1901: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1902: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1903: THEN
1904: fnd_log.STRING (fnd_log.level_statement,
1905: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1906: 'process_sales_order failed['||x_msg_data||']');
1907: END IF;
1908: RAISE FND_API.G_EXC_ERROR;

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

1912: p_order_rec => l_order_rec,
1913: x_booked_flag => l_booked_flag
1914: );
1915:
1916: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1917: THEN
1918: fnd_log.STRING (fnd_log.level_statement,
1919: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1920: 'Booking charge line with CSD_PROCESS_PVT.PROCESS_SALES_ORDER API');

Line 1918: fnd_log.STRING (fnd_log.level_statement,

1914: );
1915:
1916: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1917: THEN
1918: fnd_log.STRING (fnd_log.level_statement,
1919: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1920: 'Booking charge line with CSD_PROCESS_PVT.PROCESS_SALES_ORDER API');
1921: END IF;
1922:

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

1933: x_msg_count => x_msg_count,
1934: x_msg_data => x_msg_data );
1935:
1936: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1937: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1938: THEN
1939: fnd_log.STRING (fnd_log.level_statement,
1940: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1941: 'process_sales_order failed ['||x_msg_Data||']');

Line 1939: fnd_log.STRING (fnd_log.level_statement,

1935:
1936: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1937: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1938: THEN
1939: fnd_log.STRING (fnd_log.level_statement,
1940: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1941: 'process_sales_order failed ['||x_msg_Data||']');
1942: END IF;
1943: RAISE FND_API.G_EXC_ERROR;

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

1961:
1962: --] 3308535
1963: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1964: THEN
1965: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1966: THEN
1967: fnd_log.STRING
1968: (fnd_log.level_statement,
1969: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',

Line 1967: fnd_log.STRING

1963: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1964: THEN
1965: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1966: THEN
1967: fnd_log.STRING
1968: (fnd_log.level_statement,
1969: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1970: 'submit_Order failed ['
1971: || SUBSTR (x_msg_data, 1, 200)

Line 1968: (fnd_log.level_statement,

1964: THEN
1965: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1966: THEN
1967: fnd_log.STRING
1968: (fnd_log.level_statement,
1969: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1970: 'submit_Order failed ['
1971: || SUBSTR (x_msg_data, 1, 200)
1972: || ']'

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

1979: l_ro_txn_status := 'CHARGE_ENTERED';
1980: l_prod_txn_status := 'ENTERED';
1981: END IF;
1982:
1983: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1984: THEN
1985: fnd_log.STRING (fnd_log.level_statement,
1986: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1987: 'Updating repair status[' || l_ro_txn_status || ']'

Line 1985: fnd_log.STRING (fnd_log.level_statement,

1981: END IF;
1982:
1983: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1984: THEN
1985: fnd_log.STRING (fnd_log.level_statement,
1986: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1987: 'Updating repair status[' || l_ro_txn_status || ']'
1988: );
1989: END IF;

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

2001: fnd_msg_pub.ADD;
2002: RAISE fnd_api.g_exc_error;
2003: END IF;
2004:
2005: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2006: THEN
2007: fnd_log.STRING (fnd_log.level_statement,
2008: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
2009: 'Updating prod txn status[' || l_prod_txn_status

Line 2007: fnd_log.STRING (fnd_log.level_statement,

2003: END IF;
2004:
2005: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2006: THEN
2007: fnd_log.STRING (fnd_log.level_statement,
2008: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
2009: 'Updating prod txn status[' || l_prod_txn_status
2010: || ']'
2011: );

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

2038: -- Standard call to get message count and IF count is get message info.
2039: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2040: p_data => x_msg_data);
2041:
2042: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2043: THEN
2044: fnd_log.STRING (fnd_log.level_procedure,
2045: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN.END',
2046: 'Leaving CREATE_PRODUCT_TXN'

Line 2044: fnd_log.STRING (fnd_log.level_procedure,

2040: p_data => x_msg_data);
2041:
2042: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2043: THEN
2044: fnd_log.STRING (fnd_log.level_procedure,
2045: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN.END',
2046: 'Leaving CREATE_PRODUCT_TXN'
2047: );
2048: END IF;

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

2055: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2056: p_data => x_msg_data
2057: );
2058:
2059: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
2060: THEN
2061: fnd_log.STRING (fnd_log.level_error,
2062: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
2063: 'EXC_ERROR[' || x_msg_data || ']'

Line 2061: fnd_log.STRING (fnd_log.level_error,

2057: );
2058:
2059: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
2060: THEN
2061: fnd_log.STRING (fnd_log.level_error,
2062: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
2063: 'EXC_ERROR[' || x_msg_data || ']'
2064: );
2065: END IF;

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

2070: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2071: p_data => x_msg_data
2072: );
2073:
2074: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2075: THEN
2076: fnd_log.STRING (fnd_log.level_exception,
2077: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
2078: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']'

Line 2076: fnd_log.STRING (fnd_log.level_exception,

2072: );
2073:
2074: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2075: THEN
2076: fnd_log.STRING (fnd_log.level_exception,
2077: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
2078: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']'
2079: );
2080: END IF;

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

2091: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2092: p_data => x_msg_data
2093: );
2094:
2095: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
2096: THEN
2097: fnd_log.STRING (fnd_log.level_unexpected,
2098: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
2099: 'SQL Error[' || SQLERRM || ']'

Line 2097: fnd_log.STRING (fnd_log.level_unexpected,

2093: );
2094:
2095: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
2096: THEN
2097: fnd_log.STRING (fnd_log.level_unexpected,
2098: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
2099: 'SQL Error[' || SQLERRM || ']'
2100: );
2101: END IF;

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

2141: l_txn_rec csi_datastructures_pub.transaction_rec;
2142: -- := csd_process_util.ui_transaction_rec;
2143: l_party_site_id NUMBER;
2144: BEGIN
2145: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2146: THEN
2147: fnd_log.STRING
2148: (fnd_log.level_procedure,
2149: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE.BEGIN',

Line 2147: fnd_log.STRING

2143: l_party_site_id NUMBER;
2144: BEGIN
2145: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2146: THEN
2147: fnd_log.STRING
2148: (fnd_log.level_procedure,
2149: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE.BEGIN',
2150: 'Entered CREATE_ITEM_INSTANCE'
2151: );

Line 2148: (fnd_log.level_procedure,

2144: BEGIN
2145: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2146: THEN
2147: fnd_log.STRING
2148: (fnd_log.level_procedure,
2149: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE.BEGIN',
2150: 'Entered CREATE_ITEM_INSTANCE'
2151: );
2152: END IF;

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

2173:
2174: -- Initialize API return status to success
2175: x_return_status := fnd_api.g_ret_sts_success;
2176:
2177: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2178: THEN
2179: fnd_log.STRING (fnd_log.level_statement,
2180: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2181: 'Finding party_site_Id for party_site_use_Id=['

Line 2179: fnd_log.STRING (fnd_log.level_statement,

2175: x_return_status := fnd_api.g_ret_sts_success;
2176:
2177: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2178: THEN
2179: fnd_log.STRING (fnd_log.level_statement,
2180: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2181: 'Finding party_site_Id for party_site_use_Id=['
2182: || px_instance_rec.party_site_use_id
2183: || ']'

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

2200: --px_instance_rec.bill_to_site_use_id);
2201: RAISE fnd_api.g_exc_error;
2202: END;
2203:
2204: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2205: THEN
2206: fnd_log.STRING (fnd_log.level_statement,
2207: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2208: 'party_site_Id=[' || l_party_site_id || ']'

Line 2206: fnd_log.STRING (fnd_log.level_statement,

2202: END;
2203:
2204: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2205: THEN
2206: fnd_log.STRING (fnd_log.level_statement,
2207: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2208: 'party_site_Id=[' || l_party_site_id || ']'
2209: );
2210: END IF;

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

2264: l_txn_rec.message_id := NULL;
2265: l_txn_rec.object_version_number := NULL;
2266: l_txn_rec.split_reason_code := '';
2267:
2268: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2269: THEN
2270: fnd_log.STRING (fnd_log.level_statement,
2271: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2272: 'Calling csi_item_instance_pub.create_item_instance'

Line 2270: fnd_log.STRING (fnd_log.level_statement,

2266: l_txn_rec.split_reason_code := '';
2267:
2268: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2269: THEN
2270: fnd_log.STRING (fnd_log.level_statement,
2271: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2272: 'Calling csi_item_instance_pub.create_item_instance'
2273: );
2274: END IF;

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

2310: -- Standard call to get message count and if count is 1, get message info.
2311: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2312: p_data => x_msg_data);
2313:
2314: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2315: THEN
2316: fnd_log.STRING
2317: (fnd_log.level_procedure,
2318: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE.END',

Line 2316: fnd_log.STRING

2312: p_data => x_msg_data);
2313:
2314: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2315: THEN
2316: fnd_log.STRING
2317: (fnd_log.level_procedure,
2318: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE.END',
2319: 'Leaving CREATE_ITEM_INSTANCE'
2320: );

Line 2317: (fnd_log.level_procedure,

2313:
2314: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2315: THEN
2316: fnd_log.STRING
2317: (fnd_log.level_procedure,
2318: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE.END',
2319: 'Leaving CREATE_ITEM_INSTANCE'
2320: );
2321: END IF;

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

2327: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2328: p_data => x_msg_data
2329: );
2330:
2331: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
2332: THEN
2333: fnd_log.STRING
2334: (fnd_log.level_error,
2335: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',

Line 2333: fnd_log.STRING

2329: );
2330:
2331: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
2332: THEN
2333: fnd_log.STRING
2334: (fnd_log.level_error,
2335: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2336: 'EXC_ERROR[' || x_msg_data || ']'
2337: );

Line 2334: (fnd_log.level_error,

2330:
2331: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
2332: THEN
2333: fnd_log.STRING
2334: (fnd_log.level_error,
2335: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2336: 'EXC_ERROR[' || x_msg_data || ']'
2337: );
2338: END IF;

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

2343: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2344: p_data => x_msg_data
2345: );
2346:
2347: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2348: THEN
2349: fnd_log.STRING
2350: (fnd_log.level_exception,
2351: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',

Line 2349: fnd_log.STRING

2345: );
2346:
2347: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2348: THEN
2349: fnd_log.STRING
2350: (fnd_log.level_exception,
2351: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2352: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']'
2353: );

Line 2350: (fnd_log.level_exception,

2346:
2347: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2348: THEN
2349: fnd_log.STRING
2350: (fnd_log.level_exception,
2351: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2352: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']'
2353: );
2354: END IF;

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

2365: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2366: p_data => x_msg_data
2367: );
2368:
2369: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
2370: THEN
2371: fnd_log.STRING
2372: (fnd_log.level_unexpected,
2373: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',

Line 2371: fnd_log.STRING

2367: );
2368:
2369: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
2370: THEN
2371: fnd_log.STRING
2372: (fnd_log.level_unexpected,
2373: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2374: 'SQL MEssage[' || SQLERRM || ']'
2375: );

Line 2372: (fnd_log.level_unexpected,

2368:
2369: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
2370: THEN
2371: fnd_log.STRING
2372: (fnd_log.level_unexpected,
2373: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2374: 'SQL MEssage[' || SQLERRM || ']'
2375: );
2376: END IF;

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

2386: l_api_name CONSTANT VARCHAR2 (30) := 'PROCESS_RO';
2387: l_return_status VARCHAR2 (1) ;
2388: l_check VARCHAR2 (1);
2389: BEGIN
2390: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2391: THEN
2392: fnd_log.STRING
2393: (fnd_log.level_procedure,
2394: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN',

Line 2392: fnd_log.STRING

2388: l_check VARCHAR2 (1);
2389: BEGIN
2390: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2391: THEN
2392: fnd_log.STRING
2393: (fnd_log.level_procedure,
2394: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN',
2395: 'Entered Validate_Product_Txn_Rec'
2396: );

Line 2393: (fnd_log.level_procedure,

2389: BEGIN
2390: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2391: THEN
2392: fnd_log.STRING
2393: (fnd_log.level_procedure,
2394: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN',
2395: 'Entered Validate_Product_Txn_Rec'
2396: );
2397: END IF;

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

2395: 'Entered Validate_Product_Txn_Rec'
2396: );
2397: END IF;
2398:
2399: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2400: THEN
2401: fnd_log.STRING
2402: (fnd_log.level_statement,
2403: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN',

Line 2401: fnd_log.STRING

2397: END IF;
2398:
2399: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2400: THEN
2401: fnd_log.STRING
2402: (fnd_log.level_statement,
2403: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN',
2404: 'Checking mandatory parameters'
2405: );

Line 2402: (fnd_log.level_statement,

2398:
2399: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2400: THEN
2401: fnd_log.STRING
2402: (fnd_log.level_statement,
2403: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN',
2404: 'Checking mandatory parameters'
2405: );
2406: END IF;

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

2454: p_param_name => 'PRICE_LIST_ID',
2455: p_api_name => l_api_name
2456: );
2457:
2458: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2459: THEN
2460: fnd_log.STRING
2461: (fnd_log.level_statement,
2462: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',

Line 2460: fnd_log.STRING

2456: );
2457:
2458: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2459: THEN
2460: fnd_log.STRING
2461: (fnd_log.level_statement,
2462: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2463: 'Validate repair line id'
2464: );

Line 2461: (fnd_log.level_statement,

2457:
2458: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2459: THEN
2460: fnd_log.STRING
2461: (fnd_log.level_statement,
2462: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2463: 'Validate repair line id'
2464: );
2465: END IF;

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

2471: THEN
2472: RAISE fnd_api.g_exc_error;
2473: END IF;
2474:
2475: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2476: THEN
2477: fnd_log.STRING
2478: (fnd_log.level_statement,
2479: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',

Line 2477: fnd_log.STRING

2473: END IF;
2474:
2475: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2476: THEN
2477: fnd_log.STRING
2478: (fnd_log.level_statement,
2479: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2480: 'Validate action type'
2481: );

Line 2478: (fnd_log.level_statement,

2474:
2475: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2476: THEN
2477: fnd_log.STRING
2478: (fnd_log.level_statement,
2479: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2480: 'Validate action type'
2481: );
2482: END IF;

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

2488: THEN
2489: RAISE fnd_api.g_exc_error;
2490: END IF;
2491:
2492: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2493: THEN
2494: fnd_log.STRING
2495: (fnd_log.level_statement,
2496: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',

Line 2494: fnd_log.STRING

2490: END IF;
2491:
2492: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2493: THEN
2494: fnd_log.STRING
2495: (fnd_log.level_statement,
2496: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2497: 'Validate action code'
2498: );

Line 2495: (fnd_log.level_statement,

2491:
2492: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2493: THEN
2494: fnd_log.STRING
2495: (fnd_log.level_statement,
2496: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2497: 'Validate action code'
2498: );
2499: END IF;

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

2505: THEN
2506: RAISE fnd_api.g_exc_error;
2507: END IF;
2508:
2509: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2510: THEN
2511: fnd_log.STRING
2512: (fnd_log.level_statement,
2513: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',

Line 2511: fnd_log.STRING

2507: END IF;
2508:
2509: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2510: THEN
2511: fnd_log.STRING
2512: (fnd_log.level_statement,
2513: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2514: 'Validate product txn qty'
2515: );

Line 2512: (fnd_log.level_statement,

2508:
2509: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2510: THEN
2511: fnd_log.STRING
2512: (fnd_log.level_statement,
2513: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2514: 'Validate product txn qty'
2515: );
2516: fnd_log.STRING

Line 2516: fnd_log.STRING

2512: (fnd_log.level_statement,
2513: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2514: 'Validate product txn qty'
2515: );
2516: fnd_log.STRING
2517: (fnd_log.level_statement,
2518: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN',
2519: 'p_product_txn_rec.quantity =' || p_product_txn_rec.quantity
2520: );

Line 2517: (fnd_log.level_statement,

2513: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2514: 'Validate product txn qty'
2515: );
2516: fnd_log.STRING
2517: (fnd_log.level_statement,
2518: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN',
2519: 'p_product_txn_rec.quantity =' || p_product_txn_rec.quantity
2520: );
2521: END IF;

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

2532: );
2533:
2534: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
2535: THEN
2536: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2537: THEN
2538: fnd_log.STRING
2539: (fnd_log.level_statement,
2540: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',

Line 2538: fnd_log.STRING

2534: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
2535: THEN
2536: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2537: THEN
2538: fnd_log.STRING
2539: (fnd_log.level_statement,
2540: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2541: 'Validate_Quantity failed '
2542: );

Line 2539: (fnd_log.level_statement,

2535: THEN
2536: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2537: THEN
2538: fnd_log.STRING
2539: (fnd_log.level_statement,
2540: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2541: 'Validate_Quantity failed '
2542: );
2543: END IF;

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

2545: RAISE fnd_api.g_exc_error;
2546: END IF;
2547: END IF;
2548:
2549: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2550: THEN
2551: fnd_log.STRING
2552: (fnd_log.level_statement,
2553: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',

Line 2551: fnd_log.STRING

2547: END IF;
2548:
2549: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2550: THEN
2551: fnd_log.STRING
2552: (fnd_log.level_statement,
2553: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2554: 'Validate product txn status'
2555: );

Line 2552: (fnd_log.level_statement,

2548:
2549: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2550: THEN
2551: fnd_log.STRING
2552: (fnd_log.level_statement,
2553: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2554: 'Validate product txn status'
2555: );
2556: fnd_log.STRING

Line 2556: fnd_log.STRING

2552: (fnd_log.level_statement,
2553: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2554: 'Validate product txn status'
2555: );
2556: fnd_log.STRING
2557: (fnd_log.level_statement,
2558: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN',
2559: 'p_product_txn_rec.PROD_TXN_STATUS ='
2560: || p_product_txn_rec.prod_txn_status

Line 2557: (fnd_log.level_statement,

2553: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2554: 'Validate product txn status'
2555: );
2556: fnd_log.STRING
2557: (fnd_log.level_statement,
2558: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN',
2559: 'p_product_txn_rec.PROD_TXN_STATUS ='
2560: || p_product_txn_rec.prod_txn_status
2561: );

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

2579: RAISE fnd_api.g_exc_error;
2580: END;
2581: END IF;
2582:
2583: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2584: THEN
2585: fnd_log.STRING
2586: (fnd_log.level_procedure,
2587: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.END',

Line 2585: fnd_log.STRING

2581: END IF;
2582:
2583: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2584: THEN
2585: fnd_log.STRING
2586: (fnd_log.level_procedure,
2587: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.END',
2588: 'Leaving Validate_Product_Txn_Rec'
2589: );

Line 2586: (fnd_log.level_procedure,

2582:
2583: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2584: THEN
2585: fnd_log.STRING
2586: (fnd_log.level_procedure,
2587: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.END',
2588: 'Leaving Validate_Product_Txn_Rec'
2589: );
2590: END IF;

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

2596: RETURN BOOLEAN
2597: IS
2598: l_serial_code NUMBER ;
2599: BEGIN
2600: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2601: THEN
2602: fnd_log.STRING
2603: (fnd_log.level_procedure,
2604: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Is_Item_Pre_serialized.BEGIN',

Line 2602: fnd_log.STRING

2598: l_serial_code NUMBER ;
2599: BEGIN
2600: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2601: THEN
2602: fnd_log.STRING
2603: (fnd_log.level_procedure,
2604: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Is_Item_Pre_serialized.BEGIN',
2605: 'Entered Is_Item_Pre_serialized'
2606: );

Line 2603: (fnd_log.level_procedure,

2599: BEGIN
2600: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2601: THEN
2602: fnd_log.STRING
2603: (fnd_log.level_procedure,
2604: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Is_Item_Pre_serialized.BEGIN',
2605: 'Entered Is_Item_Pre_serialized'
2606: );
2607: END IF;

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

2618: ELSE
2619: RETURN FALSE;
2620: END IF;
2621:
2622: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2623: THEN
2624: fnd_log.STRING
2625: (fnd_log.level_procedure,
2626: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Is_Item_Pre_serialized.END',

Line 2624: fnd_log.STRING

2620: END IF;
2621:
2622: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2623: THEN
2624: fnd_log.STRING
2625: (fnd_log.level_procedure,
2626: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Is_Item_Pre_serialized.END',
2627: 'Leaving Is_Item_Pre_serialized'
2628: );

Line 2625: (fnd_log.level_procedure,

2621:
2622: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2623: THEN
2624: fnd_log.STRING
2625: (fnd_log.level_procedure,
2626: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Is_Item_Pre_serialized.END',
2627: 'Leaving Is_Item_Pre_serialized'
2628: );
2629: END IF;

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

2709: */
2710: /*AND salesrep_id IS NOT NULL;*/
2711:
2712: BEGIN
2713: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2714: THEN
2715: fnd_log.STRING (fnd_log.level_procedure,
2716: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER.BEGIN',
2717: 'Entered Validate_order'

Line 2715: fnd_log.STRING (fnd_log.level_procedure,

2711:
2712: BEGIN
2713: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2714: THEN
2715: fnd_log.STRING (fnd_log.level_procedure,
2716: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER.BEGIN',
2717: 'Entered Validate_order'
2718: );
2719: END IF;

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

2733: fnd_message.set_token ('ESTIMATE_DETAIL_ID', p_est_detail_id);
2734: */
2735: fnd_msg_pub.ADD;
2736:
2737: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2738: THEN
2739: fnd_log.STRING (fnd_log.level_statement,
2740: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER',
2741: 'Sales Order missing for estimate_detail_id ='

Line 2739: fnd_log.STRING (fnd_log.level_statement,

2735: fnd_msg_pub.ADD;
2736:
2737: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2738: THEN
2739: fnd_log.STRING (fnd_log.level_statement,
2740: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER',
2741: 'Sales Order missing for estimate_detail_id ='
2742: || p_est_detail_id
2743: );

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

2749: END IF;
2750:
2751: IF cur_ord_details%ROWCOUNT > 1
2752: THEN
2753: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2754: THEN
2755: fnd_log.STRING (fnd_log.level_statement,
2756: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER',
2757: 'Too many order header ids'

Line 2755: fnd_log.STRING (fnd_log.level_statement,

2751: IF cur_ord_details%ROWCOUNT > 1
2752: THEN
2753: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2754: THEN
2755: fnd_log.STRING (fnd_log.level_statement,
2756: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER',
2757: 'Too many order header ids'
2758: );
2759: END IF;

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

2771: fnd_message.set_name ('CSD', 'CSD_API_SALES_REP_MISSING');
2772: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);
2773: fnd_msg_pub.ADD;
2774:
2775: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2776: THEN
2777: fnd_log.STRING (fnd_log.level_statement,
2778: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER',
2779: 'Sales rep missing for Line_id='

Line 2777: fnd_log.STRING (fnd_log.level_statement,

2773: fnd_msg_pub.ADD;
2774:
2775: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2776: THEN
2777: fnd_log.STRING (fnd_log.level_statement,
2778: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER',
2779: 'Sales rep missing for Line_id='
2780: || l_order_line_id
2781: );

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

2787: END IF;
2788:
2789: IF cur_ord_line%ROWCOUNT > 1
2790: THEN
2791: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2792: THEN
2793: fnd_log.STRING (fnd_log.level_statement,
2794: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER',
2795: 'Too many order ship_from_org_id'

Line 2793: fnd_log.STRING (fnd_log.level_statement,

2789: IF cur_ord_line%ROWCOUNT > 1
2790: THEN
2791: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2792: THEN
2793: fnd_log.STRING (fnd_log.level_statement,
2794: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER',
2795: 'Too many order ship_from_org_id'
2796: );
2797: END IF;

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

2804: fnd_message.set_name ('CSD', 'CSD_API_SHIP_FROM_ORG_MISSING');
2805: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);
2806: fnd_msg_pub.ADD;
2807:
2808: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2809: THEN
2810: fnd_log.STRING (fnd_log.level_statement,
2811: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER',
2812: 'Ship from Org Id missing for Line_id='

Line 2810: fnd_log.STRING (fnd_log.level_statement,

2806: fnd_msg_pub.ADD;
2807:
2808: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2809: THEN
2810: fnd_log.STRING (fnd_log.level_statement,
2811: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER',
2812: 'Ship from Org Id missing for Line_id='
2813: || l_order_line_id
2814: );

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

2822: fnd_message.set_name ('CSD', 'CSD_API_PRICE_MISSING');
2823: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);
2824: fnd_msg_pub.ADD;
2825:
2826: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2827: THEN
2828: fnd_log.STRING (fnd_log.level_statement,
2829: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER',
2830: 'Unit Selling price missing for Line_id='

Line 2828: fnd_log.STRING (fnd_log.level_statement,

2824: fnd_msg_pub.ADD;
2825:
2826: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2827: THEN
2828: fnd_log.STRING (fnd_log.level_statement,
2829: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER',
2830: 'Unit Selling price missing for Line_id='
2831: || l_order_line_id
2832: );

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

2854: END IF;
2855:
2856: CLOSE cur_ord_hdr;
2857:
2858: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2859: THEN
2860: fnd_log.STRING (fnd_log.level_procedure,
2861: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER.END',
2862: 'Leaving Validate_order'

Line 2860: fnd_log.STRING (fnd_log.level_procedure,

2856: CLOSE cur_ord_hdr;
2857:
2858: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2859: THEN
2860: fnd_log.STRING (fnd_log.level_procedure,
2861: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER.END',
2862: 'Leaving Validate_order'
2863: );
2864: END IF;

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

2883: p_data => l_msg,
2884: p_msg_index_out => l_index_out
2885: );
2886:
2887: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
2888: THEN
2889: fnd_log.STRING (fnd_log.level_error,
2890: 'CSD.PLSQL.CSD_MASS_RCV_PVT.log_error_stack',
2891: 'error[' || l_msg || ']'

Line 2889: fnd_log.STRING (fnd_log.level_error,

2885: );
2886:
2887: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
2888: THEN
2889: fnd_log.STRING (fnd_log.level_error,
2890: 'CSD.PLSQL.CSD_MASS_RCV_PVT.log_error_stack',
2891: 'error[' || l_msg || ']'
2892: );
2893: END IF;