DBA Data[Home] [Help]

APPS.AHL_MC_APPROVALS_PVT dependencies on FND_API

Line 41: l_return_status := FND_API.g_ret_sts_success;

37: BEGIN
38:
39: fnd_msg_pub.initialize;
40:
41: l_return_status := FND_API.g_ret_sts_success;
42:
43: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
44: THEN
45: fnd_log.string

Line 96: RAISE FND_API.G_EXC_ERROR;

92: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
93: false
94: );
95: END IF;
96: RAISE FND_API.G_EXC_ERROR;
97: END IF;
98: CLOSE check_mc_exists;
99:
100: fnd_message.set_name('AHL', 'AHL_MC_NTF_FORWARD_SUBJECT');

Line 281: IF l_return_status = FND_API.g_ret_sts_success

277: x_approver_seq => l_approver_seq,
278: x_return_status => l_return_status
279: );
280:
281: IF l_return_status = FND_API.g_ret_sts_success
282: THEN
283: wf_engine.setitemattrnumber
284: (
285: itemtype => itemtype,

Line 323: RAISE FND_API.G_EXC_ERROR;

319: resultout := 'COMPLETE:SUCCESS';
320: RETURN;
321:
322: ELSE
323: RAISE FND_API.G_EXC_ERROR;
324: END IF;
325: END IF;
326:
327: --

Line 358: WHEN FND_API.G_EXC_ERROR THEN

354: );
355: END IF;
356:
357: EXCEPTION
358: WHEN FND_API.G_EXC_ERROR THEN
359: FND_MSG_PUB.Count_And_Get
360: (
361: p_encoded => FND_API.G_FALSE,
362: p_count => l_msg_count,

Line 361: p_encoded => FND_API.G_FALSE,

357: EXCEPTION
358: WHEN FND_API.G_EXC_ERROR THEN
359: FND_MSG_PUB.Count_And_Get
360: (
361: p_encoded => FND_API.G_FALSE,
362: p_count => l_msg_count,
363: p_data => l_msg_data
364: );
365: AHL_GENERIC_APRV_PVT.handle_error

Line 493: RAISE FND_API.G_EXC_ERROR;

489: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FORWARD_FYI',
490: false
491: );
492: END IF;
493: RAISE FND_API.G_EXC_ERROR;
494: ELSE
495: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_FWD');
496: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
497: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

Line 525: WHEN FND_API.G_EXC_ERROR THEN

521:
522: RETURN;
523:
524: EXCEPTION
525: WHEN FND_API.G_EXC_ERROR THEN
526: FND_MSG_PUB.Count_And_Get
527: (
528: p_encoded => FND_API.G_FALSE,
529: p_count => l_msg_count,

Line 528: p_encoded => FND_API.G_FALSE,

524: EXCEPTION
525: WHEN FND_API.G_EXC_ERROR THEN
526: FND_MSG_PUB.Count_And_Get
527: (
528: p_encoded => FND_API.G_FALSE,
529: p_count => l_msg_count,
530: p_data => l_msg_data
531: );
532: AHL_GENERIC_APRV_PVT.Handle_Error

Line 655: RAISE FND_API.G_EXC_ERROR;

651: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVED_FYI',
652: false
653: );
654: END IF;
655: RAISE FND_API.G_EXC_ERROR;
656: ELSE
657: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_APPRVD');
658: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
659: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

Line 687: WHEN FND_API.G_EXC_ERROR THEN

683:
684: RETURN;
685:
686: EXCEPTION
687: WHEN FND_API.G_EXC_ERROR THEN
688: FND_MSG_PUB.Count_And_Get
689: (
690: p_encoded => FND_API.G_FALSE,
691: p_count => l_msg_count,

Line 690: p_encoded => FND_API.G_FALSE,

686: EXCEPTION
687: WHEN FND_API.G_EXC_ERROR THEN
688: FND_MSG_PUB.Count_And_Get
689: (
690: p_encoded => FND_API.G_FALSE,
691: p_count => l_msg_count,
692: p_data => l_msg_data
693: );
694: AHL_GENERIC_APRV_PVT.Handle_Error

Line 808: RAISE FND_API.G_EXC_ERROR;

804: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FINAL_APPROVAL_FYI',
805: false
806: );
807: END IF;
808: RAISE FND_API.G_EXC_ERROR;
809: ELSE
810: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_FINAL');
811: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
812: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

Line 839: WHEN FND_API.G_EXC_ERROR THEN

835:
836: RETURN;
837:
838: EXCEPTION
839: WHEN FND_API.G_EXC_ERROR THEN
840: FND_MSG_PUB.Count_And_Get
841: (
842: p_encoded => FND_API.G_FALSE,
843: p_count => l_msg_count,

Line 842: p_encoded => FND_API.G_FALSE,

838: EXCEPTION
839: WHEN FND_API.G_EXC_ERROR THEN
840: FND_MSG_PUB.Count_And_Get
841: (
842: p_encoded => FND_API.G_FALSE,
843: p_count => l_msg_count,
844: p_data => l_msg_data
845: );
846: AHL_GENERIC_APRV_PVT.Handle_Error

Line 969: RAISE FND_API.G_EXC_ERROR;

965: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_REJECTED_FYI',
966: false
967: );
968: END IF;
969: RAISE FND_API.G_EXC_ERROR;
970: ELSE
971: fnd_message.set_name('AHL', 'AHL_MC_NTF_FWD_FYI_RJCT');
972: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
973: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

Line 1001: WHEN FND_API.G_EXC_ERROR THEN

997:
998: RETURN;
999:
1000: EXCEPTION
1001: WHEN FND_API.G_EXC_ERROR THEN
1002: FND_MSG_PUB.Count_And_Get
1003: (
1004: p_encoded => FND_API.G_FALSE,
1005: p_count => l_msg_count,

Line 1004: p_encoded => FND_API.G_FALSE,

1000: EXCEPTION
1001: WHEN FND_API.G_EXC_ERROR THEN
1002: FND_MSG_PUB.Count_And_Get
1003: (
1004: p_encoded => FND_API.G_FALSE,
1005: p_count => l_msg_count,
1006: p_data => l_msg_data
1007: );
1008: AHL_GENERIC_APRV_PVT.Handle_Error

Line 1138: RAISE FND_API.G_EXC_ERROR;

1134: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVAL',
1135: false
1136: );
1137: END IF;
1138: RAISE FND_API.G_EXC_ERROR;
1139: ELSE
1140: fnd_message.set_name('AHL', 'AHL_MC_NTF_APPROVAL');
1141: fnd_message.set_token('REQUESTER',l_requester, false);
1142: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);

Line 1171: WHEN FND_API.G_EXC_ERROR THEN

1167:
1168: RETURN;
1169:
1170: EXCEPTION
1171: WHEN FND_API.G_EXC_ERROR THEN
1172: FND_MSG_PUB.Count_And_Get
1173: (
1174: p_encoded => FND_API.G_FALSE,
1175: p_count => l_msg_count,

Line 1174: p_encoded => FND_API.G_FALSE,

1170: EXCEPTION
1171: WHEN FND_API.G_EXC_ERROR THEN
1172: FND_MSG_PUB.Count_And_Get
1173: (
1174: p_encoded => FND_API.G_FALSE,
1175: p_count => l_msg_count,
1176: p_data => l_msg_data
1177: );
1178: AHL_GENERIC_APRV_PVT.Handle_Error

Line 1308: RAISE FND_API.G_EXC_ERROR;

1304: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVAL_REMINDER',
1305: false
1306: );
1307: END IF;
1308: RAISE FND_API.G_EXC_ERROR;
1309: ELSE
1310: fnd_message.set_name('AHL', 'AHL_MC_NTF_REMIND');
1311: fnd_message.set_token('REQUESTER',l_requester, false);
1312: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);

Line 1341: WHEN FND_API.G_EXC_ERROR THEN

1337:
1338: RETURN;
1339:
1340: EXCEPTION
1341: WHEN FND_API.G_EXC_ERROR THEN
1342: FND_MSG_PUB.Count_And_Get
1343: (
1344: p_encoded => FND_API.G_FALSE,
1345: p_count => l_msg_count,

Line 1344: p_encoded => FND_API.G_FALSE,

1340: EXCEPTION
1341: WHEN FND_API.G_EXC_ERROR THEN
1342: FND_MSG_PUB.Count_And_Get
1343: (
1344: p_encoded => FND_API.G_FALSE,
1345: p_count => l_msg_count,
1346: p_data => l_msg_data
1347: );
1348: AHL_GENERIC_APRV_PVT.Handle_Error

Line 1468: RAISE FND_API.G_EXC_ERROR;

1464: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_ERROR_ACT',
1465: false
1466: );
1467: END IF;
1468: RAISE FND_API.G_EXC_ERROR;
1469: ELSE
1470: fnd_message.set_name('AHL', 'AHL_MC_NTF_ERROR_ACT');
1471: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id ,false);
1472: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);

Line 1500: WHEN FND_API.G_EXC_ERROR THEN

1496:
1497: RETURN;
1498:
1499: EXCEPTION
1500: WHEN FND_API.G_EXC_ERROR THEN
1501: FND_MSG_PUB.Count_And_Get
1502: (
1503: p_encoded => FND_API.G_FALSE,
1504: p_count => l_msg_count,

Line 1503: p_encoded => FND_API.G_FALSE,

1499: EXCEPTION
1500: WHEN FND_API.G_EXC_ERROR THEN
1501: FND_MSG_PUB.Count_And_Get
1502: (
1503: p_encoded => FND_API.G_FALSE,
1504: p_count => l_msg_count,
1505: p_data => l_msg_data
1506: );
1507: AHL_GENERIC_APRV_PVT.Handle_Error

Line 1632: RAISE FND_API.G_EXC_ERROR;

1628: 'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS',
1629: false
1630: );
1631: END IF;
1632: RAISE FND_API.G_EXC_ERROR;
1633: END IF;
1634: CLOSE check_mc_exists;
1635:
1636: UPDATE ahl_mc_headers_b

Line 1687: WHEN FND_API.g_exc_error THEN

1683: );
1684: END IF;
1685:
1686: EXCEPTION
1687: WHEN FND_API.g_exc_error THEN
1688: FND_MSG_PUB.Count_And_Get
1689: (
1690: p_encoded => FND_API.G_FALSE,
1691: p_count => l_msg_count,

Line 1690: p_encoded => FND_API.G_FALSE,

1686: EXCEPTION
1687: WHEN FND_API.g_exc_error THEN
1688: FND_MSG_PUB.Count_And_Get
1689: (
1690: p_encoded => FND_API.G_FALSE,
1691: p_count => l_msg_count,
1692: p_data => l_msg_data
1693: );
1694: AHL_GENERIC_APRV_PVT.Handle_Error

Line 1824: RAISE FND_API.G_EXC_ERROR;

1820: 'ahl.plsql.AHL_MC_Approvals_PVT.REVERT_STATUS',
1821: false
1822: );
1823: END IF;
1824: RAISE FND_API.G_EXC_ERROR;
1825: END IF;
1826: CLOSE check_mc_exists;
1827:
1828: UPDATE ahl_mc_headers_b

Line 1879: WHEN FND_API.g_exc_error THEN

1875: );
1876: END IF;
1877:
1878: EXCEPTION
1879: WHEN FND_API.g_exc_error THEN
1880: FND_MSG_PUB.Count_And_Get
1881: (
1882: p_encoded => FND_API.G_FALSE,
1883: p_count => l_msg_count,

Line 1882: p_encoded => FND_API.G_FALSE,

1878: EXCEPTION
1879: WHEN FND_API.g_exc_error THEN
1880: FND_MSG_PUB.Count_And_Get
1881: (
1882: p_encoded => FND_API.G_FALSE,
1883: p_count => l_msg_count,
1884: p_data => l_msg_data
1885: );
1886: AHL_GENERIC_APRV_PVT.Handle_Error