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_TERRITORY_PUB dependencies on FND_MSG_PUB

Line 907: fnd_msg_pub.initialize;

903:
904: -- Initialize message list if p_init_msg_list is set to TRUE.
905: IF fnd_api.to_boolean (p_init_msg_list)
906: THEN
907: fnd_msg_pub.initialize;
908: END IF;
909:
910: -- Debug Message
911: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

Line 911: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

907: fnd_msg_pub.initialize;
908: END IF;
909:
910: -- Debug Message
911: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
912: THEN
913: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
914: fnd_message.set_name ('PROC_NAME', l_api_name);
915: fnd_msg_pub.add;

Line 915: fnd_msg_pub.add;

911: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
912: THEN
913: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
914: fnd_message.set_name ('PROC_NAME', l_api_name);
915: fnd_msg_pub.add;
916: END IF;
917:
918: -- Initialize API return status to success
919: x_return_status := fnd_api.g_ret_sts_success;

Line 1000: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

996: COMMIT WORK;
997: END IF;
998:
999: -- Debug Message
1000: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1001: THEN
1002: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1003: fnd_message.set_name ('PROC_NAME', l_api_name);
1004: fnd_msg_pub.add;

Line 1004: fnd_msg_pub.add;

1000: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1001: THEN
1002: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1003: fnd_message.set_name ('PROC_NAME', l_api_name);
1004: fnd_msg_pub.add;
1005: END IF;
1006:
1007: -- Standard call to get message count and if count is 1, get message info.
1008: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1004: fnd_msg_pub.add;
1005: END IF;
1006:
1007: -- Standard call to get message count and if count is 1, get message info.
1008: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1009: EXCEPTION
1010: WHEN fnd_api.g_exc_error
1011: THEN
1012: ROLLBACK TO create_territory_pub;

Line 1014: fnd_msg_pub.count_and_get (

1010: WHEN fnd_api.g_exc_error
1011: THEN
1012: ROLLBACK TO create_territory_pub;
1013: x_return_status := fnd_api.g_ret_sts_error;
1014: fnd_msg_pub.count_and_get (
1015: p_count => x_msg_count,
1016: p_data => x_msg_data
1017: );
1018: WHEN fnd_api.g_exc_unexpected_error

Line 1022: fnd_msg_pub.count_and_get (

1018: WHEN fnd_api.g_exc_unexpected_error
1019: THEN
1020: ROLLBACK TO create_territory_pub;
1021: x_return_status := fnd_api.g_ret_sts_unexp_error;
1022: fnd_msg_pub.count_and_get (
1023: p_count => x_msg_count,
1024: p_data => x_msg_data
1025: );
1026: WHEN OTHERS

Line 1031: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1027: THEN
1028: ROLLBACK TO create_territory_pub;
1029: x_return_status := fnd_api.g_ret_sts_unexp_error;
1030:
1031: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1032: THEN
1033: fnd_msg_pub.add_exc_msg (
1034: 'Others exception in Create_Territory PUB' || SQLERRM
1035: );

Line 1033: fnd_msg_pub.add_exc_msg (

1029: x_return_status := fnd_api.g_ret_sts_unexp_error;
1030:
1031: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1032: THEN
1033: fnd_msg_pub.add_exc_msg (
1034: 'Others exception in Create_Territory PUB' || SQLERRM
1035: );
1036: END IF;
1037:

Line 1038: fnd_msg_pub.count_and_get (

1034: 'Others exception in Create_Territory PUB' || SQLERRM
1035: );
1036: END IF;
1037:
1038: fnd_msg_pub.count_and_get (
1039: p_count => x_msg_count,
1040: p_data => x_msg_data
1041: );
1042: --

Line 1112: fnd_msg_pub.initialize;

1108:
1109: -- Initialize message list if p_init_msg_list is set to TRUE.
1110: IF fnd_api.to_boolean (p_init_msg_list)
1111: THEN
1112: fnd_msg_pub.initialize;
1113: END IF;
1114:
1115: -- Debug Message
1116: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

Line 1116: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

1112: fnd_msg_pub.initialize;
1113: END IF;
1114:
1115: -- Debug Message
1116: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1117: THEN
1118: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1119: fnd_message.set_name ('PROC_NAME', l_api_name);
1120: fnd_msg_pub.add;

Line 1120: fnd_msg_pub.add;

1116: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1117: THEN
1118: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1119: fnd_message.set_name ('PROC_NAME', l_api_name);
1120: fnd_msg_pub.add;
1121: END IF;
1122:
1123: -- Initialize API return status to success
1124: x_return_status := fnd_api.g_ret_sts_success;

Line 1156: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

1152: COMMIT WORK;
1153: END IF;
1154:
1155: -- Debug Message
1156: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1157: THEN
1158: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1159: fnd_message.set_name ('PROC_NAME', l_api_name);
1160: fnd_msg_pub.add;

Line 1160: fnd_msg_pub.add;

1156: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1157: THEN
1158: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1159: fnd_message.set_name ('PROC_NAME', l_api_name);
1160: fnd_msg_pub.add;
1161: END IF;
1162:
1163: -- Standard call to get message count and if count is 1, get message info.
1164: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1160: fnd_msg_pub.add;
1161: END IF;
1162:
1163: -- Standard call to get message count and if count is 1, get message info.
1164: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1165: EXCEPTION
1166: WHEN fnd_api.g_exc_error
1167: THEN
1168: ROLLBACK TO delete_territory_pub;

Line 1170: fnd_msg_pub.count_and_get (

1166: WHEN fnd_api.g_exc_error
1167: THEN
1168: ROLLBACK TO delete_territory_pub;
1169: x_return_status := fnd_api.g_ret_sts_error;
1170: fnd_msg_pub.count_and_get (
1171: p_count => x_msg_count,
1172: p_data => x_msg_data
1173: );
1174: WHEN fnd_api.g_exc_unexpected_error

Line 1178: fnd_msg_pub.count_and_get (

1174: WHEN fnd_api.g_exc_unexpected_error
1175: THEN
1176: ROLLBACK TO delete_territory_pub;
1177: x_return_status := fnd_api.g_ret_sts_unexp_error;
1178: fnd_msg_pub.count_and_get (
1179: p_count => x_msg_count,
1180: p_data => x_msg_data
1181: );
1182: WHEN OTHERS

Line 1187: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1183: THEN
1184: ROLLBACK TO delete_territory_pub;
1185: x_return_status := fnd_api.g_ret_sts_unexp_error;
1186:
1187: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1188: THEN
1189: fnd_msg_pub.add_exc_msg (
1190: 'Others exception in Delete_Territory PUB' || SQLERRM
1191: );

Line 1189: fnd_msg_pub.add_exc_msg (

1185: x_return_status := fnd_api.g_ret_sts_unexp_error;
1186:
1187: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1188: THEN
1189: fnd_msg_pub.add_exc_msg (
1190: 'Others exception in Delete_Territory PUB' || SQLERRM
1191: );
1192: END IF;
1193:

Line 1194: fnd_msg_pub.count_and_get (

1190: 'Others exception in Delete_Territory PUB' || SQLERRM
1191: );
1192: END IF;
1193:
1194: fnd_msg_pub.count_and_get (
1195: p_count => x_msg_count,
1196: p_data => x_msg_data
1197: );
1198: --

Line 1295: fnd_msg_pub.initialize;

1291:
1292: -- Initialize message list if p_init_msg_list is set to TRUE.
1293: IF fnd_api.to_boolean (p_init_msg_list)
1294: THEN
1295: fnd_msg_pub.initialize;
1296: END IF;
1297:
1298: -- Debug Message
1299: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

Line 1299: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

1295: fnd_msg_pub.initialize;
1296: END IF;
1297:
1298: -- Debug Message
1299: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1300: THEN
1301: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1302: fnd_message.set_name ('PROC_NAME', l_api_name);
1303: fnd_msg_pub.add;

Line 1303: fnd_msg_pub.add;

1299: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1300: THEN
1301: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1302: fnd_message.set_name ('PROC_NAME', l_api_name);
1303: fnd_msg_pub.add;
1304: END IF;
1305:
1306: -- Initialize API return status to success
1307: x_return_status := fnd_api.g_ret_sts_success;

Line 1386: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

1382: RAISE fnd_api.g_exc_error;
1383: END IF;
1384:
1385: -- Debug Message
1386: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1387: THEN
1388: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1389: fnd_message.set_name ('PROC_NAME', l_api_name);
1390: fnd_msg_pub.add;

Line 1390: fnd_msg_pub.add;

1386: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1387: THEN
1388: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1389: fnd_message.set_name ('PROC_NAME', l_api_name);
1390: fnd_msg_pub.add;
1391: END IF;
1392:
1393: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1394:

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

1389: fnd_message.set_name ('PROC_NAME', l_api_name);
1390: fnd_msg_pub.add;
1391: END IF;
1392:
1393: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1394:
1395: -- Standard check for p_commit
1396: IF fnd_api.to_boolean (p_commit)
1397: THEN

Line 1409: fnd_msg_pub.count_and_get (

1405: THEN
1406: --dbms_output.put_line('Update_Territory PUB: FND_API.G_EXC_ERROR');
1407: ROLLBACK TO update_territory_pub;
1408: x_return_status := fnd_api.g_ret_sts_error;
1409: fnd_msg_pub.count_and_get (
1410: p_count => x_msg_count,
1411: p_data => x_msg_data
1412: );
1413: WHEN fnd_api.g_exc_unexpected_error

Line 1418: fnd_msg_pub.count_and_get (

1414: THEN
1415: --dbms_output.put_line('Update_Territory PUB: FND_API.G_EXC_UNEXPECTED_ERROR');
1416: ROLLBACK TO update_territory_pub;
1417: x_return_status := fnd_api.g_ret_sts_unexp_error;
1418: fnd_msg_pub.count_and_get (
1419: p_count => x_msg_count,
1420: p_data => x_msg_data
1421: );
1422: WHEN OTHERS

Line 1428: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1424: --dbms_output.put_line('Update_Territory PUB: OTHERS - ' || SQLERRM);
1425: ROLLBACK TO update_territory_pub;
1426: x_return_status := fnd_api.g_ret_sts_unexp_error;
1427:
1428: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1429: THEN
1430: fnd_msg_pub.add_exc_msg (
1431: 'Others exception in Update_Territory PUB' || SQLERRM
1432: );

Line 1430: fnd_msg_pub.add_exc_msg (

1426: x_return_status := fnd_api.g_ret_sts_unexp_error;
1427:
1428: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1429: THEN
1430: fnd_msg_pub.add_exc_msg (
1431: 'Others exception in Update_Territory PUB' || SQLERRM
1432: );
1433: END IF;
1434:

Line 1435: fnd_msg_pub.count_and_get (

1431: 'Others exception in Update_Territory PUB' || SQLERRM
1432: );
1433: END IF;
1434:
1435: fnd_msg_pub.count_and_get (
1436: p_count => x_msg_count,
1437: p_data => x_msg_data
1438: );
1439: --

Line 1508: fnd_msg_pub.initialize;

1504:
1505: -- Initialize message list if p_init_msg_list is set to TRUE.
1506: IF fnd_api.to_boolean (p_init_msg_list)
1507: THEN
1508: fnd_msg_pub.initialize;
1509: END IF;
1510:
1511: -- Debug Message
1512: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

Line 1512: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

1508: fnd_msg_pub.initialize;
1509: END IF;
1510:
1511: -- Debug Message
1512: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1513: THEN
1514: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1515: fnd_message.set_name ('PROC_NAME', l_api_name);
1516: fnd_msg_pub.add;

Line 1516: fnd_msg_pub.add;

1512: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1513: THEN
1514: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1515: fnd_message.set_name ('PROC_NAME', l_api_name);
1516: fnd_msg_pub.add;
1517: END IF;
1518:
1519: -- Initialize API return status to success
1520: x_return_status := fnd_api.g_ret_sts_success;

Line 1551: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

1547: COMMIT WORK;
1548: END IF;
1549:
1550: -- Debug Message
1551: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1552: THEN
1553: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1554: fnd_message.set_name ('PROC_NAME', l_api_name);
1555: fnd_msg_pub.add;

Line 1555: fnd_msg_pub.add;

1551: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1552: THEN
1553: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1554: fnd_message.set_name ('PROC_NAME', l_api_name);
1555: fnd_msg_pub.add;
1556: END IF;
1557:
1558: -- Standard call to get message count and if count is 1, get message info.
1559: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1555: fnd_msg_pub.add;
1556: END IF;
1557:
1558: -- Standard call to get message count and if count is 1, get message info.
1559: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1560: EXCEPTION
1561: WHEN fnd_api.g_exc_error
1562: THEN
1563: ROLLBACK TO deactivate_territory_pub;

Line 1565: fnd_msg_pub.count_and_get (

1561: WHEN fnd_api.g_exc_error
1562: THEN
1563: ROLLBACK TO deactivate_territory_pub;
1564: x_return_status := fnd_api.g_ret_sts_error;
1565: fnd_msg_pub.count_and_get (
1566: p_count => x_msg_count,
1567: p_data => x_msg_data
1568: );
1569: WHEN fnd_api.g_exc_unexpected_error

Line 1573: fnd_msg_pub.count_and_get (

1569: WHEN fnd_api.g_exc_unexpected_error
1570: THEN
1571: ROLLBACK TO deactivate_territory_pub;
1572: x_return_status := fnd_api.g_ret_sts_unexp_error;
1573: fnd_msg_pub.count_and_get (
1574: p_count => x_msg_count,
1575: p_data => x_msg_data
1576: );
1577: WHEN OTHERS

Line 1582: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1578: THEN
1579: ROLLBACK TO deactivate_territory_pub;
1580: x_return_status := fnd_api.g_ret_sts_unexp_error;
1581:
1582: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1583: THEN
1584: fnd_msg_pub.add_exc_msg (
1585: 'Others exception in Deactivate_Territory PUB' || SQLERRM
1586: );

Line 1584: fnd_msg_pub.add_exc_msg (

1580: x_return_status := fnd_api.g_ret_sts_unexp_error;
1581:
1582: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1583: THEN
1584: fnd_msg_pub.add_exc_msg (
1585: 'Others exception in Deactivate_Territory PUB' || SQLERRM
1586: );
1587: END IF;
1588:

Line 1589: fnd_msg_pub.count_and_get (

1585: 'Others exception in Deactivate_Territory PUB' || SQLERRM
1586: );
1587: END IF;
1588:
1589: fnd_msg_pub.count_and_get (
1590: p_count => x_msg_count,
1591: p_data => x_msg_data
1592: );
1593: --

Line 1672: fnd_msg_pub.initialize;

1668: END IF;
1669: -- Initialize message list if p_init_msg_list is set to TRUE.
1670: IF fnd_api.to_boolean (p_init_msg_list)
1671: THEN
1672: fnd_msg_pub.initialize;
1673: END IF;
1674:
1675: -- Debug Message
1676: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

Line 1676: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

1672: fnd_msg_pub.initialize;
1673: END IF;
1674:
1675: -- Debug Message
1676: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1677: THEN
1678: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1679: fnd_message.set_name ('PROC_NAME', l_api_name);
1680: fnd_msg_pub.add;

Line 1680: fnd_msg_pub.add;

1676: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1677: THEN
1678: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1679: fnd_message.set_name ('PROC_NAME', l_api_name);
1680: fnd_msg_pub.add;
1681: END IF;
1682:
1683: -- Initialize API return status to success
1684: x_return_status := fnd_api.g_ret_sts_success;

Line 1740: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

1736: COMMIT WORK;
1737: END IF;
1738:
1739: -- Debug Message
1740: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1741: THEN
1742: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1743: fnd_message.set_name ('PROC_NAME', l_api_name);
1744: fnd_msg_pub.add;

Line 1744: fnd_msg_pub.add;

1740: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1741: THEN
1742: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1743: fnd_message.set_name ('PROC_NAME', l_api_name);
1744: fnd_msg_pub.add;
1745: END IF;
1746:
1747: -- Standard call to get message count and if count is 1, get message info.
1748: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1744: fnd_msg_pub.add;
1745: END IF;
1746:
1747: -- Standard call to get message count and if count is 1, get message info.
1748: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1749: EXCEPTION
1750: WHEN fnd_api.g_exc_error
1751: THEN
1752: ROLLBACK TO create_territory_pub;

Line 1754: fnd_msg_pub.count_and_get (

1750: WHEN fnd_api.g_exc_error
1751: THEN
1752: ROLLBACK TO create_territory_pub;
1753: x_return_status := fnd_api.g_ret_sts_error;
1754: fnd_msg_pub.count_and_get (
1755: p_count => x_msg_count,
1756: p_data => x_msg_data
1757: );
1758: WHEN fnd_api.g_exc_unexpected_error

Line 1762: fnd_msg_pub.count_and_get (

1758: WHEN fnd_api.g_exc_unexpected_error
1759: THEN
1760: ROLLBACK TO create_territory_pub;
1761: x_return_status := fnd_api.g_ret_sts_unexp_error;
1762: fnd_msg_pub.count_and_get (
1763: p_count => x_msg_count,
1764: p_data => x_msg_data
1765: );
1766: WHEN OTHERS

Line 1771: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1767: THEN
1768: ROLLBACK TO create_territory_pub;
1769: x_return_status := fnd_api.g_ret_sts_unexp_error;
1770:
1771: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1772: THEN
1773: fnd_msg_pub.add_exc_msg (
1774: 'Others exception in Create_Territory PUB' || SQLERRM
1775: );

Line 1773: fnd_msg_pub.add_exc_msg (

1769: x_return_status := fnd_api.g_ret_sts_unexp_error;
1770:
1771: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1772: THEN
1773: fnd_msg_pub.add_exc_msg (
1774: 'Others exception in Create_Territory PUB' || SQLERRM
1775: );
1776: END IF;
1777:

Line 1778: fnd_msg_pub.count_and_get (

1774: 'Others exception in Create_Territory PUB' || SQLERRM
1775: );
1776: END IF;
1777:
1778: fnd_msg_pub.count_and_get (
1779: p_count => x_msg_count,
1780: p_data => x_msg_data
1781: );
1782: --

Line 1849: fnd_msg_pub.initialize;

1845:
1846: -- Initialize message list if p_init_msg_list is set to TRUE.
1847: IF fnd_api.to_boolean (p_init_msg_list)
1848: THEN
1849: fnd_msg_pub.initialize;
1850: END IF;
1851:
1852: -- Debug Message
1853: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

Line 1853: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

1849: fnd_msg_pub.initialize;
1850: END IF;
1851:
1852: -- Debug Message
1853: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1854: THEN
1855: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1856: fnd_message.set_name ('PROC_NAME', l_api_name);
1857: fnd_msg_pub.add;

Line 1857: fnd_msg_pub.add;

1853: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1854: THEN
1855: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1856: fnd_message.set_name ('PROC_NAME', l_api_name);
1857: fnd_msg_pub.add;
1858: END IF;
1859:
1860: -- Initialize API return status to success
1861: x_return_status := fnd_api.g_ret_sts_success;

Line 1893: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

1889: COMMIT WORK;
1890: END IF;
1891:
1892: -- Debug Message
1893: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1894: THEN
1895: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1896: fnd_message.set_name ('PROC_NAME', l_api_name);
1897: fnd_msg_pub.add;

Line 1897: fnd_msg_pub.add;

1893: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1894: THEN
1895: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1896: fnd_message.set_name ('PROC_NAME', l_api_name);
1897: fnd_msg_pub.add;
1898: END IF;
1899:
1900: -- Standard call to get message count and if count is 1, get message info.
1901: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1897: fnd_msg_pub.add;
1898: END IF;
1899:
1900: -- Standard call to get message count and if count is 1, get message info.
1901: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1902: EXCEPTION
1903: WHEN fnd_api.g_exc_error
1904: THEN
1905: ROLLBACK TO delete_territory_pub;

Line 1907: fnd_msg_pub.count_and_get (

1903: WHEN fnd_api.g_exc_error
1904: THEN
1905: ROLLBACK TO delete_territory_pub;
1906: x_return_status := fnd_api.g_ret_sts_error;
1907: fnd_msg_pub.count_and_get (
1908: p_count => x_msg_count,
1909: p_data => x_msg_data
1910: );
1911: WHEN fnd_api.g_exc_unexpected_error

Line 1915: fnd_msg_pub.count_and_get (

1911: WHEN fnd_api.g_exc_unexpected_error
1912: THEN
1913: ROLLBACK TO delete_territory_pub;
1914: x_return_status := fnd_api.g_ret_sts_unexp_error;
1915: fnd_msg_pub.count_and_get (
1916: p_count => x_msg_count,
1917: p_data => x_msg_data
1918: );
1919: WHEN OTHERS

Line 1924: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1920: THEN
1921: ROLLBACK TO delete_territory_pub;
1922: x_return_status := fnd_api.g_ret_sts_unexp_error;
1923:
1924: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1925: THEN
1926: fnd_msg_pub.add_exc_msg (
1927: 'Others exception in Delete_Terr_Qualifier PUB' || SQLERRM
1928: );

Line 1926: fnd_msg_pub.add_exc_msg (

1922: x_return_status := fnd_api.g_ret_sts_unexp_error;
1923:
1924: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1925: THEN
1926: fnd_msg_pub.add_exc_msg (
1927: 'Others exception in Delete_Terr_Qualifier PUB' || SQLERRM
1928: );
1929: END IF;
1930:

Line 1931: fnd_msg_pub.count_and_get (

1927: 'Others exception in Delete_Terr_Qualifier PUB' || SQLERRM
1928: );
1929: END IF;
1930:
1931: fnd_msg_pub.count_and_get (
1932: p_count => x_msg_count,
1933: p_data => x_msg_data
1934: );
1935: --

Line 2010: fnd_msg_pub.initialize;

2006:
2007: -- Initialize message list if p_init_msg_list is set to TRUE.
2008: IF fnd_api.to_boolean (p_init_msg_list)
2009: THEN
2010: fnd_msg_pub.initialize;
2011: END IF;
2012:
2013: -- Debug Message
2014: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

Line 2014: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

2010: fnd_msg_pub.initialize;
2011: END IF;
2012:
2013: -- Debug Message
2014: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2015: THEN
2016: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2017: fnd_message.set_name ('PROC_NAME', l_api_name);
2018: fnd_msg_pub.add;

Line 2018: fnd_msg_pub.add;

2014: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2015: THEN
2016: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2017: fnd_message.set_name ('PROC_NAME', l_api_name);
2018: fnd_msg_pub.add;
2019: END IF;
2020:
2021: -- Initialize API return status to success
2022: x_return_status := fnd_api.g_ret_sts_success;

Line 2067: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

2063: RAISE fnd_api.g_exc_error;
2064: END IF;
2065:
2066: -- Debug Message
2067: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2068: THEN
2069: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2070: fnd_message.set_name ('PROC_NAME', l_api_name);
2071: fnd_msg_pub.add;

Line 2071: fnd_msg_pub.add;

2067: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2068: THEN
2069: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2070: fnd_message.set_name ('PROC_NAME', l_api_name);
2071: fnd_msg_pub.add;
2072: END IF;
2073:
2074: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2075:

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

2070: fnd_message.set_name ('PROC_NAME', l_api_name);
2071: fnd_msg_pub.add;
2072: END IF;
2073:
2074: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2075:
2076: -- Standard check for p_commit
2077: IF fnd_api.to_boolean (p_commit)
2078: THEN

Line 2090: fnd_msg_pub.count_and_get (

2086: THEN
2087: --dbms_output.put_line('Update_Territory Values PUB: FND_API.G_EXC_ERROR');
2088: ROLLBACK TO update_territory_pub;
2089: x_return_status := fnd_api.g_ret_sts_error;
2090: fnd_msg_pub.count_and_get (
2091: p_count => x_msg_count,
2092: p_data => x_msg_data
2093: );
2094: WHEN fnd_api.g_exc_unexpected_error

Line 2099: fnd_msg_pub.count_and_get (

2095: THEN
2096: --dbms_output.put_line('Update_Territory_Values PUB: FND_API.G_EXC_UNEXPECTED_ERROR');
2097: ROLLBACK TO update_territory_pub;
2098: x_return_status := fnd_api.g_ret_sts_unexp_error;
2099: fnd_msg_pub.count_and_get (
2100: p_count => x_msg_count,
2101: p_data => x_msg_data
2102: );
2103: WHEN OTHERS

Line 2109: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2105: --dbms_output.put_line('Update_Territory Values PUB: OTHERS - ' || SQLERRM);
2106: ROLLBACK TO update_territory_pub;
2107: x_return_status := fnd_api.g_ret_sts_unexp_error;
2108:
2109: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2110: THEN
2111: fnd_msg_pub.add_exc_msg (
2112: 'Others exception in create_terr_values ' || SQLERRM
2113: );

Line 2111: fnd_msg_pub.add_exc_msg (

2107: x_return_status := fnd_api.g_ret_sts_unexp_error;
2108:
2109: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2110: THEN
2111: fnd_msg_pub.add_exc_msg (
2112: 'Others exception in create_terr_values ' || SQLERRM
2113: );
2114: END IF;
2115:

Line 2116: fnd_msg_pub.count_and_get (

2112: 'Others exception in create_terr_values ' || SQLERRM
2113: );
2114: END IF;
2115:
2116: fnd_msg_pub.count_and_get (
2117: p_count => x_msg_count,
2118: p_data => x_msg_data
2119: );
2120: --

Line 2192: fnd_msg_pub.initialize;

2188:
2189: -- Initialize message list if p_init_msg_list is set to TRUE.
2190: IF fnd_api.to_boolean (p_init_msg_list)
2191: THEN
2192: fnd_msg_pub.initialize;
2193: END IF;
2194:
2195: -- Debug Message
2196: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

Line 2196: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

2192: fnd_msg_pub.initialize;
2193: END IF;
2194:
2195: -- Debug Message
2196: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2197: THEN
2198: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2199: fnd_message.set_name ('PROC_NAME', l_api_name);
2200: fnd_msg_pub.add;

Line 2200: fnd_msg_pub.add;

2196: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2197: THEN
2198: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2199: fnd_message.set_name ('PROC_NAME', l_api_name);
2200: fnd_msg_pub.add;
2201: END IF;
2202:
2203: -- Initialize API return status to success
2204: x_return_status := fnd_api.g_ret_sts_success;

Line 2247: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

2243: RAISE fnd_api.g_exc_error;
2244: END IF;
2245:
2246: -- Debug Message
2247: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2248: THEN
2249: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2250: fnd_message.set_name ('PROC_NAME', l_api_name);
2251: fnd_msg_pub.add;

Line 2251: fnd_msg_pub.add;

2247: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2248: THEN
2249: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2250: fnd_message.set_name ('PROC_NAME', l_api_name);
2251: fnd_msg_pub.add;
2252: END IF;
2253:
2254: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2255:

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

2250: fnd_message.set_name ('PROC_NAME', l_api_name);
2251: fnd_msg_pub.add;
2252: END IF;
2253:
2254: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2255:
2256: -- Standard check for p_commit
2257: IF fnd_api.to_boolean (p_commit)
2258: THEN

Line 2270: fnd_msg_pub.count_and_get (

2266: THEN
2267: --dbms_output.put_line('Update_Territory Values PUB: FND_API.G_EXC_ERROR');
2268: ROLLBACK TO update_territory_pub;
2269: x_return_status := fnd_api.g_ret_sts_error;
2270: fnd_msg_pub.count_and_get (
2271: p_count => x_msg_count,
2272: p_data => x_msg_data
2273: );
2274: WHEN fnd_api.g_exc_unexpected_error

Line 2279: fnd_msg_pub.count_and_get (

2275: THEN
2276: --dbms_output.put_line('Update_Territory_Values PUB: FND_API.G_EXC_UNEXPECTED_ERROR');
2277: ROLLBACK TO update_territory_pub;
2278: x_return_status := fnd_api.g_ret_sts_unexp_error;
2279: fnd_msg_pub.count_and_get (
2280: p_count => x_msg_count,
2281: p_data => x_msg_data
2282: );
2283: WHEN OTHERS

Line 2289: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2285: --dbms_output.put_line('Update_Territory Values PUB: OTHERS - ' || SQLERRM);
2286: ROLLBACK TO update_territory_pub;
2287: x_return_status := fnd_api.g_ret_sts_unexp_error;
2288:
2289: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2290: THEN
2291: fnd_msg_pub.add_exc_msg (
2292: 'Others exception in Update_Territory Values ' || SQLERRM
2293: );

Line 2291: fnd_msg_pub.add_exc_msg (

2287: x_return_status := fnd_api.g_ret_sts_unexp_error;
2288:
2289: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2290: THEN
2291: fnd_msg_pub.add_exc_msg (
2292: 'Others exception in Update_Territory Values ' || SQLERRM
2293: );
2294: END IF;
2295:

Line 2296: fnd_msg_pub.count_and_get (

2292: 'Others exception in Update_Territory Values ' || SQLERRM
2293: );
2294: END IF;
2295:
2296: fnd_msg_pub.count_and_get (
2297: p_count => x_msg_count,
2298: p_data => x_msg_data
2299: );
2300: --

Line 2367: fnd_msg_pub.initialize;

2363:
2364: -- Initialize message list if p_init_msg_list is set to TRUE.
2365: IF fnd_api.to_boolean (p_init_msg_list)
2366: THEN
2367: fnd_msg_pub.initialize;
2368: END IF;
2369:
2370: -- Debug Message
2371: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

Line 2371: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

2367: fnd_msg_pub.initialize;
2368: END IF;
2369:
2370: -- Debug Message
2371: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2372: THEN
2373: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2374: fnd_message.set_name ('PROC_NAME', l_api_name);
2375: fnd_msg_pub.add;

Line 2375: fnd_msg_pub.add;

2371: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2372: THEN
2373: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2374: fnd_message.set_name ('PROC_NAME', l_api_name);
2375: fnd_msg_pub.add;
2376: END IF;
2377:
2378: -- Initialize API return status to success
2379: x_return_status := fnd_api.g_ret_sts_success;

Line 2412: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

2408: COMMIT WORK;
2409: END IF;
2410:
2411: -- Debug Message
2412: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2413: THEN
2414: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2415: fnd_message.set_name ('PROC_NAME', l_api_name);
2416: fnd_msg_pub.add;

Line 2416: fnd_msg_pub.add;

2412: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2413: THEN
2414: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2415: fnd_message.set_name ('PROC_NAME', l_api_name);
2416: fnd_msg_pub.add;
2417: END IF;
2418:
2419: -- Standard call to get message count and if count is 1, get message info.
2420: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2416: fnd_msg_pub.add;
2417: END IF;
2418:
2419: -- Standard call to get message count and if count is 1, get message info.
2420: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2421: EXCEPTION
2422: WHEN fnd_api.g_exc_error
2423: THEN
2424: ROLLBACK TO delete_territory_pub;

Line 2426: fnd_msg_pub.count_and_get (

2422: WHEN fnd_api.g_exc_error
2423: THEN
2424: ROLLBACK TO delete_territory_pub;
2425: x_return_status := fnd_api.g_ret_sts_error;
2426: fnd_msg_pub.count_and_get (
2427: p_count => x_msg_count,
2428: p_data => x_msg_data
2429: );
2430: WHEN fnd_api.g_exc_unexpected_error

Line 2434: fnd_msg_pub.count_and_get (

2430: WHEN fnd_api.g_exc_unexpected_error
2431: THEN
2432: ROLLBACK TO delete_territory_pub;
2433: x_return_status := fnd_api.g_ret_sts_unexp_error;
2434: fnd_msg_pub.count_and_get (
2435: p_count => x_msg_count,
2436: p_data => x_msg_data
2437: );
2438: WHEN OTHERS

Line 2443: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2439: THEN
2440: ROLLBACK TO delete_territory_pub;
2441: x_return_status := fnd_api.g_ret_sts_unexp_error;
2442:
2443: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2444: THEN
2445: fnd_msg_pub.add_exc_msg (
2446: 'Others exception in Delete_Terr_Value PUB' || SQLERRM
2447: );

Line 2445: fnd_msg_pub.add_exc_msg (

2441: x_return_status := fnd_api.g_ret_sts_unexp_error;
2442:
2443: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2444: THEN
2445: fnd_msg_pub.add_exc_msg (
2446: 'Others exception in Delete_Terr_Value PUB' || SQLERRM
2447: );
2448: END IF;
2449:

Line 2450: fnd_msg_pub.count_and_get (

2446: 'Others exception in Delete_Terr_Value PUB' || SQLERRM
2447: );
2448: END IF;
2449:
2450: fnd_msg_pub.count_and_get (
2451: p_count => x_msg_count,
2452: p_data => x_msg_data
2453: );
2454: --

Line 2540: fnd_msg_pub.initialize;

2536:
2537: -- Initialize message list if p_init_msg_list is set to TRUE.
2538: IF fnd_api.to_boolean (p_init_msg_list)
2539: THEN
2540: fnd_msg_pub.initialize;
2541: END IF;
2542: fnd_msg_pub.initialize;
2543:
2544: -- Debug Message

Line 2542: fnd_msg_pub.initialize;

2538: IF fnd_api.to_boolean (p_init_msg_list)
2539: THEN
2540: fnd_msg_pub.initialize;
2541: END IF;
2542: fnd_msg_pub.initialize;
2543:
2544: -- Debug Message
2545: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2546: THEN

Line 2545: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

2541: END IF;
2542: fnd_msg_pub.initialize;
2543:
2544: -- Debug Message
2545: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2546: THEN
2547: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2548: fnd_message.set_name ('PROC_NAME', l_api_name);
2549: fnd_msg_pub.add;

Line 2549: fnd_msg_pub.add;

2545: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2546: THEN
2547: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2548: fnd_message.set_name ('PROC_NAME', l_api_name);
2549: fnd_msg_pub.add;
2550: END IF;
2551:
2552: -- Initialize API return status to success
2553: x_return_status := fnd_api.g_ret_sts_success;

Line 2609: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

2605: COMMIT WORK;
2606: END IF;
2607:
2608: -- Debug Message
2609: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2610: THEN
2611: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2612: fnd_message.set_name ('PROC_NAME', l_api_name);
2613: fnd_msg_pub.add;

Line 2613: fnd_msg_pub.add;

2609: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2610: THEN
2611: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2612: fnd_message.set_name ('PROC_NAME', l_api_name);
2613: fnd_msg_pub.add;
2614: END IF;
2615:
2616: -- Standard call to get message count and if count is 1, get message info.
2617: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2613: fnd_msg_pub.add;
2614: END IF;
2615:
2616: -- Standard call to get message count and if count is 1, get message info.
2617: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2618: EXCEPTION
2619: WHEN fnd_api.g_exc_error
2620: THEN
2621: ROLLBACK TO create_terrresource_pub;

Line 2623: fnd_msg_pub.count_and_get (

2619: WHEN fnd_api.g_exc_error
2620: THEN
2621: ROLLBACK TO create_terrresource_pub;
2622: x_return_status := fnd_api.g_ret_sts_error;
2623: fnd_msg_pub.count_and_get (
2624: p_count => x_msg_count,
2625: p_data => x_msg_data
2626: );
2627:

Line 2632: fnd_msg_pub.count_and_get (

2628: WHEN fnd_api.g_exc_unexpected_error
2629: THEN
2630: ROLLBACK TO create_terrresource_pub;
2631: x_return_status := fnd_api.g_ret_sts_unexp_error;
2632: fnd_msg_pub.count_and_get (
2633: p_count => x_msg_count,
2634: p_data => x_msg_data
2635: );
2636:

Line 2642: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2638: THEN
2639: ROLLBACK TO create_terrresource_pub;
2640: x_return_status := fnd_api.g_ret_sts_unexp_error;
2641:
2642: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2643: THEN
2644: fnd_msg_pub.add_exc_msg (
2645: 'Others exception in Create_TerrResource PUB' || SQLERRM
2646: );

Line 2644: fnd_msg_pub.add_exc_msg (

2640: x_return_status := fnd_api.g_ret_sts_unexp_error;
2641:
2642: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2643: THEN
2644: fnd_msg_pub.add_exc_msg (
2645: 'Others exception in Create_TerrResource PUB' || SQLERRM
2646: );
2647: END IF;
2648:

Line 2649: fnd_msg_pub.count_and_get (

2645: 'Others exception in Create_TerrResource PUB' || SQLERRM
2646: );
2647: END IF;
2648:
2649: fnd_msg_pub.count_and_get (
2650: p_count => x_msg_count,
2651: p_data => x_msg_data
2652: );
2653: --

Line 2723: fnd_msg_pub.initialize;

2719:
2720: -- Initialize message list if p_init_msg_list is set to TRUE.
2721: IF fnd_api.to_boolean (p_init_msg_list)
2722: THEN
2723: fnd_msg_pub.initialize;
2724: END IF;
2725:
2726: -- Debug Message
2727: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

Line 2727: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

2723: fnd_msg_pub.initialize;
2724: END IF;
2725:
2726: -- Debug Message
2727: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2728: THEN
2729: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2730: fnd_message.set_name ('PROC_NAME', l_api_name);
2731: fnd_msg_pub.add;

Line 2731: fnd_msg_pub.add;

2727: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2728: THEN
2729: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2730: fnd_message.set_name ('PROC_NAME', l_api_name);
2731: fnd_msg_pub.add;
2732: END IF;
2733:
2734: -- Initialize API return status to success
2735: x_return_status := fnd_api.g_ret_sts_success;

Line 2768: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

2764: COMMIT WORK;
2765: END IF;
2766:
2767: -- Debug Message
2768: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2769: THEN
2770: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2771: fnd_message.set_name ('PROC_NAME', l_api_name);
2772: fnd_msg_pub.add;

Line 2772: fnd_msg_pub.add;

2768: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2769: THEN
2770: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2771: fnd_message.set_name ('PROC_NAME', l_api_name);
2772: fnd_msg_pub.add;
2773: END IF;
2774:
2775: -- Standard call to get message count and if count is 1, get message info.
2776: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2772: fnd_msg_pub.add;
2773: END IF;
2774:
2775: -- Standard call to get message count and if count is 1, get message info.
2776: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2777: EXCEPTION
2778: WHEN fnd_api.g_exc_error
2779: THEN
2780: ROLLBACK TO delete_terrresource_pub;

Line 2782: fnd_msg_pub.count_and_get (

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

Line 2790: fnd_msg_pub.count_and_get (

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

Line 2799: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2795: THEN
2796: ROLLBACK TO delete_terrresource_pub;
2797: x_return_status := fnd_api.g_ret_sts_unexp_error;
2798:
2799: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2800: THEN
2801: fnd_msg_pub.add_exc_msg (
2802: 'Others exception in Delete_TerrResource PUB' || SQLERRM
2803: );

Line 2801: fnd_msg_pub.add_exc_msg (

2797: x_return_status := fnd_api.g_ret_sts_unexp_error;
2798:
2799: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2800: THEN
2801: fnd_msg_pub.add_exc_msg (
2802: 'Others exception in Delete_TerrResource PUB' || SQLERRM
2803: );
2804: END IF;
2805:

Line 2806: fnd_msg_pub.count_and_get (

2802: 'Others exception in Delete_TerrResource PUB' || SQLERRM
2803: );
2804: END IF;
2805:
2806: fnd_msg_pub.count_and_get (
2807: p_count => x_msg_count,
2808: p_data => x_msg_data
2809: );
2810: --

Line 2893: fnd_msg_pub.initialize;

2889:
2890: -- Initialize message list if p_init_msg_list is set to TRUE.
2891: IF fnd_api.to_boolean (p_init_msg_list)
2892: THEN
2893: fnd_msg_pub.initialize;
2894: END IF;
2895:
2896: -- Debug Message
2897: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

Line 2897: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

2893: fnd_msg_pub.initialize;
2894: END IF;
2895:
2896: -- Debug Message
2897: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2898: THEN
2899: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2900: fnd_message.set_name ('PROC_NAME', l_api_name);
2901: fnd_msg_pub.add;

Line 2901: fnd_msg_pub.add;

2897: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2898: THEN
2899: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2900: fnd_message.set_name ('PROC_NAME', l_api_name);
2901: fnd_msg_pub.add;
2902: END IF;
2903:
2904: -- Initialize API return status to success
2905: x_return_status := fnd_api.g_ret_sts_success;

Line 2949: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

2945: RAISE fnd_api.g_exc_error;
2946: END IF;
2947:
2948: -- Debug Message
2949: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2950: THEN
2951: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2952: fnd_message.set_name ('PROC_NAME', l_api_name);
2953: fnd_msg_pub.add;

Line 2953: fnd_msg_pub.add;

2949: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2950: THEN
2951: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2952: fnd_message.set_name ('PROC_NAME', l_api_name);
2953: fnd_msg_pub.add;
2954: END IF;
2955:
2956: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2957:

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

2952: fnd_message.set_name ('PROC_NAME', l_api_name);
2953: fnd_msg_pub.add;
2954: END IF;
2955:
2956: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2957:
2958: -- Standard check for p_commit
2959: IF fnd_api.to_boolean (p_commit)
2960: THEN

Line 2970: fnd_msg_pub.count_and_get (

2966: WHEN fnd_api.g_exc_error
2967: THEN
2968: ROLLBACK TO update_terrresource_pub;
2969: x_return_status := fnd_api.g_ret_sts_error;
2970: fnd_msg_pub.count_and_get (
2971: p_count => x_msg_count,
2972: p_data => x_msg_data
2973: );
2974: WHEN fnd_api.g_exc_unexpected_error

Line 2978: fnd_msg_pub.count_and_get (

2974: WHEN fnd_api.g_exc_unexpected_error
2975: THEN
2976: ROLLBACK TO update_terrresource_pub;
2977: x_return_status := fnd_api.g_ret_sts_unexp_error;
2978: fnd_msg_pub.count_and_get (
2979: p_count => x_msg_count,
2980: p_data => x_msg_data
2981: );
2982:

Line 2988: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2984: THEN
2985: ROLLBACK TO update_terrresource_pub;
2986: x_return_status := fnd_api.g_ret_sts_unexp_error;
2987:
2988: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2989: THEN
2990: fnd_msg_pub.add_exc_msg (
2991: 'Others exception in Update_TerrResource PUB' || SQLERRM
2992: );

Line 2990: fnd_msg_pub.add_exc_msg (

2986: x_return_status := fnd_api.g_ret_sts_unexp_error;
2987:
2988: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2989: THEN
2990: fnd_msg_pub.add_exc_msg (
2991: 'Others exception in Update_TerrResource PUB' || SQLERRM
2992: );
2993:
2994: END IF;

Line 2995: fnd_msg_pub.count_and_get (

2991: 'Others exception in Update_TerrResource PUB' || SQLERRM
2992: );
2993:
2994: END IF;
2995: fnd_msg_pub.count_and_get (
2996: p_count => x_msg_count,
2997: p_data => x_msg_data
2998: );
2999: --