DBA Data[Home] [Help]

APPS.JTF_DELIVERABLE_GRP dependencies on FND_MSG_PUB

Line 142: FND_MSG_PUB.initialize;

138: END IF;
139:
140: -- Initialize message list if p_init_msg_list is set to TRUE
141: IF FND_API.to_boolean(p_init_msg_list) THEN
142: FND_MSG_PUB.initialize;
143: END IF;
144:
145: -- Initialize API rturn status to success
146: x_return_status := FND_API.g_ret_sts_success;

Line 155: FND_MSG_PUB.add;

151: OR (p_start_id = -1 AND p_batch_size = 0) THEN
152: FND_MESSAGE.set_name('JTF', 'JTF_DSP_QUERY_INVLD');
153: FND_MESSAGE.set_token('0', TO_CHAR(p_start_id));
154: FND_MESSAGE.set_token('1', TO_CHAR(p_batch_size));
155: FND_MSG_PUB.add;
156: RAISE FND_API.g_exc_unexpected_error;
157: END IF;
158:
159: IF p_category_id IS NOT NULL

Line 164: FND_MSG_PUB.add;

160: AND TRIM(p_item_applicable_to) <> 'CATEGORY' THEN
161: FND_MESSAGE.set_name('JTF', 'JTF_DSP_AVAIL_INVLD');
162: FND_MESSAGE.set_token('0', TO_CHAR(p_category_id));
163: FND_MESSAGE.set_token('1', p_item_applicable_to);
164: FND_MSG_PUB.add;
165: RAISE FND_API.g_exc_unexpected_error;
166: END IF;
167:
168: IF TRIM(p_item_type) IS NOT NULL THEN

Line 252: FND_MSG_PUB.count_and_get(

248: FETCH l_dlv_cv INTO x_row_count;
249: CLOSE l_dlv_cv;
250:
251: IF x_row_count = 0 THEN
252: FND_MSG_PUB.count_and_get(
253: p_encoded => FND_API.g_false,
254: p_count => x_msg_count,
255: p_data => x_msg_data
256: );

Line 277: FND_MSG_PUB.count_and_get(

273:
274: -- Get matched rows
275: IF p_start_id > -1 THEN
276: IF p_start_id >= x_row_count THEN
277: FND_MSG_PUB.count_and_get(
278: p_encoded => FND_API.g_false,
279: p_count => x_msg_count,
280: p_data => x_msg_data
281: );

Line 614: FND_MSG_PUB.count_and_get(

610: CLOSE l_dlv_cv;
611: */
612:
613: -- Standard call to get message count and if count is 1, get message info
614: FND_MSG_PUB.count_and_get(
615: p_encoded => FND_API.g_false,
616: p_count => x_msg_count,
617: p_data => x_msg_data
618: );

Line 624: FND_MSG_PUB.count_and_get(

620: EXCEPTION
621:
622: WHEN FND_API.g_exc_unexpected_error THEN
623: x_return_status := FND_API.g_ret_sts_unexp_error ;
624: FND_MSG_PUB.count_and_get(
625: p_encoded => FND_API.g_false,
626: p_count => x_msg_count,
627: p_data => x_msg_data
628: );

Line 633: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

629:
630: WHEN OTHERS THEN
631: x_return_status := FND_API.g_ret_sts_unexp_error ;
632:
633: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
634: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
635: END IF;
636:
637: FND_MSG_PUB.count_and_get(

Line 634: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

630: WHEN OTHERS THEN
631: x_return_status := FND_API.g_ret_sts_unexp_error ;
632:
633: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
634: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
635: END IF;
636:
637: FND_MSG_PUB.count_and_get(
638: p_encoded => FND_API.g_false,

Line 637: FND_MSG_PUB.count_and_get(

633: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
634: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
635: END IF;
636:
637: FND_MSG_PUB.count_and_get(
638: p_encoded => FND_API.g_false,
639: p_count => x_msg_count,
640: p_data => x_msg_data
641: );

Line 704: FND_MSG_PUB.initialize;

700: END IF;
701:
702: -- Initialize message list if p_init_msg_list is set to TRUE
703: IF FND_API.to_boolean(p_init_msg_list) THEN
704: FND_MSG_PUB.initialize;
705: END IF;
706:
707: -- Initialize API rturn status to success
708: x_return_status := FND_API.g_ret_sts_success;

Line 873: FND_MSG_PUB.count_and_get(

869: COMMIT;
870: END IF;
871:
872: -- Standard call to get message count and if count is 1, get message info
873: FND_MSG_PUB.count_and_get(
874: p_encoded => FND_API.g_false,
875: p_count => x_msg_count,
876: p_data => x_msg_data
877: );

Line 885: FND_MSG_PUB.count_and_get(

881: WHEN FND_API.g_exc_error THEN
882: ROLLBACK TO save_deliverable_grp;
883: x_return_status := FND_API.g_ret_sts_error;
884: p_deliverable_rec.x_action_status := FND_API.g_ret_sts_error;
885: FND_MSG_PUB.count_and_get(
886: p_encoded => FND_API.g_false,
887: p_count => x_msg_count,
888: p_data => x_msg_data
889: );

Line 895: FND_MSG_PUB.count_and_get(

891: WHEN FND_API.g_exc_unexpected_error THEN
892: ROLLBACK TO save_deliverable_grp;
893: x_return_status := FND_API.g_ret_sts_unexp_error;
894: p_deliverable_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
895: FND_MSG_PUB.count_and_get(
896: p_encoded => FND_API.g_false,
897: p_count => x_msg_count,
898: p_data => x_msg_data
899: );

Line 906: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

902: ROLLBACK TO save_deliverable_grp;
903: x_return_status := FND_API.g_ret_sts_unexp_error;
904: p_deliverable_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
905:
906: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
907: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
908: END IF;
909:
910: FND_MSG_PUB.count_and_get(

Line 907: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

903: x_return_status := FND_API.g_ret_sts_unexp_error;
904: p_deliverable_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
905:
906: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
907: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
908: END IF;
909:
910: FND_MSG_PUB.count_and_get(
911: p_encoded => FND_API.g_false,

Line 910: FND_MSG_PUB.count_and_get(

906: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
907: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
908: END IF;
909:
910: FND_MSG_PUB.count_and_get(
911: p_encoded => FND_API.g_false,
912: p_count => x_msg_count,
913: p_data => x_msg_data
914: );

Line 973: FND_MSG_PUB.initialize;

969: END IF;
970:
971: -- Initialize message list if p_init_msg_list is set to TRUE
972: IF FND_API.to_boolean(p_init_msg_list) THEN
973: FND_MSG_PUB.initialize;
974: END IF;
975:
976: -- Initialize API rturn status to success
977: x_return_status := FND_API.g_ret_sts_success;

Line 1009: FND_MSG_PUB.count_and_get(

1005: COMMIT;
1006: END IF;
1007:
1008: -- Standard call to get message count and if count is 1, get message info
1009: FND_MSG_PUB.count_and_get(
1010: p_encoded => FND_API.g_false,
1011: p_count => x_msg_count,
1012: p_data => x_msg_data
1013: );

Line 1021: FND_MSG_PUB.count_and_get(

1017:
1018: WHEN FND_API.g_exc_error THEN
1019: ROLLBACK TO save_deliverable_grp;
1020: x_return_status := FND_API.g_ret_sts_error;
1021: FND_MSG_PUB.count_and_get(
1022: p_encoded => FND_API.g_false,
1023: p_count => x_msg_count,
1024: p_data => x_msg_data
1025: );

Line 1030: FND_MSG_PUB.count_and_get(

1026:
1027: WHEN FND_API.g_exc_unexpected_error THEN
1028: ROLLBACK TO save_deliverable_grp;
1029: x_return_status := FND_API.g_ret_sts_unexp_error ;
1030: FND_MSG_PUB.count_and_get(
1031: p_encoded => FND_API.g_false,
1032: p_count => x_msg_count,
1033: p_data => x_msg_data
1034: );

Line 1041: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1037: WHEN OTHERS THEN
1038: ROLLBACK TO save_deliverable_grp;
1039: x_return_status := FND_API.g_ret_sts_unexp_error ;
1040:
1041: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1042: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1043: END IF;
1044:
1045: FND_MSG_PUB.count_and_get(

Line 1042: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1038: ROLLBACK TO save_deliverable_grp;
1039: x_return_status := FND_API.g_ret_sts_unexp_error ;
1040:
1041: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1042: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1043: END IF;
1044:
1045: FND_MSG_PUB.count_and_get(
1046: p_encoded => FND_API.g_false,

Line 1045: FND_MSG_PUB.count_and_get(

1041: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1042: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1043: END IF;
1044:
1045: FND_MSG_PUB.count_and_get(
1046: p_encoded => FND_API.g_false,
1047: p_count => x_msg_count,
1048: p_data => x_msg_data
1049: );

Line 1126: FND_MSG_PUB.initialize;

1122: END IF;
1123:
1124: -- Initialize message list if p_init_msg_list is set to TRUE
1125: IF FND_API.to_boolean(p_init_msg_list) THEN
1126: FND_MSG_PUB.initialize;
1127: END IF;
1128:
1129: -- Initialize API rturn status to success
1130: x_return_status := FND_API.g_ret_sts_success;

Line 1302: IF FND_MSG_PUB.check_msg_level(

1298: ROLLBACK TO save_one_attachment_grp;
1299: p_dlv_ath_rec.x_ath_action_status := FND_API.g_ret_sts_unexp_error;
1300: x_return_status := FND_API.g_ret_sts_unexp_error ;
1301:
1302: IF FND_MSG_PUB.check_msg_level(
1303: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1304: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1305: END IF;
1306: END;

Line 1303: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1299: p_dlv_ath_rec.x_ath_action_status := FND_API.g_ret_sts_unexp_error;
1300: x_return_status := FND_API.g_ret_sts_unexp_error ;
1301:
1302: IF FND_MSG_PUB.check_msg_level(
1303: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1304: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1305: END IF;
1306: END;
1307:

Line 1304: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1300: x_return_status := FND_API.g_ret_sts_unexp_error ;
1301:
1302: IF FND_MSG_PUB.check_msg_level(
1303: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1304: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1305: END IF;
1306: END;
1307:
1308: -- Check if the caller requested to commit ,

Line 1315: FND_MSG_PUB.count_and_get(

1311: COMMIT;
1312: END IF;
1313:
1314: -- Standard call to get message count and if count is 1, get message info
1315: FND_MSG_PUB.count_and_get(
1316: p_encoded => FND_API.g_false,
1317: p_count => x_msg_count,
1318: p_data => x_msg_data
1319: );

Line 1327: FND_MSG_PUB.count_and_get(

1323: WHEN FND_API.g_exc_error THEN
1324: ROLLBACK TO save_deliverable_grp;
1325: x_return_status := FND_API.g_ret_sts_error;
1326: p_dlv_ath_rec.x_action_status := FND_API.g_ret_sts_error;
1327: FND_MSG_PUB.count_and_get(
1328: p_encoded => FND_API.g_false,
1329: p_count => x_msg_count,
1330: p_data => x_msg_data
1331: );

Line 1337: FND_MSG_PUB.count_and_get(

1333: WHEN FND_API.g_exc_unexpected_error THEN
1334: ROLLBACK TO save_deliverable_grp;
1335: x_return_status := FND_API.g_ret_sts_unexp_error ;
1336: p_dlv_ath_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
1337: FND_MSG_PUB.count_and_get(
1338: p_encoded => FND_API.g_false,
1339: p_count => x_msg_count,
1340: p_data => x_msg_data
1341: );

Line 1348: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1344: ROLLBACK TO save_deliverable_grp;
1345: x_return_status := FND_API.g_ret_sts_unexp_error ;
1346: p_dlv_ath_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
1347:
1348: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1349: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1350: END IF;
1351:
1352: FND_MSG_PUB.count_and_get(

Line 1349: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1345: x_return_status := FND_API.g_ret_sts_unexp_error ;
1346: p_dlv_ath_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
1347:
1348: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1349: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1350: END IF;
1351:
1352: FND_MSG_PUB.count_and_get(
1353: p_encoded => FND_API.g_false,

Line 1352: FND_MSG_PUB.count_and_get(

1348: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1349: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1350: END IF;
1351:
1352: FND_MSG_PUB.count_and_get(
1353: p_encoded => FND_API.g_false,
1354: p_count => x_msg_count,
1355: p_data => x_msg_data
1356: );

Line 1422: FND_MSG_PUB.initialize;

1418: END IF;
1419:
1420: -- Initialize message list if p_init_msg_list is set to TRUE
1421: IF FND_API.to_boolean(p_init_msg_list) THEN
1422: FND_MSG_PUB.initialize;
1423: END IF;
1424:
1425: -- Initialize API rturn status to success
1426: x_return_status := FND_API.g_ret_sts_success;

Line 1458: FND_MSG_PUB.count_and_get(

1454: COMMIT;
1455: END IF;
1456:
1457: -- Standard call to get message count and if count is 1, get message info
1458: FND_MSG_PUB.count_and_get(
1459: p_encoded => FND_API.g_false,
1460: p_count => x_msg_count,
1461: p_data => x_msg_data
1462: );

Line 1469: FND_MSG_PUB.count_and_get(

1465:
1466: WHEN FND_API.g_exc_error THEN
1467: ROLLBACK TO save_deliverable_grp;
1468: x_return_status := FND_API.g_ret_sts_error;
1469: FND_MSG_PUB.count_and_get(
1470: p_encoded => FND_API.g_false,
1471: p_count => x_msg_count,
1472: p_data => x_msg_data
1473: );

Line 1478: FND_MSG_PUB.count_and_get(

1474:
1475: WHEN FND_API.g_exc_unexpected_error THEN
1476: ROLLBACK TO save_deliverable_grp;
1477: x_return_status := FND_API.g_ret_sts_unexp_error ;
1478: FND_MSG_PUB.count_and_get(
1479: p_encoded => FND_API.g_false,
1480: p_count => x_msg_count,
1481: p_data => x_msg_data
1482: );

Line 1488: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1484: WHEN OTHERS THEN
1485: ROLLBACK TO save_deliverable_grp;
1486: x_return_status := FND_API.g_ret_sts_unexp_error ;
1487:
1488: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1489: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1490: END IF;
1491:
1492: FND_MSG_PUB.count_and_get(

Line 1489: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1485: ROLLBACK TO save_deliverable_grp;
1486: x_return_status := FND_API.g_ret_sts_unexp_error ;
1487:
1488: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1489: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1490: END IF;
1491:
1492: FND_MSG_PUB.count_and_get(
1493: p_encoded => FND_API.g_false,

Line 1492: FND_MSG_PUB.count_and_get(

1488: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1489: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1490: END IF;
1491:
1492: FND_MSG_PUB.count_and_get(
1493: p_encoded => FND_API.g_false,
1494: p_count => x_msg_count,
1495: p_data => x_msg_data
1496: );

Line 1554: FND_MSG_PUB.initialize;

1550: END IF;
1551:
1552: -- Initialize message list if p_init_msg_list is set to TRUE
1553: IF FND_API.to_boolean(p_init_msg_list) THEN
1554: FND_MSG_PUB.initialize;
1555: END IF;
1556:
1557: -- Initialize API rturn status to success
1558: x_return_status := FND_API.g_ret_sts_success;

Line 1651: IF FND_MSG_PUB.check_msg_level(

1647: x_return_status := FND_API.g_ret_sts_unexp_error ;
1648: p_dlv_id_ver_tbl(l_index).x_action_status
1649: := FND_API.g_ret_sts_unexp_error;
1650:
1651: IF FND_MSG_PUB.check_msg_level(
1652: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1653: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1654: END IF;
1655:

Line 1652: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1648: p_dlv_id_ver_tbl(l_index).x_action_status
1649: := FND_API.g_ret_sts_unexp_error;
1650:
1651: IF FND_MSG_PUB.check_msg_level(
1652: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1653: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1654: END IF;
1655:
1656: END;

Line 1653: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1649: := FND_API.g_ret_sts_unexp_error;
1650:
1651: IF FND_MSG_PUB.check_msg_level(
1652: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1653: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1654: END IF;
1655:
1656: END;
1657: END LOOP;

Line 1667: FND_MSG_PUB.count_and_get(

1663: COMMIT;
1664: END IF;
1665:
1666: -- Standard call to get message count and if count is 1, get message info
1667: FND_MSG_PUB.count_and_get(
1668: p_encoded => FND_API.g_false,
1669: p_count => x_msg_count,
1670: p_data => x_msg_data
1671: );

Line 1678: FND_MSG_PUB.count_and_get(

1674:
1675: WHEN FND_API.g_exc_error THEN
1676: ROLLBACK TO delete_deliverable_grp;
1677: x_return_status := FND_API.g_ret_sts_error;
1678: FND_MSG_PUB.count_and_get(
1679: p_encoded => FND_API.g_false,
1680: p_count => x_msg_count,
1681: p_data => x_msg_data
1682: );

Line 1687: FND_MSG_PUB.count_and_get(

1683:
1684: WHEN FND_API.g_exc_unexpected_error THEN
1685: ROLLBACK TO delete_deliverable_grp;
1686: x_return_status := FND_API.g_ret_sts_unexp_error ;
1687: FND_MSG_PUB.count_and_get(
1688: p_encoded => FND_API.g_false,
1689: p_count => x_msg_count,
1690: p_data => x_msg_data
1691: );

Line 1697: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1693: WHEN OTHERS THEN
1694: ROLLBACK TO delete_deliverable_grp;
1695: x_return_status := FND_API.g_ret_sts_unexp_error ;
1696:
1697: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1698: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1699: END IF;
1700:
1701: FND_MSG_PUB.count_and_get(

Line 1698: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1694: ROLLBACK TO delete_deliverable_grp;
1695: x_return_status := FND_API.g_ret_sts_unexp_error ;
1696:
1697: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1698: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1699: END IF;
1700:
1701: FND_MSG_PUB.count_and_get(
1702: p_encoded => FND_API.g_false,

Line 1701: FND_MSG_PUB.count_and_get(

1697: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1698: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1699: END IF;
1700:
1701: FND_MSG_PUB.count_and_get(
1702: p_encoded => FND_API.g_false,
1703: p_count => x_msg_count,
1704: p_data => x_msg_data
1705: );