DBA Data[Home] [Help]

APPS.HZ_IMP_DQM_STAGE dependencies on FND_MESSAGE

Line 177: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

173: execute immediate l_sql_stmt using p_batch_id, p_from_osr, p_to_osr;
174:
175: EXCEPTION WHEN others THEN
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,

Line 178: FND_MESSAGE.SET_TOKEN('PROC' ,'POP_INTERFACE_SEARCH_TAB');

174:
175: EXCEPTION WHEN others THEN
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,

Line 179: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

175: EXCEPTION WHEN others THEN
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);

Line 316: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

312: END IF;
313: log('End of staging for interface_tca POP_INT_TCA_SEARCH_TAB');
314: EXCEPTION WHEN others THEN
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,

Line 317: FND_MESSAGE.SET_TOKEN('PROC' ,'POP_INT_TCA_SEARCH_TAB');

313: log('End of staging for interface_tca POP_INT_TCA_SEARCH_TAB');
314: EXCEPTION WHEN others THEN
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,

Line 318: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

314: EXCEPTION WHEN others THEN
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);

Line 436: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

432: delete from HZ_INT_DUP_RESULTS where batch_id = p_batch_id;
433: EXCEPTION WHEN OTHERS THEN
434: log(SQLERRM);
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,

Line 437: FND_MESSAGE.SET_TOKEN('PROC' ,'DQM_POST_IMP_CLEANUP');

433: EXCEPTION WHEN OTHERS THEN
434: log(SQLERRM);
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,

Line 438: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

434: log(SQLERRM);
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);

Line 480: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

476: delete from HZ_IMP_DUP_DETAILS where batch_id = p_batch_id;
477: EXCEPTION WHEN OTHERS THEN
478: log(SQLERRM);
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,

Line 481: FND_MESSAGE.SET_TOKEN('PROC' ,'DQM_PRE_IMP_CLEANUP');

477: EXCEPTION WHEN OTHERS THEN
478: log(SQLERRM);
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,

Line 482: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

478: log(SQLERRM);
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);

Line 604: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

600: END IF;
601: EXCEPTION WHEN OTHERS THEN
602: log(SQLERRM); --
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,

Line 605: FND_MESSAGE.SET_TOKEN('PROC' ,'DQM_INTER_IMP_CLEANUP');

601: EXCEPTION WHEN OTHERS THEN
602: log(SQLERRM); --
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,

Line 606: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

602: log(SQLERRM); --
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);

Line 771: log(fnd_message.get);

767: to_char(sysdate,'DD-MON-YY HH:MI:SS'),
768: true, p_batch_id, p_match_rule_id, to_char(I), p_num_of_workers, 'PHASE_1');
769: IF l_sub_requests(i) = 0 THEN
770: log('Error submitting worker ' || i);
771: log(fnd_message.get);
772: retcode := 2;
773: RAISE FND_API.G_EXC_ERROR;
774: ELSE
775: log('Submitted request for Worker ' || TO_CHAR(I) );

Line 811: log(fnd_message.get);

807: to_char(sysdate,'DD-MON-YY HH:MI:SS'),
808: true, p_batch_id, p_match_rule_id, to_char(I), p_num_of_workers, 'PHASE_2');
809: IF l_sub_requests(i) = 0 THEN
810: log('Error submitting worker ' || i);
811: log(fnd_message.get);
812: ELSE
813: log('Submitted request for Worker ' || TO_CHAR(I) );
814: log('Request ID : ' || l_sub_requests(i));
815: END IF;

Line 3852: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_NO_RULE');

3848: WHERE match_rule_id = l_rule_id;
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

Line 3868: fnd_message.set_name('AR','HZ_MR_HAS_INACTIVE_TX');

3864: WHEN OTHERS THEN
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;

Line 3909: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

3905: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = l_rule_id;
3906: COMMIT;
3907: WHEN OTHERS THEN
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:

Line 3910: FND_MESSAGE.SET_TOKEN('PROC','compile_match_rule');

3906: COMMIT;
3907: WHEN OTHERS THEN
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(

Line 3911: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

3907: WHEN OTHERS THEN
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,