312: px_cust_acct_rec => l_cust_acct_rec
313: );
314:
315: IF(p_cust_acct_obj.cust_profile_obj IS NULL) THEN
316: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
317: fnd_message.set_token('ENTITY' ,'CUST_PROFILE');
318: fnd_msg_pub.add;
319: RAISE FND_API.G_EXC_ERROR;
320: END IF;
313: );
314:
315: IF(p_cust_acct_obj.cust_profile_obj IS NULL) THEN
316: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
317: fnd_message.set_token('ENTITY' ,'CUST_PROFILE');
318: fnd_msg_pub.add;
319: RAISE FND_API.G_EXC_ERROR;
320: END IF;
321:
529: -- reset Global variable
530: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
531: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
532:
533: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
534: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
535: FND_MSG_PUB.ADD;
536:
537: x_return_status := fnd_api.g_ret_sts_error;
530: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
531: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
532:
533: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
534: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
535: FND_MSG_PUB.ADD;
536:
537: x_return_status := fnd_api.g_ret_sts_error;
538:
559: -- reset Global variable
560: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
561: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
562:
563: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
564: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
565: FND_MSG_PUB.ADD;
566:
567: x_return_status := fnd_api.g_ret_sts_unexp_error;
560: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
561: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
562:
563: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
564: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
565: FND_MSG_PUB.ADD;
566:
567: x_return_status := fnd_api.g_ret_sts_unexp_error;
568:
589: -- reset Global variable
590: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
591: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
592:
593: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
594: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
595: FND_MSG_PUB.ADD;
596:
597: x_return_status := fnd_api.g_ret_sts_unexp_error;
590: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
591: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
592:
593: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
594: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
595: FND_MSG_PUB.ADD;
596:
597: x_return_status := fnd_api.g_ret_sts_unexp_error;
598:
595: FND_MSG_PUB.ADD;
596:
597: x_return_status := fnd_api.g_ret_sts_unexp_error;
598:
599: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
600: fnd_message.set_token('ERROR' ,SQLERRM);
601: fnd_msg_pub.add;
602:
603: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
596:
597: x_return_status := fnd_api.g_ret_sts_unexp_error;
598:
599: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
600: fnd_message.set_token('ERROR' ,SQLERRM);
601: fnd_msg_pub.add;
602:
603: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
604: p_count => x_msg_count,
1053: -- reset Global variable
1054: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1055: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1056:
1057: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1058: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
1059: FND_MSG_PUB.ADD;
1060:
1061: x_return_status := fnd_api.g_ret_sts_error;
1054: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1055: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1056:
1057: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1058: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
1059: FND_MSG_PUB.ADD;
1060:
1061: x_return_status := fnd_api.g_ret_sts_error;
1062:
1083: -- reset Global variable
1084: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1085: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1086:
1087: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1088: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
1089: FND_MSG_PUB.ADD;
1090:
1091: x_return_status := fnd_api.g_ret_sts_unexp_error;
1084: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1085: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1086:
1087: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1088: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
1089: FND_MSG_PUB.ADD;
1090:
1091: x_return_status := fnd_api.g_ret_sts_unexp_error;
1092:
1113: -- reset Global variable
1114: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1115: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1116:
1117: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1118: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
1119: FND_MSG_PUB.ADD;
1120:
1121: x_return_status := fnd_api.g_ret_sts_unexp_error;
1114: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1115: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1116:
1117: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1118: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
1119: FND_MSG_PUB.ADD;
1120:
1121: x_return_status := fnd_api.g_ret_sts_unexp_error;
1122:
1119: FND_MSG_PUB.ADD;
1120:
1121: x_return_status := fnd_api.g_ret_sts_unexp_error;
1122:
1123: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1124: fnd_message.set_token('ERROR' ,SQLERRM);
1125: fnd_msg_pub.add;
1126:
1127: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1120:
1121: x_return_status := fnd_api.g_ret_sts_unexp_error;
1122:
1123: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1124: fnd_message.set_token('ERROR' ,SQLERRM);
1125: fnd_msg_pub.add;
1126:
1127: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1128: p_count => x_msg_count,
1199: p_parent_obj_type => px_parent_obj_type
1200: );
1201:
1202: IF(l_create_update_flag = 'E') THEN
1203: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1204: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
1205: FND_MSG_PUB.ADD;
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1200: );
1201:
1202: IF(l_create_update_flag = 'E') THEN
1203: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1204: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
1205: FND_MSG_PUB.ADD;
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208:
1256: EXCEPTION
1257: WHEN fnd_api.g_exc_error THEN
1258: x_return_status := fnd_api.g_ret_sts_error;
1259:
1260: FND_MESSAGE.SET_NAME('AR', 'HZ_SAVE_API_ERROR');
1261: FND_MSG_PUB.ADD;
1262: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1263: p_count => x_msg_count,
1264: p_data => x_msg_data);
1296: END IF;
1297: WHEN OTHERS THEN
1298: x_return_status := fnd_api.g_ret_sts_unexp_error;
1299:
1300: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1301: fnd_message.set_token('ERROR' ,SQLERRM);
1302: fnd_msg_pub.add;
1303:
1304: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1297: WHEN OTHERS THEN
1298: x_return_status := fnd_api.g_ret_sts_unexp_error;
1299:
1300: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1301: fnd_message.set_token('ERROR' ,SQLERRM);
1302: fnd_msg_pub.add;
1303:
1304: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1305: p_count => x_msg_count,
1591: END IF;
1592: WHEN OTHERS THEN
1593: x_return_status := fnd_api.g_ret_sts_unexp_error;
1594:
1595: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1596: fnd_message.set_token('ERROR' ,SQLERRM);
1597: fnd_msg_pub.add;
1598:
1599: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1592: WHEN OTHERS THEN
1593: x_return_status := fnd_api.g_ret_sts_unexp_error;
1594:
1595: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1596: fnd_message.set_token('ERROR' ,SQLERRM);
1597: fnd_msg_pub.add;
1598:
1599: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1600: p_count => x_msg_count,
1954: px_cust_acct_rec => l_cust_acct_rec
1955: );
1956:
1957: IF(p_cust_acct_v2_obj.cust_profile_obj IS NULL) THEN
1958: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
1959: fnd_message.set_token('ENTITY' ,'CUST_PROFILE');
1960: fnd_msg_pub.add;
1961: RAISE FND_API.G_EXC_ERROR;
1962: END IF;
1955: );
1956:
1957: IF(p_cust_acct_v2_obj.cust_profile_obj IS NULL) THEN
1958: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
1959: fnd_message.set_token('ENTITY' ,'CUST_PROFILE');
1960: fnd_msg_pub.add;
1961: RAISE FND_API.G_EXC_ERROR;
1962: END IF;
1963:
2172: -- reset Global variable
2173: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2174: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2175:
2176: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2177: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2178: FND_MSG_PUB.ADD;
2179:
2180: x_return_status := fnd_api.g_ret_sts_error;
2173: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2174: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2175:
2176: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2177: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2178: FND_MSG_PUB.ADD;
2179:
2180: x_return_status := fnd_api.g_ret_sts_error;
2181:
2202: -- reset Global variable
2203: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2204: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2205:
2206: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2207: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2208: FND_MSG_PUB.ADD;
2209:
2210: x_return_status := fnd_api.g_ret_sts_unexp_error;
2203: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2204: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2205:
2206: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2207: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2208: FND_MSG_PUB.ADD;
2209:
2210: x_return_status := fnd_api.g_ret_sts_unexp_error;
2211:
2232: -- reset Global variable
2233: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2234: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2235:
2236: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2237: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2238: FND_MSG_PUB.ADD;
2239:
2240: x_return_status := fnd_api.g_ret_sts_unexp_error;
2233: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2234: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2235:
2236: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2237: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2238: FND_MSG_PUB.ADD;
2239:
2240: x_return_status := fnd_api.g_ret_sts_unexp_error;
2241:
2238: FND_MSG_PUB.ADD;
2239:
2240: x_return_status := fnd_api.g_ret_sts_unexp_error;
2241:
2242: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2243: fnd_message.set_token('ERROR' ,SQLERRM);
2244: fnd_msg_pub.add;
2245:
2246: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2239:
2240: x_return_status := fnd_api.g_ret_sts_unexp_error;
2241:
2242: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2243: fnd_message.set_token('ERROR' ,SQLERRM);
2244: fnd_msg_pub.add;
2245:
2246: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2247: p_count => x_msg_count,
2630: -- reset Global variable
2631: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2632: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2633:
2634: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2635: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2636: FND_MSG_PUB.ADD;
2637:
2638: x_return_status := fnd_api.g_ret_sts_error;
2631: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2632: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2633:
2634: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2635: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2636: FND_MSG_PUB.ADD;
2637:
2638: x_return_status := fnd_api.g_ret_sts_error;
2639:
2660: -- reset Global variable
2661: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2662: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2663:
2664: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2665: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2666: FND_MSG_PUB.ADD;
2667:
2668: x_return_status := fnd_api.g_ret_sts_unexp_error;
2661: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2662: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2663:
2664: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2665: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2666: FND_MSG_PUB.ADD;
2667:
2668: x_return_status := fnd_api.g_ret_sts_unexp_error;
2669:
2690: -- reset Global variable
2691: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2692: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2693:
2694: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2695: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2696: FND_MSG_PUB.ADD;
2697:
2698: x_return_status := fnd_api.g_ret_sts_unexp_error;
2691: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2692: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2693:
2694: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2695: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2696: FND_MSG_PUB.ADD;
2697:
2698: x_return_status := fnd_api.g_ret_sts_unexp_error;
2699:
2696: FND_MSG_PUB.ADD;
2697:
2698: x_return_status := fnd_api.g_ret_sts_unexp_error;
2699:
2700: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2701: fnd_message.set_token('ERROR' ,SQLERRM);
2702: fnd_msg_pub.add;
2703:
2704: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2697:
2698: x_return_status := fnd_api.g_ret_sts_unexp_error;
2699:
2700: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2701: fnd_message.set_token('ERROR' ,SQLERRM);
2702: fnd_msg_pub.add;
2703:
2704: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2705: p_count => x_msg_count,
2776: p_parent_obj_type => px_parent_obj_type
2777: );
2778:
2779: IF(l_create_update_flag = 'E') THEN
2780: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2781: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2782: FND_MSG_PUB.ADD;
2783: RAISE FND_API.G_EXC_ERROR;
2784: END IF;
2777: );
2778:
2779: IF(l_create_update_flag = 'E') THEN
2780: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2781: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2782: FND_MSG_PUB.ADD;
2783: RAISE FND_API.G_EXC_ERROR;
2784: END IF;
2785:
2833: EXCEPTION
2834: WHEN fnd_api.g_exc_error THEN
2835: x_return_status := fnd_api.g_ret_sts_error;
2836:
2837: FND_MESSAGE.SET_NAME('AR', 'HZ_SAVE_API_ERROR');
2838: FND_MSG_PUB.ADD;
2839: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2840: p_count => x_msg_count,
2841: p_data => x_msg_data);
2873: END IF;
2874: WHEN OTHERS THEN
2875: x_return_status := fnd_api.g_ret_sts_unexp_error;
2876:
2877: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2878: fnd_message.set_token('ERROR' ,SQLERRM);
2879: fnd_msg_pub.add;
2880:
2881: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2874: WHEN OTHERS THEN
2875: x_return_status := fnd_api.g_ret_sts_unexp_error;
2876:
2877: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2878: fnd_message.set_token('ERROR' ,SQLERRM);
2879: fnd_msg_pub.add;
2880:
2881: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2882: p_count => x_msg_count,
3131: END IF;
3132: WHEN OTHERS THEN
3133: x_return_status := fnd_api.g_ret_sts_unexp_error;
3134:
3135: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3136: fnd_message.set_token('ERROR' ,SQLERRM);
3137: fnd_msg_pub.add;
3138:
3139: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3132: WHEN OTHERS THEN
3133: x_return_status := fnd_api.g_ret_sts_unexp_error;
3134:
3135: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3136: fnd_message.set_token('ERROR' ,SQLERRM);
3137: fnd_msg_pub.add;
3138:
3139: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3140: p_count => x_msg_count,