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_MESSAGE

Line 229: fnd_message.set_name('AR', 'HZ_BANK_INVALID_PARENT');

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

Line 246: fnd_message.set_name('AR', 'HZ_BANK_INVALID_PARENT');

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

Line 272: fnd_message.set_name('AR', 'HZ_BANK_INVALID_PARENT');

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

Line 293: fnd_message.set_name('AR', 'HZ_BANK_INVALID_COUNTRY');

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);
296: fnd_msg_pub.add;
297: x_return_status := fnd_api.g_ret_sts_error;

Line 294: fnd_message.set_token('INVCOUNTRY', p_bank_rec.organization_rec.home_country);

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);
296: fnd_msg_pub.add;
297: x_return_status := fnd_api.g_ret_sts_error;
298: END IF;

Line 295: fnd_message.set_token('VLDCOUNTRY', l_parent_country);

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);
296: fnd_msg_pub.add;
297: x_return_status := fnd_api.g_ret_sts_error;
298: END IF;
299:

Line 324: fnd_message.set_name('AR', 'HZ_BANK_NONUNIQUE_NUMBER');

320: --
321: OPEN c_uniquenumberck(l_parent_id);
322: FETCH c_uniquenumberck INTO l_dummy;
323: IF c_uniquenumberck%FOUND THEN
324: fnd_message.set_name('AR', 'HZ_BANK_NONUNIQUE_NUMBER');
325: fnd_message.set_token('BANK', l_parent_number);
326: fnd_message.set_token('BRANCH', p_bank_rec.bank_or_branch_number);
327: fnd_message.set_token('COUNTRY', l_parent_country);
328: fnd_msg_pub.add;

Line 325: fnd_message.set_token('BANK', l_parent_number);

321: OPEN c_uniquenumberck(l_parent_id);
322: FETCH c_uniquenumberck INTO l_dummy;
323: IF c_uniquenumberck%FOUND THEN
324: fnd_message.set_name('AR', 'HZ_BANK_NONUNIQUE_NUMBER');
325: fnd_message.set_token('BANK', l_parent_number);
326: fnd_message.set_token('BRANCH', p_bank_rec.bank_or_branch_number);
327: fnd_message.set_token('COUNTRY', l_parent_country);
328: fnd_msg_pub.add;
329: x_return_status := fnd_api.g_ret_sts_error;

Line 326: fnd_message.set_token('BRANCH', p_bank_rec.bank_or_branch_number);

322: FETCH c_uniquenumberck INTO l_dummy;
323: IF c_uniquenumberck%FOUND THEN
324: fnd_message.set_name('AR', 'HZ_BANK_NONUNIQUE_NUMBER');
325: fnd_message.set_token('BANK', l_parent_number);
326: fnd_message.set_token('BRANCH', p_bank_rec.bank_or_branch_number);
327: fnd_message.set_token('COUNTRY', l_parent_country);
328: fnd_msg_pub.add;
329: x_return_status := fnd_api.g_ret_sts_error;
330: END IF;

Line 327: fnd_message.set_token('COUNTRY', l_parent_country);

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

Line 340: fnd_message.set_name('AR', 'HZ_BANK_NONUNIQUE_NAME');

336: --
337: OPEN c_uniquenameck(l_parent_id);
338: FETCH c_uniquenameck INTO l_dummy;
339: IF c_uniquenameck%FOUND THEN
340: fnd_message.set_name('AR', 'HZ_BANK_NONUNIQUE_NAME');
341: fnd_message.set_token('BANK', l_parent_name);
342: fnd_message.set_token('BRANCH',
343: p_bank_rec.organization_rec.organization_name);
344: fnd_msg_pub.add;

Line 341: fnd_message.set_token('BANK', l_parent_name);

337: OPEN c_uniquenameck(l_parent_id);
338: FETCH c_uniquenameck INTO l_dummy;
339: IF c_uniquenameck%FOUND THEN
340: fnd_message.set_name('AR', 'HZ_BANK_NONUNIQUE_NAME');
341: fnd_message.set_token('BANK', l_parent_name);
342: fnd_message.set_token('BRANCH',
343: p_bank_rec.organization_rec.organization_name);
344: fnd_msg_pub.add;
345: x_return_status := fnd_api.g_ret_sts_error;

Line 342: fnd_message.set_token('BRANCH',

338: FETCH c_uniquenameck INTO l_dummy;
339: IF c_uniquenameck%FOUND THEN
340: fnd_message.set_name('AR', 'HZ_BANK_NONUNIQUE_NAME');
341: fnd_message.set_token('BANK', l_parent_name);
342: fnd_message.set_token('BRANCH',
343: p_bank_rec.organization_rec.organization_name);
344: fnd_msg_pub.add;
345: x_return_status := fnd_api.g_ret_sts_error;
346: END IF;

Line 412: -- fnd_message.set_name('AR', 'HZ_API_MAND_DEP_FIELDS');

408: -- IF p_mode = g_insert
409: -- AND p_bank_rec.bank_code IS NULL
410: -- AND p_bank_rec.branch_code IS NULL
411: -- THEN
412: -- fnd_message.set_name('AR', 'HZ_API_MAND_DEP_FIELDS');
413: -- fnd_message.set_token('COLUMN1', 'bank or branch number');
414: -- fnd_message.set_token('VALUE1', 'NULL');
415: -- fnd_message.set_token('COLUMN2', 'bank or branch number');
416: -- fnd_msg_pub.add;

Line 413: -- fnd_message.set_token('COLUMN1', 'bank or branch number');

409: -- AND p_bank_rec.bank_code IS NULL
410: -- AND p_bank_rec.branch_code IS NULL
411: -- THEN
412: -- fnd_message.set_name('AR', 'HZ_API_MAND_DEP_FIELDS');
413: -- fnd_message.set_token('COLUMN1', 'bank or branch number');
414: -- fnd_message.set_token('VALUE1', 'NULL');
415: -- fnd_message.set_token('COLUMN2', 'bank or branch number');
416: -- fnd_msg_pub.add;
417: -- x_return_status := fnd_api.g_ret_sts_error;

Line 414: -- fnd_message.set_token('VALUE1', 'NULL');

410: -- AND p_bank_rec.branch_code IS NULL
411: -- THEN
412: -- fnd_message.set_name('AR', 'HZ_API_MAND_DEP_FIELDS');
413: -- fnd_message.set_token('COLUMN1', 'bank or branch number');
414: -- fnd_message.set_token('VALUE1', 'NULL');
415: -- fnd_message.set_token('COLUMN2', 'bank or branch number');
416: -- fnd_msg_pub.add;
417: -- x_return_status := fnd_api.g_ret_sts_error;
418: -- END IF;

Line 415: -- fnd_message.set_token('COLUMN2', 'bank or branch number');

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

Line 423: fnd_message.set_name('AR', 'HZ_BANK_BRANCH_SPECIFIED');

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

Line 430: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');

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

Line 431: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE, BANK');

427:
428: -- bank institution type must be either CLEARINGHOUSE OR BANK
429: IF p_bank_rec.institution_type NOT IN ('BANK', 'CLEARINGHOUSE') THEN
430: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
431: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE, BANK');
432: fnd_message.set_token('INVALIDSUB', p_bank_rec.institution_type);
433: fnd_msg_pub.add;
434: x_return_status := fnd_api.g_ret_sts_error;
435: END IF;

Line 432: fnd_message.set_token('INVALIDSUB', p_bank_rec.institution_type);

428: -- bank institution type must be either CLEARINGHOUSE OR BANK
429: IF p_bank_rec.institution_type NOT IN ('BANK', 'CLEARINGHOUSE') THEN
430: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
431: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE, BANK');
432: fnd_message.set_token('INVALIDSUB', p_bank_rec.institution_type);
433: fnd_msg_pub.add;
434: x_return_status := fnd_api.g_ret_sts_error;
435: END IF;
436:

Line 444: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');

440: -- Bug 2835472 Added Clearinghouse_branch as valid institution type.
441: -- bank institution type must be BANK BRANCH or CLEARINGHOUSE_BRANCH
442: IF p_bank_rec.institution_type
443: NOT IN ('BANK_BRANCH', 'CLEARINGHOUSE_BRANCH') THEN
444: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
445: fnd_message.set_token('VALIDSUB', 'BANK_BRANCH, CLEARINGHOUSE_BRANCH');
446: fnd_message.set_token('INVALIDSUB', p_bank_rec.institution_type);
447: fnd_msg_pub.add;
448: x_return_status := fnd_api.g_ret_sts_error;

Line 445: fnd_message.set_token('VALIDSUB', 'BANK_BRANCH, CLEARINGHOUSE_BRANCH');

441: -- bank institution type must be BANK BRANCH or CLEARINGHOUSE_BRANCH
442: IF p_bank_rec.institution_type
443: NOT IN ('BANK_BRANCH', 'CLEARINGHOUSE_BRANCH') THEN
444: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
445: fnd_message.set_token('VALIDSUB', 'BANK_BRANCH, CLEARINGHOUSE_BRANCH');
446: fnd_message.set_token('INVALIDSUB', p_bank_rec.institution_type);
447: fnd_msg_pub.add;
448: x_return_status := fnd_api.g_ret_sts_error;
449: END IF;

Line 446: fnd_message.set_token('INVALIDSUB', p_bank_rec.institution_type);

442: IF p_bank_rec.institution_type
443: NOT IN ('BANK_BRANCH', 'CLEARINGHOUSE_BRANCH') THEN
444: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
445: fnd_message.set_token('VALIDSUB', 'BANK_BRANCH, CLEARINGHOUSE_BRANCH');
446: fnd_message.set_token('INVALIDSUB', p_bank_rec.institution_type);
447: fnd_msg_pub.add;
448: x_return_status := fnd_api.g_ret_sts_error;
449: END IF;
450:

Line 472: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');

468: -- Close the cursor and raise an error if the group ID could not be
469: -- selected from the sequence.
470: CLOSE orgidcur;
471:
472: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
473: fnd_message.set_token('SEQUENCE', 'hz_parties_s'); -- Bug 3397488
474: fnd_msg_pub.add;
475: RAISE fnd_api.g_exc_error;
476: END IF;

Line 473: fnd_message.set_token('SEQUENCE', 'hz_parties_s'); -- Bug 3397488

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

Line 628: fnd_message.set_name('AR', 'HZ_EDI_UNIQUE');

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

Line 636: fnd_message.set_name('AR', 'HZ_EDI_UNIQUE');

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

Line 1025: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');

1021: END IF;
1022:
1023: -- Only one group type is currently supported.
1024: IF p_group_rec.group_type <> 'BANKING_GROUP' THEN
1025: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1026: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1027: fnd_message.set_token('INVALIDSUB', p_group_rec.group_type);
1028: fnd_msg_pub.add;
1029: x_return_status := fnd_api.g_ret_sts_error;

Line 1026: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');

1022:
1023: -- Only one group type is currently supported.
1024: IF p_group_rec.group_type <> 'BANKING_GROUP' THEN
1025: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1026: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1027: fnd_message.set_token('INVALIDSUB', p_group_rec.group_type);
1028: fnd_msg_pub.add;
1029: x_return_status := fnd_api.g_ret_sts_error;
1030: END IF;

Line 1027: fnd_message.set_token('INVALIDSUB', p_group_rec.group_type);

1023: -- Only one group type is currently supported.
1024: IF p_group_rec.group_type <> 'BANKING_GROUP' THEN
1025: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1026: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1027: fnd_message.set_token('INVALIDSUB', p_group_rec.group_type);
1028: fnd_msg_pub.add;
1029: x_return_status := fnd_api.g_ret_sts_error;
1030: END IF;
1031:

Line 1089: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

1085: BEGIN
1086: OPEN c_group;
1087: FETCH c_group INTO l_group_type;
1088: IF c_group%NOTFOUND THEN
1089: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1090: fnd_message.set_token('RECORD', 'party');
1091: fnd_message.set_token('VALUE', TO_CHAR(p_party_id));
1092: fnd_msg_pub.add;
1093: x_return_status := fnd_api.g_ret_sts_error;

Line 1090: fnd_message.set_token('RECORD', 'party');

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

Line 1091: fnd_message.set_token('VALUE', TO_CHAR(p_party_id));

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

Line 1137: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');

1133: -- specified.
1134: IF (p_mode = g_insert OR p_relationship_rec.relationship_type IS NOT NULL)
1135: AND NVL(p_relationship_rec.relationship_type, 'NULL') <> 'BANKING_GROUP'
1136: THEN
1137: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1138: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1139: fnd_message.set_token('INVALIDSUB',
1140: p_relationship_rec.relationship_type);
1141: fnd_msg_pub.add;

Line 1138: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');

1134: IF (p_mode = g_insert OR p_relationship_rec.relationship_type IS NOT NULL)
1135: AND NVL(p_relationship_rec.relationship_type, 'NULL') <> 'BANKING_GROUP'
1136: THEN
1137: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1138: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1139: fnd_message.set_token('INVALIDSUB',
1140: p_relationship_rec.relationship_type);
1141: fnd_msg_pub.add;
1142: x_return_status := fnd_api.g_ret_sts_error;

Line 1139: fnd_message.set_token('INVALIDSUB',

1135: AND NVL(p_relationship_rec.relationship_type, 'NULL') <> 'BANKING_GROUP'
1136: THEN
1137: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1138: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1139: fnd_message.set_token('INVALIDSUB',
1140: p_relationship_rec.relationship_type);
1141: fnd_msg_pub.add;
1142: x_return_status := fnd_api.g_ret_sts_error;
1143: END IF;

Line 1175: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');

1171: -- the parent group is the object.
1172: l_parent := 'OBJECT';
1173: ELSE
1174: -- if the object is also not the right type, then this is not valid.
1175: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1176: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1177: fnd_message.set_token('INVALIDSUB', l_group_type);
1178: fnd_msg_pub.add;
1179: x_return_status := fnd_api.g_ret_sts_error;

Line 1176: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');

1172: l_parent := 'OBJECT';
1173: ELSE
1174: -- if the object is also not the right type, then this is not valid.
1175: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1176: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1177: fnd_message.set_token('INVALIDSUB', l_group_type);
1178: fnd_msg_pub.add;
1179: x_return_status := fnd_api.g_ret_sts_error;
1180:

Line 1177: fnd_message.set_token('INVALIDSUB', l_group_type);

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

Line 1200: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');

1196: -- specified.
1197: IF ((l_parent = 'SUBJECT' AND l_direction <> 'P')
1198: OR (l_parent = 'OBJECT' AND l_direction <> 'C'))
1199: THEN
1200: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1201: IF l_parent = 'SUBJECT' THEN
1202: fnd_message.set_token('VALIDSUB', 'P');
1203: ELSE
1204: fnd_message.set_token('VALIDSUB', 'C');

Line 1202: fnd_message.set_token('VALIDSUB', 'P');

1198: OR (l_parent = 'OBJECT' AND l_direction <> 'C'))
1199: THEN
1200: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1201: IF l_parent = 'SUBJECT' THEN
1202: fnd_message.set_token('VALIDSUB', 'P');
1203: ELSE
1204: fnd_message.set_token('VALIDSUB', 'C');
1205: END IF;
1206: fnd_message.set_token('INVALIDSUB', l_direction);

Line 1204: fnd_message.set_token('VALIDSUB', 'C');

1200: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1201: IF l_parent = 'SUBJECT' THEN
1202: fnd_message.set_token('VALIDSUB', 'P');
1203: ELSE
1204: fnd_message.set_token('VALIDSUB', 'C');
1205: END IF;
1206: fnd_message.set_token('INVALIDSUB', l_direction);
1207: fnd_msg_pub.add;
1208: x_return_status := fnd_api.g_ret_sts_error;

Line 1206: fnd_message.set_token('INVALIDSUB', l_direction);

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

Line 1211: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

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

Line 1212: fnd_message.set_token('RECORD', 'banking group relationship type');

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

Line 1213: fnd_message.set_token('VALUE', p_relationship_rec.relationship_type);

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

Line 1234: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

1230:
1231: OPEN c_codeassign(l_bank_id);
1232: FETCH c_codeassign INTO l_class_code;
1233: IF c_codeassign%NOTFOUND THEN
1234: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1235: fnd_message.set_token('RECORD', 'bank classification code assignment');
1236: fnd_message.set_token('VALUE', TO_CHAR(l_bank_id));
1237: fnd_msg_pub.add;
1238: x_return_status := fnd_api.g_ret_sts_error;

Line 1235: fnd_message.set_token('RECORD', 'bank classification code assignment');

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

Line 1236: fnd_message.set_token('VALUE', TO_CHAR(l_bank_id));

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

Line 1244: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');

1240:
1241: IF l_class_code IS NOT NULL
1242: AND l_class_code NOT IN ('BANK', 'CLEARINGHOUSE')
1243: THEN
1244: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1245: fnd_message.set_token('VALIDSUB', 'BANK, CLEARINGHOUSE');
1246: fnd_message.set_token('INVALIDSUB', l_class_code);
1247: fnd_msg_pub.add;
1248: x_return_status := fnd_api.g_ret_sts_error;

Line 1245: fnd_message.set_token('VALIDSUB', 'BANK, CLEARINGHOUSE');

1241: IF l_class_code IS NOT NULL
1242: AND l_class_code NOT IN ('BANK', 'CLEARINGHOUSE')
1243: THEN
1244: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1245: fnd_message.set_token('VALIDSUB', 'BANK, CLEARINGHOUSE');
1246: fnd_message.set_token('INVALIDSUB', l_class_code);
1247: fnd_msg_pub.add;
1248: x_return_status := fnd_api.g_ret_sts_error;
1249: END IF;

Line 1246: fnd_message.set_token('INVALIDSUB', l_class_code);

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

Line 1322: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');

1318: IF (p_mode = g_insert OR p_relationship_rec.relationship_type IS NOT NULL)
1319: AND NVL(p_relationship_rec.relationship_type, 'NULL') <>
1320: 'CLEARINGHOUSE_BANK'
1321: THEN
1322: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1323: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE_BANK');
1324: fnd_message.set_token('INVALIDSUB',
1325: p_relationship_rec.relationship_type);
1326: fnd_msg_pub.add;

Line 1323: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE_BANK');

1319: AND NVL(p_relationship_rec.relationship_type, 'NULL') <>
1320: 'CLEARINGHOUSE_BANK'
1321: THEN
1322: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1323: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE_BANK');
1324: fnd_message.set_token('INVALIDSUB',
1325: p_relationship_rec.relationship_type);
1326: fnd_msg_pub.add;
1327: x_return_status := fnd_api.g_ret_sts_error;

Line 1324: fnd_message.set_token('INVALIDSUB',

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

Line 1344: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

1340:
1341: OPEN c_codeassign(p_relationship_rec.subject_id);
1342: FETCH c_codeassign INTO l_subject_class;
1343: IF c_codeassign%NOTFOUND THEN
1344: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1345: fnd_message.set_token('RECORD',
1346: 'bank/clearinghouse code assignment (subject)');
1347: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_rec.subject_id));
1348: fnd_msg_pub.add;

Line 1345: fnd_message.set_token('RECORD',

1341: OPEN c_codeassign(p_relationship_rec.subject_id);
1342: FETCH c_codeassign INTO l_subject_class;
1343: IF c_codeassign%NOTFOUND THEN
1344: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1345: fnd_message.set_token('RECORD',
1346: 'bank/clearinghouse code assignment (subject)');
1347: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_rec.subject_id));
1348: fnd_msg_pub.add;
1349: x_return_status := fnd_api.g_ret_sts_error;

Line 1347: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_rec.subject_id));

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

Line 1352: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');

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');
1354: fnd_message.set_token('INVALIDSUB', l_subject_class);
1355: fnd_msg_pub.add;
1356: x_return_status := fnd_api.g_ret_sts_error;

Line 1353: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE, BANK');

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

Line 1354: fnd_message.set_token('INVALIDSUB', l_subject_class);

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

Line 1368: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

1364:
1365: OPEN c_codeassign(p_relationship_rec.object_id);
1366: FETCH c_codeassign INTO l_object_class;
1367: IF c_codeassign%NOTFOUND THEN
1368: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1369: fnd_message.set_token('RECORD',
1370: 'bank/clearinghouse code assignment (object)');
1371: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_rec.object_id));
1372: fnd_msg_pub.add;

Line 1369: fnd_message.set_token('RECORD',

1365: OPEN c_codeassign(p_relationship_rec.object_id);
1366: FETCH c_codeassign INTO l_object_class;
1367: IF c_codeassign%NOTFOUND THEN
1368: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1369: fnd_message.set_token('RECORD',
1370: 'bank/clearinghouse code assignment (object)');
1371: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_rec.object_id));
1372: fnd_msg_pub.add;
1373: x_return_status := fnd_api.g_ret_sts_error;

Line 1371: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_rec.object_id));

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

Line 1375: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');

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);
1378: fnd_msg_pub.add;
1379: x_return_status := fnd_api.g_ret_sts_error;

Line 1376: fnd_message.set_token('VALIDSUB', 'BANK, CLEARINGHOUSE');

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);
1378: fnd_msg_pub.add;
1379: x_return_status := fnd_api.g_ret_sts_error;
1380: ELSIF l_subject_class = l_object_class THEN

Line 1377: fnd_message.set_token('INVALIDSUB', l_object_class);

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

Line 1381: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');

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);
1384: fnd_msg_pub.add;
1385: x_return_status := fnd_api.g_ret_sts_error;

Line 1382: fnd_message.set_token('VALIDSUB', 'different');

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);
1384: fnd_msg_pub.add;
1385: x_return_status := fnd_api.g_ret_sts_error;
1386: END IF;

Line 1383: fnd_message.set_token('INVALIDSUB', l_object_class);

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);
1384: fnd_msg_pub.add;
1385: x_return_status := fnd_api.g_ret_sts_error;
1386: END IF;
1387: CLOSE c_codeassign;

Line 1403: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');

1399: -- specified.
1400: IF ((l_subject_class = 'CLEARINGHOUSE' AND l_direction <> 'P')
1401: OR (l_object_class = 'CLEARINGHOUSE' AND l_direction <> 'C'))
1402: THEN
1403: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1404: IF l_subject_class = 'CLEARINGHOUSE' THEN
1405: fnd_message.set_token('VALIDSUB', 'P');
1406: ELSE
1407: fnd_message.set_token('VALIDSUB', 'C');

Line 1405: fnd_message.set_token('VALIDSUB', 'P');

1401: OR (l_object_class = 'CLEARINGHOUSE' AND l_direction <> 'C'))
1402: THEN
1403: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1404: IF l_subject_class = 'CLEARINGHOUSE' THEN
1405: fnd_message.set_token('VALIDSUB', 'P');
1406: ELSE
1407: fnd_message.set_token('VALIDSUB', 'C');
1408: END IF;
1409: fnd_message.set_token('INVALIDSUB', l_direction);

Line 1407: fnd_message.set_token('VALIDSUB', 'C');

1403: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1404: IF l_subject_class = 'CLEARINGHOUSE' THEN
1405: fnd_message.set_token('VALIDSUB', 'P');
1406: ELSE
1407: fnd_message.set_token('VALIDSUB', 'C');
1408: END IF;
1409: fnd_message.set_token('INVALIDSUB', l_direction);
1410: fnd_msg_pub.add;
1411: x_return_status := fnd_api.g_ret_sts_error;

Line 1409: fnd_message.set_token('INVALIDSUB', l_direction);

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

Line 1414: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

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',
1416: 'clearinghouse assignment relationship type');
1417: fnd_message.set_token('VALUE', p_relationship_rec.relationship_type);
1418: fnd_msg_pub.add;

Line 1415: fnd_message.set_token('RECORD',

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

Line 1417: fnd_message.set_token('VALUE', p_relationship_rec.relationship_type);

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

Line 1527: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

1523:
1524: IF l_party_id IS NULL OR l_location_id IS NULL THEN
1525: -- incomplete information given for the insert.
1526: IF p_mode = g_insert THEN
1527: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1528: fnd_message.set_token('FK', 'party or location');
1529: fnd_message.set_token('COLUMN', 'PARTY_ID or LOCATION_ID');
1530: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
1531: fnd_msg_pub.add;

Line 1528: fnd_message.set_token('FK', 'party or location');

1524: IF l_party_id IS NULL OR l_location_id IS NULL THEN
1525: -- incomplete information given for the insert.
1526: IF p_mode = g_insert THEN
1527: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1528: fnd_message.set_token('FK', 'party or location');
1529: fnd_message.set_token('COLUMN', 'PARTY_ID or LOCATION_ID');
1530: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
1531: fnd_msg_pub.add;
1532: x_return_status := fnd_api.g_ret_sts_error;

Line 1529: fnd_message.set_token('COLUMN', 'PARTY_ID or LOCATION_ID');

1525: -- incomplete information given for the insert.
1526: IF p_mode = g_insert THEN
1527: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1528: fnd_message.set_token('FK', 'party or location');
1529: fnd_message.set_token('COLUMN', 'PARTY_ID or LOCATION_ID');
1530: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
1531: fnd_msg_pub.add;
1532: x_return_status := fnd_api.g_ret_sts_error;
1533: -- no point doing further validations. We're missing some data.

Line 1530: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');

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

Line 1541: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

1537: -- get the missing information.
1538: OPEN c_site;
1539: FETCH c_site INTO l_temp_party_id, l_temp_location_id;
1540: IF c_site%NOTFOUND THEN
1541: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1542: fnd_message.set_token('FK', 'party or location');
1543: fnd_message.set_token('COLUMN', 'PARTY_ID or LOCATION_ID');
1544: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
1545: fnd_msg_pub.add;

Line 1542: fnd_message.set_token('FK', 'party or location');

1538: OPEN c_site;
1539: FETCH c_site INTO l_temp_party_id, l_temp_location_id;
1540: IF c_site%NOTFOUND THEN
1541: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1542: fnd_message.set_token('FK', 'party or location');
1543: fnd_message.set_token('COLUMN', 'PARTY_ID or LOCATION_ID');
1544: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
1545: fnd_msg_pub.add;
1546: x_return_status := fnd_api.g_ret_sts_error;

Line 1543: fnd_message.set_token('COLUMN', 'PARTY_ID or LOCATION_ID');

1539: FETCH c_site INTO l_temp_party_id, l_temp_location_id;
1540: IF c_site%NOTFOUND THEN
1541: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1542: fnd_message.set_token('FK', 'party or location');
1543: fnd_message.set_token('COLUMN', 'PARTY_ID or LOCATION_ID');
1544: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
1545: fnd_msg_pub.add;
1546: x_return_status := fnd_api.g_ret_sts_error;
1547: -- no point doing further validations. We're missing some data.

Line 1544: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');

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

Line 1563: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

1559:
1560: OPEN c_parentcountry(l_party_id);
1561: FETCH c_parentcountry INTO l_parent_country;
1562: IF c_parentcountry%NOTFOUND THEN
1563: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1564: fnd_message.set_token('FK', 'active party');
1565: fnd_message.set_token('COLUMN', 'PARTY_ID');
1566: fnd_message.set_token('TABLE', 'HZ_PARTIES');
1567: fnd_msg_pub.add;

Line 1564: fnd_message.set_token('FK', 'active party');

1560: OPEN c_parentcountry(l_party_id);
1561: FETCH c_parentcountry INTO l_parent_country;
1562: IF c_parentcountry%NOTFOUND THEN
1563: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1564: fnd_message.set_token('FK', 'active party');
1565: fnd_message.set_token('COLUMN', 'PARTY_ID');
1566: fnd_message.set_token('TABLE', 'HZ_PARTIES');
1567: fnd_msg_pub.add;
1568: x_return_status := fnd_api.g_ret_sts_error;

Line 1565: fnd_message.set_token('COLUMN', 'PARTY_ID');

1561: FETCH c_parentcountry INTO l_parent_country;
1562: IF c_parentcountry%NOTFOUND THEN
1563: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1564: fnd_message.set_token('FK', 'active party');
1565: fnd_message.set_token('COLUMN', 'PARTY_ID');
1566: fnd_message.set_token('TABLE', 'HZ_PARTIES');
1567: fnd_msg_pub.add;
1568: x_return_status := fnd_api.g_ret_sts_error;
1569: END IF;

Line 1566: fnd_message.set_token('TABLE', 'HZ_PARTIES');

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

Line 1575: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

1571:
1572: OPEN c_sitecountry(l_location_id);
1573: FETCH c_sitecountry INTO l_site_country;
1574: IF c_sitecountry%NOTFOUND THEN
1575: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1576: fnd_message.set_token('FK', 'active location');
1577: fnd_message.set_token('COLUMN', 'LOCATION_ID');
1578: fnd_message.set_token('TABLE', 'HZ_LOCATIONS');
1579: fnd_msg_pub.add;

Line 1576: fnd_message.set_token('FK', 'active location');

1572: OPEN c_sitecountry(l_location_id);
1573: FETCH c_sitecountry INTO l_site_country;
1574: IF c_sitecountry%NOTFOUND THEN
1575: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1576: fnd_message.set_token('FK', 'active location');
1577: fnd_message.set_token('COLUMN', 'LOCATION_ID');
1578: fnd_message.set_token('TABLE', 'HZ_LOCATIONS');
1579: fnd_msg_pub.add;
1580: x_return_status := fnd_api.g_ret_sts_error;

Line 1577: fnd_message.set_token('COLUMN', 'LOCATION_ID');

1573: FETCH c_sitecountry INTO l_site_country;
1574: IF c_sitecountry%NOTFOUND THEN
1575: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1576: fnd_message.set_token('FK', 'active location');
1577: fnd_message.set_token('COLUMN', 'LOCATION_ID');
1578: fnd_message.set_token('TABLE', 'HZ_LOCATIONS');
1579: fnd_msg_pub.add;
1580: x_return_status := fnd_api.g_ret_sts_error;
1581: END IF;

Line 1578: fnd_message.set_token('TABLE', 'HZ_LOCATIONS');

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

Line 1585: fnd_message.set_name('AR', 'HZ_BANK_INVALID_COUNTRY');

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

Line 1586: fnd_message.set_token('INVCOUNTRY', l_site_country);

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

Line 1587: fnd_message.set_token('VLDCOUNTRY', l_parent_country);

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

Line 1603: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

1599: THEN
1600: OPEN c_codeassign(p_party_site_rec.party_id);
1601: FETCH c_codeassign INTO l_class_code;
1602: IF c_codeassign%NOTFOUND THEN
1603: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1604: fnd_message.set_token('RECORD', 'bank-related code assignment');
1605: fnd_message.set_token('VALUE', TO_CHAR(p_party_site_rec.party_id));
1606: fnd_msg_pub.add;
1607: x_return_status := fnd_api.g_ret_sts_error;

Line 1604: fnd_message.set_token('RECORD', 'bank-related code assignment');

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

Line 1605: fnd_message.set_token('VALUE', TO_CHAR(p_party_site_rec.party_id));

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

Line 1609: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');

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');
1612: fnd_message.set_token('INVALIDSUB', l_class_code);
1613: fnd_msg_pub.add;

Line 1610: fnd_message.set_token('VALIDSUB',

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');
1612: fnd_message.set_token('INVALIDSUB', l_class_code);
1613: fnd_msg_pub.add;
1614: x_return_status := fnd_api.g_ret_sts_error;

Line 1612: fnd_message.set_token('INVALIDSUB', l_class_code);

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

Line 2025: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

2021: OPEN c_rel;
2022: FETCH c_rel INTO l_subject_id, l_object_id, l_robject_version_number;
2023: IF c_rel%NOTFOUND THEN
2024: CLOSE c_rel;
2025: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
2026: fnd_message.set_token('RECORD', 'relationship');
2027: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_id));
2028: fnd_msg_pub.add;
2029: x_return_status := fnd_api.g_ret_sts_error;

Line 2026: fnd_message.set_token('RECORD', 'relationship');

2022: FETCH c_rel INTO l_subject_id, l_object_id, l_robject_version_number;
2023: IF c_rel%NOTFOUND THEN
2024: CLOSE c_rel;
2025: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
2026: fnd_message.set_token('RECORD', 'relationship');
2027: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_id));
2028: fnd_msg_pub.add;
2029: x_return_status := fnd_api.g_ret_sts_error;
2030:

Line 2027: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_id));

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

Line 2733: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
2737: p_count => x_msg_count,

Line 2734: fnd_message.set_token('ERROR',SQLERRM);

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,
2737: p_count => x_msg_count,
2738: p_data => x_msg_data);

Line 2978: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
2982: p_count => x_msg_count,

Line 2979: fnd_message.set_token('ERROR',SQLERRM);

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,
2982: p_count => x_msg_count,
2983: p_data => x_msg_data);

Line 3299: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
3303: p_count => x_msg_count,

Line 3300: fnd_message.set_token('ERROR',SQLERRM);

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,
3303: p_count => x_msg_count,
3304: p_data => x_msg_data);

Line 3633: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
3637: p_count => x_msg_count,

Line 3634: fnd_message.set_token('ERROR',SQLERRM);

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,
3637: p_count => x_msg_count,
3638: p_data => x_msg_data);

Line 3799: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
3803: p_count => x_msg_count,

Line 3800: fnd_message.set_token('ERROR',SQLERRM);

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,
3803: p_count => x_msg_count,
3804: p_data => x_msg_data);

Line 3963: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
3967: p_count => x_msg_count,

Line 3964: fnd_message.set_token('ERROR',SQLERRM);

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,
3967: p_count => x_msg_count,
3968: p_data => x_msg_data);

Line 4136: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
4140: p_count => x_msg_count,

Line 4137: fnd_message.set_token('ERROR',SQLERRM);

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,
4140: p_count => x_msg_count,
4141: p_data => x_msg_data);

Line 4306: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
4310: p_count => x_msg_count,

Line 4307: fnd_message.set_token('ERROR',SQLERRM);

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,
4310: p_count => x_msg_count,
4311: p_data => x_msg_data);

Line 4480: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
4484: p_count => x_msg_count,

Line 4481: fnd_message.set_token('ERROR',SQLERRM);

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,
4484: p_count => x_msg_count,
4485: p_data => x_msg_data);

Line 4651: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
4655: p_count => x_msg_count,

Line 4652: fnd_message.set_token('ERROR',SQLERRM);

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,
4655: p_count => x_msg_count,
4656: p_data => x_msg_data);

Line 4818: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
4822: p_count => x_msg_count,

Line 4819: fnd_message.set_token('ERROR',SQLERRM);

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,
4822: p_count => x_msg_count,
4823: p_data => x_msg_data);

Line 4982: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
4986: p_count => x_msg_count,

Line 4983: fnd_message.set_token('ERROR',SQLERRM);

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,
4986: p_count => x_msg_count,
4987: p_data => x_msg_data);

Line 5154: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
5158: p_count => x_msg_count,

Line 5155: fnd_message.set_token('ERROR',SQLERRM);

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,
5158: p_count => x_msg_count,
5159: p_data => x_msg_data);

Line 5326: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
5330: p_count => x_msg_count,

Line 5327: fnd_message.set_token('ERROR',SQLERRM);

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,
5330: p_count => x_msg_count,
5331: p_data => x_msg_data);

Line 5498: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
5502: p_count => x_msg_count,

Line 5499: fnd_message.set_token('ERROR',SQLERRM);

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,
5502: p_count => x_msg_count,
5503: p_data => x_msg_data);

Line 5670: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
5674: p_count => x_msg_count,

Line 5671: fnd_message.set_token('ERROR',SQLERRM);

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,
5674: p_count => x_msg_count,
5675: p_data => x_msg_data);

Line 5842: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
5846: p_count => x_msg_count,

Line 5843: fnd_message.set_token('ERROR',SQLERRM);

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,
5846: p_count => x_msg_count,
5847: p_data => x_msg_data);

Line 6014: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
6018: p_count => x_msg_count,

Line 6015: fnd_message.set_token('ERROR',SQLERRM);

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,
6018: p_count => x_msg_count,
6019: p_data => x_msg_data);

Line 6186: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
6190: p_count => x_msg_count,

Line 6187: fnd_message.set_token('ERROR',SQLERRM);

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,
6190: p_count => x_msg_count,
6191: p_data => x_msg_data);

Line 6358: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
6362: p_count => x_msg_count,

Line 6359: fnd_message.set_token('ERROR',SQLERRM);

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,
6362: p_count => x_msg_count,
6363: p_data => x_msg_data);

Line 6530: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
6534: p_count => x_msg_count,

Line 6531: fnd_message.set_token('ERROR',SQLERRM);

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,
6534: p_count => x_msg_count,
6535: p_data => x_msg_data);

Line 6702: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
6706: p_count => x_msg_count,

Line 6703: fnd_message.set_token('ERROR',SQLERRM);

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,
6706: p_count => x_msg_count,
6707: p_data => x_msg_data);

Line 6874: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
6878: p_count => x_msg_count,

Line 6875: fnd_message.set_token('ERROR',SQLERRM);

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,
6878: p_count => x_msg_count,
6879: p_data => x_msg_data);

Line 7047: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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,
7051: p_count => x_msg_count,

Line 7048: fnd_message.set_token('ERROR',SQLERRM);

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,
7051: p_count => x_msg_count,
7052: p_data => x_msg_data);

Line 7141: fnd_message.set_name('AR', 'HZ_INVALID_BATCH_PARAM');

7137: IF (p_mode IS NULL OR
7138: p_mode <> 'I' AND
7139: p_mode <> 'U')
7140: THEN
7141: fnd_message.set_name('AR', 'HZ_INVALID_BATCH_PARAM');
7142: fnd_message.set_token('PARAMTER', 'p_mode');
7143: fnd_msg_pub.add;
7144: raise fnd_api.g_exc_error;
7145: END IF;

Line 7142: fnd_message.set_token('PARAMTER', 'p_mode');

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

Line 7243: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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;
7246:
7247: fnd_msg_pub.Count_And_Get (

Line 7244: fnd_message.set_token('ERROR' ,SQLERRM);

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;
7246:
7247: fnd_msg_pub.Count_And_Get (
7248: p_encoded => fnd_api.G_FALSE,

Line 7344: fnd_message.set_name('AR', 'HZ_INVALID_BATCH_PARAM');

7340: IF (p_mode IS NULL OR
7341: p_mode <> 'I' AND
7342: p_mode <> 'U')
7343: THEN
7344: fnd_message.set_name('AR', 'HZ_INVALID_BATCH_PARAM');
7345: fnd_message.set_token('PARAMTER', 'p_mode');
7346: fnd_msg_pub.add;
7347: raise fnd_api.g_exc_error;
7348: END IF;

Line 7345: fnd_message.set_token('PARAMTER', 'p_mode');

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

Line 7458: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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;
7461:
7462: fnd_msg_pub.Count_And_Get (

Line 7459: fnd_message.set_token('ERROR' ,SQLERRM);

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;
7461:
7462: fnd_msg_pub.Count_And_Get (
7463: p_encoded => fnd_api.G_FALSE,