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_MSG_PUB

Line 448: fnd_msg_pub.add;

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

Line 552: fnd_msg_pub.add;

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

Line 623: fnd_msg_pub.add;

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

Line 643: fnd_msg_pub.add;

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

Line 666: fnd_msg_pub.add;

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

Line 688: fnd_msg_pub.add;

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

Line 722: fnd_msg_pub.add;

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

Line 758: fnd_msg_pub.add;

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

Line 826: fnd_msg_pub.add;

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';
830: END IF;

Line 1735: fnd_msg_pub.add;

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

Line 1915: fnd_msg_pub.initialize;

1911: -- initialize message list if p_init_msg_list is set to TRUE.
1912: IF p_init_msg_list IS NOT NULL AND
1913: fnd_api.To_Boolean(p_init_msg_list)
1914: THEN
1915: fnd_msg_pub.initialize;
1916: END IF;
1917:
1918: -- initialize validation level
1919: IF p_validation_level IS NULL THEN

Line 1938: fnd_msg_pub.Count_And_Get (

1934: x_return_status => x_return_status
1935: );
1936:
1937: -- standard call to get message count and if count is 1, get message info.
1938: fnd_msg_pub.Count_And_Get (
1939: p_encoded => fnd_api.G_FALSE,
1940: p_count => x_msg_count,
1941: p_data => x_msg_data);
1942:

Line 1966: fnd_msg_pub.Count_And_Get (

1962: WHEN fnd_api.G_EXC_ERROR THEN
1963: ROLLBACK TO assign_party_usage;
1964: x_return_status := fnd_api.G_RET_STS_ERROR;
1965:
1966: fnd_msg_pub.Count_And_Get (
1967: p_encoded => fnd_api.G_FALSE,
1968: p_count => x_msg_count,
1969: p_data => x_msg_data
1970: );

Line 1993: fnd_msg_pub.Count_And_Get (

1989:
1990: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
1991: ROLLBACK TO assign_party_usage;
1992: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1993: fnd_msg_pub.Count_And_Get (
1994: p_encoded => fnd_api.G_FALSE,
1995: p_count => x_msg_count,
1996: p_data => x_msg_data
1997: );

Line 2023: fnd_msg_pub.add;

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

Line 2025: fnd_msg_pub.Count_And_Get (

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,
2027: p_count => x_msg_count,
2028: p_data => x_msg_data
2029: );

Line 2122: fnd_msg_pub.initialize;

2118: -- initialize message list if p_init_msg_list is set to TRUE.
2119: IF p_init_msg_list IS NOT NULL AND
2120: fnd_api.to_Boolean(p_init_msg_list)
2121: THEN
2122: fnd_msg_pub.initialize;
2123: END IF;
2124:
2125: -- initialize API return status to success.
2126: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 2175: fnd_msg_pub.add;

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:
2179: l_counter := 0;

Line 2235: fnd_msg_pub.add;

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

Line 2242: fnd_msg_pub.add;

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:
2246: -- standard call to get message count and if count is 1, get message info.

Line 2247: fnd_msg_pub.Count_And_Get (

2243: RAISE fnd_api.G_EXC_ERROR;
2244: END IF;
2245:
2246: -- standard call to get message count and if count is 1, get message info.
2247: fnd_msg_pub.Count_And_Get (
2248: p_encoded => fnd_api.G_FALSE,
2249: p_count => x_msg_count,
2250: p_data => x_msg_data);
2251:

Line 2274: fnd_msg_pub.Count_And_Get (

2270: EXCEPTION
2271: WHEN fnd_api.G_EXC_ERROR THEN
2272: x_return_status := fnd_api.G_RET_STS_ERROR;
2273:
2274: fnd_msg_pub.Count_And_Get (
2275: p_encoded => fnd_api.G_FALSE,
2276: p_count => x_msg_count,
2277: p_data => x_msg_data
2278: );

Line 2300: fnd_msg_pub.Count_And_Get (

2296: END IF;
2297:
2298: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2299: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2300: fnd_msg_pub.Count_And_Get (
2301: p_encoded => fnd_api.G_FALSE,
2302: p_count => x_msg_count,
2303: p_data => x_msg_data
2304: );

Line 2329: fnd_msg_pub.add;

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

Line 2331: fnd_msg_pub.Count_And_Get (

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,
2333: p_count => x_msg_count,
2334: p_data => x_msg_data
2335: );

Line 2427: fnd_msg_pub.initialize;

2423: -- initialize message list if p_init_msg_list is set to TRUE.
2424: IF p_init_msg_list IS NOT NULL AND
2425: fnd_api.to_Boolean(p_init_msg_list)
2426: THEN
2427: fnd_msg_pub.initialize;
2428: END IF;
2429:
2430: -- initialize validation level
2431: IF p_validation_level IS NULL THEN

Line 2467: fnd_msg_pub.Count_And_Get (

2463: x_return_status => x_return_status
2464: );
2465:
2466: -- standard call to get message count and if count is 1, get message info.
2467: fnd_msg_pub.Count_And_Get (
2468: p_encoded => fnd_api.G_FALSE,
2469: p_count => x_msg_count,
2470: p_data => x_msg_data);
2471:

Line 2495: fnd_msg_pub.Count_And_Get (

2491: WHEN fnd_api.G_EXC_ERROR THEN
2492: ROLLBACK TO update_usg_assignment;
2493: x_return_status := fnd_api.G_RET_STS_ERROR;
2494:
2495: fnd_msg_pub.Count_And_Get (
2496: p_encoded => fnd_api.G_FALSE,
2497: p_count => x_msg_count,
2498: p_data => x_msg_data
2499: );

Line 2522: fnd_msg_pub.Count_And_Get (

2518:
2519: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2520: ROLLBACK TO update_usg_assignment;
2521: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2522: fnd_msg_pub.Count_And_Get (
2523: p_encoded => fnd_api.G_FALSE,
2524: p_count => x_msg_count,
2525: p_data => x_msg_data
2526: );

Line 2552: fnd_msg_pub.add;

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

Line 2554: fnd_msg_pub.Count_And_Get (

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,
2556: p_count => x_msg_count,
2557: p_data => x_msg_data
2558: );

Line 2659: fnd_msg_pub.Set_Search_Name('AR', 'HZ_PU_MULTIPLE_ASSIGNMENT');

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
2663: -- standard call to get message count and if count is 1, get message info.

Line 2660: l_success := fnd_msg_pub.Change_Msg;

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
2663: -- standard call to get message count and if count is 1, get message info.
2664: fnd_msg_pub.Count_And_Get (

Line 2664: fnd_msg_pub.Count_And_Get (

2660: l_success := fnd_msg_pub.Change_Msg;
2661:
2662: IF l_success = 'T' THEN
2663: -- standard call to get message count and if count is 1, get message info.
2664: fnd_msg_pub.Count_And_Get (
2665: p_encoded => fnd_api.G_FALSE,
2666: p_count => x_msg_count,
2667: p_data => x_msg_data);
2668: END IF;

Line 2796: fnd_msg_pub.initialize;

2792: -- initialize message list if p_init_msg_list is set to TRUE.
2793: IF p_init_msg_list IS NOT NULL AND
2794: fnd_api.to_Boolean(p_init_msg_list)
2795: THEN
2796: fnd_msg_pub.initialize;
2797: END IF;
2798:
2799: -- load setup data
2800: IF G_SETUP_LOADED = 0 THEN

Line 2864: fnd_msg_pub.add;

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';
2868: ELSE

Line 2882: fnd_msg_pub.Count_And_Get (

2878: END IF; -- from party has assignments
2879: END IF; -- has rules defined.
2880:
2881: -- standard call to get message count and if count is 1, get message info.
2882: fnd_msg_pub.Count_And_Get (
2883: p_encoded => fnd_api.G_FALSE,
2884: p_count => x_msg_count,
2885: p_data => x_msg_data);
2886:

Line 3036: fnd_msg_pub.add;

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