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

APPS.CSD_SPLIT_PKG dependencies on FND_LOG

Line 44: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

40: x_repair_line_id NUMBER;
41: l_original_repair_number NUMBER;
42: l_original_repair_type_id NUMBER;
43:
44: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
45: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
46: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
47: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
48:

Line 45: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

41: l_original_repair_number NUMBER;
42: l_original_repair_type_id NUMBER;
43:
44: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
45: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
46: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
47: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
48:
49: -- swai: 12.1.1 bug 7176940 service bulletin check

Line 46: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

42: l_original_repair_type_id NUMBER;
43:
44: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
45: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
46: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
47: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
48:
49: -- swai: 12.1.1 bug 7176940 service bulletin check
50: l_ro_sc_ids_tbl CSD_RO_BULLETINS_PVT.CSD_RO_SC_IDS_TBL_TYPE;

Line 47: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;

43:
44: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
45: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
46: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
47: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
48:
49: -- swai: 12.1.1 bug 7176940 service bulletin check
50: l_ro_sc_ids_tbl CSD_RO_BULLETINS_PVT.CSD_RO_SC_IDS_TBL_TYPE;
51: l_return_status VARCHAR2 (1) ;

Line 63: FND_LOG.STRING(l_procedure_level,

59:
60: Begin
61:
62: IF(l_procedure_level >= l_debug_level) THEN
63: FND_LOG.STRING(l_procedure_level,
64: 'CSD.PLSQL.CSD_SPLIT_PKG.Split_Repair_Order',
65: 'Entered Split_Repair_Order API');
66: END IF;
67:

Line 69: FND_LOG.STRING(l_statement_level,

65: 'Entered Split_Repair_Order API');
66: END IF;
67:
68: IF(l_statement_level >= l_debug_level) THEN
69: FND_LOG.STRING(l_statement_level,
70: 'CSD.PLSQL.CSD_SPLIT_PKG.Split_Repair_Order',
71: 'Enabling the Split_Repair_Order savepoint');
72: END IF;
73:

Line 106: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Repln_Record','failed');

102: x_return_status => x_return_status
103: );
104: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
105: IF(l_statement_level >= l_debug_level) THEN
106: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Repln_Record','failed');
107: END IF;
108: RAISE FND_API.G_EXC_ERROR;
109: END IF;
110:

Line 148: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Update_Repair_Order','failed');

144: x_msg_data => x_msg_data
145: );
146: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
147: IF(l_statement_level >= l_debug_level) THEN
148: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Update_Repair_Order','failed');
149: END IF;
150: RAISE FND_API.G_EXC_ERROR;
151: END IF;
152:

Line 173: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order','failed');

169: p_rep_line_rec => l_rep_line_rec
170: );
171: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
172: IF(l_statement_level >= l_debug_level) THEN
173: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order','failed');
174: END IF;
175: RAISE FND_API.G_EXC_ERROR;
176: END IF;
177:

Line 196: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIR_HISTORY_PVT.Create_repair_history','failed');

192: X_Msg_Data => x_msg_data
193: );
194: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
195: IF(l_statement_level >= l_debug_level) THEN
196: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIR_HISTORY_PVT.Create_repair_history','failed');
197: END IF;
198: RAISE FND_API.G_EXC_ERROR;
199: END IF;
200:

Line 238: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIR_HISTORY_PVT.Create_repair_history','failed');

234: X_Msg_Data => x_msg_data
235: );
236: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
237: IF(l_statement_level >= l_debug_level) THEN
238: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIR_HISTORY_PVT.Create_repair_history','failed');
239: END IF;
240: RAISE FND_API.G_EXC_ERROR;
241: END IF;
242:

Line 287: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Update_Repair_Order','failed');

283: x_msg_data => x_msg_data
284: );
285: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
286: IF(l_statement_level >= l_debug_level) THEN
287: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Update_Repair_Order','failed');
288: END IF;
289: RAISE FND_API.G_EXC_ERROR;
290: END IF;
291:

Line 312: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order','failed');

308: p_rep_line_rec => l_rep_line_rec
309: );
310: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
311: IF(l_statement_level >= l_debug_level) THEN
312: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order','failed');
313: END IF;
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316:

Line 338: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIR_HISTORY_PVT.Create_repair_history','failed');

334: X_Msg_Data => x_msg_data
335: );
336: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
337: IF(l_statement_level >= l_debug_level) THEN
338: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIR_HISTORY_PVT.Create_repair_history','failed');
339: END IF;
340: RAISE FND_API.G_EXC_ERROR;
341: END IF;
342:

Line 366: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIR_HISTORY_PVT.Create_repair_history','failed');

362: X_Msg_Data => x_msg_data
363: );
364: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
365: IF(l_statement_level >= l_debug_level) THEN
366: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIR_HISTORY_PVT.Create_repair_history','failed');
367: END IF;
368: RAISE FND_API.G_EXC_ERROR;
369: END IF;
370:

Line 408: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

404: FND_MSG_PUB.Count_And_Get
405: ( p_count => x_msg_count,
406: p_data => x_msg_data
407: );
408: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
409: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
410: 'CSD.PLSQL.CSD_SPLIT_PKG.Split_Repair_Order',
411: 'EXC_ERROR ['||x_msg_data||']');
412: END IF;

Line 409: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

405: ( p_count => x_msg_count,
406: p_data => x_msg_data
407: );
408: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
409: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
410: 'CSD.PLSQL.CSD_SPLIT_PKG.Split_Repair_Order',
411: 'EXC_ERROR ['||x_msg_data||']');
412: END IF;
413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 420: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

416: FND_MSG_PUB.Count_And_Get
417: ( p_count => x_msg_count,
418: p_data => x_msg_data
419: );
420: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
421: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
422: 'CSD.PLSQL.CSD_SPLIT_PKG.Split_Repair_Order',
423: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
424: END IF;

Line 421: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

417: ( p_count => x_msg_count,
418: p_data => x_msg_data
419: );
420: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
421: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
422: 'CSD.PLSQL.CSD_SPLIT_PKG.Split_Repair_Order',
423: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
424: END IF;
425: WHEN OTHERS THEN

Line 440: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

436: FND_MSG_PUB.Count_And_Get
437: ( p_count => x_msg_count,
438: p_data => x_msg_data
439: );
440: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
441: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
442: 'CSD.PLSQL.CSD_SPLIT_PKG.Split_Repair_Order',
443: 'SQL Message ['||sqlerrm||']');
444: END IF;

Line 441: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

437: ( p_count => x_msg_count,
438: p_data => x_msg_data
439: );
440: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
441: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
442: 'CSD.PLSQL.CSD_SPLIT_PKG.Split_Repair_Order',
443: 'SQL Message ['||sqlerrm||']');
444: END IF;
445:

Line 532: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

528: ,parent_repair_line_id --bug#13698799 auto create ro, parent ro
529: FROM csd_repairs
530: where repair_line_id = p_repair_line_id;
531:
532: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
533: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
534: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
535: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
536:

Line 533: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

529: FROM csd_repairs
530: where repair_line_id = p_repair_line_id;
531:
532: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
533: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
534: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
535: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
536:
537: begin

Line 534: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

530: where repair_line_id = p_repair_line_id;
531:
532: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
533: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
534: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
535: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
536:
537: begin
538:

Line 535: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;

531:
532: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
533: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
534: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
535: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
536:
537: begin
538:
539: -- Initialize API return status to success

Line 543: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Repln_Record','At the Begin in Build_Repln_Record');

539: -- Initialize API return status to success
540: x_return_status := FND_API.G_RET_STS_SUCCESS;
541:
542: IF(l_statement_level >= l_debug_level) THEN
543: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Repln_Record','At the Begin in Build_Repln_Record');
544: END IF;
545:
546: IF NVL(p_repair_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
547:

Line 709: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

705: ,internal_po_header_id -- swai: bug 6148019
706: FROM csd_product_transactions
707: where product_transaction_id = p_product_txn_id;
708:
709: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
710: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
711: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
712: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
713:

Line 710: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

706: FROM csd_product_transactions
707: where product_transaction_id = p_product_txn_id;
708:
709: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
710: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
711: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
712: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
713:
714: begin

Line 711: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

707: where product_transaction_id = p_product_txn_id;
708:
709: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
710: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
711: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
712: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
713:
714: begin
715:

Line 712: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;

708:
709: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
710: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
711: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
712: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
713:
714: begin
715:
716: -- Initialize API return status to success

Line 847: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

843: l_repair_mode VARCHAR2(10);
844: l_repair_type_ref VARCHAR2(10);
845: l_wip_job_count NUMBER;
846:
847: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
848: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
849: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
850: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
851:

Line 848: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

844: l_repair_type_ref VARCHAR2(10);
845: l_wip_job_count NUMBER;
846:
847: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
848: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
849: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
850: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
851:
852: CURSOR c_rma_product_txn_line_info(p_repair_line_id IN NUMBER) IS

Line 849: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

845: l_wip_job_count NUMBER;
846:
847: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
848: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
849: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
850: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
851:
852: CURSOR c_rma_product_txn_line_info(p_repair_line_id IN NUMBER) IS
853: SELECT cptv.action_type, cptv.interface_to_om_flag, cptv.repair_quantity, cptv.quantity_in_wip, cptv.quantity_rcvd, cptv.status,

Line 850: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;

846:
847: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
848: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
849: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
850: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
851:
852: CURSOR c_rma_product_txn_line_info(p_repair_line_id IN NUMBER) IS
853: SELECT cptv.action_type, cptv.interface_to_om_flag, cptv.repair_quantity, cptv.quantity_in_wip, cptv.quantity_rcvd, cptv.status,
854: cptv.serial_number_control_code, crtv.repair_type_ref, msiv.comms_nl_trackable_flag, crtv.repair_mode

Line 1012: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1008: FND_MSG_PUB.Count_And_Get
1009: ( p_count => x_msg_count,
1010: p_data => x_msg_data
1011: );
1012: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1013: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1014: 'CSD.PLSQL.CSD_SPLIT_PKG.Is_Split_Repair_Order_Allow',
1015: 'EXC_ERROR ['||x_msg_data||']');
1016: END IF;

Line 1013: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

1009: ( p_count => x_msg_count,
1010: p_data => x_msg_data
1011: );
1012: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1013: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1014: 'CSD.PLSQL.CSD_SPLIT_PKG.Is_Split_Repair_Order_Allow',
1015: 'EXC_ERROR ['||x_msg_data||']');
1016: END IF;
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1024: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1020: FND_MSG_PUB.Count_And_Get
1021: ( p_count => x_msg_count,
1022: p_data => x_msg_data
1023: );
1024: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1025: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1026: 'CSD.PLSQL.CSD_SPLIT_PKG.Is_Split_Repair_Order_Allow',
1027: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
1028: END IF;

Line 1025: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

1021: ( p_count => x_msg_count,
1022: p_data => x_msg_data
1023: );
1024: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1025: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1026: 'CSD.PLSQL.CSD_SPLIT_PKG.Is_Split_Repair_Order_Allow',
1027: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
1028: END IF;
1029: WHEN OTHERS THEN

Line 1044: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1040: FND_MSG_PUB.Count_And_Get
1041: ( p_count => x_msg_count,
1042: p_data => x_msg_data
1043: );
1044: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1045: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1046: 'CSD.PLSQL.CSD_SPLIT_PKG.Is_Split_Repair_Order_Allow',
1047: 'SQL Message ['||sqlerrm||']');
1048: END IF;

Line 1045: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

1041: ( p_count => x_msg_count,
1042: p_data => x_msg_data
1043: );
1044: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1045: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1046: 'CSD.PLSQL.CSD_SPLIT_PKG.Is_Split_Repair_Order_Allow',
1047: 'SQL Message ['||sqlerrm||']');
1048: END IF;
1049:

Line 1078: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1074: SELECT product_transaction_id
1075: FROM csd_product_txns_v
1076: WHERE repair_line_id = p_original_repair_line_id and ACTION_TYPE = 'RMA';
1077:
1078: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1079: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1080: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1081: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1082:

Line 1079: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1075: FROM csd_product_txns_v
1076: WHERE repair_line_id = p_original_repair_line_id and ACTION_TYPE = 'RMA';
1077:
1078: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1079: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1080: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1081: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1082:
1083: Begin

Line 1080: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1076: WHERE repair_line_id = p_original_repair_line_id and ACTION_TYPE = 'RMA';
1077:
1078: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1079: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1080: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1081: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1082:
1083: Begin
1084:

Line 1081: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;

1077:
1078: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1079: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1080: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1081: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1082:
1083: Begin
1084:
1085:

Line 1114: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Create_Repair_Order','failed');

1110: x_msg_data => x_msg_data
1111: );
1112: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1113: IF(l_statement_level >= l_debug_level) THEN
1114: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Create_Repair_Order','failed');
1115: END IF;
1116: RAISE FND_API.G_EXC_ERROR;
1117: END IF;
1118:

Line 1132: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Product_TXN_Record','failed');

1128: x_return_status => x_return_status
1129: );
1130: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1131: IF(l_statement_level >= l_debug_level) THEN
1132: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Product_TXN_Record','failed');
1133: END IF;
1134: RAISE FND_API.G_EXC_ERROR;
1135: END IF;
1136:

Line 1209: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Ship_Prod_Txn_Tbl','failed');

1205: x_return_status => x_return_status );
1206:
1207: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1208: IF(l_statement_level >= l_debug_level) THEN
1209: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Ship_Prod_Txn_Tbl','failed');
1210: END IF;
1211: RAISE FND_API.G_EXC_ERROR;
1212: END IF;
1213:

Line 1231: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_PROCESS_UTIL.CREATE_PRODUCT_TXN','failed');

1227: x_msg_data => x_msg_data );
1228:
1229: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1230: IF(l_statement_level >= l_debug_level) THEN
1231: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_PROCESS_UTIL.CREATE_PRODUCT_TXN','failed');
1232: END IF;
1233: RAISE FND_API.G_EXC_ERROR;
1234: END IF;
1235: END LOOP;

Line 1251: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Copy_Repair_History','failed');

1247: p_new_repair_line_id => l_repair_line_id);
1248:
1249: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1250: IF(l_statement_level >= l_debug_level) THEN
1251: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Copy_Repair_History','failed');
1252: END IF;
1253: RAISE FND_API.G_EXC_ERROR;
1254: END IF;
1255:

Line 1269: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Copy_JTF_Notes','failed');

1265: p_new_repair_line_id => l_repair_line_id);
1266:
1267: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1268: IF(l_statement_level >= l_debug_level) THEN
1269: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Copy_JTF_Notes','failed');
1270: END IF;
1271: RAISE FND_API.G_EXC_ERROR;
1272: END IF;
1273:

Line 1288: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Copy_Attachments','failed');

1284: x_msg_data => x_msg_data);
1285:
1286: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1287: IF(l_statement_level >= l_debug_level) THEN
1288: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Copy_Attachments','failed');
1289: END IF;
1290: RAISE FND_API.G_EXC_ERROR;
1291: END IF;
1292: END if;

Line 1315: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1311: FND_MSG_PUB.Count_And_Get
1312: ( p_count => x_msg_count,
1313: p_data => x_msg_data
1314: );
1315: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1316: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1317: 'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order',
1318: 'EXC_ERROR ['||x_msg_data||']');
1319: END IF;

Line 1316: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

1312: ( p_count => x_msg_count,
1313: p_data => x_msg_data
1314: );
1315: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1316: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1317: 'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order',
1318: 'EXC_ERROR ['||x_msg_data||']');
1319: END IF;
1320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1327: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1323: FND_MSG_PUB.Count_And_Get
1324: ( p_count => x_msg_count,
1325: p_data => x_msg_data
1326: );
1327: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1328: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1329: 'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order',
1330: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
1331: END IF;

Line 1328: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

1324: ( p_count => x_msg_count,
1325: p_data => x_msg_data
1326: );
1327: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1328: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1329: 'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order',
1330: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
1331: END IF;
1332: WHEN OTHERS THEN

Line 1347: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1343: FND_MSG_PUB.Count_And_Get
1344: ( p_count => x_msg_count,
1345: p_data => x_msg_data
1346: );
1347: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1348: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1349: 'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order',
1350: 'SQL Message ['||sqlerrm||']');
1351: END IF;

Line 1348: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

1344: ( p_count => x_msg_count,
1345: p_data => x_msg_data
1346: );
1347: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1348: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1349: 'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order',
1350: 'SQL Message ['||sqlerrm||']');
1351: END IF;
1352:

Line 1372: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1368:
1369: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Repair_History' ;
1370: l_repair_history_rec CSD_REPAIR_HISTORY_PVT.REPH_Rec_Type;
1371: l_repair_history_id NUMBER;
1372: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1373: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1374: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1375: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1376:

Line 1373: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1369: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Repair_History' ;
1370: l_repair_history_rec CSD_REPAIR_HISTORY_PVT.REPH_Rec_Type;
1371: l_repair_history_id NUMBER;
1372: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1373: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1374: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1375: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1376:
1377: CURSOR c_repair_history_id (p_original_repair_line_id IN NUMBER) IS

Line 1374: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1370: l_repair_history_rec CSD_REPAIR_HISTORY_PVT.REPH_Rec_Type;
1371: l_repair_history_id NUMBER;
1372: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1373: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1374: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1375: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1376:
1377: CURSOR c_repair_history_id (p_original_repair_line_id IN NUMBER) IS
1378: SELECT repair_history_id

Line 1375: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;

1371: l_repair_history_id NUMBER;
1372: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1373: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1374: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1375: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1376:
1377: CURSOR c_repair_history_id (p_original_repair_line_id IN NUMBER) IS
1378: SELECT repair_history_id
1379: FROM CSD_REPAIR_HISTORY

Line 1409: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Repair_History_Record','failed');

1405: x_return_status => x_return_status
1406: );
1407: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1408: IF(l_statement_level >= l_debug_level) THEN
1409: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Repair_History_Record','failed');
1410: END IF;
1411: RAISE FND_API.G_EXC_ERROR;
1412: END IF;
1413:

Line 1430: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIR_HISTORY_PVT.Create_repair_history','failed');

1426: X_Msg_Data => x_msg_data
1427: );
1428: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1429: IF(l_statement_level >= l_debug_level) THEN
1430: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIR_HISTORY_PVT.Create_repair_history','failed');
1431: END IF;
1432: RAISE FND_API.G_EXC_ERROR;
1433: END IF;
1434:

Line 1461: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1457: FND_MSG_PUB.Count_And_Get
1458: ( p_count => x_msg_count,
1459: p_data => x_msg_data
1460: );
1461: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1462: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1463: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_Repair_History',
1464: 'EXC_ERROR ['||x_msg_data||']');
1465: END IF;

Line 1462: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

1458: ( p_count => x_msg_count,
1459: p_data => x_msg_data
1460: );
1461: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1462: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1463: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_Repair_History',
1464: 'EXC_ERROR ['||x_msg_data||']');
1465: END IF;
1466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1473: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1469: FND_MSG_PUB.Count_And_Get
1470: ( p_count => x_msg_count,
1471: p_data => x_msg_data
1472: );
1473: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1474: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1475: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_Repair_History',
1476: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
1477: END IF;

Line 1474: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

1470: ( p_count => x_msg_count,
1471: p_data => x_msg_data
1472: );
1473: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1474: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1475: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_Repair_History',
1476: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
1477: END IF;
1478: WHEN OTHERS THEN

Line 1493: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1489: FND_MSG_PUB.Count_And_Get
1490: ( p_count => x_msg_count,
1491: p_data => x_msg_data
1492: );
1493: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1494: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1495: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_Repair_History',
1496: 'SQL Message ['||sqlerrm||']');
1497: END IF;

Line 1494: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

1490: ( p_count => x_msg_count,
1491: p_data => x_msg_data
1492: );
1493: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1494: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1495: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_Repair_History',
1496: 'SQL Message ['||sqlerrm||']');
1497: END IF;
1498:

Line 1518: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1514: , attribute7, attribute8, attribute9, attribute10, attribute11, attribute12, attribute13, attribute14, attribute15
1515: FROM csd_repair_history
1516: WHERE repair_history_id = p_original_repair_history_id;
1517:
1518: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1519: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1520: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1521: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1522:

Line 1519: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1515: FROM csd_repair_history
1516: WHERE repair_history_id = p_original_repair_history_id;
1517:
1518: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1519: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1520: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1521: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1522:
1523: begin

Line 1520: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1516: WHERE repair_history_id = p_original_repair_history_id;
1517:
1518: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1519: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1520: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1521: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1522:
1523: begin
1524:

Line 1521: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;

1517:
1518: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1519: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1520: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1521: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1522:
1523: begin
1524:
1525: -- Initialize API return status to success

Line 1580: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1576:
1577: l_api_name CONSTANT VARCHAR2(30) := 'Copy_JTF_Notes' ;
1578: l_jtf_note_contexts_tab JTF_NOTES_PUB.jtf_note_contexts_tbl_type;
1579: l_jtf_note_id NUMBER;
1580: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1581: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1582: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1583: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1584:

Line 1581: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1577: l_api_name CONSTANT VARCHAR2(30) := 'Copy_JTF_Notes' ;
1578: l_jtf_note_contexts_tab JTF_NOTES_PUB.jtf_note_contexts_tbl_type;
1579: l_jtf_note_id NUMBER;
1580: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1581: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1582: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1583: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1584:
1585:

Line 1582: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1578: l_jtf_note_contexts_tab JTF_NOTES_PUB.jtf_note_contexts_tbl_type;
1579: l_jtf_note_id NUMBER;
1580: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1581: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1582: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1583: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1584:
1585:
1586: CURSOR c_jtf_note_id (p_original_repair_line_id IN NUMBER) IS

Line 1583: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;

1579: l_jtf_note_id NUMBER;
1580: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1581: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1582: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1583: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1584:
1585:
1586: CURSOR c_jtf_note_id (p_original_repair_line_id IN NUMBER) IS
1587: SELECT notes, note_status, note_type, entered_by, entered_date, creation_date, created_by,

Line 1656: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.JTF_NOTES_PUB.create_note','failed');

1652: );
1653:
1654: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1655: IF(l_statement_level >= l_debug_level) THEN
1656: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.JTF_NOTES_PUB.create_note','failed');
1657: END IF;
1658: RAISE FND_API.G_EXC_ERROR;
1659: END IF;
1660:

Line 1688: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1684: FND_MSG_PUB.Count_And_Get
1685: ( p_count => x_msg_count,
1686: p_data => x_msg_data
1687: );
1688: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1689: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1690: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_JTF_Notes',
1691: 'EXC_ERROR ['||x_msg_data||']');
1692: END IF;

Line 1689: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

1685: ( p_count => x_msg_count,
1686: p_data => x_msg_data
1687: );
1688: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1689: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1690: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_JTF_Notes',
1691: 'EXC_ERROR ['||x_msg_data||']');
1692: END IF;
1693: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1700: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1696: FND_MSG_PUB.Count_And_Get
1697: ( p_count => x_msg_count,
1698: p_data => x_msg_data
1699: );
1700: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1701: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1702: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_JTF_Notes',
1703: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
1704: END IF;

Line 1701: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

1697: ( p_count => x_msg_count,
1698: p_data => x_msg_data
1699: );
1700: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1701: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1702: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_JTF_Notes',
1703: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
1704: END IF;
1705: WHEN OTHERS THEN

Line 1720: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1716: FND_MSG_PUB.Count_And_Get
1717: ( p_count => x_msg_count,
1718: p_data => x_msg_data
1719: );
1720: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1721: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1722: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_JTF_Notes',
1723: 'SQL Message ['||sqlerrm||']');
1724: END IF;

Line 1721: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

1717: ( p_count => x_msg_count,
1718: p_data => x_msg_data
1719: );
1720: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1721: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1722: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_JTF_Notes',
1723: 'SQL Message ['||sqlerrm||']');
1724: END IF;
1725: End Copy_JTF_Notes;

Line 1755: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1751: l_cps_txn_billing_type_id NUMBER := NULL;
1752: l_cpr_txn_billing_type_id NUMBER := NULL;
1753: l_ls_txn_billing_type_id NUMBER := NULL;
1754: l_lr_txn_billing_type_id NUMBER := NULL;
1755: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1756: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1757: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1758: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1759:

Line 1756: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1752: l_cpr_txn_billing_type_id NUMBER := NULL;
1753: l_ls_txn_billing_type_id NUMBER := NULL;
1754: l_lr_txn_billing_type_id NUMBER := NULL;
1755: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1756: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1757: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1758: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1759:
1760: l_po_number VARCHAR2(50); -- swai bug fix 4535829

Line 1757: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1753: l_ls_txn_billing_type_id NUMBER := NULL;
1754: l_lr_txn_billing_type_id NUMBER := NULL;
1755: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1756: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1757: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1758: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1759:
1760: l_po_number VARCHAR2(50); -- swai bug fix 4535829
1761: l_project_id NUMBER := null;

Line 1758: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;

1754: l_lr_txn_billing_type_id NUMBER := NULL;
1755: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1756: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1757: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1758: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1759:
1760: l_po_number VARCHAR2(50); -- swai bug fix 4535829
1761: l_project_id NUMBER := null;
1762: l_task_id NUMBER := null;