DBA Data[Home] [Help]

APPS.CSF_PREVENTIVE_MAINTENANCE_PVT dependencies on FND_API

Line 295: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

291: -- Standard Start of API savepoint
292: SAVEPOINT Generate_SR_Tasks_PVT;
293:
294: -- Standard call to check for call compatibility.
295: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
296: p_api_version_number,
297: l_api_name,
298: G_PKG_NAME)
299: THEN

Line 300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

296: p_api_version_number,
297: l_api_name,
298: G_PKG_NAME)
299: THEN
300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
301: END IF;
302:
303:
304: -- Initialize message list

Line 309: x_return_status := FND_API.G_RET_STS_SUCCESS;

305: FND_MSG_PUB.initialize;
306:
307:
308: -- Initialize API return status to SUCCESS
309: x_return_status := FND_API.G_RET_STS_SUCCESS;
310:
311:
312: --
313: -- API body

Line 474: p_init_msg_list => FND_API.G_FALSE,

470: IF (nvl(l_primary_contact,'N') = 'N') THEN
471:
472: cs_servicerequest_pub.Create_ServiceRequest
473: ( p_api_version => 3.0,
474: p_init_msg_list => FND_API.G_FALSE,
475: p_commit => FND_API.G_FALSE,
476: x_return_status => x_return_status,
477: x_msg_count => x_msg_count,
478: x_msg_data => x_msg_data,

Line 475: p_commit => FND_API.G_FALSE,

471:
472: cs_servicerequest_pub.Create_ServiceRequest
473: ( p_api_version => 3.0,
474: p_init_msg_list => FND_API.G_FALSE,
475: p_commit => FND_API.G_FALSE,
476: x_return_status => x_return_status,
477: x_msg_count => x_msg_count,
478: x_msg_data => x_msg_data,
479: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,

Line 503: p_init_msg_list => FND_API.G_FALSE,

499: ELSE
500:
501: cs_servicerequest_pub.Create_ServiceRequest
502: ( p_api_version => 3.0,
503: p_init_msg_list => FND_API.G_FALSE,
504: p_commit => FND_API.G_FALSE,
505: x_return_status => x_return_status,
506: x_msg_count => x_msg_count,
507: x_msg_data => x_msg_data,

Line 504: p_commit => FND_API.G_FALSE,

500:
501: cs_servicerequest_pub.Create_ServiceRequest
502: ( p_api_version => 3.0,
503: p_init_msg_list => FND_API.G_FALSE,
504: p_commit => FND_API.G_FALSE,
505: x_return_status => x_return_status,
506: x_msg_count => x_msg_count,
507: x_msg_data => x_msg_data,
508: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,

Line 530: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

526:
527: END IF;
528: FND_FILE.put_line(FND_FILE.log,'MESSAGE: after calling cs_servicerequest_pub.Create_ServiceRequest API x_return_status='||x_return_status);
529:
530: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
531: fnd_message.set_name('CSF','CSF_PM_SR_CREATION_ERROR');
532: fnd_message.set_token('VALUE1',l_ump_rec.unit_effectivity_id);
533: fnd_message.set_token('VALUE2',l_product_number);
534: fnd_message.set_token('VALUE3',l_serial_number);

Line 558: p_init_msg_list => fnd_api.g_false,

554: IF (nvl(l_primary_contact,'N') = 'N' and l_index is not null) THEN
555: CS_ServiceRequest_PUB.Update_ServiceRequest
556: (
557: p_api_version => 3.0,
558: p_init_msg_list => fnd_api.g_false,
559: p_commit => fnd_api.g_false,
560: x_return_status => x_return_status,
561: x_msg_count => x_msg_count,
562: x_msg_data => x_msg_data,

Line 559: p_commit => fnd_api.g_false,

555: CS_ServiceRequest_PUB.Update_ServiceRequest
556: (
557: p_api_version => 3.0,
558: p_init_msg_list => fnd_api.g_false,
559: p_commit => fnd_api.g_false,
560: x_return_status => x_return_status,
561: x_msg_count => x_msg_count,
562: x_msg_data => x_msg_data,
563: p_request_id => x_request_id,

Line 576: If x_return_status <> FND_API.G_RET_STS_SUCCESS Then

572: x_interaction_id => x_interaction_id,
573: x_workflow_process_id => x_workflow_process_id
574: );
575:
576: If x_return_status <> FND_API.G_RET_STS_SUCCESS Then
577: fnd_message.set_name('CSF','CSF_PM_SR_UPDATE_ERROR');
578: fnd_message.set_token('VALUE1',x_request_id);
579: fnd_msg_pub.add;
580: Add_Err_Msg;

Line 603: p_init_msg_list => FND_API.G_FALSE,

599: l_link_rec.program_id := fnd_global.conc_program_id;
600: l_link_rec.program_update_date := sysdate;
601: cs_incidentlinks_pub.create_incidentlink(
602: p_api_version => 2.0,
603: p_init_msg_list => FND_API.G_FALSE,
604: p_commit => FND_API.G_FALSE,
605: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
606: p_resp_id => FND_GLOBAL.RESP_ID,
607: p_user_id => FND_GLOBAL.USER_ID,

Line 604: p_commit => FND_API.G_FALSE,

600: l_link_rec.program_update_date := sysdate;
601: cs_incidentlinks_pub.create_incidentlink(
602: p_api_version => 2.0,
603: p_init_msg_list => FND_API.G_FALSE,
604: p_commit => FND_API.G_FALSE,
605: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
606: p_resp_id => FND_GLOBAL.RESP_ID,
607: p_user_id => FND_GLOBAL.USER_ID,
608: p_login_id => NULL,

Line 620: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

616: x_reciprocal_link_id => x_reciprocal_link_id,
617: x_link_id => x_link_id);
618:
619:
620: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
621: fnd_message.set_name('CSF','CSF_PM_SR_LINK_CREATION_ERROR');
622: fnd_message.set_token('VALUE1',l_ump_rec.unit_effectivity_id);
623: fnd_message.set_token('VALUE2',l_product_number);
624: fnd_message.set_token('VALUE3',l_serial_number);

Line 657: p_init_msg_list => FND_API.G_FALSE,

653: END IF;
654:
655: jtf_tasks_pub.create_task_from_template (
656: p_api_version => 1.0,
657: p_init_msg_list => FND_API.G_FALSE,
658: p_commit => FND_API.G_FALSE,
659: p_task_template_group_id => l_route_rec.task_template_group_id,
660: p_owner_type_code => nvl(x_individual_type,'RS_GROUP'),
661: p_owner_id => nvl(x_individual_owner,x_group_owner),

Line 658: p_commit => FND_API.G_FALSE,

654:
655: jtf_tasks_pub.create_task_from_template (
656: p_api_version => 1.0,
657: p_init_msg_list => FND_API.G_FALSE,
658: p_commit => FND_API.G_FALSE,
659: p_task_template_group_id => l_route_rec.task_template_group_id,
660: p_owner_type_code => nvl(x_individual_type,'RS_GROUP'),
661: p_owner_id => nvl(x_individual_owner,x_group_owner),
662: p_source_object_id => x_request_id,

Line 676: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

672: p_planned_end_date => to_date(nvl(l_ump_rec.latest_due_date,l_ump_rec.due_date)
673: || ' 23:59:59', 'dd-mon-yy hh24:mi:ss'),
674: p_timezone_id => l_service_request_rec.time_zone_id);
675: FND_FILE.put_line(FND_FILE.log,'MESSAGE:after create task x_return_status !='||x_return_status);
676: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
677: fnd_message.set_name('CSF','CSF_PM_TASK_CREATION_ERROR');
678: fnd_message.set_token('VALUE1',l_ump_rec.unit_effectivity_id);
679: fnd_message.set_token('VALUE2',l_route_rec.route_id);
680: fnd_message.set_token('VALUE3',x_individual_owner);

Line 719: ,p_init_msg_list => FND_API.G_FALSE

715: -- Customer confirmation process
716: -- Get customer cofirmation flag from contracts
717: oks_pm_entitlements_pub.Get_PM_Confirmation
718: (p_api_version => 1.0
719: ,p_init_msg_list => FND_API.G_FALSE
720: ,p_service_line_id => l_ump_rec.contract_service_id
721: ,p_program_id => l_ump_rec.program_mr_header_id
722: ,p_Activity_id => l_ump_rec.mr_header_id
723: ,x_return_status => x_return_status

Line 728: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

724: ,x_msg_count => x_msg_count
725: ,x_msg_data => x_msg_data
726: ,x_pm_conf_reqd => x_pm_conf_reqd);
727:
728: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
729: Add_Err_Msg;
730: Else
731: -- If customer conformation required then update all
732: -- the tasks statuses to CONFIRM status from profile option

Line 745: , p_init_msg_list => FND_API.G_FALSE

741:
742: FOR i in 1..conf_task_id.COUNT Loop
743: csf_tasks_pub.update_cust_confirmation(
744: p_api_version =>1.0
745: , p_init_msg_list => FND_API.G_FALSE
746: , p_commit => FND_API.G_FALSE
747: , x_return_status => x_return_status
748: , x_msg_count => x_msg_count
749: , x_msg_data => x_msg_data

Line 746: , p_commit => FND_API.G_FALSE

742: FOR i in 1..conf_task_id.COUNT Loop
743: csf_tasks_pub.update_cust_confirmation(
744: p_api_version =>1.0
745: , p_init_msg_list => FND_API.G_FALSE
746: , p_commit => FND_API.G_FALSE
747: , x_return_status => x_return_status
748: , x_msg_count => x_msg_count
749: , x_msg_data => x_msg_data
750: , p_task_id => conf_task_id(i)

Line 756: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

752: , p_action => csf_tasks_pub.g_action_conf_to_required
753: , p_initiated => csf_tasks_pub.g_dispatcher_initiated
754: );
755:
756: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
757: fnd_message.set_name('CSF','CSF_PM_TASK_UPDATE_ERROR');
758: fnd_message.set_token('VALUE1',x_request_number);
759: fnd_message.set_token('VALUE2',conf_task_id(i));
760: fnd_message.set_token('VALUE3',l_product_number);

Line 882: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

878: x_msg_data => x_msg_data );
879:
880:
881:
882: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
883: fnd_message.set_name('CSF','CSF_PM_TASK_UPDATE_ERROR');
884: fnd_message.set_token('VALUE1',x_request_number);
885: fnd_message.set_token('VALUE2',conf_task_id(i));
886: fnd_message.set_token('VALUE3',l_product_number);

Line 920: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

916:
917: If not fnd_profile.save('CSFPM_LAST_RUN_DATE',trunc(sysdate),'SITE') Then
918:
919:
920: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
921: End If;
922: COMMIT WORK;
923:
924: --

Line 935: WHEN FND_API.G_EXC_ERROR THEN

931: p_data => x_msg_data
932: );
933: retcode := g_retcode;
934: EXCEPTION
935: WHEN FND_API.G_EXC_ERROR THEN
936: FND_FILE.put_line(FND_FILE.log,'MESSAGE: Inside exception 1');
937: retcode := 1;
938: errbuf := X_Msg_Data;
939: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

943: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
944: ,X_MSG_COUNT => X_MSG_COUNT
945: ,X_MSG_DATA => X_MSG_DATA
946: ,X_RETURN_STATUS => X_RETURN_STATUS);
947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
948: FND_FILE.put_line(FND_FILE.log,'MESSAGE: Inside exception 2');
949: retcode := 1;
950: errbuf := X_Msg_Data;
951: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 1033: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1029: -- Standard Start of API savepoint
1030: SAVEPOINT update_ump_pvt;
1031:
1032: -- Standard call to check for call compatibility.
1033: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1034: p_api_version_number,
1035: l_api_name,
1036: G_PKG_NAME)
1037: THEN

Line 1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1034: p_api_version_number,
1035: l_api_name,
1036: G_PKG_NAME)
1037: THEN
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: END IF;
1040:
1041:
1042: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1047: x_return_status := FND_API.G_RET_STS_SUCCESS;

1043: FND_MSG_PUB.initialize;
1044:
1045:
1046: -- Initialize API return status to SUCCESS
1047: x_return_status := FND_API.G_RET_STS_SUCCESS;
1048:
1049: --
1050: -- API body
1051: --

Line 1080: p_init_msg_list => FND_API.G_FALSE,

1076: FND_FILE.put_line(FND_FILE.log, 'before calling
1077: ahl_ump_unitmaint_pub.capture_mr_updates');
1078: ahl_ump_unitmaint_pub.capture_mr_updates
1079: (p_api_version => 1.0,
1080: p_init_msg_list => FND_API.G_FALSE,
1081: p_commit => FND_API.G_FALSE,
1082: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1083: p_unit_effectivity_tbl => l_unit_effectivity_tbl,
1084: p_x_unit_threshold_tbl => l_unit_threshold_tbl,

Line 1081: p_commit => FND_API.G_FALSE,

1077: ahl_ump_unitmaint_pub.capture_mr_updates');
1078: ahl_ump_unitmaint_pub.capture_mr_updates
1079: (p_api_version => 1.0,
1080: p_init_msg_list => FND_API.G_FALSE,
1081: p_commit => FND_API.G_FALSE,
1082: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1083: p_unit_effectivity_tbl => l_unit_effectivity_tbl,
1084: p_x_unit_threshold_tbl => l_unit_threshold_tbl,
1085: p_x_unit_accomplish_tbl => l_unit_accomplish_tbl,

Line 1082: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1078: ahl_ump_unitmaint_pub.capture_mr_updates
1079: (p_api_version => 1.0,
1080: p_init_msg_list => FND_API.G_FALSE,
1081: p_commit => FND_API.G_FALSE,
1082: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1083: p_unit_effectivity_tbl => l_unit_effectivity_tbl,
1084: p_x_unit_threshold_tbl => l_unit_threshold_tbl,
1085: p_x_unit_accomplish_tbl => l_unit_accomplish_tbl,
1086: x_return_status => x_return_status,

Line 1091: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

1087: x_msg_count => x_msg_count,
1088: x_msg_data => x_msg_data);
1089: FND_FILE.put_line(FND_FILE.log, 'after calling
1090: ahl_ump_unitmaint_pub.capture_mr_updates x_return_status=' || x_return_status);
1091: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
1092: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count,p_data => x_msg_data);
1093: for i in 1..x_msg_count loop fnd_file.put_line (FND_FILE.log, SUBSTR(FND_MSG_PUB.GET(P_MSG_INDEX=> i, p_encoded => 'F'), 1, 254));
1094: end loop;
1095: End If;

Line 1111: WHEN FND_API.G_EXC_ERROR THEN

1107: );
1108: retcode := g_retcode;
1109:
1110: EXCEPTION
1111: WHEN FND_API.G_EXC_ERROR THEN
1112: retcode := 2;
1113: errbuf := X_Msg_Data;
1114: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1115: P_API_NAME => L_API_NAME

Line 1122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1118: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1119: ,X_MSG_COUNT => X_MSG_COUNT
1120: ,X_MSG_DATA => X_MSG_DATA
1121: ,X_RETURN_STATUS => X_RETURN_STATUS);
1122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1123: retcode := 2;
1124: errbuf := X_Msg_Data;
1125: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1126: P_API_NAME => L_API_NAME

Line 1207: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1203: -- Standard Start of API savepoint
1204: SAVEPOINT update_sr_tasks_pvt;
1205:
1206: -- Standard call to check for call compatibility.
1207: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1208: p_api_version_number,
1209: l_api_name,
1210: G_PKG_NAME)
1211: THEN

Line 1212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1208: p_api_version_number,
1209: l_api_name,
1210: G_PKG_NAME)
1211: THEN
1212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1213: END IF;
1214:
1215: FND_MSG_PUB.initialize;
1216:

Line 1218: x_return_status := FND_API.G_RET_STS_SUCCESS;

1214:
1215: FND_MSG_PUB.initialize;
1216:
1217: -- Initialize API return status to SUCCESS
1218: x_return_status := FND_API.G_RET_STS_SUCCESS;
1219:
1220: --
1221: -- API body
1222: --

Line 1235: p_init_msg_list => FND_API.G_FALSE,

1231: l_prev_rec := incident_rec;
1232: sr_update_success := FALSE;
1233: cs_servicerequest_pub.Update_Status
1234: (p_api_version => 2.0,
1235: p_init_msg_list => FND_API.G_FALSE,
1236: p_commit => FND_API.G_FALSE,
1237: x_return_status => x_return_status,
1238: x_msg_count => x_msg_count,
1239: x_msg_data => x_msg_data,

Line 1236: p_commit => FND_API.G_FALSE,

1232: sr_update_success := FALSE;
1233: cs_servicerequest_pub.Update_Status
1234: (p_api_version => 2.0,
1235: p_init_msg_list => FND_API.G_FALSE,
1236: p_commit => FND_API.G_FALSE,
1237: x_return_status => x_return_status,
1238: x_msg_count => x_msg_count,
1239: x_msg_data => x_msg_data,
1240: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,

Line 1251: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

1247: -- status code CLOSED seeded in cs_incident_statuses
1248: p_status_id => 4,
1249: p_status => 'CLOSED',
1250: x_interaction_id => x_interaction_id);
1251: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
1252: fnd_message.set_name('CSF','CSF_PM_SR_UPDATE_ERROR');
1253: fnd_message.set_token('VALUE1',incident_rec.subject_id);
1254: fnd_msg_pub.add;
1255: Add_Err_Msg;

Line 1260: P_INIT_MSG_LIST => FND_API.G_FALSE,

1256: ROLLBACK TO update_sr_tasks_pvt;
1257: Else
1258: cs_incidentlinks_pub.DELETE_INCIDENTLINK (
1259: P_API_VERSION => 2.0,
1260: P_INIT_MSG_LIST => FND_API.G_FALSE,
1261: P_COMMIT => FND_API.G_FALSE,
1262: P_RESP_APPL_ID => NULL,
1263: P_RESP_ID => NULL,
1264: P_USER_ID => NULL,

Line 1261: P_COMMIT => FND_API.G_FALSE,

1257: Else
1258: cs_incidentlinks_pub.DELETE_INCIDENTLINK (
1259: P_API_VERSION => 2.0,
1260: P_INIT_MSG_LIST => FND_API.G_FALSE,
1261: P_COMMIT => FND_API.G_FALSE,
1262: P_RESP_APPL_ID => NULL,
1263: P_RESP_ID => NULL,
1264: P_USER_ID => NULL,
1265: P_LOGIN_ID => FND_GLOBAL.CONC_LOGIN_ID,

Line 1271: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

1267: P_LINK_ID => incident_rec.link_id,
1268: X_RETURN_STATUS => x_return_status,
1269: X_MSG_COUNT => x_msg_count,
1270: X_MSG_DATA => x_msg_data);
1271: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
1272: fnd_message.set_name('CSF','CSF_PM_SR_LINK_DELETE_ERROR');
1273: fnd_message.set_token('VALUE1',incident_rec.subject_id);
1274: fnd_msg_pub.add;
1275: Add_Err_Msg;

Line 1285: p_init_msg_list => FND_API.G_FALSE,

1281: End If;
1282: If sr_update_success Then
1283: csf_tasks_pub.Update_Task
1284: (p_api_version => 1.0,
1285: p_init_msg_list => FND_API.G_FALSE,
1286: p_commit => fnd_api.g_false,
1287: p_task_id => incident_rec.task_id,
1288: p_object_version_number => incident_rec.tasks_object_version,
1289: p_planned_start_date => incident_rec.planned_start_date,

Line 1286: p_commit => fnd_api.g_false,

1282: If sr_update_success Then
1283: csf_tasks_pub.Update_Task
1284: (p_api_version => 1.0,
1285: p_init_msg_list => FND_API.G_FALSE,
1286: p_commit => fnd_api.g_false,
1287: p_task_id => incident_rec.task_id,
1288: p_object_version_number => incident_rec.tasks_object_version,
1289: p_planned_start_date => incident_rec.planned_start_date,
1290: p_planned_end_date => incident_rec.planned_end_date,

Line 1299: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

1295: p_task_status_id => fnd_profile.value('csf_default_task_cancelled_status'), -- Task cancelled status
1296: x_return_status => x_return_status,
1297: x_msg_count => x_msg_count,
1298: x_msg_data => x_msg_data );
1299: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
1300: fnd_message.set_name('CSF','CSF_PM_TASK_UPDATE_ERROR');
1301: fnd_message.set_token('VALUE1',incident_rec.subject_id);
1302: fnd_message.set_token('VALUE2',incident_rec.task_id);
1303: fnd_msg_pub.add;

Line 1321: WHEN FND_API.G_EXC_ERROR THEN

1317: p_data => x_msg_data
1318: );
1319: retcode := g_retcode;
1320: EXCEPTION
1321: WHEN FND_API.G_EXC_ERROR THEN
1322: retcode := 2;
1323: errbuf := X_Msg_Data;
1324: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1325: P_API_NAME => L_API_NAME

Line 1332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1328: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1329: ,X_MSG_COUNT => X_MSG_COUNT
1330: ,X_MSG_DATA => X_MSG_DATA
1331: ,X_RETURN_STATUS => X_RETURN_STATUS);
1332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1333: retcode := 2;
1334: errbuf := X_Msg_Data;
1335: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1336: P_API_NAME => L_API_NAME