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

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

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

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

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

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

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

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

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

819: l_party_usage_code, l_party_usage_codes_tbl(i)) OR
820: violate_coexist_rules(
821: l_party_usage_code, l_party_usage_codes_tbl(i)))
822: THEN
823: fnd_message.set_name('AR', 'HZ_PU_EXCLUSIVE_RULE_FAILED');
824: fnd_message.set_token('EXISTING_PARTY_USAGE_CODE', l_party_usage_codes_tbl(i));
825: fnd_message.set_token('NEW_PARTY_USAGE_CODE', l_party_usage_code);
826: fnd_msg_pub.add;
827: x_return_status := fnd_api.G_RET_STS_ERROR;

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

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

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

821: l_party_usage_code, l_party_usage_codes_tbl(i)))
822: THEN
823: fnd_message.set_name('AR', 'HZ_PU_EXCLUSIVE_RULE_FAILED');
824: fnd_message.set_token('EXISTING_PARTY_USAGE_CODE', l_party_usage_codes_tbl(i));
825: fnd_message.set_token('NEW_PARTY_USAGE_CODE', l_party_usage_code);
826: fnd_msg_pub.add;
827: x_return_status := fnd_api.G_RET_STS_ERROR;
828:
829: l_continue := 'N';

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2323:
2324: WHEN OTHERS THEN
2325: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2326:
2327: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2328: fnd_message.set_token('ERROR' ,SQLERRM);
2329: fnd_msg_pub.add;
2330:
2331: fnd_msg_pub.Count_And_Get (

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

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

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

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

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

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

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

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

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

2857: violate_coexist_rules(
2858: l_from_party_usage_codes_tbl(i),
2859: l_to_party_usage_codes_tbl(j)))
2860: THEN
2861: fnd_message.set_name('AR', 'HZ_PU_EXCLUSIVE_RULE_FAILED');
2862: fnd_message.set_token('EXISTING_PARTY_USAGE_CODE', l_from_party_usage_codes_tbl(i));
2863: fnd_message.set_token('NEW_PARTY_USAGE_CODE', l_to_party_usage_codes_tbl(j));
2864: fnd_msg_pub.add;
2865:

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

2858: l_from_party_usage_codes_tbl(i),
2859: l_to_party_usage_codes_tbl(j)))
2860: THEN
2861: fnd_message.set_name('AR', 'HZ_PU_EXCLUSIVE_RULE_FAILED');
2862: fnd_message.set_token('EXISTING_PARTY_USAGE_CODE', l_from_party_usage_codes_tbl(i));
2863: fnd_message.set_token('NEW_PARTY_USAGE_CODE', l_to_party_usage_codes_tbl(j));
2864: fnd_msg_pub.add;
2865:
2866: l_continue_j := 'N'; l_continue_i := 'N';

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

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

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

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