198: '','','','','','','','','','','','');
199:
200: IF l_ci_request_Id <> 0 THEN
201: --+cross instance data transfer program is submitted okay
202: FND_MESSAGE.set_name('SQLGL', 'GL_US_CI_ENTER_PRE');
203: FND_MESSAGE.set_token('REQUEST', l_ci_request_id, FALSE);
204: debug_message('==>' || FND_MESSAGE.get, TRUE);
205: ELSE
206: --+Cross instance data transfer program fails to start
199:
200: IF l_ci_request_Id <> 0 THEN
201: --+cross instance data transfer program is submitted okay
202: FND_MESSAGE.set_name('SQLGL', 'GL_US_CI_ENTER_PRE');
203: FND_MESSAGE.set_token('REQUEST', l_ci_request_id, FALSE);
204: debug_message('==>' || FND_MESSAGE.get, TRUE);
205: ELSE
206: --+Cross instance data transfer program fails to start
207: FND_MESSAGE.set_name('SQLGL', 'GL_US_CI_FAIL_STARTCI');
200: IF l_ci_request_Id <> 0 THEN
201: --+cross instance data transfer program is submitted okay
202: FND_MESSAGE.set_name('SQLGL', 'GL_US_CI_ENTER_PRE');
203: FND_MESSAGE.set_token('REQUEST', l_ci_request_id, FALSE);
204: debug_message('==>' || FND_MESSAGE.get, TRUE);
205: ELSE
206: --+Cross instance data transfer program fails to start
207: FND_MESSAGE.set_name('SQLGL', 'GL_US_CI_FAIL_STARTCI');
208: FND_MESSAGE.set_token('RESULT', SUBSTR(SQLERRM,1,200), FALSE);
203: FND_MESSAGE.set_token('REQUEST', l_ci_request_id, FALSE);
204: debug_message('==>' || FND_MESSAGE.get, TRUE);
205: ELSE
206: --+Cross instance data transfer program fails to start
207: FND_MESSAGE.set_name('SQLGL', 'GL_US_CI_FAIL_STARTCI');
208: FND_MESSAGE.set_token('RESULT', SUBSTR(SQLERRM,1,200), FALSE);
209: debug_message('==>' || FND_MESSAGE.get, TRUE);
210: END IF;
211: ELSE
204: debug_message('==>' || FND_MESSAGE.get, TRUE);
205: ELSE
206: --+Cross instance data transfer program fails to start
207: FND_MESSAGE.set_name('SQLGL', 'GL_US_CI_FAIL_STARTCI');
208: FND_MESSAGE.set_token('RESULT', SUBSTR(SQLERRM,1,200), FALSE);
209: debug_message('==>' || FND_MESSAGE.get, TRUE);
210: END IF;
211: ELSE
212: --+consolidation program fails for any reason.
205: ELSE
206: --+Cross instance data transfer program fails to start
207: FND_MESSAGE.set_name('SQLGL', 'GL_US_CI_FAIL_STARTCI');
208: FND_MESSAGE.set_token('RESULT', SUBSTR(SQLERRM,1,200), FALSE);
209: debug_message('==>' || FND_MESSAGE.get, TRUE);
210: END IF;
211: ELSE
212: --+consolidation program fails for any reason.
213: FND_MESSAGE.set_name('SQLGL', 'GL_US_CI_PRE_FAIL');
209: debug_message('==>' || FND_MESSAGE.get, TRUE);
210: END IF;
211: ELSE
212: --+consolidation program fails for any reason.
213: FND_MESSAGE.set_name('SQLGL', 'GL_US_CI_PRE_FAIL');
214: debug_message('==>' || FND_MESSAGE.get, TRUE);
215: END IF; --+ end if complete:pass
216: END IF; --+End if p_cons_request_id is not zero
217: END pre_run_CI_transfer;
210: END IF;
211: ELSE
212: --+consolidation program fails for any reason.
213: FND_MESSAGE.set_name('SQLGL', 'GL_US_CI_PRE_FAIL');
214: debug_message('==>' || FND_MESSAGE.get, TRUE);
215: END IF; --+ end if complete:pass
216: END IF; --+End if p_cons_request_id is not zero
217: END pre_run_CI_transfer;
218: