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_RECALLS_PVT dependencies on FND_LOG

Line 13: G_LEVEL_PROCEDURE NUMBER := FND_LOG.LEVEL_PROCEDURE;

9: -- NOTE :
10: -- End of Comments
11:
12: -- logging globals.
13: G_LEVEL_PROCEDURE NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: G_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
15:
16: G_RET_STS_SUCCESS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
17: -- Cache to hold the default bill to and ship to use id's for an customer.

Line 14: G_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

10: -- End of Comments
11:
12: -- logging globals.
13: G_LEVEL_PROCEDURE NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: G_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
15:
16: G_RET_STS_SUCCESS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
17: -- Cache to hold the default bill to and ship to use id's for an customer.
18: -- this prevents re-executing SQL over and over again.

Line 81: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin PROCESS_POST_WIP_MASSLOAD API');

77:
78: SAVEPOINT process_post_wip_massload;
79:
80: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
81: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin PROCESS_POST_WIP_MASSLOAD API');
82: END IF;
83:
84: SELECT crl.repair_line_id,
85: wdj.wip_entity_id,

Line 114: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'After bulk collect, count = '||l_post_wipml_tbl.COUNT);

110: AND msi.inventory_item_id = crl.inventory_item_id
111: AND crl.instance_id = cii.instance_id;
112:
113: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
114: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'After bulk collect, count = '||l_post_wipml_tbl.COUNT);
115: END IF;
116:
117: IF l_post_wipml_tbl.COUNT = 0
118: THEN

Line 256: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin upgrade item processing');

252: THEN
253: -- check if the operation exists.
254: BEGIN
255: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
256: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin upgrade item processing');
257: END IF;
258:
259: BEGIN
260: SELECT MIN(operation_seq_num)

Line 273: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'No operations found, proceeding to create one.');

269: IF l_operation_seq_num = 0
270: THEN
271: -- create new operation.
272: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
273: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'No operations found, proceeding to create one.');
274: END IF;
275: IF l_department_id IS NULL
276: THEN
277: SELECT department_id, supply_subinventory

Line 296: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling CSD_HV_WIP_JOB_PVT.PROCESS_SAVE_OP_DTLS');

292: l_op_dtls_tbl(1).last_unit_start_date := sysdate;
293: l_op_dtls_tbl(1).minimum_transfer_quantity := 0;
294:
295: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
296: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling CSD_HV_WIP_JOB_PVT.PROCESS_SAVE_OP_DTLS');
297: END IF;
298:
299: CSD_HV_WIP_JOB_PVT.PROCESS_SAVE_OP_DTLS
300: (

Line 339: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'No data found error. Missing default dept or default supply subinventory');

335: END IF;
336: EXCEPTION
337: WHEN no_data_found THEN
338: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
339: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'No data found error. Missing default dept or default supply subinventory');
340: END IF;
341: END;
342: END IF;
343: END LOOP;

Line 493: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin GENERATE_RECALL_WORK API');

489:
490: SAVEPOINT GENERATE_RECALL_WORK;
491:
492: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
493: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin GENERATE_RECALL_WORK API');
494: END IF;
495:
496: -- standard check for API compatibility.
497: IF NOT Fnd_Api.Compatible_API_Call

Line 513: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_sr_type_id = '||p_sr_type_id);

509: END IF;
510:
511: -- log api params.
512: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
513: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_sr_type_id = '||p_sr_type_id);
514: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_ro_type_id = '||p_ro_type_id);
515: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_service_code_id = '||p_service_code_id);
516: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_wip_accounting_class = '||p_wip_accounting_class);
517: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_upgrade_item_id = '||p_upgrade_item_id);

Line 514: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_ro_type_id = '||p_ro_type_id);

510:
511: -- log api params.
512: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
513: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_sr_type_id = '||p_sr_type_id);
514: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_ro_type_id = '||p_ro_type_id);
515: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_service_code_id = '||p_service_code_id);
516: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_wip_accounting_class = '||p_wip_accounting_class);
517: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_upgrade_item_id = '||p_upgrade_item_id);
518: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_wip_inv_org_id = '||p_wip_inv_org_id);

Line 515: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_service_code_id = '||p_service_code_id);

511: -- log api params.
512: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
513: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_sr_type_id = '||p_sr_type_id);
514: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_ro_type_id = '||p_ro_type_id);
515: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_service_code_id = '||p_service_code_id);
516: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_wip_accounting_class = '||p_wip_accounting_class);
517: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_upgrade_item_id = '||p_upgrade_item_id);
518: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_wip_inv_org_id = '||p_wip_inv_org_id);
519: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_recall_number = '||p_recall_number);

Line 516: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_wip_accounting_class = '||p_wip_accounting_class);

512: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
513: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_sr_type_id = '||p_sr_type_id);
514: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_ro_type_id = '||p_ro_type_id);
515: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_service_code_id = '||p_service_code_id);
516: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_wip_accounting_class = '||p_wip_accounting_class);
517: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_upgrade_item_id = '||p_upgrade_item_id);
518: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_wip_inv_org_id = '||p_wip_inv_org_id);
519: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_recall_number = '||p_recall_number);
520: FOR l_counter IN 1 ..p_recall_line_ids.COUNT

Line 517: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_upgrade_item_id = '||p_upgrade_item_id);

513: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_sr_type_id = '||p_sr_type_id);
514: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_ro_type_id = '||p_ro_type_id);
515: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_service_code_id = '||p_service_code_id);
516: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_wip_accounting_class = '||p_wip_accounting_class);
517: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_upgrade_item_id = '||p_upgrade_item_id);
518: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_wip_inv_org_id = '||p_wip_inv_org_id);
519: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_recall_number = '||p_recall_number);
520: FOR l_counter IN 1 ..p_recall_line_ids.COUNT
521: LOOP

Line 518: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_wip_inv_org_id = '||p_wip_inv_org_id);

514: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_ro_type_id = '||p_ro_type_id);
515: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_service_code_id = '||p_service_code_id);
516: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_wip_accounting_class = '||p_wip_accounting_class);
517: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_upgrade_item_id = '||p_upgrade_item_id);
518: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_wip_inv_org_id = '||p_wip_inv_org_id);
519: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_recall_number = '||p_recall_number);
520: FOR l_counter IN 1 ..p_recall_line_ids.COUNT
521: LOOP
522: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'recall_line_id'||l_counter||' = '||p_recall_line_ids(l_counter));

Line 519: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_recall_number = '||p_recall_number);

515: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_service_code_id = '||p_service_code_id);
516: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_wip_accounting_class = '||p_wip_accounting_class);
517: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_upgrade_item_id = '||p_upgrade_item_id);
518: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_wip_inv_org_id = '||p_wip_inv_org_id);
519: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_recall_number = '||p_recall_number);
520: FOR l_counter IN 1 ..p_recall_line_ids.COUNT
521: LOOP
522: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'recall_line_id'||l_counter||' = '||p_recall_line_ids(l_counter));
523: END LOOP;

Line 522: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'recall_line_id'||l_counter||' = '||p_recall_line_ids(l_counter));

518: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_wip_inv_org_id = '||p_wip_inv_org_id);
519: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'p_recall_number = '||p_recall_number);
520: FOR l_counter IN 1 ..p_recall_line_ids.COUNT
521: LOOP
522: fnd_log.string(G_LEVEL_PROCEDURE,lc_api_name,'recall_line_id'||l_counter||' = '||p_recall_line_ids(l_counter));
523: END LOOP;
524: END IF;
525:
526: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN

Line 527: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Update the recall lines as processing');

523: END LOOP;
524: END IF;
525:
526: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
527: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Update the recall lines as processing');
528: END IF;
529:
530: SELECT csd_recall_lines_group_s1.NEXTVAL INTO l_group_id FROM dual;
531:

Line 541: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Before launching the CP');

537: COMMIT;
538:
539: -- submit the concurrent request.
540: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
541: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Before launching the CP');
542: END IF;
543:
544: x_request_id := fnd_request.submit_request(application => 'CSD',
545: program => 'CSDRCLWK',

Line 558: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in launching CP');

554: IF (x_request_id IS NULL OR x_request_id <= 0)
555: THEN
556: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL)
557: THEN
558: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in launching CP');
559: END IF;
560:
561: UPDATE CSD_RECALL_LINES crl SET processing_flag = 'N'
562: WHERE crl.recall_line_id IN (SELECT * FROM TABLE(CAST(p_recall_line_ids as JTF_NUMBER_TABLE)))

Line 576: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Unexpected error, could not submit the request');

572: COMMIT;
573: EXCEPTION
574: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
575: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
576: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Unexpected error, could not submit the request');
577: END IF;
578: -- to do. get the fnd messages.
579: WHEN OTHERS THEN
580: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN

Line 581: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'WHEN OTHERS '||SQLERRM);

577: END IF;
578: -- to do. get the fnd messages.
579: WHEN OTHERS THEN
580: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
581: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'WHEN OTHERS '||SQLERRM);
582: END IF;
583: RAISE;
584: END GENERATE_RECALL_WORK;
585:

Line 665: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Post wip mass load');

661: BEGIN
662: IF fnd_conc_global.request_data IS NOT NULL
663: THEN
664: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
665: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Post wip mass load');
666: END IF;
667: l_rec_group_id := TO_NUMBER(SUBSTR(fnd_conc_global.request_data,0,INSTR(fnd_conc_global.request_data,',')-1));
668: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
669: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Step1');

Line 669: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Step1');

665: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Post wip mass load');
666: END IF;
667: l_rec_group_id := TO_NUMBER(SUBSTR(fnd_conc_global.request_data,0,INSTR(fnd_conc_global.request_data,',')-1));
668: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
669: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Step1');
670: END IF;
671: l_temp := SUBSTR(fnd_conc_global.request_data,INSTR(fnd_conc_global.request_data,',')+1);
672: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
673: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Step2');

Line 673: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Step2');

669: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Step1');
670: END IF;
671: l_temp := SUBSTR(fnd_conc_global.request_data,INSTR(fnd_conc_global.request_data,',')+1);
672: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
673: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Step2');
674: END IF;
675: l_req_group_id := TO_NUMBER(SUBSTR(l_temp,0,INSTR(l_temp,',')-1));
676: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
677: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Step3');

Line 677: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Step3');

673: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Step2');
674: END IF;
675: l_req_group_id := TO_NUMBER(SUBSTR(l_temp,0,INSTR(l_temp,',')-1));
676: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
677: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Step3');
678: END IF;
679: l_temp := SUBSTR(l_temp,INSTR(l_temp,',')+1);
680:
681: g_sc_id := TO_NUMBER(SUBSTR(l_temp,0,INSTR(l_temp,',')-1));

Line 696: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin PROCESS_RECALL_WORK API');

692:
693: SAVEPOINT PROCESS_RECALL_WORK;
694:
695: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
696: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin PROCESS_RECALL_WORK API');
697: END IF;
698:
699: OPEN eligible_lines;
700: FETCH eligible_lines BULK COLLECT INTO l_csd_recall_lines_tbl;

Line 716: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Getting the bill to and ship to site from cache');

712: -- get the bill to site use id and ship to site use id.
713: IF g_csd_shipto_billto_cache.EXISTS(l_csd_recall_lines_tbl(l_index).owner_party_id)
714: THEN
715: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
716: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Getting the bill to and ship to site from cache');
717: END IF;
718: l_service_request_rec.bill_to_site_use_id :=
719: g_csd_shipto_billto_cache(l_csd_recall_lines_tbl(l_index).owner_party_id).bill_to_site_use_id;
720: l_service_request_rec.ship_to_site_use_id :=

Line 726: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Getting bill to and ship to site.');

722: l_service_request_rec.caller_type :=
723: g_csd_shipto_billto_cache(l_csd_recall_lines_tbl(l_index).owner_party_id).caller_type;
724: ELSE
725: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
726: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Getting bill to and ship to site.');
727: END IF;
728: SELECT hpu.party_site_use_id,
729: hpu1.party_site_use_id
730: INTO g_csd_shipto_billto_cache(l_csd_recall_lines_tbl(l_index).owner_party_id).bill_to_site_use_id,

Line 820: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Before calling CSD_PROCESS_PVT.process_service_request');

816: g_sr_params_cached := true;
817: END IF;
818:
819: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
820: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Before calling CSD_PROCESS_PVT.process_service_request');
821: END IF;
822:
823: -- call service request API.
824: CSD_PROCESS_PVT.process_service_request

Line 842: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in CSD_PROCESS_PVT.process_service_request '||x_msg_data);

838: );
839: IF NOT G_RET_STS_SUCCESS = x_return_status
840: THEN
841: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
842: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in CSD_PROCESS_PVT.process_service_request '||x_msg_data);
843: END IF;
844: -- write the error msg to fnd_log.out stream.
845: csd_bulk_receive_util.write_to_conc_log(p_msg_count => x_msg_count,
846: p_msg_data => x_msg_data);

Line 844: -- write the error msg to fnd_log.out stream.

840: THEN
841: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
842: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in CSD_PROCESS_PVT.process_service_request '||x_msg_data);
843: END IF;
844: -- write the error msg to fnd_log.out stream.
845: csd_bulk_receive_util.write_to_conc_log(p_msg_count => x_msg_count,
846: p_msg_data => x_msg_data);
847: RAISE fnd_api.g_exc_error;
848: END IF;

Line 899: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling csd_repairs_util.get_entitlements for contract info');

895: AND rownum < 2;
896: END IF;
897:
898: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
899: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling csd_repairs_util.get_entitlements for contract info');
900: END IF;
901:
902: csd_repairs_util.get_entitlements(
903: p_api_version_number => 1.0,

Line 984: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling Create_Repair_Order for creating RO');

980: x_repair_line_id := null;
981:
982: -- call create repair order PVT API.
983: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
984: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling Create_Repair_Order for creating RO');
985: END IF;
986: CSD_REPAIRS_PVT.Create_Repair_Order(
987: p_api_version_number => 1.0,
988: p_commit => fnd_api.g_false,

Line 1002: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in Create_Repair_Order '||x_msg_data);

998:
999: IF NOT G_RET_STS_SUCCESS = x_return_status
1000: THEN
1001: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1002: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in Create_Repair_Order '||x_msg_data);
1003: END IF;
1004: -- write the error msg to fnd_log.out stream.
1005: csd_bulk_receive_util.write_to_conc_log(p_msg_count => x_msg_count,
1006: p_msg_data => x_msg_data);

Line 1004: -- write the error msg to fnd_log.out stream.

1000: THEN
1001: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1002: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in Create_Repair_Order '||x_msg_data);
1003: END IF;
1004: -- write the error msg to fnd_log.out stream.
1005: csd_bulk_receive_util.write_to_conc_log(p_msg_count => x_msg_count,
1006: p_msg_data => x_msg_data);
1007: RAISE fnd_api.g_exc_error;
1008: END IF;

Line 1175: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Exc error '||x_msg_data);

1171:
1172: EXCEPTION
1173: WHEN fnd_api.g_exc_error THEN
1174: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1175: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Exc error '||x_msg_data);
1176: END IF;
1177: errbuf := x_msg_data;
1178: retcode := 2;
1179: ROLLBACK TO PROCESS_RECALL_WORK;

Line 1186: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'When Others '||SQLERRM);

1182: WHERE processing_group_id = p_group_id;
1183: COMMIT;
1184: WHEN OTHERS THEN
1185: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1186: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'When Others '||SQLERRM);
1187: END IF;
1188: ROLLBACK;
1189: errbuf := x_msg_data;
1190: retcode := 2;

Line 1195: -- write the error msg to fnd_log.out stream.

1191: -- clean up the processing flag.
1192: UPDATE csd_recall_lines SET processing_flag = 'N'
1193: WHERE processing_group_id = p_group_id;
1194: COMMIT;
1195: -- write the error msg to fnd_log.out stream.
1196: csd_bulk_receive_util.write_to_conc_log(p_msg_count => x_msg_count,
1197: p_msg_data => x_msg_data);
1198: RAISE;
1199: