67: RAISE Request_Submission_Failure;
68: END IF;
69: EXCEPTION
70: WHEN request_submission_failure THEN
71: l_msg := FND_MESSAGE.GET;
72: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
73: FND_MESSAGE.SET_TOKEN('ERROR',l_msg);
74: FND_MESSAGE.SET_TOKEN('PARAMETERS',
75: ',P_FLEX_NAME='||P_FLEX_NAME);
68: END IF;
69: EXCEPTION
70: WHEN request_submission_failure THEN
71: l_msg := FND_MESSAGE.GET;
72: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
73: FND_MESSAGE.SET_TOKEN('ERROR',l_msg);
74: FND_MESSAGE.SET_TOKEN('PARAMETERS',
75: ',P_FLEX_NAME='||P_FLEX_NAME);
76: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
69: EXCEPTION
70: WHEN request_submission_failure THEN
71: l_msg := FND_MESSAGE.GET;
72: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
73: FND_MESSAGE.SET_TOKEN('ERROR',l_msg);
74: FND_MESSAGE.SET_TOKEN('PARAMETERS',
75: ',P_FLEX_NAME='||P_FLEX_NAME);
76: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
77: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
70: WHEN request_submission_failure THEN
71: l_msg := FND_MESSAGE.GET;
72: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
73: FND_MESSAGE.SET_TOKEN('ERROR',l_msg);
74: FND_MESSAGE.SET_TOKEN('PARAMETERS',
75: ',P_FLEX_NAME='||P_FLEX_NAME);
76: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
77: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
78:
72: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
73: FND_MESSAGE.SET_TOKEN('ERROR',l_msg);
74: FND_MESSAGE.SET_TOKEN('PARAMETERS',
75: ',P_FLEX_NAME='||P_FLEX_NAME);
76: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
77: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
78:
79: l_errbuf := 'Request Submission Failed for request ' || p_request_id;
80: FND_FILE.PUT_LINE(FND_FILE.LOG, l_errbuf || ' Message: ' || l_msg);
73: FND_MESSAGE.SET_TOKEN('ERROR',l_msg);
74: FND_MESSAGE.SET_TOKEN('PARAMETERS',
75: ',P_FLEX_NAME='||P_FLEX_NAME);
76: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
77: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
78:
79: l_errbuf := 'Request Submission Failed for request ' || p_request_id;
80: FND_FILE.PUT_LINE(FND_FILE.LOG, l_errbuf || ' Message: ' || l_msg);
81: RETURN;
80: FND_FILE.PUT_LINE(FND_FILE.LOG, l_errbuf || ' Message: ' || l_msg);
81: RETURN;
82: WHEN OTHERS then
83: IF (SQLCODE <> -20001 ) THEN
84: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
85: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
86: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
87: FND_MESSAGE.SET_TOKEN('PARAMETERS','Request ID = '||TO_CHAR(p_request_id));
88: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
81: RETURN;
82: WHEN OTHERS then
83: IF (SQLCODE <> -20001 ) THEN
84: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
85: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
86: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
87: FND_MESSAGE.SET_TOKEN('PARAMETERS','Request ID = '||TO_CHAR(p_request_id));
88: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
89: l_errbuf := 'Exception occurred for request ' || p_request_id;
82: WHEN OTHERS then
83: IF (SQLCODE <> -20001 ) THEN
84: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
85: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
86: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
87: FND_MESSAGE.SET_TOKEN('PARAMETERS','Request ID = '||TO_CHAR(p_request_id));
88: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
89: l_errbuf := 'Exception occurred for request ' || p_request_id;
90: FND_FILE.PUT_LINE(FND_FILE.LOG, l_errbuf);
83: IF (SQLCODE <> -20001 ) THEN
84: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
85: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
86: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
87: FND_MESSAGE.SET_TOKEN('PARAMETERS','Request ID = '||TO_CHAR(p_request_id));
88: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
89: l_errbuf := 'Exception occurred for request ' || p_request_id;
90: FND_FILE.PUT_LINE(FND_FILE.LOG, l_errbuf);
91: END IF;
84: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
85: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
86: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
87: FND_MESSAGE.SET_TOKEN('PARAMETERS','Request ID = '||TO_CHAR(p_request_id));
88: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
89: l_errbuf := 'Exception occurred for request ' || p_request_id;
90: FND_FILE.PUT_LINE(FND_FILE.LOG, l_errbuf);
91: END IF;
92:
223: END IF;
224:
225: EXCEPTION
226: WHEN invalid_flexfield_error THEN
227: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
228: FND_MESSAGE.SET_TOKEN('ERROR',l_msg);
229: FND_MESSAGE.SET_TOKEN('PARAMETERS',
230: ',P_FLEX_NAME='||P_FLEX_NAME);
231: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
224:
225: EXCEPTION
226: WHEN invalid_flexfield_error THEN
227: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
228: FND_MESSAGE.SET_TOKEN('ERROR',l_msg);
229: FND_MESSAGE.SET_TOKEN('PARAMETERS',
230: ',P_FLEX_NAME='||P_FLEX_NAME);
231: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
232: return;
225: EXCEPTION
226: WHEN invalid_flexfield_error THEN
227: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
228: FND_MESSAGE.SET_TOKEN('ERROR',l_msg);
229: FND_MESSAGE.SET_TOKEN('PARAMETERS',
230: ',P_FLEX_NAME='||P_FLEX_NAME);
231: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
232: return;
233:
227: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
228: FND_MESSAGE.SET_TOKEN('ERROR',l_msg);
229: FND_MESSAGE.SET_TOKEN('PARAMETERS',
230: ',P_FLEX_NAME='||P_FLEX_NAME);
231: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
232: return;
233:
234: WHEN OTHERS then
235: IF (SQLCODE <> -20001 ) THEN
232: return;
233:
234: WHEN OTHERS then
235: IF (SQLCODE <> -20001 ) THEN
236: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
237: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
238: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
239: FND_MESSAGE.SET_TOKEN('PARAMETERS','Request ID = '||TO_CHAR(l_request_id));
240: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
233:
234: WHEN OTHERS then
235: IF (SQLCODE <> -20001 ) THEN
236: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
237: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
238: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
239: FND_MESSAGE.SET_TOKEN('PARAMETERS','Request ID = '||TO_CHAR(l_request_id));
240: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
241: l_errbuf := 'Exception occurred for request ' || l_request_id;
234: WHEN OTHERS then
235: IF (SQLCODE <> -20001 ) THEN
236: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
237: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
238: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
239: FND_MESSAGE.SET_TOKEN('PARAMETERS','Request ID = '||TO_CHAR(l_request_id));
240: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
241: l_errbuf := 'Exception occurred for request ' || l_request_id;
242: FND_FILE.PUT_LINE(FND_FILE.LOG, l_errbuf);
235: IF (SQLCODE <> -20001 ) THEN
236: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
237: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
238: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
239: FND_MESSAGE.SET_TOKEN('PARAMETERS','Request ID = '||TO_CHAR(l_request_id));
240: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
241: l_errbuf := 'Exception occurred for request ' || l_request_id;
242: FND_FILE.PUT_LINE(FND_FILE.LOG, l_errbuf);
243: END IF;
236: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
237: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
238: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
239: FND_MESSAGE.SET_TOKEN('PARAMETERS','Request ID = '||TO_CHAR(l_request_id));
240: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
241: l_errbuf := 'Exception occurred for request ' || l_request_id;
242: FND_FILE.PUT_LINE(FND_FILE.LOG, l_errbuf);
243: END IF;
244: