DBA Data[Home] [Help]

APPS.AHL_UC_WF_APPR_PVT dependencies on FND_API

Line 55: l_return_status := FND_API.g_ret_sts_success;

51:
52: --Initiliaze message list
53: fnd_msg_pub.initialize;
54:
55: l_return_status := FND_API.g_ret_sts_success;
56:
57:
58: l_object_id := wf_engine.getitemattrnumber
59: (

Line 94: RAISE FND_API.G_EXC_ERROR;

90: FETCH get_uc_header_det into l_uc_header_rec;
91: IF get_uc_header_det%NOTFOUND THEN
92: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
93: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
94: RAISE FND_API.G_EXC_ERROR;
95: END IF;
96: CLOSE get_uc_header_det;
97:
98: --check if active uc status approval

Line 225: IF l_return_status = FND_API.g_ret_sts_success THEN

221: x_return_status => l_return_status
222: );
223:
224:
225: IF l_return_status = FND_API.g_ret_sts_success THEN
226:
227: wf_engine.setitemattrnumber
228: (
229: itemtype => itemtype,

Line 255: RAISE FND_API.G_EXC_ERROR;

251: resultout := 'COMPLETE:SUCCESS';
252: RETURN;
253:
254: ELSE
255: RAISE FND_API.G_EXC_ERROR;
256: END IF;
257: END IF;
258:
259: --

Line 290: WHEN FND_API.G_EXC_ERROR THEN

286: END IF;
287:
288:
289: EXCEPTION
290: WHEN FND_API.G_EXC_ERROR THEN
291: FND_MSG_PUB.Count_And_Get
292: (
293: p_encoded => FND_API.G_FALSE,
294: p_count => l_msg_count,

Line 293: p_encoded => FND_API.G_FALSE,

289: EXCEPTION
290: WHEN FND_API.G_EXC_ERROR THEN
291: FND_MSG_PUB.Count_And_Get
292: (
293: p_encoded => FND_API.G_FALSE,
294: p_count => l_msg_count,
295: p_data => l_msg_data
296: );
297: AHL_GENERIC_APRV_PVT.handle_error

Line 406: RAISE FND_API.G_EXC_ERROR;

402: IF get_uc_header_det%NOTFOUND
403: THEN
404: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
405: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
406: RAISE FND_API.G_EXC_ERROR;
407: ELSE
408: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FWD');
409: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
410: fnd_message.set_token('NAME',l_uc_header_rec.name, false);

Line 431: WHEN FND_API.G_EXC_ERROR THEN

427: COMMIT;
428: RETURN;
429:
430: EXCEPTION
431: WHEN FND_API.G_EXC_ERROR THEN
432: FND_MSG_PUB.Count_And_Get
433: (
434: p_encoded => FND_API.G_FALSE,
435: p_count => l_msg_count,

Line 434: p_encoded => FND_API.G_FALSE,

430: EXCEPTION
431: WHEN FND_API.G_EXC_ERROR THEN
432: FND_MSG_PUB.Count_And_Get
433: (
434: p_encoded => FND_API.G_FALSE,
435: p_count => l_msg_count,
436: p_data => l_msg_data
437: );
438: AHL_GENERIC_APRV_PVT.Handle_Error

Line 542: RAISE FND_API.G_EXC_ERROR;

538: IF get_uc_header_det%NOTFOUND
539: THEN
540: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
541: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
542: RAISE FND_API.G_EXC_ERROR;
543: ELSE
544: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_APPRVD');
545: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
546: fnd_message.set_token('NAME',l_uc_header_rec.name, false);

Line 565: WHEN FND_API.G_EXC_ERROR THEN

561:
562: RETURN;
563:
564: EXCEPTION
565: WHEN FND_API.G_EXC_ERROR THEN
566: FND_MSG_PUB.Count_And_Get
567: (
568: p_encoded => FND_API.G_FALSE,
569: p_count => l_msg_count,

Line 568: p_encoded => FND_API.G_FALSE,

564: EXCEPTION
565: WHEN FND_API.G_EXC_ERROR THEN
566: FND_MSG_PUB.Count_And_Get
567: (
568: p_encoded => FND_API.G_FALSE,
569: p_count => l_msg_count,
570: p_data => l_msg_data
571: );
572: AHL_GENERIC_APRV_PVT.Handle_Error

Line 675: RAISE FND_API.G_EXC_ERROR;

671: IF get_uc_header_det%NOTFOUND
672: THEN
673: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
674: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
675: RAISE FND_API.G_EXC_ERROR;
676: ELSE
677: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FINAL');
678: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
679: fnd_message.set_token('NAME',l_uc_header_rec.name, false);

Line 698: WHEN FND_API.G_EXC_ERROR THEN

694: RETURN;
695:
696:
697: EXCEPTION
698: WHEN FND_API.G_EXC_ERROR THEN
699: FND_MSG_PUB.Count_And_Get
700: (
701: p_encoded => FND_API.G_FALSE,
702: p_count => l_msg_count,

Line 701: p_encoded => FND_API.G_FALSE,

697: EXCEPTION
698: WHEN FND_API.G_EXC_ERROR THEN
699: FND_MSG_PUB.Count_And_Get
700: (
701: p_encoded => FND_API.G_FALSE,
702: p_count => l_msg_count,
703: p_data => l_msg_data
704: );
705: AHL_GENERIC_APRV_PVT.Handle_Error

Line 808: RAISE FND_API.G_EXC_ERROR;

804:
805: IF get_uc_header_det%NOTFOUND THEN
806: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
807: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
808: RAISE FND_API.G_EXC_ERROR;
809: ELSE
810: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_RJCT');
811: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
812: fnd_message.set_token('NAME',l_uc_header_rec.name, false);

Line 832: WHEN FND_API.G_EXC_ERROR THEN

828:
829: RETURN;
830:
831: EXCEPTION
832: WHEN FND_API.G_EXC_ERROR THEN
833: FND_MSG_PUB.Count_And_Get
834: (
835: p_encoded => FND_API.G_FALSE,
836: p_count => l_msg_count,

Line 835: p_encoded => FND_API.G_FALSE,

831: EXCEPTION
832: WHEN FND_API.G_EXC_ERROR THEN
833: FND_MSG_PUB.Count_And_Get
834: (
835: p_encoded => FND_API.G_FALSE,
836: p_count => l_msg_count,
837: p_data => l_msg_data
838: );
839: AHL_GENERIC_APRV_PVT.Handle_Error

Line 949: RAISE FND_API.G_EXC_ERROR;

945: IF get_uc_header_det%NOTFOUND
946: THEN
947: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
948: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
949: RAISE FND_API.G_EXC_ERROR;
950: ELSE
951: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL');
952: fnd_message.set_token('REQUESTER',l_requester, false);
953: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);

Line 973: WHEN FND_API.G_EXC_ERROR THEN

969:
970: RETURN;
971:
972: EXCEPTION
973: WHEN FND_API.G_EXC_ERROR THEN
974: FND_MSG_PUB.Count_And_Get
975: (
976: p_encoded => FND_API.G_FALSE,
977: p_count => l_msg_count,

Line 976: p_encoded => FND_API.G_FALSE,

972: EXCEPTION
973: WHEN FND_API.G_EXC_ERROR THEN
974: FND_MSG_PUB.Count_And_Get
975: (
976: p_encoded => FND_API.G_FALSE,
977: p_count => l_msg_count,
978: p_data => l_msg_data
979: );
980: AHL_GENERIC_APRV_PVT.Handle_Error

Line 1091: RAISE FND_API.G_EXC_ERROR;

1087: IF get_uc_header_det%NOTFOUND
1088: THEN
1089: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1090: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1091: RAISE FND_API.G_EXC_ERROR;
1092: ELSE
1093: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND');
1094: fnd_message.set_token('REQUESTER',l_requester, false);
1095: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);

Line 1115: WHEN FND_API.G_EXC_ERROR THEN

1111:
1112: RETURN;
1113:
1114: EXCEPTION
1115: WHEN FND_API.G_EXC_ERROR THEN
1116: FND_MSG_PUB.Count_And_Get
1117: (
1118: p_encoded => FND_API.G_FALSE,
1119: p_count => l_msg_count,

Line 1118: p_encoded => FND_API.G_FALSE,

1114: EXCEPTION
1115: WHEN FND_API.G_EXC_ERROR THEN
1116: FND_MSG_PUB.Count_And_Get
1117: (
1118: p_encoded => FND_API.G_FALSE,
1119: p_count => l_msg_count,
1120: p_data => l_msg_data
1121: );
1122: AHL_GENERIC_APRV_PVT.Handle_Error

Line 1223: RAISE FND_API.G_EXC_ERROR;

1219: IF get_uc_header_det%NOTFOUND
1220: THEN
1221: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1222: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1223: RAISE FND_API.G_EXC_ERROR;
1224: ELSE
1225: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_ACT');
1226: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1227: fnd_message.set_token('NAME',l_uc_header_rec.name, false);

Line 1246: WHEN FND_API.G_EXC_ERROR THEN

1242:
1243: RETURN;
1244:
1245: EXCEPTION
1246: WHEN FND_API.G_EXC_ERROR THEN
1247: FND_MSG_PUB.Count_And_Get
1248: (
1249: p_encoded => FND_API.G_FALSE,
1250: p_count => l_msg_count,

Line 1249: p_encoded => FND_API.G_FALSE,

1245: EXCEPTION
1246: WHEN FND_API.G_EXC_ERROR THEN
1247: FND_MSG_PUB.Count_And_Get
1248: (
1249: p_encoded => FND_API.G_FALSE,
1250: p_count => l_msg_count,
1251: p_data => l_msg_data
1252: );
1253: AHL_GENERIC_APRV_PVT.Handle_Error

Line 1384: RAISE FND_API.G_EXC_ERROR;

1380: IF get_uc_header_det%NOTFOUND
1381: THEN
1382: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1383: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1384: RAISE FND_API.G_EXC_ERROR;
1385: END IF;
1386: CLOSE get_uc_header_det;
1387:
1388:

Line 1400: RAISE FND_API.G_EXC_ERROR;

1396: IF G_DEBUG='Y' THEN
1397: AHL_DEBUG_PUB.debug('UC: UPDATE_STATUS check_uc_ovn --> fnd_message='||fnd_message.get );
1398: END IF;
1399:
1400: RAISE FND_API.G_EXC_ERROR;
1401: END IF;
1402: CLOSE check_uc_ovn;
1403:
1404: AHL_GENERIC_APRV_PVT.Handle_Error

Line 1424: p_init_msg_list => FND_API.G_TRUE,

1420:
1421: --CALL AHL_UC_APPROVALS_PVT.complete_uc_approvals
1422: AHL_UC_APPROVALS_PVT.complete_uc_approval(
1423: p_api_version => 1.0,
1424: p_init_msg_list => FND_API.G_TRUE,
1425: p_commit => FND_API.G_TRUE,
1426: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1427: p_uc_header_id => l_object_id,
1428: p_object_version_number => l_object_version_number,

Line 1425: p_commit => FND_API.G_TRUE,

1421: --CALL AHL_UC_APPROVALS_PVT.complete_uc_approvals
1422: AHL_UC_APPROVALS_PVT.complete_uc_approval(
1423: p_api_version => 1.0,
1424: p_init_msg_list => FND_API.G_TRUE,
1425: p_commit => FND_API.G_TRUE,
1426: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1427: p_uc_header_id => l_object_id,
1428: p_object_version_number => l_object_version_number,
1429: p_approval_status => l_approval_status,

Line 1426: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1422: AHL_UC_APPROVALS_PVT.complete_uc_approval(
1423: p_api_version => 1.0,
1424: p_init_msg_list => FND_API.G_TRUE,
1425: p_commit => FND_API.G_TRUE,
1426: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1427: p_uc_header_id => l_object_id,
1428: p_object_version_number => l_object_version_number,
1429: p_approval_status => l_approval_status,
1430: x_return_status => l_return_status,

Line 1474: WHEN FND_API.g_exc_error THEN

1470:
1471:
1472:
1473: EXCEPTION
1474: WHEN FND_API.g_exc_error THEN
1475: FND_MSG_PUB.Count_And_Get
1476: (
1477: p_encoded => FND_API.G_FALSE,
1478: p_count => l_msg_count,

Line 1477: p_encoded => FND_API.G_FALSE,

1473: EXCEPTION
1474: WHEN FND_API.g_exc_error THEN
1475: FND_MSG_PUB.Count_And_Get
1476: (
1477: p_encoded => FND_API.G_FALSE,
1478: p_count => l_msg_count,
1479: p_data => l_msg_data
1480: );
1481: AHL_GENERIC_APRV_PVT.Handle_Error

Line 1603: RAISE FND_API.G_EXC_ERROR;

1599: IF get_uc_header_det%NOTFOUND
1600: THEN
1601: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1602: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1603: RAISE FND_API.G_EXC_ERROR;
1604: END IF;
1605: CLOSE get_uc_header_det;
1606:
1607:

Line 1614: RAISE FND_API.G_EXC_ERROR;

1610:
1611: IF check_uc_ovn%NOTFOUND
1612: THEN
1613: fnd_message.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1614: RAISE FND_API.G_EXC_ERROR;
1615: END IF;
1616:
1617:
1618: IF (l_check_uc_ovn.unit_config_status_code = 'APPROVAL_PENDING') THEN

Line 1672: WHEN FND_API.g_exc_error THEN

1668:
1669:
1670:
1671: EXCEPTION
1672: WHEN FND_API.g_exc_error THEN
1673: FND_MSG_PUB.Count_And_Get
1674: (
1675: p_encoded => FND_API.G_FALSE,
1676: p_count => l_msg_count,

Line 1675: p_encoded => FND_API.G_FALSE,

1671: EXCEPTION
1672: WHEN FND_API.g_exc_error THEN
1673: FND_MSG_PUB.Count_And_Get
1674: (
1675: p_encoded => FND_API.G_FALSE,
1676: p_count => l_msg_count,
1677: p_data => l_msg_data
1678: );
1679: AHL_GENERIC_APRV_PVT.Handle_Error