[Home] [Help]
412: END LOOP;
413:
414: -- End of API body.
415:
416: -- Standard call to get message count and if count is 1, get message info.
417: fnd_msg_pub.count_and_get (p_count => x_msg_count,
418: p_data => x_msg_data,
419: p_encoded => fnd_api.g_false
420: );
859: END IF;
860:
861: -- End of API body.
862:
863: -- Standard call to get message count and if count is 1, get message info.
864: fnd_msg_pub.count_and_get (p_count => x_msg_count,
865: p_data => x_msg_data,
866: p_encoded => fnd_api.g_false
867: );
943: END IF;
944:
945: -- End of API body.
946:
947: -- Standard call to get message count and if count is 1, get message info.
948: fnd_msg_pub.count_and_get (p_count => x_msg_count,
949: p_data => x_msg_data,
950: p_encoded => fnd_api.g_false
951: );
1268: l_status VARCHAR2(1);
1269: l_note_msg VARCHAR2 (240);
1270: l_note_id NUMBER;
1271: BEGIN
1272: -- Standard Start of API savepoint
1273: SAVEPOINT create_role_plan;
1274:
1275: -- Standard call to check for call compatibility.
1276: IF NOT fnd_api.compatible_api_call (l_api_version,
1271: BEGIN
1272: -- Standard Start of API savepoint
1273: SAVEPOINT create_role_plan;
1274:
1275: -- Standard call to check for call compatibility.
1276: IF NOT fnd_api.compatible_api_call (l_api_version,
1277: p_api_version,
1278: l_api_name,
1279: g_pkg_name
1594: p_role_plan_id => l_role_plan_id,
1595: p_role_plan_rec => l_rec);
1596:
1597:
1598: -- Standard check of p_commit.
1599: IF fnd_api.to_boolean (p_commit)
1600: THEN
1601: COMMIT WORK;
1602: END IF;
1600: THEN
1601: COMMIT WORK;
1602: END IF;
1603:
1604: -- Standard call to get message count and if count is 1, get message info.
1605: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1606: p_data => x_msg_data,
1607: p_encoded => fnd_api.g_false
1608: );
1681: l_note_id NUMBER;
1682: l_consolidated_note VARCHAR2(2000);
1683: l_consolidated_note_new VARCHAR2(2000);
1684: BEGIN
1685: -- Standard Start of API savepoint
1686: SAVEPOINT update_role_plan;
1687:
1688: -- Standard call to check for call compatibility.
1689: IF NOT fnd_api.compatible_api_call (l_api_version,
1684: BEGIN
1685: -- Standard Start of API savepoint
1686: SAVEPOINT update_role_plan;
1687:
1688: -- Standard call to check for call compatibility.
1689: IF NOT fnd_api.compatible_api_call (l_api_version,
1690: p_api_version,
1691: l_api_name,
1692: g_pkg_name
2277: END IF;
2278: END IF;
2279: END IF;
2280:
2281: -- Standard check of p_commit.
2282: IF fnd_api.to_boolean (p_commit)
2283: THEN
2284: COMMIT WORK;
2285: END IF;
2283: THEN
2284: COMMIT WORK;
2285: END IF;
2286:
2287: -- Standard call to get message count and if count is 1, get message info.
2288: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2289: p_data => x_msg_data,
2290: p_encoded => fnd_api.g_false
2291: );
2353: l_status VARCHAR2(1);
2354: l_note_msg VARCHAR2 (240);
2355: l_note_id NUMBER;
2356: BEGIN
2357: -- Standard Start of API savepoint
2358: SAVEPOINT delete_role_plan;
2359:
2360: -- Standard call to check for call compatibility.
2361: IF NOT fnd_api.compatible_api_call (l_api_version,
2356: BEGIN
2357: -- Standard Start of API savepoint
2358: SAVEPOINT delete_role_plan;
2359:
2360: -- Standard call to check for call compatibility.
2361: IF NOT fnd_api.compatible_api_call (l_api_version,
2362: p_api_version,
2363: l_api_name,
2364: g_pkg_name
2663: END IF;
2664: END IF;
2665: END IF;
2666:
2667: -- Standard check of p_commit.
2668: IF fnd_api.to_boolean (p_commit)
2669: THEN
2670: COMMIT WORK;
2671: END IF;
2669: THEN
2670: COMMIT WORK;
2671: END IF;
2672:
2673: -- Standard call to get message count and if count is 1, get message info.
2674: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2675: p_data => x_msg_data,
2676: p_encoded => fnd_api.g_false
2677: );