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.CSF_PREVENTIVE_MAINTENANCE_PVT dependencies on FND_API

Line 268: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

264: -- Standard Start of API savepoint
265: SAVEPOINT Generate_SR_Tasks_PVT;
266:
267: -- Standard call to check for call compatibility.
268: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
269: p_api_version_number,
270: l_api_name,
271: G_PKG_NAME)
272: THEN

Line 273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

269: p_api_version_number,
270: l_api_name,
271: G_PKG_NAME)
272: THEN
273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
274: END IF;
275:
276:
277: -- Initialize message list

Line 282: x_return_status := FND_API.G_RET_STS_SUCCESS;

278: FND_MSG_PUB.initialize;
279:
280:
281: -- Initialize API return status to SUCCESS
282: x_return_status := FND_API.G_RET_STS_SUCCESS;
283:
284:
285: --
286: -- API body

Line 438: p_init_msg_list => FND_API.G_FALSE,

434: IF (nvl(l_primary_contact,'N') = 'N') THEN
435:
436: cs_servicerequest_pub.Create_ServiceRequest
437: ( p_api_version => 3.0,
438: p_init_msg_list => FND_API.G_FALSE,
439: p_commit => FND_API.G_FALSE,
440: x_return_status => x_return_status,
441: x_msg_count => x_msg_count,
442: x_msg_data => x_msg_data,

Line 439: p_commit => FND_API.G_FALSE,

435:
436: cs_servicerequest_pub.Create_ServiceRequest
437: ( p_api_version => 3.0,
438: p_init_msg_list => FND_API.G_FALSE,
439: p_commit => FND_API.G_FALSE,
440: x_return_status => x_return_status,
441: x_msg_count => x_msg_count,
442: x_msg_data => x_msg_data,
443: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,

Line 467: p_init_msg_list => FND_API.G_FALSE,

463: ELSE
464:
465: cs_servicerequest_pub.Create_ServiceRequest
466: ( p_api_version => 3.0,
467: p_init_msg_list => FND_API.G_FALSE,
468: p_commit => FND_API.G_FALSE,
469: x_return_status => x_return_status,
470: x_msg_count => x_msg_count,
471: x_msg_data => x_msg_data,

Line 468: p_commit => FND_API.G_FALSE,

464:
465: cs_servicerequest_pub.Create_ServiceRequest
466: ( p_api_version => 3.0,
467: p_init_msg_list => FND_API.G_FALSE,
468: p_commit => FND_API.G_FALSE,
469: x_return_status => x_return_status,
470: x_msg_count => x_msg_count,
471: x_msg_data => x_msg_data,
472: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,

Line 494: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

490:
491: END IF;
492: FND_FILE.put_line(FND_FILE.log,'MESSAGE: after calling cs_servicerequest_pub.Create_ServiceRequest API x_return_status='||x_return_status);
493:
494: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
495: fnd_message.set_name('CSF','CSF_PM_SR_CREATION_ERROR');
496: fnd_message.set_token('VALUE1',l_ump_rec.unit_effectivity_id);
497: fnd_message.set_token('VALUE2',l_product_number);
498: fnd_message.set_token('VALUE3',l_serial_number);

Line 522: p_init_msg_list => fnd_api.g_false,

518: IF (nvl(l_primary_contact,'N') = 'N' and l_index is not null) THEN
519: CS_ServiceRequest_PUB.Update_ServiceRequest
520: (
521: p_api_version => 3.0,
522: p_init_msg_list => fnd_api.g_false,
523: p_commit => fnd_api.g_false,
524: x_return_status => x_return_status,
525: x_msg_count => x_msg_count,
526: x_msg_data => x_msg_data,

Line 523: p_commit => fnd_api.g_false,

519: CS_ServiceRequest_PUB.Update_ServiceRequest
520: (
521: p_api_version => 3.0,
522: p_init_msg_list => fnd_api.g_false,
523: p_commit => fnd_api.g_false,
524: x_return_status => x_return_status,
525: x_msg_count => x_msg_count,
526: x_msg_data => x_msg_data,
527: p_request_id => x_request_id,

Line 540: If x_return_status <> FND_API.G_RET_STS_SUCCESS Then

536: x_interaction_id => x_interaction_id,
537: x_workflow_process_id => x_workflow_process_id
538: );
539:
540: If x_return_status <> FND_API.G_RET_STS_SUCCESS Then
541: fnd_message.set_name('CSF','CSF_PM_SR_UPDATE_ERROR');
542: fnd_message.set_token('VALUE1',x_request_id);
543: fnd_msg_pub.add;
544: Add_Err_Msg;

Line 567: p_init_msg_list => FND_API.G_FALSE,

563: l_link_rec.program_id := fnd_global.conc_program_id;
564: l_link_rec.program_update_date := sysdate;
565: cs_incidentlinks_pub.create_incidentlink(
566: p_api_version => 2.0,
567: p_init_msg_list => FND_API.G_FALSE,
568: p_commit => FND_API.G_FALSE,
569: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
570: p_resp_id => FND_GLOBAL.RESP_ID,
571: p_user_id => FND_GLOBAL.USER_ID,

Line 568: p_commit => FND_API.G_FALSE,

564: l_link_rec.program_update_date := sysdate;
565: cs_incidentlinks_pub.create_incidentlink(
566: p_api_version => 2.0,
567: p_init_msg_list => FND_API.G_FALSE,
568: p_commit => FND_API.G_FALSE,
569: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
570: p_resp_id => FND_GLOBAL.RESP_ID,
571: p_user_id => FND_GLOBAL.USER_ID,
572: p_login_id => NULL,

Line 583: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

579: x_reciprocal_link_id => x_reciprocal_link_id,
580: x_link_id => x_link_id);
581:
582:
583: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
584: fnd_message.set_name('CSF','CSF_PM_SR_LINK_CREATION_ERROR');
585: fnd_message.set_token('VALUE1',l_ump_rec.unit_effectivity_id);
586: fnd_message.set_token('VALUE2',l_product_number);
587: fnd_message.set_token('VALUE3',l_serial_number);

Line 620: p_init_msg_list => FND_API.G_FALSE,

616: END IF;
617:
618: jtf_tasks_pub.create_task_from_template (
619: p_api_version => 1.0,
620: p_init_msg_list => FND_API.G_FALSE,
621: p_commit => FND_API.G_FALSE,
622: p_task_template_group_id => l_route_rec.task_template_group_id,
623: p_owner_type_code => nvl(x_individual_type,'RS_GROUP'),
624: p_owner_id => nvl(x_individual_owner,x_group_owner),

Line 621: p_commit => FND_API.G_FALSE,

617:
618: jtf_tasks_pub.create_task_from_template (
619: p_api_version => 1.0,
620: p_init_msg_list => FND_API.G_FALSE,
621: p_commit => FND_API.G_FALSE,
622: p_task_template_group_id => l_route_rec.task_template_group_id,
623: p_owner_type_code => nvl(x_individual_type,'RS_GROUP'),
624: p_owner_id => nvl(x_individual_owner,x_group_owner),
625: p_source_object_id => x_request_id,

Line 639: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

635: p_planned_end_date => to_date(nvl(l_ump_rec.latest_due_date,l_ump_rec.due_date)
636: || ' 23:59:59', 'dd-mon-yy hh24:mi:ss'),
637: p_timezone_id => l_service_request_rec.time_zone_id);
638: FND_FILE.put_line(FND_FILE.log,'MESSAGE:after create task x_return_status !='||x_return_status);
639: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
640: fnd_message.set_name('CSF','CSF_PM_TASK_CREATION_ERROR');
641: fnd_message.set_token('VALUE1',l_ump_rec.unit_effectivity_id);
642: fnd_message.set_token('VALUE2',l_route_rec.route_id);
643: fnd_message.set_token('VALUE3',x_individual_owner);

Line 682: ,p_init_msg_list => FND_API.G_FALSE

678: -- Customer confirmation process
679: -- Get customer cofirmation flag from contracts
680: oks_pm_entitlements_pub.Get_PM_Confirmation
681: (p_api_version => 1.0
682: ,p_init_msg_list => FND_API.G_FALSE
683: ,p_service_line_id => l_ump_rec.contract_service_id
684: ,p_program_id => l_ump_rec.program_mr_header_id
685: ,p_Activity_id => l_ump_rec.mr_header_id
686: ,x_return_status => x_return_status

Line 691: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

687: ,x_msg_count => x_msg_count
688: ,x_msg_data => x_msg_data
689: ,x_pm_conf_reqd => x_pm_conf_reqd);
690:
691: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
692: Add_Err_Msg;
693: Else
694: -- If customer conformation required then update all
695: -- the tasks statuses to CONFIRM status from profile option

Line 708: p_init_msg_list => FND_API.G_FALSE,

704:
705: FOR i in 1..conf_task_id.COUNT Loop
706: csf_tasks_pub.Update_Task_status
707: (p_api_version => 1.0,
708: p_init_msg_list => FND_API.G_FALSE,
709: p_commit => fnd_api.g_false,
710: p_task_id => conf_task_id(i),
711: p_task_status_id => fnd_profile.value('csfpm_task_confirm_status'),
712: p_object_version_number => conf_object_version_number(i),

Line 709: p_commit => fnd_api.g_false,

705: FOR i in 1..conf_task_id.COUNT Loop
706: csf_tasks_pub.Update_Task_status
707: (p_api_version => 1.0,
708: p_init_msg_list => FND_API.G_FALSE,
709: p_commit => fnd_api.g_false,
710: p_task_id => conf_task_id(i),
711: p_task_status_id => fnd_profile.value('csfpm_task_confirm_status'),
712: p_object_version_number => conf_object_version_number(i),
713: x_return_status => x_return_status,

Line 716: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

712: p_object_version_number => conf_object_version_number(i),
713: x_return_status => x_return_status,
714: x_msg_count => x_msg_count,
715: x_msg_data => x_msg_data );
716: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
717: fnd_message.set_name('CSF','CSF_PM_TASK_UPDATE_ERROR');
718: fnd_message.set_token('VALUE1',x_request_number);
719: fnd_message.set_token('VALUE2',conf_task_id(i));
720: fnd_message.set_token('VALUE3',l_product_number);

Line 842: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

838: x_msg_data => x_msg_data );
839:
840:
841:
842: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
843: fnd_message.set_name('CSF','CSF_PM_TASK_UPDATE_ERROR');
844: fnd_message.set_token('VALUE1',x_request_number);
845: fnd_message.set_token('VALUE2',conf_task_id(i));
846: fnd_message.set_token('VALUE3',l_product_number);

Line 880: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

876:
877: If not fnd_profile.save('CSFPM_LAST_RUN_DATE',trunc(sysdate),'SITE') Then
878:
879:
880: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
881: End If;
882: COMMIT WORK;
883:
884: --

Line 895: WHEN FND_API.G_EXC_ERROR THEN

891: p_data => x_msg_data
892: );
893: retcode := g_retcode;
894: EXCEPTION
895: WHEN FND_API.G_EXC_ERROR THEN
896: FND_FILE.put_line(FND_FILE.log,'MESSAGE: Inside exception 1');
897: retcode := 1;
898: errbuf := X_Msg_Data;
899: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

903: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
904: ,X_MSG_COUNT => X_MSG_COUNT
905: ,X_MSG_DATA => X_MSG_DATA
906: ,X_RETURN_STATUS => X_RETURN_STATUS);
907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
908: FND_FILE.put_line(FND_FILE.log,'MESSAGE: Inside exception 2');
909: retcode := 1;
910: errbuf := X_Msg_Data;
911: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 993: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

989: -- Standard Start of API savepoint
990: SAVEPOINT update_ump_pvt;
991:
992: -- Standard call to check for call compatibility.
993: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
994: p_api_version_number,
995: l_api_name,
996: G_PKG_NAME)
997: THEN

Line 998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

994: p_api_version_number,
995: l_api_name,
996: G_PKG_NAME)
997: THEN
998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
999: END IF;
1000:
1001:
1002: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1007: x_return_status := FND_API.G_RET_STS_SUCCESS;

1003: FND_MSG_PUB.initialize;
1004:
1005:
1006: -- Initialize API return status to SUCCESS
1007: x_return_status := FND_API.G_RET_STS_SUCCESS;
1008:
1009: --
1010: -- API body
1011: --

Line 1036: p_init_msg_list => FND_API.G_FALSE,

1032: End If;
1033: END LOOP;
1034: ahl_ump_unitmaint_pub.capture_mr_updates
1035: (p_api_version => 1.0,
1036: p_init_msg_list => FND_API.G_FALSE,
1037: p_commit => FND_API.G_FALSE,
1038: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1039: p_unit_effectivity_tbl => l_unit_effectivity_tbl,
1040: p_x_unit_threshold_tbl => l_unit_threshold_tbl,

Line 1037: p_commit => FND_API.G_FALSE,

1033: END LOOP;
1034: ahl_ump_unitmaint_pub.capture_mr_updates
1035: (p_api_version => 1.0,
1036: p_init_msg_list => FND_API.G_FALSE,
1037: p_commit => FND_API.G_FALSE,
1038: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1039: p_unit_effectivity_tbl => l_unit_effectivity_tbl,
1040: p_x_unit_threshold_tbl => l_unit_threshold_tbl,
1041: p_x_unit_accomplish_tbl => l_unit_accomplish_tbl,

Line 1038: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1034: ahl_ump_unitmaint_pub.capture_mr_updates
1035: (p_api_version => 1.0,
1036: p_init_msg_list => FND_API.G_FALSE,
1037: p_commit => FND_API.G_FALSE,
1038: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1039: p_unit_effectivity_tbl => l_unit_effectivity_tbl,
1040: p_x_unit_threshold_tbl => l_unit_threshold_tbl,
1041: p_x_unit_accomplish_tbl => l_unit_accomplish_tbl,
1042: x_return_status => x_return_status,

Line 1045: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

1041: p_x_unit_accomplish_tbl => l_unit_accomplish_tbl,
1042: x_return_status => x_return_status,
1043: x_msg_count => x_msg_count,
1044: x_msg_data => x_msg_data);
1045: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
1046: Add_Err_Msg;
1047: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1048: End If;
1049:

Line 1047: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1043: x_msg_count => x_msg_count,
1044: x_msg_data => x_msg_data);
1045: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
1046: Add_Err_Msg;
1047: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1048: End If;
1049:
1050: COMMIT WORK;
1051:

Line 1064: WHEN FND_API.G_EXC_ERROR THEN

1060: );
1061: retcode := g_retcode;
1062:
1063: EXCEPTION
1064: WHEN FND_API.G_EXC_ERROR THEN
1065: retcode := 2;
1066: errbuf := X_Msg_Data;
1067: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1068: P_API_NAME => L_API_NAME

Line 1075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1071: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1072: ,X_MSG_COUNT => X_MSG_COUNT
1073: ,X_MSG_DATA => X_MSG_DATA
1074: ,X_RETURN_STATUS => X_RETURN_STATUS);
1075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1076: retcode := 2;
1077: errbuf := X_Msg_Data;
1078: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1079: P_API_NAME => L_API_NAME

Line 1160: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1156: -- Standard Start of API savepoint
1157: SAVEPOINT update_sr_tasks_pvt;
1158:
1159: -- Standard call to check for call compatibility.
1160: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1161: p_api_version_number,
1162: l_api_name,
1163: G_PKG_NAME)
1164: THEN

Line 1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1161: p_api_version_number,
1162: l_api_name,
1163: G_PKG_NAME)
1164: THEN
1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1166: END IF;
1167:
1168: FND_MSG_PUB.initialize;
1169:

Line 1171: x_return_status := FND_API.G_RET_STS_SUCCESS;

1167:
1168: FND_MSG_PUB.initialize;
1169:
1170: -- Initialize API return status to SUCCESS
1171: x_return_status := FND_API.G_RET_STS_SUCCESS;
1172:
1173: --
1174: -- API body
1175: --

Line 1188: p_init_msg_list => FND_API.G_FALSE,

1184: l_prev_rec := incident_rec;
1185: sr_update_success := FALSE;
1186: cs_servicerequest_pub.Update_Status
1187: (p_api_version => 2.0,
1188: p_init_msg_list => FND_API.G_FALSE,
1189: p_commit => FND_API.G_FALSE,
1190: x_return_status => x_return_status,
1191: x_msg_count => x_msg_count,
1192: x_msg_data => x_msg_data,

Line 1189: p_commit => FND_API.G_FALSE,

1185: sr_update_success := FALSE;
1186: cs_servicerequest_pub.Update_Status
1187: (p_api_version => 2.0,
1188: p_init_msg_list => FND_API.G_FALSE,
1189: p_commit => FND_API.G_FALSE,
1190: x_return_status => x_return_status,
1191: x_msg_count => x_msg_count,
1192: x_msg_data => x_msg_data,
1193: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,

Line 1204: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

1200: -- status code CLOSED seeded in cs_incident_statuses
1201: p_status_id => 4,
1202: p_status => 'CLOSED',
1203: x_interaction_id => x_interaction_id);
1204: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
1205: fnd_message.set_name('CSF','CSF_PM_SR_UPDATE_ERROR');
1206: fnd_message.set_token('VALUE1',incident_rec.subject_id);
1207: fnd_msg_pub.add;
1208: Add_Err_Msg;

Line 1213: P_INIT_MSG_LIST => FND_API.G_FALSE,

1209: ROLLBACK TO update_sr_tasks_pvt;
1210: Else
1211: cs_incidentlinks_pub.DELETE_INCIDENTLINK (
1212: P_API_VERSION => 2.0,
1213: P_INIT_MSG_LIST => FND_API.G_FALSE,
1214: P_COMMIT => FND_API.G_FALSE,
1215: P_RESP_APPL_ID => NULL,
1216: P_RESP_ID => NULL,
1217: P_USER_ID => NULL,

Line 1214: P_COMMIT => FND_API.G_FALSE,

1210: Else
1211: cs_incidentlinks_pub.DELETE_INCIDENTLINK (
1212: P_API_VERSION => 2.0,
1213: P_INIT_MSG_LIST => FND_API.G_FALSE,
1214: P_COMMIT => FND_API.G_FALSE,
1215: P_RESP_APPL_ID => NULL,
1216: P_RESP_ID => NULL,
1217: P_USER_ID => NULL,
1218: P_LOGIN_ID => FND_GLOBAL.CONC_LOGIN_ID,

Line 1224: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

1220: P_LINK_ID => incident_rec.link_id,
1221: X_RETURN_STATUS => x_return_status,
1222: X_MSG_COUNT => x_msg_count,
1223: X_MSG_DATA => x_msg_data);
1224: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
1225: fnd_message.set_name('CSF','CSF_PM_SR_LINK_DELETE_ERROR');
1226: fnd_message.set_token('VALUE1',incident_rec.subject_id);
1227: fnd_msg_pub.add;
1228: Add_Err_Msg;

Line 1238: p_init_msg_list => FND_API.G_FALSE,

1234: End If;
1235: If sr_update_success Then
1236: csf_tasks_pub.Update_Task
1237: (p_api_version => 1.0,
1238: p_init_msg_list => FND_API.G_FALSE,
1239: p_commit => fnd_api.g_false,
1240: p_task_id => incident_rec.task_id,
1241: p_object_version_number => incident_rec.tasks_object_version,
1242: p_planned_start_date => incident_rec.planned_start_date,

Line 1239: p_commit => fnd_api.g_false,

1235: If sr_update_success Then
1236: csf_tasks_pub.Update_Task
1237: (p_api_version => 1.0,
1238: p_init_msg_list => FND_API.G_FALSE,
1239: p_commit => fnd_api.g_false,
1240: p_task_id => incident_rec.task_id,
1241: p_object_version_number => incident_rec.tasks_object_version,
1242: p_planned_start_date => incident_rec.planned_start_date,
1243: p_planned_end_date => incident_rec.planned_end_date,

Line 1252: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

1248: p_task_status_id => fnd_profile.value('csf_default_task_cancelled_status'), -- Task cancelled status
1249: x_return_status => x_return_status,
1250: x_msg_count => x_msg_count,
1251: x_msg_data => x_msg_data );
1252: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
1253: fnd_message.set_name('CSF','CSF_PM_TASK_UPDATE_ERROR');
1254: fnd_message.set_token('VALUE1',incident_rec.subject_id);
1255: fnd_message.set_token('VALUE2',incident_rec.task_id);
1256: fnd_msg_pub.add;

Line 1274: WHEN FND_API.G_EXC_ERROR THEN

1270: p_data => x_msg_data
1271: );
1272: retcode := g_retcode;
1273: EXCEPTION
1274: WHEN FND_API.G_EXC_ERROR THEN
1275: retcode := 2;
1276: errbuf := X_Msg_Data;
1277: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1278: P_API_NAME => L_API_NAME

Line 1285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1281: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1282: ,X_MSG_COUNT => X_MSG_COUNT
1283: ,X_MSG_DATA => X_MSG_DATA
1284: ,X_RETURN_STATUS => X_RETURN_STATUS);
1285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1286: retcode := 2;
1287: errbuf := X_Msg_Data;
1288: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1289: P_API_NAME => L_API_NAME