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_IMP_DQM_STAGE dependencies on FND_MSG_PUB

Line 72: FND_MSG_PUB.Reset;

68: PROCEDURE logerror(SQLERRM VARCHAR2 DEFAULT NULL)
69: IS
70: l_msg_data VARCHAR2(2000);
71: BEGIN
72: FND_MSG_PUB.Reset;
73: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
74: l_msg_data := substr(l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ), 1, 2000) ;
75: END LOOP;
76: IF (SQLERRM IS NOT NULL) THEN

Line 73: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

69: IS
70: l_msg_data VARCHAR2(2000);
71: BEGIN
72: FND_MSG_PUB.Reset;
73: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
74: l_msg_data := substr(l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ), 1, 2000) ;
75: END LOOP;
76: IF (SQLERRM IS NOT NULL) THEN
77: l_msg_data := substr(l_msg_data || SQLERRM, 1, 2000);

Line 74: l_msg_data := substr(l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ), 1, 2000) ;

70: l_msg_data VARCHAR2(2000);
71: BEGIN
72: FND_MSG_PUB.Reset;
73: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
74: l_msg_data := substr(l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ), 1, 2000) ;
75: END LOOP;
76: IF (SQLERRM IS NOT NULL) THEN
77: l_msg_data := substr(l_msg_data || SQLERRM, 1, 2000);
78: END IF;

Line 180: FND_MSG_PUB.ADD;

176: x_return_status := fnd_api.g_ret_sts_unexp_error;
177: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
178: FND_MESSAGE.SET_TOKEN('PROC' ,'POP_INTERFACE_SEARCH_TAB');
179: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
180: FND_MSG_PUB.ADD;
181: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
182: p_count => x_msg_count,
183: p_data => x_msg_data);
184: END POP_INTERFACE_SEARCH_TAB;

Line 181: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

177: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
178: FND_MESSAGE.SET_TOKEN('PROC' ,'POP_INTERFACE_SEARCH_TAB');
179: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
180: FND_MSG_PUB.ADD;
181: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
182: p_count => x_msg_count,
183: p_data => x_msg_data);
184: END POP_INTERFACE_SEARCH_TAB;
185:

Line 319: FND_MSG_PUB.ADD;

315: x_return_status := fnd_api.g_ret_sts_unexp_error;
316: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
317: FND_MESSAGE.SET_TOKEN('PROC' ,'POP_INT_TCA_SEARCH_TAB');
318: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
319: FND_MSG_PUB.ADD;
320: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
321: p_count => x_msg_count,
322: p_data => x_msg_data);
323: END POP_INT_TCA_SEARCH_TAB;

Line 320: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

316: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
317: FND_MESSAGE.SET_TOKEN('PROC' ,'POP_INT_TCA_SEARCH_TAB');
318: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
319: FND_MSG_PUB.ADD;
320: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
321: p_count => x_msg_count,
322: p_data => x_msg_data);
323: END POP_INT_TCA_SEARCH_TAB;
324:

Line 439: FND_MSG_PUB.ADD;

435: x_return_status := fnd_api.g_ret_sts_unexp_error;
436: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
437: FND_MESSAGE.SET_TOKEN('PROC' ,'DQM_POST_IMP_CLEANUP');
438: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
439: FND_MSG_PUB.ADD;
440: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
441: p_count => x_msg_count,
442: p_data => x_msg_data);
443: END dqm_post_imp_cleanup;

Line 440: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

436: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
437: FND_MESSAGE.SET_TOKEN('PROC' ,'DQM_POST_IMP_CLEANUP');
438: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
439: FND_MSG_PUB.ADD;
440: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
441: p_count => x_msg_count,
442: p_data => x_msg_data);
443: END dqm_post_imp_cleanup;
444:

Line 483: FND_MSG_PUB.ADD;

479: x_return_status := fnd_api.g_ret_sts_unexp_error;
480: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
481: FND_MESSAGE.SET_TOKEN('PROC' ,'DQM_PRE_IMP_CLEANUP');
482: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
483: FND_MSG_PUB.ADD;
484: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
485: p_count => x_msg_count,
486: p_data => x_msg_data);
487: END dqm_pre_imp_cleanup;

Line 484: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

480: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
481: FND_MESSAGE.SET_TOKEN('PROC' ,'DQM_PRE_IMP_CLEANUP');
482: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
483: FND_MSG_PUB.ADD;
484: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
485: p_count => x_msg_count,
486: p_data => x_msg_data);
487: END dqm_pre_imp_cleanup;
488:

Line 607: FND_MSG_PUB.ADD;

603: x_return_status := fnd_api.g_ret_sts_unexp_error;
604: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
605: FND_MESSAGE.SET_TOKEN('PROC' ,'DQM_INTER_IMP_CLEANUP');
606: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
607: FND_MSG_PUB.ADD;
608: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
609: p_count => x_msg_count,
610: p_data => x_msg_data);
611: END dqm_inter_imp_cleanup;

Line 608: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

604: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
605: FND_MESSAGE.SET_TOKEN('PROC' ,'DQM_INTER_IMP_CLEANUP');
606: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
607: FND_MSG_PUB.ADD;
608: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
609: p_count => x_msg_count,
610: p_data => x_msg_data);
611: END dqm_inter_imp_cleanup;
612:

Line 2589: l(' fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, ');

2585: l(' pop_contacts(p_batch_id, p_from_osr, p_to_osr);');
2586: l(' -- build_srch_indexes(); ');
2587: l(' EXCEPTION WHEN others THEN ');
2588: l(' x_return_status := fnd_api.g_ret_sts_unexp_error; ');
2589: l(' fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, ');
2590: l(' p_count => x_msg_count, ');
2591: l(' p_data => x_msg_data); ');
2592: l(' RAISE; ');
2593: l(' END POP_INTERFACE_SEARCH_TAB;');

Line 2634: l(' fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, ');

2630: l(' END IF; ');
2631:
2632: l(' EXCEPTION WHEN others THEN ');
2633: l(' x_return_status := fnd_api.g_ret_sts_unexp_error; ');
2634: l(' fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, ');
2635: l(' p_count => x_msg_count, ');
2636: l(' p_data => x_msg_data); ');
2637: l(' RAISE; ');
2638: l(' END POP_INT_TCA_SEARCH_TAB; ');

Line 3841: FND_MSG_PUB.initialize;

3837: -- Initialize the compiled package name
3838: l_rule_id := TO_NUMBER(p_rule_id);
3839: l_package_name := 'HZ_IMP_MATCH_RULE_'||p_rule_id;
3840: -- Initialize message stack
3841: FND_MSG_PUB.initialize;
3842:
3843:
3844: BEGIN
3845: -- Verify that the match rule exists

Line 3853: FND_MSG_PUB.ADD;

3849:
3850: EXCEPTION
3851: WHEN NO_DATA_FOUND THEN
3852: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_NO_RULE');
3853: FND_MSG_PUB.ADD;
3854: RAISE FND_API.G_EXC_ERROR;
3855: END;
3856: -- Check if match rule has any inactive transformations
3857: OPEN check_inactive;

Line 3869: FND_MSG_PUB.ADD;

3865: NULL;
3866: END;
3867:
3868: fnd_message.set_name('AR','HZ_MR_HAS_INACTIVE_TX');
3869: FND_MSG_PUB.ADD;
3870: RAISE FND_API.G_EXC_ERROR;
3871: END IF;
3872: CLOSE check_inactive;
3873: -- Generate and compile match rule package spec

Line 3883: FND_MSG_PUB.Count_And_Get(

3879: gen_pkg_body(l_package_name, l_rule_id);
3880: HZ_GEN_PLSQL.compile_code;
3881:
3882: --Standard call to get message count and if count is 1, get message info.
3883: FND_MSG_PUB.Count_And_Get(
3884: p_encoded => FND_API.G_FALSE,
3885: p_count => x_msg_count,
3886: p_data => x_msg_data);
3887:

Line 3892: FND_MSG_PUB.Count_And_Get(

3888: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'C' WHERE MATCH_RULE_ID = l_rule_id;
3889: COMMIT;
3890: EXCEPTION
3891: WHEN FND_API.G_EXC_ERROR THEN
3892: FND_MSG_PUB.Count_And_Get(
3893: p_encoded => FND_API.G_FALSE,
3894: p_count => x_msg_count,
3895: p_data => x_msg_data);
3896: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3900: FND_MSG_PUB.Count_And_Get(

3896: x_return_status := FND_API.G_RET_STS_ERROR;
3897: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = l_rule_id;
3898: COMMIT;
3899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3900: FND_MSG_PUB.Count_And_Get(
3901: p_encoded => FND_API.G_FALSE,
3902: p_count => x_msg_count,
3903: p_data => x_msg_data);
3904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3912: FND_MSG_PUB.ADD;

3908:
3909: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3910: FND_MESSAGE.SET_TOKEN('PROC','compile_match_rule');
3911: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3912: FND_MSG_PUB.ADD;
3913:
3914: FND_MSG_PUB.Count_And_Get(
3915: p_encoded => FND_API.G_FALSE,
3916: p_count => x_msg_count,

Line 3914: FND_MSG_PUB.Count_And_Get(

3910: FND_MESSAGE.SET_TOKEN('PROC','compile_match_rule');
3911: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3912: FND_MSG_PUB.ADD;
3913:
3914: FND_MSG_PUB.Count_And_Get(
3915: p_encoded => FND_API.G_FALSE,
3916: p_count => x_msg_count,
3917: p_data => x_msg_data);
3918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;