DBA Data[Home] [Help]

APPS.IBY_FD_POST_PICP_PROGS_PVT dependencies on FND_REQUEST

Line 104: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST().',

100: iby_debug_pub.add(debug_msg => '============================================',
101: debug_level => FND_LOG.LEVEL_STATEMENT,
102: module => l_Debug_Module);
103:
104: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST().',
105: debug_level => FND_LOG.LEVEL_STATEMENT,
106: module => l_Debug_Module);
107:
108: --Bug 6411356

Line 112: l_bool_val:= FND_REQUEST.SET_OPTIONS( numeric_characters => l_icx_numeric_characters);

108: --Bug 6411356
109: --below code added to set the current nls character setting
110: --before submitting a child requests.
111: fnd_profile.get('ICX_NUMERIC_CHARACTERS',l_icx_numeric_characters);
112: l_bool_val:= FND_REQUEST.SET_OPTIONS( numeric_characters => l_icx_numeric_characters);
113:
114:
115: -- submit the extract program
116: x_request_id := FND_REQUEST.SUBMIT_REQUEST

Line 116: x_request_id := FND_REQUEST.SUBMIT_REQUEST

112: l_bool_val:= FND_REQUEST.SET_OPTIONS( numeric_characters => l_icx_numeric_characters);
113:
114:
115: -- submit the extract program
116: x_request_id := FND_REQUEST.SUBMIT_REQUEST
117: (
118: 'IBY',
119: 'IBY_FD_FEDERAL_SUMMARY',
120: null, -- description

Line 141: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST().',

137: '', '', '', '', '', '', '', '',
138: '', '', ''
139: );
140:
141: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST().',
142: debug_level => FND_LOG.LEVEL_STATEMENT,
143: module => l_Debug_Module);
144:
145: iby_debug_pub.add(debug_msg => 'Request id: ' || x_request_id,

Line 303: l_set_opt_ok := FND_REQUEST.SET_OPTIONS;

299: -- language IN varchar2 default NULL,
300: -- territory IN varchar2 default NULL
301: -- it appears that if the Use in SRS is turned off,
302: -- the CM will set the implicit to YES
303: l_set_opt_ok := FND_REQUEST.SET_OPTIONS;
304:
305: IF l_set_opt_ok THEN
306: iby_debug_pub.add(debug_msg => 'Set request implicit to NO ',
307: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 339: l_set_print_opt_ok := FND_REQUEST.SET_PRINT_OPTIONS

335: END IF;
336:
337:
338: IF l_save_no_output = 'Y' THEN
339: l_set_print_opt_ok := FND_REQUEST.SET_PRINT_OPTIONS
340: (printer => l_printer_name,
341: style => null,
342: copies => l_copies,
343: save_output => FALSE);

Line 345: l_set_print_opt_ok := FND_REQUEST.SET_PRINT_OPTIONS

341: style => null,
342: copies => l_copies,
343: save_output => FALSE);
344: ELSE
345: l_set_print_opt_ok := FND_REQUEST.SET_PRINT_OPTIONS
346: (printer => l_printer_name,
347: style => null,
348: copies => l_copies);
349: END IF;

Line 363: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST().',

359: debug_level => FND_LOG.LEVEL_STATEMENT,
360: module => l_Debug_Module);
361: END IF;
362:
363: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST().',
364: debug_level => FND_LOG.LEVEL_STATEMENT,
365: module => l_Debug_Module);
366:
367: --Bug 6411356

Line 371: l_bool_val:= FND_REQUEST.SET_OPTIONS( numeric_characters => l_icx_numeric_characters);

367: --Bug 6411356
368: --below code added to set the current nls character setting
369: --before submitting a child requests.
370: fnd_profile.get('ICX_NUMERIC_CHARACTERS',l_icx_numeric_characters);
371: l_bool_val:= FND_REQUEST.SET_OPTIONS( numeric_characters => l_icx_numeric_characters);
372:
373:
374: SELECT temp.application_short_name,
375: temp.template_code,

Line 403: /* l_bool := FND_REQUEST.add_layout

399: AND SYSDATE BETWEEN NVL(temp.start_date, SYSDATE) AND NVL(temp.end_date,SYSDATE);
400:
401:
402:
403: /* l_bool := FND_REQUEST.add_layout
404: (
405: l_appl_name,
406: l_template_code,
407: l_template_lang,

Line 418: l_request_id := FND_REQUEST.SUBMIT_REQUEST

414: -- submit the extract program
415:
416: IF l_output_format ='PDF' THEN
417:
418: l_request_id := FND_REQUEST.SUBMIT_REQUEST
419: (
420: 'IBY',
421: 'IBY_FD_PAYMENT_FORMAT',
422: null, -- description

Line 448: l_request_id := FND_REQUEST.SUBMIT_REQUEST

444: module => l_Debug_Module);
445:
446: ELSE
447:
448: l_request_id := FND_REQUEST.SUBMIT_REQUEST
449: (
450: 'IBY',
451: 'IBY_FD_PAYMENT_FORMAT_TEXT',
452: null, -- description

Line 478: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST().',

474: module => l_Debug_Module);
475:
476: END IF;
477:
478: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST().',
479: debug_level => FND_LOG.LEVEL_STATEMENT,
480: module => l_Debug_Module);
481: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
482: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2211: l_def_sts := fnd_request.set_deferred();

2207: iby_debug_pub.add(debug_msg => 'Setting request to deferred',
2208: debug_level => FND_LOG.LEVEL_STATEMENT,
2209: module => l_Debug_Module);
2210:
2211: l_def_sts := fnd_request.set_deferred();
2212:
2213: IF l_def_sts = FALSE THEN
2214: iby_debug_pub.add(debug_msg => 'Warning: failed to set request as deferred',
2215: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2220: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST()',

2216: module => l_Debug_Module);
2217:
2218: END IF;
2219:
2220: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST()',
2221: debug_level => FND_LOG.LEVEL_STATEMENT,
2222: module => l_Debug_Module);
2223:
2224:

Line 2229: l_bool_val:= FND_REQUEST.SET_OPTIONS( numeric_characters => l_icx_numeric_characters);

2225: --Bug 6411356
2226: --below code added to set the current nls character setting
2227: --before submitting a child requests.
2228: fnd_profile.get('ICX_NUMERIC_CHARACTERS',l_icx_numeric_characters);
2229: l_bool_val:= FND_REQUEST.SET_OPTIONS( numeric_characters => l_icx_numeric_characters);
2230:
2231:
2232: -- submit the extract program
2233: l_request_id := FND_REQUEST.SUBMIT_REQUEST

Line 2233: l_request_id := FND_REQUEST.SUBMIT_REQUEST

2229: l_bool_val:= FND_REQUEST.SET_OPTIONS( numeric_characters => l_icx_numeric_characters);
2230:
2231:
2232: -- submit the extract program
2233: l_request_id := FND_REQUEST.SUBMIT_REQUEST
2234: (
2235: 'IBY',
2236: 'IBY_RESET_PERIODIC_SEQ',
2237: null, -- description

Line 2258: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',

2254: '', '', '', '', '', '', '', '',
2255: '', '', ''
2256: );
2257:
2258: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',
2259: debug_level => FND_LOG.LEVEL_STATEMENT,
2260: module => l_Debug_Module);
2261: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
2262: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2316: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST()',

2312: RETURN;
2313: END IF;
2314:
2315:
2316: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST()',
2317: debug_level => FND_LOG.LEVEL_STATEMENT,
2318: module => l_Debug_Module);
2319:
2320:

Line 2325: l_return_status:= FND_REQUEST.SET_OPTIONS( numeric_characters => l_icx_numeric_characters);

2321: --Bug 6411356
2322: --below code added to set the current nls character setting
2323: --before submitting a child requests.
2324: fnd_profile.get('ICX_NUMERIC_CHARACTERS',l_icx_numeric_characters);
2325: l_return_status:= FND_REQUEST.SET_OPTIONS( numeric_characters => l_icx_numeric_characters);
2326:
2327:
2328: -- submit the acp ltr program
2329: -- note the format code is not passed

Line 2330: l_request_id := FND_REQUEST.SUBMIT_REQUEST

2326:
2327:
2328: -- submit the acp ltr program
2329: -- note the format code is not passed
2330: l_request_id := FND_REQUEST.SUBMIT_REQUEST
2331: (
2332: 'IBY',
2333: 'IBY_FD_ACP_LTR_FORMAT',
2334: null, -- description

Line 2353: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',

2349: '', '', '', '', '', '', '', '',
2350: '', '', ''
2351: );
2352:
2353: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',
2354: debug_level => FND_LOG.LEVEL_STATEMENT,
2355: module => l_Debug_Module);
2356: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
2357: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 2473: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST()',

2469: debug_level => FND_LOG.LEVEL_STATEMENT,
2470: module => l_Debug_Module);
2471:
2472:
2473: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST()',
2474: debug_level => FND_LOG.LEVEL_STATEMENT,
2475: module => l_Debug_Module);
2476:
2477:

Line 2482: l_bool_val:= FND_REQUEST.SET_OPTIONS( numeric_characters => l_icx_numeric_characters);

2478: --Bug 6411356
2479: --below code added to set the current nls character setting
2480: --before submitting a child requests.
2481: fnd_profile.get('ICX_NUMERIC_CHARACTERS',l_icx_numeric_characters);
2482: l_bool_val:= FND_REQUEST.SET_OPTIONS( numeric_characters => l_icx_numeric_characters);
2483:
2484: -- submit the extract program
2485: l_request_id := FND_REQUEST.SUBMIT_REQUEST
2486: (

Line 2485: l_request_id := FND_REQUEST.SUBMIT_REQUEST

2481: fnd_profile.get('ICX_NUMERIC_CHARACTERS',l_icx_numeric_characters);
2482: l_bool_val:= FND_REQUEST.SET_OPTIONS( numeric_characters => l_icx_numeric_characters);
2483:
2484: -- submit the extract program
2485: l_request_id := FND_REQUEST.SUBMIT_REQUEST
2486: (
2487: 'IBY',
2488: p_program_short_name,
2489: null, -- description

Line 2508: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',

2504: '', '', '', '', '', '', '', '',
2505: '', '', ''
2506: );
2507:
2508: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',
2509: debug_level => FND_LOG.LEVEL_STATEMENT,
2510: module => l_Debug_Module);
2511: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
2512: debug_level => FND_LOG.LEVEL_STATEMENT,