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 638: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

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

Line 640: fnd_log.STRING (fnd_log.level_procedure,

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

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

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

Line 673: fnd_log.STRING (fnd_log.level_event,

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

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

762:
763: CLOSE cur_repair_order;
764:
765: --Get the repair type ref and populate product txn table
766: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
767: THEN
768: fnd_log.STRING (fnd_log.level_event,
769: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
770: '------------------Fetching repair type ref for[='

Line 768: fnd_log.STRING (fnd_log.level_event,

764:
765: --Get the repair type ref and populate product txn table
766: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
767: THEN
768: fnd_log.STRING (fnd_log.level_event,
769: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
770: '------------------Fetching repair type ref for[='
771: || l_repair_order_rec.repair_type_id
772: || ']----------------'

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

806: FND_MSG_PUB.ADD;
807: RAISE FND_API.G_EXC_ERROR;
808: END IF;
809: */
810: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
811: THEN
812: fnd_log.STRING (fnd_log.level_event,
813: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
814: '------------------Calling csd_repairs_pvt.create_repair_order'

Line 812: fnd_log.STRING (fnd_log.level_event,

808: END IF;
809: */
810: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
811: THEN
812: fnd_log.STRING (fnd_log.level_event,
813: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
814: '------------------Calling csd_repairs_pvt.create_repair_order'
815: );
816: END IF;

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

836:
837: --Update Repair order line id in the record p_repair_Order_rec and prod txn table
838: l_repair_order_rec.repair_number := l_repair_number;
839:
840: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
841: THEN
842: fnd_log.STRING (fnd_log.level_statement,
843: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
844: '------------------New repair order number=[' || l_repair_number || ']'

Line 842: fnd_log.STRING (fnd_log.level_statement,

838: l_repair_order_rec.repair_number := l_repair_number;
839:
840: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
841: THEN
842: fnd_log.STRING (fnd_log.level_statement,
843: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
844: '------------------New repair order number=[' || l_repair_number || ']'
845: );
846: END IF;

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

873: p_prod_txn_tbl (i).repair_line_id := x_new_repln_id;
874: p_prod_txn_tbl (i).product_transaction_id := NULL;
875:
876: --l_product_Txn_Rec := p_prod_txn_tbl(i);
877: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level
878: )
879: THEN
880: fnd_log.STRING (fnd_log.level_statement,
881: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',

Line 880: fnd_log.STRING (fnd_log.level_statement,

876: --l_product_Txn_Rec := p_prod_txn_tbl(i);
877: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level
878: )
879: THEN
880: fnd_log.STRING (fnd_log.level_statement,
881: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
882: 'Calling Create_Product_Txn for['
883: || p_prod_txn_tbl (i).source_serial_number
884: || ']'

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

902: --Rollback to Save point Process_RO
903: RAISE fnd_api.g_exc_error;
904: END IF;
905:
906: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level
907: )
908: THEN
909: fnd_log.STRING (fnd_log.level_statement,
910: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',

Line 909: fnd_log.STRING (fnd_log.level_statement,

905:
906: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level
907: )
908: THEN
909: fnd_log.STRING (fnd_log.level_statement,
910: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
911: 'After Create_product_txn['
912: || l_repair_order_rec.serial_number
913: || ']'

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

930: x_msg_count => x_msg_count,
931: x_msg_data => x_msg_data
932: );
933:
934: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
935: fnd_log.STRING (fnd_log.level_statement,
936: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
937: 'After Create_default_product_txn['
938: || l_repair_order_rec.serial_number|| ']');

Line 935: fnd_log.STRING (fnd_log.level_statement,

931: x_msg_data => x_msg_data
932: );
933:
934: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
935: fnd_log.STRING (fnd_log.level_statement,
936: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
937: 'After Create_default_product_txn['
938: || l_repair_order_rec.serial_number|| ']');
939: END IF;

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

955: x_return_status => l_return_status,
956: x_msg_count => l_msg_count,
957: x_msg_data => l_msg_data
958: );
959: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
960: fnd_log.STRING (fnd_log.level_statement,
961: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
962: 'After CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO['
963: || x_new_repln_id || ']');

Line 960: fnd_log.STRING (fnd_log.level_statement,

956: x_msg_count => l_msg_count,
957: x_msg_data => l_msg_data
958: );
959: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
960: fnd_log.STRING (fnd_log.level_statement,
961: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
962: 'After CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO['
963: || x_new_repln_id || ']');
964: END IF;

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

968: END IF;
969:
970:
971: --Delete the processed serial number from CSD_MASS_RO_SN if exists.
972: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
973: THEN
974: fnd_log.STRING (fnd_log.level_statement,
975: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
976: 'Deleting CSD_MASS_RO_SN record sn=['

Line 974: fnd_log.STRING (fnd_log.level_statement,

970:
971: --Delete the processed serial number from CSD_MASS_RO_SN if exists.
972: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
973: THEN
974: fnd_log.STRING (fnd_log.level_statement,
975: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
976: 'Deleting CSD_MASS_RO_SN record sn=['
977: || NVL (l_repair_order_rec.serial_number, '')
978: || ']'

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

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

Line 986: fnd_log.STRING (fnd_log.level_statement,

982: IF (NVL (l_repair_order_rec.serial_number, '-') <> '-')
983: THEN
984: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
985: THEN
986: fnd_log.STRING (fnd_log.level_statement,
987: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
988: 'Deleting CSD_MASS_RO_SN record '
989: );
990: END IF;

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

1003: -- Standard call to get message count and IF count is get message info.
1004: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1005: p_data => x_msg_data);
1006:
1007: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1008: THEN
1009: fnd_log.STRING (fnd_log.level_procedure,
1010: 'CSD.PLSQL.CSD_MASS_RCV_PVT.PROCESS_RO.END',
1011: 'Leaving Process_RO'

Line 1009: fnd_log.STRING (fnd_log.level_procedure,

1005: p_data => x_msg_data);
1006:
1007: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1008: THEN
1009: fnd_log.STRING (fnd_log.level_procedure,
1010: 'CSD.PLSQL.CSD_MASS_RCV_PVT.PROCESS_RO.END',
1011: 'Leaving Process_RO'
1012: );
1013: END IF;

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

1019: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1020: p_data => x_msg_data
1021: );
1022:
1023: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
1024: THEN
1025: fnd_log.STRING (fnd_log.level_error,
1026: 'CSD.PLSQL.CSD_MASS_RCV_PVT.PROCESS_RO',
1027: 'EXC_ERROR[' || x_msg_data || ']'

Line 1025: fnd_log.STRING (fnd_log.level_error,

1021: );
1022:
1023: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
1024: THEN
1025: fnd_log.STRING (fnd_log.level_error,
1026: 'CSD.PLSQL.CSD_MASS_RCV_PVT.PROCESS_RO',
1027: 'EXC_ERROR[' || x_msg_data || ']'
1028: );
1029: END IF;

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

1034: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1035: p_data => x_msg_data
1036: );
1037:
1038: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1039: THEN
1040: fnd_log.STRING (fnd_log.level_exception,
1041: 'CSD.PLSQL.CSD_MASS_RCV_PVT.PROCESS_RO',
1042: 'EXC_UNEXP_ERROR[' || x_msg_data || ']'

Line 1040: fnd_log.STRING (fnd_log.level_exception,

1036: );
1037:
1038: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1039: THEN
1040: fnd_log.STRING (fnd_log.level_exception,
1041: 'CSD.PLSQL.CSD_MASS_RCV_PVT.PROCESS_RO',
1042: 'EXC_UNEXP_ERROR[' || x_msg_data || ']'
1043: );
1044: END IF;

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

1055: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1056: p_data => x_msg_data
1057: );
1058:
1059: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1060: THEN
1061: fnd_log.STRING (fnd_log.level_exception,
1062: 'CSD.PLSQL.CSD_MASS_RCV_PVT.PROCESS_RO',
1063: 'SQL MEssage[' || SQLERRM || ']'

Line 1061: fnd_log.STRING (fnd_log.level_exception,

1057: );
1058:
1059: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1060: THEN
1061: fnd_log.STRING (fnd_log.level_exception,
1062: 'CSD.PLSQL.CSD_MASS_RCV_PVT.PROCESS_RO',
1063: 'SQL MEssage[' || SQLERRM || ']'
1064: );
1065: END IF;

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

1212: l_estimate_detail_id NUMBER;
1213: l_booked_flag VARCHAR2 (1);
1214: l_transaction_type_id NUMBER;
1215: BEGIN
1216: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1217: THEN
1218: fnd_log.STRING
1219: (fnd_log.level_procedure,
1220: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN.BEGIN',

Line 1218: fnd_log.STRING

1214: l_transaction_type_id NUMBER;
1215: BEGIN
1216: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1217: THEN
1218: fnd_log.STRING
1219: (fnd_log.level_procedure,
1220: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN.BEGIN',
1221: 'Entered CREATE_PRODUCT_TXN'
1222: );

Line 1219: (fnd_log.level_procedure,

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

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

1221: 'Entered CREATE_PRODUCT_TXN'
1222: );
1223: END IF;
1224:
1225: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1226: THEN
1227: fnd_log.STRING (fnd_log.level_statement,
1228: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1229: 'Processing Serial Number:=['

Line 1227: fnd_log.STRING (fnd_log.level_statement,

1223: END IF;
1224:
1225: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1226: THEN
1227: fnd_log.STRING (fnd_log.level_statement,
1228: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1229: 'Processing Serial Number:=['
1230: || p_product_txn_rec.source_serial_number
1231: || ']'

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

1257: --and Price_list_Id.
1258: --Validate the parameters, Repair_line_id, action_type, action_code and Prod_Txn_Status
1259:
1260: ---------------------------------------------------------------------------------1
1261: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1262: THEN
1263: fnd_log.STRING (fnd_log.level_statement,
1264: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1265: 'Before calling validate_product_txn_Rec'

Line 1263: fnd_log.STRING (fnd_log.level_statement,

1259:
1260: ---------------------------------------------------------------------------------1
1261: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1262: THEN
1263: fnd_log.STRING (fnd_log.level_statement,
1264: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1265: 'Before calling validate_product_txn_Rec'
1266: );
1267: END IF;

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

1295: END IF;
1296:
1297: CLOSE cur_ro_details;
1298:
1299: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1300: THEN
1301: fnd_log.STRING (fnd_log.level_statement,
1302: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1303: 'l_incident_id =' || l_incident_id

Line 1301: fnd_log.STRING (fnd_log.level_statement,

1297: CLOSE cur_ro_details;
1298:
1299: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1300: THEN
1301: fnd_log.STRING (fnd_log.level_statement,
1302: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1303: 'l_incident_id =' || l_incident_id
1304: );
1305: END IF;

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

1308: -- Get the business process id
1309: l_bus_process_id :=
1310: csd_process_util.get_bus_process (p_product_txn_rec.repair_line_id);
1311:
1312: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1313: THEN
1314: fnd_log.STRING (fnd_log.level_statement,
1315: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1316: 'l_bus_process_id =' || l_bus_process_id

Line 1314: fnd_log.STRING (fnd_log.level_statement,

1310: csd_process_util.get_bus_process (p_product_txn_rec.repair_line_id);
1311:
1312: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1313: THEN
1314: fnd_log.STRING (fnd_log.level_statement,
1315: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1316: 'l_bus_process_id =' || l_bus_process_id
1317: );
1318: END IF;

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

1323: fnd_api.g_miss_num
1324: THEN
1325: l_bus_process_id := p_product_txn_rec.business_process_id;
1326: ELSE
1327: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1328: THEN
1329: fnd_log.STRING
1330: (fnd_log.level_statement,
1331: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',

Line 1329: fnd_log.STRING

1325: l_bus_process_id := p_product_txn_rec.business_process_id;
1326: ELSE
1327: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1328: THEN
1329: fnd_log.STRING
1330: (fnd_log.level_statement,
1331: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1332: 'Business process Id does not exist '
1333: );

Line 1330: (fnd_log.level_statement,

1326: ELSE
1327: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1328: THEN
1329: fnd_log.STRING
1330: (fnd_log.level_statement,
1331: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1332: 'Business process Id does not exist '
1333: );
1334: END IF;

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

1348: INTO l_transaction_type_id;
1349:
1350: IF (cur_txn_type_id%NOTFOUND)
1351: THEN
1352: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1353: THEN
1354: fnd_log.STRING
1355: (fnd_log.level_statement,
1356: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',

Line 1354: fnd_log.STRING

1350: IF (cur_txn_type_id%NOTFOUND)
1351: THEN
1352: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1353: THEN
1354: fnd_log.STRING
1355: (fnd_log.level_statement,
1356: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1357: 'No Row found for the txn_billing_type_id='
1358: || TO_CHAR (p_product_txn_rec.txn_billing_type_id)

Line 1355: (fnd_log.level_statement,

1351: THEN
1352: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1353: THEN
1354: fnd_log.STRING
1355: (fnd_log.level_statement,
1356: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1357: 'No Row found for the txn_billing_type_id='
1358: || TO_CHAR (p_product_txn_rec.txn_billing_type_id)
1359: );

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

1367: CLOSE cur_txn_type_id;
1368:
1369: p_product_txn_rec.transaction_type_id := l_transaction_type_id;
1370:
1371: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1372: THEN
1373: fnd_log.STRING (fnd_log.level_statement,
1374: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1375: 'p_product_txn_rec.transaction_type_id :'

Line 1373: fnd_log.STRING (fnd_log.level_statement,

1369: p_product_txn_rec.transaction_type_id := l_transaction_type_id;
1370:
1371: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1372: THEN
1373: fnd_log.STRING (fnd_log.level_statement,
1374: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1375: 'p_product_txn_rec.transaction_type_id :'
1376: || TO_CHAR (p_product_txn_rec.transaction_type_id)
1377: );

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

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

Line 1386: fnd_log.STRING (fnd_log.level_statement,

1382: --If the contract id is not null, derive the coverage details from oks_ent_coverages_v, oks_ent_txn_groups_v for the
1383: --given contract id and business process id.
1384: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1385: THEN
1386: fnd_log.STRING (fnd_log.level_statement,
1387: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1388: 'contract_line_id =' || p_product_txn_rec.contract_id
1389: );
1390: END IF;

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

1408: p_product_txn_rec.contract_id
1409: );
1410: fnd_msg_pub.ADD;
1411:
1412: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1413: THEN
1414: fnd_log.STRING
1415: (fnd_log.level_statement,
1416: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',

Line 1414: fnd_log.STRING

1410: fnd_msg_pub.ADD;
1411:
1412: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1413: THEN
1414: fnd_log.STRING
1415: (fnd_log.level_statement,
1416: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1417: 'Contract Line Id missing'
1418: );

Line 1415: (fnd_log.level_statement,

1411:
1412: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1413: THEN
1414: fnd_log.STRING
1415: (fnd_log.level_statement,
1416: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1417: 'Contract Line Id missing'
1418: );
1419: END IF;

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

1470: THEN
1471: RAISE fnd_api.g_exc_error;
1472: END IF;
1473:
1474: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1475: THEN
1476: fnd_log.STRING (fnd_log.level_statement,
1477: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1478: 'l_line_type_id =' || l_line_type_id

Line 1476: fnd_log.STRING (fnd_log.level_statement,

1472: END IF;
1473:
1474: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1475: THEN
1476: fnd_log.STRING (fnd_log.level_statement,
1477: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1478: 'l_line_type_id =' || l_line_type_id
1479: );
1480: fnd_log.STRING (fnd_log.level_statement,

Line 1480: fnd_log.STRING (fnd_log.level_statement,

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

Line 1485: fnd_log.STRING (fnd_log.level_statement,

1481: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1482: 'l_line_category_code ='
1483: || l_line_category_code
1484: );
1485: fnd_log.STRING (fnd_log.level_statement,
1486: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1487: 'p_product_txn_rec.price_list_id ='
1488: || p_product_txn_rec.price_list_id
1489: );

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

1521: p_product_txn_rec.inventory_item_id
1522: );
1523: fnd_msg_pub.ADD;
1524:
1525: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1526: THEN
1527: fnd_log.STRING
1528: (fnd_log.level_statement,
1529: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',

Line 1527: fnd_log.STRING

1523: fnd_msg_pub.ADD;
1524:
1525: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1526: THEN
1527: fnd_log.STRING
1528: (fnd_log.level_statement,
1529: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1530: 'Serial Number missing for inventory_item_id='
1531: || p_product_txn_rec.inventory_item_id

Line 1528: (fnd_log.level_statement,

1524:
1525: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1526: THEN
1527: fnd_log.STRING
1528: (fnd_log.level_statement,
1529: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1530: 'Serial Number missing for inventory_item_id='
1531: || p_product_txn_rec.inventory_item_id
1532: );

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

1561: END IF;
1562:
1563: CLOSE cur_pricelist_details;
1564:
1565: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1566: THEN
1567: fnd_log.STRING (fnd_log.level_statement,
1568: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1569: 'l_curr_code =' || l_curr_code

Line 1567: fnd_log.STRING (fnd_log.level_statement,

1563: CLOSE cur_pricelist_details;
1564:
1565: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1566: THEN
1567: fnd_log.STRING (fnd_log.level_statement,
1568: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1569: 'l_curr_code =' || l_curr_code
1570: );
1571: END IF;

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

1576: l_add_to_same_order := p_add_to_order_flag;
1577: l_order_header_id := null;
1578:
1579: -- If the source is RMA then process differently
1580: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1581: THEN
1582: fnd_log.STRING (fnd_log.level_statement,
1583: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1584: 'orignal source ref=[' || l_orig_src_reference || ']'

Line 1582: fnd_log.STRING (fnd_log.level_statement,

1578:
1579: -- If the source is RMA then process differently
1580: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1581: THEN
1582: fnd_log.STRING (fnd_log.level_statement,
1583: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1584: 'orignal source ref=[' || l_orig_src_reference || ']'
1585: );
1586: fnd_log.STRING (fnd_log.level_statement,

Line 1586: fnd_log.STRING (fnd_log.level_statement,

1582: fnd_log.STRING (fnd_log.level_statement,
1583: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1584: 'orignal source ref=[' || l_orig_src_reference || ']'
1585: );
1586: fnd_log.STRING (fnd_log.level_statement,
1587: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1588: 'l_add_to_same_order=[' || l_add_to_same_order || ']'
1589: );
1590: END IF;

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

1597:
1598: FETCH cur_order_header
1599: INTO l_order_header_id;
1600:
1601: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1602: THEN
1603: IF (cur_order_header%NOTFOUND)
1604: THEN
1605: fnd_log.STRING

Line 1605: fnd_log.STRING

1601: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1602: THEN
1603: IF (cur_order_header%NOTFOUND)
1604: THEN
1605: fnd_log.STRING
1606: (fnd_log.level_statement,
1607: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1608: 'Getting max order header id failed '
1609: );

Line 1606: (fnd_log.level_statement,

1602: THEN
1603: IF (cur_order_header%NOTFOUND)
1604: THEN
1605: fnd_log.STRING
1606: (fnd_log.level_statement,
1607: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1608: 'Getting max order header id failed '
1609: );
1610: ELSE

Line 1611: fnd_log.STRING

1607: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1608: 'Getting max order header id failed '
1609: );
1610: ELSE
1611: fnd_log.STRING
1612: (fnd_log.level_statement,
1613: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1614: 'Order header id[' || l_order_header_id || ']'
1615: );

Line 1612: (fnd_log.level_statement,

1608: 'Getting max order header id failed '
1609: );
1610: ELSE
1611: fnd_log.STRING
1612: (fnd_log.level_statement,
1613: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1614: 'Order header id[' || l_order_header_id || ']'
1615: );
1616: END IF;

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

1644: p_product_txn_rec.line_type_id := l_line_type_id;
1645: p_product_txn_rec.currency_code := l_curr_code;
1646: p_product_txn_rec.line_category_code := l_line_category_code;
1647:
1648: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1649: THEN
1650: fnd_log.STRING (fnd_log.level_statement,
1651: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1652: 'Convert product txn rec to charges rec'

Line 1650: fnd_log.STRING (fnd_log.level_statement,

1646: p_product_txn_rec.line_category_code := l_line_category_code;
1647:
1648: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1649: THEN
1650: fnd_log.STRING (fnd_log.level_statement,
1651: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1652: 'Convert product txn rec to charges rec'
1653: );
1654: END IF;

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

1666: );
1667:
1668: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1669: THEN
1670: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1671: THEN
1672: fnd_log.STRING (fnd_log.level_statement,
1673: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1674: 'sql error[' || SQLERRM || ']'

Line 1672: fnd_log.STRING (fnd_log.level_statement,

1668: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1669: THEN
1670: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1671: THEN
1672: fnd_log.STRING (fnd_log.level_statement,
1673: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1674: 'sql error[' || SQLERRM || ']'
1675: );
1676: END IF;

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

1683:
1684: ---------------------------------------------------------------------------------11
1685: --Call CSD_PROCESS_PVT.PROCESS_CHARGE_LINES with 'CREATE' as input parameter to create charge line.
1686: --Update estimate_Detail_id in the Product_Txn_rec.
1687: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1688: THEN
1689: fnd_log.STRING
1690: (fnd_log.level_statement,
1691: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',

Line 1689: fnd_log.STRING

1685: --Call CSD_PROCESS_PVT.PROCESS_CHARGE_LINES with 'CREATE' as input parameter to create charge line.
1686: --Update estimate_Detail_id in the Product_Txn_rec.
1687: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1688: THEN
1689: fnd_log.STRING
1690: (fnd_log.level_statement,
1691: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1692: 'Calling process_charge_lines to create charge lines '
1693: );

Line 1690: (fnd_log.level_statement,

1686: --Update estimate_Detail_id in the Product_Txn_rec.
1687: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1688: THEN
1689: fnd_log.STRING
1690: (fnd_log.level_statement,
1691: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1692: 'Calling process_charge_lines to create charge lines '
1693: );
1694: END IF;

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

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

Line 1713: fnd_log.STRING (fnd_log.level_statement,

1709: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1710: THEN
1711: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1712: THEN
1713: fnd_log.STRING (fnd_log.level_statement,
1714: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1715: 'Error[' || SUBSTR (x_msg_data, 1, 200) || ']'
1716: );
1717: END IF;

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

1718:
1719: RAISE fnd_api.g_exc_error;
1720: END IF;
1721:
1722: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1723: THEN
1724: fnd_log.STRING (fnd_log.level_statement,
1725: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1726: 'Created charge line[' || l_estimate_detail_id || ']'

Line 1724: fnd_log.STRING (fnd_log.level_statement,

1720: END IF;
1721:
1722: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1723: THEN
1724: fnd_log.STRING (fnd_log.level_statement,
1725: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1726: 'Created charge line[' || l_estimate_detail_id || ']'
1727: );
1728: END IF;

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

1729:
1730: ---------------------------------------------------------------------------------12
1731: --Call CSD_PRODUCT_TRANSACTIONS_PKG.INSERT_ROW to add a product transaction record.
1732: --Update product_transaction_id in the Product_Txn_Rec.
1733: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1734: THEN
1735: fnd_log.STRING (fnd_log.level_statement,
1736: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1737: 'Creating product txn rec ..'

Line 1735: fnd_log.STRING (fnd_log.level_statement,

1731: --Call CSD_PRODUCT_TRANSACTIONS_PKG.INSERT_ROW to add a product transaction record.
1732: --Update product_transaction_id in the Product_Txn_Rec.
1733: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1734: THEN
1735: fnd_log.STRING (fnd_log.level_statement,
1736: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1737: 'Creating product txn rec ..'
1738: );
1739: END IF;

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

1798: THEN
1799: RAISE fnd_api.g_exc_error;
1800: END IF;
1801:
1802: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1803: THEN
1804: fnd_log.STRING (fnd_log.level_statement,
1805: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1806: 'PRODUCT_TRANSACTION_ID='

Line 1804: fnd_log.STRING (fnd_log.level_statement,

1800: END IF;
1801:
1802: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1803: THEN
1804: fnd_log.STRING (fnd_log.level_statement,
1805: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1806: 'PRODUCT_TRANSACTION_ID='
1807: || p_product_txn_rec.product_transaction_id
1808: );

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

1819: --raise exception, else proceed to next step.
1820: ------------------------------------------------------------------------------------
1821: IF (p_product_txn_rec.interface_to_om_flag = 'Y')
1822: THEN
1823: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1824: THEN
1825: fnd_log.STRING
1826: (fnd_log.level_statement,
1827: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',

Line 1825: fnd_log.STRING

1821: IF (p_product_txn_rec.interface_to_om_flag = 'Y')
1822: THEN
1823: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1824: THEN
1825: fnd_log.STRING
1826: (fnd_log.level_statement,
1827: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1828: 'Call CSD_PROCESS_PVT.APPLY_CONTRACT to apply contract '
1829: );

Line 1826: (fnd_log.level_statement,

1822: THEN
1823: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1824: THEN
1825: fnd_log.STRING
1826: (fnd_log.level_statement,
1827: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1828: 'Call CSD_PROCESS_PVT.APPLY_CONTRACT to apply contract '
1829: );
1830: END IF;

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

1841: );
1842:
1843: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1844: THEN
1845: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1846: THEN
1847: fnd_log.STRING
1848: (fnd_log.level_statement,
1849: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',

Line 1847: fnd_log.STRING

1843: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1844: THEN
1845: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1846: THEN
1847: fnd_log.STRING
1848: (fnd_log.level_statement,
1849: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1850: 'apply_contract failed['
1851: || SUBSTR (x_msg_data, 1, 200)

Line 1848: (fnd_log.level_statement,

1844: THEN
1845: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1846: THEN
1847: fnd_log.STRING
1848: (fnd_log.level_statement,
1849: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1850: 'apply_contract failed['
1851: || SUBSTR (x_msg_data, 1, 200)
1852: || ']'

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

1876: l_prod_txn_status := 'SUBMITTED';
1877: l_booked_flag := 'N';
1878: END IF;
1879:
1880: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1881: THEN
1882: fnd_log.STRING (fnd_log.level_statement,
1883: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1884: 'calling CSD_PROCESS_PVT.PROCESS_SALES_ORDER to interface '

Line 1882: fnd_log.STRING (fnd_log.level_statement,

1878: END IF;
1879:
1880: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1881: THEN
1882: fnd_log.STRING (fnd_log.level_statement,
1883: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1884: 'calling CSD_PROCESS_PVT.PROCESS_SALES_ORDER to interface '
1885: || 'Charge line without booking'
1886: );

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

1904: x_msg_count => x_msg_count,
1905: x_msg_data => x_msg_data );
1906:
1907: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1908: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1909: THEN
1910: fnd_log.STRING (fnd_log.level_statement,
1911: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1912: 'process_sales_order failed['||x_msg_data||']');

Line 1910: fnd_log.STRING (fnd_log.level_statement,

1906:
1907: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1908: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1909: THEN
1910: fnd_log.STRING (fnd_log.level_statement,
1911: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1912: 'process_sales_order failed['||x_msg_data||']');
1913: END IF;
1914: RAISE FND_API.G_EXC_ERROR;

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

1918: p_order_rec => l_order_rec,
1919: x_booked_flag => l_booked_flag
1920: );
1921:
1922: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1923: THEN
1924: fnd_log.STRING (fnd_log.level_statement,
1925: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1926: 'Booking charge line with CSD_PROCESS_PVT.PROCESS_SALES_ORDER API');

Line 1924: fnd_log.STRING (fnd_log.level_statement,

1920: );
1921:
1922: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1923: THEN
1924: fnd_log.STRING (fnd_log.level_statement,
1925: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1926: 'Booking charge line with CSD_PROCESS_PVT.PROCESS_SALES_ORDER API');
1927: END IF;
1928:

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

1939: x_msg_count => x_msg_count,
1940: x_msg_data => x_msg_data );
1941:
1942: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1943: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1944: THEN
1945: fnd_log.STRING (fnd_log.level_statement,
1946: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1947: 'process_sales_order failed ['||x_msg_Data||']');

Line 1945: fnd_log.STRING (fnd_log.level_statement,

1941:
1942: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1943: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1944: THEN
1945: fnd_log.STRING (fnd_log.level_statement,
1946: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1947: 'process_sales_order failed ['||x_msg_Data||']');
1948: END IF;
1949: RAISE FND_API.G_EXC_ERROR;

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

1967:
1968: --] 3308535
1969: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1970: THEN
1971: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1972: THEN
1973: fnd_log.STRING
1974: (fnd_log.level_statement,
1975: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',

Line 1973: fnd_log.STRING

1969: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1970: THEN
1971: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1972: THEN
1973: fnd_log.STRING
1974: (fnd_log.level_statement,
1975: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1976: 'submit_Order failed ['
1977: || SUBSTR (x_msg_data, 1, 200)

Line 1974: (fnd_log.level_statement,

1970: THEN
1971: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1972: THEN
1973: fnd_log.STRING
1974: (fnd_log.level_statement,
1975: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1976: 'submit_Order failed ['
1977: || SUBSTR (x_msg_data, 1, 200)
1978: || ']'

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

1985: l_ro_txn_status := 'CHARGE_ENTERED';
1986: l_prod_txn_status := 'ENTERED';
1987: END IF;
1988:
1989: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1990: THEN
1991: fnd_log.STRING (fnd_log.level_statement,
1992: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1993: 'Updating repair status[' || l_ro_txn_status || ']'

Line 1991: fnd_log.STRING (fnd_log.level_statement,

1987: END IF;
1988:
1989: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1990: THEN
1991: fnd_log.STRING (fnd_log.level_statement,
1992: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
1993: 'Updating repair status[' || l_ro_txn_status || ']'
1994: );
1995: END IF;

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

2007: fnd_msg_pub.ADD;
2008: RAISE fnd_api.g_exc_error;
2009: END IF;
2010:
2011: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2012: THEN
2013: fnd_log.STRING (fnd_log.level_statement,
2014: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
2015: 'Updating prod txn status[' || l_prod_txn_status

Line 2013: fnd_log.STRING (fnd_log.level_statement,

2009: END IF;
2010:
2011: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2012: THEN
2013: fnd_log.STRING (fnd_log.level_statement,
2014: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
2015: 'Updating prod txn status[' || l_prod_txn_status
2016: || ']'
2017: );

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

2044: -- Standard call to get message count and IF count is get message info.
2045: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2046: p_data => x_msg_data);
2047:
2048: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2049: THEN
2050: fnd_log.STRING (fnd_log.level_procedure,
2051: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN.END',
2052: 'Leaving CREATE_PRODUCT_TXN'

Line 2050: fnd_log.STRING (fnd_log.level_procedure,

2046: p_data => x_msg_data);
2047:
2048: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2049: THEN
2050: fnd_log.STRING (fnd_log.level_procedure,
2051: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN.END',
2052: 'Leaving CREATE_PRODUCT_TXN'
2053: );
2054: END IF;

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

2061: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2062: p_data => x_msg_data
2063: );
2064:
2065: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
2066: THEN
2067: fnd_log.STRING (fnd_log.level_error,
2068: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
2069: 'EXC_ERROR[' || x_msg_data || ']'

Line 2067: fnd_log.STRING (fnd_log.level_error,

2063: );
2064:
2065: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
2066: THEN
2067: fnd_log.STRING (fnd_log.level_error,
2068: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
2069: 'EXC_ERROR[' || x_msg_data || ']'
2070: );
2071: END IF;

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

2076: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2077: p_data => x_msg_data
2078: );
2079:
2080: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2081: THEN
2082: fnd_log.STRING (fnd_log.level_exception,
2083: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
2084: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']'

Line 2082: fnd_log.STRING (fnd_log.level_exception,

2078: );
2079:
2080: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2081: THEN
2082: fnd_log.STRING (fnd_log.level_exception,
2083: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
2084: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']'
2085: );
2086: END IF;

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

2097: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2098: p_data => x_msg_data
2099: );
2100:
2101: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
2102: THEN
2103: fnd_log.STRING (fnd_log.level_unexpected,
2104: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
2105: 'SQL Error[' || SQLERRM || ']'

Line 2103: fnd_log.STRING (fnd_log.level_unexpected,

2099: );
2100:
2101: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
2102: THEN
2103: fnd_log.STRING (fnd_log.level_unexpected,
2104: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_PRODUCT_TXN',
2105: 'SQL Error[' || SQLERRM || ']'
2106: );
2107: END IF;

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

2147: l_txn_rec csi_datastructures_pub.transaction_rec;
2148: -- := csd_process_util.ui_transaction_rec;
2149: l_party_site_id NUMBER;
2150: BEGIN
2151: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2152: THEN
2153: fnd_log.STRING
2154: (fnd_log.level_procedure,
2155: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE.BEGIN',

Line 2153: fnd_log.STRING

2149: l_party_site_id NUMBER;
2150: BEGIN
2151: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2152: THEN
2153: fnd_log.STRING
2154: (fnd_log.level_procedure,
2155: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE.BEGIN',
2156: 'Entered CREATE_ITEM_INSTANCE'
2157: );

Line 2154: (fnd_log.level_procedure,

2150: BEGIN
2151: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2152: THEN
2153: fnd_log.STRING
2154: (fnd_log.level_procedure,
2155: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE.BEGIN',
2156: 'Entered CREATE_ITEM_INSTANCE'
2157: );
2158: END IF;

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

2179:
2180: -- Initialize API return status to success
2181: x_return_status := fnd_api.g_ret_sts_success;
2182:
2183: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2184: THEN
2185: fnd_log.STRING (fnd_log.level_statement,
2186: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2187: 'Finding party_site_Id for party_site_use_Id=['

Line 2185: fnd_log.STRING (fnd_log.level_statement,

2181: x_return_status := fnd_api.g_ret_sts_success;
2182:
2183: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2184: THEN
2185: fnd_log.STRING (fnd_log.level_statement,
2186: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2187: 'Finding party_site_Id for party_site_use_Id=['
2188: || px_instance_rec.party_site_use_id
2189: || ']'

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

2206: --px_instance_rec.bill_to_site_use_id);
2207: RAISE fnd_api.g_exc_error;
2208: END;
2209:
2210: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2211: THEN
2212: fnd_log.STRING (fnd_log.level_statement,
2213: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2214: 'party_site_Id=[' || l_party_site_id || ']'

Line 2212: fnd_log.STRING (fnd_log.level_statement,

2208: END;
2209:
2210: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2211: THEN
2212: fnd_log.STRING (fnd_log.level_statement,
2213: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2214: 'party_site_Id=[' || l_party_site_id || ']'
2215: );
2216: END IF;

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

2281: l_org_units_tbl(1).active_start_date := sysdate ;
2282: --bug#13713291
2283:
2284:
2285: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2286: THEN
2287: fnd_log.STRING (fnd_log.level_statement,
2288: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2289: 'Calling csi_item_instance_pub.create_item_instance'

Line 2287: fnd_log.STRING (fnd_log.level_statement,

2283:
2284:
2285: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2286: THEN
2287: fnd_log.STRING (fnd_log.level_statement,
2288: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2289: 'Calling csi_item_instance_pub.create_item_instance'
2290: );
2291: END IF;

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

2327: -- Standard call to get message count and if count is 1, get message info.
2328: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2329: p_data => x_msg_data);
2330:
2331: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2332: THEN
2333: fnd_log.STRING
2334: (fnd_log.level_procedure,
2335: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE.END',

Line 2333: fnd_log.STRING

2329: p_data => x_msg_data);
2330:
2331: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2332: THEN
2333: fnd_log.STRING
2334: (fnd_log.level_procedure,
2335: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE.END',
2336: 'Leaving CREATE_ITEM_INSTANCE'
2337: );

Line 2334: (fnd_log.level_procedure,

2330:
2331: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2332: THEN
2333: fnd_log.STRING
2334: (fnd_log.level_procedure,
2335: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE.END',
2336: 'Leaving CREATE_ITEM_INSTANCE'
2337: );
2338: END IF;

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

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

Line 2350: fnd_log.STRING

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

Line 2351: (fnd_log.level_error,

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

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

2360: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2361: p_data => x_msg_data
2362: );
2363:
2364: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2365: THEN
2366: fnd_log.STRING
2367: (fnd_log.level_exception,
2368: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',

Line 2366: fnd_log.STRING

2362: );
2363:
2364: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2365: THEN
2366: fnd_log.STRING
2367: (fnd_log.level_exception,
2368: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2369: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']'
2370: );

Line 2367: (fnd_log.level_exception,

2363:
2364: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2365: THEN
2366: fnd_log.STRING
2367: (fnd_log.level_exception,
2368: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2369: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']'
2370: );
2371: END IF;

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

2382: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2383: p_data => x_msg_data
2384: );
2385:
2386: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
2387: THEN
2388: fnd_log.STRING
2389: (fnd_log.level_unexpected,
2390: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',

Line 2388: fnd_log.STRING

2384: );
2385:
2386: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
2387: THEN
2388: fnd_log.STRING
2389: (fnd_log.level_unexpected,
2390: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2391: 'SQL MEssage[' || SQLERRM || ']'
2392: );

Line 2389: (fnd_log.level_unexpected,

2385:
2386: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
2387: THEN
2388: fnd_log.STRING
2389: (fnd_log.level_unexpected,
2390: 'CSD.PLSQL.CSD_MASS_RCV_PVT.CREATE_ITEM_INSTANCE',
2391: 'SQL MEssage[' || SQLERRM || ']'
2392: );
2393: END IF;

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

2403: l_api_name CONSTANT VARCHAR2 (30) := 'PROCESS_RO';
2404: l_return_status VARCHAR2 (1) ;
2405: l_check VARCHAR2 (1);
2406: BEGIN
2407: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2408: THEN
2409: fnd_log.STRING
2410: (fnd_log.level_procedure,
2411: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN',

Line 2409: fnd_log.STRING

2405: l_check VARCHAR2 (1);
2406: BEGIN
2407: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2408: THEN
2409: fnd_log.STRING
2410: (fnd_log.level_procedure,
2411: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN',
2412: 'Entered Validate_Product_Txn_Rec'
2413: );

Line 2410: (fnd_log.level_procedure,

2406: BEGIN
2407: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2408: THEN
2409: fnd_log.STRING
2410: (fnd_log.level_procedure,
2411: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN',
2412: 'Entered Validate_Product_Txn_Rec'
2413: );
2414: END IF;

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

2412: 'Entered Validate_Product_Txn_Rec'
2413: );
2414: END IF;
2415:
2416: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2417: THEN
2418: fnd_log.STRING
2419: (fnd_log.level_statement,
2420: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN',

Line 2418: fnd_log.STRING

2414: END IF;
2415:
2416: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2417: THEN
2418: fnd_log.STRING
2419: (fnd_log.level_statement,
2420: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN',
2421: 'Checking mandatory parameters'
2422: );

Line 2419: (fnd_log.level_statement,

2415:
2416: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2417: THEN
2418: fnd_log.STRING
2419: (fnd_log.level_statement,
2420: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN',
2421: 'Checking mandatory parameters'
2422: );
2423: END IF;

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

2471: p_param_name => 'PRICE_LIST_ID',
2472: p_api_name => l_api_name
2473: );
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: );
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 repair line id'
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 repair line id'
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 type'
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 type'
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 action code'
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 action code'
2515: );
2516: END IF;

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

2522: THEN
2523: RAISE fnd_api.g_exc_error;
2524: END IF;
2525:
2526: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2527: THEN
2528: fnd_log.STRING
2529: (fnd_log.level_statement,
2530: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',

Line 2528: fnd_log.STRING

2524: END IF;
2525:
2526: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2527: THEN
2528: fnd_log.STRING
2529: (fnd_log.level_statement,
2530: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2531: 'Validate product txn qty'
2532: );

Line 2529: (fnd_log.level_statement,

2525:
2526: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2527: THEN
2528: fnd_log.STRING
2529: (fnd_log.level_statement,
2530: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2531: 'Validate product txn qty'
2532: );
2533: fnd_log.STRING

Line 2533: fnd_log.STRING

2529: (fnd_log.level_statement,
2530: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2531: 'Validate product txn qty'
2532: );
2533: fnd_log.STRING
2534: (fnd_log.level_statement,
2535: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN',
2536: 'p_product_txn_rec.quantity =' || p_product_txn_rec.quantity
2537: );

Line 2534: (fnd_log.level_statement,

2530: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2531: 'Validate product txn qty'
2532: );
2533: fnd_log.STRING
2534: (fnd_log.level_statement,
2535: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN',
2536: 'p_product_txn_rec.quantity =' || p_product_txn_rec.quantity
2537: );
2538: END IF;

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

2549: );
2550:
2551: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
2552: THEN
2553: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2554: THEN
2555: fnd_log.STRING
2556: (fnd_log.level_statement,
2557: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',

Line 2555: fnd_log.STRING

2551: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
2552: THEN
2553: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2554: THEN
2555: fnd_log.STRING
2556: (fnd_log.level_statement,
2557: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2558: 'Validate_Quantity failed '
2559: );

Line 2556: (fnd_log.level_statement,

2552: THEN
2553: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2554: THEN
2555: fnd_log.STRING
2556: (fnd_log.level_statement,
2557: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2558: 'Validate_Quantity failed '
2559: );
2560: END IF;

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

2562: RAISE fnd_api.g_exc_error;
2563: END IF;
2564: END IF;
2565:
2566: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2567: THEN
2568: fnd_log.STRING
2569: (fnd_log.level_statement,
2570: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',

Line 2568: fnd_log.STRING

2564: END IF;
2565:
2566: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2567: THEN
2568: fnd_log.STRING
2569: (fnd_log.level_statement,
2570: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2571: 'Validate product txn status'
2572: );

Line 2569: (fnd_log.level_statement,

2565:
2566: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2567: THEN
2568: fnd_log.STRING
2569: (fnd_log.level_statement,
2570: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2571: 'Validate product txn status'
2572: );
2573: fnd_log.STRING

Line 2573: fnd_log.STRING

2569: (fnd_log.level_statement,
2570: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2571: 'Validate product txn status'
2572: );
2573: fnd_log.STRING
2574: (fnd_log.level_statement,
2575: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN',
2576: 'p_product_txn_rec.PROD_TXN_STATUS ='
2577: || p_product_txn_rec.prod_txn_status

Line 2574: (fnd_log.level_statement,

2570: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC',
2571: 'Validate product txn status'
2572: );
2573: fnd_log.STRING
2574: (fnd_log.level_statement,
2575: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_PRODUCT_TXN_REC.BEGIN',
2576: 'p_product_txn_rec.PROD_TXN_STATUS ='
2577: || p_product_txn_rec.prod_txn_status
2578: );

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

2596: RAISE fnd_api.g_exc_error;
2597: END;
2598: END IF;
2599:
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.VALIDATE_PRODUCT_TXN_REC.END',

Line 2602: fnd_log.STRING

2598: END IF;
2599:
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.VALIDATE_PRODUCT_TXN_REC.END',
2605: 'Leaving Validate_Product_Txn_Rec'
2606: );

Line 2603: (fnd_log.level_procedure,

2599:
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.VALIDATE_PRODUCT_TXN_REC.END',
2605: 'Leaving Validate_Product_Txn_Rec'
2606: );
2607: END IF;

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

2613: RETURN BOOLEAN
2614: IS
2615: l_serial_code NUMBER ;
2616: BEGIN
2617: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2618: THEN
2619: fnd_log.STRING
2620: (fnd_log.level_procedure,
2621: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Is_Item_Pre_serialized.BEGIN',

Line 2619: fnd_log.STRING

2615: l_serial_code NUMBER ;
2616: BEGIN
2617: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2618: THEN
2619: fnd_log.STRING
2620: (fnd_log.level_procedure,
2621: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Is_Item_Pre_serialized.BEGIN',
2622: 'Entered Is_Item_Pre_serialized'
2623: );

Line 2620: (fnd_log.level_procedure,

2616: BEGIN
2617: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2618: THEN
2619: fnd_log.STRING
2620: (fnd_log.level_procedure,
2621: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Is_Item_Pre_serialized.BEGIN',
2622: 'Entered Is_Item_Pre_serialized'
2623: );
2624: END IF;

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

2635: ELSE
2636: RETURN FALSE;
2637: END IF;
2638:
2639: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2640: THEN
2641: fnd_log.STRING
2642: (fnd_log.level_procedure,
2643: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Is_Item_Pre_serialized.END',

Line 2641: fnd_log.STRING

2637: END IF;
2638:
2639: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2640: THEN
2641: fnd_log.STRING
2642: (fnd_log.level_procedure,
2643: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Is_Item_Pre_serialized.END',
2644: 'Leaving Is_Item_Pre_serialized'
2645: );

Line 2642: (fnd_log.level_procedure,

2638:
2639: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2640: THEN
2641: fnd_log.STRING
2642: (fnd_log.level_procedure,
2643: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Is_Item_Pre_serialized.END',
2644: 'Leaving Is_Item_Pre_serialized'
2645: );
2646: END IF;

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

2726: */
2727: /*AND salesrep_id IS NOT NULL;*/
2728:
2729: BEGIN
2730: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2731: THEN
2732: fnd_log.STRING (fnd_log.level_procedure,
2733: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER.BEGIN',
2734: 'Entered Validate_order'

Line 2732: fnd_log.STRING (fnd_log.level_procedure,

2728:
2729: BEGIN
2730: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2731: THEN
2732: fnd_log.STRING (fnd_log.level_procedure,
2733: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER.BEGIN',
2734: 'Entered Validate_order'
2735: );
2736: END IF;

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

2750: fnd_message.set_token ('ESTIMATE_DETAIL_ID', p_est_detail_id);
2751: */
2752: fnd_msg_pub.ADD;
2753:
2754: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2755: THEN
2756: fnd_log.STRING (fnd_log.level_statement,
2757: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER',
2758: 'Sales Order missing for estimate_detail_id ='

Line 2756: fnd_log.STRING (fnd_log.level_statement,

2752: fnd_msg_pub.ADD;
2753:
2754: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2755: THEN
2756: fnd_log.STRING (fnd_log.level_statement,
2757: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER',
2758: 'Sales Order missing for estimate_detail_id ='
2759: || p_est_detail_id
2760: );

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

2766: END IF;
2767:
2768: IF cur_ord_details%ROWCOUNT > 1
2769: THEN
2770: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2771: THEN
2772: fnd_log.STRING (fnd_log.level_statement,
2773: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER',
2774: 'Too many order header ids'

Line 2772: fnd_log.STRING (fnd_log.level_statement,

2768: IF cur_ord_details%ROWCOUNT > 1
2769: THEN
2770: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2771: THEN
2772: fnd_log.STRING (fnd_log.level_statement,
2773: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER',
2774: 'Too many order header ids'
2775: );
2776: END IF;

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

2788: fnd_message.set_name ('CSD', 'CSD_API_SALES_REP_MISSING');
2789: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);
2790: fnd_msg_pub.ADD;
2791:
2792: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2793: THEN
2794: fnd_log.STRING (fnd_log.level_statement,
2795: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER',
2796: 'Sales rep missing for Line_id='

Line 2794: fnd_log.STRING (fnd_log.level_statement,

2790: fnd_msg_pub.ADD;
2791:
2792: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2793: THEN
2794: fnd_log.STRING (fnd_log.level_statement,
2795: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER',
2796: 'Sales rep missing for Line_id='
2797: || l_order_line_id
2798: );

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

2804: END IF;
2805:
2806: IF cur_ord_line%ROWCOUNT > 1
2807: THEN
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: 'Too many order ship_from_org_id'

Line 2810: fnd_log.STRING (fnd_log.level_statement,

2806: IF cur_ord_line%ROWCOUNT > 1
2807: THEN
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: 'Too many order ship_from_org_id'
2813: );
2814: END IF;

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

2821: fnd_message.set_name ('CSD', 'CSD_API_SHIP_FROM_ORG_MISSING');
2822: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);
2823: fnd_msg_pub.ADD;
2824:
2825: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2826: THEN
2827: fnd_log.STRING (fnd_log.level_statement,
2828: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER',
2829: 'Ship from Org Id missing for Line_id='

Line 2827: fnd_log.STRING (fnd_log.level_statement,

2823: fnd_msg_pub.ADD;
2824:
2825: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2826: THEN
2827: fnd_log.STRING (fnd_log.level_statement,
2828: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER',
2829: 'Ship from Org Id missing for Line_id='
2830: || l_order_line_id
2831: );

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

2839: fnd_message.set_name ('CSD', 'CSD_API_PRICE_MISSING');
2840: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);
2841: fnd_msg_pub.ADD;
2842:
2843: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2844: THEN
2845: fnd_log.STRING (fnd_log.level_statement,
2846: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER',
2847: 'Unit Selling price missing for Line_id='

Line 2845: fnd_log.STRING (fnd_log.level_statement,

2841: fnd_msg_pub.ADD;
2842:
2843: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2844: THEN
2845: fnd_log.STRING (fnd_log.level_statement,
2846: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER',
2847: 'Unit Selling price missing for Line_id='
2848: || l_order_line_id
2849: );

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

2871: END IF;
2872:
2873: CLOSE cur_ord_hdr;
2874:
2875: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2876: THEN
2877: fnd_log.STRING (fnd_log.level_procedure,
2878: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER.END',
2879: 'Leaving Validate_order'

Line 2877: fnd_log.STRING (fnd_log.level_procedure,

2873: CLOSE cur_ord_hdr;
2874:
2875: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2876: THEN
2877: fnd_log.STRING (fnd_log.level_procedure,
2878: 'CSD.PLSQL.CSD_MASS_RCV_PVT.VALIDATE_ORDER.END',
2879: 'Leaving Validate_order'
2880: );
2881: END IF;

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

2900: p_data => l_msg,
2901: p_msg_index_out => l_index_out
2902: );
2903:
2904: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
2905: THEN
2906: fnd_log.STRING (fnd_log.level_error,
2907: 'CSD.PLSQL.CSD_MASS_RCV_PVT.log_error_stack',
2908: 'error[' || l_msg || ']'

Line 2906: fnd_log.STRING (fnd_log.level_error,

2902: );
2903:
2904: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
2905: THEN
2906: fnd_log.STRING (fnd_log.level_error,
2907: 'CSD.PLSQL.CSD_MASS_RCV_PVT.log_error_stack',
2908: 'error[' || l_msg || ']'
2909: );
2910: END IF;