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_API

Line 16: G_RET_STS_SUCCESS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

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.
19: g_csd_shipto_billto_cache csd_shipto_billto_tbl;
20:

Line 127: p_init_msg_list => fnd_api.g_false,

123: FOR i IN 1 ..l_post_wipml_tbl.COUNT
124: LOOP
125: csd_to_form_repair_job_xref.validate_and_write(
126: p_api_version_number => 1.0,
127: p_init_msg_list => fnd_api.g_false,
128: p_commit => fnd_api.g_false,
129: p_validation_level => NULL,
130: p_action_code => 0,
131: px_repair_job_xref_id => x_job_xref_id,

Line 128: p_commit => fnd_api.g_false,

124: LOOP
125: csd_to_form_repair_job_xref.validate_and_write(
126: p_api_version_number => 1.0,
127: p_init_msg_list => fnd_api.g_false,
128: p_commit => fnd_api.g_false,
129: p_validation_level => NULL,
130: p_action_code => 0,
131: px_repair_job_xref_id => x_job_xref_id,
132: p_created_by => l_user_id,

Line 171: RAISE fnd_api.g_exc_error;

167: x_msg_count => x_msg_count,
168: x_msg_data => x_msg_data);
169: IF x_return_status <> g_ret_sts_success
170: THEN
171: RAISE fnd_api.g_exc_error;
172: END IF;
173:
174: csd_to_form_repair_history.validate_and_write(
175: p_api_version_number => 1.0,

Line 176: p_init_msg_list => fnd_api.g_false,

172: END IF;
173:
174: csd_to_form_repair_history.validate_and_write(
175: p_api_version_number => 1.0,
176: p_init_msg_list => fnd_api.g_false,
177: p_commit => fnd_api.g_false,
178: p_validation_level => NULL,
179: p_action_code => 0,
180: px_repair_history_id => l_rep_hist_id,

Line 177: p_commit => fnd_api.g_false,

173:
174: csd_to_form_repair_history.validate_and_write(
175: p_api_version_number => 1.0,
176: p_init_msg_list => fnd_api.g_false,
177: p_commit => fnd_api.g_false,
178: p_validation_level => NULL,
179: p_action_code => 0,
180: px_repair_history_id => l_rep_hist_id,
181: p_OBJECT_VERSION_NUMBER => NULL,

Line 246: RAISE fnd_api.g_exc_error;

242: x_msg_data => x_msg_data);
243:
244: IF x_return_status <> g_ret_sts_success
245: THEN
246: RAISE fnd_api.g_exc_error;
247: END IF;
248:
249: l_default_ro_item := nvl(FND_PROFILE.VALUE('CSD_DEFAULT_RO_ITEM_AS_MATERIAL_ON_JOB'), 'N');
250:

Line 302: p_init_msg_list => fnd_api.g_false,

298:
299: CSD_HV_WIP_JOB_PVT.PROCESS_SAVE_OP_DTLS
300: (
301: p_api_version_number => 1.0,
302: p_init_msg_list => fnd_api.g_false,
303: p_Commit => fnd_api.g_false,
304: p_validation_level => 100,
305: x_return_status => x_return_status,
306: x_msg_count => x_msg_count,

Line 303: p_Commit => fnd_api.g_false,

299: CSD_HV_WIP_JOB_PVT.PROCESS_SAVE_OP_DTLS
300: (
301: p_api_version_number => 1.0,
302: p_init_msg_list => fnd_api.g_false,
303: p_Commit => fnd_api.g_false,
304: p_validation_level => 100,
305: x_return_status => x_return_status,
306: x_msg_count => x_msg_count,
307: x_msg_data => x_msg_data,

Line 349: p_init_msg_list => fnd_api.g_false,

345: -- call the hvr save mtl_transactions API.
346: CSD_HV_WIP_JOB_PVT.PROCESS_SAVE_MTL_TXN_DTLS
347: (
348: p_api_version_number => 1.0,
349: p_init_msg_list => fnd_api.g_false,
350: p_Commit => fnd_api.g_false,
351: p_validation_level => 100,
352: x_return_status => x_return_status,
353: x_msg_count => x_msg_count,

Line 350: p_Commit => fnd_api.g_false,

346: CSD_HV_WIP_JOB_PVT.PROCESS_SAVE_MTL_TXN_DTLS
347: (
348: p_api_version_number => 1.0,
349: p_init_msg_list => fnd_api.g_false,
350: p_Commit => fnd_api.g_false,
351: p_validation_level => 100,
352: x_return_status => x_return_status,
353: x_msg_count => x_msg_count,
354: x_msg_data => x_msg_data,

Line 360: WHEN fnd_api.g_exc_error THEN

356: x_op_created => x_op_created
357: );
358:
359: EXCEPTION
360: WHEN fnd_api.g_exc_error THEN
361: ROLLBACK TO process_post_wip_massload;
362:
363: WHEN OTHERS THEN
364: ROLLBACK TO process_post_wip_massload;

Line 466: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

462: /*-- History: 24/03/2010, Created by Sudheer Bhat. */
463: /****************************************************************************************/
464:
465: PROCEDURE GENERATE_RECALL_WORK (p_api_version IN NUMBER,
466: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
467: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
468: p_recall_line_ids IN JTF_NUMBER_TABLE,
469: p_sr_type_id IN NUMBER,
470: p_ro_type_id IN NUMBER DEFAULT NULL,

Line 467: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

463: /****************************************************************************************/
464:
465: PROCEDURE GENERATE_RECALL_WORK (p_api_version IN NUMBER,
466: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
467: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
468: p_recall_line_ids IN JTF_NUMBER_TABLE,
469: p_sr_type_id IN NUMBER,
470: p_ro_type_id IN NUMBER DEFAULT NULL,
471: p_service_code_id IN NUMBER DEFAULT NULL,

Line 497: IF NOT Fnd_Api.Compatible_API_Call

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
498: (lc_api_version,
499: p_api_version,
500: lc_api_name,
501: G_PKG_NAME)

Line 503: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

499: p_api_version,
500: lc_api_name,
501: G_PKG_NAME)
502: THEN
503: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
504: END IF;
505:
506: IF Fnd_Api.to_Boolean(p_init_msg_list)
507: THEN

Line 506: IF Fnd_Api.to_Boolean(p_init_msg_list)

502: THEN
503: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
504: END IF;
505:
506: IF Fnd_Api.to_Boolean(p_init_msg_list)
507: THEN
508: Fnd_Msg_Pub.initialize;
509: END IF;
510:

Line 569: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

565:
566: COMMIT;
567: -- to do.
568: -- add a message.
569: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
570: END IF;
571:
572: COMMIT;
573: EXCEPTION

Line 574: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

570: END IF;
571:
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.

Line 826: p_commit => fnd_api.g_false,

822:
823: -- call service request API.
824: CSD_PROCESS_PVT.process_service_request
825: ( p_api_version => 1.0,
826: p_commit => fnd_api.g_false,
827: p_init_msg_list => fnd_api.g_true,
828: p_validation_level => fnd_api.g_valid_level_full,
829: p_action => 'CREATE',
830: p_incident_id => NULL,

Line 827: p_init_msg_list => fnd_api.g_true,

823: -- call service request API.
824: CSD_PROCESS_PVT.process_service_request
825: ( p_api_version => 1.0,
826: p_commit => fnd_api.g_false,
827: p_init_msg_list => fnd_api.g_true,
828: p_validation_level => fnd_api.g_valid_level_full,
829: p_action => 'CREATE',
830: p_incident_id => NULL,
831: p_service_request_rec => l_service_request_rec,

Line 828: p_validation_level => fnd_api.g_valid_level_full,

824: CSD_PROCESS_PVT.process_service_request
825: ( p_api_version => 1.0,
826: p_commit => fnd_api.g_false,
827: p_init_msg_list => fnd_api.g_true,
828: p_validation_level => fnd_api.g_valid_level_full,
829: p_action => 'CREATE',
830: p_incident_id => NULL,
831: p_service_request_rec => l_service_request_rec,
832: p_notes_tbl => l_sr_notes_tbl,

Line 847: RAISE fnd_api.g_exc_error;

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;
849: l_csd_recall_lines_tbl(l_index).incident_id := x_incident_id;
850:
851: UPDATE csd_recall_lines SET incident_id = x_incident_id

Line 904: p_init_msg_list => fnd_api.g_false,

900: END IF;
901:
902: csd_repairs_util.get_entitlements(
903: p_api_version_number => 1.0,
904: p_init_msg_list => fnd_api.g_false,
905: p_commit => fnd_api.g_false,
906: p_contract_number => null,
907: p_service_line_id => null,
908: p_customer_id => l_csd_recall_lines_tbl(l_index).owner_party_id ,

Line 905: p_commit => fnd_api.g_false,

901:
902: csd_repairs_util.get_entitlements(
903: p_api_version_number => 1.0,
904: p_init_msg_list => fnd_api.g_false,
905: p_commit => fnd_api.g_false,
906: p_contract_number => null,
907: p_service_line_id => null,
908: p_customer_id => l_csd_recall_lines_tbl(l_index).owner_party_id ,
909: p_site_id => g_csd_shipto_billto_cache(l_csd_recall_lines_tbl(l_index).owner_party_id).ship_to_site_use_id,

Line 936: p_init_msg_list => fnd_api.g_false,

932: -- get the pricelist and currency.
933:
934: csd_process_util.get_ro_default_curr_pl(
935: p_api_version => 1.0,
936: p_init_msg_list => fnd_api.g_false,
937: p_incident_id => x_incident_id,
938: p_repair_type_id => p_ro_type_id,
939: p_ro_contract_line_id => l_repln_rec.contract_line_id,
940: x_contract_pl_id => l_contract_pl_id,

Line 958: l_repln_rec.inventory_org_id := fnd_api.g_miss_num;

954: l_repln_rec.currency_code := l_currency_code;
955:
956: -- set below attributes as g_miss_*. So that defaulting engine can act in the
957: -- PVT API.
958: l_repln_rec.inventory_org_id := fnd_api.g_miss_num;
959: l_repln_rec.resource_group := fnd_api.g_miss_num;
960: l_repln_rec.ro_priority_code := fnd_api.g_miss_char;
961: l_repln_rec.resource_id := fnd_api.g_miss_num;
962:

Line 959: l_repln_rec.resource_group := fnd_api.g_miss_num;

955:
956: -- set below attributes as g_miss_*. So that defaulting engine can act in the
957: -- PVT API.
958: l_repln_rec.inventory_org_id := fnd_api.g_miss_num;
959: l_repln_rec.resource_group := fnd_api.g_miss_num;
960: l_repln_rec.ro_priority_code := fnd_api.g_miss_char;
961: l_repln_rec.resource_id := fnd_api.g_miss_num;
962:
963: l_repln_rec.incident_id := NVL(x_incident_id,l_csd_recall_lines_tbl(l_index).incident_id);

Line 960: l_repln_rec.ro_priority_code := fnd_api.g_miss_char;

956: -- set below attributes as g_miss_*. So that defaulting engine can act in the
957: -- PVT API.
958: l_repln_rec.inventory_org_id := fnd_api.g_miss_num;
959: l_repln_rec.resource_group := fnd_api.g_miss_num;
960: l_repln_rec.ro_priority_code := fnd_api.g_miss_char;
961: l_repln_rec.resource_id := fnd_api.g_miss_num;
962:
963: l_repln_rec.incident_id := NVL(x_incident_id,l_csd_recall_lines_tbl(l_index).incident_id);
964: l_repln_rec.customer_product_id := l_csd_recall_lines_tbl(l_index).instance_id;

Line 961: l_repln_rec.resource_id := fnd_api.g_miss_num;

957: -- PVT API.
958: l_repln_rec.inventory_org_id := fnd_api.g_miss_num;
959: l_repln_rec.resource_group := fnd_api.g_miss_num;
960: l_repln_rec.ro_priority_code := fnd_api.g_miss_char;
961: l_repln_rec.resource_id := fnd_api.g_miss_num;
962:
963: l_repln_rec.incident_id := NVL(x_incident_id,l_csd_recall_lines_tbl(l_index).incident_id);
964: l_repln_rec.customer_product_id := l_csd_recall_lines_tbl(l_index).instance_id;
965: l_repln_rec.auto_process_rma := g_auto_process_rma;

Line 988: p_commit => fnd_api.g_false,

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,
989: p_init_msg_list => fnd_api.g_true,
990: p_validation_level => fnd_api.g_valid_level_full,
991: p_repair_line_id => x_repair_line_id,
992: p_Repln_Rec => l_repln_rec,

Line 989: p_init_msg_list => fnd_api.g_true,

985: END IF;
986: CSD_REPAIRS_PVT.Create_Repair_Order(
987: p_api_version_number => 1.0,
988: p_commit => fnd_api.g_false,
989: p_init_msg_list => fnd_api.g_true,
990: p_validation_level => fnd_api.g_valid_level_full,
991: p_repair_line_id => x_repair_line_id,
992: p_Repln_Rec => l_repln_rec,
993: x_repair_line_id => x_repair_line_id,

Line 990: p_validation_level => fnd_api.g_valid_level_full,

986: CSD_REPAIRS_PVT.Create_Repair_Order(
987: p_api_version_number => 1.0,
988: p_commit => fnd_api.g_false,
989: p_init_msg_list => fnd_api.g_true,
990: p_validation_level => fnd_api.g_valid_level_full,
991: p_repair_line_id => x_repair_line_id,
992: p_Repln_Rec => l_repln_rec,
993: x_repair_line_id => x_repair_line_id,
994: x_repair_number => x_repair_number,

Line 1007: RAISE fnd_api.g_exc_error;

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;
1009:
1010: l_csd_recall_lines_tbl(l_index).repair_line_id := x_repair_line_id;
1011:

Line 1019: p_commit => fnd_api.g_false,

1015:
1016: -- default logistics lines.
1017: csd_process_pvt.create_default_prod_txn
1018: (p_api_version => 1.0,
1019: p_commit => fnd_api.g_false,
1020: p_init_msg_list => fnd_api.g_true,
1021: p_validation_level => fnd_api.g_valid_level_full,
1022: p_repair_line_id => x_repair_line_id,
1023: x_return_status => x_return_status,

Line 1020: p_init_msg_list => fnd_api.g_true,

1016: -- default logistics lines.
1017: csd_process_pvt.create_default_prod_txn
1018: (p_api_version => 1.0,
1019: p_commit => fnd_api.g_false,
1020: p_init_msg_list => fnd_api.g_true,
1021: p_validation_level => fnd_api.g_valid_level_full,
1022: p_repair_line_id => x_repair_line_id,
1023: x_return_status => x_return_status,
1024: x_msg_count => x_msg_count,

Line 1021: p_validation_level => fnd_api.g_valid_level_full,

1017: csd_process_pvt.create_default_prod_txn
1018: (p_api_version => 1.0,
1019: p_commit => fnd_api.g_false,
1020: p_init_msg_list => fnd_api.g_true,
1021: p_validation_level => fnd_api.g_valid_level_full,
1022: p_repair_line_id => x_repair_line_id,
1023: x_return_status => x_return_status,
1024: x_msg_count => x_msg_count,
1025: x_msg_data => x_msg_data);

Line 1173: WHEN fnd_api.g_exc_error THEN

1169: fnd_conc_global.set_req_globals(conc_status => 'PAUSED',
1170: request_data => TO_CHAR(p_group_id)||','||TO_CHAR(l_group_id)||','||TO_CHAR(p_service_code_id)||','||TO_CHAR(p_upgrade_item_id));
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;