DBA Data[Home] [Help]

APPS.PO_RELGEN_PKG dependencies on FND_FILE

Line 186: fnd_file.put_line(fnd_file.log,x_error_msg);

182: fnd_message.set_name ('PO', 'PO_REQ_BPA_CONVERT_UOM');
183: fnd_message.set_token('REQ', x_req_num);
184: fnd_message.set_token('LINE', x_req_line_num);
185: x_error_msg := fnd_message.get;
186: fnd_file.put_line(fnd_file.log,x_error_msg);
187: x_no_convert_flag := 'Y';
188:
189: END IF;
190:

Line 221: fnd_file.put_line(FND_FILE.LOG, po_tax_interface_pvt.g_tax_errors_tbl.message_text(i) );

217: ||' po_release_id: '||x_po_release_id
218: );
219: END IF;
220: FOR i IN 1..po_tax_interface_pvt.g_tax_errors_tbl.message_text.COUNT LOOP
221: fnd_file.put_line(FND_FILE.LOG, po_tax_interface_pvt.g_tax_errors_tbl.message_text(i) );
222: END LOOP;
223: END IF;
224: l_progress := '043';
225:

Line 495: fnd_file.put_line(FND_FILE.LOG, po_tax_interface_pvt.g_tax_errors_tbl.message_text(i) );

491: ||' po_release_id: '||x_po_release_id
492: );
493: END IF;
494: FOR i IN 1..po_tax_interface_pvt.g_tax_errors_tbl.message_text.COUNT LOOP
495: fnd_file.put_line(FND_FILE.LOG, po_tax_interface_pvt.g_tax_errors_tbl.message_text(i) );
496: END LOOP;
497: END IF;
498: l_progress := '043';
499:

Line 676: FND_FILE.put_line(FND_FILE.LOG,

672:
673: WHEN OTHERS THEN
674: -- dbms_output.put_line ('In exception');
675: -- Bug 2701147 START
676: FND_FILE.put_line(FND_FILE.LOG,
677: c_log_head || l_api_name || '.' || l_progress
678: || ' exception; SQL code: ' || sqlcode);
679: -- Bug 2701147 END
680: raise_application_error(-20001,sqlerrm||'---'||msgbuf);

Line 1348: FND_FILE.put_line(FND_FILE.LOG,

1344:
1345: EXCEPTION
1346: --
1347: WHEN OTHERS THEN
1348: FND_FILE.put_line(FND_FILE.LOG,
1349: c_log_head || l_api_name || ' exception; location: '
1350: || l_progress || ' SQL code: ' || sqlcode);
1351: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1352: FND_LOG.string(FND_LOG.level_unexpected, c_log_head ||

Line 2320: FND_FILE.put_line(FND_FILE.LOG,

2316: -- Bug 2701147 START
2317: -- Write an error message to the log file.
2318: x_error_msg := FND_MESSAGE.GET_STRING('PO',
2319: 'PO_SUB_REL_AMT_LESS_MINREL_AMT');
2320: FND_FILE.put_line(FND_FILE.LOG,
2321: substr(g_reqmsg||g_delim||x_req_num||g_delim||g_linemsg||g_delim||
2322: x_req_line_num||g_delim||
2323: x_error_msg,1,240));
2324: x_check_status := FND_API.G_RET_STS_ERROR;

Line 2338: fnd_file.put_line(fnd_file.log,x_error_msg);

2334: fnd_message.set_token('REQ_NUM', x_req_num);
2335: fnd_message.set_token('LINE_NUM', x_req_line_num);
2336: fnd_message.set_token('PO_NUM',x_po_num);
2337: x_error_msg := fnd_message.get;
2338: fnd_file.put_line(fnd_file.log,x_error_msg);
2339: x_check_status := FND_API.G_RET_STS_ERROR; -- Bug 2701147
2340: END IF;
2341:
2342: EXCEPTION

Line 2743: FND_FILE.put_line(FND_FILE.LOG,

2739: 'PO_SUB_REQ_PRICE_TOL_EXCEED');
2740: get_req_info_from_po_shipment(
2741: l_line_location_id(shipment_line),
2742: l_req_num, l_req_line_num);
2743: FND_FILE.put_line(FND_FILE.LOG,
2744: substr(g_reqmsg||g_delim||
2745: l_req_num||g_delim||g_linemsg||g_delim||
2746: l_req_line_num||g_delim||
2747: l_textline,1,240));

Line 2825: FND_FILE.put_line(FND_FILE.LOG,

2821: FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REQ_AMT_TOL_EXCEED');
2822: get_req_info_from_po_shipment(
2823: l_line_location_id(shipment_line),
2824: l_req_num, l_req_line_num);
2825: FND_FILE.put_line(FND_FILE.LOG,
2826: substr(g_reqmsg||g_delim||
2827: l_req_num||g_delim||g_linemsg||g_delim||
2828: l_req_line_num||g_delim||
2829: l_textline,1,240));

Line 2844: FND_FILE.put_line(FND_FILE.LOG,

2840: END LOOP; --for shipment_line
2841:
2842: EXCEPTION
2843: WHEN OTHERS THEN
2844: FND_FILE.put_line(FND_FILE.LOG,
2845: c_log_head || l_api_name || ' exception; location: '
2846: || l_progress || ' SQL code: ' || sqlcode);
2847: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2848: FND_LOG.string(FND_LOG.level_unexpected, c_log_head ||

Line 2987: FND_FILE.put_line(FND_FILE.LOG, l_error_messages(i));

2983: AND PLL2.shipment_type in ('BLANKET', 'SCHEDULED'))*/
2984: GROUP BY POH.segment1, POL.line_num,POL.min_release_amount; --12553671
2985:
2986: FOR i IN 1..l_error_messages.COUNT LOOP
2987: FND_FILE.put_line(FND_FILE.LOG, l_error_messages(i));
2988: END LOOP;
2989: IF l_error_messages.COUNT > 0 THEN
2990: x_check_status := FND_API.G_RET_STS_ERROR;
2991: END IF;

Line 3050: FND_FILE.put_line(FND_FILE.LOG,

3046:
3047: FOR i IN 1..l_error_messages.COUNT LOOP
3048: get_req_info_from_po_dist(l_dist_id(i),
3049: l_req_num, l_req_line_num);
3050: FND_FILE.put_line(FND_FILE.LOG,
3051: g_reqmsg||g_delim||l_req_num||g_delim||
3052: g_linemsg||g_delim||l_req_line_num||g_delim||
3053: l_error_messages(i));
3054: END LOOP;

Line 3100: FND_FILE.put_line(FND_FILE.LOG,

3096:
3097: FOR i IN 1..l_error_messages.COUNT LOOP
3098: get_req_info_from_po_shipment(l_line_location_id(i),
3099: l_req_num, l_req_line_num);
3100: FND_FILE.put_line(FND_FILE.LOG,
3101: g_reqmsg||g_delim||l_req_num||g_delim||
3102: g_linemsg||g_delim||l_req_line_num||g_delim||
3103: l_error_messages(i));
3104: FND_FILE.put_line(FND_FILE.LOG, l_error_messages(i));

Line 3104: FND_FILE.put_line(FND_FILE.LOG, l_error_messages(i));

3100: FND_FILE.put_line(FND_FILE.LOG,
3101: g_reqmsg||g_delim||l_req_num||g_delim||
3102: g_linemsg||g_delim||l_req_line_num||g_delim||
3103: l_error_messages(i));
3104: FND_FILE.put_line(FND_FILE.LOG, l_error_messages(i));
3105: END LOOP;
3106: IF l_error_messages.COUNT > 0 THEN
3107: x_check_status := FND_API.G_RET_STS_ERROR;
3108: END IF;

Line 3176: FND_FILE.put_line(FND_FILE.LOG, l_error_messages(i));

3172: AND ASR.business_rule = '1_PO_APPROVAL'
3173: HAVING sum(decode(ASR.allow_action_flag, 'Y', 1, -100)) > 0);
3174:
3175: FOR i IN 1..l_error_messages.COUNT LOOP
3176: FND_FILE.put_line(FND_FILE.LOG, l_error_messages(i));
3177: END LOOP;
3178: IF l_error_messages.COUNT > 0 THEN
3179: x_check_status := FND_API.G_RET_STS_ERROR;
3180: END IF;

Line 3245: FND_FILE.put_line(FND_FILE.LOG, l_error_messages(i));

3241: AND ASR.business_rule = '1_PO_APPROVAL'
3242: HAVING sum(decode(ASR.allow_action_flag, 'Y', 1, -100)) < 0);
3243:
3244: FOR i IN 1..l_error_messages.COUNT LOOP
3245: FND_FILE.put_line(FND_FILE.LOG, l_error_messages(i));
3246: END LOOP;
3247: IF l_error_messages.COUNT > 0 THEN
3248: x_check_status := FND_API.G_RET_STS_ERROR;
3249: END IF;

Line 3296: FND_FILE.put_line(FND_FILE.LOG, substr(g_reqmsg||g_delim

3292: p_vendor_site_id => l_vendor_site_id);
3293:
3294: IF NOT l_valid_registration THEN
3295: l_textline := FND_MESSAGE.get_string('PO', 'PO_VENDOR_SITE_CCR_INVALID');
3296: FND_FILE.put_line(FND_FILE.LOG, substr(g_reqmsg||g_delim
3297: ||p_req_num||g_delim||g_linemsg||g_delim
3298: ||p_req_line_num||g_delim||l_textline,1,240));
3299: x_check_status := FND_API.G_RET_STS_ERROR;
3300: END IF; -- l_valid_registration check

Line 3325: FND_FILE.put_line(FND_FILE.LOG, l_error_messages(i));

3321: AND Nvl(PLL.LCM_FLAG,'N') = 'Y'
3322: AND Nvl(PLL.match_option,'P') <> 'R';
3323:
3324: FOR i IN 1..l_error_messages.COUNT LOOP
3325: FND_FILE.put_line(FND_FILE.LOG, l_error_messages(i));
3326: END LOOP;
3327: IF l_error_messages.COUNT > 0 THEN
3328: x_check_status := FND_API.G_RET_STS_UNEXP_ERROR;
3329: END IF;

Line 3354: FND_FILE.put_line(FND_FILE.LOG, l_error_messages(i));

3350: AND Nvl(POD.LCM_FLAG,'N') = 'Y'
3351: AND POD.DESTINATION_TYPE_CODE <> 'INVENTORY';
3352:
3353: FOR i IN 1..l_error_messages.COUNT LOOP
3354: FND_FILE.put_line(FND_FILE.LOG, l_error_messages(i));
3355: END LOOP;
3356: IF l_error_messages.COUNT > 0 THEN
3357: x_check_status := FND_API.G_RET_STS_UNEXP_ERROR;
3358: END IF;

Line 3363: FND_FILE.put_line(FND_FILE.LOG,

3359:
3360: EXCEPTION
3361:
3362: WHEN OTHERS THEN
3363: FND_FILE.put_line(FND_FILE.LOG,
3364: c_log_head || l_api_name || ' exception; location: '
3365: || l_progress || ' SQL code: ' || sqlcode);
3366: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3367: FND_LOG.string(FND_LOG.level_unexpected, c_log_head ||

Line 3590: FND_FILE.put_line(FND_FILE.LOG,

3586: RAISE;
3587:
3588: WHEN OTHERS THEN
3589:
3590: FND_FILE.put_line(FND_FILE.LOG,
3591: c_log_head || l_api_name || ' exception; location: '
3592: || l_progress || ' SQL code: ' || sqlcode);
3593:
3594: IF (g_fnd_debug = 'Y') THEN