73: END IF;
74: OPEN check_analysis(p_analysis_names(i));
75: FETCH check_analysis INTO p_settings;
76: IF (check_analysis%NOTFOUND) THEN
77: FND_MESSAGE.set_name('QRM', 'QRM_ANA_NO_SETTING');
78: FND_MESSAGE.set_token('ANALYSIS_NAME', p_settings.analysis_name);
79: FND_MSG_PUB.add;
80: IF (g_proc_level>=g_debug_level) THEN
81: xtr_risk_debug_pkg.dlog('run_analysis_am: ' || 'analysis not found');
74: OPEN check_analysis(p_analysis_names(i));
75: FETCH check_analysis INTO p_settings;
76: IF (check_analysis%NOTFOUND) THEN
77: FND_MESSAGE.set_name('QRM', 'QRM_ANA_NO_SETTING');
78: FND_MESSAGE.set_token('ANALYSIS_NAME', p_settings.analysis_name);
79: FND_MSG_PUB.add;
80: IF (g_proc_level>=g_debug_level) THEN
81: xtr_risk_debug_pkg.dlog('run_analysis_am: ' || 'analysis not found');
82: END IF;
87: IF (g_proc_level>=g_debug_level) THEN
88: XTR_RISK_DEBUG_PKG.dlog('run_analysis_am: ' || 'dphase is', dphase);
89: END IF;
90: IF (dphase IN ('PENDING', 'RUNNING', 'INACTIVE')) THEN
91: FND_MESSAGE.set_name('QRM', 'QRM_ANA_RUN_IN_PROGRESS');
92: FND_MESSAGE.set_token('ANALYSIS', p_settings.analysis_name);
93: FND_MSG_PUB.add;
94: IF (g_proc_level>=g_debug_level) THEN
95: xtr_risk_debug_pkg.dlog('run_analysis_am: ' || 'status is 3');
88: XTR_RISK_DEBUG_PKG.dlog('run_analysis_am: ' || 'dphase is', dphase);
89: END IF;
90: IF (dphase IN ('PENDING', 'RUNNING', 'INACTIVE')) THEN
91: FND_MESSAGE.set_name('QRM', 'QRM_ANA_RUN_IN_PROGRESS');
92: FND_MESSAGE.set_token('ANALYSIS', p_settings.analysis_name);
93: FND_MSG_PUB.add;
94: IF (g_proc_level>=g_debug_level) THEN
95: xtr_risk_debug_pkg.dlog('run_analysis_am: ' || 'status is 3');
96: END IF;
108: IF (g_proc_level>=g_debug_level) THEN
109: XTR_RISK_DEBUG_PKG.dlog('run_analysis_am: ' || 'request id: '||p_request_id);
110: END IF;
111: IF (p_request_id = 0) THEN
112: FND_MESSAGE.RETRIEVE(p_msg);
113: -- FND_MESSAGE.ERROR;
114: IF (g_proc_level>=g_debug_level) THEN
115: XTR_RISK_DEBUG_PKG.dlog('run_analysis_am: ' || 'error msg: '||p_msg);
116: END IF;
109: XTR_RISK_DEBUG_PKG.dlog('run_analysis_am: ' || 'request id: '||p_request_id);
110: END IF;
111: IF (p_request_id = 0) THEN
112: FND_MESSAGE.RETRIEVE(p_msg);
113: -- FND_MESSAGE.ERROR;
114: IF (g_proc_level>=g_debug_level) THEN
115: XTR_RISK_DEBUG_PKG.dlog('run_analysis_am: ' || 'error msg: '||p_msg);
116: END IF;
117: FND_MESSAGE.set_name('QRM', 'QRM_ANA_SUBMIT_ERROR');
113: -- FND_MESSAGE.ERROR;
114: IF (g_proc_level>=g_debug_level) THEN
115: XTR_RISK_DEBUG_PKG.dlog('run_analysis_am: ' || 'error msg: '||p_msg);
116: END IF;
117: FND_MESSAGE.set_name('QRM', 'QRM_ANA_SUBMIT_ERROR');
118: FND_MESSAGE.set_token('ANALYSIS', p_analysis_names(i));
119: FND_MSG_PUB.add;
120: IF (g_proc_level>=g_debug_level) THEN
121: xtr_risk_debug_pkg.dlog('run_analysis_am: ' || 'request not submitted');
114: IF (g_proc_level>=g_debug_level) THEN
115: XTR_RISK_DEBUG_PKG.dlog('run_analysis_am: ' || 'error msg: '||p_msg);
116: END IF;
117: FND_MESSAGE.set_name('QRM', 'QRM_ANA_SUBMIT_ERROR');
118: FND_MESSAGE.set_token('ANALYSIS', p_analysis_names(i));
119: FND_MSG_PUB.add;
120: IF (g_proc_level>=g_debug_level) THEN
121: xtr_risk_debug_pkg.dlog('run_analysis_am: ' || 'request not submitted');
122: END IF;