91: X_finished_flag := X_tmp_flag;
92:
93: EXCEPTION
94: WHEN OTHERS THEN
95: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
96: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
97: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',X_curr_calling_sequence);
98: FND_MESSAGE.SET_TOKEN('PARAMETERS','CHECKRUN_NAME = '||X_batch_name);
99: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',X_debug_info);
92:
93: EXCEPTION
94: WHEN OTHERS THEN
95: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
96: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
97: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',X_curr_calling_sequence);
98: FND_MESSAGE.SET_TOKEN('PARAMETERS','CHECKRUN_NAME = '||X_batch_name);
99: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',X_debug_info);
100: APP_EXCEPTION.RAISE_EXCEPTION;
93: EXCEPTION
94: WHEN OTHERS THEN
95: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
96: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
97: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',X_curr_calling_sequence);
98: FND_MESSAGE.SET_TOKEN('PARAMETERS','CHECKRUN_NAME = '||X_batch_name);
99: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',X_debug_info);
100: APP_EXCEPTION.RAISE_EXCEPTION;
101:
94: WHEN OTHERS THEN
95: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
96: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
97: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',X_curr_calling_sequence);
98: FND_MESSAGE.SET_TOKEN('PARAMETERS','CHECKRUN_NAME = '||X_batch_name);
99: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',X_debug_info);
100: APP_EXCEPTION.RAISE_EXCEPTION;
101:
102: END pay_batch_requests_finished;
95: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
96: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
97: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',X_curr_calling_sequence);
98: FND_MESSAGE.SET_TOKEN('PARAMETERS','CHECKRUN_NAME = '||X_batch_name);
99: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',X_debug_info);
100: APP_EXCEPTION.RAISE_EXCEPTION;
101:
102: END pay_batch_requests_finished;
103:
191: EXCEPTION
192: WHEN NO_DATA_FOUND THEN
193: X_finished_flag := FALSE;
194: WHEN OTHERS THEN
195: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
196: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
197: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',X_curr_calling_sequence);
198: FND_MESSAGE.SET_TOKEN('PARAMETERS','PROGRAM_NAME = ' ||
199: X_program_name ||
192: WHEN NO_DATA_FOUND THEN
193: X_finished_flag := FALSE;
194: WHEN OTHERS THEN
195: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
196: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
197: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',X_curr_calling_sequence);
198: FND_MESSAGE.SET_TOKEN('PARAMETERS','PROGRAM_NAME = ' ||
199: X_program_name ||
200: ', APPLICATION_NAME = ' ||
193: X_finished_flag := FALSE;
194: WHEN OTHERS THEN
195: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
196: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
197: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',X_curr_calling_sequence);
198: FND_MESSAGE.SET_TOKEN('PARAMETERS','PROGRAM_NAME = ' ||
199: X_program_name ||
200: ', APPLICATION_NAME = ' ||
201: X_application_name);
194: WHEN OTHERS THEN
195: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
196: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
197: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',X_curr_calling_sequence);
198: FND_MESSAGE.SET_TOKEN('PARAMETERS','PROGRAM_NAME = ' ||
199: X_program_name ||
200: ', APPLICATION_NAME = ' ||
201: X_application_name);
202: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',X_debug_info);
198: FND_MESSAGE.SET_TOKEN('PARAMETERS','PROGRAM_NAME = ' ||
199: X_program_name ||
200: ', APPLICATION_NAME = ' ||
201: X_application_name);
202: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',X_debug_info);
203: APP_EXCEPTION.RAISE_EXCEPTION;
204:
205: END requests_finished;
206:
237: EXCEPTION
238: WHEN NO_DATA_FOUND THEN
239: X_execution_method := NULL;
240: WHEN OTHERS THEN
241: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
242: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
243: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',X_curr_calling_sequence);
244: FND_MESSAGE.SET_TOKEN('PARAMETERS','PROGRAM_NAME = ' || X_program_name);
245: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',X_debug_info);
238: WHEN NO_DATA_FOUND THEN
239: X_execution_method := NULL;
240: WHEN OTHERS THEN
241: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
242: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
243: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',X_curr_calling_sequence);
244: FND_MESSAGE.SET_TOKEN('PARAMETERS','PROGRAM_NAME = ' || X_program_name);
245: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',X_debug_info);
246: APP_EXCEPTION.RAISE_EXCEPTION;
239: X_execution_method := NULL;
240: WHEN OTHERS THEN
241: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
242: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
243: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',X_curr_calling_sequence);
244: FND_MESSAGE.SET_TOKEN('PARAMETERS','PROGRAM_NAME = ' || X_program_name);
245: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',X_debug_info);
246: APP_EXCEPTION.RAISE_EXCEPTION;
247:
240: WHEN OTHERS THEN
241: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
242: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
243: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',X_curr_calling_sequence);
244: FND_MESSAGE.SET_TOKEN('PARAMETERS','PROGRAM_NAME = ' || X_program_name);
245: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',X_debug_info);
246: APP_EXCEPTION.RAISE_EXCEPTION;
247:
248: END execution_method;
241: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
242: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
243: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',X_curr_calling_sequence);
244: FND_MESSAGE.SET_TOKEN('PARAMETERS','PROGRAM_NAME = ' || X_program_name);
245: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',X_debug_info);
246: APP_EXCEPTION.RAISE_EXCEPTION;
247:
248: END execution_method;
249:
277: EXCEPTION
278: WHEN NO_DATA_FOUND THEN
279: X_srs_flag := NULL;
280: WHEN OTHERS THEN
281: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
282: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
283: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',X_curr_calling_sequence);
284: FND_MESSAGE.SET_TOKEN('PARAMETERS','PROGRAM_NAME = ' || X_program_name);
285: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',X_debug_info);
278: WHEN NO_DATA_FOUND THEN
279: X_srs_flag := NULL;
280: WHEN OTHERS THEN
281: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
282: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
283: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',X_curr_calling_sequence);
284: FND_MESSAGE.SET_TOKEN('PARAMETERS','PROGRAM_NAME = ' || X_program_name);
285: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',X_debug_info);
286: APP_EXCEPTION.RAISE_EXCEPTION;
279: X_srs_flag := NULL;
280: WHEN OTHERS THEN
281: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
282: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
283: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',X_curr_calling_sequence);
284: FND_MESSAGE.SET_TOKEN('PARAMETERS','PROGRAM_NAME = ' || X_program_name);
285: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',X_debug_info);
286: APP_EXCEPTION.RAISE_EXCEPTION;
287:
280: WHEN OTHERS THEN
281: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
282: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
283: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',X_curr_calling_sequence);
284: FND_MESSAGE.SET_TOKEN('PARAMETERS','PROGRAM_NAME = ' || X_program_name);
285: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',X_debug_info);
286: APP_EXCEPTION.RAISE_EXCEPTION;
287:
288: END IS_PROGRAM_SRS;
281: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
282: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
283: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',X_curr_calling_sequence);
284: FND_MESSAGE.SET_TOKEN('PARAMETERS','PROGRAM_NAME = ' || X_program_name);
285: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',X_debug_info);
286: APP_EXCEPTION.RAISE_EXCEPTION;
287:
288: END IS_PROGRAM_SRS;
289: