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,
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.
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,
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.
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');
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);
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.
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
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,
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.
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,
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.
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');
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);
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.
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.
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.
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);
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.
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,
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.
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,
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.
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');
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);
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.
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
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,
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.
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,
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.
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');
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);
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.
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.
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.
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);
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.