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 227: fnd_message.set_name('AR', 'HZ_BANK_INVALID_PARENT');

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

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

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

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

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

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

287: IF (p_mode = g_insert
288: OR p_bank_rec.organization_rec.home_country IS NOT NULL)
289: AND NVL(l_parent_country, fnd_api.g_miss_char) <> p_bank_rec.organization_rec.home_country
290: THEN
291: fnd_message.set_name('AR', 'HZ_BANK_INVALID_COUNTRY');
292: fnd_message.set_token('INVCOUNTRY', p_bank_rec.organization_rec.home_country);
293: fnd_message.set_token('VLDCOUNTRY', l_parent_country);
294: fnd_msg_pub.add;
295: x_return_status := fnd_api.g_ret_sts_error;

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

288: OR p_bank_rec.organization_rec.home_country IS NOT NULL)
289: AND NVL(l_parent_country, fnd_api.g_miss_char) <> p_bank_rec.organization_rec.home_country
290: THEN
291: fnd_message.set_name('AR', 'HZ_BANK_INVALID_COUNTRY');
292: fnd_message.set_token('INVCOUNTRY', p_bank_rec.organization_rec.home_country);
293: fnd_message.set_token('VLDCOUNTRY', l_parent_country);
294: fnd_msg_pub.add;
295: x_return_status := fnd_api.g_ret_sts_error;
296: END IF;

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

289: AND NVL(l_parent_country, fnd_api.g_miss_char) <> p_bank_rec.organization_rec.home_country
290: THEN
291: fnd_message.set_name('AR', 'HZ_BANK_INVALID_COUNTRY');
292: fnd_message.set_token('INVCOUNTRY', p_bank_rec.organization_rec.home_country);
293: fnd_message.set_token('VLDCOUNTRY', l_parent_country);
294: fnd_msg_pub.add;
295: x_return_status := fnd_api.g_ret_sts_error;
296: END IF;
297:

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

308: --
309: OPEN c_uniquenumberck(l_parent_id);
310: FETCH c_uniquenumberck INTO l_dummy;
311: IF c_uniquenumberck%FOUND THEN
312: fnd_message.set_name('AR', 'HZ_BANK_NONUNIQUE_NUMBER');
313: fnd_message.set_token('BANK', l_parent_number);
314: fnd_message.set_token('BRANCH', p_bank_rec.bank_or_branch_number);
315: fnd_message.set_token('COUNTRY', l_parent_country);
316: fnd_msg_pub.add;

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

309: OPEN c_uniquenumberck(l_parent_id);
310: FETCH c_uniquenumberck INTO l_dummy;
311: IF c_uniquenumberck%FOUND THEN
312: fnd_message.set_name('AR', 'HZ_BANK_NONUNIQUE_NUMBER');
313: fnd_message.set_token('BANK', l_parent_number);
314: fnd_message.set_token('BRANCH', p_bank_rec.bank_or_branch_number);
315: fnd_message.set_token('COUNTRY', l_parent_country);
316: fnd_msg_pub.add;
317: x_return_status := fnd_api.g_ret_sts_error;

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

310: FETCH c_uniquenumberck INTO l_dummy;
311: IF c_uniquenumberck%FOUND THEN
312: fnd_message.set_name('AR', 'HZ_BANK_NONUNIQUE_NUMBER');
313: fnd_message.set_token('BANK', l_parent_number);
314: fnd_message.set_token('BRANCH', p_bank_rec.bank_or_branch_number);
315: fnd_message.set_token('COUNTRY', l_parent_country);
316: fnd_msg_pub.add;
317: x_return_status := fnd_api.g_ret_sts_error;
318: END IF;

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

311: IF c_uniquenumberck%FOUND THEN
312: fnd_message.set_name('AR', 'HZ_BANK_NONUNIQUE_NUMBER');
313: fnd_message.set_token('BANK', l_parent_number);
314: fnd_message.set_token('BRANCH', p_bank_rec.bank_or_branch_number);
315: fnd_message.set_token('COUNTRY', l_parent_country);
316: fnd_msg_pub.add;
317: x_return_status := fnd_api.g_ret_sts_error;
318: END IF;
319: CLOSE c_uniquenumberck;

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

324: --
325: OPEN c_uniquenameck(l_parent_id);
326: FETCH c_uniquenameck INTO l_dummy;
327: IF c_uniquenameck%FOUND THEN
328: fnd_message.set_name('AR', 'HZ_BANK_NONUNIQUE_NAME');
329: fnd_message.set_token('BANK', l_parent_name);
330: fnd_message.set_token('BRANCH',
331: p_bank_rec.organization_rec.organization_name);
332: fnd_msg_pub.add;

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

325: OPEN c_uniquenameck(l_parent_id);
326: FETCH c_uniquenameck INTO l_dummy;
327: IF c_uniquenameck%FOUND THEN
328: fnd_message.set_name('AR', 'HZ_BANK_NONUNIQUE_NAME');
329: fnd_message.set_token('BANK', l_parent_name);
330: fnd_message.set_token('BRANCH',
331: p_bank_rec.organization_rec.organization_name);
332: fnd_msg_pub.add;
333: x_return_status := fnd_api.g_ret_sts_error;

Line 330: fnd_message.set_token('BRANCH',

326: FETCH c_uniquenameck INTO l_dummy;
327: IF c_uniquenameck%FOUND THEN
328: fnd_message.set_name('AR', 'HZ_BANK_NONUNIQUE_NAME');
329: fnd_message.set_token('BANK', l_parent_name);
330: fnd_message.set_token('BRANCH',
331: p_bank_rec.organization_rec.organization_name);
332: fnd_msg_pub.add;
333: x_return_status := fnd_api.g_ret_sts_error;
334: END IF;

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

396: -- IF p_mode = g_insert
397: -- AND p_bank_rec.bank_code IS NULL
398: -- AND p_bank_rec.branch_code IS NULL
399: -- THEN
400: -- fnd_message.set_name('AR', 'HZ_API_MAND_DEP_FIELDS');
401: -- fnd_message.set_token('COLUMN1', 'bank or branch number');
402: -- fnd_message.set_token('VALUE1', 'NULL');
403: -- fnd_message.set_token('COLUMN2', 'bank or branch number');
404: -- fnd_msg_pub.add;

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

397: -- AND p_bank_rec.bank_code IS NULL
398: -- AND p_bank_rec.branch_code IS NULL
399: -- THEN
400: -- fnd_message.set_name('AR', 'HZ_API_MAND_DEP_FIELDS');
401: -- fnd_message.set_token('COLUMN1', 'bank or branch number');
402: -- fnd_message.set_token('VALUE1', 'NULL');
403: -- fnd_message.set_token('COLUMN2', 'bank or branch number');
404: -- fnd_msg_pub.add;
405: -- x_return_status := fnd_api.g_ret_sts_error;

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

398: -- AND p_bank_rec.branch_code IS NULL
399: -- THEN
400: -- fnd_message.set_name('AR', 'HZ_API_MAND_DEP_FIELDS');
401: -- fnd_message.set_token('COLUMN1', 'bank or branch number');
402: -- fnd_message.set_token('VALUE1', 'NULL');
403: -- fnd_message.set_token('COLUMN2', 'bank or branch number');
404: -- fnd_msg_pub.add;
405: -- x_return_status := fnd_api.g_ret_sts_error;
406: -- END IF;

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

399: -- THEN
400: -- fnd_message.set_name('AR', 'HZ_API_MAND_DEP_FIELDS');
401: -- fnd_message.set_token('COLUMN1', 'bank or branch number');
402: -- fnd_message.set_token('VALUE1', 'NULL');
403: -- fnd_message.set_token('COLUMN2', 'bank or branch number');
404: -- fnd_msg_pub.add;
405: -- x_return_status := fnd_api.g_ret_sts_error;
406: -- END IF;
407:

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

407:
408: IF p_intended_type = 'BANK' THEN
409: -- branch code must be null
410: IF p_bank_rec.branch_code IS NOT NULL THEN
411: fnd_message.set_name('AR', 'HZ_BANK_BRANCH_SPECIFIED');
412: fnd_msg_pub.add;
413: x_return_status := fnd_api.g_ret_sts_error;
414: END IF;
415:

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

414: END IF;
415:
416: -- bank institution type must be either CLEARINGHOUSE OR BANK
417: IF p_bank_rec.institution_type NOT IN ('BANK', 'CLEARINGHOUSE') THEN
418: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
419: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE, BANK');
420: fnd_message.set_token('INVALIDSUB', p_bank_rec.institution_type);
421: fnd_msg_pub.add;
422: x_return_status := fnd_api.g_ret_sts_error;

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

415:
416: -- bank institution type must be either CLEARINGHOUSE OR BANK
417: IF p_bank_rec.institution_type NOT IN ('BANK', 'CLEARINGHOUSE') THEN
418: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
419: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE, BANK');
420: fnd_message.set_token('INVALIDSUB', p_bank_rec.institution_type);
421: fnd_msg_pub.add;
422: x_return_status := fnd_api.g_ret_sts_error;
423: END IF;

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

416: -- bank institution type must be either CLEARINGHOUSE OR BANK
417: IF p_bank_rec.institution_type NOT IN ('BANK', 'CLEARINGHOUSE') THEN
418: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
419: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE, BANK');
420: fnd_message.set_token('INVALIDSUB', p_bank_rec.institution_type);
421: fnd_msg_pub.add;
422: x_return_status := fnd_api.g_ret_sts_error;
423: END IF;
424:

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

428: -- Bug 2835472 Added Clearinghouse_branch as valid institution type.
429: -- bank institution type must be BANK BRANCH or CLEARINGHOUSE_BRANCH
430: IF p_bank_rec.institution_type
431: NOT IN ('BANK_BRANCH', 'CLEARINGHOUSE_BRANCH') THEN
432: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
433: fnd_message.set_token('VALIDSUB', 'BANK_BRANCH, CLEARINGHOUSE_BRANCH');
434: fnd_message.set_token('INVALIDSUB', p_bank_rec.institution_type);
435: fnd_msg_pub.add;
436: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

430: IF p_bank_rec.institution_type
431: NOT IN ('BANK_BRANCH', 'CLEARINGHOUSE_BRANCH') THEN
432: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
433: fnd_message.set_token('VALIDSUB', 'BANK_BRANCH, CLEARINGHOUSE_BRANCH');
434: fnd_message.set_token('INVALIDSUB', p_bank_rec.institution_type);
435: fnd_msg_pub.add;
436: x_return_status := fnd_api.g_ret_sts_error;
437: END IF;
438:

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

456: -- Close the cursor and raise an error if the group ID could not be
457: -- selected from the sequence.
458: CLOSE orgidcur;
459:
460: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
461: fnd_message.set_token('SEQUENCE', 'hz_parties_s'); -- Bug 3397488
462: fnd_msg_pub.add;
463: RAISE fnd_api.g_exc_error;
464: END IF;

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

457: -- selected from the sequence.
458: CLOSE orgidcur;
459:
460: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
461: fnd_message.set_token('SEQUENCE', 'hz_parties_s'); -- Bug 3397488
462: fnd_msg_pub.add;
463: RAISE fnd_api.g_exc_error;
464: END IF;
465: CLOSE orgidcur;

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

612: -- first check across party contacts.
613: OPEN c_uniqueptyedi;
614: FETCH c_uniqueptyedi INTO l_dummy;
615: IF c_uniqueptyedi%FOUND THEN
616: fnd_message.set_name('AR', 'HZ_EDI_UNIQUE');
617: fnd_msg_pub.add;
618: x_return_status := fnd_api.g_ret_sts_error;
619: ELSE
620: -- party contacts passed, check across party site contacts.

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

620: -- party contacts passed, check across party site contacts.
621: OPEN c_uniquepsedi;
622: FETCH c_uniquepsedi INTO l_dummy;
623: IF c_uniquepsedi%FOUND THEN
624: fnd_message.set_name('AR', 'HZ_EDI_UNIQUE');
625: fnd_msg_pub.add;
626: x_return_status := fnd_api.g_ret_sts_error;
627: END IF;
628: CLOSE c_uniquepsedi;

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

1009: END IF;
1010:
1011: -- Only one group type is currently supported.
1012: IF p_group_rec.group_type <> 'BANKING_GROUP' THEN
1013: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1014: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1015: fnd_message.set_token('INVALIDSUB', p_group_rec.group_type);
1016: fnd_msg_pub.add;
1017: x_return_status := fnd_api.g_ret_sts_error;

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

1010:
1011: -- Only one group type is currently supported.
1012: IF p_group_rec.group_type <> 'BANKING_GROUP' THEN
1013: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1014: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1015: fnd_message.set_token('INVALIDSUB', p_group_rec.group_type);
1016: fnd_msg_pub.add;
1017: x_return_status := fnd_api.g_ret_sts_error;
1018: END IF;

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

1011: -- Only one group type is currently supported.
1012: IF p_group_rec.group_type <> 'BANKING_GROUP' THEN
1013: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1014: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1015: fnd_message.set_token('INVALIDSUB', p_group_rec.group_type);
1016: fnd_msg_pub.add;
1017: x_return_status := fnd_api.g_ret_sts_error;
1018: END IF;
1019:

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

1073: BEGIN
1074: OPEN c_group;
1075: FETCH c_group INTO l_group_type;
1076: IF c_group%NOTFOUND THEN
1077: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1078: fnd_message.set_token('RECORD', 'party');
1079: fnd_message.set_token('VALUE', TO_CHAR(p_party_id));
1080: fnd_msg_pub.add;
1081: x_return_status := fnd_api.g_ret_sts_error;

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

1074: OPEN c_group;
1075: FETCH c_group INTO l_group_type;
1076: IF c_group%NOTFOUND THEN
1077: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1078: fnd_message.set_token('RECORD', 'party');
1079: fnd_message.set_token('VALUE', TO_CHAR(p_party_id));
1080: fnd_msg_pub.add;
1081: x_return_status := fnd_api.g_ret_sts_error;
1082: END IF;

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

1075: FETCH c_group INTO l_group_type;
1076: IF c_group%NOTFOUND THEN
1077: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1078: fnd_message.set_token('RECORD', 'party');
1079: fnd_message.set_token('VALUE', TO_CHAR(p_party_id));
1080: fnd_msg_pub.add;
1081: x_return_status := fnd_api.g_ret_sts_error;
1082: END IF;
1083: CLOSE c_group;

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

1121: -- specified.
1122: IF (p_mode = g_insert OR p_relationship_rec.relationship_type IS NOT NULL)
1123: AND NVL(p_relationship_rec.relationship_type, 'NULL') <> 'BANKING_GROUP'
1124: THEN
1125: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1126: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1127: fnd_message.set_token('INVALIDSUB',
1128: p_relationship_rec.relationship_type);
1129: fnd_msg_pub.add;

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

1122: IF (p_mode = g_insert OR p_relationship_rec.relationship_type IS NOT NULL)
1123: AND NVL(p_relationship_rec.relationship_type, 'NULL') <> 'BANKING_GROUP'
1124: THEN
1125: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1126: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1127: fnd_message.set_token('INVALIDSUB',
1128: p_relationship_rec.relationship_type);
1129: fnd_msg_pub.add;
1130: x_return_status := fnd_api.g_ret_sts_error;

Line 1127: fnd_message.set_token('INVALIDSUB',

1123: AND NVL(p_relationship_rec.relationship_type, 'NULL') <> 'BANKING_GROUP'
1124: THEN
1125: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1126: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1127: fnd_message.set_token('INVALIDSUB',
1128: p_relationship_rec.relationship_type);
1129: fnd_msg_pub.add;
1130: x_return_status := fnd_api.g_ret_sts_error;
1131: END IF;

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

1159: -- the parent group is the object.
1160: l_parent := 'OBJECT';
1161: ELSE
1162: -- if the object is also not the right type, then this is not valid.
1163: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1164: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1165: fnd_message.set_token('INVALIDSUB', l_group_type);
1166: fnd_msg_pub.add;
1167: x_return_status := fnd_api.g_ret_sts_error;

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

1160: l_parent := 'OBJECT';
1161: ELSE
1162: -- if the object is also not the right type, then this is not valid.
1163: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1164: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1165: fnd_message.set_token('INVALIDSUB', l_group_type);
1166: fnd_msg_pub.add;
1167: x_return_status := fnd_api.g_ret_sts_error;
1168:

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

1161: ELSE
1162: -- if the object is also not the right type, then this is not valid.
1163: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1164: fnd_message.set_token('VALIDSUB', 'BANKING_GROUP');
1165: fnd_message.set_token('INVALIDSUB', l_group_type);
1166: fnd_msg_pub.add;
1167: x_return_status := fnd_api.g_ret_sts_error;
1168:
1169: -- return, the rest of the validations do not make sense if neither

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

1184: -- specified.
1185: IF ((l_parent = 'SUBJECT' AND l_direction <> 'P')
1186: OR (l_parent = 'OBJECT' AND l_direction <> 'C'))
1187: THEN
1188: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1189: IF l_parent = 'SUBJECT' THEN
1190: fnd_message.set_token('VALIDSUB', 'P');
1191: ELSE
1192: fnd_message.set_token('VALIDSUB', 'C');

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

1186: OR (l_parent = 'OBJECT' AND l_direction <> 'C'))
1187: THEN
1188: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1189: IF l_parent = 'SUBJECT' THEN
1190: fnd_message.set_token('VALIDSUB', 'P');
1191: ELSE
1192: fnd_message.set_token('VALIDSUB', 'C');
1193: END IF;
1194: fnd_message.set_token('INVALIDSUB', l_direction);

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

1188: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1189: IF l_parent = 'SUBJECT' THEN
1190: fnd_message.set_token('VALIDSUB', 'P');
1191: ELSE
1192: fnd_message.set_token('VALIDSUB', 'C');
1193: END IF;
1194: fnd_message.set_token('INVALIDSUB', l_direction);
1195: fnd_msg_pub.add;
1196: x_return_status := fnd_api.g_ret_sts_error;

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

1190: fnd_message.set_token('VALIDSUB', 'P');
1191: ELSE
1192: fnd_message.set_token('VALIDSUB', 'C');
1193: END IF;
1194: fnd_message.set_token('INVALIDSUB', l_direction);
1195: fnd_msg_pub.add;
1196: x_return_status := fnd_api.g_ret_sts_error;
1197: END IF;
1198: ELSE

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

1195: fnd_msg_pub.add;
1196: x_return_status := fnd_api.g_ret_sts_error;
1197: END IF;
1198: ELSE
1199: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1200: fnd_message.set_token('RECORD', 'banking group relationship type');
1201: fnd_message.set_token('VALUE', p_relationship_rec.relationship_type);
1202: fnd_msg_pub.add;
1203: x_return_status := fnd_api.g_ret_sts_error;

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

1196: x_return_status := fnd_api.g_ret_sts_error;
1197: END IF;
1198: ELSE
1199: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1200: fnd_message.set_token('RECORD', 'banking group relationship type');
1201: fnd_message.set_token('VALUE', p_relationship_rec.relationship_type);
1202: fnd_msg_pub.add;
1203: x_return_status := fnd_api.g_ret_sts_error;
1204: END IF;

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

1197: END IF;
1198: ELSE
1199: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1200: fnd_message.set_token('RECORD', 'banking group relationship type');
1201: fnd_message.set_token('VALUE', p_relationship_rec.relationship_type);
1202: fnd_msg_pub.add;
1203: x_return_status := fnd_api.g_ret_sts_error;
1204: END IF;
1205: CLOSE c_reldir;

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

1218:
1219: OPEN c_codeassign(l_bank_id);
1220: FETCH c_codeassign INTO l_class_code;
1221: IF c_codeassign%NOTFOUND THEN
1222: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1223: fnd_message.set_token('RECORD', 'bank classification code assignment');
1224: fnd_message.set_token('VALUE', TO_CHAR(l_bank_id));
1225: fnd_msg_pub.add;
1226: x_return_status := fnd_api.g_ret_sts_error;

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

1219: OPEN c_codeassign(l_bank_id);
1220: FETCH c_codeassign INTO l_class_code;
1221: IF c_codeassign%NOTFOUND THEN
1222: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1223: fnd_message.set_token('RECORD', 'bank classification code assignment');
1224: fnd_message.set_token('VALUE', TO_CHAR(l_bank_id));
1225: fnd_msg_pub.add;
1226: x_return_status := fnd_api.g_ret_sts_error;
1227: END IF;

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

1220: FETCH c_codeassign INTO l_class_code;
1221: IF c_codeassign%NOTFOUND THEN
1222: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1223: fnd_message.set_token('RECORD', 'bank classification code assignment');
1224: fnd_message.set_token('VALUE', TO_CHAR(l_bank_id));
1225: fnd_msg_pub.add;
1226: x_return_status := fnd_api.g_ret_sts_error;
1227: END IF;
1228:

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

1228:
1229: IF l_class_code IS NOT NULL
1230: AND l_class_code NOT IN ('BANK', 'CLEARINGHOUSE')
1231: THEN
1232: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1233: fnd_message.set_token('VALIDSUB', 'BANK, CLEARINGHOUSE');
1234: fnd_message.set_token('INVALIDSUB', l_class_code);
1235: fnd_msg_pub.add;
1236: x_return_status := fnd_api.g_ret_sts_error;

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

1229: IF l_class_code IS NOT NULL
1230: AND l_class_code NOT IN ('BANK', 'CLEARINGHOUSE')
1231: THEN
1232: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1233: fnd_message.set_token('VALIDSUB', 'BANK, CLEARINGHOUSE');
1234: fnd_message.set_token('INVALIDSUB', l_class_code);
1235: fnd_msg_pub.add;
1236: x_return_status := fnd_api.g_ret_sts_error;
1237: END IF;

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

1230: AND l_class_code NOT IN ('BANK', 'CLEARINGHOUSE')
1231: THEN
1232: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1233: fnd_message.set_token('VALIDSUB', 'BANK, CLEARINGHOUSE');
1234: fnd_message.set_token('INVALIDSUB', l_class_code);
1235: fnd_msg_pub.add;
1236: x_return_status := fnd_api.g_ret_sts_error;
1237: END IF;
1238: CLOSE c_codeassign;

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

1306: IF (p_mode = g_insert OR p_relationship_rec.relationship_type IS NOT NULL)
1307: AND NVL(p_relationship_rec.relationship_type, 'NULL') <>
1308: 'CLEARINGHOUSE_BANK'
1309: THEN
1310: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1311: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE_BANK');
1312: fnd_message.set_token('INVALIDSUB',
1313: p_relationship_rec.relationship_type);
1314: fnd_msg_pub.add;

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

1307: AND NVL(p_relationship_rec.relationship_type, 'NULL') <>
1308: 'CLEARINGHOUSE_BANK'
1309: THEN
1310: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1311: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE_BANK');
1312: fnd_message.set_token('INVALIDSUB',
1313: p_relationship_rec.relationship_type);
1314: fnd_msg_pub.add;
1315: x_return_status := fnd_api.g_ret_sts_error;

Line 1312: fnd_message.set_token('INVALIDSUB',

1308: 'CLEARINGHOUSE_BANK'
1309: THEN
1310: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1311: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE_BANK');
1312: fnd_message.set_token('INVALIDSUB',
1313: p_relationship_rec.relationship_type);
1314: fnd_msg_pub.add;
1315: x_return_status := fnd_api.g_ret_sts_error;
1316: END IF;

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

1328:
1329: OPEN c_codeassign(p_relationship_rec.subject_id);
1330: FETCH c_codeassign INTO l_subject_class;
1331: IF c_codeassign%NOTFOUND THEN
1332: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1333: fnd_message.set_token('RECORD',
1334: 'bank/clearinghouse code assignment (subject)');
1335: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_rec.subject_id));
1336: fnd_msg_pub.add;

Line 1333: fnd_message.set_token('RECORD',

1329: OPEN c_codeassign(p_relationship_rec.subject_id);
1330: FETCH c_codeassign INTO l_subject_class;
1331: IF c_codeassign%NOTFOUND THEN
1332: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1333: fnd_message.set_token('RECORD',
1334: 'bank/clearinghouse code assignment (subject)');
1335: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_rec.subject_id));
1336: fnd_msg_pub.add;
1337: x_return_status := fnd_api.g_ret_sts_error;

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

1331: IF c_codeassign%NOTFOUND THEN
1332: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1333: fnd_message.set_token('RECORD',
1334: 'bank/clearinghouse code assignment (subject)');
1335: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_rec.subject_id));
1336: fnd_msg_pub.add;
1337: x_return_status := fnd_api.g_ret_sts_error;
1338: ELSIF l_subject_class NOT IN ('CLEARINGHOUSE', 'BANK', 'BANK_BRANCH')
1339: THEN

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

1336: fnd_msg_pub.add;
1337: x_return_status := fnd_api.g_ret_sts_error;
1338: ELSIF l_subject_class NOT IN ('CLEARINGHOUSE', 'BANK', 'BANK_BRANCH')
1339: THEN
1340: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1341: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE, BANK');
1342: fnd_message.set_token('INVALIDSUB', l_subject_class);
1343: fnd_msg_pub.add;
1344: x_return_status := fnd_api.g_ret_sts_error;

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

1337: x_return_status := fnd_api.g_ret_sts_error;
1338: ELSIF l_subject_class NOT IN ('CLEARINGHOUSE', 'BANK', 'BANK_BRANCH')
1339: THEN
1340: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1341: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE, BANK');
1342: fnd_message.set_token('INVALIDSUB', l_subject_class);
1343: fnd_msg_pub.add;
1344: x_return_status := fnd_api.g_ret_sts_error;
1345: END IF;

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

1338: ELSIF l_subject_class NOT IN ('CLEARINGHOUSE', 'BANK', 'BANK_BRANCH')
1339: THEN
1340: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1341: fnd_message.set_token('VALIDSUB', 'CLEARINGHOUSE, BANK');
1342: fnd_message.set_token('INVALIDSUB', l_subject_class);
1343: fnd_msg_pub.add;
1344: x_return_status := fnd_api.g_ret_sts_error;
1345: END IF;
1346: CLOSE c_codeassign;

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

1352:
1353: OPEN c_codeassign(p_relationship_rec.object_id);
1354: FETCH c_codeassign INTO l_object_class;
1355: IF c_codeassign%NOTFOUND THEN
1356: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1357: fnd_message.set_token('RECORD',
1358: 'bank/clearinghouse code assignment (object)');
1359: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_rec.object_id));
1360: fnd_msg_pub.add;

Line 1357: fnd_message.set_token('RECORD',

1353: OPEN c_codeassign(p_relationship_rec.object_id);
1354: FETCH c_codeassign INTO l_object_class;
1355: IF c_codeassign%NOTFOUND THEN
1356: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1357: fnd_message.set_token('RECORD',
1358: 'bank/clearinghouse code assignment (object)');
1359: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_rec.object_id));
1360: fnd_msg_pub.add;
1361: x_return_status := fnd_api.g_ret_sts_error;

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

1355: IF c_codeassign%NOTFOUND THEN
1356: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1357: fnd_message.set_token('RECORD',
1358: 'bank/clearinghouse code assignment (object)');
1359: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_rec.object_id));
1360: fnd_msg_pub.add;
1361: x_return_status := fnd_api.g_ret_sts_error;
1362: ELSIF l_object_class NOT IN ('CLEARINGHOUSE', 'BANK', 'BANK_BRANCH') THEN
1363: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');

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

1359: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_rec.object_id));
1360: fnd_msg_pub.add;
1361: x_return_status := fnd_api.g_ret_sts_error;
1362: ELSIF l_object_class NOT IN ('CLEARINGHOUSE', 'BANK', 'BANK_BRANCH') THEN
1363: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1364: fnd_message.set_token('VALIDSUB', 'BANK, CLEARINGHOUSE');
1365: fnd_message.set_token('INVALIDSUB', l_object_class);
1366: fnd_msg_pub.add;
1367: x_return_status := fnd_api.g_ret_sts_error;

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

1360: fnd_msg_pub.add;
1361: x_return_status := fnd_api.g_ret_sts_error;
1362: ELSIF l_object_class NOT IN ('CLEARINGHOUSE', 'BANK', 'BANK_BRANCH') THEN
1363: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1364: fnd_message.set_token('VALIDSUB', 'BANK, CLEARINGHOUSE');
1365: fnd_message.set_token('INVALIDSUB', l_object_class);
1366: fnd_msg_pub.add;
1367: x_return_status := fnd_api.g_ret_sts_error;
1368: ELSIF l_subject_class = l_object_class THEN

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

1361: x_return_status := fnd_api.g_ret_sts_error;
1362: ELSIF l_object_class NOT IN ('CLEARINGHOUSE', 'BANK', 'BANK_BRANCH') THEN
1363: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1364: fnd_message.set_token('VALIDSUB', 'BANK, CLEARINGHOUSE');
1365: fnd_message.set_token('INVALIDSUB', l_object_class);
1366: fnd_msg_pub.add;
1367: x_return_status := fnd_api.g_ret_sts_error;
1368: ELSIF l_subject_class = l_object_class THEN
1369: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');

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

1365: fnd_message.set_token('INVALIDSUB', l_object_class);
1366: fnd_msg_pub.add;
1367: x_return_status := fnd_api.g_ret_sts_error;
1368: ELSIF l_subject_class = l_object_class THEN
1369: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1370: fnd_message.set_token('VALIDSUB', 'different');
1371: fnd_message.set_token('INVALIDSUB', l_object_class);
1372: fnd_msg_pub.add;
1373: x_return_status := fnd_api.g_ret_sts_error;

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

1366: fnd_msg_pub.add;
1367: x_return_status := fnd_api.g_ret_sts_error;
1368: ELSIF l_subject_class = l_object_class THEN
1369: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1370: fnd_message.set_token('VALIDSUB', 'different');
1371: fnd_message.set_token('INVALIDSUB', l_object_class);
1372: fnd_msg_pub.add;
1373: x_return_status := fnd_api.g_ret_sts_error;
1374: END IF;

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

1367: x_return_status := fnd_api.g_ret_sts_error;
1368: ELSIF l_subject_class = l_object_class THEN
1369: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1370: fnd_message.set_token('VALIDSUB', 'different');
1371: fnd_message.set_token('INVALIDSUB', l_object_class);
1372: fnd_msg_pub.add;
1373: x_return_status := fnd_api.g_ret_sts_error;
1374: END IF;
1375: CLOSE c_codeassign;

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

1387: -- specified.
1388: IF ((l_subject_class = 'CLEARINGHOUSE' AND l_direction <> 'P')
1389: OR (l_object_class = 'CLEARINGHOUSE' AND l_direction <> 'C'))
1390: THEN
1391: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1392: IF l_subject_class = 'CLEARINGHOUSE' THEN
1393: fnd_message.set_token('VALIDSUB', 'P');
1394: ELSE
1395: fnd_message.set_token('VALIDSUB', 'C');

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

1389: OR (l_object_class = 'CLEARINGHOUSE' AND l_direction <> 'C'))
1390: THEN
1391: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1392: IF l_subject_class = 'CLEARINGHOUSE' THEN
1393: fnd_message.set_token('VALIDSUB', 'P');
1394: ELSE
1395: fnd_message.set_token('VALIDSUB', 'C');
1396: END IF;
1397: fnd_message.set_token('INVALIDSUB', l_direction);

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

1391: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1392: IF l_subject_class = 'CLEARINGHOUSE' THEN
1393: fnd_message.set_token('VALIDSUB', 'P');
1394: ELSE
1395: fnd_message.set_token('VALIDSUB', 'C');
1396: END IF;
1397: fnd_message.set_token('INVALIDSUB', l_direction);
1398: fnd_msg_pub.add;
1399: x_return_status := fnd_api.g_ret_sts_error;

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

1393: fnd_message.set_token('VALIDSUB', 'P');
1394: ELSE
1395: fnd_message.set_token('VALIDSUB', 'C');
1396: END IF;
1397: fnd_message.set_token('INVALIDSUB', l_direction);
1398: fnd_msg_pub.add;
1399: x_return_status := fnd_api.g_ret_sts_error;
1400: END IF;
1401: ELSE

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

1398: fnd_msg_pub.add;
1399: x_return_status := fnd_api.g_ret_sts_error;
1400: END IF;
1401: ELSE
1402: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1403: fnd_message.set_token('RECORD',
1404: 'clearinghouse assignment relationship type');
1405: fnd_message.set_token('VALUE', p_relationship_rec.relationship_type);
1406: fnd_msg_pub.add;

Line 1403: fnd_message.set_token('RECORD',

1399: x_return_status := fnd_api.g_ret_sts_error;
1400: END IF;
1401: ELSE
1402: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1403: fnd_message.set_token('RECORD',
1404: 'clearinghouse assignment relationship type');
1405: fnd_message.set_token('VALUE', p_relationship_rec.relationship_type);
1406: fnd_msg_pub.add;
1407: x_return_status := fnd_api.g_ret_sts_error;

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

1401: ELSE
1402: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1403: fnd_message.set_token('RECORD',
1404: 'clearinghouse assignment relationship type');
1405: fnd_message.set_token('VALUE', p_relationship_rec.relationship_type);
1406: fnd_msg_pub.add;
1407: x_return_status := fnd_api.g_ret_sts_error;
1408: END IF;
1409: CLOSE c_reldir;

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

1511:
1512: IF l_party_id IS NULL OR l_location_id IS NULL THEN
1513: -- incomplete information given for the insert.
1514: IF p_mode = g_insert THEN
1515: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1516: fnd_message.set_token('FK', 'party or location');
1517: fnd_message.set_token('COLUMN', 'PARTY_ID or LOCATION_ID');
1518: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
1519: fnd_msg_pub.add;

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

1512: IF l_party_id IS NULL OR l_location_id IS NULL THEN
1513: -- incomplete information given for the insert.
1514: IF p_mode = g_insert THEN
1515: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1516: fnd_message.set_token('FK', 'party or location');
1517: fnd_message.set_token('COLUMN', 'PARTY_ID or LOCATION_ID');
1518: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
1519: fnd_msg_pub.add;
1520: x_return_status := fnd_api.g_ret_sts_error;

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

1513: -- incomplete information given for the insert.
1514: IF p_mode = g_insert THEN
1515: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1516: fnd_message.set_token('FK', 'party or location');
1517: fnd_message.set_token('COLUMN', 'PARTY_ID or LOCATION_ID');
1518: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
1519: fnd_msg_pub.add;
1520: x_return_status := fnd_api.g_ret_sts_error;
1521: -- no point doing further validations. We're missing some data.

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

1514: IF p_mode = g_insert THEN
1515: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1516: fnd_message.set_token('FK', 'party or location');
1517: fnd_message.set_token('COLUMN', 'PARTY_ID or LOCATION_ID');
1518: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
1519: fnd_msg_pub.add;
1520: x_return_status := fnd_api.g_ret_sts_error;
1521: -- no point doing further validations. We're missing some data.
1522: RETURN;

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

1525: -- get the missing information.
1526: OPEN c_site;
1527: FETCH c_site INTO l_temp_party_id, l_temp_location_id;
1528: IF c_site%NOTFOUND THEN
1529: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1530: fnd_message.set_token('FK', 'party or location');
1531: fnd_message.set_token('COLUMN', 'PARTY_ID or LOCATION_ID');
1532: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
1533: fnd_msg_pub.add;

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

1526: OPEN c_site;
1527: FETCH c_site INTO l_temp_party_id, l_temp_location_id;
1528: IF c_site%NOTFOUND THEN
1529: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1530: fnd_message.set_token('FK', 'party or location');
1531: fnd_message.set_token('COLUMN', 'PARTY_ID or LOCATION_ID');
1532: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
1533: fnd_msg_pub.add;
1534: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

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

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

1547:
1548: OPEN c_parentcountry(l_party_id);
1549: FETCH c_parentcountry INTO l_parent_country;
1550: IF c_parentcountry%NOTFOUND THEN
1551: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1552: fnd_message.set_token('FK', 'active party');
1553: fnd_message.set_token('COLUMN', 'PARTY_ID');
1554: fnd_message.set_token('TABLE', 'HZ_PARTIES');
1555: fnd_msg_pub.add;

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

1548: OPEN c_parentcountry(l_party_id);
1549: FETCH c_parentcountry INTO l_parent_country;
1550: IF c_parentcountry%NOTFOUND THEN
1551: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1552: fnd_message.set_token('FK', 'active party');
1553: fnd_message.set_token('COLUMN', 'PARTY_ID');
1554: fnd_message.set_token('TABLE', 'HZ_PARTIES');
1555: fnd_msg_pub.add;
1556: x_return_status := fnd_api.g_ret_sts_error;

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

1549: FETCH c_parentcountry INTO l_parent_country;
1550: IF c_parentcountry%NOTFOUND THEN
1551: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1552: fnd_message.set_token('FK', 'active party');
1553: fnd_message.set_token('COLUMN', 'PARTY_ID');
1554: fnd_message.set_token('TABLE', 'HZ_PARTIES');
1555: fnd_msg_pub.add;
1556: x_return_status := fnd_api.g_ret_sts_error;
1557: END IF;

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

1550: IF c_parentcountry%NOTFOUND THEN
1551: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1552: fnd_message.set_token('FK', 'active party');
1553: fnd_message.set_token('COLUMN', 'PARTY_ID');
1554: fnd_message.set_token('TABLE', 'HZ_PARTIES');
1555: fnd_msg_pub.add;
1556: x_return_status := fnd_api.g_ret_sts_error;
1557: END IF;
1558: CLOSE c_parentcountry;

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

1559:
1560: OPEN c_sitecountry(l_location_id);
1561: FETCH c_sitecountry INTO l_site_country;
1562: IF c_sitecountry%NOTFOUND THEN
1563: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1564: fnd_message.set_token('FK', 'active location');
1565: fnd_message.set_token('COLUMN', 'LOCATION_ID');
1566: fnd_message.set_token('TABLE', 'HZ_LOCATIONS');
1567: fnd_msg_pub.add;

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

1560: OPEN c_sitecountry(l_location_id);
1561: FETCH c_sitecountry INTO l_site_country;
1562: IF c_sitecountry%NOTFOUND THEN
1563: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1564: fnd_message.set_token('FK', 'active location');
1565: fnd_message.set_token('COLUMN', 'LOCATION_ID');
1566: fnd_message.set_token('TABLE', 'HZ_LOCATIONS');
1567: fnd_msg_pub.add;
1568: x_return_status := fnd_api.g_ret_sts_error;

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

1561: FETCH c_sitecountry INTO l_site_country;
1562: IF c_sitecountry%NOTFOUND THEN
1563: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1564: fnd_message.set_token('FK', 'active location');
1565: fnd_message.set_token('COLUMN', 'LOCATION_ID');
1566: fnd_message.set_token('TABLE', 'HZ_LOCATIONS');
1567: fnd_msg_pub.add;
1568: x_return_status := fnd_api.g_ret_sts_error;
1569: END IF;

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

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

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

1569: END IF;
1570: CLOSE c_sitecountry;
1571:
1572: IF l_parent_country <> l_site_country THEN
1573: fnd_message.set_name('AR', 'HZ_BANK_INVALID_COUNTRY');
1574: fnd_message.set_token('INVCOUNTRY', l_site_country);
1575: fnd_message.set_token('VLDCOUNTRY', l_parent_country);
1576: fnd_msg_pub.add;
1577: x_return_status := fnd_api.g_ret_sts_error;

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

1570: CLOSE c_sitecountry;
1571:
1572: IF l_parent_country <> l_site_country THEN
1573: fnd_message.set_name('AR', 'HZ_BANK_INVALID_COUNTRY');
1574: fnd_message.set_token('INVCOUNTRY', l_site_country);
1575: fnd_message.set_token('VLDCOUNTRY', l_parent_country);
1576: fnd_msg_pub.add;
1577: x_return_status := fnd_api.g_ret_sts_error;
1578: END IF;

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

1571:
1572: IF l_parent_country <> l_site_country THEN
1573: fnd_message.set_name('AR', 'HZ_BANK_INVALID_COUNTRY');
1574: fnd_message.set_token('INVCOUNTRY', l_site_country);
1575: fnd_message.set_token('VLDCOUNTRY', l_parent_country);
1576: fnd_msg_pub.add;
1577: x_return_status := fnd_api.g_ret_sts_error;
1578: END IF;
1579: END IF;

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

1587: THEN
1588: OPEN c_codeassign(p_party_site_rec.party_id);
1589: FETCH c_codeassign INTO l_class_code;
1590: IF c_codeassign%NOTFOUND THEN
1591: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1592: fnd_message.set_token('RECORD', 'bank-related code assignment');
1593: fnd_message.set_token('VALUE', TO_CHAR(p_party_site_rec.party_id));
1594: fnd_msg_pub.add;
1595: x_return_status := fnd_api.g_ret_sts_error;

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

1588: OPEN c_codeassign(p_party_site_rec.party_id);
1589: FETCH c_codeassign INTO l_class_code;
1590: IF c_codeassign%NOTFOUND THEN
1591: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1592: fnd_message.set_token('RECORD', 'bank-related code assignment');
1593: fnd_message.set_token('VALUE', TO_CHAR(p_party_site_rec.party_id));
1594: fnd_msg_pub.add;
1595: x_return_status := fnd_api.g_ret_sts_error;
1596: ELSIF l_class_code NOT IN ('CLEARINGHOUSE', 'BANK', 'BANK_BRANCH') THEN

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

1589: FETCH c_codeassign INTO l_class_code;
1590: IF c_codeassign%NOTFOUND THEN
1591: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1592: fnd_message.set_token('RECORD', 'bank-related code assignment');
1593: fnd_message.set_token('VALUE', TO_CHAR(p_party_site_rec.party_id));
1594: fnd_msg_pub.add;
1595: x_return_status := fnd_api.g_ret_sts_error;
1596: ELSIF l_class_code NOT IN ('CLEARINGHOUSE', 'BANK', 'BANK_BRANCH') THEN
1597: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');

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

1593: fnd_message.set_token('VALUE', TO_CHAR(p_party_site_rec.party_id));
1594: fnd_msg_pub.add;
1595: x_return_status := fnd_api.g_ret_sts_error;
1596: ELSIF l_class_code NOT IN ('CLEARINGHOUSE', 'BANK', 'BANK_BRANCH') THEN
1597: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1598: fnd_message.set_token('VALIDSUB',
1599: 'BANK, CLEARINGHOUSE, BANK_BRANCH');
1600: fnd_message.set_token('INVALIDSUB', l_class_code);
1601: fnd_msg_pub.add;

Line 1598: fnd_message.set_token('VALIDSUB',

1594: fnd_msg_pub.add;
1595: x_return_status := fnd_api.g_ret_sts_error;
1596: ELSIF l_class_code NOT IN ('CLEARINGHOUSE', 'BANK', 'BANK_BRANCH') THEN
1597: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1598: fnd_message.set_token('VALIDSUB',
1599: 'BANK, CLEARINGHOUSE, BANK_BRANCH');
1600: fnd_message.set_token('INVALIDSUB', l_class_code);
1601: fnd_msg_pub.add;
1602: x_return_status := fnd_api.g_ret_sts_error;

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

1596: ELSIF l_class_code NOT IN ('CLEARINGHOUSE', 'BANK', 'BANK_BRANCH') THEN
1597: fnd_message.set_name('AR', 'HZ_BANK_INVALID_TYPE');
1598: fnd_message.set_token('VALIDSUB',
1599: 'BANK, CLEARINGHOUSE, BANK_BRANCH');
1600: fnd_message.set_token('INVALIDSUB', l_class_code);
1601: fnd_msg_pub.add;
1602: x_return_status := fnd_api.g_ret_sts_error;
1603: END IF;
1604: CLOSE c_codeassign;

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

2009: OPEN c_rel;
2010: FETCH c_rel INTO l_subject_id, l_object_id, l_robject_version_number;
2011: IF c_rel%NOTFOUND THEN
2012: CLOSE c_rel;
2013: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
2014: fnd_message.set_token('RECORD', 'relationship');
2015: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_id));
2016: fnd_msg_pub.add;
2017: x_return_status := fnd_api.g_ret_sts_error;

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

2010: FETCH c_rel INTO l_subject_id, l_object_id, l_robject_version_number;
2011: IF c_rel%NOTFOUND THEN
2012: CLOSE c_rel;
2013: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
2014: fnd_message.set_token('RECORD', 'relationship');
2015: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_id));
2016: fnd_msg_pub.add;
2017: x_return_status := fnd_api.g_ret_sts_error;
2018:

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

2011: IF c_rel%NOTFOUND THEN
2012: CLOSE c_rel;
2013: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
2014: fnd_message.set_token('RECORD', 'relationship');
2015: fnd_message.set_token('VALUE', TO_CHAR(p_relationship_id));
2016: fnd_msg_pub.add;
2017: x_return_status := fnd_api.g_ret_sts_error;
2018:
2019: -- Debug info.

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

2714:
2715: WHEN OTHERS THEN
2716: ROLLBACK TO create_bank;
2717: x_return_status := fnd_api.g_ret_sts_unexp_error;
2718: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2719: fnd_message.set_token('ERROR',SQLERRM);
2720: fnd_msg_pub.add;
2721: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2722: p_count => x_msg_count,

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

2715: WHEN OTHERS THEN
2716: ROLLBACK TO create_bank;
2717: x_return_status := fnd_api.g_ret_sts_unexp_error;
2718: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2719: fnd_message.set_token('ERROR',SQLERRM);
2720: fnd_msg_pub.add;
2721: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2722: p_count => x_msg_count,
2723: p_data => x_msg_data);

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

2959:
2960: WHEN OTHERS THEN
2961: ROLLBACK TO update_bank;
2962: x_return_status := fnd_api.g_ret_sts_unexp_error;
2963: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2964: fnd_message.set_token('ERROR',SQLERRM);
2965: fnd_msg_pub.add;
2966: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2967: p_count => x_msg_count,

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

2960: WHEN OTHERS THEN
2961: ROLLBACK TO update_bank;
2962: x_return_status := fnd_api.g_ret_sts_unexp_error;
2963: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2964: fnd_message.set_token('ERROR',SQLERRM);
2965: fnd_msg_pub.add;
2966: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2967: p_count => x_msg_count,
2968: p_data => x_msg_data);

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

3276:
3277: WHEN OTHERS THEN
3278: ROLLBACK TO create_bank_branch;
3279: x_return_status := fnd_api.g_ret_sts_unexp_error;
3280: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3281: fnd_message.set_token('ERROR',SQLERRM);
3282: fnd_msg_pub.add;
3283: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3284: p_count => x_msg_count,

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

3277: WHEN OTHERS THEN
3278: ROLLBACK TO create_bank_branch;
3279: x_return_status := fnd_api.g_ret_sts_unexp_error;
3280: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3281: fnd_message.set_token('ERROR',SQLERRM);
3282: fnd_msg_pub.add;
3283: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3284: p_count => x_msg_count,
3285: p_data => x_msg_data);

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

3606:
3607: WHEN OTHERS THEN
3608: ROLLBACK TO update_bank_branch;
3609: x_return_status := fnd_api.g_ret_sts_unexp_error;
3610: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3611: fnd_message.set_token('ERROR',SQLERRM);
3612: fnd_msg_pub.add;
3613: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3614: p_count => x_msg_count,

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

3607: WHEN OTHERS THEN
3608: ROLLBACK TO update_bank_branch;
3609: x_return_status := fnd_api.g_ret_sts_unexp_error;
3610: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3611: fnd_message.set_token('ERROR',SQLERRM);
3612: fnd_msg_pub.add;
3613: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3614: p_count => x_msg_count,
3615: p_data => x_msg_data);

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

3772:
3773: WHEN OTHERS THEN
3774: ROLLBACK TO create_banking_group;
3775: x_return_status := fnd_api.g_ret_sts_unexp_error;
3776: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3777: fnd_message.set_token('ERROR',SQLERRM);
3778: fnd_msg_pub.add;
3779: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3780: p_count => x_msg_count,

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

3773: WHEN OTHERS THEN
3774: ROLLBACK TO create_banking_group;
3775: x_return_status := fnd_api.g_ret_sts_unexp_error;
3776: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3777: fnd_message.set_token('ERROR',SQLERRM);
3778: fnd_msg_pub.add;
3779: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3780: p_count => x_msg_count,
3781: p_data => x_msg_data);

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

3936:
3937: WHEN OTHERS THEN
3938: ROLLBACK TO update_banking_group;
3939: x_return_status := fnd_api.g_ret_sts_unexp_error;
3940: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3941: fnd_message.set_token('ERROR',SQLERRM);
3942: fnd_msg_pub.add;
3943: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3944: p_count => x_msg_count,

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

3937: WHEN OTHERS THEN
3938: ROLLBACK TO update_banking_group;
3939: x_return_status := fnd_api.g_ret_sts_unexp_error;
3940: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3941: fnd_message.set_token('ERROR',SQLERRM);
3942: fnd_msg_pub.add;
3943: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3944: p_count => x_msg_count,
3945: p_data => x_msg_data);

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

4109:
4110: WHEN OTHERS THEN
4111: ROLLBACK TO create_bank_group_member;
4112: x_return_status := fnd_api.g_ret_sts_unexp_error;
4113: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4114: fnd_message.set_token('ERROR',SQLERRM);
4115: fnd_msg_pub.add;
4116: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4117: p_count => x_msg_count,

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

4110: WHEN OTHERS THEN
4111: ROLLBACK TO create_bank_group_member;
4112: x_return_status := fnd_api.g_ret_sts_unexp_error;
4113: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4114: fnd_message.set_token('ERROR',SQLERRM);
4115: fnd_msg_pub.add;
4116: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4117: p_count => x_msg_count,
4118: p_data => x_msg_data);

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

4279:
4280: WHEN OTHERS THEN
4281: ROLLBACK TO update_bank_group_member;
4282: x_return_status := fnd_api.g_ret_sts_unexp_error;
4283: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4284: fnd_message.set_token('ERROR',SQLERRM);
4285: fnd_msg_pub.add;
4286: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4287: p_count => x_msg_count,

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

4280: WHEN OTHERS THEN
4281: ROLLBACK TO update_bank_group_member;
4282: x_return_status := fnd_api.g_ret_sts_unexp_error;
4283: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4284: fnd_message.set_token('ERROR',SQLERRM);
4285: fnd_msg_pub.add;
4286: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4287: p_count => x_msg_count,
4288: p_data => x_msg_data);

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

4453:
4454: WHEN OTHERS THEN
4455: ROLLBACK TO create_clearinghouse_assign;
4456: x_return_status := fnd_api.g_ret_sts_unexp_error;
4457: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4458: fnd_message.set_token('ERROR',SQLERRM);
4459: fnd_msg_pub.add;
4460: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4461: p_count => x_msg_count,

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

4454: WHEN OTHERS THEN
4455: ROLLBACK TO create_clearinghouse_assign;
4456: x_return_status := fnd_api.g_ret_sts_unexp_error;
4457: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4458: fnd_message.set_token('ERROR',SQLERRM);
4459: fnd_msg_pub.add;
4460: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4461: p_count => x_msg_count,
4462: p_data => x_msg_data);

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

4624:
4625: WHEN OTHERS THEN
4626: ROLLBACK TO update_clearinghouse_assign;
4627: x_return_status := fnd_api.g_ret_sts_unexp_error;
4628: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4629: fnd_message.set_token('ERROR',SQLERRM);
4630: fnd_msg_pub.add;
4631: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4632: p_count => x_msg_count,

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

4625: WHEN OTHERS THEN
4626: ROLLBACK TO update_clearinghouse_assign;
4627: x_return_status := fnd_api.g_ret_sts_unexp_error;
4628: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4629: fnd_message.set_token('ERROR',SQLERRM);
4630: fnd_msg_pub.add;
4631: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4632: p_count => x_msg_count,
4633: p_data => x_msg_data);

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

4791:
4792: WHEN OTHERS THEN
4793: ROLLBACK TO create_bank_site;
4794: x_return_status := fnd_api.g_ret_sts_unexp_error;
4795: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4796: fnd_message.set_token('ERROR',SQLERRM);
4797: fnd_msg_pub.add;
4798: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4799: p_count => x_msg_count,

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

4792: WHEN OTHERS THEN
4793: ROLLBACK TO create_bank_site;
4794: x_return_status := fnd_api.g_ret_sts_unexp_error;
4795: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4796: fnd_message.set_token('ERROR',SQLERRM);
4797: fnd_msg_pub.add;
4798: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4799: p_count => x_msg_count,
4800: p_data => x_msg_data);

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

4955:
4956: WHEN OTHERS THEN
4957: ROLLBACK TO update_bank_site;
4958: x_return_status := fnd_api.g_ret_sts_unexp_error;
4959: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4960: fnd_message.set_token('ERROR',SQLERRM);
4961: fnd_msg_pub.add;
4962: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4963: p_count => x_msg_count,

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

4956: WHEN OTHERS THEN
4957: ROLLBACK TO update_bank_site;
4958: x_return_status := fnd_api.g_ret_sts_unexp_error;
4959: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4960: fnd_message.set_token('ERROR',SQLERRM);
4961: fnd_msg_pub.add;
4962: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4963: p_count => x_msg_count,
4964: p_data => x_msg_data);

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

5127:
5128: WHEN OTHERS THEN
5129: ROLLBACK TO create_edi_contact_point;
5130: x_return_status := fnd_api.g_ret_sts_unexp_error;
5131: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5132: fnd_message.set_token('ERROR',SQLERRM);
5133: fnd_msg_pub.add;
5134: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5135: p_count => x_msg_count,

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

5128: WHEN OTHERS THEN
5129: ROLLBACK TO create_edi_contact_point;
5130: x_return_status := fnd_api.g_ret_sts_unexp_error;
5131: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5132: fnd_message.set_token('ERROR',SQLERRM);
5133: fnd_msg_pub.add;
5134: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5135: p_count => x_msg_count,
5136: p_data => x_msg_data);

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

5299:
5300: WHEN OTHERS THEN
5301: ROLLBACK TO update_edi_contact_point;
5302: x_return_status := fnd_api.g_ret_sts_unexp_error;
5303: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5304: fnd_message.set_token('ERROR',SQLERRM);
5305: fnd_msg_pub.add;
5306: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5307: p_count => x_msg_count,

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

5300: WHEN OTHERS THEN
5301: ROLLBACK TO update_edi_contact_point;
5302: x_return_status := fnd_api.g_ret_sts_unexp_error;
5303: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5304: fnd_message.set_token('ERROR',SQLERRM);
5305: fnd_msg_pub.add;
5306: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5307: p_count => x_msg_count,
5308: p_data => x_msg_data);

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

5471:
5472: WHEN OTHERS THEN
5473: ROLLBACK TO create_eft_contact_point;
5474: x_return_status := fnd_api.g_ret_sts_unexp_error;
5475: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5476: fnd_message.set_token('ERROR',SQLERRM);
5477: fnd_msg_pub.add;
5478: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5479: p_count => x_msg_count,

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

5472: WHEN OTHERS THEN
5473: ROLLBACK TO create_eft_contact_point;
5474: x_return_status := fnd_api.g_ret_sts_unexp_error;
5475: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5476: fnd_message.set_token('ERROR',SQLERRM);
5477: fnd_msg_pub.add;
5478: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5479: p_count => x_msg_count,
5480: p_data => x_msg_data);

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

5643:
5644: WHEN OTHERS THEN
5645: ROLLBACK TO update_eft_contact_point;
5646: x_return_status := fnd_api.g_ret_sts_unexp_error;
5647: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5648: fnd_message.set_token('ERROR',SQLERRM);
5649: fnd_msg_pub.add;
5650: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5651: p_count => x_msg_count,

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

5644: WHEN OTHERS THEN
5645: ROLLBACK TO update_eft_contact_point;
5646: x_return_status := fnd_api.g_ret_sts_unexp_error;
5647: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5648: fnd_message.set_token('ERROR',SQLERRM);
5649: fnd_msg_pub.add;
5650: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5651: p_count => x_msg_count,
5652: p_data => x_msg_data);

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

5815:
5816: WHEN OTHERS THEN
5817: ROLLBACK TO create_web_contact_point;
5818: x_return_status := fnd_api.g_ret_sts_unexp_error;
5819: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5820: fnd_message.set_token('ERROR',SQLERRM);
5821: fnd_msg_pub.add;
5822: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5823: p_count => x_msg_count,

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

5816: WHEN OTHERS THEN
5817: ROLLBACK TO create_web_contact_point;
5818: x_return_status := fnd_api.g_ret_sts_unexp_error;
5819: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5820: fnd_message.set_token('ERROR',SQLERRM);
5821: fnd_msg_pub.add;
5822: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5823: p_count => x_msg_count,
5824: p_data => x_msg_data);

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

5987:
5988: WHEN OTHERS THEN
5989: ROLLBACK TO update_web_contact_point;
5990: x_return_status := fnd_api.g_ret_sts_unexp_error;
5991: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5992: fnd_message.set_token('ERROR',SQLERRM);
5993: fnd_msg_pub.add;
5994: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5995: p_count => x_msg_count,

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

5988: WHEN OTHERS THEN
5989: ROLLBACK TO update_web_contact_point;
5990: x_return_status := fnd_api.g_ret_sts_unexp_error;
5991: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5992: fnd_message.set_token('ERROR',SQLERRM);
5993: fnd_msg_pub.add;
5994: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5995: p_count => x_msg_count,
5996: p_data => x_msg_data);

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

6159:
6160: WHEN OTHERS THEN
6161: ROLLBACK TO create_phone_contact_point;
6162: x_return_status := fnd_api.g_ret_sts_unexp_error;
6163: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6164: fnd_message.set_token('ERROR',SQLERRM);
6165: fnd_msg_pub.add;
6166: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6167: p_count => x_msg_count,

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

6160: WHEN OTHERS THEN
6161: ROLLBACK TO create_phone_contact_point;
6162: x_return_status := fnd_api.g_ret_sts_unexp_error;
6163: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6164: fnd_message.set_token('ERROR',SQLERRM);
6165: fnd_msg_pub.add;
6166: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6167: p_count => x_msg_count,
6168: p_data => x_msg_data);

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

6331:
6332: WHEN OTHERS THEN
6333: ROLLBACK TO update_phone_contact_point;
6334: x_return_status := fnd_api.g_ret_sts_unexp_error;
6335: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6336: fnd_message.set_token('ERROR',SQLERRM);
6337: fnd_msg_pub.add;
6338: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6339: p_count => x_msg_count,

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

6332: WHEN OTHERS THEN
6333: ROLLBACK TO update_phone_contact_point;
6334: x_return_status := fnd_api.g_ret_sts_unexp_error;
6335: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6336: fnd_message.set_token('ERROR',SQLERRM);
6337: fnd_msg_pub.add;
6338: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6339: p_count => x_msg_count,
6340: p_data => x_msg_data);

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

6503:
6504: WHEN OTHERS THEN
6505: ROLLBACK TO create_email_contact_point;
6506: x_return_status := fnd_api.g_ret_sts_unexp_error;
6507: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6508: fnd_message.set_token('ERROR',SQLERRM);
6509: fnd_msg_pub.add;
6510: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6511: p_count => x_msg_count,

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

6504: WHEN OTHERS THEN
6505: ROLLBACK TO create_email_contact_point;
6506: x_return_status := fnd_api.g_ret_sts_unexp_error;
6507: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6508: fnd_message.set_token('ERROR',SQLERRM);
6509: fnd_msg_pub.add;
6510: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6511: p_count => x_msg_count,
6512: p_data => x_msg_data);

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

6675:
6676: WHEN OTHERS THEN
6677: ROLLBACK TO update_email_contact_point;
6678: x_return_status := fnd_api.g_ret_sts_unexp_error;
6679: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6680: fnd_message.set_token('ERROR',SQLERRM);
6681: fnd_msg_pub.add;
6682: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6683: p_count => x_msg_count,

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

6676: WHEN OTHERS THEN
6677: ROLLBACK TO update_email_contact_point;
6678: x_return_status := fnd_api.g_ret_sts_unexp_error;
6679: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6680: fnd_message.set_token('ERROR',SQLERRM);
6681: fnd_msg_pub.add;
6682: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6683: p_count => x_msg_count,
6684: p_data => x_msg_data);

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

6847:
6848: WHEN OTHERS THEN
6849: ROLLBACK TO create_telex_contact_point;
6850: x_return_status := fnd_api.g_ret_sts_unexp_error;
6851: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6852: fnd_message.set_token('ERROR',SQLERRM);
6853: fnd_msg_pub.add;
6854: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6855: p_count => x_msg_count,

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

6848: WHEN OTHERS THEN
6849: ROLLBACK TO create_telex_contact_point;
6850: x_return_status := fnd_api.g_ret_sts_unexp_error;
6851: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6852: fnd_message.set_token('ERROR',SQLERRM);
6853: fnd_msg_pub.add;
6854: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6855: p_count => x_msg_count,
6856: p_data => x_msg_data);

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

7020:
7021: WHEN OTHERS THEN
7022: ROLLBACK TO update_telex_contact_point;
7023: x_return_status := fnd_api.g_ret_sts_unexp_error;
7024: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7025: fnd_message.set_token('ERROR',SQLERRM);
7026: fnd_msg_pub.add;
7027: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
7028: p_count => x_msg_count,

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

7021: WHEN OTHERS THEN
7022: ROLLBACK TO update_telex_contact_point;
7023: x_return_status := fnd_api.g_ret_sts_unexp_error;
7024: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7025: fnd_message.set_token('ERROR',SQLERRM);
7026: fnd_msg_pub.add;
7027: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
7028: p_count => x_msg_count,
7029: p_data => x_msg_data);

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

7114: IF (p_mode IS NULL OR
7115: p_mode <> 'I' AND
7116: p_mode <> 'U')
7117: THEN
7118: fnd_message.set_name('AR', 'HZ_INVALID_BATCH_PARAM');
7119: fnd_message.set_token('PARAMTER', 'p_mode');
7120: fnd_msg_pub.add;
7121: raise fnd_api.g_exc_error;
7122: END IF;

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

7115: p_mode <> 'I' AND
7116: p_mode <> 'U')
7117: THEN
7118: fnd_message.set_name('AR', 'HZ_INVALID_BATCH_PARAM');
7119: fnd_message.set_token('PARAMTER', 'p_mode');
7120: fnd_msg_pub.add;
7121: raise fnd_api.g_exc_error;
7122: END IF;
7123:

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

7216:
7217: WHEN OTHERS THEN
7218: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
7219:
7220: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7221: fnd_message.set_token('ERROR' ,SQLERRM);
7222: fnd_msg_pub.add;
7223:
7224: fnd_msg_pub.Count_And_Get (

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

7217: WHEN OTHERS THEN
7218: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
7219:
7220: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7221: fnd_message.set_token('ERROR' ,SQLERRM);
7222: fnd_msg_pub.add;
7223:
7224: fnd_msg_pub.Count_And_Get (
7225: p_encoded => fnd_api.G_FALSE,

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

7317: IF (p_mode IS NULL OR
7318: p_mode <> 'I' AND
7319: p_mode <> 'U')
7320: THEN
7321: fnd_message.set_name('AR', 'HZ_INVALID_BATCH_PARAM');
7322: fnd_message.set_token('PARAMTER', 'p_mode');
7323: fnd_msg_pub.add;
7324: raise fnd_api.g_exc_error;
7325: END IF;

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

7318: p_mode <> 'I' AND
7319: p_mode <> 'U')
7320: THEN
7321: fnd_message.set_name('AR', 'HZ_INVALID_BATCH_PARAM');
7322: fnd_message.set_token('PARAMTER', 'p_mode');
7323: fnd_msg_pub.add;
7324: raise fnd_api.g_exc_error;
7325: END IF;
7326:

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

7431:
7432: WHEN OTHERS THEN
7433: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
7434:
7435: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7436: fnd_message.set_token('ERROR' ,SQLERRM);
7437: fnd_msg_pub.add;
7438:
7439: fnd_msg_pub.Count_And_Get (

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

7432: WHEN OTHERS THEN
7433: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
7434:
7435: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7436: fnd_message.set_token('ERROR' ,SQLERRM);
7437: fnd_msg_pub.add;
7438:
7439: fnd_msg_pub.Count_And_Get (
7440: p_encoded => fnd_api.G_FALSE,