DBA Data[Home] [Help]

APPS.IGS_EN_IVR_PUB dependencies on STANDARD

Line 61: -- Standard Start of API savepoint

57: l_message_data VARCHAR2(2000);
58:
59: BEGIN
60:
61: -- Standard Start of API savepoint
62: SAVEPOINT ADDTOCART_PUB;
63:
64: -- Standard call to check for call compatibility.
65: IF NOT FND_API.COMPATIBLE_API_CALL (1.0,

Line 64: -- Standard call to check for call compatibility.

60:
61: -- Standard Start of API savepoint
62: SAVEPOINT ADDTOCART_PUB;
63:
64: -- Standard call to check for call compatibility.
65: IF NOT FND_API.COMPATIBLE_API_CALL (1.0,
66: p_api_version,
67: l_api_name,
68: g_pkg_name ) THEN

Line 201: -- Standard call to check for call compatibility.

197: BEGIN
198:
199: SAVEPOINT ENROL_CART_PUB;
200:
201: -- Standard call to check for call compatibility.
202: IF NOT FND_API.COMPATIBLE_API_CALL (1.0,
203: p_api_version,
204: l_api_name,
205: g_pkg_name ) THEN

Line 454: --Standard start of API savepoint

450: person_id = cp_person_id AND
451: course_cd = cp_program_cd AND
452: version_number = cp_version_number;
453: BEGIN
454: --Standard start of API savepoint
455: SAVEPOINT clean_up_cart;
456:
457: --Standard call to check for call compatibility.
458: IF NOT FND_API.compatible_api_call(l_api_version,

Line 457: --Standard call to check for call compatibility.

453: BEGIN
454: --Standard start of API savepoint
455: SAVEPOINT clean_up_cart;
456:
457: --Standard call to check for call compatibility.
458: IF NOT FND_API.compatible_api_call(l_api_version,
459: p_api_version,
460: l_api_name,
461: G_PKG_NAME) THEN

Line 516: --Standard check of p_commit.

512: FOR rec_sua IN cur_sua(l_person_id, l_primary_code, l_primary_version) LOOP
513: igs_en_su_attempt_pkg.delete_row(rec_sua.row_id);
514: END LOOP;
515:
516: --Standard check of p_commit.
517: IF FND_API.to_Boolean(p_commit) THEN
518: commit;
519: END IF;
520:

Line 521: --Standard call to get message count and if count is 1, get message info.

517: IF FND_API.to_Boolean(p_commit) THEN
518: commit;
519: END IF;
520:
521: --Standard call to get message count and if count is 1, get message info.
522: FND_MSG_PUB.Count_And_Get(
523: p_count => l_messaage_count,
524: p_data => l_message_data);
525:

Line 580: --Standard start of API savepoint

576: l_message_data VARCHAR2(1000);
577: l_return_status VARCHAR2(10);
578: l_error_message VARCHAR2(1000);
579: BEGIN
580: --Standard start of API savepoint
581: SAVEPOINT drop_all_section;
582:
583: --Standard call to check for call compatibility.
584: IF NOT FND_API.Compatible_API_Call(l_api_version,

Line 583: --Standard call to check for call compatibility.

579: BEGIN
580: --Standard start of API savepoint
581: SAVEPOINT drop_all_section;
582:
583: --Standard call to check for call compatibility.
584: IF NOT FND_API.Compatible_API_Call(l_api_version,
585: p_api_version,
586: l_api_name,
587: G_PKG_NAME) THEN

Line 626: --Standard check of p_commit.

622: x_msg_count := l_messaage_count;
623: x_msg_data := l_message_data;
624: END IF;
625:
626: --Standard check of p_commit.
627: IF FND_API.to_Boolean(p_commit) THEN
628: commit;
629: END IF;
630:

Line 631: --Standard call to get message count and if count is 1, get message info.

627: IF FND_API.to_Boolean(p_commit) THEN
628: commit;
629: END IF;
630:
631: --Standard call to get message count and if count is 1, get message info.
632: FND_MSG_PUB.Count_And_Get(
633: p_count => l_messaage_count,
634: p_data => l_message_data);
635:

Line 693: --Standard start of API savepoint

689: l_message_data VARCHAR2(1000);
690: l_return_status VARCHAR2(10);
691: l_error_message VARCHAR2(1000);
692: BEGIN
693: --Standard start of API savepoint
694: SAVEPOINT drop_section_by_call_number;
695:
696: --Standard call to check for call compatibility.
697: IF NOT FND_API.Compatible_API_Call(l_api_version,

Line 696: --Standard call to check for call compatibility.

692: BEGIN
693: --Standard start of API savepoint
694: SAVEPOINT drop_section_by_call_number;
695:
696: --Standard call to check for call compatibility.
697: IF NOT FND_API.Compatible_API_Call(l_api_version,
698: p_api_version,
699: l_api_name,
700: G_PKG_NAME) THEN

Line 739: --Standard check of p_commit.

735: x_msg_data := l_message_data;
736: x_return_status := FND_API.G_RET_STS_ERROR;
737: END IF;
738:
739: --Standard check of p_commit.
740: IF FND_API.to_Boolean(p_commit) THEN
741: commit;
742: END IF;
743:

Line 744: --Standard call to get message count and if count is 1, get message info.

740: IF FND_API.to_Boolean(p_commit) THEN
741: commit;
742: END IF;
743:
744: --Standard call to get message count and if count is 1, get message info.
745: FND_MSG_PUB.Count_And_Get(
746: p_count => l_messaage_count,
747: p_data => l_message_data);
748:

Line 817: -- Standard call to check for call compatibility.

813: l_deny_warn igs_en_cpd_ext_v.notification_flag%TYPE;
814: l_step_eval_result VARCHAR2(6);
815:
816: BEGIN
817: -- Standard call to check for call compatibility.
818: IF NOT FND_API.COMPATIBLE_API_CALL (1.0,
819: p_api_version,
820: l_api_name,
821: g_pkg_name ) THEN

Line 992: --Standard start of API savepoint

988: sua1.person_id = sua.person_id AND
989: sua1.course_cd = sua.course_cd AND
990: sua1.uoo_id = sua.uoo_id;
991: BEGIN
992: --Standard start of API savepoint
993: SAVEPOINT list_schedule;
994:
995: --Standard call to check for call compatibility.
996: IF NOT FND_API.Compatible_API_Call(l_api_version,

Line 995: --Standard call to check for call compatibility.

991: BEGIN
992: --Standard start of API savepoint
993: SAVEPOINT list_schedule;
994:
995: --Standard call to check for call compatibility.
996: IF NOT FND_API.Compatible_API_Call(l_api_version,
997: p_api_version,
998: l_api_name,
999: G_PKG_NAME) THEN

Line 1084: --Standard check of p_commit.

1080: x_msg_count := l_messaage_count;
1081: x_msg_data := l_message_data;
1082: END IF;
1083:
1084: --Standard check of p_commit.
1085: IF FND_API.to_Boolean(p_commit) THEN
1086: commit;
1087: END IF;
1088:

Line 1089: --Standard call to get message count and if count is 1, get message info.

1085: IF FND_API.to_Boolean(p_commit) THEN
1086: commit;
1087: END IF;
1088:
1089: --Standard call to get message count and if count is 1, get message info.
1090: FND_MSG_PUB.Count_And_Get(
1091: p_count => l_messaage_count,
1092: p_data => l_message_data);
1093:

Line 1176: --Standard start of API savepoint

1172: WHERE load_cal_type = cp_load_cal_type AND
1173: load_ci_sequence_number = cp_load_ci_sequence_number) AND
1174: sua.unit_attempt_status IN ('INVALID','UNCONFIRM');
1175: BEGIN
1176: --Standard start of API savepoint
1177: SAVEPOINT list_section_in_cart;
1178:
1179: --Standard call to check for call compatibility.
1180: IF NOT FND_API.compatible_api_call(l_api_version,

Line 1179: --Standard call to check for call compatibility.

1175: BEGIN
1176: --Standard start of API savepoint
1177: SAVEPOINT list_section_in_cart;
1178:
1179: --Standard call to check for call compatibility.
1180: IF NOT FND_API.compatible_api_call(l_api_version,
1181: p_api_version,
1182: l_api_name,
1183: G_PKG_NAME) THEN

Line 1253: --Standard check of p_commit.

1249: x_msg_count := l_messaage_count;
1250: x_msg_data := l_message_data;
1251: END IF;
1252:
1253: --Standard check of p_commit.
1254: IF FND_API.to_Boolean(p_commit) THEN
1255: commit;
1256: END IF;
1257:

Line 1258: --Standard call to get message count and if count is 1, get message info.

1254: IF FND_API.to_Boolean(p_commit) THEN
1255: commit;
1256: END IF;
1257:
1258: --Standard call to get message count and if count is 1, get message info.
1259: FND_MSG_PUB.Count_And_Get(
1260: p_count => l_messaage_count,
1261: p_data => l_message_data);
1262:

Line 1336: --Standard start of API savepoint

1332: course_cd = cp_course_cd AND
1333: uoo_id = cp_uoo_id;
1334: l_rec_cart cur_cart%ROWTYPE;
1335: BEGIN
1336: --Standard start of API savepoint
1337: SAVEPOINT remove_from_cart;
1338:
1339: --Standard call to check for call compatibility.
1340: IF NOT FND_API.compatible_api_call(l_api_version,

Line 1339: --Standard call to check for call compatibility.

1335: BEGIN
1336: --Standard start of API savepoint
1337: SAVEPOINT remove_from_cart;
1338:
1339: --Standard call to check for call compatibility.
1340: IF NOT FND_API.compatible_api_call(l_api_version,
1341: p_api_version,
1342: l_api_name,
1343: G_PKG_NAME) THEN

Line 1404: --Standard check of p_commit.

1400: igs_en_su_attempt_pkg.delete_row(x_rowid => l_rec_cart.rowid);
1401: END IF;
1402: CLOSE cur_cart;
1403:
1404: --Standard check of p_commit.
1405: IF FND_API.to_Boolean(p_commit) THEN
1406: commit;
1407: END IF;
1408:

Line 1409: --Standard call to get message count and if count is 1, get message info.

1405: IF FND_API.to_Boolean(p_commit) THEN
1406: commit;
1407: END IF;
1408:
1409: --Standard call to get message count and if count is 1, get message info.
1410: FND_MSG_PUB.Count_And_Get(
1411: p_count => l_messaage_count,
1412: p_data => l_message_data);
1413:

Line 1488: --Standard start of API savepoint

1484: FROM igs_ps_unit_ofr_opt puo
1485: WHERE puo.uoo_id = cp_uoo_id;
1486: l_rec_enroll_stat cur_enroll_stat%ROWTYPE;
1487: BEGIN
1488: --Standard start of API savepoint
1489: SAVEPOINT update_enroll_stats;
1490:
1491: --Standard call to check for call compatibility.
1492: IF NOT FND_API.compatible_api_call(l_api_version,

Line 1491: --Standard call to check for call compatibility.

1487: BEGIN
1488: --Standard start of API savepoint
1489: SAVEPOINT update_enroll_stats;
1490:
1491: --Standard call to check for call compatibility.
1492: IF NOT FND_API.compatible_api_call(l_api_version,
1493: p_api_version,
1494: l_api_name,
1495: G_PKG_NAME) THEN

Line 1603: --Standard check of p_commit.

1599: END;
1600: END IF;
1601: CLOSE cur_enroll_stat;
1602:
1603: --Standard check of p_commit.
1604: IF FND_API.to_Boolean(p_commit) THEN
1605: commit;
1606: END IF;
1607:

Line 1608: --Standard call to get message count and if count is 1, get message info.

1604: IF FND_API.to_Boolean(p_commit) THEN
1605: commit;
1606: END IF;
1607:
1608: --Standard call to get message count and if count is 1, get message info.
1609: FND_MSG_PUB.Count_And_Get(
1610: p_count => l_messaage_count,
1611: p_data => l_message_data);
1612:

Line 1691: --Standard start of API savepoint

1687: course_cd = cp_course_cd;
1688: l_rec_ver cur_get_ver%ROWTYPE;
1689:
1690: BEGIN
1691: --Standard start of API savepoint
1692: SAVEPOINT validate_career_program;
1693:
1694: --Standard call to check for call compatibility.
1695: IF NOT FND_API.compatible_api_call(l_api_version,

Line 1694: --Standard call to check for call compatibility.

1690: BEGIN
1691: --Standard start of API savepoint
1692: SAVEPOINT validate_career_program;
1693:
1694: --Standard call to check for call compatibility.
1695: IF NOT FND_API.compatible_api_call(l_api_version,
1696: p_api_version,
1697: l_api_name,
1698: G_PKG_NAME) THEN

Line 1812: --Standard check of p_commit.

1808: x_msg_data := NULL;
1809: RETURN;
1810: END IF;
1811:
1812: --Standard check of p_commit.
1813: IF FND_API.to_Boolean(p_commit) THEN
1814: commit;
1815: END IF;
1816:

Line 1817: --Standard call to get message count and if count is 1, get message info.

1813: IF FND_API.to_Boolean(p_commit) THEN
1814: commit;
1815: END IF;
1816:
1817: --Standard call to get message count and if count is 1, get message info.
1818: FND_MSG_PUB.Count_And_Get(
1819: p_count => l_messaage_count,
1820: p_data => l_message_data);
1821:

Line 1920: --Standard start of API savepoint

1916: AND person_id = lc_person_id;
1917:
1918: BEGIN -- main begin
1919:
1920: --Standard start of API savepoint
1921: SAVEPOINT validate_person_details;
1922:
1923: --Standard call to check for call compatibility.
1924: IF NOT FND_API.Compatible_API_Call(

Line 1923: --Standard call to check for call compatibility.

1919:
1920: --Standard start of API savepoint
1921: SAVEPOINT validate_person_details;
1922:
1923: --Standard call to check for call compatibility.
1924: IF NOT FND_API.Compatible_API_Call(
1925: l_api_version,
1926: p_api_version,
1927: l_api_name,

Line 2039: --Standard check of p_commit.

2035: END IF;
2036:
2037:
2038:
2039: --Standard check of p_commit.
2040: IF FND_API.to_Boolean(p_commit) THEN
2041: commit;
2042: END IF;
2043:

Line 2044: --Standard call to get message count and if count is 1, get message info.

2040: IF FND_API.to_Boolean(p_commit) THEN
2041: commit;
2042: END IF;
2043:
2044: --Standard call to get message count and if count is 1, get message info.
2045: FND_MSG_PUB.Count_And_Get(
2046: p_count => x_msg_count,
2047: p_data => x_msg_data);
2048:

Line 2108: -- Standard call to check for call compatibility.

2104: l_message_data VARCHAR2(2000);
2105:
2106: BEGIN
2107:
2108: -- Standard call to check for call compatibility.
2109: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version,
2110: p_api_version,
2111: l_api_name,
2112: g_pkg_name ) THEN

Line 2210: -- Standard Start of API savepoint

2206: l_waitlist VARCHAR2(1);
2207:
2208: BEGIN
2209:
2210: -- Standard Start of API savepoint
2211: SAVEPOINT WAITLIST_PUB;
2212:
2213: -- Standard call to check for call compatibility.
2214: IF NOT FND_API.COMPATIBLE_API_CALL (1.0,

Line 2213: -- Standard call to check for call compatibility.

2209:
2210: -- Standard Start of API savepoint
2211: SAVEPOINT WAITLIST_PUB;
2212:
2213: -- Standard call to check for call compatibility.
2214: IF NOT FND_API.COMPATIBLE_API_CALL (1.0,
2215: p_api_version,
2216: l_api_name,
2217: g_pkg_name ) THEN