DBA Data[Home] [Help]

APPS.PO_RELGEN_PKG dependencies on FND_FILE

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

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

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

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

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

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

Line 675: FND_FILE.put_line(FND_FILE.LOG,

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

Line 1339: FND_FILE.put_line(FND_FILE.LOG,

1335:
1336: EXCEPTION
1337: --
1338: WHEN OTHERS THEN
1339: FND_FILE.put_line(FND_FILE.LOG,
1340: c_log_head || l_api_name || ' exception; location: '
1341: || l_progress || ' SQL code: ' || sqlcode);
1342: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1343: FND_LOG.string(FND_LOG.level_unexpected, c_log_head ||

Line 2295: FND_FILE.put_line(FND_FILE.LOG,

2291: -- Bug 2701147 START
2292: -- Write an error message to the log file.
2293: x_error_msg := FND_MESSAGE.GET_STRING('PO',
2294: 'PO_SUB_REL_AMT_LESS_MINREL_AMT');
2295: FND_FILE.put_line(FND_FILE.LOG,
2296: substr(g_reqmsg||g_delim||x_req_num||g_delim||g_linemsg||g_delim||
2297: x_req_line_num||g_delim||
2298: x_error_msg,1,240));
2299: x_check_status := FND_API.G_RET_STS_ERROR;

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

2309: fnd_message.set_token('REQ_NUM', x_req_num);
2310: fnd_message.set_token('LINE_NUM', x_req_line_num);
2311: fnd_message.set_token('PO_NUM',x_po_num);
2312: x_error_msg := fnd_message.get;
2313: fnd_file.put_line(fnd_file.log,x_error_msg);
2314: x_check_status := FND_API.G_RET_STS_ERROR; -- Bug 2701147
2315: END IF;
2316:
2317: EXCEPTION

Line 2718: FND_FILE.put_line(FND_FILE.LOG,

2714: 'PO_SUB_REQ_PRICE_TOL_EXCEED');
2715: get_req_info_from_po_shipment(
2716: l_line_location_id(shipment_line),
2717: l_req_num, l_req_line_num);
2718: FND_FILE.put_line(FND_FILE.LOG,
2719: substr(g_reqmsg||g_delim||
2720: l_req_num||g_delim||g_linemsg||g_delim||
2721: l_req_line_num||g_delim||
2722: l_textline,1,240));

Line 2800: FND_FILE.put_line(FND_FILE.LOG,

2796: FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REQ_AMT_TOL_EXCEED');
2797: get_req_info_from_po_shipment(
2798: l_line_location_id(shipment_line),
2799: l_req_num, l_req_line_num);
2800: FND_FILE.put_line(FND_FILE.LOG,
2801: substr(g_reqmsg||g_delim||
2802: l_req_num||g_delim||g_linemsg||g_delim||
2803: l_req_line_num||g_delim||
2804: l_textline,1,240));

Line 2819: FND_FILE.put_line(FND_FILE.LOG,

2815: END LOOP; --for shipment_line
2816:
2817: EXCEPTION
2818: WHEN OTHERS THEN
2819: FND_FILE.put_line(FND_FILE.LOG,
2820: c_log_head || l_api_name || ' exception; location: '
2821: || l_progress || ' SQL code: ' || sqlcode);
2822: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2823: FND_LOG.string(FND_LOG.level_unexpected, c_log_head ||

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

2929: AND PLL2.shipment_type in ('BLANKET', 'SCHEDULED'))
2930: GROUP BY POL.line_num,POL.min_release_amount;
2931:
2932: FOR i IN 1..l_error_messages.COUNT LOOP
2933: FND_FILE.put_line(FND_FILE.LOG, l_error_messages(i));
2934: END LOOP;
2935: IF l_error_messages.COUNT > 0 THEN
2936: x_check_status := FND_API.G_RET_STS_ERROR;
2937: END IF;

Line 2996: FND_FILE.put_line(FND_FILE.LOG,

2992:
2993: FOR i IN 1..l_error_messages.COUNT LOOP
2994: get_req_info_from_po_dist(l_dist_id(i),
2995: l_req_num, l_req_line_num);
2996: FND_FILE.put_line(FND_FILE.LOG,
2997: g_reqmsg||g_delim||l_req_num||g_delim||
2998: g_linemsg||g_delim||l_req_line_num||g_delim||
2999: l_error_messages(i));
3000: END LOOP;

Line 3046: FND_FILE.put_line(FND_FILE.LOG,

3042:
3043: FOR i IN 1..l_error_messages.COUNT LOOP
3044: get_req_info_from_po_shipment(l_line_location_id(i),
3045: l_req_num, l_req_line_num);
3046: FND_FILE.put_line(FND_FILE.LOG,
3047: g_reqmsg||g_delim||l_req_num||g_delim||
3048: g_linemsg||g_delim||l_req_line_num||g_delim||
3049: l_error_messages(i));
3050: FND_FILE.put_line(FND_FILE.LOG, l_error_messages(i));

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

3046: FND_FILE.put_line(FND_FILE.LOG,
3047: g_reqmsg||g_delim||l_req_num||g_delim||
3048: g_linemsg||g_delim||l_req_line_num||g_delim||
3049: l_error_messages(i));
3050: FND_FILE.put_line(FND_FILE.LOG, l_error_messages(i));
3051: END LOOP;
3052: IF l_error_messages.COUNT > 0 THEN
3053: x_check_status := FND_API.G_RET_STS_ERROR;
3054: END IF;

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

3118: AND ASR.business_rule = '1_PO_APPROVAL'
3119: HAVING sum(decode(ASR.allow_action_flag, 'Y', 1, -100)) > 0);
3120:
3121: FOR i IN 1..l_error_messages.COUNT LOOP
3122: FND_FILE.put_line(FND_FILE.LOG, l_error_messages(i));
3123: END LOOP;
3124: IF l_error_messages.COUNT > 0 THEN
3125: x_check_status := FND_API.G_RET_STS_ERROR;
3126: END IF;

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

3187: AND ASR.business_rule = '1_PO_APPROVAL'
3188: HAVING sum(decode(ASR.allow_action_flag, 'Y', 1, -100)) < 0);
3189:
3190: FOR i IN 1..l_error_messages.COUNT LOOP
3191: FND_FILE.put_line(FND_FILE.LOG, l_error_messages(i));
3192: END LOOP;
3193: IF l_error_messages.COUNT > 0 THEN
3194: x_check_status := FND_API.G_RET_STS_ERROR;
3195: END IF;

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

3238: p_vendor_site_id => l_vendor_site_id);
3239:
3240: IF NOT l_valid_registration THEN
3241: l_textline := FND_MESSAGE.get_string('PO', 'PO_VENDOR_SITE_CCR_INVALID');
3242: FND_FILE.put_line(FND_FILE.LOG, substr(g_reqmsg||g_delim
3243: ||p_req_num||g_delim||g_linemsg||g_delim
3244: ||p_req_line_num||g_delim||l_textline,1,240));
3245: x_check_status := FND_API.G_RET_STS_ERROR;
3246: END IF; -- l_valid_registration check

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

3267: AND Nvl(PLL.LCM_FLAG,'N') = 'Y'
3268: AND Nvl(PLL.match_option,'P') <> 'R';
3269:
3270: FOR i IN 1..l_error_messages.COUNT LOOP
3271: FND_FILE.put_line(FND_FILE.LOG, l_error_messages(i));
3272: END LOOP;
3273: IF l_error_messages.COUNT > 0 THEN
3274: x_check_status := FND_API.G_RET_STS_UNEXP_ERROR;
3275: END IF;

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

3296: AND Nvl(POD.LCM_FLAG,'N') = 'Y'
3297: AND POD.DESTINATION_TYPE_CODE <> 'INVENTORY';
3298:
3299: FOR i IN 1..l_error_messages.COUNT LOOP
3300: FND_FILE.put_line(FND_FILE.LOG, l_error_messages(i));
3301: END LOOP;
3302: IF l_error_messages.COUNT > 0 THEN
3303: x_check_status := FND_API.G_RET_STS_UNEXP_ERROR;
3304: END IF;

Line 3309: FND_FILE.put_line(FND_FILE.LOG,

3305:
3306: EXCEPTION
3307:
3308: WHEN OTHERS THEN
3309: FND_FILE.put_line(FND_FILE.LOG,
3310: c_log_head || l_api_name || ' exception; location: '
3311: || l_progress || ' SQL code: ' || sqlcode);
3312: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3313: FND_LOG.string(FND_LOG.level_unexpected, c_log_head ||

Line 3536: FND_FILE.put_line(FND_FILE.LOG,

3532: RAISE;
3533:
3534: WHEN OTHERS THEN
3535:
3536: FND_FILE.put_line(FND_FILE.LOG,
3537: c_log_head || l_api_name || ' exception; location: '
3538: || l_progress || ' SQL code: ' || sqlcode);
3539:
3540: IF (g_fnd_debug = 'Y') THEN