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 724: fnd_msg_pub.add;

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

Line 762: fnd_msg_pub.add;

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

Line 830: fnd_msg_pub.add;

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

Line 1739: fnd_msg_pub.add;

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

Line 1919: fnd_msg_pub.initialize;

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

Line 1942: fnd_msg_pub.Count_And_Get (

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

Line 1970: fnd_msg_pub.Count_And_Get (

1966: WHEN fnd_api.G_EXC_ERROR THEN
1967: ROLLBACK TO assign_party_usage;
1968: x_return_status := fnd_api.G_RET_STS_ERROR;
1969:
1970: fnd_msg_pub.Count_And_Get (
1971: p_encoded => fnd_api.G_FALSE,
1972: p_count => x_msg_count,
1973: p_data => x_msg_data
1974: );

Line 1997: fnd_msg_pub.Count_And_Get (

1993:
1994: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
1995: ROLLBACK TO assign_party_usage;
1996: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1997: fnd_msg_pub.Count_And_Get (
1998: p_encoded => fnd_api.G_FALSE,
1999: p_count => x_msg_count,
2000: p_data => x_msg_data
2001: );

Line 2027: fnd_msg_pub.add;

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

Line 2029: fnd_msg_pub.Count_And_Get (

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,
2031: p_count => x_msg_count,
2032: p_data => x_msg_data
2033: );

Line 2126: fnd_msg_pub.initialize;

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

Line 2179: fnd_msg_pub.add;

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

Line 2239: fnd_msg_pub.add;

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

Line 2246: fnd_msg_pub.add;

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

Line 2251: fnd_msg_pub.Count_And_Get (

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

Line 2278: fnd_msg_pub.Count_And_Get (

2274: EXCEPTION
2275: WHEN fnd_api.G_EXC_ERROR THEN
2276: x_return_status := fnd_api.G_RET_STS_ERROR;
2277:
2278: fnd_msg_pub.Count_And_Get (
2279: p_encoded => fnd_api.G_FALSE,
2280: p_count => x_msg_count,
2281: p_data => x_msg_data
2282: );

Line 2304: fnd_msg_pub.Count_And_Get (

2300: END IF;
2301:
2302: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2303: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2304: fnd_msg_pub.Count_And_Get (
2305: p_encoded => fnd_api.G_FALSE,
2306: p_count => x_msg_count,
2307: p_data => x_msg_data
2308: );

Line 2333: fnd_msg_pub.add;

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

Line 2335: fnd_msg_pub.Count_And_Get (

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,
2337: p_count => x_msg_count,
2338: p_data => x_msg_data
2339: );

Line 2431: fnd_msg_pub.initialize;

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

Line 2471: fnd_msg_pub.Count_And_Get (

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

Line 2499: fnd_msg_pub.Count_And_Get (

2495: WHEN fnd_api.G_EXC_ERROR THEN
2496: ROLLBACK TO update_usg_assignment;
2497: x_return_status := fnd_api.G_RET_STS_ERROR;
2498:
2499: fnd_msg_pub.Count_And_Get (
2500: p_encoded => fnd_api.G_FALSE,
2501: p_count => x_msg_count,
2502: p_data => x_msg_data
2503: );

Line 2526: fnd_msg_pub.Count_And_Get (

2522:
2523: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
2524: ROLLBACK TO update_usg_assignment;
2525: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2526: fnd_msg_pub.Count_And_Get (
2527: p_encoded => fnd_api.G_FALSE,
2528: p_count => x_msg_count,
2529: p_data => x_msg_data
2530: );

Line 2556: fnd_msg_pub.add;

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

Line 2558: fnd_msg_pub.Count_And_Get (

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,
2560: p_count => x_msg_count,
2561: p_data => x_msg_data
2562: );

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

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

Line 2664: l_success := fnd_msg_pub.Change_Msg;

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

Line 2668: fnd_msg_pub.Count_And_Get (

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

Line 2800: fnd_msg_pub.initialize;

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

Line 2868: fnd_msg_pub.add;

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

Line 2886: fnd_msg_pub.Count_And_Get (

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

Line 3040: fnd_msg_pub.add;

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