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_API

Line 231: x_return_status := fnd_api.g_ret_sts_error;

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;
235: ELSE

Line 248: x_return_status := fnd_api.g_ret_sts_error;

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;
252: ELSE

Line 274: x_return_status := fnd_api.g_ret_sts_error;

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;
278: ELSE

Line 291: AND NVL(l_parent_country, fnd_api.g_miss_char) <> p_bank_rec.organization_rec.home_country

287: -- country is specified in the bank record or we are in insert mode.
288: --
289: IF (p_mode = g_insert
290: OR p_bank_rec.organization_rec.home_country IS NOT NULL)
291: AND NVL(l_parent_country, fnd_api.g_miss_char) <> p_bank_rec.organization_rec.home_country
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);

Line 297: x_return_status := fnd_api.g_ret_sts_error;

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.
301: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 329: x_return_status := fnd_api.g_ret_sts_error;

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;
333: --

Line 345: x_return_status := fnd_api.g_ret_sts_error;

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
349: -- Debug info.

Line 417: -- x_return_status := fnd_api.g_ret_sts_error;

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
421: -- branch code must be null

Line 425: x_return_status := fnd_api.g_ret_sts_error;

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
429: IF p_bank_rec.institution_type NOT IN ('BANK', 'CLEARINGHOUSE') THEN

Line 434: x_return_status := fnd_api.g_ret_sts_error;

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.
438: l_validation_procedure := 'HZ_BANK_VALIDATION_PROCEDURE';

Line 448: x_return_status := fnd_api.g_ret_sts_error;

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.
452: l_validation_procedure := 'HZ_BANK_BRANCH_VALIDATION_PROCEDURE';

Line 455: RAISE fnd_api.g_exc_error;

451: -- set the validation procedure to be run.
452: l_validation_procedure := 'HZ_BANK_BRANCH_VALIDATION_PROCEDURE';
453: ELSE
454: -- this procedure should not have been called.
455: RAISE fnd_api.g_exc_error;
456: END IF;
457:
458: --
459: -- get the temporary ID to identify the bank record - use the same ID

Line 475: RAISE fnd_api.g_exc_error;

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
479: l_country:=p_bank_rec.organization_rec.home_country;

Line 547: x_return_status := fnd_api.g_ret_sts_error;

543:
544: WHEN OTHERS THEN
545: -- set the error status, don't need to set the error stack because
546: -- the dynamic validation procedure already does so.
547: x_return_status := fnd_api.g_ret_sts_error;
548: END;
549:
550: -- Debug info.
551: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 630: x_return_status := fnd_api.g_ret_sts_error;

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;
634: FETCH c_uniquepsedi INTO l_dummy;

Line 638: x_return_status := fnd_api.g_ret_sts_error;

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;
642: CLOSE c_uniqueptyedi;

Line 670: x_return_status := fnd_api.g_ret_sts_error;

666: END IF;
667: WHEN OTHERS THEN
668: -- set the error status, don't need to set the error stack because
669: -- the dynamic validation procedure already does so.
670: x_return_status := fnd_api.g_ret_sts_error;
671: END;
672:
673: -- Debug info.
674: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 733: x_return_status := fnd_api.g_ret_sts_error;

729: END IF;
730: WHEN OTHERS THEN
731: -- set the error status, don't need to set the error stack because
732: -- the dynamic validation procedure already does so.
733: x_return_status := fnd_api.g_ret_sts_error;
734: END;
735:
736: -- Debug info.
737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 797: x_return_status := fnd_api.g_ret_sts_error;

793:
794: WHEN OTHERS THEN
795: -- set the error status, don't need to set the error stack because
796: -- the dynamic validation procedure already does so.
797: x_return_status := fnd_api.g_ret_sts_error;
798: END;
799:
800: -- Debug info.
801: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 861: x_return_status := fnd_api.g_ret_sts_error;

857:
858: WHEN OTHERS THEN
859: -- set the error status, don't need to set the error stack because
860: -- the dynamic validation procedure already does so.
861: x_return_status := fnd_api.g_ret_sts_error;
862: END;
863:
864: -- Debug info.
865: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 924: x_return_status := fnd_api.g_ret_sts_error;

920: END IF;
921: WHEN OTHERS THEN
922: -- set the error status, don't need to set the error stack because
923: -- the dynamic validation procedure already does so.
924: x_return_status := fnd_api.g_ret_sts_error;
925: END;
926:
927: -- Debug info.
928: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 987: x_return_status := fnd_api.g_ret_sts_error;

983: END IF;
984: WHEN OTHERS THEN
985: -- set the error status, don't need to set the error stack because
986: -- the dynamic validation procedure already does so.
987: x_return_status := fnd_api.g_ret_sts_error;
988: END;
989:
990: -- Debug info.
991: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1029: x_return_status := fnd_api.g_ret_sts_error;

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
1033: hz_dyn_validation.validate_group(

Line 1052: x_return_status := fnd_api.g_ret_sts_error;

1048: END IF;
1049: WHEN OTHERS THEN
1050: -- set the error status, don't need to set the error stack because
1051: -- the dynamic validation procedure already does so.
1052: x_return_status := fnd_api.g_ret_sts_error;
1053: END;
1054:
1055: -- Debug info.
1056: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1093: x_return_status := fnd_api.g_ret_sts_error;

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:
1097: RETURN NVL(l_group_type, 'NULL');

Line 1142: x_return_status := fnd_api.g_ret_sts_error;

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: --
1146: -- Only check this information if we are in insert

Line 1179: x_return_status := fnd_api.g_ret_sts_error;

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.
1183: RETURN;

Line 1208: x_return_status := fnd_api.g_ret_sts_error;

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');
1212: fnd_message.set_token('RECORD', 'banking group relationship type');

Line 1215: x_return_status := fnd_api.g_ret_sts_error;

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:
1219: --

Line 1238: x_return_status := fnd_api.g_ret_sts_error;

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
1242: AND l_class_code NOT IN ('BANK', 'CLEARINGHOUSE')

Line 1248: x_return_status := fnd_api.g_ret_sts_error;

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;
1252:

Line 1277: x_return_status := fnd_api.g_ret_sts_error;

1273: END IF;
1274: WHEN OTHERS THEN
1275: -- set the error status, don't need to set the error stack because
1276: -- the dynamic validation procedure already does so.
1277: x_return_status := fnd_api.g_ret_sts_error;
1278: END;
1279:
1280: -- Debug info.
1281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1327: x_return_status := fnd_api.g_ret_sts_error;

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: --
1331: -- Only check this information if we are in insert mode. The V2 API call

Line 1349: x_return_status := fnd_api.g_ret_sts_error;

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');
1353: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE, BANK');

Line 1356: x_return_status := fnd_api.g_ret_sts_error;

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:
1360: --

Line 1373: x_return_status := fnd_api.g_ret_sts_error;

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');
1377: fnd_message.set_token('INVALIDSUB', l_object_class);

Line 1379: x_return_status := fnd_api.g_ret_sts_error;

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');
1383: fnd_message.set_token('INVALIDSUB', l_object_class);

Line 1385: x_return_status := fnd_api.g_ret_sts_error;

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:
1389: --

Line 1411: x_return_status := fnd_api.g_ret_sts_error;

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');
1415: fnd_message.set_token('RECORD',

Line 1419: x_return_status := fnd_api.g_ret_sts_error;

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;
1423:

Line 1444: x_return_status := fnd_api.g_ret_sts_error;

1440: END IF;
1441: WHEN OTHERS THEN
1442: -- set the error status, don't need to set the error stack because
1443: -- the dynamic validation procedure already does so.
1444: x_return_status := fnd_api.g_ret_sts_error;
1445: END;
1446:
1447: -- Debug info.
1448: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1532: x_return_status := fnd_api.g_ret_sts_error;

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;
1536:

Line 1546: x_return_status := fnd_api.g_ret_sts_error;

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;
1550:

Line 1568: x_return_status := fnd_api.g_ret_sts_error;

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:
1572: OPEN c_sitecountry(l_location_id);

Line 1580: x_return_status := fnd_api.g_ret_sts_error;

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:
1584: IF l_parent_country <> l_site_country THEN

Line 1589: x_return_status := fnd_api.g_ret_sts_error;

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:
1593: --

Line 1607: x_return_status := fnd_api.g_ret_sts_error;

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',
1611: 'BANK, CLEARINGHOUSE, BANK_BRANCH');

Line 1614: x_return_status := fnd_api.g_ret_sts_error;

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;
1618:

Line 1643: x_return_status := fnd_api.g_ret_sts_error;

1639: END IF;
1640: WHEN OTHERS THEN
1641: -- set the error status, don't need to set the error stack because
1642: -- the dynamic validation procedure already does so.
1643: x_return_status := fnd_api.g_ret_sts_error;
1644: END;
1645:
1646: -- Debug info.
1647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2029: x_return_status := fnd_api.g_ret_sts_error;

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
2033: hz_utility_v2pub.debug(p_message=>'update_bank_relationship (-)',

Line 2100: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2096: x_msg_data => x_msg_data
2097: );
2098:
2099: -- finish execution if the relationship creation routine is unsuccessful
2100: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2101: -- Debug info.
2102: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2103: hz_utility_v2pub.debug(p_message=>'update_bank_relationship (-)',
2104: p_prefix=>l_debug_prefix,

Line 2195: p_init_msg_list => fnd_api.g_false,

2191: l_code_assignment_rec.application_id := p_application_id;
2192: l_code_assignment_rec.end_date_active := p_end_date_active;
2193:
2194: hz_classification_v2pub.create_code_assignment(
2195: p_init_msg_list => fnd_api.g_false,
2196: p_code_assignment_rec => l_code_assignment_rec,
2197: x_return_status => x_return_status,
2198: x_msg_count => x_msg_count,
2199: x_msg_data => x_msg_data,

Line 2203: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2199: x_msg_data => x_msg_data,
2200: x_code_assignment_id => x_code_assignment_id
2201: );
2202: -- raise an exception if the code assignment creation is unsuccessful
2203: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2204: RAISE fnd_api.g_exc_error;
2205: END IF;
2206: -- Debug info.
2207: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2204: RAISE fnd_api.g_exc_error;

2200: x_code_assignment_id => x_code_assignment_id
2201: );
2202: -- raise an exception if the code assignment creation is unsuccessful
2203: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2204: RAISE fnd_api.g_exc_error;
2205: END IF;
2206: -- Debug info.
2207: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2208: hz_utility_v2pub.debug(p_message=>'create_code_assignment (-)',

Line 2300: p_init_msg_list => fnd_api.g_false,

2296: l_code_assignment_rec.code_assignment_id := l_code_assignment_id;
2297: l_code_assignment_rec.end_date_active := p_end_date_active;
2298:
2299: hz_classification_v2pub.update_code_assignment(
2300: p_init_msg_list => fnd_api.g_false,
2301: p_code_assignment_rec => l_code_assignment_rec,
2302: p_object_version_number => p_object_version_number,
2303: x_return_status => x_return_status,
2304: x_msg_count => x_msg_count,

Line 2309: p_bank_organization_type <> fnd_api.g_miss_char

2305: x_msg_data => x_msg_data
2306: );
2307:
2308: ELSIF p_bank_organization_type IS NOT NULL AND
2309: p_bank_organization_type <> fnd_api.g_miss_char
2310: THEN
2311: -- inactivate the existing active assignment
2312: IF p_end_date_active IS NOT NULL AND
2313: p_end_date_active > SYSDATE OR

Line 2315: p_end_date_active = fnd_api.g_miss_date

2311: -- inactivate the existing active assignment
2312: IF p_end_date_active IS NOT NULL AND
2313: p_end_date_active > SYSDATE OR
2314: p_end_date_active IS NULL OR
2315: p_end_date_active = fnd_api.g_miss_date
2316: THEN
2317: OPEN c_assignid;
2318: FETCH c_assignid INTO
2319: l_code_assignment_id, p_object_version_number;

Line 2328: p_init_msg_list => fnd_api.g_false,

2324: l_code_assignment_rec.end_date_active := sysdate-10/(24*60*60);
2325: l_code_assignment_rec.primary_flag := 'N';
2326:
2327: hz_classification_v2pub.update_code_assignment(
2328: p_init_msg_list => fnd_api.g_false,
2329: p_code_assignment_rec => l_code_assignment_rec,
2330: p_object_version_number => p_object_version_number,
2331: x_return_status => x_return_status,
2332: x_msg_count => x_msg_count,

Line 2357: p_init_msg_list => fnd_api.g_false,

2353: l_code_assignment_rec.application_id := p_application_id;
2354: l_code_assignment_rec.end_date_active := p_end_date_active;
2355:
2356: hz_classification_v2pub.create_code_assignment(
2357: p_init_msg_list => fnd_api.g_false,
2358: p_code_assignment_rec => l_code_assignment_rec,
2359: x_return_status => x_return_status,
2360: x_msg_count => x_msg_count,
2361: x_msg_data => x_msg_data,

Line 2372: p_init_msg_list => fnd_api.g_false,

2368: l_code_assignment_rec.end_date_active := p_end_date_active;
2369: l_code_assignment_rec.primary_flag := 'Y';
2370:
2371: hz_classification_v2pub.update_code_assignment(
2372: p_init_msg_list => fnd_api.g_false,
2373: p_code_assignment_rec => l_code_assignment_rec,
2374: p_object_version_number => p_object_version_number,
2375: x_return_status => x_return_status,
2376: x_msg_count => x_msg_count,

Line 2423: p_end_date_active <> FND_API.G_MISS_DATE

2419: l_party_usg_assignment_rec.effective_end_date := p_end_date_active;
2420:
2421: IF p_end_date_active IS NOT NULL AND
2422: trunc(p_end_date_active) < trunc(sysdate) AND
2423: p_end_date_active <> FND_API.G_MISS_DATE
2424: THEN
2425: l_party_usg_assignment_rec.effective_start_date := p_end_date_active;
2426: END IF;
2427:

Line 2495: IF p_end_date_active <> fnd_api.g_miss_date AND

2491: OPEN c_party_usage_date(l_class_code);
2492: FETCH c_party_usage_date INTO l_assignment_id, l_end_date_active;
2493: CLOSE c_party_usage_date;
2494:
2495: IF p_end_date_active <> fnd_api.g_miss_date AND
2496: l_end_date_active = TO_DATE('4712/12/31','YYYY/MM/DD') OR
2497: p_end_date_active = fnd_api.g_miss_date AND
2498: l_end_date_active <> TO_DATE('4712/12/31','YYYY/MM/DD') OR
2499: trunc(p_end_date_active) <> l_end_date_active

Line 2497: p_end_date_active = fnd_api.g_miss_date AND

2493: CLOSE c_party_usage_date;
2494:
2495: IF p_end_date_active <> fnd_api.g_miss_date AND
2496: l_end_date_active = TO_DATE('4712/12/31','YYYY/MM/DD') OR
2497: p_end_date_active = fnd_api.g_miss_date AND
2498: l_end_date_active <> TO_DATE('4712/12/31','YYYY/MM/DD') OR
2499: trunc(p_end_date_active) <> l_end_date_active
2500: THEN
2501: l_party_usg_assignment_rec.party_id := p_party_id;

Line 2532: | FND_API.G_TRUE. Default is fnd_api.g_false. |

2528: | |
2529: | ARGUMENTS |
2530: | IN: |
2531: | p_init_msg_list Initialize message stack if it is set to |
2532: | FND_API.G_TRUE. Default is fnd_api.g_false. |
2533: | p_bank_rec Bank record. |
2534: | IN/OUT: |
2535: | OUT: |
2536: | x_party_id Party ID for the bank. |

Line 2542: | be FND_API.G_RET_STS_SUCCESS (success), |

2538: | x_profile_id Organization profile ID for the bank. |
2539: | x_code_assignment_id The code assignment ID for the bank |
2540: | classification. |
2541: | x_return_status Return status after the call. The status can |
2542: | be FND_API.G_RET_STS_SUCCESS (success), |
2543: | fnd_api.g_ret_sts_error (error), |
2544: | fnd_api.g_ret_sts_unexp_error (unexpected |
2545: | error). |
2546: | x_msg_count Number of messages in message stack. |

Line 2543: | fnd_api.g_ret_sts_error (error), |

2539: | x_code_assignment_id The code assignment ID for the bank |
2540: | classification. |
2541: | x_return_status Return status after the call. The status can |
2542: | be FND_API.G_RET_STS_SUCCESS (success), |
2543: | fnd_api.g_ret_sts_error (error), |
2544: | fnd_api.g_ret_sts_unexp_error (unexpected |
2545: | error). |
2546: | x_msg_count Number of messages in message stack. |
2547: | x_msg_data Message text if x_msg_count is 1. |

Line 2544: | fnd_api.g_ret_sts_unexp_error (unexpected |

2540: | classification. |
2541: | x_return_status Return status after the call. The status can |
2542: | be FND_API.G_RET_STS_SUCCESS (success), |
2543: | fnd_api.g_ret_sts_error (error), |
2544: | fnd_api.g_ret_sts_unexp_error (unexpected |
2545: | error). |
2546: | x_msg_count Number of messages in message stack. |
2547: | x_msg_data Message text if x_msg_count is 1. |
2548: | MODIFICATION HISTORY |

Line 2553: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,

2549: | 27-NOV-2001 J. del Callar Created. |
2550: | 23-JAN-2004 Rajesh Jose Modified for Bug 3397488 |
2551: +=======================================================================*/
2552: PROCEDURE create_bank (
2553: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
2554: p_bank_rec IN bank_rec_type,
2555: x_party_id OUT NOCOPY NUMBER,
2556: x_party_number OUT NOCOPY VARCHAR2,
2557: x_profile_id OUT NOCOPY NUMBER,

Line 2580: IF fnd_api.to_boolean(p_init_msg_list) THEN

2576: p_msg_level=>fnd_log.level_procedure);
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.

Line 2585: x_return_status := fnd_api.g_ret_sts_success;

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;
2586:
2587: --
2588: -- execute business logic
2589: --

Line 2597: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2593:
2594: validate_bank_org(l_bank_rec, 'BANK', g_insert, x_return_status);
2595:
2596: -- raise an exception if the validation routine is unsuccessful
2597: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2598: RAISE fnd_api.g_exc_error;
2599: END IF;
2600:
2601: -- Retrieving the party_id that we are using to create the bank record.

Line 2598: RAISE fnd_api.g_exc_error;

2594: validate_bank_org(l_bank_rec, 'BANK', g_insert, x_return_status);
2595:
2596: -- raise an exception if the validation routine is unsuccessful
2597: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2598: RAISE fnd_api.g_exc_error;
2599: END IF;
2600:
2601: -- Retrieving the party_id that we are using to create the bank record.
2602: select temp_id into l_bank_rec.organization_rec.party_rec.party_id

Line 2617: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2613: x_profile_id => x_profile_id
2614: );
2615:
2616: -- raise an exception if the organization profile creation is unsuccessful
2617: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2618: RAISE fnd_api.g_exc_error;
2619: END IF;
2620:
2621: -- update the bank-specific organization attributes

Line 2618: RAISE fnd_api.g_exc_error;

2614: );
2615:
2616: -- raise an exception if the organization profile creation is unsuccessful
2617: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2618: RAISE fnd_api.g_exc_error;
2619: END IF;
2620:
2621: -- update the bank-specific organization attributes
2622: update_bank_organization(x_profile_id,

Line 2640: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2636: x_msg_count,
2637: x_msg_data);
2638:
2639: -- raise an exception if the code assignment creation is unsuccessful
2640: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2641: RAISE fnd_api.g_exc_error;
2642: END IF;
2643:
2644: --

Line 2641: RAISE fnd_api.g_exc_error;

2637: x_msg_data);
2638:
2639: -- raise an exception if the code assignment creation is unsuccessful
2640: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2641: RAISE fnd_api.g_exc_error;
2642: END IF;
2643:
2644: --
2645: -- added for R12 party usage project.

Line 2656: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2652: x_return_status => x_return_status
2653: );
2654:
2655: -- raise an exception if the usage assignment creation is unsuccessful
2656: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2657: RAISE fnd_api.g_exc_error;
2658: END IF;
2659: END IF;
2660:

Line 2657: RAISE fnd_api.g_exc_error;

2653: );
2654:
2655: -- raise an exception if the usage assignment creation is unsuccessful
2656: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2657: RAISE fnd_api.g_exc_error;
2658: END IF;
2659: END IF;
2660:
2661: -- standard call to get message count and if count is 1, get message info.

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 2683: WHEN fnd_api.g_exc_error THEN

2679: -- Check if API is called in debug mode. If yes, disable debug.
2680: --disable_debug;
2681:
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,

Line 2685: x_return_status := fnd_api.g_ret_sts_error;

2681:
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:

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 2706: WHEN fnd_api.g_exc_unexpected_error THEN

2702:
2703: -- Check if API is called in debug mode. If yes, disable debug.
2704: --disable_debug;
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,

Line 2708: x_return_status := fnd_api.g_ret_sts_unexp_error;

2704: --disable_debug;
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:

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 2732: x_return_status := fnd_api.g_ret_sts_unexp_error;

2728: --disable_debug;
2729:
2730: WHEN OTHERS THEN
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,

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 2772: | set to FND_API.G_TRUE. Default is |

2768: | |
2769: | ARGUMENTS |
2770: | IN: |
2771: | p_init_msg_list Initialize message stack if it is |
2772: | set to FND_API.G_TRUE. Default is |
2773: | fnd_api.g_false. |
2774: | p_bank_rec Bank record. |
2775: | IN/OUT: |
2776: | x_pobject_version_number New version number for the bank. |

Line 2773: | fnd_api.g_false. |

2769: | ARGUMENTS |
2770: | IN: |
2771: | p_init_msg_list Initialize message stack if it is |
2772: | set to FND_API.G_TRUE. Default is |
2773: | fnd_api.g_false. |
2774: | p_bank_rec Bank record. |
2775: | IN/OUT: |
2776: | x_pobject_version_number New version number for the bank. |
2777: | x_bitobject_version_number New version number for the code |

Line 2784: | FND_API.G_RET_STS_SUCCESS |

2780: | x_profile_id New organization profile ID for |
2781: | the updated bank. |
2782: | x_return_status Return status after the call. The |
2783: | status can be |
2784: | FND_API.G_RET_STS_SUCCESS |
2785: | (success), fnd_api.g_ret_sts_error |
2786: | (error), |
2787: | fnd_api.g_ret_sts_unexp_error |
2788: | (unexpected error). |

Line 2785: | (success), fnd_api.g_ret_sts_error |

2781: | the updated bank. |
2782: | x_return_status Return status after the call. The |
2783: | status can be |
2784: | FND_API.G_RET_STS_SUCCESS |
2785: | (success), fnd_api.g_ret_sts_error |
2786: | (error), |
2787: | fnd_api.g_ret_sts_unexp_error |
2788: | (unexpected error). |
2789: | x_msg_count Number of messages in message |

Line 2787: | fnd_api.g_ret_sts_unexp_error |

2783: | status can be |
2784: | FND_API.G_RET_STS_SUCCESS |
2785: | (success), fnd_api.g_ret_sts_error |
2786: | (error), |
2787: | fnd_api.g_ret_sts_unexp_error |
2788: | (unexpected error). |
2789: | x_msg_count Number of messages in message |
2790: | stack. |
2791: | x_msg_data Message text if x_msg_count is 1. |

Line 2802: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,

2798: | update_bank and update_bank_branch|
2799: | APIs. |
2800: +=======================================================================*/
2801: PROCEDURE update_bank (
2802: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
2803: p_bank_rec IN bank_rec_type,
2804: p_pobject_version_number IN OUT NOCOPY NUMBER,
2805: p_bitobject_version_number IN OUT NOCOPY NUMBER,
2806: x_profile_id OUT NOCOPY NUMBER,

Line 2830: IF fnd_api.to_boolean(p_init_msg_list) THEN

2826: p_msg_level=>fnd_log.level_procedure);
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.

Line 2835: x_return_status := fnd_api.g_ret_sts_success;

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;
2836:
2837: l_bank_rec := p_bank_rec;
2838: l_bank_rec.organization_rec.home_country := l_bank_rec.country;
2839:

Line 2847: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2843:
2844: validate_bank_org(l_bank_rec, 'BANK', g_update, x_return_status);
2845:
2846: -- raise an exception if the validation routine is unsuccessful
2847: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2848: RAISE fnd_api.g_exc_error;
2849: END IF;
2850:
2851: -- update the organization profile.

Line 2848: RAISE fnd_api.g_exc_error;

2844: validate_bank_org(l_bank_rec, 'BANK', g_update, x_return_status);
2845:
2846: -- raise an exception if the validation routine is unsuccessful
2847: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2848: RAISE fnd_api.g_exc_error;
2849: END IF;
2850:
2851: -- update the organization profile.
2852: hz_party_v2pub.update_organization(

Line 2862: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2858: x_msg_data => x_msg_data
2859: );
2860:
2861: -- raise an exception if the organization profile creation is unsuccessful
2862: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2863: RAISE fnd_api.g_exc_error;
2864: END IF;
2865:
2866: -- update the bank-specific organization attributes

Line 2863: RAISE fnd_api.g_exc_error;

2859: );
2860:
2861: -- raise an exception if the organization profile creation is unsuccessful
2862: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2863: RAISE fnd_api.g_exc_error;
2864: END IF;
2865:
2866: -- update the bank-specific organization attributes
2867: update_bank_organization(x_profile_id,

Line 2887: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2883: x_msg_count,
2884: x_msg_data);
2885:
2886: -- raise an exception if the code assignment creation is unsuccessful
2887: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2888: RAISE fnd_api.g_exc_error;
2889: END IF;
2890: --END IF;
2891:

Line 2888: RAISE fnd_api.g_exc_error;

2884: x_msg_data);
2885:
2886: -- raise an exception if the code assignment creation is unsuccessful
2887: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2888: RAISE fnd_api.g_exc_error;
2889: END IF;
2890: --END IF;
2891:
2892: --

Line 2902: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2898: p_end_date_active => l_bank_rec.inactive_date,
2899: x_return_status => x_return_status
2900: );
2901:
2902: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2903: RAISE fnd_api.g_exc_error;
2904: END IF;
2905: END IF;
2906:

Line 2903: RAISE fnd_api.g_exc_error;

2899: x_return_status => x_return_status
2900: );
2901:
2902: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2903: RAISE fnd_api.g_exc_error;
2904: END IF;
2905: END IF;
2906:
2907: -- standard call to get message count and if count is 1, get message info.

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 2929: WHEN fnd_api.g_exc_error THEN

2925: -- Check if API is called in debug mode. If yes, disable debug.
2926: --disable_debug;
2927:
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,

Line 2931: x_return_status := fnd_api.g_ret_sts_error;

2927:
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:

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 2952: WHEN fnd_api.g_exc_unexpected_error THEN

2948:
2949: -- Check if API is called in debug mode. If yes, disable debug.
2950: --disable_debug;
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,

Line 2954: x_return_status := fnd_api.g_ret_sts_unexp_error;

2950: --disable_debug;
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:

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 2977: x_return_status := fnd_api.g_ret_sts_unexp_error;

2973: --disable_debug;
2974:
2975: WHEN OTHERS THEN
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,

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 3015: | FND_API.G_TRUE. Default is fnd_api.g_false. |

3011: | |
3012: | ARGUMENTS |
3013: | IN: |
3014: | p_init_msg_list Initialize message stack if it is set to |
3015: | FND_API.G_TRUE. Default is fnd_api.g_false. |
3016: | p_bank_rec Bank record. |
3017: | p_bank_party_id Party ID of the parent bank. NULL if the |
3018: | parent bank is not going to be reassigned. |
3019: | IN/OUT: |

Line 3035: | be FND_API.G_RET_STS_SUCCESS (success), |

3031: | bank branch. |
3032: | x_rfccode_assignment_id The code assignment ID for the Regional |
3033: | Finance Center used by the bank branch. |
3034: | x_return_status Return status after the call. The status can |
3035: | be FND_API.G_RET_STS_SUCCESS (success), |
3036: | fnd_api.g_ret_sts_error (error), |
3037: | fnd_api.g_ret_sts_unexp_error (unexpected |
3038: | error). |
3039: | x_msg_count Number of messages in message stack. |

Line 3036: | fnd_api.g_ret_sts_error (error), |

3032: | x_rfccode_assignment_id The code assignment ID for the Regional |
3033: | Finance Center used by the bank branch. |
3034: | x_return_status Return status after the call. The status can |
3035: | be FND_API.G_RET_STS_SUCCESS (success), |
3036: | fnd_api.g_ret_sts_error (error), |
3037: | fnd_api.g_ret_sts_unexp_error (unexpected |
3038: | error). |
3039: | x_msg_count Number of messages in message stack. |
3040: | x_msg_data Message text if x_msg_count is 1. |

Line 3037: | fnd_api.g_ret_sts_unexp_error (unexpected |

3033: | Finance Center used by the bank branch. |
3034: | x_return_status Return status after the call. The status can |
3035: | be FND_API.G_RET_STS_SUCCESS (success), |
3036: | fnd_api.g_ret_sts_error (error), |
3037: | fnd_api.g_ret_sts_unexp_error (unexpected |
3038: | error). |
3039: | x_msg_count Number of messages in message stack. |
3040: | x_msg_data Message text if x_msg_count is 1. |
3041: | MODIFICATION HISTORY |

Line 3047: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,

3043: | 06-MAY-2002 J. del Callar Added support for RFCs. |
3044: | 23-JAN-2004 Rajesh Jose Modified for Bug 3397488 |
3045: +=======================================================================*/
3046: PROCEDURE create_bank_branch (
3047: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
3048: p_bank_rec IN bank_rec_type,
3049: p_bank_party_id IN NUMBER,
3050: x_party_id OUT NOCOPY NUMBER,
3051: x_party_number OUT NOCOPY VARCHAR2,

Line 3080: IF fnd_api.to_boolean(p_init_msg_list) THEN

3076: p_msg_level=>fnd_log.level_procedure);
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.

Line 3085: x_return_status := fnd_api.g_ret_sts_success;

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;
3086:
3087: --
3088: -- execute business logic
3089: --

Line 3104: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3100: -- validate the bank branch and its type.
3101: validate_bank_org(l_bank_rec, 'BRANCH', g_insert, x_return_status);
3102:
3103: -- raise an exception if the validation routine is unsuccessful
3104: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3105: RAISE fnd_api.g_exc_error;
3106: END IF;
3107:
3108: -- Retrieving the party_id that we are using to create the bank record.

Line 3105: RAISE fnd_api.g_exc_error;

3101: validate_bank_org(l_bank_rec, 'BRANCH', g_insert, x_return_status);
3102:
3103: -- raise an exception if the validation routine is unsuccessful
3104: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3105: RAISE fnd_api.g_exc_error;
3106: END IF;
3107:
3108: -- Retrieving the party_id that we are using to create the bank record.
3109:

Line 3125: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3121: x_profile_id => x_profile_id
3122: );
3123:
3124: -- raise an exception if the organization profile creation is unsuccessful
3125: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3126: RAISE fnd_api.g_exc_error;
3127: END IF;
3128:
3129: -- update the bank-specific organization attributes

Line 3126: RAISE fnd_api.g_exc_error;

3122: );
3123:
3124: -- raise an exception if the organization profile creation is unsuccessful
3125: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3126: RAISE fnd_api.g_exc_error;
3127: END IF;
3128:
3129: -- update the bank-specific organization attributes
3130: update_bank_organization(x_profile_id,

Line 3150: AND l_bank_rec.branch_type <> fnd_api.g_miss_char

3146:
3147: --Bug9226202 Instead of Parameter's Inactive Date G_MISS_DATE will be provided
3148: -- create the code assignment for the bank branch's branch type
3149: IF l_bank_rec.branch_type IS NOT NULL
3150: AND l_bank_rec.branch_type <> fnd_api.g_miss_char
3151: THEN
3152: create_code_assignment(x_party_id,
3153: l_bank_rec.branch_type,
3154: 'BANK_BRANCH_TYPE',

Line 3158: FND_API.G_MISS_DATE,

3154: 'BANK_BRANCH_TYPE',
3155: l_bank_rec.organization_rec.created_by_module,
3156: l_bank_rec.organization_rec.application_id,
3157: -- l_bank_rec.inactive_date,
3158: FND_API.G_MISS_DATE,
3159: x_bbtcode_assignment_id,
3160: x_return_status,
3161: x_msg_count,
3162: x_msg_data);

Line 3174: FND_API.G_MISS_DATE,

3170: 'RFC_IDENTIFIER',
3171: l_bank_rec.organization_rec.created_by_module,
3172: l_bank_rec.organization_rec.application_id,
3173: -- l_bank_rec.inactive_date,
3174: FND_API.G_MISS_DATE,
3175: x_rfccode_assignment_id,
3176: x_return_status,
3177: x_msg_count,
3178: x_msg_data);

Line 3182: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3178: x_msg_data);
3179: END IF;
3180:
3181: -- raise an exception if the code assignment creation is unsuccessful
3182: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3183: RAISE fnd_api.g_exc_error;
3184: END IF;
3185:
3186: -- create a relationship between the bank branch and its parent bank

Line 3183: RAISE fnd_api.g_exc_error;

3179: END IF;
3180:
3181: -- raise an exception if the code assignment creation is unsuccessful
3182: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3183: RAISE fnd_api.g_exc_error;
3184: END IF;
3185:
3186: -- create a relationship between the bank branch and its parent bank
3187: create_relationship(

Line 3207: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3203: x_msg_data => x_msg_data
3204: );
3205:
3206: -- raise an exception if the relationship creation is unsuccessful
3207: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3208: RAISE fnd_api.g_exc_error;
3209: END IF;
3210:
3211: --

Line 3208: RAISE fnd_api.g_exc_error;

3204: );
3205:
3206: -- raise an exception if the relationship creation is unsuccessful
3207: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3208: RAISE fnd_api.g_exc_error;
3209: END IF;
3210:
3211: --
3212: -- added for R12 party usage project.

Line 3223: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3219: x_return_status => x_return_status
3220: );
3221:
3222: -- raise an exception if the usage assignment creation is unsuccessful
3223: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3224: RAISE fnd_api.g_exc_error;
3225: END IF;
3226: END IF;
3227:

Line 3224: RAISE fnd_api.g_exc_error;

3220: );
3221:
3222: -- raise an exception if the usage assignment creation is unsuccessful
3223: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3224: RAISE fnd_api.g_exc_error;
3225: END IF;
3226: END IF;
3227:
3228: -- standard call to get message count and if count is 1, get message info.

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 3250: WHEN fnd_api.g_exc_error THEN

3246: -- Check if API is called in debug mode. If yes, disable debug.
3247: --disable_debug;
3248:
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,

Line 3252: x_return_status := fnd_api.g_ret_sts_error;

3248:
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:

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 3273: WHEN fnd_api.g_exc_unexpected_error THEN

3269:
3270: -- Check if API is called in debug mode. If yes, disable debug.
3271: --disable_debug;
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,

Line 3275: x_return_status := fnd_api.g_ret_sts_unexp_error;

3271: --disable_debug;
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:

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 3298: x_return_status := fnd_api.g_ret_sts_unexp_error;

3294: --disable_debug;
3295:
3296: WHEN OTHERS THEN
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,

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 3336: | FND_API.G_TRUE. Default is fnd_api.g_false. |

3332: | |
3333: | ARGUMENTS |
3334: | IN: |
3335: | p_init_msg_list Initialize message stack if it is set to |
3336: | FND_API.G_TRUE. Default is fnd_api.g_false. |
3337: | p_bank_rec Bank record. |
3338: | p_relationship_id ID for relationship between bank branch and |
3339: | its parent bank. NULL if the parent bank is |
3340: | not going to be reassigned. |

Line 3355: | be FND_API.G_RET_STS_SUCCESS (success), |

3351: | x_profile_id Organization profile ID for the bank branch. |
3352: | x_rel_party_id ID for party relationship created. |
3353: | x_rel_party_number Number for the party relationship created. |
3354: | x_return_status Return status after the call. The status can |
3355: | be FND_API.G_RET_STS_SUCCESS (success), |
3356: | fnd_api.g_ret_sts_error (error), |
3357: | fnd_api.g_ret_sts_unexp_error (unexpected |
3358: | error). |
3359: | x_msg_count Number of messages in message stack. |

Line 3356: | fnd_api.g_ret_sts_error (error), |

3352: | x_rel_party_id ID for party relationship created. |
3353: | x_rel_party_number Number for the party relationship created. |
3354: | x_return_status Return status after the call. The status can |
3355: | be FND_API.G_RET_STS_SUCCESS (success), |
3356: | fnd_api.g_ret_sts_error (error), |
3357: | fnd_api.g_ret_sts_unexp_error (unexpected |
3358: | error). |
3359: | x_msg_count Number of messages in message stack. |
3360: | x_msg_data Message text if x_msg_count is 1. |

Line 3357: | fnd_api.g_ret_sts_unexp_error (unexpected |

3353: | x_rel_party_number Number for the party relationship created. |
3354: | x_return_status Return status after the call. The status can |
3355: | be FND_API.G_RET_STS_SUCCESS (success), |
3356: | fnd_api.g_ret_sts_error (error), |
3357: | fnd_api.g_ret_sts_unexp_error (unexpected |
3358: | error). |
3359: | x_msg_count Number of messages in message stack. |
3360: | x_msg_data Message text if x_msg_count is 1. |
3361: | MODIFICATION HISTORY |

Line 3371: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

3367: | update_bank and update_bank_branch|
3368: | APIs. |
3369: +=======================================================================*/
3370: PROCEDURE update_bank_branch (
3371: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3372: p_bank_rec IN bank_rec_type,
3373: p_bank_party_id IN NUMBER := NULL,
3374: p_relationship_id IN OUT NOCOPY NUMBER,
3375: p_pobject_version_number IN OUT NOCOPY NUMBER,

Line 3403: IF fnd_api.to_boolean(p_init_msg_list) THEN

3399: p_msg_level=>fnd_log.level_procedure);
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.

Line 3408: x_return_status := fnd_api.g_ret_sts_success;

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;
3409:
3410: l_bank_rec := p_bank_rec;
3411: l_bank_rec.organization_rec.home_country := l_bank_rec.country;
3412:

Line 3427: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3423: -- validate the bank branch and its type.
3424: validate_bank_org(l_bank_rec, 'BRANCH', g_update, x_return_status);
3425:
3426: -- raise an exception if the validation routine is unsuccessful
3427: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3428: RAISE fnd_api.g_exc_error;
3429: END IF;
3430:
3431: -- update the organization profile.

Line 3428: RAISE fnd_api.g_exc_error;

3424: validate_bank_org(l_bank_rec, 'BRANCH', g_update, x_return_status);
3425:
3426: -- raise an exception if the validation routine is unsuccessful
3427: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3428: RAISE fnd_api.g_exc_error;
3429: END IF;
3430:
3431: -- update the organization profile.
3432: hz_party_v2pub.update_organization(

Line 3442: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3438: x_msg_data => x_msg_data
3439: );
3440:
3441: -- raise an exception if the organization profile update is unsuccessful
3442: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3443: RAISE fnd_api.g_exc_error;
3444: END IF;
3445:
3446: -- update the bank-specific organization attributes

Line 3443: RAISE fnd_api.g_exc_error;

3439: );
3440:
3441: -- raise an exception if the organization profile update is unsuccessful
3442: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3443: RAISE fnd_api.g_exc_error;
3444: END IF;
3445:
3446: -- update the bank-specific organization attributes
3447: update_bank_organization(x_profile_id,

Line 3465: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3461: x_msg_count,
3462: x_msg_data);
3463:
3464: -- raise an exception if the code assignment updation is unsuccessful
3465: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3466: RAISE fnd_api.g_exc_error;
3467: END IF;
3468:
3469:

Line 3466: RAISE fnd_api.g_exc_error;

3462: x_msg_data);
3463:
3464: -- raise an exception if the code assignment updation is unsuccessful
3465: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3466: RAISE fnd_api.g_exc_error;
3467: END IF;
3468:
3469:
3470: -- update the code assignment for the bank branch's branch type if a bank

Line 3480: FND_API.G_MISS_DATE,

3476: 'BANK_BRANCH_TYPE',
3477: l_bank_rec.organization_rec.created_by_module,
3478: l_bank_rec.organization_rec.application_id,
3479: -- l_bank_rec.inactive_date,
3480: FND_API.G_MISS_DATE,
3481: p_bbtobject_version_number,
3482: x_return_status,
3483: x_msg_count,
3484: x_msg_data);

Line 3488: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3484: x_msg_data);
3485: --END IF;
3486:
3487: -- raise an exception if the code assignment updation is unsuccessful
3488: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3489: RAISE fnd_api.g_exc_error;
3490: END IF;
3491:
3492: -- update the code assignment for the bank branch's Regional Finance Center

Line 3489: RAISE fnd_api.g_exc_error;

3485: --END IF;
3486:
3487: -- raise an exception if the code assignment updation is unsuccessful
3488: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3489: RAISE fnd_api.g_exc_error;
3490: END IF;
3491:
3492: -- update the code assignment for the bank branch's Regional Finance Center
3493: -- if an RFC was specified.

Line 3502: FND_API.G_MISS_DATE,

3498: 'RFC_IDENTIFIER',
3499: l_bank_rec.organization_rec.created_by_module,
3500: l_bank_rec.organization_rec.application_id,
3501: -- l_bank_rec.inactive_date,
3502: FND_API.G_MISS_DATE,
3503: p_rfcobject_version_number,
3504: x_return_status,
3505: x_msg_count,
3506: x_msg_data);

Line 3510: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3506: x_msg_data);
3507: --END IF;
3508:
3509: -- raise an exception if the code assignment creation is unsuccessful
3510: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3511: RAISE fnd_api.g_exc_error;
3512: END IF;
3513:
3514: -- update the relationship between the bank branch and its parent bank

Line 3511: RAISE fnd_api.g_exc_error;

3507: --END IF;
3508:
3509: -- raise an exception if the code assignment creation is unsuccessful
3510: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3511: RAISE fnd_api.g_exc_error;
3512: END IF;
3513:
3514: -- update the relationship between the bank branch and its parent bank
3515: -- if the parent bank was specified.

Line 3543: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3539: );
3540: END IF;
3541:
3542: -- raise an exception if the relationship creation is unsuccessful
3543: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3544: RAISE fnd_api.g_exc_error;
3545: END IF;
3546:
3547: --

Line 3544: RAISE fnd_api.g_exc_error;

3540: END IF;
3541:
3542: -- raise an exception if the relationship creation is unsuccessful
3543: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3544: RAISE fnd_api.g_exc_error;
3545: END IF;
3546:
3547: --
3548: -- added for R12 party usage project.

Line 3557: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3553: p_end_date_active => l_bank_rec.inactive_date,
3554: x_return_status => x_return_status
3555: );
3556:
3557: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3558: RAISE fnd_api.g_exc_error;
3559: END IF;
3560: END IF;
3561:

Line 3558: RAISE fnd_api.g_exc_error;

3554: x_return_status => x_return_status
3555: );
3556:
3557: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3558: RAISE fnd_api.g_exc_error;
3559: END IF;
3560: END IF;
3561:
3562: -- standard call to get message count and if count is 1, get message info.

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 3584: WHEN fnd_api.g_exc_error THEN

3580: -- Check if API is called in debug mode. If yes, disable debug.
3581: --disable_debug;
3582:
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,

Line 3586: x_return_status := fnd_api.g_ret_sts_error;

3582:
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:

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 3607: WHEN fnd_api.g_exc_unexpected_error THEN

3603:
3604: -- Check if API is called in debug mode. If yes, disable debug.
3605: --disable_debug;
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,

Line 3609: x_return_status := fnd_api.g_ret_sts_unexp_error;

3605: --disable_debug;
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:

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 3632: x_return_status := fnd_api.g_ret_sts_unexp_error;

3628: --disable_debug;
3629:
3630: WHEN OTHERS THEN
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,

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 3670: | FND_API.G_TRUE. Default is fnd_api.g_false. |

3666: | |
3667: | ARGUMENTS |
3668: | IN: |
3669: | p_init_msg_list Initialize message stack if it is set to |
3670: | FND_API.G_TRUE. Default is fnd_api.g_false. |
3671: | p_group_rec Group record for the banking group. |
3672: | IN/OUT: |
3673: | OUT: |
3674: | x_party_id Party ID for the banking group created. |

Line 3677: | be FND_API.G_RET_STS_SUCCESS (success), |

3673: | OUT: |
3674: | x_party_id Party ID for the banking group created. |
3675: | x_party_number Party number for banking group created. |
3676: | x_return_status Return status after the call. The status can |
3677: | be FND_API.G_RET_STS_SUCCESS (success), |
3678: | fnd_api.g_ret_sts_error (error), |
3679: | fnd_api.g_ret_sts_unexp_error (unexpected |
3680: | error). |
3681: | x_msg_count Number of messages in message stack. |

Line 3678: | fnd_api.g_ret_sts_error (error), |

3674: | x_party_id Party ID for the banking group created. |
3675: | x_party_number Party number for banking group created. |
3676: | x_return_status Return status after the call. The status can |
3677: | be FND_API.G_RET_STS_SUCCESS (success), |
3678: | fnd_api.g_ret_sts_error (error), |
3679: | fnd_api.g_ret_sts_unexp_error (unexpected |
3680: | error). |
3681: | x_msg_count Number of messages in message stack. |
3682: | x_msg_data Message text if x_msg_count is 1. |

Line 3679: | fnd_api.g_ret_sts_unexp_error (unexpected |

3675: | x_party_number Party number for banking group created. |
3676: | x_return_status Return status after the call. The status can |
3677: | be FND_API.G_RET_STS_SUCCESS (success), |
3678: | fnd_api.g_ret_sts_error (error), |
3679: | fnd_api.g_ret_sts_unexp_error (unexpected |
3680: | error). |
3681: | x_msg_count Number of messages in message stack. |
3682: | x_msg_data Message text if x_msg_count is 1. |
3683: | MODIFICATION HISTORY |

Line 3687: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,

3683: | MODIFICATION HISTORY |
3684: | 27-NOV-2001 J. del Callar Created. |
3685: +=======================================================================*/
3686: PROCEDURE create_banking_group (
3687: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
3688: p_group_rec IN hz_party_v2pub.group_rec_type,
3689: x_party_id OUT NOCOPY NUMBER,
3690: x_party_number OUT NOCOPY VARCHAR2,
3691: x_return_status OUT NOCOPY VARCHAR2,

Line 3711: x_return_status := fnd_api.g_ret_sts_success;

3707: p_msg_level=>fnd_log.level_procedure);
3708: END IF;
3709:
3710: -- initialize API return status to success.
3711: x_return_status := fnd_api.g_ret_sts_success;
3712:
3713: --
3714: -- execute business logic
3715: --

Line 3721: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3717: -- validate the banking group
3718: validate_banking_group(p_group_rec, x_return_status);
3719:
3720: -- raise an exception if the validation routine is unsuccessful
3721: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3722: RAISE fnd_api.g_exc_error;
3723: END IF;
3724:
3725: -- create the banking group

Line 3722: RAISE fnd_api.g_exc_error;

3718: validate_banking_group(p_group_rec, x_return_status);
3719:
3720: -- raise an exception if the validation routine is unsuccessful
3721: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3722: RAISE fnd_api.g_exc_error;
3723: END IF;
3724:
3725: -- create the banking group
3726: hz_party_v2pub.create_group(

Line 3736: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3732: x_msg_data => x_msg_data
3733: );
3734:
3735: -- raise an exception if the banking group creation is unsuccessful
3736: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3737: RAISE fnd_api.g_exc_error;
3738: END IF;
3739:
3740: -- Debug info.

Line 3737: RAISE fnd_api.g_exc_error;

3733: );
3734:
3735: -- raise an exception if the banking group creation is unsuccessful
3736: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3737: RAISE fnd_api.g_exc_error;
3738: END IF;
3739:
3740: -- Debug info.
3741: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 3750: WHEN fnd_api.g_exc_error THEN

3746:
3747: -- disable the debug procedure before exiting.
3748: --disable_debug;
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,

Line 3752: x_return_status := fnd_api.g_ret_sts_error;

3748: --disable_debug;
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:

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 3773: WHEN fnd_api.g_exc_unexpected_error THEN

3769:
3770: -- Check if API is called in debug mode. If yes, disable debug.
3771: --disable_debug;
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,

Line 3775: x_return_status := fnd_api.g_ret_sts_unexp_error;

3771: --disable_debug;
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:

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 3798: x_return_status := fnd_api.g_ret_sts_unexp_error;

3794: --disable_debug;
3795:
3796: WHEN OTHERS THEN
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,

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 3836: | FND_API.G_TRUE. Default is fnd_api.g_false. |

3832: | |
3833: | ARGUMENTS |
3834: | IN: |
3835: | p_init_msg_list Initialize message stack if it is set to |
3836: | FND_API.G_TRUE. Default is fnd_api.g_false. |
3837: | p_group_rec Group record for the banking group. |
3838: | IN/OUT: |
3839: | p_pobject_version_number Version number for the banking group |
3840: | party that was created. |

Line 3843: | be FND_API.G_RET_STS_SUCCESS (success), |

3839: | p_pobject_version_number Version number for the banking group |
3840: | party that was created. |
3841: | OUT: |
3842: | x_return_status Return status after the call. The status can |
3843: | be FND_API.G_RET_STS_SUCCESS (success), |
3844: | fnd_api.g_ret_sts_error (error), |
3845: | fnd_api.g_ret_sts_unexp_error (unexpected |
3846: | error). |
3847: | x_msg_count Number of messages in message stack. |

Line 3844: | fnd_api.g_ret_sts_error (error), |

3840: | party that was created. |
3841: | OUT: |
3842: | x_return_status Return status after the call. The status can |
3843: | be FND_API.G_RET_STS_SUCCESS (success), |
3844: | fnd_api.g_ret_sts_error (error), |
3845: | fnd_api.g_ret_sts_unexp_error (unexpected |
3846: | error). |
3847: | x_msg_count Number of messages in message stack. |
3848: | x_msg_data Message text if x_msg_count is 1. |

Line 3845: | fnd_api.g_ret_sts_unexp_error (unexpected |

3841: | OUT: |
3842: | x_return_status Return status after the call. The status can |
3843: | be FND_API.G_RET_STS_SUCCESS (success), |
3844: | fnd_api.g_ret_sts_error (error), |
3845: | fnd_api.g_ret_sts_unexp_error (unexpected |
3846: | error). |
3847: | x_msg_count Number of messages in message stack. |
3848: | x_msg_data Message text if x_msg_count is 1. |
3849: | MODIFICATION HISTORY |

Line 3853: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,

3849: | MODIFICATION HISTORY |
3850: | 27-NOV-2001 J. del Callar Created. |
3851: +=======================================================================*/
3852: PROCEDURE update_banking_group (
3853: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
3854: p_group_rec IN hz_party_v2pub.group_rec_type,
3855: p_pobject_version_number IN OUT NOCOPY NUMBER,
3856: x_return_status OUT NOCOPY VARCHAR2,
3857: x_msg_count OUT NOCOPY NUMBER,

Line 3876: x_return_status := fnd_api.g_ret_sts_success;

3872: p_msg_level=>fnd_log.level_procedure);
3873: END IF;
3874:
3875: -- initialize API return status to success.
3876: x_return_status := fnd_api.g_ret_sts_success;
3877:
3878: --
3879: -- execute business logic
3880: --

Line 3886: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3882: -- validate the banking group
3883: validate_banking_group(p_group_rec, x_return_status);
3884:
3885: -- raise an exception if the validation routine is unsuccessful
3886: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3887: RAISE fnd_api.g_exc_error;
3888: END IF;
3889:
3890: -- create the banking group

Line 3887: RAISE fnd_api.g_exc_error;

3883: validate_banking_group(p_group_rec, x_return_status);
3884:
3885: -- raise an exception if the validation routine is unsuccessful
3886: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3887: RAISE fnd_api.g_exc_error;
3888: END IF;
3889:
3890: -- create the banking group
3891: hz_party_v2pub.update_group(

Line 3900: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3896: x_msg_data => x_msg_data
3897: );
3898:
3899: -- raise an exception if the banking group update is unsuccessful
3900: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3901: RAISE fnd_api.g_exc_error;
3902: END IF;
3903:
3904: -- Debug info.

Line 3901: RAISE fnd_api.g_exc_error;

3897: );
3898:
3899: -- raise an exception if the banking group update is unsuccessful
3900: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3901: RAISE fnd_api.g_exc_error;
3902: END IF;
3903:
3904: -- Debug info.
3905: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 3914: WHEN fnd_api.g_exc_error THEN

3910:
3911: -- disable the debug procedure before exiting.
3912: --disable_debug;
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,

Line 3916: x_return_status := fnd_api.g_ret_sts_error;

3912: --disable_debug;
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:

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 3937: WHEN fnd_api.g_exc_unexpected_error THEN

3933:
3934: -- Check if API is called in debug mode. If yes, disable debug.
3935: --disable_debug;
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,

Line 3939: x_return_status := fnd_api.g_ret_sts_unexp_error;

3935: --disable_debug;
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:

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 3962: x_return_status := fnd_api.g_ret_sts_unexp_error;

3958: --disable_debug;
3959:
3960: WHEN OTHERS THEN
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,

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 4001: | FND_API.G_TRUE. Default is fnd_api.g_false. |

3997: | |
3998: | ARGUMENTS |
3999: | IN: |
4000: | p_init_msg_list Initialize message stack if it is set to |
4001: | FND_API.G_TRUE. Default is fnd_api.g_false. |
4002: | p_relationship_rec Relationship record for the banking group |
4003: | membership. |
4004: | IN/OUT: |
4005: | OUT: |

Line 4012: | be FND_API.G_RET_STS_SUCCESS (success), |

4008: | relationship. |
4009: | x_party_number Party number for the party created for the |
4010: | relationship. |
4011: | x_return_status Return status after the call. The status can |
4012: | be FND_API.G_RET_STS_SUCCESS (success), |
4013: | fnd_api.g_ret_sts_error (error), |
4014: | fnd_api.g_ret_sts_unexp_error (unexpected |
4015: | error). |
4016: | x_msg_count Number of messages in message stack. |

Line 4013: | fnd_api.g_ret_sts_error (error), |

4009: | x_party_number Party number for the party created for the |
4010: | relationship. |
4011: | x_return_status Return status after the call. The status can |
4012: | be FND_API.G_RET_STS_SUCCESS (success), |
4013: | fnd_api.g_ret_sts_error (error), |
4014: | fnd_api.g_ret_sts_unexp_error (unexpected |
4015: | error). |
4016: | x_msg_count Number of messages in message stack. |
4017: | x_msg_data Message text if x_msg_count is 1. |

Line 4014: | fnd_api.g_ret_sts_unexp_error (unexpected |

4010: | relationship. |
4011: | x_return_status Return status after the call. The status can |
4012: | be FND_API.G_RET_STS_SUCCESS (success), |
4013: | fnd_api.g_ret_sts_error (error), |
4014: | fnd_api.g_ret_sts_unexp_error (unexpected |
4015: | error). |
4016: | x_msg_count Number of messages in message stack. |
4017: | x_msg_data Message text if x_msg_count is 1. |
4018: | MODIFICATION HISTORY |

Line 4022: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,

4018: | MODIFICATION HISTORY |
4019: | 27-NOV-2001 J. del Callar Created. |
4020: +=======================================================================*/
4021: PROCEDURE create_bank_group_member (
4022: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
4023: p_relationship_rec IN hz_relationship_v2pub.relationship_rec_type,
4024: x_relationship_id OUT NOCOPY NUMBER,
4025: x_party_id OUT NOCOPY NUMBER,
4026: x_party_number OUT NOCOPY NUMBER,

Line 4047: x_return_status := fnd_api.g_ret_sts_success;

4043: p_msg_level=>fnd_log.level_procedure);
4044: END IF;
4045:
4046: -- initialize API return status to success.
4047: x_return_status := fnd_api.g_ret_sts_success;
4048:
4049: --
4050: -- execute business logic
4051: --

Line 4057: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4053: -- validate the banking group membership
4054: validate_bank_group_member(p_relationship_rec, g_insert, x_return_status);
4055:
4056: -- raise an exception if the validation routine is unsuccessful
4057: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4058: RAISE fnd_api.g_exc_error;
4059: END IF;
4060:
4061: -- create the banking group membership

Line 4058: RAISE fnd_api.g_exc_error;

4054: validate_bank_group_member(p_relationship_rec, g_insert, x_return_status);
4055:
4056: -- raise an exception if the validation routine is unsuccessful
4057: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4058: RAISE fnd_api.g_exc_error;
4059: END IF;
4060:
4061: -- create the banking group membership
4062: hz_relationship_v2pub.create_relationship(

Line 4073: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4069: x_msg_data => x_msg_data
4070: );
4071:
4072: -- raise an exception if the banking group creation is unsuccessful
4073: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4074: RAISE fnd_api.g_exc_error;
4075: END IF;
4076:
4077: -- Debug info.

Line 4074: RAISE fnd_api.g_exc_error;

4070: );
4071:
4072: -- raise an exception if the banking group creation is unsuccessful
4073: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4074: RAISE fnd_api.g_exc_error;
4075: END IF;
4076:
4077: -- Debug info.
4078: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 4087: WHEN fnd_api.g_exc_error THEN

4083:
4084: -- disable the debug procedure before exiting.
4085: --disable_debug;
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,

Line 4089: x_return_status := fnd_api.g_ret_sts_error;

4085: --disable_debug;
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:

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 4110: WHEN fnd_api.g_exc_unexpected_error THEN

4106:
4107: -- Check if API is called in debug mode. If yes, disable debug.
4108: --disable_debug;
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,

Line 4112: x_return_status := fnd_api.g_ret_sts_unexp_error;

4108: --disable_debug;
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:

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 4135: x_return_status := fnd_api.g_ret_sts_unexp_error;

4131: --disable_debug;
4132:
4133: WHEN OTHERS THEN
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,

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 4174: | FND_API.G_TRUE. Default is fnd_api.g_false. |

4170: | |
4171: | ARGUMENTS |
4172: | IN: |
4173: | p_init_msg_list Initialize message stack if it is set to |
4174: | FND_API.G_TRUE. Default is fnd_api.g_false. |
4175: | p_relationship_rec Relationship record for the banking group |
4176: | membership. |
4177: | IN/OUT: |
4178: | p_robject_version_number New version number for the banking |

Line 4184: | be FND_API.G_RET_STS_SUCCESS (success), |

4180: | p_pobject_version_number New version number for the banking |
4181: | group membership rel party. |
4182: | OUT: |
4183: | x_return_status Return status after the call. The status can |
4184: | be FND_API.G_RET_STS_SUCCESS (success), |
4185: | fnd_api.g_ret_sts_error (error), |
4186: | fnd_api.g_ret_sts_unexp_error (unexpected |
4187: | error). |
4188: | x_msg_count Number of messages in message stack. |

Line 4185: | fnd_api.g_ret_sts_error (error), |

4181: | group membership rel party. |
4182: | OUT: |
4183: | x_return_status Return status after the call. The status can |
4184: | be FND_API.G_RET_STS_SUCCESS (success), |
4185: | fnd_api.g_ret_sts_error (error), |
4186: | fnd_api.g_ret_sts_unexp_error (unexpected |
4187: | error). |
4188: | x_msg_count Number of messages in message stack. |
4189: | x_msg_data Message text if x_msg_count is 1. |

Line 4186: | fnd_api.g_ret_sts_unexp_error (unexpected |

4182: | OUT: |
4183: | x_return_status Return status after the call. The status can |
4184: | be FND_API.G_RET_STS_SUCCESS (success), |
4185: | fnd_api.g_ret_sts_error (error), |
4186: | fnd_api.g_ret_sts_unexp_error (unexpected |
4187: | error). |
4188: | x_msg_count Number of messages in message stack. |
4189: | x_msg_data Message text if x_msg_count is 1. |
4190: | MODIFICATION HISTORY |

Line 4194: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,

4190: | MODIFICATION HISTORY |
4191: | 27-NOV-2001 J. del Callar Updated. |
4192: +=======================================================================*/
4193: PROCEDURE update_bank_group_member (
4194: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
4195: p_relationship_rec IN hz_relationship_v2pub.relationship_rec_type,
4196: p_robject_version_number IN OUT NOCOPY NUMBER,
4197: p_pobject_version_number IN OUT NOCOPY NUMBER,
4198: x_return_status OUT NOCOPY VARCHAR2,

Line 4218: x_return_status := fnd_api.g_ret_sts_success;

4214: p_msg_level=>fnd_log.level_procedure);
4215: END IF;
4216:
4217: -- initialize API return status to success.
4218: x_return_status := fnd_api.g_ret_sts_success;
4219:
4220: --
4221: -- execute business logic
4222: --

Line 4228: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4224: -- validate the banking group membership
4225: validate_bank_group_member(p_relationship_rec, g_update, x_return_status);
4226:
4227: -- raise an exception if the validation routine is unsuccessful
4228: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4229: RAISE fnd_api.g_exc_error;
4230: END IF;
4231:
4232: -- update the banking group membership

Line 4229: RAISE fnd_api.g_exc_error;

4225: validate_bank_group_member(p_relationship_rec, g_update, x_return_status);
4226:
4227: -- raise an exception if the validation routine is unsuccessful
4228: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4229: RAISE fnd_api.g_exc_error;
4230: END IF;
4231:
4232: -- update the banking group membership
4233: hz_relationship_v2pub.update_relationship(

Line 4243: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4239: x_msg_data => x_msg_data
4240: );
4241:
4242: -- raise an exception if the banking group creation is unsuccessful
4243: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4244: RAISE fnd_api.g_exc_error;
4245: END IF;
4246:
4247: -- Debug info.

Line 4244: RAISE fnd_api.g_exc_error;

4240: );
4241:
4242: -- raise an exception if the banking group creation is unsuccessful
4243: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4244: RAISE fnd_api.g_exc_error;
4245: END IF;
4246:
4247: -- Debug info.
4248: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 4257: WHEN fnd_api.g_exc_error THEN

4253:
4254: -- disable the debug procedure before exiting.
4255: --disable_debug;
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,

Line 4259: x_return_status := fnd_api.g_ret_sts_error;

4255: --disable_debug;
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:

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 4280: WHEN fnd_api.g_exc_unexpected_error THEN

4276:
4277: -- Check if API is called in debug mode. If yes, disable debug.
4278: --disable_debug;
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,

Line 4282: x_return_status := fnd_api.g_ret_sts_unexp_error;

4278: --disable_debug;
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:

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 4305: x_return_status := fnd_api.g_ret_sts_unexp_error;

4301: --disable_debug;
4302:
4303: WHEN OTHERS THEN
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,

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 4343: | FND_API.G_TRUE. Default is fnd_api.g_false. |

4339: | |
4340: | ARGUMENTS |
4341: | IN: |
4342: | p_init_msg_list Initialize message stack if it is set to |
4343: | FND_API.G_TRUE. Default is fnd_api.g_false. |
4344: | p_relationship_rec Relationship record for the clearinghouse |
4345: | assignment. |
4346: | IN/OUT: |
4347: | OUT: |

Line 4354: | be FND_API.G_RET_STS_SUCCESS (success), |

4350: | relationship. |
4351: | x_party_number Party number for the party created for the |
4352: | relationship. |
4353: | x_return_status Return status after the call. The status can |
4354: | be FND_API.G_RET_STS_SUCCESS (success), |
4355: | fnd_api.g_ret_sts_error (error), |
4356: | fnd_api.g_ret_sts_unexp_error (unexpected |
4357: | error). |
4358: | x_msg_count Number of messages in message stack. |

Line 4355: | fnd_api.g_ret_sts_error (error), |

4351: | x_party_number Party number for the party created for the |
4352: | relationship. |
4353: | x_return_status Return status after the call. The status can |
4354: | be FND_API.G_RET_STS_SUCCESS (success), |
4355: | fnd_api.g_ret_sts_error (error), |
4356: | fnd_api.g_ret_sts_unexp_error (unexpected |
4357: | error). |
4358: | x_msg_count Number of messages in message stack. |
4359: | x_msg_data Message text if x_msg_count is 1. |

Line 4356: | fnd_api.g_ret_sts_unexp_error (unexpected |

4352: | relationship. |
4353: | x_return_status Return status after the call. The status can |
4354: | be FND_API.G_RET_STS_SUCCESS (success), |
4355: | fnd_api.g_ret_sts_error (error), |
4356: | fnd_api.g_ret_sts_unexp_error (unexpected |
4357: | error). |
4358: | x_msg_count Number of messages in message stack. |
4359: | x_msg_data Message text if x_msg_count is 1. |
4360: | MODIFICATION HISTORY |

Line 4364: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,

4360: | MODIFICATION HISTORY |
4361: | 27-NOV-2001 J. del Callar Created. |
4362: +=======================================================================*/
4363: PROCEDURE create_clearinghouse_assign (
4364: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
4365: p_relationship_rec IN hz_relationship_v2pub.relationship_rec_type,
4366: x_relationship_id OUT NOCOPY NUMBER,
4367: x_party_id OUT NOCOPY NUMBER,
4368: x_party_number OUT NOCOPY NUMBER,

Line 4389: x_return_status := fnd_api.g_ret_sts_success;

4385: p_msg_level=>fnd_log.level_procedure);
4386: END IF;
4387:
4388: -- initialize API return status to success.
4389: x_return_status := fnd_api.g_ret_sts_success;
4390:
4391: --
4392: -- execute business logic
4393: --

Line 4401: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4397: g_insert,
4398: x_return_status);
4399:
4400: -- raise an exception if the validation routine is unsuccessful
4401: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4402: RAISE fnd_api.g_exc_error;
4403: END IF;
4404:
4405: -- create the banking group membership

Line 4402: RAISE fnd_api.g_exc_error;

4398: x_return_status);
4399:
4400: -- raise an exception if the validation routine is unsuccessful
4401: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4402: RAISE fnd_api.g_exc_error;
4403: END IF;
4404:
4405: -- create the banking group membership
4406: hz_relationship_v2pub.create_relationship(

Line 4417: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4413: x_msg_data => x_msg_data
4414: );
4415:
4416: -- raise an exception if the banking group creation is unsuccessful
4417: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4418: RAISE fnd_api.g_exc_error;
4419: END IF;
4420:
4421: -- Debug info.

Line 4418: RAISE fnd_api.g_exc_error;

4414: );
4415:
4416: -- raise an exception if the banking group creation is unsuccessful
4417: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4418: RAISE fnd_api.g_exc_error;
4419: END IF;
4420:
4421: -- Debug info.
4422: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 4431: WHEN fnd_api.g_exc_error THEN

4427:
4428: -- disable the debug procedure before exiting.
4429: --disable_debug;
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,

Line 4433: x_return_status := fnd_api.g_ret_sts_error;

4429: --disable_debug;
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:

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 4454: WHEN fnd_api.g_exc_unexpected_error THEN

4450:
4451: -- Check if API is called in debug mode. If yes, disable debug.
4452: --disable_debug;
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,

Line 4456: x_return_status := fnd_api.g_ret_sts_unexp_error;

4452: --disable_debug;
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:

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 4479: x_return_status := fnd_api.g_ret_sts_unexp_error;

4475: --disable_debug;
4476:
4477: WHEN OTHERS THEN
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,

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 4517: | FND_API.G_TRUE. Default is fnd_api.g_false. |

4513: | |
4514: | ARGUMENTS |
4515: | IN: |
4516: | p_init_msg_list Initialize message stack if it is set to |
4517: | FND_API.G_TRUE. Default is fnd_api.g_false. |
4518: | p_relationship_rec Relationship record for the clearinghouse |
4519: | assignment. |
4520: | IN/OUT: |
4521: | p_robject_version_number New version number for the banking |

Line 4527: | be FND_API.G_RET_STS_SUCCESS (success), |

4523: | p_pobject_version_number New version number for the banking |
4524: | group membership rel party. |
4525: | OUT: |
4526: | x_return_status Return status after the call. The status can |
4527: | be FND_API.G_RET_STS_SUCCESS (success), |
4528: | fnd_api.g_ret_sts_error (error), |
4529: | fnd_api.g_ret_sts_unexp_error (unexpected |
4530: | error). |
4531: | x_msg_count Number of messages in message stack. |

Line 4528: | fnd_api.g_ret_sts_error (error), |

4524: | group membership rel party. |
4525: | OUT: |
4526: | x_return_status Return status after the call. The status can |
4527: | be FND_API.G_RET_STS_SUCCESS (success), |
4528: | fnd_api.g_ret_sts_error (error), |
4529: | fnd_api.g_ret_sts_unexp_error (unexpected |
4530: | error). |
4531: | x_msg_count Number of messages in message stack. |
4532: | x_msg_data Message text if x_msg_count is 1. |

Line 4529: | fnd_api.g_ret_sts_unexp_error (unexpected |

4525: | OUT: |
4526: | x_return_status Return status after the call. The status can |
4527: | be FND_API.G_RET_STS_SUCCESS (success), |
4528: | fnd_api.g_ret_sts_error (error), |
4529: | fnd_api.g_ret_sts_unexp_error (unexpected |
4530: | error). |
4531: | x_msg_count Number of messages in message stack. |
4532: | x_msg_data Message text if x_msg_count is 1. |
4533: | MODIFICATION HISTORY |

Line 4537: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,

4533: | MODIFICATION HISTORY |
4534: | 27-NOV-2001 J. del Callar Updated. |
4535: +=======================================================================*/
4536: PROCEDURE update_clearinghouse_assign (
4537: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
4538: p_relationship_rec IN hz_relationship_v2pub.relationship_rec_type,
4539: p_robject_version_number IN OUT NOCOPY NUMBER,
4540: p_pobject_version_number IN OUT NOCOPY NUMBER,
4541: x_return_status OUT NOCOPY VARCHAR2,

Line 4561: x_return_status := fnd_api.g_ret_sts_success;

4557: p_msg_level=>fnd_log.level_procedure);
4558: END IF;
4559:
4560: -- initialize API return status to success.
4561: x_return_status := fnd_api.g_ret_sts_success;
4562:
4563: --
4564: -- execute business logic
4565: --

Line 4573: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4569: g_update,
4570: x_return_status);
4571:
4572: -- raise an exception if the validation routine is unsuccessful
4573: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4574: RAISE fnd_api.g_exc_error;
4575: END IF;
4576:
4577: -- update the banking group membership

Line 4574: RAISE fnd_api.g_exc_error;

4570: x_return_status);
4571:
4572: -- raise an exception if the validation routine is unsuccessful
4573: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4574: RAISE fnd_api.g_exc_error;
4575: END IF;
4576:
4577: -- update the banking group membership
4578: hz_relationship_v2pub.update_relationship(

Line 4588: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4584: x_msg_data => x_msg_data
4585: );
4586:
4587: -- raise an exception if the banking group creation is unsuccessful
4588: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4589: RAISE fnd_api.g_exc_error;
4590: END IF;
4591:
4592: -- Debug info.

Line 4589: RAISE fnd_api.g_exc_error;

4585: );
4586:
4587: -- raise an exception if the banking group creation is unsuccessful
4588: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4589: RAISE fnd_api.g_exc_error;
4590: END IF;
4591:
4592: -- Debug info.
4593: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 4602: WHEN fnd_api.g_exc_error THEN

4598:
4599: -- disable the debug procedure before exiting.
4600: --disable_debug;
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,

Line 4604: x_return_status := fnd_api.g_ret_sts_error;

4600: --disable_debug;
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:

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 4625: WHEN fnd_api.g_exc_unexpected_error THEN

4621:
4622: -- Check if API is called in debug mode. If yes, disable debug.
4623: --disable_debug;
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,

Line 4627: x_return_status := fnd_api.g_ret_sts_unexp_error;

4623: --disable_debug;
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:

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 4650: x_return_status := fnd_api.g_ret_sts_unexp_error;

4646: --disable_debug;
4647:
4648: WHEN OTHERS THEN
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,

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 4688: | FND_API.G_TRUE. Default is fnd_api.g_false. |

4684: | |
4685: | ARGUMENTS |
4686: | IN: |
4687: | p_init_msg_list Initialize message stack if it is set to |
4688: | FND_API.G_TRUE. Default is fnd_api.g_false. |
4689: | p_party_site_rec Party site record for the bank organization. |
4690: | IN/OUT: |
4691: | OUT: |
4692: | x_party_site_id ID for the party site created. |

Line 4696: | be FND_API.G_RET_STS_SUCCESS (success), |

4692: | x_party_site_id ID for the party site created. |
4693: | x_party_site_number Party site number for the bank site |
4694: | created. |
4695: | x_return_status Return status after the call. The status can |
4696: | be FND_API.G_RET_STS_SUCCESS (success), |
4697: | fnd_api.g_ret_sts_error (error), |
4698: | fnd_api.g_ret_sts_unexp_error (unexpected |
4699: | error). |
4700: | x_msg_count Number of messages in message stack. |

Line 4697: | fnd_api.g_ret_sts_error (error), |

4693: | x_party_site_number Party site number for the bank site |
4694: | created. |
4695: | x_return_status Return status after the call. The status can |
4696: | be FND_API.G_RET_STS_SUCCESS (success), |
4697: | fnd_api.g_ret_sts_error (error), |
4698: | fnd_api.g_ret_sts_unexp_error (unexpected |
4699: | error). |
4700: | x_msg_count Number of messages in message stack. |
4701: | x_msg_data Message text if x_msg_count is 1. |

Line 4698: | fnd_api.g_ret_sts_unexp_error (unexpected |

4694: | created. |
4695: | x_return_status Return status after the call. The status can |
4696: | be FND_API.G_RET_STS_SUCCESS (success), |
4697: | fnd_api.g_ret_sts_error (error), |
4698: | fnd_api.g_ret_sts_unexp_error (unexpected |
4699: | error). |
4700: | x_msg_count Number of messages in message stack. |
4701: | x_msg_data Message text if x_msg_count is 1. |
4702: | MODIFICATION HISTORY |

Line 4706: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,

4702: | MODIFICATION HISTORY |
4703: | 27-NOV-2001 J. del Callar Created. |
4704: +=======================================================================*/
4705: PROCEDURE create_bank_site (
4706: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
4707: p_party_site_rec IN hz_party_site_v2pub.party_site_rec_type,
4708: x_party_site_id OUT NOCOPY NUMBER,
4709: x_party_site_number OUT NOCOPY NUMBER,
4710: x_return_status OUT NOCOPY VARCHAR2,

Line 4730: x_return_status := fnd_api.g_ret_sts_success;

4726: p_msg_level=>fnd_log.level_procedure);
4727: END IF;
4728:
4729: -- initialize API return status to success.
4730: x_return_status := fnd_api.g_ret_sts_success;
4731:
4732: --
4733: -- execute business logic
4734: --

Line 4740: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4736: -- validate the banking group membership
4737: validate_bank_site(p_party_site_rec, g_insert, x_return_status);
4738:
4739: -- raise an exception if the validation routine is unsuccessful
4740: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4741: RAISE fnd_api.g_exc_error;
4742: END IF;
4743:
4744: -- create the banking group membership

Line 4741: RAISE fnd_api.g_exc_error;

4737: validate_bank_site(p_party_site_rec, g_insert, x_return_status);
4738:
4739: -- raise an exception if the validation routine is unsuccessful
4740: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4741: RAISE fnd_api.g_exc_error;
4742: END IF;
4743:
4744: -- create the banking group membership
4745: hz_party_site_v2pub.create_party_site(

Line 4755: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4751: x_msg_data => x_msg_data
4752: );
4753:
4754: -- raise an exception if the banking group creation is unsuccessful
4755: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4756: RAISE fnd_api.g_exc_error;
4757: END IF;
4758:
4759: -- Debug info.

Line 4756: RAISE fnd_api.g_exc_error;

4752: );
4753:
4754: -- raise an exception if the banking group creation is unsuccessful
4755: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4756: RAISE fnd_api.g_exc_error;
4757: END IF;
4758:
4759: -- Debug info.
4760: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 4769: WHEN fnd_api.g_exc_error THEN

4765:
4766: -- disable the debug procedure before exiting.
4767: --disable_debug;
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,

Line 4771: x_return_status := fnd_api.g_ret_sts_error;

4767: --disable_debug;
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:

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 4792: WHEN fnd_api.g_exc_unexpected_error THEN

4788:
4789: -- Check if API is called in debug mode. If yes, disable debug.
4790: --disable_debug;
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,

Line 4794: x_return_status := fnd_api.g_ret_sts_unexp_error;

4790: --disable_debug;
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:

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 4817: x_return_status := fnd_api.g_ret_sts_unexp_error;

4813: --disable_debug;
4814:
4815: WHEN OTHERS THEN
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,

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 4855: | FND_API.G_TRUE. Default is fnd_api.g_false. |

4851: | |
4852: | ARGUMENTS |
4853: | IN: |
4854: | p_init_msg_list Initialize message stack if it is set to |
4855: | FND_API.G_TRUE. Default is fnd_api.g_false. |
4856: | p_party_site_rec Party site record for the bank organization. |
4857: | IN/OUT: |
4858: | x_psobject_version_number Party site version number for the |
4859: | updated bank site. |

Line 4862: | be FND_API.G_RET_STS_SUCCESS (success), |

4858: | x_psobject_version_number Party site version number for the |
4859: | updated bank site. |
4860: | OUT: |
4861: | x_return_status Return status after the call. The status can |
4862: | be FND_API.G_RET_STS_SUCCESS (success), |
4863: | fnd_api.g_ret_sts_error (error), |
4864: | fnd_api.g_ret_sts_unexp_error (unexpected |
4865: | error). |
4866: | x_msg_count Number of messages in message stack. |

Line 4863: | fnd_api.g_ret_sts_error (error), |

4859: | updated bank site. |
4860: | OUT: |
4861: | x_return_status Return status after the call. The status can |
4862: | be FND_API.G_RET_STS_SUCCESS (success), |
4863: | fnd_api.g_ret_sts_error (error), |
4864: | fnd_api.g_ret_sts_unexp_error (unexpected |
4865: | error). |
4866: | x_msg_count Number of messages in message stack. |
4867: | x_msg_data Message text if x_msg_count is 1. |

Line 4864: | fnd_api.g_ret_sts_unexp_error (unexpected |

4860: | OUT: |
4861: | x_return_status Return status after the call. The status can |
4862: | be FND_API.G_RET_STS_SUCCESS (success), |
4863: | fnd_api.g_ret_sts_error (error), |
4864: | fnd_api.g_ret_sts_unexp_error (unexpected |
4865: | error). |
4866: | x_msg_count Number of messages in message stack. |
4867: | x_msg_data Message text if x_msg_count is 1. |
4868: | MODIFICATION HISTORY |

Line 4872: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,

4868: | MODIFICATION HISTORY |
4869: | 27-NOV-2001 J. del Callar Updated. |
4870: +=======================================================================*/
4871: PROCEDURE update_bank_site (
4872: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
4873: p_party_site_rec IN hz_party_site_v2pub.party_site_rec_type,
4874: p_psobject_version_number IN OUT NOCOPY NUMBER,
4875: x_return_status OUT NOCOPY VARCHAR2,
4876: x_msg_count OUT NOCOPY NUMBER,

Line 4895: x_return_status := fnd_api.g_ret_sts_success;

4891: p_msg_level=>fnd_log.level_procedure);
4892: END IF;
4893:
4894: -- initialize API return status to success.
4895: x_return_status := fnd_api.g_ret_sts_success;
4896:
4897: --
4898: -- execute business logic
4899: --

Line 4905: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4901: -- validate the banking group membership
4902: validate_bank_site(p_party_site_rec, g_update, x_return_status);
4903:
4904: -- raise an exception if the validation routine is unsuccessful
4905: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4906: RAISE fnd_api.g_exc_error;
4907: END IF;
4908:
4909: -- update the banking group membership

Line 4906: RAISE fnd_api.g_exc_error;

4902: validate_bank_site(p_party_site_rec, g_update, x_return_status);
4903:
4904: -- raise an exception if the validation routine is unsuccessful
4905: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4906: RAISE fnd_api.g_exc_error;
4907: END IF;
4908:
4909: -- update the banking group membership
4910: hz_party_site_v2pub.update_party_site(

Line 4919: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4915: x_msg_data => x_msg_data
4916: );
4917:
4918: -- raise an exception if the banking group creation is unsuccessful
4919: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4920: RAISE fnd_api.g_exc_error;
4921: END IF;
4922:
4923: -- Debug info.

Line 4920: RAISE fnd_api.g_exc_error;

4916: );
4917:
4918: -- raise an exception if the banking group creation is unsuccessful
4919: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4920: RAISE fnd_api.g_exc_error;
4921: END IF;
4922:
4923: -- Debug info.
4924: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 4933: WHEN fnd_api.g_exc_error THEN

4929:
4930: -- disable the debug procedure before exiting.
4931: --disable_debug;
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,

Line 4935: x_return_status := fnd_api.g_ret_sts_error;

4931: --disable_debug;
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:

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 4956: WHEN fnd_api.g_exc_unexpected_error THEN

4952:
4953: -- Check if API is called in debug mode. If yes, disable debug.
4954: --disable_debug;
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,

Line 4958: x_return_status := fnd_api.g_ret_sts_unexp_error;

4954: --disable_debug;
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:

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 4981: x_return_status := fnd_api.g_ret_sts_unexp_error;

4977: --disable_debug;
4978:
4979: WHEN OTHERS THEN
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,

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 5019: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |

5015: | |
5016: | ARGUMENTS |
5017: | IN: |
5018: | p_init_msg_list Initialize message stack if it is set to |
5019: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
5020: | p_contact_point_rec Contact point record. |
5021: | p_edi_rec EDI record. |
5022: | IN/OUT: |
5023: | OUT: |

Line 5028: | be FND_API.G_RET_STS_SUCCESS (success), |

5024: | x_contact_point_id ID of the contact point created. |
5025: | x_party_number Party number for the party created for the |
5026: | relationship. |
5027: | x_return_status Return status after the call. The status can |
5028: | be FND_API.G_RET_STS_SUCCESS (success), |
5029: | fnd_api.g_ret_sts_error (error), |
5030: | fnd_api.g_ret_sts_unexp_error (unexpected |
5031: | error). |
5032: | x_msg_count Number of messages in message stack. |

Line 5029: | fnd_api.g_ret_sts_error (error), |

5025: | x_party_number Party number for the party created for the |
5026: | relationship. |
5027: | x_return_status Return status after the call. The status can |
5028: | be FND_API.G_RET_STS_SUCCESS (success), |
5029: | fnd_api.g_ret_sts_error (error), |
5030: | fnd_api.g_ret_sts_unexp_error (unexpected |
5031: | error). |
5032: | x_msg_count Number of messages in message stack. |
5033: | x_msg_data Message text if x_msg_count is 1. |

Line 5030: | fnd_api.g_ret_sts_unexp_error (unexpected |

5026: | relationship. |
5027: | x_return_status Return status after the call. The status can |
5028: | be FND_API.G_RET_STS_SUCCESS (success), |
5029: | fnd_api.g_ret_sts_error (error), |
5030: | fnd_api.g_ret_sts_unexp_error (unexpected |
5031: | error). |
5032: | x_msg_count Number of messages in message stack. |
5033: | x_msg_data Message text if x_msg_count is 1. |
5034: | MODIFICATION HISTORY |

Line 5038: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

5034: | MODIFICATION HISTORY |
5035: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
5036: +=======================================================================*/
5037: PROCEDURE create_edi_contact_point (
5038: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5039: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5040: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type
5041: := hz_contact_point_v2pub.g_miss_edi_rec,
5042: x_contact_point_id OUT NOCOPY NUMBER,

Line 5063: x_return_status := fnd_api.g_ret_sts_success;

5059: p_msg_level=>fnd_log.level_procedure);
5060: END IF;
5061:
5062: -- initialize API return status to success.
5063: x_return_status := fnd_api.g_ret_sts_success;
5064:
5065: --
5066: -- execute business logic
5067: --

Line 5075: IF x_return_status <> fnd_api.g_ret_sts_success THEN

5071: p_edi_rec,
5072: x_return_status);
5073:
5074: -- raise an exception if the validation routine is unsuccessful
5075: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5076: RAISE fnd_api.g_exc_error;
5077: END IF;
5078:
5079: -- create the EDI contact point

Line 5076: RAISE fnd_api.g_exc_error;

5072: x_return_status);
5073:
5074: -- raise an exception if the validation routine is unsuccessful
5075: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5076: RAISE fnd_api.g_exc_error;
5077: END IF;
5078:
5079: -- create the EDI contact point
5080: hz_contact_point_v2pub.create_edi_contact_point(

Line 5081: p_init_msg_list => fnd_api.g_false,

5077: END IF;
5078:
5079: -- create the EDI contact point
5080: hz_contact_point_v2pub.create_edi_contact_point(
5081: p_init_msg_list => fnd_api.g_false,
5082: p_contact_point_rec => p_contact_point_rec,
5083: p_edi_rec => p_edi_rec,
5084: x_contact_point_id => x_contact_point_id,
5085: x_return_status => x_return_status,

Line 5091: IF x_return_status <> fnd_api.g_ret_sts_success THEN

5087: x_msg_data => x_msg_data
5088: );
5089:
5090: -- raise an exception if the banking group creation is unsuccessful
5091: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5092: RAISE fnd_api.g_exc_error;
5093: END IF;
5094:
5095: -- Debug info.

Line 5092: RAISE fnd_api.g_exc_error;

5088: );
5089:
5090: -- raise an exception if the banking group creation is unsuccessful
5091: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5092: RAISE fnd_api.g_exc_error;
5093: END IF;
5094:
5095: -- Debug info.
5096: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5105: WHEN fnd_api.g_exc_error THEN

5101:
5102: -- disable the debug procedure before exiting.
5103: --disable_debug;
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,

Line 5107: x_return_status := fnd_api.g_ret_sts_error;

5103: --disable_debug;
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:

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 5128: WHEN fnd_api.g_exc_unexpected_error THEN

5124:
5125: -- Check if API is called in debug mode. If yes, disable debug.
5126: --disable_debug;
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,

Line 5130: x_return_status := fnd_api.g_ret_sts_unexp_error;

5126: --disable_debug;
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:

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 5153: x_return_status := fnd_api.g_ret_sts_unexp_error;

5149: --disable_debug;
5150:
5151: WHEN OTHERS THEN
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,

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 5191: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |

5187: | |
5188: | ARGUMENTS |
5189: | IN: |
5190: | p_init_msg_list Initialize message stack if it is set to |
5191: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
5192: | p_contact_point_rec Contact point record. |
5193: | p_edi_rec EDI record. |
5194: | IN/OUT: |
5195: | p_object_version_number Used to lock the record being updated. |

Line 5200: | be FND_API.G_RET_STS_SUCCESS (success), |

5196: | OUT: |
5197: | x_party_number Party number for the party created for the |
5198: | relationship. |
5199: | x_return_status Return status after the call. The status can |
5200: | be FND_API.G_RET_STS_SUCCESS (success), |
5201: | fnd_api.g_ret_sts_error (error), |
5202: | fnd_api.g_ret_sts_unexp_error (unexpected |
5203: | error). |
5204: | x_msg_count Number of messages in message stack. |

Line 5201: | fnd_api.g_ret_sts_error (error), |

5197: | x_party_number Party number for the party created for the |
5198: | relationship. |
5199: | x_return_status Return status after the call. The status can |
5200: | be FND_API.G_RET_STS_SUCCESS (success), |
5201: | fnd_api.g_ret_sts_error (error), |
5202: | fnd_api.g_ret_sts_unexp_error (unexpected |
5203: | error). |
5204: | x_msg_count Number of messages in message stack. |
5205: | x_msg_data Message text if x_msg_count is 1. |

Line 5202: | fnd_api.g_ret_sts_unexp_error (unexpected |

5198: | relationship. |
5199: | x_return_status Return status after the call. The status can |
5200: | be FND_API.G_RET_STS_SUCCESS (success), |
5201: | fnd_api.g_ret_sts_error (error), |
5202: | fnd_api.g_ret_sts_unexp_error (unexpected |
5203: | error). |
5204: | x_msg_count Number of messages in message stack. |
5205: | x_msg_data Message text if x_msg_count is 1. |
5206: | MODIFICATION HISTORY |

Line 5210: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

5206: | MODIFICATION HISTORY |
5207: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
5208: +=======================================================================*/
5209: PROCEDURE update_edi_contact_point (
5210: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5211: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5212: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type
5213: := hz_contact_point_v2pub.g_miss_edi_rec,
5214: p_object_version_number IN OUT NOCOPY NUMBER,

Line 5235: x_return_status := fnd_api.g_ret_sts_success;

5231: p_msg_level=>fnd_log.level_procedure);
5232: END IF;
5233:
5234: -- initialize API return status to success.
5235: x_return_status := fnd_api.g_ret_sts_success;
5236:
5237: --
5238: -- execute business logic
5239: --

Line 5247: IF x_return_status <> fnd_api.g_ret_sts_success THEN

5243: p_edi_rec,
5244: x_return_status);
5245:
5246: -- raise an exception if the validation routine is unsuccessful
5247: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5248: RAISE fnd_api.g_exc_error;
5249: END IF;
5250:
5251: -- update the EDI contact point

Line 5248: RAISE fnd_api.g_exc_error;

5244: x_return_status);
5245:
5246: -- raise an exception if the validation routine is unsuccessful
5247: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5248: RAISE fnd_api.g_exc_error;
5249: END IF;
5250:
5251: -- update the EDI contact point
5252: hz_contact_point_v2pub.update_edi_contact_point(

Line 5253: p_init_msg_list => fnd_api.g_false,

5249: END IF;
5250:
5251: -- update the EDI contact point
5252: hz_contact_point_v2pub.update_edi_contact_point(
5253: p_init_msg_list => fnd_api.g_false,
5254: p_contact_point_rec => p_contact_point_rec,
5255: p_edi_rec => p_edi_rec,
5256: p_object_version_number => p_object_version_number,
5257: x_return_status => x_return_status,

Line 5263: IF x_return_status <> fnd_api.g_ret_sts_success THEN

5259: x_msg_data => x_msg_data
5260: );
5261:
5262: -- raise an exception if the banking group creation is unsuccessful
5263: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5264: RAISE fnd_api.g_exc_error;
5265: END IF;
5266:
5267: -- Debug info.

Line 5264: RAISE fnd_api.g_exc_error;

5260: );
5261:
5262: -- raise an exception if the banking group creation is unsuccessful
5263: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5264: RAISE fnd_api.g_exc_error;
5265: END IF;
5266:
5267: -- Debug info.
5268: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5277: WHEN fnd_api.g_exc_error THEN

5273:
5274: -- disable the debug procedure before exiting.
5275: --disable_debug;
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,

Line 5279: x_return_status := fnd_api.g_ret_sts_error;

5275: --disable_debug;
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:

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 5300: WHEN fnd_api.g_exc_unexpected_error THEN

5296:
5297: -- Check if API is called in debug mode. If yes, disable debug.
5298: --disable_debug;
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,

Line 5302: x_return_status := fnd_api.g_ret_sts_unexp_error;

5298: --disable_debug;
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:

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 5325: x_return_status := fnd_api.g_ret_sts_unexp_error;

5321: --disable_debug;
5322:
5323: WHEN OTHERS THEN
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,

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 5363: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |

5359: | |
5360: | ARGUMENTS |
5361: | IN: |
5362: | p_init_msg_list Initialize message stack if it is set to |
5363: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
5364: | p_contact_point_rec Contact point record. |
5365: | p_eft_rec EFT record. |
5366: | IN/OUT: |
5367: | OUT: |

Line 5372: | be FND_API.G_RET_STS_SUCCESS (success), |

5368: | x_contact_point_id ID of the contact point created. |
5369: | x_party_number Party number for the party created for the |
5370: | relationship. |
5371: | x_return_status Return status after the call. The status can |
5372: | be FND_API.G_RET_STS_SUCCESS (success), |
5373: | fnd_api.g_ret_sts_error (error), |
5374: | fnd_api.g_ret_sts_unexp_error (unexpected |
5375: | error). |
5376: | x_msg_count Number of messages in message stack. |

Line 5373: | fnd_api.g_ret_sts_error (error), |

5369: | x_party_number Party number for the party created for the |
5370: | relationship. |
5371: | x_return_status Return status after the call. The status can |
5372: | be FND_API.G_RET_STS_SUCCESS (success), |
5373: | fnd_api.g_ret_sts_error (error), |
5374: | fnd_api.g_ret_sts_unexp_error (unexpected |
5375: | error). |
5376: | x_msg_count Number of messages in message stack. |
5377: | x_msg_data Message text if x_msg_count is 1. |

Line 5374: | fnd_api.g_ret_sts_unexp_error (unexpected |

5370: | relationship. |
5371: | x_return_status Return status after the call. The status can |
5372: | be FND_API.G_RET_STS_SUCCESS (success), |
5373: | fnd_api.g_ret_sts_error (error), |
5374: | fnd_api.g_ret_sts_unexp_error (unexpected |
5375: | error). |
5376: | x_msg_count Number of messages in message stack. |
5377: | x_msg_data Message text if x_msg_count is 1. |
5378: | MODIFICATION HISTORY |

Line 5382: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

5378: | MODIFICATION HISTORY |
5379: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
5380: +=======================================================================*/
5381: PROCEDURE create_eft_contact_point (
5382: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5383: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5384: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type
5385: := hz_contact_point_v2pub.g_miss_eft_rec,
5386: x_contact_point_id OUT NOCOPY NUMBER,

Line 5407: x_return_status := fnd_api.g_ret_sts_success;

5403: p_msg_level=>fnd_log.level_procedure);
5404: END IF;
5405:
5406: -- initialize API return status to success.
5407: x_return_status := fnd_api.g_ret_sts_success;
5408:
5409: --
5410: -- execute business logic
5411: --

Line 5419: IF x_return_status <> fnd_api.g_ret_sts_success THEN

5415: p_eft_rec,
5416: x_return_status);
5417:
5418: -- raise an exception if the validation routine is unsuccessful
5419: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5420: RAISE fnd_api.g_exc_error;
5421: END IF;
5422:
5423: -- create the EFT contact point

Line 5420: RAISE fnd_api.g_exc_error;

5416: x_return_status);
5417:
5418: -- raise an exception if the validation routine is unsuccessful
5419: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5420: RAISE fnd_api.g_exc_error;
5421: END IF;
5422:
5423: -- create the EFT contact point
5424: hz_contact_point_v2pub.create_eft_contact_point(

Line 5425: p_init_msg_list => fnd_api.g_false,

5421: END IF;
5422:
5423: -- create the EFT contact point
5424: hz_contact_point_v2pub.create_eft_contact_point(
5425: p_init_msg_list => fnd_api.g_false,
5426: p_contact_point_rec => p_contact_point_rec,
5427: p_eft_rec => p_eft_rec,
5428: x_contact_point_id => x_contact_point_id,
5429: x_return_status => x_return_status,

Line 5435: IF x_return_status <> fnd_api.g_ret_sts_success THEN

5431: x_msg_data => x_msg_data
5432: );
5433:
5434: -- raise an exception if the banking group creation is unsuccessful
5435: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5436: RAISE fnd_api.g_exc_error;
5437: END IF;
5438:
5439: -- Debug info.

Line 5436: RAISE fnd_api.g_exc_error;

5432: );
5433:
5434: -- raise an exception if the banking group creation is unsuccessful
5435: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5436: RAISE fnd_api.g_exc_error;
5437: END IF;
5438:
5439: -- Debug info.
5440: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5449: WHEN fnd_api.g_exc_error THEN

5445:
5446: -- disable the debug procedure before exiting.
5447: --disable_debug;
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,

Line 5451: x_return_status := fnd_api.g_ret_sts_error;

5447: --disable_debug;
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:

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 5472: WHEN fnd_api.g_exc_unexpected_error THEN

5468:
5469: -- Check if API is called in debug mode. If yes, disable debug.
5470: --disable_debug;
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,

Line 5474: x_return_status := fnd_api.g_ret_sts_unexp_error;

5470: --disable_debug;
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:

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 5497: x_return_status := fnd_api.g_ret_sts_unexp_error;

5493: --disable_debug;
5494:
5495: WHEN OTHERS THEN
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,

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 5535: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |

5531: | |
5532: | ARGUMENTS |
5533: | IN: |
5534: | p_init_msg_list Initialize message stack if it is set to |
5535: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
5536: | p_contact_point_rec Contact point record. |
5537: | p_eft_rec EFT record. |
5538: | IN/OUT: |
5539: | p_object_version_number Used to lock the record being updated. |

Line 5544: | be FND_API.G_RET_STS_SUCCESS (success), |

5540: | OUT: |
5541: | x_party_number Party number for the party created for the |
5542: | relationship. |
5543: | x_return_status Return status after the call. The status can |
5544: | be FND_API.G_RET_STS_SUCCESS (success), |
5545: | fnd_api.g_ret_sts_error (error), |
5546: | fnd_api.g_ret_sts_unexp_error (unexpected |
5547: | error). |
5548: | x_msg_count Number of messages in message stack. |

Line 5545: | fnd_api.g_ret_sts_error (error), |

5541: | x_party_number Party number for the party created for the |
5542: | relationship. |
5543: | x_return_status Return status after the call. The status can |
5544: | be FND_API.G_RET_STS_SUCCESS (success), |
5545: | fnd_api.g_ret_sts_error (error), |
5546: | fnd_api.g_ret_sts_unexp_error (unexpected |
5547: | error). |
5548: | x_msg_count Number of messages in message stack. |
5549: | x_msg_data Message text if x_msg_count is 1. |

Line 5546: | fnd_api.g_ret_sts_unexp_error (unexpected |

5542: | relationship. |
5543: | x_return_status Return status after the call. The status can |
5544: | be FND_API.G_RET_STS_SUCCESS (success), |
5545: | fnd_api.g_ret_sts_error (error), |
5546: | fnd_api.g_ret_sts_unexp_error (unexpected |
5547: | error). |
5548: | x_msg_count Number of messages in message stack. |
5549: | x_msg_data Message text if x_msg_count is 1. |
5550: | MODIFICATION HISTORY |

Line 5554: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

5550: | MODIFICATION HISTORY |
5551: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
5552: +=======================================================================*/
5553: PROCEDURE update_eft_contact_point (
5554: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5555: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5556: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type
5557: := hz_contact_point_v2pub.g_miss_eft_rec,
5558: p_object_version_number IN OUT NOCOPY NUMBER,

Line 5579: x_return_status := fnd_api.g_ret_sts_success;

5575: p_msg_level=>fnd_log.level_procedure);
5576: END IF;
5577:
5578: -- initialize API return status to success.
5579: x_return_status := fnd_api.g_ret_sts_success;
5580:
5581: --
5582: -- execute business logic
5583: --

Line 5591: IF x_return_status <> fnd_api.g_ret_sts_success THEN

5587: p_eft_rec,
5588: x_return_status);
5589:
5590: -- raise an exception if the validation routine is unsuccessful
5591: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5592: RAISE fnd_api.g_exc_error;
5593: END IF;
5594:
5595: -- update the EFT contact point

Line 5592: RAISE fnd_api.g_exc_error;

5588: x_return_status);
5589:
5590: -- raise an exception if the validation routine is unsuccessful
5591: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5592: RAISE fnd_api.g_exc_error;
5593: END IF;
5594:
5595: -- update the EFT contact point
5596: hz_contact_point_v2pub.update_eft_contact_point(

Line 5597: p_init_msg_list => fnd_api.g_false,

5593: END IF;
5594:
5595: -- update the EFT contact point
5596: hz_contact_point_v2pub.update_eft_contact_point(
5597: p_init_msg_list => fnd_api.g_false,
5598: p_contact_point_rec => p_contact_point_rec,
5599: p_eft_rec => p_eft_rec,
5600: p_object_version_number => p_object_version_number,
5601: x_return_status => x_return_status,

Line 5607: IF x_return_status <> fnd_api.g_ret_sts_success THEN

5603: x_msg_data => x_msg_data
5604: );
5605:
5606: -- raise an exception if the banking group creation is unsuccessful
5607: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5608: RAISE fnd_api.g_exc_error;
5609: END IF;
5610:
5611: -- Debug info.

Line 5608: RAISE fnd_api.g_exc_error;

5604: );
5605:
5606: -- raise an exception if the banking group creation is unsuccessful
5607: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5608: RAISE fnd_api.g_exc_error;
5609: END IF;
5610:
5611: -- Debug info.
5612: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5621: WHEN fnd_api.g_exc_error THEN

5617:
5618: -- disable the debug procedure before exiting.
5619: --disable_debug;
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,

Line 5623: x_return_status := fnd_api.g_ret_sts_error;

5619: --disable_debug;
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:

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 5644: WHEN fnd_api.g_exc_unexpected_error THEN

5640:
5641: -- Check if API is called in debug mode. If yes, disable debug.
5642: --disable_debug;
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,

Line 5646: x_return_status := fnd_api.g_ret_sts_unexp_error;

5642: --disable_debug;
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:

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 5669: x_return_status := fnd_api.g_ret_sts_unexp_error;

5665: --disable_debug;
5666:
5667: WHEN OTHERS THEN
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,

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 5707: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |

5703: | |
5704: | ARGUMENTS |
5705: | IN: |
5706: | p_init_msg_list Initialize message stack if it is set to |
5707: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
5708: | p_contact_point_rec Contact point record. |
5709: | p_web_rec WEB record. |
5710: | IN/OUT: |
5711: | OUT: |

Line 5716: | be FND_API.G_RET_STS_SUCCESS (success), |

5712: | x_contact_point_id ID of the contact point created. |
5713: | x_party_number Party number for the party created for the |
5714: | relationship. |
5715: | x_return_status Return status after the call. The status can |
5716: | be FND_API.G_RET_STS_SUCCESS (success), |
5717: | fnd_api.g_ret_sts_error (error), |
5718: | fnd_api.g_ret_sts_unexp_error (unexpected |
5719: | error). |
5720: | x_msg_count Number of messages in message stack. |

Line 5717: | fnd_api.g_ret_sts_error (error), |

5713: | x_party_number Party number for the party created for the |
5714: | relationship. |
5715: | x_return_status Return status after the call. The status can |
5716: | be FND_API.G_RET_STS_SUCCESS (success), |
5717: | fnd_api.g_ret_sts_error (error), |
5718: | fnd_api.g_ret_sts_unexp_error (unexpected |
5719: | error). |
5720: | x_msg_count Number of messages in message stack. |
5721: | x_msg_data Message text if x_msg_count is 1. |

Line 5718: | fnd_api.g_ret_sts_unexp_error (unexpected |

5714: | relationship. |
5715: | x_return_status Return status after the call. The status can |
5716: | be FND_API.G_RET_STS_SUCCESS (success), |
5717: | fnd_api.g_ret_sts_error (error), |
5718: | fnd_api.g_ret_sts_unexp_error (unexpected |
5719: | error). |
5720: | x_msg_count Number of messages in message stack. |
5721: | x_msg_data Message text if x_msg_count is 1. |
5722: | MODIFICATION HISTORY |

Line 5726: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

5722: | MODIFICATION HISTORY |
5723: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
5724: +=======================================================================*/
5725: PROCEDURE create_web_contact_point (
5726: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5727: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5728: p_web_rec IN hz_contact_point_v2pub.web_rec_type
5729: := hz_contact_point_v2pub.g_miss_web_rec,
5730: x_contact_point_id OUT NOCOPY NUMBER,

Line 5751: x_return_status := fnd_api.g_ret_sts_success;

5747: p_msg_level=>fnd_log.level_procedure);
5748: END IF;
5749:
5750: -- initialize API return status to success.
5751: x_return_status := fnd_api.g_ret_sts_success;
5752:
5753: --
5754: -- execute business logic
5755: --

Line 5763: IF x_return_status <> fnd_api.g_ret_sts_success THEN

5759: p_web_rec,
5760: x_return_status);
5761:
5762: -- raise an exception if the validation routine is unsuccessful
5763: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5764: RAISE fnd_api.g_exc_error;
5765: END IF;
5766:
5767: -- create the WEB contact point

Line 5764: RAISE fnd_api.g_exc_error;

5760: x_return_status);
5761:
5762: -- raise an exception if the validation routine is unsuccessful
5763: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5764: RAISE fnd_api.g_exc_error;
5765: END IF;
5766:
5767: -- create the WEB contact point
5768: hz_contact_point_v2pub.create_web_contact_point(

Line 5769: p_init_msg_list => fnd_api.g_false,

5765: END IF;
5766:
5767: -- create the WEB contact point
5768: hz_contact_point_v2pub.create_web_contact_point(
5769: p_init_msg_list => fnd_api.g_false,
5770: p_contact_point_rec => p_contact_point_rec,
5771: p_web_rec => p_web_rec,
5772: x_contact_point_id => x_contact_point_id,
5773: x_return_status => x_return_status,

Line 5779: IF x_return_status <> fnd_api.g_ret_sts_success THEN

5775: x_msg_data => x_msg_data
5776: );
5777:
5778: -- raise an exception if the banking group creation is unsuccessful
5779: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5780: RAISE fnd_api.g_exc_error;
5781: END IF;
5782:
5783: -- Debug info.

Line 5780: RAISE fnd_api.g_exc_error;

5776: );
5777:
5778: -- raise an exception if the banking group creation is unsuccessful
5779: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5780: RAISE fnd_api.g_exc_error;
5781: END IF;
5782:
5783: -- Debug info.
5784: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5793: WHEN fnd_api.g_exc_error THEN

5789:
5790: -- disable the debug procedure before exiting.
5791: --disable_debug;
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,

Line 5795: x_return_status := fnd_api.g_ret_sts_error;

5791: --disable_debug;
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:

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 5816: WHEN fnd_api.g_exc_unexpected_error THEN

5812:
5813: -- Check if API is called in debug mode. If yes, disable debug.
5814: --disable_debug;
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,

Line 5818: x_return_status := fnd_api.g_ret_sts_unexp_error;

5814: --disable_debug;
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:

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 5841: x_return_status := fnd_api.g_ret_sts_unexp_error;

5837: --disable_debug;
5838:
5839: WHEN OTHERS THEN
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,

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 5879: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |

5875: | |
5876: | ARGUMENTS |
5877: | IN: |
5878: | p_init_msg_list Initialize message stack if it is set to |
5879: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
5880: | p_contact_point_rec Contact point record. |
5881: | p_web_rec WEB record. |
5882: | IN/OUT: |
5883: | p_object_version_number Used to lock the record being updated. |

Line 5888: | be FND_API.G_RET_STS_SUCCESS (success), |

5884: | OUT: |
5885: | x_party_number Party number for the party created for the |
5886: | relationship. |
5887: | x_return_status Return status after the call. The status can |
5888: | be FND_API.G_RET_STS_SUCCESS (success), |
5889: | fnd_api.g_ret_sts_error (error), |
5890: | fnd_api.g_ret_sts_unexp_error (unexpected |
5891: | error). |
5892: | x_msg_count Number of messages in message stack. |

Line 5889: | fnd_api.g_ret_sts_error (error), |

5885: | x_party_number Party number for the party created for the |
5886: | relationship. |
5887: | x_return_status Return status after the call. The status can |
5888: | be FND_API.G_RET_STS_SUCCESS (success), |
5889: | fnd_api.g_ret_sts_error (error), |
5890: | fnd_api.g_ret_sts_unexp_error (unexpected |
5891: | error). |
5892: | x_msg_count Number of messages in message stack. |
5893: | x_msg_data Message text if x_msg_count is 1. |

Line 5890: | fnd_api.g_ret_sts_unexp_error (unexpected |

5886: | relationship. |
5887: | x_return_status Return status after the call. The status can |
5888: | be FND_API.G_RET_STS_SUCCESS (success), |
5889: | fnd_api.g_ret_sts_error (error), |
5890: | fnd_api.g_ret_sts_unexp_error (unexpected |
5891: | error). |
5892: | x_msg_count Number of messages in message stack. |
5893: | x_msg_data Message text if x_msg_count is 1. |
5894: | MODIFICATION HISTORY |

Line 5898: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

5894: | MODIFICATION HISTORY |
5895: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
5896: +=======================================================================*/
5897: PROCEDURE update_web_contact_point (
5898: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5899: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5900: p_web_rec IN hz_contact_point_v2pub.web_rec_type
5901: := hz_contact_point_v2pub.g_miss_web_rec,
5902: p_object_version_number IN OUT NOCOPY NUMBER,

Line 5923: x_return_status := fnd_api.g_ret_sts_success;

5919: p_msg_level=>fnd_log.level_procedure);
5920: END IF;
5921:
5922: -- initialize API return status to success.
5923: x_return_status := fnd_api.g_ret_sts_success;
5924:
5925: --
5926: -- execute business logic
5927: --

Line 5935: IF x_return_status <> fnd_api.g_ret_sts_success THEN

5931: p_web_rec,
5932: x_return_status);
5933:
5934: -- raise an exception if the validation routine is unsuccessful
5935: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5936: RAISE fnd_api.g_exc_error;
5937: END IF;
5938:
5939: -- update the WEB contact point

Line 5936: RAISE fnd_api.g_exc_error;

5932: x_return_status);
5933:
5934: -- raise an exception if the validation routine is unsuccessful
5935: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5936: RAISE fnd_api.g_exc_error;
5937: END IF;
5938:
5939: -- update the WEB contact point
5940: hz_contact_point_v2pub.update_web_contact_point(

Line 5941: p_init_msg_list => fnd_api.g_false,

5937: END IF;
5938:
5939: -- update the WEB contact point
5940: hz_contact_point_v2pub.update_web_contact_point(
5941: p_init_msg_list => fnd_api.g_false,
5942: p_contact_point_rec => p_contact_point_rec,
5943: p_web_rec => p_web_rec,
5944: p_object_version_number => p_object_version_number,
5945: x_return_status => x_return_status,

Line 5951: IF x_return_status <> fnd_api.g_ret_sts_success THEN

5947: x_msg_data => x_msg_data
5948: );
5949:
5950: -- raise an exception if the banking group creation is unsuccessful
5951: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5952: RAISE fnd_api.g_exc_error;
5953: END IF;
5954:
5955: -- Debug info.

Line 5952: RAISE fnd_api.g_exc_error;

5948: );
5949:
5950: -- raise an exception if the banking group creation is unsuccessful
5951: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5952: RAISE fnd_api.g_exc_error;
5953: END IF;
5954:
5955: -- Debug info.
5956: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5965: WHEN fnd_api.g_exc_error THEN

5961:
5962: -- disable the debug procedure before exiting.
5963: --disable_debug;
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,

Line 5967: x_return_status := fnd_api.g_ret_sts_error;

5963: --disable_debug;
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:

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 5988: WHEN fnd_api.g_exc_unexpected_error THEN

5984:
5985: -- Check if API is called in debug mode. If yes, disable debug.
5986: --disable_debug;
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,

Line 5990: x_return_status := fnd_api.g_ret_sts_unexp_error;

5986: --disable_debug;
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:

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 6013: x_return_status := fnd_api.g_ret_sts_unexp_error;

6009: --disable_debug;
6010:
6011: WHEN OTHERS THEN
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,

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 6051: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |

6047: | |
6048: | ARGUMENTS |
6049: | IN: |
6050: | p_init_msg_list Initialize message stack if it is set to |
6051: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
6052: | p_contact_point_rec Contact point record. |
6053: | p_phone_rec PHONE record. |
6054: | IN/OUT: |
6055: | OUT: |

Line 6060: | be FND_API.G_RET_STS_SUCCESS (success), |

6056: | x_contact_point_id ID of the contact point created. |
6057: | x_party_number Party number for the party created for the |
6058: | relationship. |
6059: | x_return_status Return status after the call. The status can |
6060: | be FND_API.G_RET_STS_SUCCESS (success), |
6061: | fnd_api.g_ret_sts_error (error), |
6062: | fnd_api.g_ret_sts_unexp_error (unexpected |
6063: | error). |
6064: | x_msg_count Number of messages in message stack. |

Line 6061: | fnd_api.g_ret_sts_error (error), |

6057: | x_party_number Party number for the party created for the |
6058: | relationship. |
6059: | x_return_status Return status after the call. The status can |
6060: | be FND_API.G_RET_STS_SUCCESS (success), |
6061: | fnd_api.g_ret_sts_error (error), |
6062: | fnd_api.g_ret_sts_unexp_error (unexpected |
6063: | error). |
6064: | x_msg_count Number of messages in message stack. |
6065: | x_msg_data Message text if x_msg_count is 1. |

Line 6062: | fnd_api.g_ret_sts_unexp_error (unexpected |

6058: | relationship. |
6059: | x_return_status Return status after the call. The status can |
6060: | be FND_API.G_RET_STS_SUCCESS (success), |
6061: | fnd_api.g_ret_sts_error (error), |
6062: | fnd_api.g_ret_sts_unexp_error (unexpected |
6063: | error). |
6064: | x_msg_count Number of messages in message stack. |
6065: | x_msg_data Message text if x_msg_count is 1. |
6066: | MODIFICATION HISTORY |

Line 6070: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

6066: | MODIFICATION HISTORY |
6067: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
6068: +=======================================================================*/
6069: PROCEDURE create_phone_contact_point (
6070: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6071: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6072: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type
6073: := hz_contact_point_v2pub.g_miss_phone_rec,
6074: x_contact_point_id OUT NOCOPY NUMBER,

Line 6095: x_return_status := fnd_api.g_ret_sts_success;

6091: p_msg_level=>fnd_log.level_procedure);
6092: END IF;
6093:
6094: -- initialize API return status to success.
6095: x_return_status := fnd_api.g_ret_sts_success;
6096:
6097: --
6098: -- execute business logic
6099: --

Line 6107: IF x_return_status <> fnd_api.g_ret_sts_success THEN

6103: p_phone_rec,
6104: x_return_status);
6105:
6106: -- raise an exception if the validation routine is unsuccessful
6107: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6108: RAISE fnd_api.g_exc_error;
6109: END IF;
6110:
6111: -- create the Phone contact point

Line 6108: RAISE fnd_api.g_exc_error;

6104: x_return_status);
6105:
6106: -- raise an exception if the validation routine is unsuccessful
6107: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6108: RAISE fnd_api.g_exc_error;
6109: END IF;
6110:
6111: -- create the Phone contact point
6112: hz_contact_point_v2pub.create_phone_contact_point(

Line 6113: p_init_msg_list => fnd_api.g_false,

6109: END IF;
6110:
6111: -- create the Phone contact point
6112: hz_contact_point_v2pub.create_phone_contact_point(
6113: p_init_msg_list => fnd_api.g_false,
6114: p_contact_point_rec => p_contact_point_rec,
6115: p_phone_rec => p_phone_rec,
6116: x_contact_point_id => x_contact_point_id,
6117: x_return_status => x_return_status,

Line 6123: IF x_return_status <> fnd_api.g_ret_sts_success THEN

6119: x_msg_data => x_msg_data
6120: );
6121:
6122: -- raise an exception if the banking group creation is unsuccessful
6123: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6124: RAISE fnd_api.g_exc_error;
6125: END IF;
6126:
6127: -- Debug info.

Line 6124: RAISE fnd_api.g_exc_error;

6120: );
6121:
6122: -- raise an exception if the banking group creation is unsuccessful
6123: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6124: RAISE fnd_api.g_exc_error;
6125: END IF;
6126:
6127: -- Debug info.
6128: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 6137: WHEN fnd_api.g_exc_error THEN

6133:
6134: -- disable the debug procedure before exiting.
6135: --disable_debug;
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,

Line 6139: x_return_status := fnd_api.g_ret_sts_error;

6135: --disable_debug;
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:

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 6160: WHEN fnd_api.g_exc_unexpected_error THEN

6156:
6157: -- Check if API is called in debug mode. If yes, disable debug.
6158: --disable_debug;
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,

Line 6162: x_return_status := fnd_api.g_ret_sts_unexp_error;

6158: --disable_debug;
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:

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 6185: x_return_status := fnd_api.g_ret_sts_unexp_error;

6181: --disable_debug;
6182:
6183: WHEN OTHERS THEN
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,

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 6223: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |

6219: | |
6220: | ARGUMENTS |
6221: | IN: |
6222: | p_init_msg_list Initialize message stack if it is set to |
6223: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
6224: | p_contact_point_rec Contact point record. |
6225: | p_phone_rec PHONE record. |
6226: | IN/OUT: |
6227: | p_object_version_number Used to lock the record being updated. |

Line 6232: | be FND_API.G_RET_STS_SUCCESS (success), |

6228: | OUT: |
6229: | x_party_number Party number for the party created for the |
6230: | relationship. |
6231: | x_return_status Return status after the call. The status can |
6232: | be FND_API.G_RET_STS_SUCCESS (success), |
6233: | fnd_api.g_ret_sts_error (error), |
6234: | fnd_api.g_ret_sts_unexp_error (unexpected |
6235: | error). |
6236: | x_msg_count Number of messages in message stack. |

Line 6233: | fnd_api.g_ret_sts_error (error), |

6229: | x_party_number Party number for the party created for the |
6230: | relationship. |
6231: | x_return_status Return status after the call. The status can |
6232: | be FND_API.G_RET_STS_SUCCESS (success), |
6233: | fnd_api.g_ret_sts_error (error), |
6234: | fnd_api.g_ret_sts_unexp_error (unexpected |
6235: | error). |
6236: | x_msg_count Number of messages in message stack. |
6237: | x_msg_data Message text if x_msg_count is 1. |

Line 6234: | fnd_api.g_ret_sts_unexp_error (unexpected |

6230: | relationship. |
6231: | x_return_status Return status after the call. The status can |
6232: | be FND_API.G_RET_STS_SUCCESS (success), |
6233: | fnd_api.g_ret_sts_error (error), |
6234: | fnd_api.g_ret_sts_unexp_error (unexpected |
6235: | error). |
6236: | x_msg_count Number of messages in message stack. |
6237: | x_msg_data Message text if x_msg_count is 1. |
6238: | MODIFICATION HISTORY |

Line 6242: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

6238: | MODIFICATION HISTORY |
6239: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
6240: +=======================================================================*/
6241: PROCEDURE update_phone_contact_point (
6242: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6243: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6244: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type
6245: := hz_contact_point_v2pub.g_miss_phone_rec,
6246: p_object_version_number IN OUT NOCOPY NUMBER,

Line 6267: x_return_status := fnd_api.g_ret_sts_success;

6263: p_msg_level=>fnd_log.level_procedure);
6264: END IF;
6265:
6266: -- initialize API return status to success.
6267: x_return_status := fnd_api.g_ret_sts_success;
6268:
6269: --
6270: -- execute business logic
6271: --

Line 6279: IF x_return_status <> fnd_api.g_ret_sts_success THEN

6275: p_phone_rec,
6276: x_return_status);
6277:
6278: -- raise an exception if the validation routine is unsuccessful
6279: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6280: RAISE fnd_api.g_exc_error;
6281: END IF;
6282:
6283: -- update the Phone contact point

Line 6280: RAISE fnd_api.g_exc_error;

6276: x_return_status);
6277:
6278: -- raise an exception if the validation routine is unsuccessful
6279: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6280: RAISE fnd_api.g_exc_error;
6281: END IF;
6282:
6283: -- update the Phone contact point
6284: hz_contact_point_v2pub.update_phone_contact_point(

Line 6285: p_init_msg_list => fnd_api.g_false,

6281: END IF;
6282:
6283: -- update the Phone contact point
6284: hz_contact_point_v2pub.update_phone_contact_point(
6285: p_init_msg_list => fnd_api.g_false,
6286: p_contact_point_rec => p_contact_point_rec,
6287: p_phone_rec => p_phone_rec,
6288: p_object_version_number => p_object_version_number,
6289: x_return_status => x_return_status,

Line 6295: IF x_return_status <> fnd_api.g_ret_sts_success THEN

6291: x_msg_data => x_msg_data
6292: );
6293:
6294: -- raise an exception if the banking group creation is unsuccessful
6295: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6296: RAISE fnd_api.g_exc_error;
6297: END IF;
6298:
6299: -- Debug info.

Line 6296: RAISE fnd_api.g_exc_error;

6292: );
6293:
6294: -- raise an exception if the banking group creation is unsuccessful
6295: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6296: RAISE fnd_api.g_exc_error;
6297: END IF;
6298:
6299: -- Debug info.
6300: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 6309: WHEN fnd_api.g_exc_error THEN

6305:
6306: -- disable the debug procedure before exiting.
6307: --disable_debug;
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,

Line 6311: x_return_status := fnd_api.g_ret_sts_error;

6307: --disable_debug;
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:

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 6332: WHEN fnd_api.g_exc_unexpected_error THEN

6328:
6329: -- Check if API is called in debug mode. If yes, disable debug.
6330: --disable_debug;
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,

Line 6334: x_return_status := fnd_api.g_ret_sts_unexp_error;

6330: --disable_debug;
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:

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 6357: x_return_status := fnd_api.g_ret_sts_unexp_error;

6353: --disable_debug;
6354:
6355: WHEN OTHERS THEN
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,

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 6395: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |

6391: | |
6392: | ARGUMENTS |
6393: | IN: |
6394: | p_init_msg_list Initialize message stack if it is set to |
6395: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
6396: | p_contact_point_rec Contact point record. |
6397: | p_email_rec EMAIL record. |
6398: | IN/OUT: |
6399: | OUT: |

Line 6404: | be FND_API.G_RET_STS_SUCCESS (success), |

6400: | x_contact_point_id ID of the contact point created. |
6401: | x_party_number Party number for the party created for the |
6402: | relationship. |
6403: | x_return_status Return status after the call. The status can |
6404: | be FND_API.G_RET_STS_SUCCESS (success), |
6405: | fnd_api.g_ret_sts_error (error), |
6406: | fnd_api.g_ret_sts_unexp_error (unexpected |
6407: | error). |
6408: | x_msg_count Number of messages in message stack. |

Line 6405: | fnd_api.g_ret_sts_error (error), |

6401: | x_party_number Party number for the party created for the |
6402: | relationship. |
6403: | x_return_status Return status after the call. The status can |
6404: | be FND_API.G_RET_STS_SUCCESS (success), |
6405: | fnd_api.g_ret_sts_error (error), |
6406: | fnd_api.g_ret_sts_unexp_error (unexpected |
6407: | error). |
6408: | x_msg_count Number of messages in message stack. |
6409: | x_msg_data Message text if x_msg_count is 1. |

Line 6406: | fnd_api.g_ret_sts_unexp_error (unexpected |

6402: | relationship. |
6403: | x_return_status Return status after the call. The status can |
6404: | be FND_API.G_RET_STS_SUCCESS (success), |
6405: | fnd_api.g_ret_sts_error (error), |
6406: | fnd_api.g_ret_sts_unexp_error (unexpected |
6407: | error). |
6408: | x_msg_count Number of messages in message stack. |
6409: | x_msg_data Message text if x_msg_count is 1. |
6410: | MODIFICATION HISTORY |

Line 6414: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

6410: | MODIFICATION HISTORY |
6411: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
6412: +=======================================================================*/
6413: PROCEDURE create_email_contact_point (
6414: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6415: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6416: p_email_rec IN hz_contact_point_v2pub.email_rec_type
6417: := hz_contact_point_v2pub.g_miss_email_rec,
6418: x_contact_point_id OUT NOCOPY NUMBER,

Line 6439: x_return_status := fnd_api.g_ret_sts_success;

6435: p_msg_level=>fnd_log.level_procedure);
6436: END IF;
6437:
6438: -- initialize API return status to success.
6439: x_return_status := fnd_api.g_ret_sts_success;
6440:
6441: --
6442: -- execute business logic
6443: --

Line 6451: IF x_return_status <> fnd_api.g_ret_sts_success THEN

6447: p_email_rec,
6448: x_return_status);
6449:
6450: -- raise an exception if the validation routine is unsuccessful
6451: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6452: RAISE fnd_api.g_exc_error;
6453: END IF;
6454:
6455: -- create the Email contact point

Line 6452: RAISE fnd_api.g_exc_error;

6448: x_return_status);
6449:
6450: -- raise an exception if the validation routine is unsuccessful
6451: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6452: RAISE fnd_api.g_exc_error;
6453: END IF;
6454:
6455: -- create the Email contact point
6456: hz_contact_point_v2pub.create_email_contact_point(

Line 6457: p_init_msg_list => fnd_api.g_false,

6453: END IF;
6454:
6455: -- create the Email contact point
6456: hz_contact_point_v2pub.create_email_contact_point(
6457: p_init_msg_list => fnd_api.g_false,
6458: p_contact_point_rec => p_contact_point_rec,
6459: p_email_rec => p_email_rec,
6460: x_contact_point_id => x_contact_point_id,
6461: x_return_status => x_return_status,

Line 6467: IF x_return_status <> fnd_api.g_ret_sts_success THEN

6463: x_msg_data => x_msg_data
6464: );
6465:
6466: -- raise an exception if the banking group creation is unsuccessful
6467: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6468: RAISE fnd_api.g_exc_error;
6469: END IF;
6470:
6471: -- Debug info.

Line 6468: RAISE fnd_api.g_exc_error;

6464: );
6465:
6466: -- raise an exception if the banking group creation is unsuccessful
6467: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6468: RAISE fnd_api.g_exc_error;
6469: END IF;
6470:
6471: -- Debug info.
6472: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 6481: WHEN fnd_api.g_exc_error THEN

6477:
6478: -- disable the debug procedure before exiting.
6479: --disable_debug;
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,

Line 6483: x_return_status := fnd_api.g_ret_sts_error;

6479: --disable_debug;
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:

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 6504: WHEN fnd_api.g_exc_unexpected_error THEN

6500:
6501: -- Check if API is called in debug mode. If yes, disable debug.
6502: --disable_debug;
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,

Line 6506: x_return_status := fnd_api.g_ret_sts_unexp_error;

6502: --disable_debug;
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:

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 6529: x_return_status := fnd_api.g_ret_sts_unexp_error;

6525: --disable_debug;
6526:
6527: WHEN OTHERS THEN
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,

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 6567: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |

6563: | |
6564: | ARGUMENTS |
6565: | IN: |
6566: | p_init_msg_list Initialize message stack if it is set to |
6567: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
6568: | p_contact_point_rec Contact point record. |
6569: | p_email_rec EMAIL record. |
6570: | IN/OUT: |
6571: | p_object_version_number Used to lock the record being updated. |

Line 6576: | be FND_API.G_RET_STS_SUCCESS (success), |

6572: | OUT: |
6573: | x_party_number Party number for the party created for the |
6574: | relationship. |
6575: | x_return_status Return status after the call. The status can |
6576: | be FND_API.G_RET_STS_SUCCESS (success), |
6577: | fnd_api.g_ret_sts_error (error), |
6578: | fnd_api.g_ret_sts_unexp_error (unexpected |
6579: | error). |
6580: | x_msg_count Number of messages in message stack. |

Line 6577: | fnd_api.g_ret_sts_error (error), |

6573: | x_party_number Party number for the party created for the |
6574: | relationship. |
6575: | x_return_status Return status after the call. The status can |
6576: | be FND_API.G_RET_STS_SUCCESS (success), |
6577: | fnd_api.g_ret_sts_error (error), |
6578: | fnd_api.g_ret_sts_unexp_error (unexpected |
6579: | error). |
6580: | x_msg_count Number of messages in message stack. |
6581: | x_msg_data Message text if x_msg_count is 1. |

Line 6578: | fnd_api.g_ret_sts_unexp_error (unexpected |

6574: | relationship. |
6575: | x_return_status Return status after the call. The status can |
6576: | be FND_API.G_RET_STS_SUCCESS (success), |
6577: | fnd_api.g_ret_sts_error (error), |
6578: | fnd_api.g_ret_sts_unexp_error (unexpected |
6579: | error). |
6580: | x_msg_count Number of messages in message stack. |
6581: | x_msg_data Message text if x_msg_count is 1. |
6582: | MODIFICATION HISTORY |

Line 6586: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

6582: | MODIFICATION HISTORY |
6583: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
6584: +=======================================================================*/
6585: PROCEDURE update_email_contact_point (
6586: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6587: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6588: p_email_rec IN hz_contact_point_v2pub.email_rec_type
6589: := hz_contact_point_v2pub.g_miss_email_rec,
6590: p_object_version_number IN OUT NOCOPY NUMBER,

Line 6611: x_return_status := fnd_api.g_ret_sts_success;

6607: p_msg_level=>fnd_log.level_procedure);
6608: END IF;
6609:
6610: -- initialize API return status to success.
6611: x_return_status := fnd_api.g_ret_sts_success;
6612:
6613: --
6614: -- execute business logic
6615: --

Line 6623: IF x_return_status <> fnd_api.g_ret_sts_success THEN

6619: p_email_rec,
6620: x_return_status);
6621:
6622: -- raise an exception if the validation routine is unsuccessful
6623: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6624: RAISE fnd_api.g_exc_error;
6625: END IF;
6626:
6627: -- update the Email contact point

Line 6624: RAISE fnd_api.g_exc_error;

6620: x_return_status);
6621:
6622: -- raise an exception if the validation routine is unsuccessful
6623: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6624: RAISE fnd_api.g_exc_error;
6625: END IF;
6626:
6627: -- update the Email contact point
6628: hz_contact_point_v2pub.update_email_contact_point(

Line 6629: p_init_msg_list => fnd_api.g_false,

6625: END IF;
6626:
6627: -- update the Email contact point
6628: hz_contact_point_v2pub.update_email_contact_point(
6629: p_init_msg_list => fnd_api.g_false,
6630: p_contact_point_rec => p_contact_point_rec,
6631: p_email_rec => p_email_rec,
6632: p_object_version_number => p_object_version_number,
6633: x_return_status => x_return_status,

Line 6639: IF x_return_status <> fnd_api.g_ret_sts_success THEN

6635: x_msg_data => x_msg_data
6636: );
6637:
6638: -- raise an exception if the banking group creation is unsuccessful
6639: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6640: RAISE fnd_api.g_exc_error;
6641: END IF;
6642:
6643: -- Debug info.

Line 6640: RAISE fnd_api.g_exc_error;

6636: );
6637:
6638: -- raise an exception if the banking group creation is unsuccessful
6639: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6640: RAISE fnd_api.g_exc_error;
6641: END IF;
6642:
6643: -- Debug info.
6644: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 6653: WHEN fnd_api.g_exc_error THEN

6649:
6650: -- disable the debug procedure before exiting.
6651: --disable_debug;
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,

Line 6655: x_return_status := fnd_api.g_ret_sts_error;

6651: --disable_debug;
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:

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 6676: WHEN fnd_api.g_exc_unexpected_error THEN

6672:
6673: -- Check if API is called in debug mode. If yes, disable debug.
6674: --disable_debug;
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,

Line 6678: x_return_status := fnd_api.g_ret_sts_unexp_error;

6674: --disable_debug;
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:

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 6701: x_return_status := fnd_api.g_ret_sts_unexp_error;

6697: --disable_debug;
6698:
6699: WHEN OTHERS THEN
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,

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 6739: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |

6735: | |
6736: | ARGUMENTS |
6737: | IN: |
6738: | p_init_msg_list Initialize message stack if it is set to |
6739: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
6740: | p_contact_point_rec Contact point record. |
6741: | p_telex_rec TELEX record. |
6742: | IN/OUT: |
6743: | OUT: |

Line 6748: | be FND_API.G_RET_STS_SUCCESS (success), |

6744: | x_contact_point_id ID of the contact point created. |
6745: | x_party_number Party number for the party created for the |
6746: | relationship. |
6747: | x_return_status Return status after the call. The status can |
6748: | be FND_API.G_RET_STS_SUCCESS (success), |
6749: | fnd_api.g_ret_sts_error (error), |
6750: | fnd_api.g_ret_sts_unexp_error (unexpected |
6751: | error). |
6752: | x_msg_count Number of messages in message stack. |

Line 6749: | fnd_api.g_ret_sts_error (error), |

6745: | x_party_number Party number for the party created for the |
6746: | relationship. |
6747: | x_return_status Return status after the call. The status can |
6748: | be FND_API.G_RET_STS_SUCCESS (success), |
6749: | fnd_api.g_ret_sts_error (error), |
6750: | fnd_api.g_ret_sts_unexp_error (unexpected |
6751: | error). |
6752: | x_msg_count Number of messages in message stack. |
6753: | x_msg_data Message text if x_msg_count is 1. |

Line 6750: | fnd_api.g_ret_sts_unexp_error (unexpected |

6746: | relationship. |
6747: | x_return_status Return status after the call. The status can |
6748: | be FND_API.G_RET_STS_SUCCESS (success), |
6749: | fnd_api.g_ret_sts_error (error), |
6750: | fnd_api.g_ret_sts_unexp_error (unexpected |
6751: | error). |
6752: | x_msg_count Number of messages in message stack. |
6753: | x_msg_data Message text if x_msg_count is 1. |
6754: | MODIFICATION HISTORY |

Line 6758: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

6754: | MODIFICATION HISTORY |
6755: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
6756: +=======================================================================*/
6757: PROCEDURE create_telex_contact_point (
6758: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6759: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6760: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type
6761: := hz_contact_point_v2pub.g_miss_telex_rec,
6762: x_contact_point_id OUT NOCOPY NUMBER,

Line 6783: x_return_status := fnd_api.g_ret_sts_success;

6779: p_msg_level=>fnd_log.level_procedure);
6780: END IF;
6781:
6782: -- initialize API return status to success.
6783: x_return_status := fnd_api.g_ret_sts_success;
6784:
6785: --
6786: -- execute business logic
6787: --

Line 6795: IF x_return_status <> fnd_api.g_ret_sts_success THEN

6791: p_telex_rec,
6792: x_return_status);
6793:
6794: -- raise an exception if the validation routine is unsuccessful
6795: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6796: RAISE fnd_api.g_exc_error;
6797: END IF;
6798:
6799: -- create the Telex contact point

Line 6796: RAISE fnd_api.g_exc_error;

6792: x_return_status);
6793:
6794: -- raise an exception if the validation routine is unsuccessful
6795: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6796: RAISE fnd_api.g_exc_error;
6797: END IF;
6798:
6799: -- create the Telex contact point
6800: hz_contact_point_v2pub.create_telex_contact_point(

Line 6801: p_init_msg_list => fnd_api.g_false,

6797: END IF;
6798:
6799: -- create the Telex contact point
6800: hz_contact_point_v2pub.create_telex_contact_point(
6801: p_init_msg_list => fnd_api.g_false,
6802: p_contact_point_rec => p_contact_point_rec,
6803: p_telex_rec => p_telex_rec,
6804: x_contact_point_id => x_contact_point_id,
6805: x_return_status => x_return_status,

Line 6811: IF x_return_status <> fnd_api.g_ret_sts_success THEN

6807: x_msg_data => x_msg_data
6808: );
6809:
6810: -- raise an exception if the banking group creation is unsuccessful
6811: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6812: RAISE fnd_api.g_exc_error;
6813: END IF;
6814:
6815: -- Debug info.

Line 6812: RAISE fnd_api.g_exc_error;

6808: );
6809:
6810: -- raise an exception if the banking group creation is unsuccessful
6811: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6812: RAISE fnd_api.g_exc_error;
6813: END IF;
6814:
6815: -- Debug info.
6816: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 6825: WHEN fnd_api.g_exc_error THEN

6821:
6822: -- disable the debug procedure before exiting.
6823: --disable_debug;
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,

Line 6827: x_return_status := fnd_api.g_ret_sts_error;

6823: --disable_debug;
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:

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 6848: WHEN fnd_api.g_exc_unexpected_error THEN

6844:
6845: -- Check if API is called in debug mode. If yes, disable debug.
6846: --disable_debug;
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,

Line 6850: x_return_status := fnd_api.g_ret_sts_unexp_error;

6846: --disable_debug;
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:

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 6873: x_return_status := fnd_api.g_ret_sts_unexp_error;

6869: --disable_debug;
6870:
6871: WHEN OTHERS THEN
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,

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 6911: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |

6907: | |
6908: | ARGUMENTS |
6909: | IN: |
6910: | p_init_msg_list Initialize message stack if it is set to |
6911: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
6912: | p_contact_point_rec Contact point record. |
6913: | p_telex_rec TELEX record. |
6914: | IN/OUT: |
6915: | p_object_version_number Used to lock the record being updated. |

Line 6920: | be FND_API.G_RET_STS_SUCCESS (success), |

6916: | OUT: |
6917: | x_party_number Party number for the party created for the |
6918: | relationship. |
6919: | x_return_status Return status after the call. The status can |
6920: | be FND_API.G_RET_STS_SUCCESS (success), |
6921: | fnd_api.g_ret_sts_error (error), |
6922: | fnd_api.g_ret_sts_unexp_error (unexpected |
6923: | error). |
6924: | x_msg_count Number of messages in message stack. |

Line 6921: | fnd_api.g_ret_sts_error (error), |

6917: | x_party_number Party number for the party created for the |
6918: | relationship. |
6919: | x_return_status Return status after the call. The status can |
6920: | be FND_API.G_RET_STS_SUCCESS (success), |
6921: | fnd_api.g_ret_sts_error (error), |
6922: | fnd_api.g_ret_sts_unexp_error (unexpected |
6923: | error). |
6924: | x_msg_count Number of messages in message stack. |
6925: | x_msg_data Message text if x_msg_count is 1. |

Line 6922: | fnd_api.g_ret_sts_unexp_error (unexpected |

6918: | relationship. |
6919: | x_return_status Return status after the call. The status can |
6920: | be FND_API.G_RET_STS_SUCCESS (success), |
6921: | fnd_api.g_ret_sts_error (error), |
6922: | fnd_api.g_ret_sts_unexp_error (unexpected |
6923: | error). |
6924: | x_msg_count Number of messages in message stack. |
6925: | x_msg_data Message text if x_msg_count is 1. |
6926: | MODIFICATION HISTORY |

Line 6930: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

6926: | MODIFICATION HISTORY |
6927: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
6928: +=======================================================================*/
6929: PROCEDURE update_telex_contact_point (
6930: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6931: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6932: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type
6933: := hz_contact_point_v2pub.g_miss_telex_rec,
6934: p_object_version_number IN OUT NOCOPY NUMBER,

Line 6956: x_return_status := fnd_api.g_ret_sts_success;

6952: END IF;
6953:
6954:
6955: -- initialize API return status to success.
6956: x_return_status := fnd_api.g_ret_sts_success;
6957:
6958: --
6959: -- execute business logic
6960: --

Line 6968: IF x_return_status <> fnd_api.g_ret_sts_success THEN

6964: p_telex_rec,
6965: x_return_status);
6966:
6967: -- raise an exception if the validation routine is unsuccessful
6968: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6969: RAISE fnd_api.g_exc_error;
6970: END IF;
6971:
6972: -- update the Telex contact point

Line 6969: RAISE fnd_api.g_exc_error;

6965: x_return_status);
6966:
6967: -- raise an exception if the validation routine is unsuccessful
6968: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6969: RAISE fnd_api.g_exc_error;
6970: END IF;
6971:
6972: -- update the Telex contact point
6973: hz_contact_point_v2pub.update_telex_contact_point(

Line 6974: p_init_msg_list => fnd_api.g_false,

6970: END IF;
6971:
6972: -- update the Telex contact point
6973: hz_contact_point_v2pub.update_telex_contact_point(
6974: p_init_msg_list => fnd_api.g_false,
6975: p_contact_point_rec => p_contact_point_rec,
6976: p_telex_rec => p_telex_rec,
6977: p_object_version_number => p_object_version_number,
6978: x_return_status => x_return_status,

Line 6984: IF x_return_status <> fnd_api.g_ret_sts_success THEN

6980: x_msg_data => x_msg_data
6981: );
6982:
6983: -- raise an exception if the banking group creation is unsuccessful
6984: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6985: RAISE fnd_api.g_exc_error;
6986: END IF;
6987:
6988: -- Debug info.

Line 6985: RAISE fnd_api.g_exc_error;

6981: );
6982:
6983: -- raise an exception if the banking group creation is unsuccessful
6984: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6985: RAISE fnd_api.g_exc_error;
6986: END IF;
6987:
6988: -- Debug info.
6989: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 6998: WHEN fnd_api.g_exc_error THEN

6994:
6995: -- disable the debug procedure before exiting.
6996: --disable_debug;
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,

Line 7000: x_return_status := fnd_api.g_ret_sts_error;

6996: --disable_debug;
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:

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 7021: WHEN fnd_api.g_exc_unexpected_error THEN

7017:
7018: -- Check if API is called in debug mode. If yes, disable debug.
7019: --disable_debug;
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,

Line 7023: x_return_status := fnd_api.g_ret_sts_unexp_error;

7019: --disable_debug;
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:

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 7046: x_return_status := fnd_api.g_ret_sts_unexp_error;

7042: --disable_debug;
7043:
7044: WHEN OTHERS THEN
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,

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 7083: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |

7079: | |
7080: | ARGUMENTS |
7081: | IN: |
7082: | p_init_msg_list Initialize message stack if it is set to |
7083: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
7084: | p_bank_rec bank record |
7085: | p_mode 'I' for insert mode. |
7086: | 'U' for update mode. |
7087: | IN/OUT: |

Line 7090: | be FND_API.G_RET_STS_SUCCESS (success), |

7086: | 'U' for update mode. |
7087: | IN/OUT: |
7088: | OUT: |
7089: | x_return_status Return status after the call. The status can |
7090: | be FND_API.G_RET_STS_SUCCESS (success), |
7091: | fnd_api.g_ret_sts_error (error), |
7092: | fnd_api.g_ret_sts_unexp_error (unexpected |
7093: | error). |
7094: | x_msg_count Number of messages in message stack. |

Line 7091: | fnd_api.g_ret_sts_error (error), |

7087: | IN/OUT: |
7088: | OUT: |
7089: | x_return_status Return status after the call. The status can |
7090: | be FND_API.G_RET_STS_SUCCESS (success), |
7091: | fnd_api.g_ret_sts_error (error), |
7092: | fnd_api.g_ret_sts_unexp_error (unexpected |
7093: | error). |
7094: | x_msg_count Number of messages in message stack. |
7095: | x_msg_data Message text if x_msg_count is 1. |

Line 7092: | fnd_api.g_ret_sts_unexp_error (unexpected |

7088: | OUT: |
7089: | x_return_status Return status after the call. The status can |
7090: | be FND_API.G_RET_STS_SUCCESS (success), |
7091: | fnd_api.g_ret_sts_error (error), |
7092: | fnd_api.g_ret_sts_unexp_error (unexpected |
7093: | error). |
7094: | x_msg_count Number of messages in message stack. |
7095: | x_msg_data Message text if x_msg_count is 1. |
7096: | MODIFICATION HISTORY |

Line 7128: fnd_api.To_Boolean(p_init_msg_list)

7124: END IF;
7125:
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:

Line 7134: x_return_status := fnd_api.g_ret_sts_success;

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;
7135:
7136: -- validate input
7137: IF (p_mode IS NULL OR
7138: p_mode <> 'I' AND

Line 7144: raise fnd_api.g_exc_error;

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;
7148: l_bank_rec.organization_rec.home_country := l_bank_rec.country;

Line 7158: IF x_return_status <> fnd_api.g_ret_sts_success THEN

7154: x_return_status => x_return_status
7155: );
7156:
7157: -- raise an exception if validation failed
7158: IF x_return_status <> fnd_api.g_ret_sts_success THEN
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.

Line 7159: raise fnd_api.g_exc_error;

7155: );
7156:
7157: -- raise an exception if validation failed
7158: IF x_return_status <> fnd_api.g_ret_sts_success THEN
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 (

Line 7164: p_encoded => fnd_api.G_FALSE,

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:
7168: -- Debug info.

Line 7187: WHEN fnd_api.G_EXC_ERROR THEN

7183: );
7184: END IF;
7185:
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,

Line 7188: x_return_status := fnd_api.G_RET_STS_ERROR;

7184: END IF;
7185:
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,

Line 7191: p_encoded => fnd_api.G_FALSE,

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: );
7195:

Line 7214: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

7210: p_msg_level => fnd_log.level_procedure
7211: );
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,

Line 7215: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

7211: );
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

Line 7217: p_encoded => fnd_api.G_FALSE,

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: );
7221:

Line 7241: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

7237: );
7238: END IF;
7239:
7240: WHEN OTHERS THEN
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;

Line 7248: p_encoded => fnd_api.G_FALSE,

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: );
7252:

Line 7284: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |

7280: | |
7281: | ARGUMENTS |
7282: | IN: |
7283: | p_init_msg_list Initialize message stack if it is set to |
7284: | FND_API.G_TRUE. Default is FND_API.G_FALSE. |
7285: | p_bank_party_id bank party id. |
7286: | p_bank_branch_rec bank branch record |
7287: | p_mode 'I' for insert mode. |
7288: | 'U' for update mode. |

Line 7292: | be FND_API.G_RET_STS_SUCCESS (success), |

7288: | 'U' for update mode. |
7289: | IN/OUT: |
7290: | OUT: |
7291: | x_return_status Return status after the call. The status can |
7292: | be FND_API.G_RET_STS_SUCCESS (success), |
7293: | fnd_api.g_ret_sts_error (error), |
7294: | fnd_api.g_ret_sts_unexp_error (unexpected |
7295: | error). |
7296: | x_msg_count Number of messages in message stack. |

Line 7293: | fnd_api.g_ret_sts_error (error), |

7289: | IN/OUT: |
7290: | OUT: |
7291: | x_return_status Return status after the call. The status can |
7292: | be FND_API.G_RET_STS_SUCCESS (success), |
7293: | fnd_api.g_ret_sts_error (error), |
7294: | fnd_api.g_ret_sts_unexp_error (unexpected |
7295: | error). |
7296: | x_msg_count Number of messages in message stack. |
7297: | x_msg_data Message text if x_msg_count is 1. |

Line 7294: | fnd_api.g_ret_sts_unexp_error (unexpected |

7290: | OUT: |
7291: | x_return_status Return status after the call. The status can |
7292: | be FND_API.G_RET_STS_SUCCESS (success), |
7293: | fnd_api.g_ret_sts_error (error), |
7294: | fnd_api.g_ret_sts_unexp_error (unexpected |
7295: | error). |
7296: | x_msg_count Number of messages in message stack. |
7297: | x_msg_data Message text if x_msg_count is 1. |
7298: | MODIFICATION HISTORY |

Line 7331: fnd_api.To_Boolean(p_init_msg_list)

7327: END IF;
7328:
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:

Line 7337: x_return_status := fnd_api.G_RET_STS_SUCCESS;

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;
7338:
7339: -- validate input
7340: IF (p_mode IS NULL OR
7341: p_mode <> 'I' AND

Line 7347: raise fnd_api.g_exc_error;

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;
7351: l_bank_branch_rec.organization_rec.home_country := l_bank_branch_rec.country;

Line 7361: IF x_return_status <> fnd_api.g_ret_sts_success THEN

7357: x_return_status => x_return_status
7358: );
7359:
7360: -- raise an exception if validation failed
7361: IF x_return_status <> fnd_api.g_ret_sts_success THEN
7362: raise fnd_api.g_exc_error;
7363: END IF;
7364:
7365: validate_bank_org (

Line 7362: raise fnd_api.g_exc_error;

7358: );
7359:
7360: -- raise an exception if validation failed
7361: IF x_return_status <> fnd_api.g_ret_sts_success THEN
7362: raise fnd_api.g_exc_error;
7363: END IF;
7364:
7365: validate_bank_org (
7366: p_bank_rec => p_bank_branch_rec,

Line 7373: IF x_return_status <> fnd_api.g_ret_sts_success THEN

7369: x_return_status => x_return_status
7370: );
7371:
7372: -- raise an exception if validation failed
7373: IF x_return_status <> fnd_api.g_ret_sts_success THEN
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.

Line 7374: raise fnd_api.g_exc_error;

7370: );
7371:
7372: -- raise an exception if validation failed
7373: IF x_return_status <> fnd_api.g_ret_sts_success THEN
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 (

Line 7379: p_encoded => fnd_api.G_FALSE,

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:
7383: -- Debug info.

Line 7402: WHEN fnd_api.G_EXC_ERROR THEN

7398: );
7399: END IF;
7400:
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,

Line 7403: x_return_status := fnd_api.G_RET_STS_ERROR;

7399: END IF;
7400:
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,

Line 7406: p_encoded => fnd_api.G_FALSE,

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: );
7410:

Line 7429: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

7425: p_msg_level => fnd_log.level_procedure
7426: );
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,

Line 7430: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

7426: );
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

Line 7432: p_encoded => fnd_api.G_FALSE,

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: );
7436:

Line 7456: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

7452: );
7453: END IF;
7454:
7455: WHEN OTHERS THEN
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;

Line 7463: p_encoded => fnd_api.G_FALSE,

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: );
7467: