DBA Data[Home] [Help]

APPS.HZ_CUST_ACCT_SITE_BO_PVT dependencies on FND_MSG_PUB

Line 402: FND_MSG_PUB.ADD;

398: WHEN fnd_api.g_exc_error THEN
399: ROLLBACK TO create_casu_pvt;
400: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
401: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'CUST_ACCT_SITE_USE');
402: FND_MSG_PUB.ADD;
403:
404: x_return_status := fnd_api.g_ret_sts_error;
405:
406: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 406: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

402: FND_MSG_PUB.ADD;
403:
404: x_return_status := fnd_api.g_ret_sts_error;
405:
406: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
407: p_count => x_msg_count,
408: p_data => x_msg_data);
409:
410: -- Debug info.

Line 427: FND_MSG_PUB.ADD;

423: WHEN fnd_api.g_exc_unexpected_error THEN
424: ROLLBACK TO create_casu_pvt;
425: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
426: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'CUST_ACCT_SITE_USE');
427: FND_MSG_PUB.ADD;
428:
429: x_return_status := fnd_api.g_ret_sts_unexp_error;
430:
431: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 431: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

427: FND_MSG_PUB.ADD;
428:
429: x_return_status := fnd_api.g_ret_sts_unexp_error;
430:
431: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
432: p_count => x_msg_count,
433: p_data => x_msg_data);
434:
435: -- Debug info.

Line 452: FND_MSG_PUB.ADD;

448: WHEN OTHERS THEN
449: ROLLBACK TO create_casu_pvt;
450: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
451: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'CUST_ACCT_SITE_USE');
452: FND_MSG_PUB.ADD;
453:
454: x_return_status := fnd_api.g_ret_sts_unexp_error;
455:
456: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 458: fnd_msg_pub.add;

454: x_return_status := fnd_api.g_ret_sts_unexp_error;
455:
456: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
457: fnd_message.set_token('ERROR' ,SQLERRM);
458: fnd_msg_pub.add;
459:
460: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
461: p_count => x_msg_count,
462: p_data => x_msg_data);

Line 460: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

456: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
457: fnd_message.set_token('ERROR' ,SQLERRM);
458: fnd_msg_pub.add;
459:
460: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
461: p_count => x_msg_count,
462: p_data => x_msg_data);
463:
464: -- Debug info.

Line 613: FND_MSG_PUB.ADD;

609:
610: IF(l_create_update_flag = 'E') THEN
611: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
612: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'CUST_ACCT_SITE_USE');
613: FND_MSG_PUB.ADD;
614: RAISE FND_API.G_EXC_ERROR;
615: END IF;
616:
617: -- check if the cust site use record is create or update

Line 829: FND_MSG_PUB.ADD;

825: WHEN fnd_api.g_exc_error THEN
826: ROLLBACK TO save_casu_pvt;
827: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
828: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'CUST_ACCT_SITE_USE');
829: FND_MSG_PUB.ADD;
830:
831: x_return_status := fnd_api.g_ret_sts_error;
832:
833: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 833: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

829: FND_MSG_PUB.ADD;
830:
831: x_return_status := fnd_api.g_ret_sts_error;
832:
833: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
834: p_count => x_msg_count,
835: p_data => x_msg_data);
836:
837: -- Debug info.

Line 854: FND_MSG_PUB.ADD;

850: WHEN fnd_api.g_exc_unexpected_error THEN
851: ROLLBACK TO save_casu_pvt;
852: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
853: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'CUST_ACCT_SITE_USE');
854: FND_MSG_PUB.ADD;
855:
856: x_return_status := fnd_api.g_ret_sts_unexp_error;
857:
858: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 858: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

854: FND_MSG_PUB.ADD;
855:
856: x_return_status := fnd_api.g_ret_sts_unexp_error;
857:
858: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
859: p_count => x_msg_count,
860: p_data => x_msg_data);
861:
862: -- Debug info.

Line 879: FND_MSG_PUB.ADD;

875: WHEN OTHERS THEN
876: ROLLBACK TO save_casu_pvt;
877: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
878: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'CUST_ACCT_SITE_USE');
879: FND_MSG_PUB.ADD;
880:
881: x_return_status := fnd_api.g_ret_sts_unexp_error;
882:
883: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 885: fnd_msg_pub.add;

881: x_return_status := fnd_api.g_ret_sts_unexp_error;
882:
883: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
884: fnd_message.set_token('ERROR' ,SQLERRM);
885: fnd_msg_pub.add;
886:
887: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
888: p_count => x_msg_count,
889: p_data => x_msg_data);

Line 887: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

883: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
884: fnd_message.set_token('ERROR' ,SQLERRM);
885: fnd_msg_pub.add;
886:
887: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
888: p_count => x_msg_count,
889: p_data => x_msg_data);
890:
891: -- Debug info.

Line 1025: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1021: EXCEPTION
1022: WHEN fnd_api.g_exc_error THEN
1023: x_return_status := fnd_api.g_ret_sts_error;
1024:
1025: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1026: p_count => x_msg_count,
1027: p_data => x_msg_data);
1028:
1029: -- Debug info.

Line 1044: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1040: END IF;
1041: WHEN fnd_api.g_exc_unexpected_error THEN
1042: x_return_status := fnd_api.g_ret_sts_unexp_error;
1043:
1044: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1045: p_count => x_msg_count,
1046: p_data => x_msg_data);
1047:
1048: -- Debug info.

Line 1065: fnd_msg_pub.add;

1061: x_return_status := fnd_api.g_ret_sts_unexp_error;
1062:
1063: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1064: fnd_message.set_token('ERROR' ,SQLERRM);
1065: fnd_msg_pub.add;
1066:
1067: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1068: p_count => x_msg_count,
1069: p_data => x_msg_data);

Line 1067: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1063: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1064: fnd_message.set_token('ERROR' ,SQLERRM);
1065: fnd_msg_pub.add;
1066:
1067: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1068: p_count => x_msg_count,
1069: p_data => x_msg_data);
1070:
1071: -- Debug info.

Line 1484: FND_MSG_PUB.ADD;

1480: WHEN fnd_api.g_exc_error THEN
1481: ROLLBACK TO create_casu_v2_pvt;
1482: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
1483: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'CUST_ACCT_SITE_USE');
1484: FND_MSG_PUB.ADD;
1485:
1486: x_return_status := fnd_api.g_ret_sts_error;
1487:
1488: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 1488: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1484: FND_MSG_PUB.ADD;
1485:
1486: x_return_status := fnd_api.g_ret_sts_error;
1487:
1488: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1489: p_count => x_msg_count,
1490: p_data => x_msg_data);
1491:
1492: -- Debug info.

Line 1509: FND_MSG_PUB.ADD;

1505: WHEN fnd_api.g_exc_unexpected_error THEN
1506: ROLLBACK TO create_casu_v2_pvt;
1507: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
1508: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'CUST_ACCT_SITE_USE');
1509: FND_MSG_PUB.ADD;
1510:
1511: x_return_status := fnd_api.g_ret_sts_unexp_error;
1512:
1513: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 1513: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1509: FND_MSG_PUB.ADD;
1510:
1511: x_return_status := fnd_api.g_ret_sts_unexp_error;
1512:
1513: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1514: p_count => x_msg_count,
1515: p_data => x_msg_data);
1516:
1517: -- Debug info.

Line 1534: FND_MSG_PUB.ADD;

1530: WHEN OTHERS THEN
1531: ROLLBACK TO create_casu_v2_pvt;
1532: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
1533: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'CUST_ACCT_SITE_USE');
1534: FND_MSG_PUB.ADD;
1535:
1536: x_return_status := fnd_api.g_ret_sts_unexp_error;
1537:
1538: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 1540: fnd_msg_pub.add;

1536: x_return_status := fnd_api.g_ret_sts_unexp_error;
1537:
1538: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1539: fnd_message.set_token('ERROR' ,SQLERRM);
1540: fnd_msg_pub.add;
1541:
1542: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1543: p_count => x_msg_count,
1544: p_data => x_msg_data);

Line 1542: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1538: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1539: fnd_message.set_token('ERROR' ,SQLERRM);
1540: fnd_msg_pub.add;
1541:
1542: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1543: p_count => x_msg_count,
1544: p_data => x_msg_data);
1545:
1546: -- Debug info.

Line 1671: FND_MSG_PUB.ADD;

1667:
1668: IF(l_create_update_flag = 'E') THEN
1669: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
1670: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'CUST_ACCT_SITE_USE');
1671: FND_MSG_PUB.ADD;
1672: RAISE FND_API.G_EXC_ERROR;
1673: END IF;
1674:
1675: -- check if the cust site use record is create or update

Line 1888: FND_MSG_PUB.ADD;

1884: WHEN fnd_api.g_exc_error THEN
1885: ROLLBACK TO save_casu_v2_pvt;
1886: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
1887: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'CUST_ACCT_SITE_USE');
1888: FND_MSG_PUB.ADD;
1889:
1890: x_return_status := fnd_api.g_ret_sts_error;
1891:
1892: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 1892: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1888: FND_MSG_PUB.ADD;
1889:
1890: x_return_status := fnd_api.g_ret_sts_error;
1891:
1892: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1893: p_count => x_msg_count,
1894: p_data => x_msg_data);
1895:
1896: -- Debug info.

Line 1913: FND_MSG_PUB.ADD;

1909: WHEN fnd_api.g_exc_unexpected_error THEN
1910: ROLLBACK TO save_casu_v2_pvt;
1911: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
1912: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'CUST_ACCT_SITE_USE');
1913: FND_MSG_PUB.ADD;
1914:
1915: x_return_status := fnd_api.g_ret_sts_unexp_error;
1916:
1917: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 1917: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1913: FND_MSG_PUB.ADD;
1914:
1915: x_return_status := fnd_api.g_ret_sts_unexp_error;
1916:
1917: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1918: p_count => x_msg_count,
1919: p_data => x_msg_data);
1920:
1921: -- Debug info.

Line 1938: FND_MSG_PUB.ADD;

1934: WHEN OTHERS THEN
1935: ROLLBACK TO save_casu_v2_pvt;
1936: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
1937: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'CUST_ACCT_SITE_USE');
1938: FND_MSG_PUB.ADD;
1939:
1940: x_return_status := fnd_api.g_ret_sts_unexp_error;
1941:
1942: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 1944: fnd_msg_pub.add;

1940: x_return_status := fnd_api.g_ret_sts_unexp_error;
1941:
1942: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1943: fnd_message.set_token('ERROR' ,SQLERRM);
1944: fnd_msg_pub.add;
1945:
1946: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1947: p_count => x_msg_count,
1948: p_data => x_msg_data);

Line 1946: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1942: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1943: fnd_message.set_token('ERROR' ,SQLERRM);
1944: fnd_msg_pub.add;
1945:
1946: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1947: p_count => x_msg_count,
1948: p_data => x_msg_data);
1949:
1950: -- Debug info.

Line 2084: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2080: EXCEPTION
2081: WHEN fnd_api.g_exc_error THEN
2082: x_return_status := fnd_api.g_ret_sts_error;
2083:
2084: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2085: p_count => x_msg_count,
2086: p_data => x_msg_data);
2087:
2088: -- Debug info.

Line 2103: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2099: END IF;
2100: WHEN fnd_api.g_exc_unexpected_error THEN
2101: x_return_status := fnd_api.g_ret_sts_unexp_error;
2102:
2103: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2104: p_count => x_msg_count,
2105: p_data => x_msg_data);
2106:
2107: -- Debug info.

Line 2124: fnd_msg_pub.add;

2120: x_return_status := fnd_api.g_ret_sts_unexp_error;
2121:
2122: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2123: fnd_message.set_token('ERROR' ,SQLERRM);
2124: fnd_msg_pub.add;
2125:
2126: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2127: p_count => x_msg_count,
2128: p_data => x_msg_data);

Line 2126: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2122: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2123: fnd_message.set_token('ERROR' ,SQLERRM);
2124: fnd_msg_pub.add;
2125:
2126: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2127: p_count => x_msg_count,
2128: p_data => x_msg_data);
2129:
2130: -- Debug info.