eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_IH_PUB_PS dependencies on FND_MSG_PUB

Line 785: fnd_msg_pub.initialize;

781: END IF;
782:
783: -- Initialize message list if p_init_msg_list is set to TRUE
784: IF fnd_api.to_boolean(p_init_msg_list) THEN
785: fnd_msg_pub.initialize;
786: END IF;
787:
788: -- Initialize API return status to success
789: x_return_status := fnd_api.g_ret_sts_success;

Line 924: fnd_msg_pub.count_and_get

920: COMMIT WORK;
921: END IF;
922:
923: -- Standard call to get message count and if count is 1, get message info
924: fnd_msg_pub.count_and_get
925: ( p_count => x_msg_count,
926: p_data => x_msg_data );
927: EXCEPTION
928: WHEN fnd_api.g_exc_error THEN

Line 931: fnd_msg_pub.count_and_get

927: EXCEPTION
928: WHEN fnd_api.g_exc_error THEN
929: ROLLBACK TO create_media_pub;
930: x_return_status := fnd_api.g_ret_sts_error;
931: fnd_msg_pub.count_and_get
932: ( p_count => x_msg_count,
933: p_data => x_msg_data );
934: WHEN fnd_api.g_exc_unexpected_error THEN
935: ROLLBACK TO create_media_pub;

Line 937: fnd_msg_pub.count_and_get

933: p_data => x_msg_data );
934: WHEN fnd_api.g_exc_unexpected_error THEN
935: ROLLBACK TO create_media_pub;
936: x_return_status := fnd_api.g_ret_sts_unexp_error;
937: fnd_msg_pub.count_and_get
938: ( p_count => x_msg_count,
939: p_data => x_msg_data );
940: WHEN OTHERS THEN
941: ROLLBACK TO create_media_pub;

Line 943: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

939: p_data => x_msg_data );
940: WHEN OTHERS THEN
941: ROLLBACK TO create_media_pub;
942: x_return_status := fnd_api.g_ret_sts_unexp_error;
943: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
944: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
945: END IF;
946: fnd_msg_pub.count_and_get
947: ( p_count => x_msg_count,

Line 944: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

940: WHEN OTHERS THEN
941: ROLLBACK TO create_media_pub;
942: x_return_status := fnd_api.g_ret_sts_unexp_error;
943: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
944: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
945: END IF;
946: fnd_msg_pub.count_and_get
947: ( p_count => x_msg_count,
948: p_data => x_msg_data );

Line 946: fnd_msg_pub.count_and_get

942: x_return_status := fnd_api.g_ret_sts_unexp_error;
943: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
944: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
945: END IF;
946: fnd_msg_pub.count_and_get
947: ( p_count => x_msg_count,
948: p_data => x_msg_data );
949:
950: END Create_MediaItem;

Line 990: fnd_msg_pub.initialize;

986: ----DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB_PS.Create_MediaItem');
987:
988: -- Initialize message list if p_init_msg_list is set to TRUE
989: IF fnd_api.to_boolean(p_init_msg_list) THEN
990: fnd_msg_pub.initialize;
991: END IF;
992:
993: -- Initialize API return status to success
994: x_return_status := fnd_api.g_ret_sts_success;

Line 1083: fnd_msg_pub.count_and_get

1079: COMMIT WORK;
1080: END IF;
1081:
1082: -- Standard call to get message count and if count is 1, get message info
1083: fnd_msg_pub.count_and_get
1084: ( p_count => x_msg_count,
1085: p_data => x_msg_data );
1086: EXCEPTION
1087: WHEN fnd_api.g_exc_error THEN

Line 1090: fnd_msg_pub.count_and_get

1086: EXCEPTION
1087: WHEN fnd_api.g_exc_error THEN
1088: ROLLBACK TO create_media_pub;
1089: x_return_status := fnd_api.g_ret_sts_error;
1090: fnd_msg_pub.count_and_get
1091: ( p_count => x_msg_count,
1092: p_data => x_msg_data );
1093: WHEN fnd_api.g_exc_unexpected_error THEN
1094: ROLLBACK TO create_media_pub;

Line 1096: fnd_msg_pub.count_and_get

1092: p_data => x_msg_data );
1093: WHEN fnd_api.g_exc_unexpected_error THEN
1094: ROLLBACK TO create_media_pub;
1095: x_return_status := fnd_api.g_ret_sts_unexp_error;
1096: fnd_msg_pub.count_and_get
1097: ( p_count => x_msg_count,
1098: p_data => x_msg_data );
1099: WHEN OTHERS THEN
1100: ROLLBACK TO create_media_pub;

Line 1102: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1098: p_data => x_msg_data );
1099: WHEN OTHERS THEN
1100: ROLLBACK TO create_media_pub;
1101: x_return_status := fnd_api.g_ret_sts_unexp_error;
1102: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1103: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1104: END IF;
1105: fnd_msg_pub.count_and_get
1106: ( p_count => x_msg_count,

Line 1103: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1099: WHEN OTHERS THEN
1100: ROLLBACK TO create_media_pub;
1101: x_return_status := fnd_api.g_ret_sts_unexp_error;
1102: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1103: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1104: END IF;
1105: fnd_msg_pub.count_and_get
1106: ( p_count => x_msg_count,
1107: p_data => x_msg_data );

Line 1105: fnd_msg_pub.count_and_get

1101: x_return_status := fnd_api.g_ret_sts_unexp_error;
1102: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1103: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1104: END IF;
1105: fnd_msg_pub.count_and_get
1106: ( p_count => x_msg_count,
1107: p_data => x_msg_data );
1108:
1109: END Create_MediaItem;

Line 1145: fnd_msg_pub.initialize;

1141: END IF;
1142: ----DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB_PS.Create_MediaLifecycle');
1143: -- Initialize message list if p_init_msg_list is set to TRUE
1144: IF fnd_api.to_boolean(p_init_msg_list) THEN
1145: fnd_msg_pub.initialize;
1146: END IF;
1147:
1148: -- Initialize API return status to success
1149: x_return_status := fnd_api.g_ret_sts_success;

Line 1230: fnd_msg_pub.count_and_get

1226: COMMIT WORK;
1227: END IF;
1228:
1229: -- Standard call to get message count and if count is 1, get message info
1230: fnd_msg_pub.count_and_get
1231: ( p_count => x_msg_count,
1232: p_data => x_msg_data );
1233: EXCEPTION
1234: WHEN fnd_api.g_exc_error THEN

Line 1237: fnd_msg_pub.count_and_get

1233: EXCEPTION
1234: WHEN fnd_api.g_exc_error THEN
1235: ROLLBACK TO create_media_lc_pub;
1236: x_return_status := fnd_api.g_ret_sts_error;
1237: fnd_msg_pub.count_and_get
1238: ( p_count => x_msg_count,
1239: p_data => x_msg_data );
1240: WHEN fnd_api.g_exc_unexpected_error THEN
1241: ROLLBACK TO create_media_lc_pub;

Line 1243: fnd_msg_pub.count_and_get

1239: p_data => x_msg_data );
1240: WHEN fnd_api.g_exc_unexpected_error THEN
1241: ROLLBACK TO create_media_lc_pub;
1242: x_return_status := fnd_api.g_ret_sts_unexp_error;
1243: fnd_msg_pub.count_and_get
1244: ( p_count => x_msg_count,
1245: p_data => x_msg_data );
1246: WHEN OTHERS THEN
1247: ROLLBACK TO create_media_lc_pub;

Line 1249: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1245: p_data => x_msg_data );
1246: WHEN OTHERS THEN
1247: ROLLBACK TO create_media_lc_pub;
1248: x_return_status := fnd_api.g_ret_sts_unexp_error;
1249: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1250: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1251: END IF;
1252: fnd_msg_pub.count_and_get
1253: ( p_count => x_msg_count,

Line 1250: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1246: WHEN OTHERS THEN
1247: ROLLBACK TO create_media_lc_pub;
1248: x_return_status := fnd_api.g_ret_sts_unexp_error;
1249: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1250: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1251: END IF;
1252: fnd_msg_pub.count_and_get
1253: ( p_count => x_msg_count,
1254: p_data => x_msg_data );

Line 1252: fnd_msg_pub.count_and_get

1248: x_return_status := fnd_api.g_ret_sts_unexp_error;
1249: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1250: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1251: END IF;
1252: fnd_msg_pub.count_and_get
1253: ( p_count => x_msg_count,
1254: p_data => x_msg_data );
1255:
1256: END Create_MediaLifecycle;

Line 1295: fnd_msg_pub.initialize;

1291: --DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB_PS.Create_Interaction');
1292:
1293: -- Initialize message list if p_init_msg_list is set to TRUE
1294: IF fnd_api.to_boolean(p_init_msg_list) THEN
1295: fnd_msg_pub.initialize;
1296: END IF;
1297:
1298: -- Initialize API return status to success
1299: x_return_status := fnd_api.g_ret_sts_success;

Line 1547: fnd_msg_pub.count_and_get

1543: COMMIT WORK;
1544: END IF;
1545:
1546: -- Standard call to get message count and if count is 1, get message info
1547: fnd_msg_pub.count_and_get
1548: ( p_count => x_msg_count,
1549: p_data => x_msg_data );
1550: EXCEPTION
1551: WHEN fnd_api.g_exc_error THEN

Line 1554: fnd_msg_pub.count_and_get

1550: EXCEPTION
1551: WHEN fnd_api.g_exc_error THEN
1552: ROLLBACK TO create_interaction_pub;
1553: x_return_status := fnd_api.g_ret_sts_error;
1554: fnd_msg_pub.count_and_get
1555: ( p_count => x_msg_count,
1556: p_data => x_msg_data );
1557: WHEN fnd_api.g_exc_unexpected_error THEN
1558: ROLLBACK TO create_interaction_pub;

Line 1560: fnd_msg_pub.count_and_get

1556: p_data => x_msg_data );
1557: WHEN fnd_api.g_exc_unexpected_error THEN
1558: ROLLBACK TO create_interaction_pub;
1559: x_return_status := fnd_api.g_ret_sts_unexp_error;
1560: fnd_msg_pub.count_and_get
1561: ( p_count => x_msg_count,
1562: p_data => x_msg_data );
1563: WHEN OTHERS THEN
1564: ROLLBACK TO create_interaction_pub;

Line 1566: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1562: p_data => x_msg_data );
1563: WHEN OTHERS THEN
1564: ROLLBACK TO create_interaction_pub;
1565: x_return_status := fnd_api.g_ret_sts_unexp_error;
1566: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1567: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1568: END IF;
1569: fnd_msg_pub.count_and_get
1570: ( p_count => x_msg_count,

Line 1567: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1563: WHEN OTHERS THEN
1564: ROLLBACK TO create_interaction_pub;
1565: x_return_status := fnd_api.g_ret_sts_unexp_error;
1566: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1567: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1568: END IF;
1569: fnd_msg_pub.count_and_get
1570: ( p_count => x_msg_count,
1571: p_data => x_msg_data );

Line 1569: fnd_msg_pub.count_and_get

1565: x_return_status := fnd_api.g_ret_sts_unexp_error;
1566: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1567: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1568: END IF;
1569: fnd_msg_pub.count_and_get
1570: ( p_count => x_msg_count,
1571: p_data => x_msg_data );
1572:
1573: END Create_Interaction;

Line 1611: fnd_msg_pub.initialize;

1607: END IF;
1608:
1609: -- Initialize message list if p_init_msg_list is set to TRUE
1610: IF fnd_api.to_boolean(p_init_msg_list) THEN
1611: fnd_msg_pub.initialize;
1612: END IF;
1613:
1614: -- Initialize API return status to success
1615: x_return_status := fnd_api.g_ret_sts_success;

Line 1647: fnd_msg_pub.count_and_get

1643: and media_id = p_media_id
1644: ;
1645: x_activity_count := actionCount;
1646: -- Standard call to get message count and if count is 1, get message info
1647: fnd_msg_pub.count_and_get
1648: ( p_count => x_msg_count,
1649: p_data => x_msg_data );
1650: EXCEPTION
1651: WHEN fnd_api.g_exc_error THEN

Line 1653: fnd_msg_pub.count_and_get

1649: p_data => x_msg_data );
1650: EXCEPTION
1651: WHEN fnd_api.g_exc_error THEN
1652: x_return_status := fnd_api.g_ret_sts_error;
1653: fnd_msg_pub.count_and_get
1654: ( p_count => x_msg_count,
1655: p_data => x_msg_data );
1656: WHEN fnd_api.g_exc_unexpected_error THEN
1657: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1658: fnd_msg_pub.count_and_get

1654: ( p_count => x_msg_count,
1655: p_data => x_msg_data );
1656: WHEN fnd_api.g_exc_unexpected_error THEN
1657: x_return_status := fnd_api.g_ret_sts_unexp_error;
1658: fnd_msg_pub.count_and_get
1659: ( p_count => x_msg_count,
1660: p_data => x_msg_data );
1661: WHEN OTHERS THEN
1662: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1663: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1659: ( p_count => x_msg_count,
1660: p_data => x_msg_data );
1661: WHEN OTHERS THEN
1662: x_return_status := fnd_api.g_ret_sts_unexp_error;
1663: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1664: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1665: END IF;
1666: fnd_msg_pub.count_and_get
1667: ( p_count => x_msg_count,

Line 1664: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1660: p_data => x_msg_data );
1661: WHEN OTHERS THEN
1662: x_return_status := fnd_api.g_ret_sts_unexp_error;
1663: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1664: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1665: END IF;
1666: fnd_msg_pub.count_and_get
1667: ( p_count => x_msg_count,
1668: p_data => x_msg_data );

Line 1666: fnd_msg_pub.count_and_get

1662: x_return_status := fnd_api.g_ret_sts_unexp_error;
1663: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1664: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1665: END IF;
1666: fnd_msg_pub.count_and_get
1667: ( p_count => x_msg_count,
1668: p_data => x_msg_data );
1669:
1670: END Get_InteractionActivityCount;

Line 1719: fnd_msg_pub.initialize;

1715: END IF;
1716:
1717: -- Initialize message list if p_init_msg_list is set to TRUE
1718: IF fnd_api.to_boolean(p_init_msg_list) THEN
1719: fnd_msg_pub.initialize;
1720: END IF;
1721:
1722: -- Initialize API return status to success
1723: x_return_status := fnd_api.g_ret_sts_success;

Line 1770: fnd_msg_pub.count_and_get

1766: and ((p_attribute_category = p_attribute_category) or (p_attribute_category is NULL and p_attribute_category is NULL))
1767: ;
1768: x_interaction_count := interactionCount;
1769: -- Standard call to get message count and if count is 1, get message info
1770: fnd_msg_pub.count_and_get
1771: ( p_count => x_msg_count,
1772: p_data => x_msg_data );
1773: EXCEPTION
1774: WHEN fnd_api.g_exc_error THEN

Line 1776: fnd_msg_pub.count_and_get

1772: p_data => x_msg_data );
1773: EXCEPTION
1774: WHEN fnd_api.g_exc_error THEN
1775: x_return_status := fnd_api.g_ret_sts_error;
1776: fnd_msg_pub.count_and_get
1777: ( p_count => x_msg_count,
1778: p_data => x_msg_data );
1779: WHEN fnd_api.g_exc_unexpected_error THEN
1780: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1781: fnd_msg_pub.count_and_get

1777: ( p_count => x_msg_count,
1778: p_data => x_msg_data );
1779: WHEN fnd_api.g_exc_unexpected_error THEN
1780: x_return_status := fnd_api.g_ret_sts_unexp_error;
1781: fnd_msg_pub.count_and_get
1782: ( p_count => x_msg_count,
1783: p_data => x_msg_data );
1784: WHEN OTHERS THEN
1785: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1786: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1782: ( p_count => x_msg_count,
1783: p_data => x_msg_data );
1784: WHEN OTHERS THEN
1785: x_return_status := fnd_api.g_ret_sts_unexp_error;
1786: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1787: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1788: END IF;
1789: fnd_msg_pub.count_and_get
1790: ( p_count => x_msg_count,

Line 1787: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1783: p_data => x_msg_data );
1784: WHEN OTHERS THEN
1785: x_return_status := fnd_api.g_ret_sts_unexp_error;
1786: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1787: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1788: END IF;
1789: fnd_msg_pub.count_and_get
1790: ( p_count => x_msg_count,
1791: p_data => x_msg_data );

Line 1789: fnd_msg_pub.count_and_get

1785: x_return_status := fnd_api.g_ret_sts_unexp_error;
1786: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1787: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1788: END IF;
1789: fnd_msg_pub.count_and_get
1790: ( p_count => x_msg_count,
1791: p_data => x_msg_data );
1792:
1793: END Get_InteractionCount;

Line 1833: fnd_msg_pub.initialize;

1829: --DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB_PS.Open_Interaction');
1830:
1831: -- Initialize message list if p_init_msg_list is set to TRUE
1832: IF fnd_api.to_boolean(p_init_msg_list) THEN
1833: fnd_msg_pub.initialize;
1834: END IF;
1835:
1836: -- Initialize API return status to success
1837: x_return_status := fnd_api.g_ret_sts_success;

Line 2053: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );

2049: COMMIT WORK;
2050: END IF;
2051:
2052: -- Standard call to get message count and if count is 1, get message info
2053: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
2054: EXCEPTION
2055: WHEN fnd_api.g_exc_error THEN
2056: ROLLBACK TO open_interaction_pub;
2057: x_return_status := fnd_api.g_ret_sts_error;

Line 2058: fnd_msg_pub.count_and_get

2054: EXCEPTION
2055: WHEN fnd_api.g_exc_error THEN
2056: ROLLBACK TO open_interaction_pub;
2057: x_return_status := fnd_api.g_ret_sts_error;
2058: fnd_msg_pub.count_and_get
2059: ( p_count => x_msg_count,
2060: p_data => x_msg_data );
2061: WHEN fnd_api.g_exc_unexpected_error THEN
2062: ROLLBACK TO open_interaction_pub;

Line 2064: fnd_msg_pub.count_and_get

2060: p_data => x_msg_data );
2061: WHEN fnd_api.g_exc_unexpected_error THEN
2062: ROLLBACK TO open_interaction_pub;
2063: x_return_status := fnd_api.g_ret_sts_unexp_error;
2064: fnd_msg_pub.count_and_get
2065: ( p_count => x_msg_count,
2066: p_data => x_msg_data );
2067: WHEN OTHERS THEN
2068: ROLLBACK TO open_interaction_pub;

Line 2070: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2066: p_data => x_msg_data );
2067: WHEN OTHERS THEN
2068: ROLLBACK TO open_interaction_pub;
2069: x_return_status := fnd_api.g_ret_sts_unexp_error;
2070: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2071: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2072: END IF;
2073: fnd_msg_pub.count_and_get
2074: ( p_count => x_msg_count,

Line 2071: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

2067: WHEN OTHERS THEN
2068: ROLLBACK TO open_interaction_pub;
2069: x_return_status := fnd_api.g_ret_sts_unexp_error;
2070: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2071: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2072: END IF;
2073: fnd_msg_pub.count_and_get
2074: ( p_count => x_msg_count,
2075: p_data => x_msg_data );

Line 2073: fnd_msg_pub.count_and_get

2069: x_return_status := fnd_api.g_ret_sts_unexp_error;
2070: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2071: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2072: END IF;
2073: fnd_msg_pub.count_and_get
2074: ( p_count => x_msg_count,
2075: p_data => x_msg_data );
2076: END Open_Interaction;
2077:

Line 2116: fnd_msg_pub.initialize;

2112: --DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB_PS.Update_Interaction');
2113:
2114: -- Initialize message list if p_init_msg_list is set to TRUE
2115: IF fnd_api.to_boolean(p_init_msg_list) THEN
2116: fnd_msg_pub.initialize;
2117: END IF;
2118:
2119: -- Initialize API return status to success
2120: x_return_status := fnd_api.g_ret_sts_success;

Line 2403: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );

2399: COMMIT WORK;
2400: END IF;
2401:
2402: -- Standard call to get message count and if count is 1, get message info
2403: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
2404:
2405: EXCEPTION
2406: WHEN fnd_api.g_exc_error THEN
2407: ROLLBACK TO update_interaction_pub;

Line 2409: fnd_msg_pub.count_and_get

2405: EXCEPTION
2406: WHEN fnd_api.g_exc_error THEN
2407: ROLLBACK TO update_interaction_pub;
2408: x_return_status := fnd_api.g_ret_sts_error;
2409: fnd_msg_pub.count_and_get
2410: ( p_count => x_msg_count,
2411: p_data => x_msg_data );
2412: WHEN fnd_api.g_exc_unexpected_error THEN
2413: ROLLBACK TO update_interaction_pub;

Line 2415: fnd_msg_pub.count_and_get

2411: p_data => x_msg_data );
2412: WHEN fnd_api.g_exc_unexpected_error THEN
2413: ROLLBACK TO update_interaction_pub;
2414: x_return_status := fnd_api.g_ret_sts_unexp_error;
2415: fnd_msg_pub.count_and_get
2416: ( p_count => x_msg_count,
2417: p_data => x_msg_data );
2418: WHEN OTHERS THEN
2419: ROLLBACK TO update_interaction_pub;

Line 2421: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2417: p_data => x_msg_data );
2418: WHEN OTHERS THEN
2419: ROLLBACK TO update_interaction_pub;
2420: x_return_status := fnd_api.g_ret_sts_unexp_error;
2421: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2422: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2423: END IF;
2424: fnd_msg_pub.count_and_get
2425: ( p_count => x_msg_count,

Line 2422: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

2418: WHEN OTHERS THEN
2419: ROLLBACK TO update_interaction_pub;
2420: x_return_status := fnd_api.g_ret_sts_unexp_error;
2421: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2422: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2423: END IF;
2424: fnd_msg_pub.count_and_get
2425: ( p_count => x_msg_count,
2426: p_data => x_msg_data );

Line 2424: fnd_msg_pub.count_and_get

2420: x_return_status := fnd_api.g_ret_sts_unexp_error;
2421: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2422: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2423: END IF;
2424: fnd_msg_pub.count_and_get
2425: ( p_count => x_msg_count,
2426: p_data => x_msg_data );
2427: END Update_Interaction;
2428:

Line 2466: fnd_msg_pub.initialize;

2462: --DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB_PS.Close_Interaction');
2463:
2464: -- Initialize message list if p_init_msg_list is set to TRUE
2465: IF fnd_api.to_boolean(p_init_msg_list) THEN
2466: fnd_msg_pub.initialize;
2467: END IF;
2468:
2469: -- Initialize API return status to success
2470: x_return_status := fnd_api.g_ret_sts_success;

Line 2573: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );

2569: COMMIT WORK;
2570: END IF;
2571:
2572: -- Standard call to get message count and if count is 1, get message info
2573: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
2574: EXCEPTION
2575: WHEN fnd_api.g_exc_error THEN
2576: ROLLBACK TO close_interaction_pub1;
2577: x_return_status := fnd_api.g_ret_sts_error;

Line 2578: fnd_msg_pub.count_and_get

2574: EXCEPTION
2575: WHEN fnd_api.g_exc_error THEN
2576: ROLLBACK TO close_interaction_pub1;
2577: x_return_status := fnd_api.g_ret_sts_error;
2578: fnd_msg_pub.count_and_get
2579: ( p_count => x_msg_count,
2580: p_data => x_msg_data );
2581: WHEN fnd_api.g_exc_unexpected_error THEN
2582: ROLLBACK TO close_interaction_pub1;

Line 2584: fnd_msg_pub.count_and_get

2580: p_data => x_msg_data );
2581: WHEN fnd_api.g_exc_unexpected_error THEN
2582: ROLLBACK TO close_interaction_pub1;
2583: x_return_status := fnd_api.g_ret_sts_unexp_error;
2584: fnd_msg_pub.count_and_get
2585: ( p_count => x_msg_count,
2586: p_data => x_msg_data );
2587: WHEN OTHERS THEN
2588: ROLLBACK TO close_interaction_pub1;

Line 2590: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2586: p_data => x_msg_data );
2587: WHEN OTHERS THEN
2588: ROLLBACK TO close_interaction_pub1;
2589: x_return_status := fnd_api.g_ret_sts_unexp_error;
2590: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2591: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2592: END IF;
2593: fnd_msg_pub.count_and_get
2594: ( p_count => x_msg_count,

Line 2591: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

2587: WHEN OTHERS THEN
2588: ROLLBACK TO close_interaction_pub1;
2589: x_return_status := fnd_api.g_ret_sts_unexp_error;
2590: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2591: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2592: END IF;
2593: fnd_msg_pub.count_and_get
2594: ( p_count => x_msg_count,
2595: p_data => x_msg_data );

Line 2593: fnd_msg_pub.count_and_get

2589: x_return_status := fnd_api.g_ret_sts_unexp_error;
2590: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2591: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2592: END IF;
2593: fnd_msg_pub.count_and_get
2594: ( p_count => x_msg_count,
2595: p_data => x_msg_data );
2596:
2597: END Close_Interaction;

Line 2636: fnd_msg_pub.initialize;

2632: --DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB_PS.Add_Activity');
2633:
2634: -- Initialize message list if p_init_msg_list is set to TRUE
2635: IF fnd_api.to_boolean(p_init_msg_list) THEN
2636: fnd_msg_pub.initialize;
2637: END IF;
2638:
2639: -- Initialize API return status to success
2640: x_return_status := fnd_api.g_ret_sts_success;

Line 2778: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );

2774: COMMIT WORK;
2775: END IF;
2776:
2777: -- Standard call to get message count and if count is 1, get message info
2778: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
2779: EXCEPTION
2780: WHEN fnd_api.g_exc_error THEN
2781: ROLLBACK TO add_activity_pub;
2782: x_return_status := fnd_api.g_ret_sts_error;

Line 2783: fnd_msg_pub.count_and_get

2779: EXCEPTION
2780: WHEN fnd_api.g_exc_error THEN
2781: ROLLBACK TO add_activity_pub;
2782: x_return_status := fnd_api.g_ret_sts_error;
2783: fnd_msg_pub.count_and_get
2784: ( p_count => x_msg_count,
2785: p_data => x_msg_data );
2786: WHEN fnd_api.g_exc_unexpected_error THEN
2787: ROLLBACK TO add_activity_pub;

Line 2789: fnd_msg_pub.count_and_get

2785: p_data => x_msg_data );
2786: WHEN fnd_api.g_exc_unexpected_error THEN
2787: ROLLBACK TO add_activity_pub;
2788: x_return_status := fnd_api.g_ret_sts_unexp_error;
2789: fnd_msg_pub.count_and_get
2790: ( p_count => x_msg_count,
2791: p_data => x_msg_data );
2792: WHEN OTHERS THEN
2793: ROLLBACK TO add_activity_pub;

Line 2795: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2791: p_data => x_msg_data );
2792: WHEN OTHERS THEN
2793: ROLLBACK TO add_activity_pub;
2794: x_return_status := fnd_api.g_ret_sts_unexp_error;
2795: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2796: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2797: END IF;
2798: fnd_msg_pub.count_and_get
2799: ( p_count => x_msg_count,

Line 2796: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

2792: WHEN OTHERS THEN
2793: ROLLBACK TO add_activity_pub;
2794: x_return_status := fnd_api.g_ret_sts_unexp_error;
2795: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2796: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2797: END IF;
2798: fnd_msg_pub.count_and_get
2799: ( p_count => x_msg_count,
2800: p_data => x_msg_data );

Line 2798: fnd_msg_pub.count_and_get

2794: x_return_status := fnd_api.g_ret_sts_unexp_error;
2795: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2796: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2797: END IF;
2798: fnd_msg_pub.count_and_get
2799: ( p_count => x_msg_count,
2800: p_data => x_msg_data );
2801: END Add_Activity;
2802:

Line 2839: fnd_msg_pub.initialize;

2835: --DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB_PS.Update_Activity');
2836:
2837: -- Initialize message list if p_init_msg_list is set to TRUE
2838: IF fnd_api.to_boolean(p_init_msg_list) THEN
2839: fnd_msg_pub.initialize;
2840: END IF;
2841:
2842: -- Initialize API return status to success
2843: x_return_status := fnd_api.g_ret_sts_success;

Line 3017: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );

3013: COMMIT WORK;
3014: END IF;
3015:
3016: -- Standard call to get message count and if count is 1, get message info
3017: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
3018: EXCEPTION
3019: WHEN fnd_api.g_exc_error THEN
3020: ROLLBACK TO update_activity_pub;
3021: x_return_status := fnd_api.g_ret_sts_error;

Line 3022: fnd_msg_pub.count_and_get

3018: EXCEPTION
3019: WHEN fnd_api.g_exc_error THEN
3020: ROLLBACK TO update_activity_pub;
3021: x_return_status := fnd_api.g_ret_sts_error;
3022: fnd_msg_pub.count_and_get
3023: ( p_count => x_msg_count,
3024: p_data => x_msg_data );
3025: WHEN fnd_api.g_exc_unexpected_error THEN
3026: ROLLBACK TO update_activity_pub;

Line 3028: fnd_msg_pub.count_and_get

3024: p_data => x_msg_data );
3025: WHEN fnd_api.g_exc_unexpected_error THEN
3026: ROLLBACK TO update_activity_pub;
3027: x_return_status := fnd_api.g_ret_sts_unexp_error;
3028: fnd_msg_pub.count_and_get
3029: ( p_count => x_msg_count,
3030: p_data => x_msg_data );
3031: WHEN OTHERS THEN
3032: ROLLBACK TO update_activity_pub;

Line 3034: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3030: p_data => x_msg_data );
3031: WHEN OTHERS THEN
3032: ROLLBACK TO update_activity_pub;
3033: x_return_status := fnd_api.g_ret_sts_unexp_error;
3034: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3035: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3036: END IF;
3037: fnd_msg_pub.count_and_get
3038: ( p_count => x_msg_count,

Line 3035: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

3031: WHEN OTHERS THEN
3032: ROLLBACK TO update_activity_pub;
3033: x_return_status := fnd_api.g_ret_sts_unexp_error;
3034: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3035: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3036: END IF;
3037: fnd_msg_pub.count_and_get
3038: ( p_count => x_msg_count,
3039: p_data => x_msg_data );

Line 3037: fnd_msg_pub.count_and_get

3033: x_return_status := fnd_api.g_ret_sts_unexp_error;
3034: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3035: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3036: END IF;
3037: fnd_msg_pub.count_and_get
3038: ( p_count => x_msg_count,
3039: p_data => x_msg_data );
3040: END Update_Activity;
3041:

Line 3079: fnd_msg_pub.initialize;

3075: --DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB_PS.Close_Interaction_2');
3076:
3077: -- Initialize message list if p_init_msg_list is set to TRUE
3078: IF fnd_api.to_boolean(p_init_msg_list) THEN
3079: fnd_msg_pub.initialize;
3080: END IF;
3081:
3082: -- Initialize API return status to success
3083: x_return_status := fnd_api.g_ret_sts_success;

Line 3170: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );

3166: COMMIT WORK;
3167: END IF;
3168:
3169: -- Standard call to get message count and if count is 1, get message info
3170: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
3171: EXCEPTION
3172: WHEN fnd_api.g_exc_error THEN
3173: ROLLBACK TO close_interaction_pub2;
3174: x_return_status := fnd_api.g_ret_sts_error;

Line 3175: fnd_msg_pub.count_and_get

3171: EXCEPTION
3172: WHEN fnd_api.g_exc_error THEN
3173: ROLLBACK TO close_interaction_pub2;
3174: x_return_status := fnd_api.g_ret_sts_error;
3175: fnd_msg_pub.count_and_get
3176: ( p_count => x_msg_count,
3177: p_data => x_msg_data );
3178: WHEN fnd_api.g_exc_unexpected_error THEN
3179: ROLLBACK TO close_interaction_pub2;

Line 3181: fnd_msg_pub.count_and_get

3177: p_data => x_msg_data );
3178: WHEN fnd_api.g_exc_unexpected_error THEN
3179: ROLLBACK TO close_interaction_pub2;
3180: x_return_status := fnd_api.g_ret_sts_unexp_error;
3181: fnd_msg_pub.count_and_get
3182: ( p_count => x_msg_count,
3183: p_data => x_msg_data );
3184: WHEN OTHERS THEN
3185: ROLLBACK TO close_interaction_pub2;

Line 3187: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3183: p_data => x_msg_data );
3184: WHEN OTHERS THEN
3185: ROLLBACK TO close_interaction_pub2;
3186: x_return_status := fnd_api.g_ret_sts_unexp_error;
3187: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3188: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3189: END IF;
3190: fnd_msg_pub.count_and_get
3191: ( p_count => x_msg_count,

Line 3188: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

3184: WHEN OTHERS THEN
3185: ROLLBACK TO close_interaction_pub2;
3186: x_return_status := fnd_api.g_ret_sts_unexp_error;
3187: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3188: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3189: END IF;
3190: fnd_msg_pub.count_and_get
3191: ( p_count => x_msg_count,
3192: p_data => x_msg_data );

Line 3190: fnd_msg_pub.count_and_get

3186: x_return_status := fnd_api.g_ret_sts_unexp_error;
3187: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3188: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3189: END IF;
3190: fnd_msg_pub.count_and_get
3191: ( p_count => x_msg_count,
3192: p_data => x_msg_data );
3193:
3194: END Close_Interaction;

Line 3233: fnd_msg_pub.initialize;

3229: --DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB_PS.Update_ActivityDuration');
3230:
3231: -- Initialize message list if p_init_msg_list is set to TRUE
3232: IF fnd_api.to_boolean(p_init_msg_list) THEN
3233: fnd_msg_pub.initialize;
3234: END IF;
3235:
3236: -- Initialize API return status to success
3237: x_return_status := fnd_api.g_ret_sts_success;

Line 3298: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );

3294: COMMIT WORK;
3295: END IF;
3296:
3297: -- Standard call to get message count and if count is 1, get message info
3298: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
3299: EXCEPTION
3300: WHEN fnd_api.g_exc_error THEN
3301: ROLLBACK TO update_activityDuration;
3302: x_return_status := fnd_api.g_ret_sts_error;

Line 3303: fnd_msg_pub.count_and_get

3299: EXCEPTION
3300: WHEN fnd_api.g_exc_error THEN
3301: ROLLBACK TO update_activityDuration;
3302: x_return_status := fnd_api.g_ret_sts_error;
3303: fnd_msg_pub.count_and_get
3304: ( p_count => x_msg_count,
3305: p_data => x_msg_data );
3306: WHEN fnd_api.g_exc_unexpected_error THEN
3307: ROLLBACK TO update_activityDuration;

Line 3309: fnd_msg_pub.count_and_get

3305: p_data => x_msg_data );
3306: WHEN fnd_api.g_exc_unexpected_error THEN
3307: ROLLBACK TO update_activityDuration;
3308: x_return_status := fnd_api.g_ret_sts_unexp_error;
3309: fnd_msg_pub.count_and_get
3310: ( p_count => x_msg_count,
3311: p_data => x_msg_data );
3312: WHEN OTHERS THEN
3313: ROLLBACK TO update_activityDuration;

Line 3315: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3311: p_data => x_msg_data );
3312: WHEN OTHERS THEN
3313: ROLLBACK TO update_activityDuration;
3314: x_return_status := fnd_api.g_ret_sts_unexp_error;
3315: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3316: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3317: END IF;
3318: fnd_msg_pub.count_and_get
3319: ( p_count => x_msg_count,

Line 3316: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

3312: WHEN OTHERS THEN
3313: ROLLBACK TO update_activityDuration;
3314: x_return_status := fnd_api.g_ret_sts_unexp_error;
3315: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3316: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3317: END IF;
3318: fnd_msg_pub.count_and_get
3319: ( p_count => x_msg_count,
3320: p_data => x_msg_data );

Line 3318: fnd_msg_pub.count_and_get

3314: x_return_status := fnd_api.g_ret_sts_unexp_error;
3315: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3316: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3317: END IF;
3318: fnd_msg_pub.count_and_get
3319: ( p_count => x_msg_count,
3320: p_data => x_msg_data );
3321: END Update_ActivityDuration;
3322: