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 531: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

527: ,attribute30
528: FROM csd_repairs
529: where repair_line_id = p_repair_line_id;
530:
531: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
532: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
533: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
534: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
535:

Line 532: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

Line 533: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

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

Line 534: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;

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

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

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

Line 707: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 708: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

Line 709: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

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

Line 710: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;

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

Line 845: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 846: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

Line 847: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

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

Line 848: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;

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

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

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

Line 1011: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

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

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

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

Line 1023: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

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

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

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

Line 1043: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

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

Line 1076: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 1077: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

Line 1078: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

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

Line 1079: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1314: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

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

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

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

Line 1326: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

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

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

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

Line 1346: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

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

Line 1370: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 1371: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

Line 1372: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

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

Line 1373: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;

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

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

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

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

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

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

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

Line 1460: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

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

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

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

Line 1472: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

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

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

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

Line 1492: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

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

Line 1516: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 1517: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

Line 1518: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

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

Line 1519: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;

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

Line 1578: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 1579: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

Line 1580: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

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

Line 1581: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;

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

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

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

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

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

Line 1687: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

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

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

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

Line 1699: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

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

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

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

Line 1719: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

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

Line 1753: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 1754: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

Line 1755: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

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

Line 1756: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;

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