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.HZ_BANK_PUB dependencies on FND_MSG_PUB

Line 230: fnd_msg_pub.add;

226: l_parent_class_code <> 'CLEARINGHOUSE')
227: THEN
228: CLOSE c_codeassign;
229: fnd_message.set_name('AR', 'HZ_BANK_INVALID_PARENT');
230: fnd_msg_pub.add;
231: x_return_status := fnd_api.g_ret_sts_error;
232:
233: -- parent is not a bank: no point in going any further.
234: RETURN;

Line 247: fnd_msg_pub.add;

243: FETCH c_parentinfo INTO l_parent_number, l_parent_name, l_parent_country;
244: IF c_parentinfo%NOTFOUND THEN
245: CLOSE c_parentinfo;
246: fnd_message.set_name('AR', 'HZ_BANK_INVALID_PARENT');
247: fnd_msg_pub.add;
248: x_return_status := fnd_api.g_ret_sts_error;
249:
250: -- parent is not a bank: no point in going any further.
251: RETURN;

Line 273: fnd_msg_pub.add;

269: l_parent_country;
270: IF c_parentinfo2%NOTFOUND THEN
271: CLOSE c_parentinfo2;
272: fnd_message.set_name('AR', 'HZ_BANK_INVALID_PARENT');
273: fnd_msg_pub.add;
274: x_return_status := fnd_api.g_ret_sts_error;
275:
276: -- parent is not a bank: no point in going any further.
277: RETURN;

Line 296: fnd_msg_pub.add;

292: THEN
293: fnd_message.set_name('AR', 'HZ_BANK_INVALID_COUNTRY');
294: fnd_message.set_token('INVCOUNTRY', p_bank_rec.organization_rec.home_country);
295: fnd_message.set_token('VLDCOUNTRY', l_parent_country);
296: fnd_msg_pub.add;
297: x_return_status := fnd_api.g_ret_sts_error;
298: END IF;
299:
300: -- Debug info.

Line 328: fnd_msg_pub.add;

324: fnd_message.set_name('AR', 'HZ_BANK_NONUNIQUE_NUMBER');
325: fnd_message.set_token('BANK', l_parent_number);
326: fnd_message.set_token('BRANCH', p_bank_rec.bank_or_branch_number);
327: fnd_message.set_token('COUNTRY', l_parent_country);
328: fnd_msg_pub.add;
329: x_return_status := fnd_api.g_ret_sts_error;
330: END IF;
331: CLOSE c_uniquenumberck;
332: END IF;

Line 344: fnd_msg_pub.add;

340: fnd_message.set_name('AR', 'HZ_BANK_NONUNIQUE_NAME');
341: fnd_message.set_token('BANK', l_parent_name);
342: fnd_message.set_token('BRANCH',
343: p_bank_rec.organization_rec.organization_name);
344: fnd_msg_pub.add;
345: x_return_status := fnd_api.g_ret_sts_error;
346: END IF;
347: CLOSE c_uniquenameck;
348: */ -- End of Bug14353281

Line 416: -- fnd_msg_pub.add;

412: -- fnd_message.set_name('AR', 'HZ_API_MAND_DEP_FIELDS');
413: -- fnd_message.set_token('COLUMN1', 'bank or branch number');
414: -- fnd_message.set_token('VALUE1', 'NULL');
415: -- fnd_message.set_token('COLUMN2', 'bank or branch number');
416: -- fnd_msg_pub.add;
417: -- x_return_status := fnd_api.g_ret_sts_error;
418: -- END IF;
419:
420: IF p_intended_type = 'BANK' THEN

Line 424: fnd_msg_pub.add;

420: IF p_intended_type = 'BANK' THEN
421: -- branch code must be null
422: IF p_bank_rec.branch_code IS NOT NULL THEN
423: fnd_message.set_name('AR', 'HZ_BANK_BRANCH_SPECIFIED');
424: fnd_msg_pub.add;
425: x_return_status := fnd_api.g_ret_sts_error;
426: END IF;
427:
428: -- bank institution type must be either CLEARINGHOUSE OR BANK

Line 433: fnd_msg_pub.add;

429: IF p_bank_rec.institution_type NOT IN ('BANK', 'CLEARINGHOUSE') THEN
430: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
431: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE, BANK');
432: fnd_message.set_token('INVALIDSUB', p_bank_rec.institution_type);
433: fnd_msg_pub.add;
434: x_return_status := fnd_api.g_ret_sts_error;
435: END IF;
436:
437: -- set the validation procedure to be run.

Line 447: fnd_msg_pub.add;

443: NOT IN ('BANK_BRANCH', 'CLEARINGHOUSE_BRANCH') THEN
444: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
445: fnd_message.set_token('VALIDSUB', 'BANK_BRANCH, CLEARINGHOUSE_BRANCH');
446: fnd_message.set_token('INVALIDSUB', p_bank_rec.institution_type);
447: fnd_msg_pub.add;
448: x_return_status := fnd_api.g_ret_sts_error;
449: END IF;
450:
451: -- set the validation procedure to be run.

Line 474: fnd_msg_pub.add;

470: CLOSE orgidcur;
471:
472: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
473: fnd_message.set_token('SEQUENCE', 'hz_parties_s'); -- Bug 3397488
474: fnd_msg_pub.add;
475: RAISE fnd_api.g_exc_error;
476: END IF;
477: CLOSE orgidcur;
478: -- Bug 3814832

Line 629: fnd_msg_pub.add;

625: OPEN c_uniqueptyedi;
626: FETCH c_uniqueptyedi INTO l_dummy;
627: IF c_uniqueptyedi%FOUND THEN
628: fnd_message.set_name('AR', 'HZ_EDI_UNIQUE');
629: fnd_msg_pub.add;
630: x_return_status := fnd_api.g_ret_sts_error;
631: ELSE
632: -- party contacts passed, check across party site contacts.
633: OPEN c_uniquepsedi;

Line 637: fnd_msg_pub.add;

633: OPEN c_uniquepsedi;
634: FETCH c_uniquepsedi INTO l_dummy;
635: IF c_uniquepsedi%FOUND THEN
636: fnd_message.set_name('AR', 'HZ_EDI_UNIQUE');
637: fnd_msg_pub.add;
638: x_return_status := fnd_api.g_ret_sts_error;
639: END IF;
640: CLOSE c_uniquepsedi;
641: END IF;

Line 1028: fnd_msg_pub.add;

1024: IF p_group_rec.group_type <> 'BANKING_GROUP' THEN
1025: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1026: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1027: fnd_message.set_token('INVALIDSUB', p_group_rec.group_type);
1028: fnd_msg_pub.add;
1029: x_return_status := fnd_api.g_ret_sts_error;
1030: END IF;
1031:
1032: BEGIN

Line 1092: fnd_msg_pub.add;

1088: IF c_group%NOTFOUND THEN
1089: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1090: fnd_message.set_token('RECORD', 'party');
1091: fnd_message.set_token('VALUE', TO_CHAR(p_party_id));
1092: fnd_msg_pub.add;
1093: x_return_status := fnd_api.g_ret_sts_error;
1094: END IF;
1095: CLOSE c_group;
1096:

Line 1141: fnd_msg_pub.add;

1137: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1138: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1139: fnd_message.set_token('INVALIDSUB',
1140: p_relationship_rec.relationship_type);
1141: fnd_msg_pub.add;
1142: x_return_status := fnd_api.g_ret_sts_error;
1143: END IF;
1144:
1145: --

Line 1178: fnd_msg_pub.add;

1174: -- if the object is also not the right type, then this is not valid.
1175: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1176: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1177: fnd_message.set_token('INVALIDSUB', l_group_type);
1178: fnd_msg_pub.add;
1179: x_return_status := fnd_api.g_ret_sts_error;
1180:
1181: -- return, the rest of the validations do not make sense if neither
1182: -- subject nor object is a valid banking group.

Line 1207: fnd_msg_pub.add;

1203: ELSE
1204: fnd_message.set_token('VALIDSUB', 'C');
1205: END IF;
1206: fnd_message.set_token('INVALIDSUB', l_direction);
1207: fnd_msg_pub.add;
1208: x_return_status := fnd_api.g_ret_sts_error;
1209: END IF;
1210: ELSE
1211: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

Line 1214: fnd_msg_pub.add;

1210: ELSE
1211: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1212: fnd_message.set_token('RECORD', 'banking group relationship type');
1213: fnd_message.set_token('VALUE', p_relationship_rec.relationship_type);
1214: fnd_msg_pub.add;
1215: x_return_status := fnd_api.g_ret_sts_error;
1216: END IF;
1217: CLOSE c_reldir;
1218:

Line 1237: fnd_msg_pub.add;

1233: IF c_codeassign%NOTFOUND THEN
1234: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1235: fnd_message.set_token('RECORD', 'bank classification code assignment');
1236: fnd_message.set_token('VALUE', TO_CHAR(l_bank_id));
1237: fnd_msg_pub.add;
1238: x_return_status := fnd_api.g_ret_sts_error;
1239: END IF;
1240:
1241: IF l_class_code IS NOT NULL

Line 1247: fnd_msg_pub.add;

1243: THEN
1244: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1245: fnd_message.set_token('VALIDSUB', 'BANK, CLEARINGHOUSE');
1246: fnd_message.set_token('INVALIDSUB', l_class_code);
1247: fnd_msg_pub.add;
1248: x_return_status := fnd_api.g_ret_sts_error;
1249: END IF;
1250: CLOSE c_codeassign;
1251: END IF;

Line 1326: fnd_msg_pub.add;

1322: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1323: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE_BANK');
1324: fnd_message.set_token('INVALIDSUB',
1325: p_relationship_rec.relationship_type);
1326: fnd_msg_pub.add;
1327: x_return_status := fnd_api.g_ret_sts_error;
1328: END IF;
1329:
1330: --

Line 1348: fnd_msg_pub.add;

1344: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1345: fnd_message.set_token('RECORD',
1346: 'bank/clearinghouse code assignment (subject)');
1347: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_rec.subject_id));
1348: fnd_msg_pub.add;
1349: x_return_status := fnd_api.g_ret_sts_error;
1350: ELSIF l_subject_class NOT IN ('CLEARINGHOUSE', 'BANK', 'BANK_BRANCH')
1351: THEN
1352: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');

Line 1355: fnd_msg_pub.add;

1351: THEN
1352: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1353: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE, BANK');
1354: fnd_message.set_token('INVALIDSUB', l_subject_class);
1355: fnd_msg_pub.add;
1356: x_return_status := fnd_api.g_ret_sts_error;
1357: END IF;
1358: CLOSE c_codeassign;
1359:

Line 1372: fnd_msg_pub.add;

1368: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1369: fnd_message.set_token('RECORD',
1370: 'bank/clearinghouse code assignment (object)');
1371: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_rec.object_id));
1372: fnd_msg_pub.add;
1373: x_return_status := fnd_api.g_ret_sts_error;
1374: ELSIF l_object_class NOT IN ('CLEARINGHOUSE', 'BANK', 'BANK_BRANCH') THEN
1375: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1376: fnd_message.set_token('VALIDSUB', 'BANK, CLEARINGHOUSE');

Line 1378: fnd_msg_pub.add;

1374: ELSIF l_object_class NOT IN ('CLEARINGHOUSE', 'BANK', 'BANK_BRANCH') THEN
1375: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1376: fnd_message.set_token('VALIDSUB', 'BANK, CLEARINGHOUSE');
1377: fnd_message.set_token('INVALIDSUB', l_object_class);
1378: fnd_msg_pub.add;
1379: x_return_status := fnd_api.g_ret_sts_error;
1380: ELSIF l_subject_class = l_object_class THEN
1381: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1382: fnd_message.set_token('VALIDSUB', 'different');

Line 1384: fnd_msg_pub.add;

1380: ELSIF l_subject_class = l_object_class THEN
1381: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1382: fnd_message.set_token('VALIDSUB', 'different');
1383: fnd_message.set_token('INVALIDSUB', l_object_class);
1384: fnd_msg_pub.add;
1385: x_return_status := fnd_api.g_ret_sts_error;
1386: END IF;
1387: CLOSE c_codeassign;
1388:

Line 1410: fnd_msg_pub.add;

1406: ELSE
1407: fnd_message.set_token('VALIDSUB', 'C');
1408: END IF;
1409: fnd_message.set_token('INVALIDSUB', l_direction);
1410: fnd_msg_pub.add;
1411: x_return_status := fnd_api.g_ret_sts_error;
1412: END IF;
1413: ELSE
1414: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

Line 1418: fnd_msg_pub.add;

1414: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1415: fnd_message.set_token('RECORD',
1416: 'clearinghouse assignment relationship type');
1417: fnd_message.set_token('VALUE', p_relationship_rec.relationship_type);
1418: fnd_msg_pub.add;
1419: x_return_status := fnd_api.g_ret_sts_error;
1420: END IF;
1421: CLOSE c_reldir;
1422: END IF;

Line 1531: fnd_msg_pub.add;

1527: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1528: fnd_message.set_token('FK', 'party or location');
1529: fnd_message.set_token('COLUMN', 'PARTY_ID or LOCATION_ID');
1530: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
1531: fnd_msg_pub.add;
1532: x_return_status := fnd_api.g_ret_sts_error;
1533: -- no point doing further validations. We're missing some data.
1534: RETURN;
1535: END IF;

Line 1545: fnd_msg_pub.add;

1541: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1542: fnd_message.set_token('FK', 'party or location');
1543: fnd_message.set_token('COLUMN', 'PARTY_ID or LOCATION_ID');
1544: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
1545: fnd_msg_pub.add;
1546: x_return_status := fnd_api.g_ret_sts_error;
1547: -- no point doing further validations. We're missing some data.
1548: RETURN;
1549: END IF;

Line 1567: fnd_msg_pub.add;

1563: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1564: fnd_message.set_token('FK', 'active party');
1565: fnd_message.set_token('COLUMN', 'PARTY_ID');
1566: fnd_message.set_token('TABLE', 'HZ_PARTIES');
1567: fnd_msg_pub.add;
1568: x_return_status := fnd_api.g_ret_sts_error;
1569: END IF;
1570: CLOSE c_parentcountry;
1571:

Line 1579: fnd_msg_pub.add;

1575: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1576: fnd_message.set_token('FK', 'active location');
1577: fnd_message.set_token('COLUMN', 'LOCATION_ID');
1578: fnd_message.set_token('TABLE', 'HZ_LOCATIONS');
1579: fnd_msg_pub.add;
1580: x_return_status := fnd_api.g_ret_sts_error;
1581: END IF;
1582: CLOSE c_sitecountry;
1583:

Line 1588: fnd_msg_pub.add;

1584: IF l_parent_country <> l_site_country THEN
1585: fnd_message.set_name('AR', 'HZ_BANK_INVALID_COUNTRY');
1586: fnd_message.set_token('INVCOUNTRY', l_site_country);
1587: fnd_message.set_token('VLDCOUNTRY', l_parent_country);
1588: fnd_msg_pub.add;
1589: x_return_status := fnd_api.g_ret_sts_error;
1590: END IF;
1591: END IF;
1592:

Line 1606: fnd_msg_pub.add;

1602: IF c_codeassign%NOTFOUND THEN
1603: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1604: fnd_message.set_token('RECORD', 'bank-related code assignment');
1605: fnd_message.set_token('VALUE', TO_CHAR(p_party_site_rec.party_id));
1606: fnd_msg_pub.add;
1607: x_return_status := fnd_api.g_ret_sts_error;
1608: ELSIF l_class_code NOT IN ('CLEARINGHOUSE', 'BANK', 'BANK_BRANCH') THEN
1609: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1610: fnd_message.set_token('VALIDSUB',

Line 1613: fnd_msg_pub.add;

1609: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1610: fnd_message.set_token('VALIDSUB',
1611: 'BANK, CLEARINGHOUSE, BANK_BRANCH');
1612: fnd_message.set_token('INVALIDSUB', l_class_code);
1613: fnd_msg_pub.add;
1614: x_return_status := fnd_api.g_ret_sts_error;
1615: END IF;
1616: CLOSE c_codeassign;
1617: END IF;

Line 2028: fnd_msg_pub.add;

2024: CLOSE c_rel;
2025: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
2026: fnd_message.set_token('RECORD', 'relationship');
2027: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_id));
2028: fnd_msg_pub.add;
2029: x_return_status := fnd_api.g_ret_sts_error;
2030:
2031: -- Debug info.
2032: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2581: fnd_msg_pub.initialize;

2577: END IF;
2578:
2579: -- initialize message list if p_init_msg_list is set to TRUE.
2580: IF fnd_api.to_boolean(p_init_msg_list) THEN
2581: fnd_msg_pub.initialize;
2582: END IF;
2583:
2584: -- initialize API return status to success.
2585: x_return_status := fnd_api.g_ret_sts_success;

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

2658: END IF;
2659: END IF;
2660:
2661: -- standard call to get message count and if count is 1, get message info.
2662: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2663: p_count => x_msg_count,
2664: p_data => x_msg_data);
2665:
2666: -- Debug info.

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

2682: EXCEPTION
2683: WHEN fnd_api.g_exc_error THEN
2684: ROLLBACK TO create_bank;
2685: x_return_status := fnd_api.g_ret_sts_error;
2686: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2687: p_count => x_msg_count,
2688: p_data => x_msg_data);
2689:
2690: -- Debug info.

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

2705:
2706: WHEN fnd_api.g_exc_unexpected_error THEN
2707: ROLLBACK TO create_bank;
2708: x_return_status := fnd_api.g_ret_sts_unexp_error;
2709: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2710: p_count => x_msg_count,
2711: p_data => x_msg_data);
2712:
2713: -- Debug info.

Line 2735: fnd_msg_pub.add;

2731: ROLLBACK TO create_bank;
2732: x_return_status := fnd_api.g_ret_sts_unexp_error;
2733: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2734: fnd_message.set_token('ERROR',SQLERRM);
2735: fnd_msg_pub.add;
2736: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2737: p_count => x_msg_count,
2738: p_data => x_msg_data);
2739:

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

2732: x_return_status := fnd_api.g_ret_sts_unexp_error;
2733: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2734: fnd_message.set_token('ERROR',SQLERRM);
2735: fnd_msg_pub.add;
2736: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2737: p_count => x_msg_count,
2738: p_data => x_msg_data);
2739:
2740: -- Debug info.

Line 2831: fnd_msg_pub.initialize;

2827: END IF;
2828:
2829: -- initialize message list if p_init_msg_list is set to TRUE.
2830: IF fnd_api.to_boolean(p_init_msg_list) THEN
2831: fnd_msg_pub.initialize;
2832: END IF;
2833:
2834: -- initialize API return status to success.
2835: x_return_status := fnd_api.g_ret_sts_success;

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

2904: END IF;
2905: END IF;
2906:
2907: -- standard call to get message count and if count is 1, get message info.
2908: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2909: p_count => x_msg_count,
2910: p_data => x_msg_data);
2911:
2912: -- Debug info.

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

2928: EXCEPTION
2929: WHEN fnd_api.g_exc_error THEN
2930: ROLLBACK TO update_bank;
2931: x_return_status := fnd_api.g_ret_sts_error;
2932: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2933: p_count => x_msg_count,
2934: p_data => x_msg_data);
2935:
2936: -- Debug info.

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

2951:
2952: WHEN fnd_api.g_exc_unexpected_error THEN
2953: ROLLBACK TO update_bank;
2954: x_return_status := fnd_api.g_ret_sts_unexp_error;
2955: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2956: p_count => x_msg_count,
2957: p_data => x_msg_data);
2958:
2959: -- Debug info.

Line 2980: fnd_msg_pub.add;

2976: ROLLBACK TO update_bank;
2977: x_return_status := fnd_api.g_ret_sts_unexp_error;
2978: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2979: fnd_message.set_token('ERROR',SQLERRM);
2980: fnd_msg_pub.add;
2981: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2982: p_count => x_msg_count,
2983: p_data => x_msg_data);
2984:

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

2977: x_return_status := fnd_api.g_ret_sts_unexp_error;
2978: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2979: fnd_message.set_token('ERROR',SQLERRM);
2980: fnd_msg_pub.add;
2981: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2982: p_count => x_msg_count,
2983: p_data => x_msg_data);
2984:
2985: -- Debug info.

Line 3081: fnd_msg_pub.initialize;

3077: END IF;
3078:
3079: -- initialize message list if p_init_msg_list is set to TRUE.
3080: IF fnd_api.to_boolean(p_init_msg_list) THEN
3081: fnd_msg_pub.initialize;
3082: END IF;
3083:
3084: -- initialize API return status to success.
3085: x_return_status := fnd_api.g_ret_sts_success;

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

3225: END IF;
3226: END IF;
3227:
3228: -- standard call to get message count and if count is 1, get message info.
3229: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3230: p_count => x_msg_count,
3231: p_data => x_msg_data);
3232:
3233: -- Debug info.

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

3249: EXCEPTION
3250: WHEN fnd_api.g_exc_error THEN
3251: ROLLBACK TO create_bank_branch;
3252: x_return_status := fnd_api.g_ret_sts_error;
3253: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3254: p_count => x_msg_count,
3255: p_data => x_msg_data);
3256:
3257: -- Debug info.

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

3272:
3273: WHEN fnd_api.g_exc_unexpected_error THEN
3274: ROLLBACK TO create_bank_branch;
3275: x_return_status := fnd_api.g_ret_sts_unexp_error;
3276: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3277: p_count => x_msg_count,
3278: p_data => x_msg_data);
3279:
3280: -- Debug info.

Line 3301: fnd_msg_pub.add;

3297: ROLLBACK TO create_bank_branch;
3298: x_return_status := fnd_api.g_ret_sts_unexp_error;
3299: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3300: fnd_message.set_token('ERROR',SQLERRM);
3301: fnd_msg_pub.add;
3302: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3303: p_count => x_msg_count,
3304: p_data => x_msg_data);
3305:

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

3298: x_return_status := fnd_api.g_ret_sts_unexp_error;
3299: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3300: fnd_message.set_token('ERROR',SQLERRM);
3301: fnd_msg_pub.add;
3302: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3303: p_count => x_msg_count,
3304: p_data => x_msg_data);
3305:
3306: -- Debug info.

Line 3404: fnd_msg_pub.initialize;

3400: END IF;
3401:
3402: -- initialize message list if p_init_msg_list is set to TRUE.
3403: IF fnd_api.to_boolean(p_init_msg_list) THEN
3404: fnd_msg_pub.initialize;
3405: END IF;
3406:
3407: -- initialize API return status to success.
3408: x_return_status := fnd_api.g_ret_sts_success;

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

3559: END IF;
3560: END IF;
3561:
3562: -- standard call to get message count and if count is 1, get message info.
3563: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3564: p_count => x_msg_count,
3565: p_data => x_msg_data);
3566:
3567: -- Debug info.

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

3583: EXCEPTION
3584: WHEN fnd_api.g_exc_error THEN
3585: ROLLBACK TO update_bank_branch;
3586: x_return_status := fnd_api.g_ret_sts_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.

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

3606:
3607: WHEN fnd_api.g_exc_unexpected_error THEN
3608: ROLLBACK TO update_bank_branch;
3609: x_return_status := fnd_api.g_ret_sts_unexp_error;
3610: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3611: p_count => x_msg_count,
3612: p_data => x_msg_data);
3613:
3614: -- Debug info.

Line 3635: fnd_msg_pub.add;

3631: ROLLBACK TO update_bank_branch;
3632: x_return_status := fnd_api.g_ret_sts_unexp_error;
3633: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3634: fnd_message.set_token('ERROR',SQLERRM);
3635: fnd_msg_pub.add;
3636: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3637: p_count => x_msg_count,
3638: p_data => x_msg_data);
3639:

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

3632: x_return_status := fnd_api.g_ret_sts_unexp_error;
3633: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3634: fnd_message.set_token('ERROR',SQLERRM);
3635: fnd_msg_pub.add;
3636: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3637: p_count => x_msg_count,
3638: p_data => x_msg_data);
3639:
3640: -- Debug info.

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

3749: EXCEPTION
3750: WHEN fnd_api.g_exc_error THEN
3751: ROLLBACK TO create_banking_group;
3752: x_return_status := fnd_api.g_ret_sts_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.

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

3772:
3773: WHEN fnd_api.g_exc_unexpected_error THEN
3774: ROLLBACK TO create_banking_group;
3775: x_return_status := fnd_api.g_ret_sts_unexp_error;
3776: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3777: p_count => x_msg_count,
3778: p_data => x_msg_data);
3779:
3780: -- Debug info.

Line 3801: fnd_msg_pub.add;

3797: ROLLBACK TO create_banking_group;
3798: x_return_status := fnd_api.g_ret_sts_unexp_error;
3799: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3800: fnd_message.set_token('ERROR',SQLERRM);
3801: fnd_msg_pub.add;
3802: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3803: p_count => x_msg_count,
3804: p_data => x_msg_data);
3805:

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

3798: x_return_status := fnd_api.g_ret_sts_unexp_error;
3799: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3800: fnd_message.set_token('ERROR',SQLERRM);
3801: fnd_msg_pub.add;
3802: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3803: p_count => x_msg_count,
3804: p_data => x_msg_data);
3805:
3806: -- Debug info.

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

3913: EXCEPTION
3914: WHEN fnd_api.g_exc_error THEN
3915: ROLLBACK TO update_banking_group;
3916: x_return_status := fnd_api.g_ret_sts_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.

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

3936:
3937: WHEN fnd_api.g_exc_unexpected_error THEN
3938: ROLLBACK TO update_banking_group;
3939: x_return_status := fnd_api.g_ret_sts_unexp_error;
3940: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3941: p_count => x_msg_count,
3942: p_data => x_msg_data);
3943:
3944: -- Debug info.

Line 3965: fnd_msg_pub.add;

3961: ROLLBACK TO update_banking_group;
3962: x_return_status := fnd_api.g_ret_sts_unexp_error;
3963: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3964: fnd_message.set_token('ERROR',SQLERRM);
3965: fnd_msg_pub.add;
3966: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3967: p_count => x_msg_count,
3968: p_data => x_msg_data);
3969:

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

3962: x_return_status := fnd_api.g_ret_sts_unexp_error;
3963: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3964: fnd_message.set_token('ERROR',SQLERRM);
3965: fnd_msg_pub.add;
3966: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3967: p_count => x_msg_count,
3968: p_data => x_msg_data);
3969:
3970: -- Debug info.

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

4086: EXCEPTION
4087: WHEN fnd_api.g_exc_error THEN
4088: ROLLBACK TO create_bank_group_member;
4089: x_return_status := fnd_api.g_ret_sts_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.

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

4109:
4110: WHEN fnd_api.g_exc_unexpected_error THEN
4111: ROLLBACK TO create_bank_group_member;
4112: x_return_status := fnd_api.g_ret_sts_unexp_error;
4113: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4114: p_count => x_msg_count,
4115: p_data => x_msg_data);
4116:
4117: -- Debug info.

Line 4138: fnd_msg_pub.add;

4134: ROLLBACK TO create_bank_group_member;
4135: x_return_status := fnd_api.g_ret_sts_unexp_error;
4136: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4137: fnd_message.set_token('ERROR',SQLERRM);
4138: fnd_msg_pub.add;
4139: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4140: p_count => x_msg_count,
4141: p_data => x_msg_data);
4142:

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

4135: x_return_status := fnd_api.g_ret_sts_unexp_error;
4136: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4137: fnd_message.set_token('ERROR',SQLERRM);
4138: fnd_msg_pub.add;
4139: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4140: p_count => x_msg_count,
4141: p_data => x_msg_data);
4142:
4143: -- Debug info.

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

4256: EXCEPTION
4257: WHEN fnd_api.g_exc_error THEN
4258: ROLLBACK TO update_bank_group_member;
4259: x_return_status := fnd_api.g_ret_sts_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.

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

4279:
4280: WHEN fnd_api.g_exc_unexpected_error THEN
4281: ROLLBACK TO update_bank_group_member;
4282: x_return_status := fnd_api.g_ret_sts_unexp_error;
4283: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4284: p_count => x_msg_count,
4285: p_data => x_msg_data);
4286:
4287: -- Debug info.

Line 4308: fnd_msg_pub.add;

4304: ROLLBACK TO update_bank_group_member;
4305: x_return_status := fnd_api.g_ret_sts_unexp_error;
4306: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4307: fnd_message.set_token('ERROR',SQLERRM);
4308: fnd_msg_pub.add;
4309: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4310: p_count => x_msg_count,
4311: p_data => x_msg_data);
4312:

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

4305: x_return_status := fnd_api.g_ret_sts_unexp_error;
4306: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4307: fnd_message.set_token('ERROR',SQLERRM);
4308: fnd_msg_pub.add;
4309: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4310: p_count => x_msg_count,
4311: p_data => x_msg_data);
4312:
4313: -- Debug info.

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

4430: EXCEPTION
4431: WHEN fnd_api.g_exc_error THEN
4432: ROLLBACK TO create_clearinghouse_assign;
4433: x_return_status := fnd_api.g_ret_sts_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.

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

4453:
4454: WHEN fnd_api.g_exc_unexpected_error THEN
4455: ROLLBACK TO create_clearinghouse_assign;
4456: x_return_status := fnd_api.g_ret_sts_unexp_error;
4457: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4458: p_count => x_msg_count,
4459: p_data => x_msg_data);
4460:
4461: -- Debug info.

Line 4482: fnd_msg_pub.add;

4478: ROLLBACK TO create_clearinghouse_assign;
4479: x_return_status := fnd_api.g_ret_sts_unexp_error;
4480: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4481: fnd_message.set_token('ERROR',SQLERRM);
4482: fnd_msg_pub.add;
4483: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4484: p_count => x_msg_count,
4485: p_data => x_msg_data);
4486:

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

4479: x_return_status := fnd_api.g_ret_sts_unexp_error;
4480: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4481: fnd_message.set_token('ERROR',SQLERRM);
4482: fnd_msg_pub.add;
4483: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4484: p_count => x_msg_count,
4485: p_data => x_msg_data);
4486:
4487: -- Debug info.

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

4601: EXCEPTION
4602: WHEN fnd_api.g_exc_error THEN
4603: ROLLBACK TO update_clearinghouse_assign;
4604: x_return_status := fnd_api.g_ret_sts_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.

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

4624:
4625: WHEN fnd_api.g_exc_unexpected_error THEN
4626: ROLLBACK TO update_clearinghouse_assign;
4627: x_return_status := fnd_api.g_ret_sts_unexp_error;
4628: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4629: p_count => x_msg_count,
4630: p_data => x_msg_data);
4631:
4632: -- Debug info.

Line 4653: fnd_msg_pub.add;

4649: ROLLBACK TO update_clearinghouse_assign;
4650: x_return_status := fnd_api.g_ret_sts_unexp_error;
4651: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4652: fnd_message.set_token('ERROR',SQLERRM);
4653: fnd_msg_pub.add;
4654: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4655: p_count => x_msg_count,
4656: p_data => x_msg_data);
4657:

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

4650: x_return_status := fnd_api.g_ret_sts_unexp_error;
4651: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4652: fnd_message.set_token('ERROR',SQLERRM);
4653: fnd_msg_pub.add;
4654: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4655: p_count => x_msg_count,
4656: p_data => x_msg_data);
4657:
4658: -- Debug info.

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

4768: EXCEPTION
4769: WHEN fnd_api.g_exc_error THEN
4770: ROLLBACK TO create_bank_site;
4771: x_return_status := fnd_api.g_ret_sts_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.

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

4791:
4792: WHEN fnd_api.g_exc_unexpected_error THEN
4793: ROLLBACK TO create_bank_site;
4794: x_return_status := fnd_api.g_ret_sts_unexp_error;
4795: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4796: p_count => x_msg_count,
4797: p_data => x_msg_data);
4798:
4799: -- Debug info.

Line 4820: fnd_msg_pub.add;

4816: ROLLBACK TO create_bank_site;
4817: x_return_status := fnd_api.g_ret_sts_unexp_error;
4818: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4819: fnd_message.set_token('ERROR',SQLERRM);
4820: fnd_msg_pub.add;
4821: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4822: p_count => x_msg_count,
4823: p_data => x_msg_data);
4824:

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

4817: x_return_status := fnd_api.g_ret_sts_unexp_error;
4818: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4819: fnd_message.set_token('ERROR',SQLERRM);
4820: fnd_msg_pub.add;
4821: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4822: p_count => x_msg_count,
4823: p_data => x_msg_data);
4824:
4825: -- Debug info.

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

4932: EXCEPTION
4933: WHEN fnd_api.g_exc_error THEN
4934: ROLLBACK TO update_bank_site;
4935: x_return_status := fnd_api.g_ret_sts_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.

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

4955:
4956: WHEN fnd_api.g_exc_unexpected_error THEN
4957: ROLLBACK TO update_bank_site;
4958: x_return_status := fnd_api.g_ret_sts_unexp_error;
4959: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4960: p_count => x_msg_count,
4961: p_data => x_msg_data);
4962:
4963: -- Debug info.

Line 4984: fnd_msg_pub.add;

4980: ROLLBACK TO update_bank_site;
4981: x_return_status := fnd_api.g_ret_sts_unexp_error;
4982: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4983: fnd_message.set_token('ERROR',SQLERRM);
4984: fnd_msg_pub.add;
4985: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4986: p_count => x_msg_count,
4987: p_data => x_msg_data);
4988:

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

4981: x_return_status := fnd_api.g_ret_sts_unexp_error;
4982: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4983: fnd_message.set_token('ERROR',SQLERRM);
4984: fnd_msg_pub.add;
4985: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4986: p_count => x_msg_count,
4987: p_data => x_msg_data);
4988:
4989: -- Debug info.

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

5104: EXCEPTION
5105: WHEN fnd_api.g_exc_error THEN
5106: ROLLBACK TO create_edi_contact_point;
5107: x_return_status := fnd_api.g_ret_sts_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.

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

5127:
5128: WHEN fnd_api.g_exc_unexpected_error THEN
5129: ROLLBACK TO create_edi_contact_point;
5130: x_return_status := fnd_api.g_ret_sts_unexp_error;
5131: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5132: p_count => x_msg_count,
5133: p_data => x_msg_data);
5134:
5135: -- Debug info.

Line 5156: fnd_msg_pub.add;

5152: ROLLBACK TO create_edi_contact_point;
5153: x_return_status := fnd_api.g_ret_sts_unexp_error;
5154: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5155: fnd_message.set_token('ERROR',SQLERRM);
5156: fnd_msg_pub.add;
5157: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5158: p_count => x_msg_count,
5159: p_data => x_msg_data);
5160:

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

5153: x_return_status := fnd_api.g_ret_sts_unexp_error;
5154: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5155: fnd_message.set_token('ERROR',SQLERRM);
5156: fnd_msg_pub.add;
5157: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5158: p_count => x_msg_count,
5159: p_data => x_msg_data);
5160:
5161: -- Debug info.

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

5276: EXCEPTION
5277: WHEN fnd_api.g_exc_error THEN
5278: ROLLBACK TO update_edi_contact_point;
5279: x_return_status := fnd_api.g_ret_sts_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.

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

5299:
5300: WHEN fnd_api.g_exc_unexpected_error THEN
5301: ROLLBACK TO update_edi_contact_point;
5302: x_return_status := fnd_api.g_ret_sts_unexp_error;
5303: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5304: p_count => x_msg_count,
5305: p_data => x_msg_data);
5306:
5307: -- Debug info.

Line 5328: fnd_msg_pub.add;

5324: ROLLBACK TO update_edi_contact_point;
5325: x_return_status := fnd_api.g_ret_sts_unexp_error;
5326: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5327: fnd_message.set_token('ERROR',SQLERRM);
5328: fnd_msg_pub.add;
5329: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5330: p_count => x_msg_count,
5331: p_data => x_msg_data);
5332:

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

5325: x_return_status := fnd_api.g_ret_sts_unexp_error;
5326: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5327: fnd_message.set_token('ERROR',SQLERRM);
5328: fnd_msg_pub.add;
5329: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5330: p_count => x_msg_count,
5331: p_data => x_msg_data);
5332:
5333: -- Debug info.

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

5448: EXCEPTION
5449: WHEN fnd_api.g_exc_error THEN
5450: ROLLBACK TO create_eft_contact_point;
5451: x_return_status := fnd_api.g_ret_sts_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.

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

5471:
5472: WHEN fnd_api.g_exc_unexpected_error THEN
5473: ROLLBACK TO create_eft_contact_point;
5474: x_return_status := fnd_api.g_ret_sts_unexp_error;
5475: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5476: p_count => x_msg_count,
5477: p_data => x_msg_data);
5478:
5479: -- Debug info.

Line 5500: fnd_msg_pub.add;

5496: ROLLBACK TO create_eft_contact_point;
5497: x_return_status := fnd_api.g_ret_sts_unexp_error;
5498: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5499: fnd_message.set_token('ERROR',SQLERRM);
5500: fnd_msg_pub.add;
5501: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5502: p_count => x_msg_count,
5503: p_data => x_msg_data);
5504:

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

5497: x_return_status := fnd_api.g_ret_sts_unexp_error;
5498: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5499: fnd_message.set_token('ERROR',SQLERRM);
5500: fnd_msg_pub.add;
5501: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5502: p_count => x_msg_count,
5503: p_data => x_msg_data);
5504:
5505: -- Debug info.

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

5620: EXCEPTION
5621: WHEN fnd_api.g_exc_error THEN
5622: ROLLBACK TO update_eft_contact_point;
5623: x_return_status := fnd_api.g_ret_sts_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.

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

5643:
5644: WHEN fnd_api.g_exc_unexpected_error THEN
5645: ROLLBACK TO update_eft_contact_point;
5646: x_return_status := fnd_api.g_ret_sts_unexp_error;
5647: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5648: p_count => x_msg_count,
5649: p_data => x_msg_data);
5650:
5651: -- Debug info.

Line 5672: fnd_msg_pub.add;

5668: ROLLBACK TO update_eft_contact_point;
5669: x_return_status := fnd_api.g_ret_sts_unexp_error;
5670: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5671: fnd_message.set_token('ERROR',SQLERRM);
5672: fnd_msg_pub.add;
5673: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5674: p_count => x_msg_count,
5675: p_data => x_msg_data);
5676:

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

5669: x_return_status := fnd_api.g_ret_sts_unexp_error;
5670: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5671: fnd_message.set_token('ERROR',SQLERRM);
5672: fnd_msg_pub.add;
5673: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5674: p_count => x_msg_count,
5675: p_data => x_msg_data);
5676:
5677: -- Debug info.

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

5792: EXCEPTION
5793: WHEN fnd_api.g_exc_error THEN
5794: ROLLBACK TO create_web_contact_point;
5795: x_return_status := fnd_api.g_ret_sts_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.

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

5815:
5816: WHEN fnd_api.g_exc_unexpected_error THEN
5817: ROLLBACK TO create_web_contact_point;
5818: x_return_status := fnd_api.g_ret_sts_unexp_error;
5819: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5820: p_count => x_msg_count,
5821: p_data => x_msg_data);
5822:
5823: -- Debug info.

Line 5844: fnd_msg_pub.add;

5840: ROLLBACK TO create_web_contact_point;
5841: x_return_status := fnd_api.g_ret_sts_unexp_error;
5842: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5843: fnd_message.set_token('ERROR',SQLERRM);
5844: fnd_msg_pub.add;
5845: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5846: p_count => x_msg_count,
5847: p_data => x_msg_data);
5848:

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

5841: x_return_status := fnd_api.g_ret_sts_unexp_error;
5842: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5843: fnd_message.set_token('ERROR',SQLERRM);
5844: fnd_msg_pub.add;
5845: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5846: p_count => x_msg_count,
5847: p_data => x_msg_data);
5848:
5849: -- Debug info.

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

5964: EXCEPTION
5965: WHEN fnd_api.g_exc_error THEN
5966: ROLLBACK TO update_web_contact_point;
5967: x_return_status := fnd_api.g_ret_sts_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.

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

5987:
5988: WHEN fnd_api.g_exc_unexpected_error THEN
5989: ROLLBACK TO update_web_contact_point;
5990: x_return_status := fnd_api.g_ret_sts_unexp_error;
5991: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5992: p_count => x_msg_count,
5993: p_data => x_msg_data);
5994:
5995: -- Debug info.

Line 6016: fnd_msg_pub.add;

6012: ROLLBACK TO update_web_contact_point;
6013: x_return_status := fnd_api.g_ret_sts_unexp_error;
6014: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6015: fnd_message.set_token('ERROR',SQLERRM);
6016: fnd_msg_pub.add;
6017: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6018: p_count => x_msg_count,
6019: p_data => x_msg_data);
6020:

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

6013: x_return_status := fnd_api.g_ret_sts_unexp_error;
6014: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6015: fnd_message.set_token('ERROR',SQLERRM);
6016: fnd_msg_pub.add;
6017: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6018: p_count => x_msg_count,
6019: p_data => x_msg_data);
6020:
6021: -- Debug info.

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

6136: EXCEPTION
6137: WHEN fnd_api.g_exc_error THEN
6138: ROLLBACK TO create_phone_contact_point;
6139: x_return_status := fnd_api.g_ret_sts_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.

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

6159:
6160: WHEN fnd_api.g_exc_unexpected_error THEN
6161: ROLLBACK TO create_phone_contact_point;
6162: x_return_status := fnd_api.g_ret_sts_unexp_error;
6163: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6164: p_count => x_msg_count,
6165: p_data => x_msg_data);
6166:
6167: -- Debug info.

Line 6188: fnd_msg_pub.add;

6184: ROLLBACK TO create_phone_contact_point;
6185: x_return_status := fnd_api.g_ret_sts_unexp_error;
6186: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6187: fnd_message.set_token('ERROR',SQLERRM);
6188: fnd_msg_pub.add;
6189: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6190: p_count => x_msg_count,
6191: p_data => x_msg_data);
6192:

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

6185: x_return_status := fnd_api.g_ret_sts_unexp_error;
6186: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6187: fnd_message.set_token('ERROR',SQLERRM);
6188: fnd_msg_pub.add;
6189: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6190: p_count => x_msg_count,
6191: p_data => x_msg_data);
6192:
6193: -- Debug info.

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

6308: EXCEPTION
6309: WHEN fnd_api.g_exc_error THEN
6310: ROLLBACK TO update_phone_contact_point;
6311: x_return_status := fnd_api.g_ret_sts_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.

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

6331:
6332: WHEN fnd_api.g_exc_unexpected_error THEN
6333: ROLLBACK TO update_phone_contact_point;
6334: x_return_status := fnd_api.g_ret_sts_unexp_error;
6335: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6336: p_count => x_msg_count,
6337: p_data => x_msg_data);
6338:
6339: -- Debug info.

Line 6360: fnd_msg_pub.add;

6356: ROLLBACK TO update_phone_contact_point;
6357: x_return_status := fnd_api.g_ret_sts_unexp_error;
6358: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6359: fnd_message.set_token('ERROR',SQLERRM);
6360: fnd_msg_pub.add;
6361: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6362: p_count => x_msg_count,
6363: p_data => x_msg_data);
6364:

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

6357: x_return_status := fnd_api.g_ret_sts_unexp_error;
6358: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6359: fnd_message.set_token('ERROR',SQLERRM);
6360: fnd_msg_pub.add;
6361: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6362: p_count => x_msg_count,
6363: p_data => x_msg_data);
6364:
6365: -- Debug info.

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

6480: EXCEPTION
6481: WHEN fnd_api.g_exc_error THEN
6482: ROLLBACK TO create_email_contact_point;
6483: x_return_status := fnd_api.g_ret_sts_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.

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

6503:
6504: WHEN fnd_api.g_exc_unexpected_error THEN
6505: ROLLBACK TO create_email_contact_point;
6506: x_return_status := fnd_api.g_ret_sts_unexp_error;
6507: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6508: p_count => x_msg_count,
6509: p_data => x_msg_data);
6510:
6511: -- Debug info.

Line 6532: fnd_msg_pub.add;

6528: ROLLBACK TO create_email_contact_point;
6529: x_return_status := fnd_api.g_ret_sts_unexp_error;
6530: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6531: fnd_message.set_token('ERROR',SQLERRM);
6532: fnd_msg_pub.add;
6533: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6534: p_count => x_msg_count,
6535: p_data => x_msg_data);
6536:

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

6529: x_return_status := fnd_api.g_ret_sts_unexp_error;
6530: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6531: fnd_message.set_token('ERROR',SQLERRM);
6532: fnd_msg_pub.add;
6533: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6534: p_count => x_msg_count,
6535: p_data => x_msg_data);
6536:
6537: -- Debug info.

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

6652: EXCEPTION
6653: WHEN fnd_api.g_exc_error THEN
6654: ROLLBACK TO update_email_contact_point;
6655: x_return_status := fnd_api.g_ret_sts_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.

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

6675:
6676: WHEN fnd_api.g_exc_unexpected_error THEN
6677: ROLLBACK TO update_email_contact_point;
6678: x_return_status := fnd_api.g_ret_sts_unexp_error;
6679: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6680: p_count => x_msg_count,
6681: p_data => x_msg_data);
6682:
6683: -- Debug info.

Line 6704: fnd_msg_pub.add;

6700: ROLLBACK TO update_email_contact_point;
6701: x_return_status := fnd_api.g_ret_sts_unexp_error;
6702: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6703: fnd_message.set_token('ERROR',SQLERRM);
6704: fnd_msg_pub.add;
6705: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6706: p_count => x_msg_count,
6707: p_data => x_msg_data);
6708:

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

6701: x_return_status := fnd_api.g_ret_sts_unexp_error;
6702: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6703: fnd_message.set_token('ERROR',SQLERRM);
6704: fnd_msg_pub.add;
6705: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6706: p_count => x_msg_count,
6707: p_data => x_msg_data);
6708:
6709: -- Debug info.

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

6824: EXCEPTION
6825: WHEN fnd_api.g_exc_error THEN
6826: ROLLBACK TO create_telex_contact_point;
6827: x_return_status := fnd_api.g_ret_sts_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.

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

6847:
6848: WHEN fnd_api.g_exc_unexpected_error THEN
6849: ROLLBACK TO create_telex_contact_point;
6850: x_return_status := fnd_api.g_ret_sts_unexp_error;
6851: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6852: p_count => x_msg_count,
6853: p_data => x_msg_data);
6854:
6855: -- Debug info.

Line 6876: fnd_msg_pub.add;

6872: ROLLBACK TO create_telex_contact_point;
6873: x_return_status := fnd_api.g_ret_sts_unexp_error;
6874: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6875: fnd_message.set_token('ERROR',SQLERRM);
6876: fnd_msg_pub.add;
6877: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6878: p_count => x_msg_count,
6879: p_data => x_msg_data);
6880:

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

6873: x_return_status := fnd_api.g_ret_sts_unexp_error;
6874: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6875: fnd_message.set_token('ERROR',SQLERRM);
6876: fnd_msg_pub.add;
6877: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6878: p_count => x_msg_count,
6879: p_data => x_msg_data);
6880:
6881: -- Debug info.

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

6997: EXCEPTION
6998: WHEN fnd_api.g_exc_error THEN
6999: ROLLBACK TO update_telex_contact_point;
7000: x_return_status := fnd_api.g_ret_sts_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.

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

7020:
7021: WHEN fnd_api.g_exc_unexpected_error THEN
7022: ROLLBACK TO update_telex_contact_point;
7023: x_return_status := fnd_api.g_ret_sts_unexp_error;
7024: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
7025: p_count => x_msg_count,
7026: p_data => x_msg_data);
7027:
7028: -- Debug info.

Line 7049: fnd_msg_pub.add;

7045: ROLLBACK TO update_telex_contact_point;
7046: x_return_status := fnd_api.g_ret_sts_unexp_error;
7047: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7048: fnd_message.set_token('ERROR',SQLERRM);
7049: fnd_msg_pub.add;
7050: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
7051: p_count => x_msg_count,
7052: p_data => x_msg_data);
7053:

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

7046: x_return_status := fnd_api.g_ret_sts_unexp_error;
7047: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7048: fnd_message.set_token('ERROR',SQLERRM);
7049: fnd_msg_pub.add;
7050: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
7051: p_count => x_msg_count,
7052: p_data => x_msg_data);
7053:
7054: -- Debug info.

Line 7130: fnd_msg_pub.initialize;

7126: -- initialize message list if p_init_msg_list is set to TRUE.
7127: IF p_init_msg_list IS NOT NULL AND
7128: fnd_api.To_Boolean(p_init_msg_list)
7129: THEN
7130: fnd_msg_pub.initialize;
7131: END IF;
7132:
7133: -- initialize API return status to success.
7134: x_return_status := fnd_api.g_ret_sts_success;

Line 7143: fnd_msg_pub.add;

7139: p_mode <> 'U')
7140: THEN
7141: fnd_message.set_name('AR', 'HZ_INVALID_BATCH_PARAM');
7142: fnd_message.set_token('PARAMTER', 'p_mode');
7143: fnd_msg_pub.add;
7144: raise fnd_api.g_exc_error;
7145: END IF;
7146:
7147: l_bank_rec := p_bank_rec;

Line 7163: fnd_msg_pub.Count_And_Get (

7159: raise fnd_api.g_exc_error;
7160: END IF;
7161:
7162: -- standard call to get message count and if count is 1, get message info.
7163: fnd_msg_pub.Count_And_Get (
7164: p_encoded => fnd_api.G_FALSE,
7165: p_count => x_msg_count,
7166: p_data => x_msg_data);
7167:

Line 7190: fnd_msg_pub.Count_And_Get (

7186: EXCEPTION
7187: WHEN fnd_api.G_EXC_ERROR THEN
7188: x_return_status := fnd_api.G_RET_STS_ERROR;
7189:
7190: fnd_msg_pub.Count_And_Get (
7191: p_encoded => fnd_api.G_FALSE,
7192: p_count => x_msg_count,
7193: p_data => x_msg_data
7194: );

Line 7216: fnd_msg_pub.Count_And_Get (

7212: END IF;
7213:
7214: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
7215: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
7216: fnd_msg_pub.Count_And_Get (
7217: p_encoded => fnd_api.G_FALSE,
7218: p_count => x_msg_count,
7219: p_data => x_msg_data
7220: );

Line 7245: fnd_msg_pub.add;

7241: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
7242:
7243: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7244: fnd_message.set_token('ERROR' ,SQLERRM);
7245: fnd_msg_pub.add;
7246:
7247: fnd_msg_pub.Count_And_Get (
7248: p_encoded => fnd_api.G_FALSE,
7249: p_count => x_msg_count,

Line 7247: fnd_msg_pub.Count_And_Get (

7243: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7244: fnd_message.set_token('ERROR' ,SQLERRM);
7245: fnd_msg_pub.add;
7246:
7247: fnd_msg_pub.Count_And_Get (
7248: p_encoded => fnd_api.G_FALSE,
7249: p_count => x_msg_count,
7250: p_data => x_msg_data
7251: );

Line 7333: fnd_msg_pub.initialize;

7329: -- initialize message list if p_init_msg_list is set to TRUE.
7330: IF p_init_msg_list IS NOT NULL AND
7331: fnd_api.To_Boolean(p_init_msg_list)
7332: THEN
7333: fnd_msg_pub.initialize;
7334: END IF;
7335:
7336: -- initialize API return status to success.
7337: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 7346: fnd_msg_pub.add;

7342: p_mode <> 'U')
7343: THEN
7344: fnd_message.set_name('AR', 'HZ_INVALID_BATCH_PARAM');
7345: fnd_message.set_token('PARAMTER', 'p_mode');
7346: fnd_msg_pub.add;
7347: raise fnd_api.g_exc_error;
7348: END IF;
7349:
7350: l_bank_branch_rec := p_bank_branch_rec;

Line 7378: fnd_msg_pub.Count_And_Get (

7374: raise fnd_api.g_exc_error;
7375: END IF;
7376:
7377: -- standard call to get message count and if count is 1, get message info.
7378: fnd_msg_pub.Count_And_Get (
7379: p_encoded => fnd_api.G_FALSE,
7380: p_count => x_msg_count,
7381: p_data => x_msg_data);
7382:

Line 7405: fnd_msg_pub.Count_And_Get (

7401: EXCEPTION
7402: WHEN fnd_api.G_EXC_ERROR THEN
7403: x_return_status := fnd_api.G_RET_STS_ERROR;
7404:
7405: fnd_msg_pub.Count_And_Get (
7406: p_encoded => fnd_api.G_FALSE,
7407: p_count => x_msg_count,
7408: p_data => x_msg_data
7409: );

Line 7431: fnd_msg_pub.Count_And_Get (

7427: END IF;
7428:
7429: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
7430: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
7431: fnd_msg_pub.Count_And_Get (
7432: p_encoded => fnd_api.G_FALSE,
7433: p_count => x_msg_count,
7434: p_data => x_msg_data
7435: );

Line 7460: fnd_msg_pub.add;

7456: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
7457:
7458: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7459: fnd_message.set_token('ERROR' ,SQLERRM);
7460: fnd_msg_pub.add;
7461:
7462: fnd_msg_pub.Count_And_Get (
7463: p_encoded => fnd_api.G_FALSE,
7464: p_count => x_msg_count,

Line 7462: fnd_msg_pub.Count_And_Get (

7458: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7459: fnd_message.set_token('ERROR' ,SQLERRM);
7460: fnd_msg_pub.add;
7461:
7462: fnd_msg_pub.Count_And_Get (
7463: p_encoded => fnd_api.G_FALSE,
7464: p_count => x_msg_count,
7465: p_data => x_msg_data
7466: );