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_PARTY_USG_ASSIGNMENT_PVT dependencies on FND_MESSAGE

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

440: IF p_owner_table_name = 'HZ_RELATIONSHIPS' THEN
441: OPEN c_relationship (p_owner_table_id);
442: FETCH c_relationship INTO l_dummy;
443: IF c_relationship%NOTFOUND THEN
444: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
445: fnd_message.set_token('FK', 'owner_table_id');
446: fnd_message.set_token('COLUMN', 'relationship_id');
447: fnd_message.set_token('TABLE', 'hz_relationships');
448: fnd_msg_pub.add;

Line 445: fnd_message.set_token('FK', 'owner_table_id');

441: OPEN c_relationship (p_owner_table_id);
442: FETCH c_relationship INTO l_dummy;
443: IF c_relationship%NOTFOUND THEN
444: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
445: fnd_message.set_token('FK', 'owner_table_id');
446: fnd_message.set_token('COLUMN', 'relationship_id');
447: fnd_message.set_token('TABLE', 'hz_relationships');
448: fnd_msg_pub.add;
449: x_return_status := fnd_api.G_RET_STS_ERROR;

Line 446: fnd_message.set_token('COLUMN', 'relationship_id');

442: FETCH c_relationship INTO l_dummy;
443: IF c_relationship%NOTFOUND THEN
444: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
445: fnd_message.set_token('FK', 'owner_table_id');
446: fnd_message.set_token('COLUMN', 'relationship_id');
447: fnd_message.set_token('TABLE', 'hz_relationships');
448: fnd_msg_pub.add;
449: x_return_status := fnd_api.G_RET_STS_ERROR;
450: END IF;

Line 447: fnd_message.set_token('TABLE', 'hz_relationships');

443: IF c_relationship%NOTFOUND THEN
444: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
445: fnd_message.set_token('FK', 'owner_table_id');
446: fnd_message.set_token('COLUMN', 'relationship_id');
447: fnd_message.set_token('TABLE', 'hz_relationships');
448: fnd_msg_pub.add;
449: x_return_status := fnd_api.G_RET_STS_ERROR;
450: END IF;
451:

Line 549: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');

545: --
546: IF trunc(p_party_usg_assignment_rec.effective_start_date) >
547: trunc(p_party_usg_assignment_rec.effective_end_date)
548: THEN
549: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
550: fnd_message.set_token('DATE2', 'effective_end_date');
551: fnd_message.set_token('DATE1', 'effective_start_date');
552: fnd_msg_pub.add;
553: x_return_status := fnd_api.G_RET_STS_ERROR;

Line 550: fnd_message.set_token('DATE2', 'effective_end_date');

546: IF trunc(p_party_usg_assignment_rec.effective_start_date) >
547: trunc(p_party_usg_assignment_rec.effective_end_date)
548: THEN
549: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
550: fnd_message.set_token('DATE2', 'effective_end_date');
551: fnd_message.set_token('DATE1', 'effective_start_date');
552: fnd_msg_pub.add;
553: x_return_status := fnd_api.G_RET_STS_ERROR;
554: END IF;

Line 551: fnd_message.set_token('DATE1', 'effective_start_date');

547: trunc(p_party_usg_assignment_rec.effective_end_date)
548: THEN
549: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
550: fnd_message.set_token('DATE2', 'effective_end_date');
551: fnd_message.set_token('DATE1', 'effective_start_date');
552: fnd_msg_pub.add;
553: x_return_status := fnd_api.G_RET_STS_ERROR;
554: END IF;
555:

Line 621: fnd_message.set_name('AR', 'HZ_PU_INVALID_PARTY_USAGE_CODE');

617: ELSIF p_create_update_flag = 'C' THEN
618: --
619: -- invalid foreign key
620: --
621: fnd_message.set_name('AR', 'HZ_PU_INVALID_PARTY_USAGE_CODE');
622: fnd_message.set_token('PARTY_USAGE_CODE', l_party_usage_code);
623: fnd_msg_pub.add;
624: x_return_status := fnd_api.G_RET_STS_ERROR;
625: END IF;

Line 622: fnd_message.set_token('PARTY_USAGE_CODE', l_party_usage_code);

618: --
619: -- invalid foreign key
620: --
621: fnd_message.set_name('AR', 'HZ_PU_INVALID_PARTY_USAGE_CODE');
622: fnd_message.set_token('PARTY_USAGE_CODE', l_party_usage_code);
623: fnd_msg_pub.add;
624: x_return_status := fnd_api.G_RET_STS_ERROR;
625: END IF;
626:

Line 641: fnd_message.set_name('AR', 'HZ_PU_INACTIVE_PARTY_USG_CODE');

637: --
638: -- inactive party usage code
639: --
640: IF db_party_usage_status <> 'A' THEN
641: fnd_message.set_name('AR', 'HZ_PU_INACTIVE_PARTY_USG_CODE');
642: fnd_message.set_token('PARTY_USAGE_CODE', p_party_usg_assignment_rec.party_usage_code);
643: fnd_msg_pub.add;
644: x_return_status := fnd_api.G_RET_STS_ERROR;
645: END IF;

Line 642: fnd_message.set_token('PARTY_USAGE_CODE', p_party_usg_assignment_rec.party_usage_code);

638: -- inactive party usage code
639: --
640: IF db_party_usage_status <> 'A' THEN
641: fnd_message.set_name('AR', 'HZ_PU_INACTIVE_PARTY_USG_CODE');
642: fnd_message.set_token('PARTY_USAGE_CODE', p_party_usg_assignment_rec.party_usage_code);
643: fnd_msg_pub.add;
644: x_return_status := fnd_api.G_RET_STS_ERROR;
645: END IF;
646:

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

658: --
659: OPEN c_party (p_party_usg_assignment_rec.party_id);
660: FETCH c_party INTO db_party_type, db_party_name;
661: IF (c_party%NOTFOUND) THEN
662: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
663: fnd_message.set_token('FK', 'party_id');
664: fnd_message.set_token('COLUMN', 'party_id');
665: fnd_message.set_token('TABLE', 'hz_parties');
666: fnd_msg_pub.add;

Line 663: fnd_message.set_token('FK', 'party_id');

659: OPEN c_party (p_party_usg_assignment_rec.party_id);
660: FETCH c_party INTO db_party_type, db_party_name;
661: IF (c_party%NOTFOUND) THEN
662: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
663: fnd_message.set_token('FK', 'party_id');
664: fnd_message.set_token('COLUMN', 'party_id');
665: fnd_message.set_token('TABLE', 'hz_parties');
666: fnd_msg_pub.add;
667: x_return_status := fnd_api.G_RET_STS_ERROR;

Line 664: fnd_message.set_token('COLUMN', 'party_id');

660: FETCH c_party INTO db_party_type, db_party_name;
661: IF (c_party%NOTFOUND) THEN
662: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
663: fnd_message.set_token('FK', 'party_id');
664: fnd_message.set_token('COLUMN', 'party_id');
665: fnd_message.set_token('TABLE', 'hz_parties');
666: fnd_msg_pub.add;
667: x_return_status := fnd_api.G_RET_STS_ERROR;
668: END IF;

Line 665: fnd_message.set_token('TABLE', 'hz_parties');

661: IF (c_party%NOTFOUND) THEN
662: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
663: fnd_message.set_token('FK', 'party_id');
664: fnd_message.set_token('COLUMN', 'party_id');
665: fnd_message.set_token('TABLE', 'hz_parties');
666: fnd_msg_pub.add;
667: x_return_status := fnd_api.G_RET_STS_ERROR;
668: END IF;
669: CLOSE c_party;

Line 685: fnd_message.set_name('AR', 'HZ_PU_INVALID_PARTY_TYPE');

681: --
682: -- party type doesn't match
683: --
684: IF instrb(db_party_usage_type, db_party_type) = 0 THEN
685: fnd_message.set_name('AR', 'HZ_PU_INVALID_PARTY_TYPE');
686: fnd_message.set_token('PARTY_USAGE_CODE', p_party_usg_assignment_rec.party_usage_code);
687: fnd_message.set_token('PARTY_TYPE', db_party_type);
688: fnd_msg_pub.add;
689: x_return_status := fnd_api.G_RET_STS_ERROR;

Line 686: fnd_message.set_token('PARTY_USAGE_CODE', p_party_usg_assignment_rec.party_usage_code);

682: -- party type doesn't match
683: --
684: IF instrb(db_party_usage_type, db_party_type) = 0 THEN
685: fnd_message.set_name('AR', 'HZ_PU_INVALID_PARTY_TYPE');
686: fnd_message.set_token('PARTY_USAGE_CODE', p_party_usg_assignment_rec.party_usage_code);
687: fnd_message.set_token('PARTY_TYPE', db_party_type);
688: fnd_msg_pub.add;
689: x_return_status := fnd_api.G_RET_STS_ERROR;
690: END IF;

Line 687: fnd_message.set_token('PARTY_TYPE', db_party_type);

683: --
684: IF instrb(db_party_usage_type, db_party_type) = 0 THEN
685: fnd_message.set_name('AR', 'HZ_PU_INVALID_PARTY_TYPE');
686: fnd_message.set_token('PARTY_USAGE_CODE', p_party_usg_assignment_rec.party_usage_code);
687: fnd_message.set_token('PARTY_TYPE', db_party_type);
688: fnd_msg_pub.add;
689: x_return_status := fnd_api.G_RET_STS_ERROR;
690: END IF;
691:

Line 722: fnd_message.set_name('AR', 'HZ_PU_SEED_CBM_ASSIGN');

718: -- Party Usage Assignment.
719: IF l_created_by NOT IN (0, 1, 2, 120, 121,122) AND
720: db_party_usage_created_by IN (0, 1, 2, 120, 121,122)
721: THEN
722: fnd_message.set_name('AR', 'HZ_PU_SEED_CBM_ASSIGN');
723: fnd_message.set_token('PARTY_USAGE_CODE', l_party_usage_code);
724: fnd_msg_pub.add;
725: x_return_status := fnd_api.G_RET_STS_ERROR;
726: END IF;

Line 723: fnd_message.set_token('PARTY_USAGE_CODE', l_party_usage_code);

719: IF l_created_by NOT IN (0, 1, 2, 120, 121,122) AND
720: db_party_usage_created_by IN (0, 1, 2, 120, 121,122)
721: THEN
722: fnd_message.set_name('AR', 'HZ_PU_SEED_CBM_ASSIGN');
723: fnd_message.set_token('PARTY_USAGE_CODE', l_party_usage_code);
724: fnd_msg_pub.add;
725: x_return_status := fnd_api.G_RET_STS_ERROR;
726: END IF;
727:

Line 760: fnd_message.set_name('AR', 'HZ_PU_SEED_CBM_UPDATE');

756: IF db_restrict_manual_update = 'Y' AND
757: G_CALLING_API = 'HZ_PARTY_USG_ASSIGNMENT_PUB' AND
758: db_party_usage_created_by IN (0, 1, 2, 120, 121,122)
759: THEN
760: fnd_message.set_name('AR', 'HZ_PU_SEED_CBM_UPDATE');
761: fnd_message.set_token('PARTY_USAGE_CODE', l_party_usage_code);
762: fnd_msg_pub.add;
763: x_return_status := fnd_api.G_RET_STS_ERROR;
764: END IF;

Line 761: fnd_message.set_token('PARTY_USAGE_CODE', l_party_usage_code);

757: G_CALLING_API = 'HZ_PARTY_USG_ASSIGNMENT_PUB' AND
758: db_party_usage_created_by IN (0, 1, 2, 120, 121,122)
759: THEN
760: fnd_message.set_name('AR', 'HZ_PU_SEED_CBM_UPDATE');
761: fnd_message.set_token('PARTY_USAGE_CODE', l_party_usage_code);
762: fnd_msg_pub.add;
763: x_return_status := fnd_api.G_RET_STS_ERROR;
764: END IF;
765:

Line 827: fnd_message.set_name('AR', 'HZ_PU_EXCLUSIVE_RULE_FAILED');

823: l_party_usage_code, l_party_usage_codes_tbl(i)) OR
824: violate_coexist_rules(
825: l_party_usage_code, l_party_usage_codes_tbl(i)))
826: THEN
827: fnd_message.set_name('AR', 'HZ_PU_EXCLUSIVE_RULE_FAILED');
828: fnd_message.set_token('EXISTING_PARTY_USAGE_CODE', l_party_usage_codes_tbl(i));
829: fnd_message.set_token('NEW_PARTY_USAGE_CODE', l_party_usage_code);
830: fnd_msg_pub.add;
831: x_return_status := fnd_api.G_RET_STS_ERROR;

Line 828: fnd_message.set_token('EXISTING_PARTY_USAGE_CODE', l_party_usage_codes_tbl(i));

824: violate_coexist_rules(
825: l_party_usage_code, l_party_usage_codes_tbl(i)))
826: THEN
827: fnd_message.set_name('AR', 'HZ_PU_EXCLUSIVE_RULE_FAILED');
828: fnd_message.set_token('EXISTING_PARTY_USAGE_CODE', l_party_usage_codes_tbl(i));
829: fnd_message.set_token('NEW_PARTY_USAGE_CODE', l_party_usage_code);
830: fnd_msg_pub.add;
831: x_return_status := fnd_api.G_RET_STS_ERROR;
832:

Line 829: fnd_message.set_token('NEW_PARTY_USAGE_CODE', l_party_usage_code);

825: l_party_usage_code, l_party_usage_codes_tbl(i)))
826: THEN
827: fnd_message.set_name('AR', 'HZ_PU_EXCLUSIVE_RULE_FAILED');
828: fnd_message.set_token('EXISTING_PARTY_USAGE_CODE', l_party_usage_codes_tbl(i));
829: fnd_message.set_token('NEW_PARTY_USAGE_CODE', l_party_usage_code);
830: fnd_msg_pub.add;
831: x_return_status := fnd_api.G_RET_STS_ERROR;
832:
833: l_continue := 'N';

Line 1737: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');

1733: l_object_version_number := p_old_object_version_number;
1734: END IF;
1735:
1736: IF p_object_version_number <> l_object_version_number THEN
1737: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1738: fnd_message.set_token('TABLE', 'hz_party_usg_assignments');
1739: fnd_msg_pub.add;
1740: RAISE fnd_api.g_exc_error;
1741: END IF;

Line 1738: fnd_message.set_token('TABLE', 'hz_party_usg_assignments');

1734: END IF;
1735:
1736: IF p_object_version_number <> l_object_version_number THEN
1737: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1738: fnd_message.set_token('TABLE', 'hz_party_usg_assignments');
1739: fnd_msg_pub.add;
1740: RAISE fnd_api.g_exc_error;
1741: END IF;
1742: END IF;

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

2021: WHEN OTHERS THEN
2022: ROLLBACK TO assign_party_usage;
2023: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2024:
2025: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2026: fnd_message.set_token('ERROR' ,SQLERRM);
2027: fnd_msg_pub.add;
2028:
2029: fnd_msg_pub.Count_And_Get (

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

2022: ROLLBACK TO assign_party_usage;
2023: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2024:
2025: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2026: fnd_message.set_token('ERROR' ,SQLERRM);
2027: fnd_msg_pub.add;
2028:
2029: fnd_msg_pub.Count_And_Get (
2030: p_encoded => fnd_api.G_FALSE,

Line 2178: fnd_message.set_name('AR', 'HZ_PU_MISSING_COLUMN');

2174: AND owner_table_id = p_party_usg_assignment_rec.owner_table_id;
2175: -- need required parameters
2176: --
2177: ELSE
2178: fnd_message.set_name('AR', 'HZ_PU_MISSING_COLUMN');
2179: fnd_msg_pub.add;
2180: RAISE fnd_api.G_EXC_ERROR;
2181: END IF;
2182:

Line 2238: fnd_message.set_name('AR', 'HZ_PU_MULTIPLE_ASSIGNMENT');

2234: --
2235: IF l_counter > 1 AND
2236: l_search_by IN ('USAGE_CODE', 'ASSIGNMENT_ID')
2237: THEN
2238: fnd_message.set_name('AR', 'HZ_PU_MULTIPLE_ASSIGNMENT');
2239: fnd_msg_pub.add;
2240: RAISE fnd_api.G_EXC_ERROR;
2241: --
2242: -- no assignment exist

Line 2245: fnd_message.set_name('AR', 'HZ_PU_INVALID_ASSIGNMENT');

2241: --
2242: -- no assignment exist
2243: --
2244: ELSIF l_counter = 0 THEN
2245: fnd_message.set_name('AR', 'HZ_PU_INVALID_ASSIGNMENT');
2246: fnd_msg_pub.add;
2247: RAISE fnd_api.G_EXC_ERROR;
2248: END IF;
2249:

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

2327:
2328: WHEN OTHERS THEN
2329: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2330:
2331: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2332: fnd_message.set_token('ERROR' ,SQLERRM);
2333: fnd_msg_pub.add;
2334:
2335: fnd_msg_pub.Count_And_Get (

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

2328: WHEN OTHERS THEN
2329: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2330:
2331: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2332: fnd_message.set_token('ERROR' ,SQLERRM);
2333: fnd_msg_pub.add;
2334:
2335: fnd_msg_pub.Count_And_Get (
2336: p_encoded => fnd_api.G_FALSE,

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

2550: WHEN OTHERS THEN
2551: ROLLBACK TO update_usg_assignment;
2552: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2553:
2554: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2555: fnd_message.set_token('ERROR' ,SQLERRM);
2556: fnd_msg_pub.add;
2557:
2558: fnd_msg_pub.Count_And_Get (

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

2551: ROLLBACK TO update_usg_assignment;
2552: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2553:
2554: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2555: fnd_message.set_token('ERROR' ,SQLERRM);
2556: fnd_msg_pub.add;
2557:
2558: fnd_msg_pub.Count_And_Get (
2559: p_encoded => fnd_api.G_FALSE,

Line 2662: fnd_message.set_name('AR', 'HZ_PU_WRONG_API');

2658: );
2659:
2660: -- replace error message
2661: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
2662: fnd_message.set_name('AR', 'HZ_PU_WRONG_API');
2663: fnd_msg_pub.Set_Search_Name('AR', 'HZ_PU_MULTIPLE_ASSIGNMENT');
2664: l_success := fnd_msg_pub.Change_Msg;
2665:
2666: IF l_success = 'T' THEN

Line 2865: fnd_message.set_name('AR', 'HZ_PU_EXCLUSIVE_RULE_FAILED');

2861: violate_coexist_rules(
2862: l_from_party_usage_codes_tbl(i),
2863: l_to_party_usage_codes_tbl(j)))
2864: THEN
2865: fnd_message.set_name('AR', 'HZ_PU_EXCLUSIVE_RULE_FAILED');
2866: fnd_message.set_token('EXISTING_PARTY_USAGE_CODE', l_from_party_usage_codes_tbl(i));
2867: fnd_message.set_token('NEW_PARTY_USAGE_CODE', l_to_party_usage_codes_tbl(j));
2868: fnd_msg_pub.add;
2869:

Line 2866: fnd_message.set_token('EXISTING_PARTY_USAGE_CODE', l_from_party_usage_codes_tbl(i));

2862: l_from_party_usage_codes_tbl(i),
2863: l_to_party_usage_codes_tbl(j)))
2864: THEN
2865: fnd_message.set_name('AR', 'HZ_PU_EXCLUSIVE_RULE_FAILED');
2866: fnd_message.set_token('EXISTING_PARTY_USAGE_CODE', l_from_party_usage_codes_tbl(i));
2867: fnd_message.set_token('NEW_PARTY_USAGE_CODE', l_to_party_usage_codes_tbl(j));
2868: fnd_msg_pub.add;
2869:
2870: l_continue_j := 'N'; l_continue_i := 'N';

Line 2867: fnd_message.set_token('NEW_PARTY_USAGE_CODE', l_to_party_usage_codes_tbl(j));

2863: l_to_party_usage_codes_tbl(j)))
2864: THEN
2865: fnd_message.set_name('AR', 'HZ_PU_EXCLUSIVE_RULE_FAILED');
2866: fnd_message.set_token('EXISTING_PARTY_USAGE_CODE', l_from_party_usage_codes_tbl(i));
2867: fnd_message.set_token('NEW_PARTY_USAGE_CODE', l_to_party_usage_codes_tbl(j));
2868: fnd_msg_pub.add;
2869:
2870: l_continue_j := 'N'; l_continue_i := 'N';
2871: l_allow_party_merge := 'N';

Line 3039: fnd_message.set_name('AR', 'HZ_NONUNIQUE_SUPPLIER_NAME');

3035: -- check uniqueness across supplier parties
3036: OPEN c_party(p_party_id, p_party_name);
3037: FETCH c_party INTO l_dummy;
3038: IF c_party%FOUND THEN
3039: fnd_message.set_name('AR', 'HZ_NONUNIQUE_SUPPLIER_NAME');
3040: fnd_msg_pub.add;
3041: x_return_status := fnd_api.g_ret_sts_error;
3042: END IF;
3043: CLOSE c_party;