[Home] [Help]
224: l_parent_class_code <> 'CLEARINGHOUSE')
225: THEN
226: CLOSE c_codeassign;
227: fnd_message.set_name('AR', 'HZ_BANK_INVALID_PARENT');
228: fnd_msg_pub.add;
229: x_return_status := fnd_api.g_ret_sts_error;
230:
231: -- parent is not a bank: no point in going any further.
232: RETURN;
241: FETCH c_parentinfo INTO l_parent_number, l_parent_name, l_parent_country;
242: IF c_parentinfo%NOTFOUND THEN
243: CLOSE c_parentinfo;
244: fnd_message.set_name('AR', 'HZ_BANK_INVALID_PARENT');
245: fnd_msg_pub.add;
246: x_return_status := fnd_api.g_ret_sts_error;
247:
248: -- parent is not a bank: no point in going any further.
249: RETURN;
267: l_parent_country;
268: IF c_parentinfo2%NOTFOUND THEN
269: CLOSE c_parentinfo2;
270: fnd_message.set_name('AR', 'HZ_BANK_INVALID_PARENT');
271: fnd_msg_pub.add;
272: x_return_status := fnd_api.g_ret_sts_error;
273:
274: -- parent is not a bank: no point in going any further.
275: RETURN;
290: THEN
291: fnd_message.set_name('AR', 'HZ_BANK_INVALID_COUNTRY');
292: fnd_message.set_token('INVCOUNTRY', p_bank_rec.organization_rec.home_country);
293: fnd_message.set_token('VLDCOUNTRY', l_parent_country);
294: fnd_msg_pub.add;
295: x_return_status := fnd_api.g_ret_sts_error;
296: END IF;
297:
298: -- Debug info.
312: fnd_message.set_name('AR', 'HZ_BANK_NONUNIQUE_NUMBER');
313: fnd_message.set_token('BANK', l_parent_number);
314: fnd_message.set_token('BRANCH', p_bank_rec.bank_or_branch_number);
315: fnd_message.set_token('COUNTRY', l_parent_country);
316: fnd_msg_pub.add;
317: x_return_status := fnd_api.g_ret_sts_error;
318: END IF;
319: CLOSE c_uniquenumberck;
320:
328: fnd_message.set_name('AR', 'HZ_BANK_NONUNIQUE_NAME');
329: fnd_message.set_token('BANK', l_parent_name);
330: fnd_message.set_token('BRANCH',
331: p_bank_rec.organization_rec.organization_name);
332: fnd_msg_pub.add;
333: x_return_status := fnd_api.g_ret_sts_error;
334: END IF;
335: CLOSE c_uniquenameck;
336:
400: -- fnd_message.set_name('AR', 'HZ_API_MAND_DEP_FIELDS');
401: -- fnd_message.set_token('COLUMN1', 'bank or branch number');
402: -- fnd_message.set_token('VALUE1', 'NULL');
403: -- fnd_message.set_token('COLUMN2', 'bank or branch number');
404: -- fnd_msg_pub.add;
405: -- x_return_status := fnd_api.g_ret_sts_error;
406: -- END IF;
407:
408: IF p_intended_type = 'BANK' THEN
408: IF p_intended_type = 'BANK' THEN
409: -- branch code must be null
410: IF p_bank_rec.branch_code IS NOT NULL THEN
411: fnd_message.set_name('AR', 'HZ_BANK_BRANCH_SPECIFIED');
412: fnd_msg_pub.add;
413: x_return_status := fnd_api.g_ret_sts_error;
414: END IF;
415:
416: -- bank institution type must be either CLEARINGHOUSE OR BANK
417: IF p_bank_rec.institution_type NOT IN ('BANK', 'CLEARINGHOUSE') THEN
418: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
419: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE, BANK');
420: fnd_message.set_token('INVALIDSUB', p_bank_rec.institution_type);
421: fnd_msg_pub.add;
422: x_return_status := fnd_api.g_ret_sts_error;
423: END IF;
424:
425: -- set the validation procedure to be run.
431: NOT IN ('BANK_BRANCH', 'CLEARINGHOUSE_BRANCH') THEN
432: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
433: fnd_message.set_token('VALIDSUB', 'BANK_BRANCH, CLEARINGHOUSE_BRANCH');
434: fnd_message.set_token('INVALIDSUB', p_bank_rec.institution_type);
435: fnd_msg_pub.add;
436: x_return_status := fnd_api.g_ret_sts_error;
437: END IF;
438:
439: -- set the validation procedure to be run.
458: CLOSE orgidcur;
459:
460: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
461: fnd_message.set_token('SEQUENCE', 'hz_parties_s'); -- Bug 3397488
462: fnd_msg_pub.add;
463: RAISE fnd_api.g_exc_error;
464: END IF;
465: CLOSE orgidcur;
466: -- Bug 3814832
613: OPEN c_uniqueptyedi;
614: FETCH c_uniqueptyedi INTO l_dummy;
615: IF c_uniqueptyedi%FOUND THEN
616: fnd_message.set_name('AR', 'HZ_EDI_UNIQUE');
617: fnd_msg_pub.add;
618: x_return_status := fnd_api.g_ret_sts_error;
619: ELSE
620: -- party contacts passed, check across party site contacts.
621: OPEN c_uniquepsedi;
621: OPEN c_uniquepsedi;
622: FETCH c_uniquepsedi INTO l_dummy;
623: IF c_uniquepsedi%FOUND THEN
624: fnd_message.set_name('AR', 'HZ_EDI_UNIQUE');
625: fnd_msg_pub.add;
626: x_return_status := fnd_api.g_ret_sts_error;
627: END IF;
628: CLOSE c_uniquepsedi;
629: END IF;
1012: IF p_group_rec.group_type <> 'BANKING_GROUP' THEN
1013: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1014: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1015: fnd_message.set_token('INVALIDSUB', p_group_rec.group_type);
1016: fnd_msg_pub.add;
1017: x_return_status := fnd_api.g_ret_sts_error;
1018: END IF;
1019:
1020: BEGIN
1076: IF c_group%NOTFOUND THEN
1077: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1078: fnd_message.set_token('RECORD', 'party');
1079: fnd_message.set_token('VALUE', TO_CHAR(p_party_id));
1080: fnd_msg_pub.add;
1081: x_return_status := fnd_api.g_ret_sts_error;
1082: END IF;
1083: CLOSE c_group;
1084:
1125: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1126: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1127: fnd_message.set_token('INVALIDSUB',
1128: p_relationship_rec.relationship_type);
1129: fnd_msg_pub.add;
1130: x_return_status := fnd_api.g_ret_sts_error;
1131: END IF;
1132:
1133: --
1162: -- if the object is also not the right type, then this is not valid.
1163: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1164: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1165: fnd_message.set_token('INVALIDSUB', l_group_type);
1166: fnd_msg_pub.add;
1167: x_return_status := fnd_api.g_ret_sts_error;
1168:
1169: -- return, the rest of the validations do not make sense if neither
1170: -- subject nor object is a valid banking group.
1191: ELSE
1192: fnd_message.set_token('VALIDSUB', 'C');
1193: END IF;
1194: fnd_message.set_token('INVALIDSUB', l_direction);
1195: fnd_msg_pub.add;
1196: x_return_status := fnd_api.g_ret_sts_error;
1197: END IF;
1198: ELSE
1199: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1198: ELSE
1199: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1200: fnd_message.set_token('RECORD', 'banking group relationship type');
1201: fnd_message.set_token('VALUE', p_relationship_rec.relationship_type);
1202: fnd_msg_pub.add;
1203: x_return_status := fnd_api.g_ret_sts_error;
1204: END IF;
1205: CLOSE c_reldir;
1206:
1221: IF c_codeassign%NOTFOUND THEN
1222: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1223: fnd_message.set_token('RECORD', 'bank classification code assignment');
1224: fnd_message.set_token('VALUE', TO_CHAR(l_bank_id));
1225: fnd_msg_pub.add;
1226: x_return_status := fnd_api.g_ret_sts_error;
1227: END IF;
1228:
1229: IF l_class_code IS NOT NULL
1231: THEN
1232: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1233: fnd_message.set_token('VALIDSUB', 'BANK, CLEARINGHOUSE');
1234: fnd_message.set_token('INVALIDSUB', l_class_code);
1235: fnd_msg_pub.add;
1236: x_return_status := fnd_api.g_ret_sts_error;
1237: END IF;
1238: CLOSE c_codeassign;
1239: END IF;
1310: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1311: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE_BANK');
1312: fnd_message.set_token('INVALIDSUB',
1313: p_relationship_rec.relationship_type);
1314: fnd_msg_pub.add;
1315: x_return_status := fnd_api.g_ret_sts_error;
1316: END IF;
1317:
1318: --
1332: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1333: fnd_message.set_token('RECORD',
1334: 'bank/clearinghouse code assignment (subject)');
1335: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_rec.subject_id));
1336: fnd_msg_pub.add;
1337: x_return_status := fnd_api.g_ret_sts_error;
1338: ELSIF l_subject_class NOT IN ('CLEARINGHOUSE', 'BANK', 'BANK_BRANCH')
1339: THEN
1340: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1339: THEN
1340: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1341: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE, BANK');
1342: fnd_message.set_token('INVALIDSUB', l_subject_class);
1343: fnd_msg_pub.add;
1344: x_return_status := fnd_api.g_ret_sts_error;
1345: END IF;
1346: CLOSE c_codeassign;
1347:
1356: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1357: fnd_message.set_token('RECORD',
1358: 'bank/clearinghouse code assignment (object)');
1359: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_rec.object_id));
1360: fnd_msg_pub.add;
1361: x_return_status := fnd_api.g_ret_sts_error;
1362: ELSIF l_object_class NOT IN ('CLEARINGHOUSE', 'BANK', 'BANK_BRANCH') THEN
1363: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1364: fnd_message.set_token('VALIDSUB', 'BANK, CLEARINGHOUSE');
1362: ELSIF l_object_class NOT IN ('CLEARINGHOUSE', 'BANK', 'BANK_BRANCH') THEN
1363: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1364: fnd_message.set_token('VALIDSUB', 'BANK, CLEARINGHOUSE');
1365: fnd_message.set_token('INVALIDSUB', l_object_class);
1366: fnd_msg_pub.add;
1367: x_return_status := fnd_api.g_ret_sts_error;
1368: ELSIF l_subject_class = l_object_class THEN
1369: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1370: fnd_message.set_token('VALIDSUB', 'different');
1368: ELSIF l_subject_class = l_object_class THEN
1369: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1370: fnd_message.set_token('VALIDSUB', 'different');
1371: fnd_message.set_token('INVALIDSUB', l_object_class);
1372: fnd_msg_pub.add;
1373: x_return_status := fnd_api.g_ret_sts_error;
1374: END IF;
1375: CLOSE c_codeassign;
1376:
1394: ELSE
1395: fnd_message.set_token('VALIDSUB', 'C');
1396: END IF;
1397: fnd_message.set_token('INVALIDSUB', l_direction);
1398: fnd_msg_pub.add;
1399: x_return_status := fnd_api.g_ret_sts_error;
1400: END IF;
1401: ELSE
1402: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1402: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1403: fnd_message.set_token('RECORD',
1404: 'clearinghouse assignment relationship type');
1405: fnd_message.set_token('VALUE', p_relationship_rec.relationship_type);
1406: fnd_msg_pub.add;
1407: x_return_status := fnd_api.g_ret_sts_error;
1408: END IF;
1409: CLOSE c_reldir;
1410: END IF;
1515: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1516: fnd_message.set_token('FK', 'party or location');
1517: fnd_message.set_token('COLUMN', 'PARTY_ID or LOCATION_ID');
1518: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
1519: fnd_msg_pub.add;
1520: x_return_status := fnd_api.g_ret_sts_error;
1521: -- no point doing further validations. We're missing some data.
1522: RETURN;
1523: END IF;
1529: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1530: fnd_message.set_token('FK', 'party or location');
1531: fnd_message.set_token('COLUMN', 'PARTY_ID or LOCATION_ID');
1532: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
1533: fnd_msg_pub.add;
1534: x_return_status := fnd_api.g_ret_sts_error;
1535: -- no point doing further validations. We're missing some data.
1536: RETURN;
1537: END IF;
1551: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1552: fnd_message.set_token('FK', 'active party');
1553: fnd_message.set_token('COLUMN', 'PARTY_ID');
1554: fnd_message.set_token('TABLE', 'HZ_PARTIES');
1555: fnd_msg_pub.add;
1556: x_return_status := fnd_api.g_ret_sts_error;
1557: END IF;
1558: CLOSE c_parentcountry;
1559:
1563: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1564: fnd_message.set_token('FK', 'active location');
1565: fnd_message.set_token('COLUMN', 'LOCATION_ID');
1566: fnd_message.set_token('TABLE', 'HZ_LOCATIONS');
1567: fnd_msg_pub.add;
1568: x_return_status := fnd_api.g_ret_sts_error;
1569: END IF;
1570: CLOSE c_sitecountry;
1571:
1572: IF l_parent_country <> l_site_country THEN
1573: fnd_message.set_name('AR', 'HZ_BANK_INVALID_COUNTRY');
1574: fnd_message.set_token('INVCOUNTRY', l_site_country);
1575: fnd_message.set_token('VLDCOUNTRY', l_parent_country);
1576: fnd_msg_pub.add;
1577: x_return_status := fnd_api.g_ret_sts_error;
1578: END IF;
1579: END IF;
1580:
1590: IF c_codeassign%NOTFOUND THEN
1591: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1592: fnd_message.set_token('RECORD', 'bank-related code assignment');
1593: fnd_message.set_token('VALUE', TO_CHAR(p_party_site_rec.party_id));
1594: fnd_msg_pub.add;
1595: x_return_status := fnd_api.g_ret_sts_error;
1596: ELSIF l_class_code NOT IN ('CLEARINGHOUSE', 'BANK', 'BANK_BRANCH') THEN
1597: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1598: fnd_message.set_token('VALIDSUB',
1597: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1598: fnd_message.set_token('VALIDSUB',
1599: 'BANK, CLEARINGHOUSE, BANK_BRANCH');
1600: fnd_message.set_token('INVALIDSUB', l_class_code);
1601: fnd_msg_pub.add;
1602: x_return_status := fnd_api.g_ret_sts_error;
1603: END IF;
1604: CLOSE c_codeassign;
1605: END IF;
2012: CLOSE c_rel;
2013: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
2014: fnd_message.set_token('RECORD', 'relationship');
2015: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_id));
2016: fnd_msg_pub.add;
2017: x_return_status := fnd_api.g_ret_sts_error;
2018:
2019: -- Debug info.
2020: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2562: END IF;
2563:
2564: -- initialize message list if p_init_msg_list is set to TRUE.
2565: IF fnd_api.to_boolean(p_init_msg_list) THEN
2566: fnd_msg_pub.initialize;
2567: END IF;
2568:
2569: -- initialize API return status to success.
2570: x_return_status := fnd_api.g_ret_sts_success;
2643: END IF;
2644: END IF;
2645:
2646: -- standard call to get message count and if count is 1, get message info.
2647: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2648: p_count => x_msg_count,
2649: p_data => x_msg_data);
2650:
2651: -- Debug info.
2667: EXCEPTION
2668: WHEN fnd_api.g_exc_error THEN
2669: ROLLBACK TO create_bank;
2670: x_return_status := fnd_api.g_ret_sts_error;
2671: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2672: p_count => x_msg_count,
2673: p_data => x_msg_data);
2674:
2675: -- Debug info.
2690:
2691: WHEN fnd_api.g_exc_unexpected_error THEN
2692: ROLLBACK TO create_bank;
2693: x_return_status := fnd_api.g_ret_sts_unexp_error;
2694: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2695: p_count => x_msg_count,
2696: p_data => x_msg_data);
2697:
2698: -- Debug info.
2716: ROLLBACK TO create_bank;
2717: x_return_status := fnd_api.g_ret_sts_unexp_error;
2718: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2719: fnd_message.set_token('ERROR',SQLERRM);
2720: fnd_msg_pub.add;
2721: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2722: p_count => x_msg_count,
2723: p_data => x_msg_data);
2724:
2717: x_return_status := fnd_api.g_ret_sts_unexp_error;
2718: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2719: fnd_message.set_token('ERROR',SQLERRM);
2720: fnd_msg_pub.add;
2721: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2722: p_count => x_msg_count,
2723: p_data => x_msg_data);
2724:
2725: -- Debug info.
2812: END IF;
2813:
2814: -- initialize message list if p_init_msg_list is set to TRUE.
2815: IF fnd_api.to_boolean(p_init_msg_list) THEN
2816: fnd_msg_pub.initialize;
2817: END IF;
2818:
2819: -- initialize API return status to success.
2820: x_return_status := fnd_api.g_ret_sts_success;
2889: END IF;
2890: END IF;
2891:
2892: -- standard call to get message count and if count is 1, get message info.
2893: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2894: p_count => x_msg_count,
2895: p_data => x_msg_data);
2896:
2897: -- Debug info.
2913: EXCEPTION
2914: WHEN fnd_api.g_exc_error THEN
2915: ROLLBACK TO update_bank;
2916: x_return_status := fnd_api.g_ret_sts_error;
2917: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2918: p_count => x_msg_count,
2919: p_data => x_msg_data);
2920:
2921: -- Debug info.
2936:
2937: WHEN fnd_api.g_exc_unexpected_error THEN
2938: ROLLBACK TO update_bank;
2939: x_return_status := fnd_api.g_ret_sts_unexp_error;
2940: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2941: p_count => x_msg_count,
2942: p_data => x_msg_data);
2943:
2944: -- Debug info.
2961: ROLLBACK TO update_bank;
2962: x_return_status := fnd_api.g_ret_sts_unexp_error;
2963: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2964: fnd_message.set_token('ERROR',SQLERRM);
2965: fnd_msg_pub.add;
2966: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2967: p_count => x_msg_count,
2968: p_data => x_msg_data);
2969:
2962: x_return_status := fnd_api.g_ret_sts_unexp_error;
2963: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2964: fnd_message.set_token('ERROR',SQLERRM);
2965: fnd_msg_pub.add;
2966: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2967: p_count => x_msg_count,
2968: p_data => x_msg_data);
2969:
2970: -- Debug info.
3062: END IF;
3063:
3064: -- initialize message list if p_init_msg_list is set to TRUE.
3065: IF fnd_api.to_boolean(p_init_msg_list) THEN
3066: fnd_msg_pub.initialize;
3067: END IF;
3068:
3069: -- initialize API return status to success.
3070: x_return_status := fnd_api.g_ret_sts_success;
3206: END IF;
3207: END IF;
3208:
3209: -- standard call to get message count and if count is 1, get message info.
3210: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3211: p_count => x_msg_count,
3212: p_data => x_msg_data);
3213:
3214: -- Debug info.
3230: EXCEPTION
3231: WHEN fnd_api.g_exc_error THEN
3232: ROLLBACK TO create_bank_branch;
3233: x_return_status := fnd_api.g_ret_sts_error;
3234: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3235: p_count => x_msg_count,
3236: p_data => x_msg_data);
3237:
3238: -- Debug info.
3253:
3254: WHEN fnd_api.g_exc_unexpected_error THEN
3255: ROLLBACK TO create_bank_branch;
3256: x_return_status := fnd_api.g_ret_sts_unexp_error;
3257: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3258: p_count => x_msg_count,
3259: p_data => x_msg_data);
3260:
3261: -- Debug info.
3278: ROLLBACK TO create_bank_branch;
3279: x_return_status := fnd_api.g_ret_sts_unexp_error;
3280: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3281: fnd_message.set_token('ERROR',SQLERRM);
3282: fnd_msg_pub.add;
3283: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3284: p_count => x_msg_count,
3285: p_data => x_msg_data);
3286:
3279: x_return_status := fnd_api.g_ret_sts_unexp_error;
3280: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3281: fnd_message.set_token('ERROR',SQLERRM);
3282: fnd_msg_pub.add;
3283: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3284: p_count => x_msg_count,
3285: p_data => x_msg_data);
3286:
3287: -- Debug info.
3381: END IF;
3382:
3383: -- initialize message list if p_init_msg_list is set to TRUE.
3384: IF fnd_api.to_boolean(p_init_msg_list) THEN
3385: fnd_msg_pub.initialize;
3386: END IF;
3387:
3388: -- initialize API return status to success.
3389: x_return_status := fnd_api.g_ret_sts_success;
3536: END IF;
3537: END IF;
3538:
3539: -- standard call to get message count and if count is 1, get message info.
3540: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3541: p_count => x_msg_count,
3542: p_data => x_msg_data);
3543:
3544: -- Debug info.
3560: EXCEPTION
3561: WHEN fnd_api.g_exc_error THEN
3562: ROLLBACK TO update_bank_branch;
3563: x_return_status := fnd_api.g_ret_sts_error;
3564: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3565: p_count => x_msg_count,
3566: p_data => x_msg_data);
3567:
3568: -- Debug info.
3583:
3584: WHEN fnd_api.g_exc_unexpected_error THEN
3585: ROLLBACK TO update_bank_branch;
3586: x_return_status := fnd_api.g_ret_sts_unexp_error;
3587: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3588: p_count => x_msg_count,
3589: p_data => x_msg_data);
3590:
3591: -- Debug info.
3608: ROLLBACK TO update_bank_branch;
3609: x_return_status := fnd_api.g_ret_sts_unexp_error;
3610: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3611: fnd_message.set_token('ERROR',SQLERRM);
3612: fnd_msg_pub.add;
3613: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3614: p_count => x_msg_count,
3615: p_data => x_msg_data);
3616:
3609: x_return_status := fnd_api.g_ret_sts_unexp_error;
3610: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3611: fnd_message.set_token('ERROR',SQLERRM);
3612: fnd_msg_pub.add;
3613: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3614: p_count => x_msg_count,
3615: p_data => x_msg_data);
3616:
3617: -- Debug info.
3726: EXCEPTION
3727: WHEN fnd_api.g_exc_error THEN
3728: ROLLBACK TO create_banking_group;
3729: x_return_status := fnd_api.g_ret_sts_error;
3730: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3731: p_count => x_msg_count,
3732: p_data => x_msg_data);
3733:
3734: -- Debug info.
3749:
3750: WHEN fnd_api.g_exc_unexpected_error THEN
3751: ROLLBACK TO create_banking_group;
3752: x_return_status := fnd_api.g_ret_sts_unexp_error;
3753: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3754: p_count => x_msg_count,
3755: p_data => x_msg_data);
3756:
3757: -- Debug info.
3774: ROLLBACK TO create_banking_group;
3775: x_return_status := fnd_api.g_ret_sts_unexp_error;
3776: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3777: fnd_message.set_token('ERROR',SQLERRM);
3778: fnd_msg_pub.add;
3779: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3780: p_count => x_msg_count,
3781: p_data => x_msg_data);
3782:
3775: x_return_status := fnd_api.g_ret_sts_unexp_error;
3776: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3777: fnd_message.set_token('ERROR',SQLERRM);
3778: fnd_msg_pub.add;
3779: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3780: p_count => x_msg_count,
3781: p_data => x_msg_data);
3782:
3783: -- Debug info.
3890: EXCEPTION
3891: WHEN fnd_api.g_exc_error THEN
3892: ROLLBACK TO update_banking_group;
3893: x_return_status := fnd_api.g_ret_sts_error;
3894: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3895: p_count => x_msg_count,
3896: p_data => x_msg_data);
3897:
3898: -- Debug info.
3913:
3914: WHEN fnd_api.g_exc_unexpected_error THEN
3915: ROLLBACK TO update_banking_group;
3916: x_return_status := fnd_api.g_ret_sts_unexp_error;
3917: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3918: p_count => x_msg_count,
3919: p_data => x_msg_data);
3920:
3921: -- Debug info.
3938: ROLLBACK TO update_banking_group;
3939: x_return_status := fnd_api.g_ret_sts_unexp_error;
3940: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3941: fnd_message.set_token('ERROR',SQLERRM);
3942: fnd_msg_pub.add;
3943: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3944: p_count => x_msg_count,
3945: p_data => x_msg_data);
3946:
3939: x_return_status := fnd_api.g_ret_sts_unexp_error;
3940: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3941: fnd_message.set_token('ERROR',SQLERRM);
3942: fnd_msg_pub.add;
3943: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3944: p_count => x_msg_count,
3945: p_data => x_msg_data);
3946:
3947: -- Debug info.
4063: EXCEPTION
4064: WHEN fnd_api.g_exc_error THEN
4065: ROLLBACK TO create_bank_group_member;
4066: x_return_status := fnd_api.g_ret_sts_error;
4067: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4068: p_count => x_msg_count,
4069: p_data => x_msg_data);
4070:
4071: -- Debug info.
4086:
4087: WHEN fnd_api.g_exc_unexpected_error THEN
4088: ROLLBACK TO create_bank_group_member;
4089: x_return_status := fnd_api.g_ret_sts_unexp_error;
4090: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4091: p_count => x_msg_count,
4092: p_data => x_msg_data);
4093:
4094: -- Debug info.
4111: ROLLBACK TO create_bank_group_member;
4112: x_return_status := fnd_api.g_ret_sts_unexp_error;
4113: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4114: fnd_message.set_token('ERROR',SQLERRM);
4115: fnd_msg_pub.add;
4116: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4117: p_count => x_msg_count,
4118: p_data => x_msg_data);
4119:
4112: x_return_status := fnd_api.g_ret_sts_unexp_error;
4113: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4114: fnd_message.set_token('ERROR',SQLERRM);
4115: fnd_msg_pub.add;
4116: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4117: p_count => x_msg_count,
4118: p_data => x_msg_data);
4119:
4120: -- Debug info.
4233: EXCEPTION
4234: WHEN fnd_api.g_exc_error THEN
4235: ROLLBACK TO update_bank_group_member;
4236: x_return_status := fnd_api.g_ret_sts_error;
4237: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4238: p_count => x_msg_count,
4239: p_data => x_msg_data);
4240:
4241: -- Debug info.
4256:
4257: WHEN fnd_api.g_exc_unexpected_error THEN
4258: ROLLBACK TO update_bank_group_member;
4259: x_return_status := fnd_api.g_ret_sts_unexp_error;
4260: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4261: p_count => x_msg_count,
4262: p_data => x_msg_data);
4263:
4264: -- Debug info.
4281: ROLLBACK TO update_bank_group_member;
4282: x_return_status := fnd_api.g_ret_sts_unexp_error;
4283: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4284: fnd_message.set_token('ERROR',SQLERRM);
4285: fnd_msg_pub.add;
4286: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4287: p_count => x_msg_count,
4288: p_data => x_msg_data);
4289:
4282: x_return_status := fnd_api.g_ret_sts_unexp_error;
4283: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4284: fnd_message.set_token('ERROR',SQLERRM);
4285: fnd_msg_pub.add;
4286: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4287: p_count => x_msg_count,
4288: p_data => x_msg_data);
4289:
4290: -- Debug info.
4407: EXCEPTION
4408: WHEN fnd_api.g_exc_error THEN
4409: ROLLBACK TO create_clearinghouse_assign;
4410: x_return_status := fnd_api.g_ret_sts_error;
4411: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4412: p_count => x_msg_count,
4413: p_data => x_msg_data);
4414:
4415: -- Debug info.
4430:
4431: WHEN fnd_api.g_exc_unexpected_error THEN
4432: ROLLBACK TO create_clearinghouse_assign;
4433: x_return_status := fnd_api.g_ret_sts_unexp_error;
4434: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4435: p_count => x_msg_count,
4436: p_data => x_msg_data);
4437:
4438: -- Debug info.
4455: ROLLBACK TO create_clearinghouse_assign;
4456: x_return_status := fnd_api.g_ret_sts_unexp_error;
4457: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4458: fnd_message.set_token('ERROR',SQLERRM);
4459: fnd_msg_pub.add;
4460: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4461: p_count => x_msg_count,
4462: p_data => x_msg_data);
4463:
4456: x_return_status := fnd_api.g_ret_sts_unexp_error;
4457: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4458: fnd_message.set_token('ERROR',SQLERRM);
4459: fnd_msg_pub.add;
4460: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4461: p_count => x_msg_count,
4462: p_data => x_msg_data);
4463:
4464: -- Debug info.
4578: EXCEPTION
4579: WHEN fnd_api.g_exc_error THEN
4580: ROLLBACK TO update_clearinghouse_assign;
4581: x_return_status := fnd_api.g_ret_sts_error;
4582: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4583: p_count => x_msg_count,
4584: p_data => x_msg_data);
4585:
4586: -- Debug info.
4601:
4602: WHEN fnd_api.g_exc_unexpected_error THEN
4603: ROLLBACK TO update_clearinghouse_assign;
4604: x_return_status := fnd_api.g_ret_sts_unexp_error;
4605: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4606: p_count => x_msg_count,
4607: p_data => x_msg_data);
4608:
4609: -- Debug info.
4626: ROLLBACK TO update_clearinghouse_assign;
4627: x_return_status := fnd_api.g_ret_sts_unexp_error;
4628: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4629: fnd_message.set_token('ERROR',SQLERRM);
4630: fnd_msg_pub.add;
4631: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4632: p_count => x_msg_count,
4633: p_data => x_msg_data);
4634:
4627: x_return_status := fnd_api.g_ret_sts_unexp_error;
4628: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4629: fnd_message.set_token('ERROR',SQLERRM);
4630: fnd_msg_pub.add;
4631: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4632: p_count => x_msg_count,
4633: p_data => x_msg_data);
4634:
4635: -- Debug info.
4745: EXCEPTION
4746: WHEN fnd_api.g_exc_error THEN
4747: ROLLBACK TO create_bank_site;
4748: x_return_status := fnd_api.g_ret_sts_error;
4749: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4750: p_count => x_msg_count,
4751: p_data => x_msg_data);
4752:
4753: -- Debug info.
4768:
4769: WHEN fnd_api.g_exc_unexpected_error THEN
4770: ROLLBACK TO create_bank_site;
4771: x_return_status := fnd_api.g_ret_sts_unexp_error;
4772: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4773: p_count => x_msg_count,
4774: p_data => x_msg_data);
4775:
4776: -- Debug info.
4793: ROLLBACK TO create_bank_site;
4794: x_return_status := fnd_api.g_ret_sts_unexp_error;
4795: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4796: fnd_message.set_token('ERROR',SQLERRM);
4797: fnd_msg_pub.add;
4798: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4799: p_count => x_msg_count,
4800: p_data => x_msg_data);
4801:
4794: x_return_status := fnd_api.g_ret_sts_unexp_error;
4795: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4796: fnd_message.set_token('ERROR',SQLERRM);
4797: fnd_msg_pub.add;
4798: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4799: p_count => x_msg_count,
4800: p_data => x_msg_data);
4801:
4802: -- Debug info.
4909: EXCEPTION
4910: WHEN fnd_api.g_exc_error THEN
4911: ROLLBACK TO update_bank_site;
4912: x_return_status := fnd_api.g_ret_sts_error;
4913: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4914: p_count => x_msg_count,
4915: p_data => x_msg_data);
4916:
4917: -- Debug info.
4932:
4933: WHEN fnd_api.g_exc_unexpected_error THEN
4934: ROLLBACK TO update_bank_site;
4935: x_return_status := fnd_api.g_ret_sts_unexp_error;
4936: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4937: p_count => x_msg_count,
4938: p_data => x_msg_data);
4939:
4940: -- Debug info.
4957: ROLLBACK TO update_bank_site;
4958: x_return_status := fnd_api.g_ret_sts_unexp_error;
4959: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4960: fnd_message.set_token('ERROR',SQLERRM);
4961: fnd_msg_pub.add;
4962: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4963: p_count => x_msg_count,
4964: p_data => x_msg_data);
4965:
4958: x_return_status := fnd_api.g_ret_sts_unexp_error;
4959: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4960: fnd_message.set_token('ERROR',SQLERRM);
4961: fnd_msg_pub.add;
4962: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4963: p_count => x_msg_count,
4964: p_data => x_msg_data);
4965:
4966: -- Debug info.
5081: EXCEPTION
5082: WHEN fnd_api.g_exc_error THEN
5083: ROLLBACK TO create_edi_contact_point;
5084: x_return_status := fnd_api.g_ret_sts_error;
5085: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5086: p_count => x_msg_count,
5087: p_data => x_msg_data);
5088:
5089: -- Debug info.
5104:
5105: WHEN fnd_api.g_exc_unexpected_error THEN
5106: ROLLBACK TO create_edi_contact_point;
5107: x_return_status := fnd_api.g_ret_sts_unexp_error;
5108: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5109: p_count => x_msg_count,
5110: p_data => x_msg_data);
5111:
5112: -- Debug info.
5129: ROLLBACK TO create_edi_contact_point;
5130: x_return_status := fnd_api.g_ret_sts_unexp_error;
5131: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5132: fnd_message.set_token('ERROR',SQLERRM);
5133: fnd_msg_pub.add;
5134: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5135: p_count => x_msg_count,
5136: p_data => x_msg_data);
5137:
5130: x_return_status := fnd_api.g_ret_sts_unexp_error;
5131: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5132: fnd_message.set_token('ERROR',SQLERRM);
5133: fnd_msg_pub.add;
5134: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5135: p_count => x_msg_count,
5136: p_data => x_msg_data);
5137:
5138: -- Debug info.
5253: EXCEPTION
5254: WHEN fnd_api.g_exc_error THEN
5255: ROLLBACK TO update_edi_contact_point;
5256: x_return_status := fnd_api.g_ret_sts_error;
5257: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5258: p_count => x_msg_count,
5259: p_data => x_msg_data);
5260:
5261: -- Debug info.
5276:
5277: WHEN fnd_api.g_exc_unexpected_error THEN
5278: ROLLBACK TO update_edi_contact_point;
5279: x_return_status := fnd_api.g_ret_sts_unexp_error;
5280: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5281: p_count => x_msg_count,
5282: p_data => x_msg_data);
5283:
5284: -- Debug info.
5301: ROLLBACK TO update_edi_contact_point;
5302: x_return_status := fnd_api.g_ret_sts_unexp_error;
5303: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5304: fnd_message.set_token('ERROR',SQLERRM);
5305: fnd_msg_pub.add;
5306: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5307: p_count => x_msg_count,
5308: p_data => x_msg_data);
5309:
5302: x_return_status := fnd_api.g_ret_sts_unexp_error;
5303: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5304: fnd_message.set_token('ERROR',SQLERRM);
5305: fnd_msg_pub.add;
5306: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5307: p_count => x_msg_count,
5308: p_data => x_msg_data);
5309:
5310: -- Debug info.
5425: EXCEPTION
5426: WHEN fnd_api.g_exc_error THEN
5427: ROLLBACK TO create_eft_contact_point;
5428: x_return_status := fnd_api.g_ret_sts_error;
5429: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5430: p_count => x_msg_count,
5431: p_data => x_msg_data);
5432:
5433: -- Debug info.
5448:
5449: WHEN fnd_api.g_exc_unexpected_error THEN
5450: ROLLBACK TO create_eft_contact_point;
5451: x_return_status := fnd_api.g_ret_sts_unexp_error;
5452: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5453: p_count => x_msg_count,
5454: p_data => x_msg_data);
5455:
5456: -- Debug info.
5473: ROLLBACK TO create_eft_contact_point;
5474: x_return_status := fnd_api.g_ret_sts_unexp_error;
5475: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5476: fnd_message.set_token('ERROR',SQLERRM);
5477: fnd_msg_pub.add;
5478: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5479: p_count => x_msg_count,
5480: p_data => x_msg_data);
5481:
5474: x_return_status := fnd_api.g_ret_sts_unexp_error;
5475: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5476: fnd_message.set_token('ERROR',SQLERRM);
5477: fnd_msg_pub.add;
5478: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5479: p_count => x_msg_count,
5480: p_data => x_msg_data);
5481:
5482: -- Debug info.
5597: EXCEPTION
5598: WHEN fnd_api.g_exc_error THEN
5599: ROLLBACK TO update_eft_contact_point;
5600: x_return_status := fnd_api.g_ret_sts_error;
5601: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5602: p_count => x_msg_count,
5603: p_data => x_msg_data);
5604:
5605: -- Debug info.
5620:
5621: WHEN fnd_api.g_exc_unexpected_error THEN
5622: ROLLBACK TO update_eft_contact_point;
5623: x_return_status := fnd_api.g_ret_sts_unexp_error;
5624: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5625: p_count => x_msg_count,
5626: p_data => x_msg_data);
5627:
5628: -- Debug info.
5645: ROLLBACK TO update_eft_contact_point;
5646: x_return_status := fnd_api.g_ret_sts_unexp_error;
5647: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5648: fnd_message.set_token('ERROR',SQLERRM);
5649: fnd_msg_pub.add;
5650: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5651: p_count => x_msg_count,
5652: p_data => x_msg_data);
5653:
5646: x_return_status := fnd_api.g_ret_sts_unexp_error;
5647: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5648: fnd_message.set_token('ERROR',SQLERRM);
5649: fnd_msg_pub.add;
5650: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5651: p_count => x_msg_count,
5652: p_data => x_msg_data);
5653:
5654: -- Debug info.
5769: EXCEPTION
5770: WHEN fnd_api.g_exc_error THEN
5771: ROLLBACK TO create_web_contact_point;
5772: x_return_status := fnd_api.g_ret_sts_error;
5773: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5774: p_count => x_msg_count,
5775: p_data => x_msg_data);
5776:
5777: -- Debug info.
5792:
5793: WHEN fnd_api.g_exc_unexpected_error THEN
5794: ROLLBACK TO create_web_contact_point;
5795: x_return_status := fnd_api.g_ret_sts_unexp_error;
5796: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5797: p_count => x_msg_count,
5798: p_data => x_msg_data);
5799:
5800: -- Debug info.
5817: ROLLBACK TO create_web_contact_point;
5818: x_return_status := fnd_api.g_ret_sts_unexp_error;
5819: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5820: fnd_message.set_token('ERROR',SQLERRM);
5821: fnd_msg_pub.add;
5822: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5823: p_count => x_msg_count,
5824: p_data => x_msg_data);
5825:
5818: x_return_status := fnd_api.g_ret_sts_unexp_error;
5819: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5820: fnd_message.set_token('ERROR',SQLERRM);
5821: fnd_msg_pub.add;
5822: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5823: p_count => x_msg_count,
5824: p_data => x_msg_data);
5825:
5826: -- Debug info.
5941: EXCEPTION
5942: WHEN fnd_api.g_exc_error THEN
5943: ROLLBACK TO update_web_contact_point;
5944: x_return_status := fnd_api.g_ret_sts_error;
5945: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5946: p_count => x_msg_count,
5947: p_data => x_msg_data);
5948:
5949: -- Debug info.
5964:
5965: WHEN fnd_api.g_exc_unexpected_error THEN
5966: ROLLBACK TO update_web_contact_point;
5967: x_return_status := fnd_api.g_ret_sts_unexp_error;
5968: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5969: p_count => x_msg_count,
5970: p_data => x_msg_data);
5971:
5972: -- Debug info.
5989: ROLLBACK TO update_web_contact_point;
5990: x_return_status := fnd_api.g_ret_sts_unexp_error;
5991: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5992: fnd_message.set_token('ERROR',SQLERRM);
5993: fnd_msg_pub.add;
5994: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5995: p_count => x_msg_count,
5996: p_data => x_msg_data);
5997:
5990: x_return_status := fnd_api.g_ret_sts_unexp_error;
5991: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5992: fnd_message.set_token('ERROR',SQLERRM);
5993: fnd_msg_pub.add;
5994: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5995: p_count => x_msg_count,
5996: p_data => x_msg_data);
5997:
5998: -- Debug info.
6113: EXCEPTION
6114: WHEN fnd_api.g_exc_error THEN
6115: ROLLBACK TO create_phone_contact_point;
6116: x_return_status := fnd_api.g_ret_sts_error;
6117: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6118: p_count => x_msg_count,
6119: p_data => x_msg_data);
6120:
6121: -- Debug info.
6136:
6137: WHEN fnd_api.g_exc_unexpected_error THEN
6138: ROLLBACK TO create_phone_contact_point;
6139: x_return_status := fnd_api.g_ret_sts_unexp_error;
6140: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6141: p_count => x_msg_count,
6142: p_data => x_msg_data);
6143:
6144: -- Debug info.
6161: ROLLBACK TO create_phone_contact_point;
6162: x_return_status := fnd_api.g_ret_sts_unexp_error;
6163: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6164: fnd_message.set_token('ERROR',SQLERRM);
6165: fnd_msg_pub.add;
6166: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6167: p_count => x_msg_count,
6168: p_data => x_msg_data);
6169:
6162: x_return_status := fnd_api.g_ret_sts_unexp_error;
6163: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6164: fnd_message.set_token('ERROR',SQLERRM);
6165: fnd_msg_pub.add;
6166: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6167: p_count => x_msg_count,
6168: p_data => x_msg_data);
6169:
6170: -- Debug info.
6285: EXCEPTION
6286: WHEN fnd_api.g_exc_error THEN
6287: ROLLBACK TO update_phone_contact_point;
6288: x_return_status := fnd_api.g_ret_sts_error;
6289: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6290: p_count => x_msg_count,
6291: p_data => x_msg_data);
6292:
6293: -- Debug info.
6308:
6309: WHEN fnd_api.g_exc_unexpected_error THEN
6310: ROLLBACK TO update_phone_contact_point;
6311: x_return_status := fnd_api.g_ret_sts_unexp_error;
6312: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6313: p_count => x_msg_count,
6314: p_data => x_msg_data);
6315:
6316: -- Debug info.
6333: ROLLBACK TO update_phone_contact_point;
6334: x_return_status := fnd_api.g_ret_sts_unexp_error;
6335: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6336: fnd_message.set_token('ERROR',SQLERRM);
6337: fnd_msg_pub.add;
6338: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6339: p_count => x_msg_count,
6340: p_data => x_msg_data);
6341:
6334: x_return_status := fnd_api.g_ret_sts_unexp_error;
6335: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6336: fnd_message.set_token('ERROR',SQLERRM);
6337: fnd_msg_pub.add;
6338: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6339: p_count => x_msg_count,
6340: p_data => x_msg_data);
6341:
6342: -- Debug info.
6457: EXCEPTION
6458: WHEN fnd_api.g_exc_error THEN
6459: ROLLBACK TO create_email_contact_point;
6460: x_return_status := fnd_api.g_ret_sts_error;
6461: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6462: p_count => x_msg_count,
6463: p_data => x_msg_data);
6464:
6465: -- Debug info.
6480:
6481: WHEN fnd_api.g_exc_unexpected_error THEN
6482: ROLLBACK TO create_email_contact_point;
6483: x_return_status := fnd_api.g_ret_sts_unexp_error;
6484: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6485: p_count => x_msg_count,
6486: p_data => x_msg_data);
6487:
6488: -- Debug info.
6505: ROLLBACK TO create_email_contact_point;
6506: x_return_status := fnd_api.g_ret_sts_unexp_error;
6507: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6508: fnd_message.set_token('ERROR',SQLERRM);
6509: fnd_msg_pub.add;
6510: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6511: p_count => x_msg_count,
6512: p_data => x_msg_data);
6513:
6506: x_return_status := fnd_api.g_ret_sts_unexp_error;
6507: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6508: fnd_message.set_token('ERROR',SQLERRM);
6509: fnd_msg_pub.add;
6510: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6511: p_count => x_msg_count,
6512: p_data => x_msg_data);
6513:
6514: -- Debug info.
6629: EXCEPTION
6630: WHEN fnd_api.g_exc_error THEN
6631: ROLLBACK TO update_email_contact_point;
6632: x_return_status := fnd_api.g_ret_sts_error;
6633: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6634: p_count => x_msg_count,
6635: p_data => x_msg_data);
6636:
6637: -- Debug info.
6652:
6653: WHEN fnd_api.g_exc_unexpected_error THEN
6654: ROLLBACK TO update_email_contact_point;
6655: x_return_status := fnd_api.g_ret_sts_unexp_error;
6656: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6657: p_count => x_msg_count,
6658: p_data => x_msg_data);
6659:
6660: -- Debug info.
6677: ROLLBACK TO update_email_contact_point;
6678: x_return_status := fnd_api.g_ret_sts_unexp_error;
6679: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6680: fnd_message.set_token('ERROR',SQLERRM);
6681: fnd_msg_pub.add;
6682: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6683: p_count => x_msg_count,
6684: p_data => x_msg_data);
6685:
6678: x_return_status := fnd_api.g_ret_sts_unexp_error;
6679: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6680: fnd_message.set_token('ERROR',SQLERRM);
6681: fnd_msg_pub.add;
6682: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6683: p_count => x_msg_count,
6684: p_data => x_msg_data);
6685:
6686: -- Debug info.
6801: EXCEPTION
6802: WHEN fnd_api.g_exc_error THEN
6803: ROLLBACK TO create_telex_contact_point;
6804: x_return_status := fnd_api.g_ret_sts_error;
6805: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6806: p_count => x_msg_count,
6807: p_data => x_msg_data);
6808:
6809: -- Debug info.
6824:
6825: WHEN fnd_api.g_exc_unexpected_error THEN
6826: ROLLBACK TO create_telex_contact_point;
6827: x_return_status := fnd_api.g_ret_sts_unexp_error;
6828: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6829: p_count => x_msg_count,
6830: p_data => x_msg_data);
6831:
6832: -- Debug info.
6849: ROLLBACK TO create_telex_contact_point;
6850: x_return_status := fnd_api.g_ret_sts_unexp_error;
6851: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6852: fnd_message.set_token('ERROR',SQLERRM);
6853: fnd_msg_pub.add;
6854: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6855: p_count => x_msg_count,
6856: p_data => x_msg_data);
6857:
6850: x_return_status := fnd_api.g_ret_sts_unexp_error;
6851: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6852: fnd_message.set_token('ERROR',SQLERRM);
6853: fnd_msg_pub.add;
6854: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6855: p_count => x_msg_count,
6856: p_data => x_msg_data);
6857:
6858: -- Debug info.
6974: EXCEPTION
6975: WHEN fnd_api.g_exc_error THEN
6976: ROLLBACK TO update_telex_contact_point;
6977: x_return_status := fnd_api.g_ret_sts_error;
6978: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6979: p_count => x_msg_count,
6980: p_data => x_msg_data);
6981:
6982: -- Debug info.
6997:
6998: WHEN fnd_api.g_exc_unexpected_error THEN
6999: ROLLBACK TO update_telex_contact_point;
7000: x_return_status := fnd_api.g_ret_sts_unexp_error;
7001: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
7002: p_count => x_msg_count,
7003: p_data => x_msg_data);
7004:
7005: -- Debug info.
7022: ROLLBACK TO update_telex_contact_point;
7023: x_return_status := fnd_api.g_ret_sts_unexp_error;
7024: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7025: fnd_message.set_token('ERROR',SQLERRM);
7026: fnd_msg_pub.add;
7027: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
7028: p_count => x_msg_count,
7029: p_data => x_msg_data);
7030:
7023: x_return_status := fnd_api.g_ret_sts_unexp_error;
7024: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7025: fnd_message.set_token('ERROR',SQLERRM);
7026: fnd_msg_pub.add;
7027: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
7028: p_count => x_msg_count,
7029: p_data => x_msg_data);
7030:
7031: -- Debug info.
7103: -- initialize message list if p_init_msg_list is set to TRUE.
7104: IF p_init_msg_list IS NOT NULL AND
7105: fnd_api.To_Boolean(p_init_msg_list)
7106: THEN
7107: fnd_msg_pub.initialize;
7108: END IF;
7109:
7110: -- initialize API return status to success.
7111: x_return_status := fnd_api.g_ret_sts_success;
7116: p_mode <> 'U')
7117: THEN
7118: fnd_message.set_name('AR', 'HZ_INVALID_BATCH_PARAM');
7119: fnd_message.set_token('PARAMTER', 'p_mode');
7120: fnd_msg_pub.add;
7121: raise fnd_api.g_exc_error;
7122: END IF;
7123:
7124: l_bank_rec := p_bank_rec;
7136: raise fnd_api.g_exc_error;
7137: END IF;
7138:
7139: -- standard call to get message count and if count is 1, get message info.
7140: fnd_msg_pub.Count_And_Get (
7141: p_encoded => fnd_api.G_FALSE,
7142: p_count => x_msg_count,
7143: p_data => x_msg_data);
7144:
7163: EXCEPTION
7164: WHEN fnd_api.G_EXC_ERROR THEN
7165: x_return_status := fnd_api.G_RET_STS_ERROR;
7166:
7167: fnd_msg_pub.Count_And_Get (
7168: p_encoded => fnd_api.G_FALSE,
7169: p_count => x_msg_count,
7170: p_data => x_msg_data
7171: );
7189: END IF;
7190:
7191: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
7192: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
7193: fnd_msg_pub.Count_And_Get (
7194: p_encoded => fnd_api.G_FALSE,
7195: p_count => x_msg_count,
7196: p_data => x_msg_data
7197: );
7218: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
7219:
7220: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7221: fnd_message.set_token('ERROR' ,SQLERRM);
7222: fnd_msg_pub.add;
7223:
7224: fnd_msg_pub.Count_And_Get (
7225: p_encoded => fnd_api.G_FALSE,
7226: p_count => x_msg_count,
7220: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7221: fnd_message.set_token('ERROR' ,SQLERRM);
7222: fnd_msg_pub.add;
7223:
7224: fnd_msg_pub.Count_And_Get (
7225: p_encoded => fnd_api.G_FALSE,
7226: p_count => x_msg_count,
7227: p_data => x_msg_data
7228: );
7306: -- initialize message list if p_init_msg_list is set to TRUE.
7307: IF p_init_msg_list IS NOT NULL AND
7308: fnd_api.To_Boolean(p_init_msg_list)
7309: THEN
7310: fnd_msg_pub.initialize;
7311: END IF;
7312:
7313: -- initialize API return status to success.
7314: x_return_status := fnd_api.G_RET_STS_SUCCESS;
7319: p_mode <> 'U')
7320: THEN
7321: fnd_message.set_name('AR', 'HZ_INVALID_BATCH_PARAM');
7322: fnd_message.set_token('PARAMTER', 'p_mode');
7323: fnd_msg_pub.add;
7324: raise fnd_api.g_exc_error;
7325: END IF;
7326:
7327: l_bank_branch_rec := p_bank_branch_rec;
7351: raise fnd_api.g_exc_error;
7352: END IF;
7353:
7354: -- standard call to get message count and if count is 1, get message info.
7355: fnd_msg_pub.Count_And_Get (
7356: p_encoded => fnd_api.G_FALSE,
7357: p_count => x_msg_count,
7358: p_data => x_msg_data);
7359:
7378: EXCEPTION
7379: WHEN fnd_api.G_EXC_ERROR THEN
7380: x_return_status := fnd_api.G_RET_STS_ERROR;
7381:
7382: fnd_msg_pub.Count_And_Get (
7383: p_encoded => fnd_api.G_FALSE,
7384: p_count => x_msg_count,
7385: p_data => x_msg_data
7386: );
7404: END IF;
7405:
7406: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
7407: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
7408: fnd_msg_pub.Count_And_Get (
7409: p_encoded => fnd_api.G_FALSE,
7410: p_count => x_msg_count,
7411: p_data => x_msg_data
7412: );
7433: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
7434:
7435: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7436: fnd_message.set_token('ERROR' ,SQLERRM);
7437: fnd_msg_pub.add;
7438:
7439: fnd_msg_pub.Count_And_Get (
7440: p_encoded => fnd_api.G_FALSE,
7441: p_count => x_msg_count,
7435: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7436: fnd_message.set_token('ERROR' ,SQLERRM);
7437: fnd_msg_pub.add;
7438:
7439: fnd_msg_pub.Count_And_Get (
7440: p_encoded => fnd_api.G_FALSE,
7441: p_count => x_msg_count,
7442: p_data => x_msg_data
7443: );