APPS.GR_PROCESS_ORDERS dependencies on FND_FILE

Line 258: FND_FILE.PUT(FND_FILE.LOG, 'OM Integration' || l_om_integration);

254: ** B2286375 Check if using OM or OF
255: */
256: l_om_integration := FND_PROFILE.VALUE('GML_OM_INTEGRATION');
257:
258: FND_FILE.PUT(FND_FILE.LOG, 'OM Integration' || l_om_integration);
259: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
260:
261: /*
262: ** Check the passed in batch number is not null

Line 259: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

255: */
256: l_om_integration := FND_PROFILE.VALUE('GML_OM_INTEGRATION');
257:
258: FND_FILE.PUT(FND_FILE.LOG, 'OM Integration' || l_om_integration);
259: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
260:
261: /*
262: ** Check the passed in batch number is not null
263: ** and exists on the batch selection header and the

Line 323: FND_FILE.PUT(FND_FILE.LOG, l_code_block);

319: l_code_block := 'Process shipments';
320: IF GlobalBatchHeader.shipment_from IS NULL AND
321: GlobalBatchHeader.shipment_to IS NULL THEN
322: l_code_block := 'Process by shipment date';
323: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
324: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
325:
326: OPEN c_get_shipment_date;
327: FETCH c_get_shipment_date INTO LocalShipmentDate;

Line 324: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

320: IF GlobalBatchHeader.shipment_from IS NULL AND
321: GlobalBatchHeader.shipment_to IS NULL THEN
322: l_code_block := 'Process by shipment date';
323: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
324: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
325:
326: OPEN c_get_shipment_date;
327: FETCH c_get_shipment_date INTO LocalShipmentDate;
328: IF c_get_shipment_date%FOUND THEN

Line 332: FND_FILE.PUT(FND_FILE.LOG, ' Shipment : '||LocalShipmentDate.bol_no||' Order : '||LocalShipmentDate.order_no||' - '||TO_CHAR(LocalShipmentDate.line_no));

328: IF c_get_shipment_date%FOUND THEN
329: WHILE c_get_shipment_date%FOUND LOOP
330: g_item_code := LocalShipmentDate.item_no;
331: IF LocalShipmentDate.shipping_ind <> 0 THEN
332: FND_FILE.PUT(FND_FILE.LOG, ' Shipment : '||LocalShipmentDate.bol_no||' Order : '||LocalShipmentDate.order_no||' - '||TO_CHAR(LocalShipmentDate.line_no));
333: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
334:
335: l_code_block := 'Hold reason does not allow order to be shipped';
336:

Line 333: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

329: WHILE c_get_shipment_date%FOUND LOOP
330: g_item_code := LocalShipmentDate.item_no;
331: IF LocalShipmentDate.shipping_ind <> 0 THEN
332: FND_FILE.PUT(FND_FILE.LOG, ' Shipment : '||LocalShipmentDate.bol_no||' Order : '||LocalShipmentDate.order_no||' - '||TO_CHAR(LocalShipmentDate.line_no));
333: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
334:
335: l_code_block := 'Hold reason does not allow order to be shipped';
336:
337: FND_FILE.PUT(FND_FILE.LOG, l_code_block);

Line 337: FND_FILE.PUT(FND_FILE.LOG, l_code_block);

333: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
334:
335: l_code_block := 'Hold reason does not allow order to be shipped';
336:
337: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
338: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
339:
340: l_return_status := FND_API.G_RET_STS_SUCCESS;
341: Insert_Selection_Row

Line 338: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

334:
335: l_code_block := 'Hold reason does not allow order to be shipped';
336:
337: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
338: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
339:
340: l_return_status := FND_API.G_RET_STS_SUCCESS;
341: Insert_Selection_Row
342: ('GR_ON_HOLD_NO_SHIP',

Line 381: FND_FILE.PUT(FND_FILE.LOG, l_code_block);

377: CLOSE c_get_shipment_date;
378: ELSE
379: l_code_block := 'Process by shipment number';
380:
381: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
382: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
383:
384: IF c_get_shipment_detail%ISOPEN THEN
385: CLOSE c_get_shipment_detail;

Line 382: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

378: ELSE
379: l_code_block := 'Process by shipment number';
380:
381: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
382: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
383:
384: IF c_get_shipment_detail%ISOPEN THEN
385: CLOSE c_get_shipment_detail;
386: END IF;

Line 392: FND_FILE.PUT(FND_FILE.LOG, ' Shipment : '||LocalShipmentDetail.bol_no||' Order : '||LocalShipmentDetail.order_no||' - '||TO_CHAR(LocalShipmentDetail.line_no));

388: OPEN c_get_shipment_detail;
389: FETCH c_get_shipment_detail INTO LocalShipmentDetail;
390: IF c_get_shipment_detail%FOUND THEN
391: WHILE c_get_shipment_detail%FOUND LOOP
392: FND_FILE.PUT(FND_FILE.LOG, ' Shipment : '||LocalShipmentDetail.bol_no||' Order : '||LocalShipmentDetail.order_no||' - '||TO_CHAR(LocalShipmentDetail.line_no));
393: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
394: g_item_code := LocalShipmentDetail.item_no;
395: IF LocalShipmentDetail.shipping_ind <> 0 THEN
396: l_code_block := 'Hold reason does not allow order to be shipped';

Line 393: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

389: FETCH c_get_shipment_detail INTO LocalShipmentDetail;
390: IF c_get_shipment_detail%FOUND THEN
391: WHILE c_get_shipment_detail%FOUND LOOP
392: FND_FILE.PUT(FND_FILE.LOG, ' Shipment : '||LocalShipmentDetail.bol_no||' Order : '||LocalShipmentDetail.order_no||' - '||TO_CHAR(LocalShipmentDetail.line_no));
393: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
394: g_item_code := LocalShipmentDetail.item_no;
395: IF LocalShipmentDetail.shipping_ind <> 0 THEN
396: l_code_block := 'Hold reason does not allow order to be shipped';
397:

Line 398: FND_FILE.PUT(FND_FILE.LOG, l_code_block);

394: g_item_code := LocalShipmentDetail.item_no;
395: IF LocalShipmentDetail.shipping_ind <> 0 THEN
396: l_code_block := 'Hold reason does not allow order to be shipped';
397:
398: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
399: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
400:
401: l_return_status := FND_API.G_RET_STS_SUCCESS;
402: Insert_Selection_Row

Line 399: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

395: IF LocalShipmentDetail.shipping_ind <> 0 THEN
396: l_code_block := 'Hold reason does not allow order to be shipped';
397:
398: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
399: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
400:
401: l_return_status := FND_API.G_RET_STS_SUCCESS;
402: Insert_Selection_Row
403: ('GR_ON_HOLD_NO_SHIP',

Line 441: FND_FILE.PUT(FND_FILE.LOG, l_code_block);

437: CLOSE c_get_shipment_detail;
438: END IF;
439: ELSE
440: l_code_block := 'Process orders';
441: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
442: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
443:
444: OPEN c_get_order_detail;
445: FETCH c_get_order_detail INTO LocalOrderDetail;

Line 442: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

438: END IF;
439: ELSE
440: l_code_block := 'Process orders';
441: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
442: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
443:
444: OPEN c_get_order_detail;
445: FETCH c_get_order_detail INTO LocalOrderDetail;
446: IF c_get_order_detail%FOUND THEN

Line 449: FND_FILE.PUT(FND_FILE.LOG, ' Order : '||LocalOrderDetail.order_no||' - '||TO_CHAR(LocalOrderDetail.line_no));

445: FETCH c_get_order_detail INTO LocalOrderDetail;
446: IF c_get_order_detail%FOUND THEN
447:
448: WHILE c_get_order_detail%FOUND LOOP
449: FND_FILE.PUT(FND_FILE.LOG, ' Order : '||LocalOrderDetail.order_no||' - '||TO_CHAR(LocalOrderDetail.line_no));
450: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
451:
452: g_item_code := LocalOrderDetail.item_no;
453: IF l_om_integration = 'N' THEN /*Added for OM Integration B2286375*/

Line 450: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

446: IF c_get_order_detail%FOUND THEN
447:
448: WHILE c_get_order_detail%FOUND LOOP
449: FND_FILE.PUT(FND_FILE.LOG, ' Order : '||LocalOrderDetail.order_no||' - '||TO_CHAR(LocalOrderDetail.line_no));
450: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
451:
452: g_item_code := LocalOrderDetail.item_no;
453: IF l_om_integration = 'N' THEN /*Added for OM Integration B2286375*/
454: --utl_file.put_line(pg_fp, 'integrn ' ||l_om_integration);

Line 461: FND_FILE.PUT(FND_FILE.LOG, l_code_block);

457: IF LocalOrderDetail.picking_ind <> 0 AND
458: LocalOrderDetail.picking_ind IS NOT NULL THEN
459: l_code_block := 'Hold reason does not allow order to be picked';
460:
461: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
462: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
463:
464: l_return_status := FND_API.G_RET_STS_SUCCESS;
465: Insert_Selection_Row

Line 462: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

458: LocalOrderDetail.picking_ind IS NOT NULL THEN
459: l_code_block := 'Hold reason does not allow order to be picked';
460:
461: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
462: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
463:
464: l_return_status := FND_API.G_RET_STS_SUCCESS;
465: Insert_Selection_Row
466: ('GR_ON_HOLD_NO_PICK',

Line 485: FND_FILE.PUT(FND_FILE.LOG, l_code_block);

481: ELSIF LocalOrderDetail.shipping_ind <> 0 AND
482: LocalOrderDetail.shipping_ind IS NOT NULL THEN
483: l_code_block := 'Hold reason does not allow order to be shipped';
484: --utl_file.put_line(pg_fp, 'code '||l_code_block);
485: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
486: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
487:
488: l_return_status := FND_API.G_RET_STS_SUCCESS;
489: Insert_Selection_Row

Line 486: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

482: LocalOrderDetail.shipping_ind IS NOT NULL THEN
483: l_code_block := 'Hold reason does not allow order to be shipped';
484: --utl_file.put_line(pg_fp, 'code '||l_code_block);
485: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
486: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
487:
488: l_return_status := FND_API.G_RET_STS_SUCCESS;
489: Insert_Selection_Row
490: ('GR_ON_HOLD_NO_SHIP',

Line 511: FND_FILE.PUT(FND_FILE.LOG, l_code_block);

507: IF LocalOrderDetail.bol_id <> 0 AND
508: LocalOrderDetail.bol_id IS NOT NULL THEN
509: l_code_block := ' Line already shipped';
510:
511: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
512: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
513:
514: l_return_status := FND_API.G_RET_STS_SUCCESS;
515: Insert_Selection_Row

Line 512: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

508: LocalOrderDetail.bol_id IS NOT NULL THEN
509: l_code_block := ' Line already shipped';
510:
511: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
512: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
513:
514: l_return_status := FND_API.G_RET_STS_SUCCESS;
515: Insert_Selection_Row
516: ('GR_ORDER_ALREADY_SHIPPED',

Line 559: FND_FILE.PUT(FND_FILE.LOG, l_code_block);

555: FETCH c_get_hold INTO LocalHoldRecord;
556: IF c_get_hold%FOUND THEN
557: l_code_block := 'Hold reason does not allow order to be picked';
558: --utl_file.put_line(pg_fp,'code blk ' ||l_code_block);
559: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
560: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
561:
562: l_return_status := FND_API.G_RET_STS_SUCCESS;
563: Insert_Selection_Row

Line 560: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

556: IF c_get_hold%FOUND THEN
557: l_code_block := 'Hold reason does not allow order to be picked';
558: --utl_file.put_line(pg_fp,'code blk ' ||l_code_block);
559: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
560: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
561:
562: l_return_status := FND_API.G_RET_STS_SUCCESS;
563: Insert_Selection_Row
564: ('GR_ON_HOLD_NO_PICK',

Line 840: FND_FILE.PUT(FND_FILE.LOG, ' Report Type ' || g_report_type);

836: END IF;
837:
838: /* 17-Jun-2003 Mercy Thomas BUG 2932007 - Added report type for Document Management */
839:
840: FND_FILE.PUT(FND_FILE.LOG, ' Report Type ' || g_report_type);
841: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
842: IF g_report_type = 0 THEN
843: g_report_type := 4;
844: FND_FILE.PUT(FND_FILE.LOG, ' Report Type ' || g_report_type);

Line 841: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

837:
838: /* 17-Jun-2003 Mercy Thomas BUG 2932007 - Added report type for Document Management */
839:
840: FND_FILE.PUT(FND_FILE.LOG, ' Report Type ' || g_report_type);
841: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
842: IF g_report_type = 0 THEN
843: g_report_type := 4;
844: FND_FILE.PUT(FND_FILE.LOG, ' Report Type ' || g_report_type);
845: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 844: FND_FILE.PUT(FND_FILE.LOG, ' Report Type ' || g_report_type);

840: FND_FILE.PUT(FND_FILE.LOG, ' Report Type ' || g_report_type);
841: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
842: IF g_report_type = 0 THEN
843: g_report_type := 4;
844: FND_FILE.PUT(FND_FILE.LOG, ' Report Type ' || g_report_type);
845: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
846: END IF;
847: /* 17-Jun-2003 Mercy Thomas BUG 2932007 - End of code changes */
848:

Line 845: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

841: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
842: IF g_report_type = 0 THEN
843: g_report_type := 4;
844: FND_FILE.PUT(FND_FILE.LOG, ' Report Type ' || g_report_type);
845: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
846: END IF;
847: /* 17-Jun-2003 Mercy Thomas BUG 2932007 - End of code changes */
848:
849: /*

Line 966: FND_FILE.PUT(FND_FILE.LOG, l_code_block||' - '||LocalDetailRecord.order_no||' - '||TO_CHAR(LocalDetailRecord.order_line_number));

962: IF l_header_status = 4 AND
963: (LocalDetailRecord.line_status <> 2 OR
964: LocalDetailRecord.line_status <> 3) THEN
965: l_code_block := 'Do not print this line';
966: FND_FILE.PUT(FND_FILE.LOG, l_code_block||' - '||LocalDetailRecord.order_no||' - '||TO_CHAR(LocalDetailRecord.order_line_number));
967: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
968: ELSE
969: SAVEPOINT Process_Document_Selection;
970: /*

Line 967: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

963: (LocalDetailRecord.line_status <> 2 OR
964: LocalDetailRecord.line_status <> 3) THEN
965: l_code_block := 'Do not print this line';
966: FND_FILE.PUT(FND_FILE.LOG, l_code_block||' - '||LocalDetailRecord.order_no||' - '||TO_CHAR(LocalDetailRecord.order_line_number));
967: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
968: ELSE
969: SAVEPOINT Process_Document_Selection;
970: /*
971: ** Set the line status to printing in process

Line 1013: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');

1009: '',
1010: l_return_status);
1011: IF l_return_status <> 'S' THEN
1012: l_code_block := 'Error';
1013: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');
1014: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1015: RAISE Other_API_Error;
1016: END IF;
1017: /*

Line 1014: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1010: l_return_status);
1011: IF l_return_status <> 'S' THEN
1012: l_code_block := 'Error';
1013: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');
1014: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1015: RAISE Other_API_Error;
1016: END IF;
1017: /*
1018: ** Print the letter and increment the session id

Line 1030: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

1026: g_default_document,
1027: l_language_code,
1028: l_return_status);
1029: IF l_return_status <> 'S' THEN
1030: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
1031: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1032: END IF;
1033: l_return_status := 'S';
1034: END IF;

Line 1031: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1027: l_language_code,
1028: l_return_status);
1029: IF l_return_status <> 'S' THEN
1030: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
1031: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1032: END IF;
1033: l_return_status := 'S';
1034: END IF;
1035: l_code_block := 'Print document in default language';

Line 1073: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');

1069: '',
1070: l_return_status);
1071: IF l_return_status <> 'S' THEN
1072: l_code_block := 'Error';
1073: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');
1074: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1075: RAISE Other_API_Error;
1076: END IF;
1077: /*

Line 1074: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1070: l_return_status);
1071: IF l_return_status <> 'S' THEN
1072: l_code_block := 'Error';
1073: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');
1074: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1075: RAISE Other_API_Error;
1076: END IF;
1077: /*
1078: ** Print the letter and increment the session id

Line 1090: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

1086: g_default_document,
1087: l_language_code,
1088: l_return_status);
1089: IF l_return_status <> 'S' THEN
1090: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
1091: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1092: END IF;
1093: l_return_status := 'S';
1094: END IF;

Line 1091: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1087: l_language_code,
1088: l_return_status);
1089: IF l_return_status <> 'S' THEN
1090: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
1091: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1092: END IF;
1093: l_return_status := 'S';
1094: END IF;
1095: l_code_block := 'Print document in default language';

Line 1132: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');

1128: '',
1129: l_return_status);
1130: IF l_return_status <> 'S' THEN
1131: l_code_block := 'Error';
1132: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');
1133: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1134: RAISE Other_API_Error;
1135: END IF;
1136: /*

Line 1133: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1129: l_return_status);
1130: IF l_return_status <> 'S' THEN
1131: l_code_block := 'Error';
1132: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');
1133: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1134: RAISE Other_API_Error;
1135: END IF;
1136: /*
1137: ** Print the letter and increment the session id

Line 1149: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

1145: g_default_document,
1146: l_language_code,
1147: l_return_status);
1148: IF l_return_status <> 'S' THEN
1149: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
1150: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1151: END IF;
1152: l_return_status := 'S';
1153: END IF;

Line 1150: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1146: l_language_code,
1147: l_return_status);
1148: IF l_return_status <> 'S' THEN
1149: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
1150: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1151: END IF;
1152: l_return_status := 'S';
1153: END IF;
1154: l_code_block := 'Print document in region language';

Line 1200: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');

1196: '',
1197: l_return_status);
1198: IF l_return_status <> 'S' THEN
1199: l_code_block := 'Error';
1200: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');
1201: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1202: RAISE Other_API_Error;
1203: END IF;
1204: /*

Line 1201: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1197: l_return_status);
1198: IF l_return_status <> 'S' THEN
1199: l_code_block := 'Error';
1200: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');
1201: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1202: RAISE Other_API_Error;
1203: END IF;
1204: /*
1205: ** Print the letter and increment the session id

Line 1217: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

1213: g_default_document,
1214: l_language_code,
1215: l_return_status);
1216: IF l_return_status <> 'S' THEN
1217: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
1218: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1219: END IF;
1220: l_return_status := 'S';
1221: END IF;

Line 1218: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1214: l_language_code,
1215: l_return_status);
1216: IF l_return_status <> 'S' THEN
1217: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
1218: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1219: END IF;
1220: l_return_status := 'S';
1221: END IF;
1222: l_code_block := 'Print document in default language';

Line 1260: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');

1256: '',
1257: l_return_status);
1258: IF l_return_status <> 'S' THEN
1259: l_code_block := 'Error';
1260: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');
1261: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1262: RAISE Other_API_Error;
1263: END IF;
1264: /*

Line 1261: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1257: l_return_status);
1258: IF l_return_status <> 'S' THEN
1259: l_code_block := 'Error';
1260: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');
1261: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1262: RAISE Other_API_Error;
1263: END IF;
1264: /*
1265: ** Print the letter and increment the session id

Line 1277: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

1273: g_default_document,
1274: l_language_code,
1275: l_return_status);
1276: IF l_return_status <> 'S' THEN
1277: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
1278: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1279: END IF;
1280: l_return_status := 'S';
1281: END IF;

Line 1278: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1274: l_language_code,
1275: l_return_status);
1276: IF l_return_status <> 'S' THEN
1277: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
1278: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1279: END IF;
1280: l_return_status := 'S';
1281: END IF;
1282: l_code_block := 'Print document in default language';

Line 1319: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');

1315: '',
1316: l_return_status);
1317: IF l_return_status <> 'S' THEN
1318: l_code_block := 'Error';
1319: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');
1320: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1321: RAISE Other_API_Error;
1322: END IF;
1323: /*

Line 1320: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1316: l_return_status);
1317: IF l_return_status <> 'S' THEN
1318: l_code_block := 'Error';
1319: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');
1320: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1321: RAISE Other_API_Error;
1322: END IF;
1323: /*
1324: ** Print the letter and increment the session id

Line 1336: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

1332: g_default_document,
1333: l_language_code,
1334: l_return_status);
1335: IF l_return_status <> 'S' THEN
1336: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
1337: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1338: END IF;
1339: l_return_status := 'S';
1340: END IF;

Line 1337: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1333: l_language_code,
1334: l_return_status);
1335: IF l_return_status <> 'S' THEN
1336: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
1337: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1338: END IF;
1339: l_return_status := 'S';
1340: END IF;
1341: l_code_block := 'Print document in region language';

Line 1389: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');

1385: GlobalOtherAddrRecord.addr_id,
1386: l_return_status);
1387: IF l_return_status <> 'S' THEN
1388: l_code_block := 'Error';
1389: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');
1390: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1391: RAISE Other_API_Error;
1392: END IF;
1393: /*

Line 1390: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1386: l_return_status);
1387: IF l_return_status <> 'S' THEN
1388: l_code_block := 'Error';
1389: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');
1390: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1391: RAISE Other_API_Error;
1392: END IF;
1393: /*
1394: ** Print the letter and increment the session id

Line 1407: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

1403: l_language_code,
1404: l_return_status);
1405:
1406: IF l_return_status <> 'S' THEN
1407: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
1408: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1409: END IF;
1410: l_return_status := 'S';
1411: END IF;

Line 1408: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1404: l_return_status);
1405:
1406: IF l_return_status <> 'S' THEN
1407: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
1408: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1409: END IF;
1410: l_return_status := 'S';
1411: END IF;
1412: l_code_block := 'Print document in default language';

Line 1450: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');

1446: GlobalOtherAddrRecord.addr_id,
1447: l_return_status);
1448: IF l_return_status <> 'S' THEN
1449: l_code_block := 'Error';
1450: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');
1451: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1452: RAISE Other_API_Error;
1453: END IF;
1454: /*

Line 1451: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1447: l_return_status);
1448: IF l_return_status <> 'S' THEN
1449: l_code_block := 'Error';
1450: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');
1451: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1452: RAISE Other_API_Error;
1453: END IF;
1454: /*
1455: ** Print the letter and increment the session id

Line 1468: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

1464: l_language_code,
1465: l_return_status);
1466:
1467: IF l_return_status <> 'S' THEN
1468: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
1469: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1470: END IF;
1471: l_return_status := 'S';
1472: END IF;

Line 1469: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1465: l_return_status);
1466:
1467: IF l_return_status <> 'S' THEN
1468: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
1469: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1470: END IF;
1471: l_return_status := 'S';
1472: END IF;
1473: l_code_block := 'Print document in default language';

Line 1510: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');

1506: GlobalOtherAddrRecord.addr_id,
1507: l_return_status);
1508: IF l_return_status <> 'S' THEN
1509: l_code_block := 'Error';
1510: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');
1511: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1512: RAISE Other_API_Error;
1513: END IF;
1514: /*

Line 1511: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1507: l_return_status);
1508: IF l_return_status <> 'S' THEN
1509: l_code_block := 'Error';
1510: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');
1511: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1512: RAISE Other_API_Error;
1513: END IF;
1514: /*
1515: ** Print the letter and increment the session id

Line 1528: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

1524: l_language_code,
1525: l_return_status);
1526:
1527: IF l_return_status <> 'S' THEN
1528: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
1529: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1530: END IF;
1531: l_return_status := 'S';
1532: END IF;

Line 1529: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1525: l_return_status);
1526:
1527: IF l_return_status <> 'S' THEN
1528: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
1529: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1530: END IF;
1531: l_return_status := 'S';
1532: END IF;
1533: l_code_block := 'Print document in region language';

Line 1621: FND_FILE.PUT(FND_FILE.LOG, LocalLineRecord.message);

1617: OPEN c_get_line_message;
1618: LOOP
1619: FETCH c_get_line_message INTO LocalLineRecord;
1620: EXIT WHEN c_get_line_message%NOTFOUND;
1621: FND_FILE.PUT(FND_FILE.LOG, LocalLineRecord.message);
1622: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
1623: END LOOP;
1624: CLOSE c_get_line_message;
1625:

Line 1622: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

1618: LOOP
1619: FETCH c_get_line_message INTO LocalLineRecord;
1620: EXIT WHEN c_get_line_message%NOTFOUND;
1621: FND_FILE.PUT(FND_FILE.LOG, LocalLineRecord.message);
1622: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
1623: END LOOP;
1624: CLOSE c_get_line_message;
1625:
1626: END IF;

Line 1958: FND_FILE.PUT(FND_FILE.LOG, l_code_block);

1954: UPDATE gr_selection_header
1955: SET status = 7
1956: WHERE batch_no = p_batch_number;
1957:
1958: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
1959: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
1960: /*
1961: ** Now process the details and update dispatch history
1962: */

Line 1959: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

1955: SET status = 7
1956: WHERE batch_no = p_batch_number;
1957:
1958: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
1959: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
1960: /*
1961: ** Now process the details and update dispatch history
1962: */
1963: l_code_block := 'Process the batch details';

Line 1964: FND_FILE.PUT(FND_FILE.LOG, l_code_block);

1960: /*
1961: ** Now process the details and update dispatch history
1962: */
1963: l_code_block := 'Process the batch details';
1964: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
1965: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
1966: OPEN c_get_batch_details;
1967: FETCH c_get_batch_details INTO BatchDetails;
1968: WHILE c_get_batch_details%FOUND LOOP

Line 1965: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

1961: ** Now process the details and update dispatch history
1962: */
1963: l_code_block := 'Process the batch details';
1964: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
1965: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
1966: OPEN c_get_batch_details;
1967: FETCH c_get_batch_details INTO BatchDetails;
1968: WHILE c_get_batch_details%FOUND LOOP
1969: IF BatchDetails.print_flag = 'Y' OR

Line 1974: FND_FILE.PUT(FND_FILE.LOG, l_code_block);

1970: (BatchDetails.print_flag = 'N' AND
1971: BatchDetails.user_override = 'Y') THEN
1972: l_code_block := 'Updating ' || BatchDetails.order_no;
1973: l_code_block := l_code_block || ' ' || BatchDetails.item_code;
1974: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
1975: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
1976: l_commit := 'F';
1977: l_called_by_form := 'F';
1978: l_user_id := FND_GLOBAL.USER_ID;

Line 1975: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

1971: BatchDetails.user_override = 'Y') THEN
1972: l_code_block := 'Updating ' || BatchDetails.order_no;
1973: l_code_block := l_code_block || ' ' || BatchDetails.item_code;
1974: FND_FILE.PUT(FND_FILE.LOG, l_code_block);
1975: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
1976: l_commit := 'F';
1977: l_called_by_form := 'F';
1978: l_user_id := FND_GLOBAL.USER_ID;
1979:

Line 2069: FND_FILE.PUT(FND_FILE.LOG, ' Check Primary Key for Dispatch Histories ' );

2065: l_msds_date := BatchDetails.date_msds_sent;
2066: END IF; /* BatchDetails.date_msds_sent IS NULL */
2067: IF BatchDetails.document_code IS NOT NULL THEN
2068: l_return_status := FND_API.G_RET_STS_SUCCESS;
2069: FND_FILE.PUT(FND_FILE.LOG, ' Check Primary Key for Dispatch Histories ' );
2070: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
2071: /*
2072: ** Bug 2342375 Mercy Thomas 08/15/2002 Added the following code to check for the validity of the item code before Inserting
2073: ** the Dispatch History Table.

Line 2070: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

2066: END IF; /* BatchDetails.date_msds_sent IS NULL */
2067: IF BatchDetails.document_code IS NOT NULL THEN
2068: l_return_status := FND_API.G_RET_STS_SUCCESS;
2069: FND_FILE.PUT(FND_FILE.LOG, ' Check Primary Key for Dispatch Histories ' );
2070: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
2071: /*
2072: ** Bug 2342375 Mercy Thomas 08/15/2002 Added the following code to check for the validity of the item code before Inserting
2073: ** the Dispatch History Table.
2074: */

Line 2187: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);

2183: END IF; /* NOT FND_API.TO_BOOLEAN(l_key_exists) */
2184: END IF; /* l_item_code IS NOT NULL */
2185: ELSE
2186: FND_MESSAGE.SET_NAME('GR', 'GR_NULL_BATCH_NUMBER');
2187: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
2188: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
2189: END IF; /* BatchDetails.document_code IS NOT NULL */
2190: /*
2191: ** Update the line status

Line 2188: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

2184: END IF; /* l_item_code IS NOT NULL */
2185: ELSE
2186: FND_MESSAGE.SET_NAME('GR', 'GR_NULL_BATCH_NUMBER');
2187: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
2188: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
2189: END IF; /* BatchDetails.document_code IS NOT NULL */
2190: /*
2191: ** Update the line status
2192: */

Line 2521: FND_FILE.PUT(FND_FILE.LOG,l_code_block);

2517: FROM dual;
2518:
2519: l_code_block := 'Session id: ' || TO_CHAR(g_session_id);
2520:
2521: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
2522: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2523:
2524: l_return_status := 'S';
2525: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

Line 2522: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2518:
2519: l_code_block := 'Session id: ' || TO_CHAR(g_session_id);
2520:
2521: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
2522: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2523:
2524: l_return_status := 'S';
2525: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session
2526: ('F',

Line 2556: FND_FILE.PUT(FND_FILE.LOG,' PROCESSING ITEM '||LocalItemRec.item_code);

2552: OPEN c_get_item;
2553: FETCH c_get_item INTO LocalItemRec;
2554: IF c_get_item%FOUND THEN
2555: WHILE c_get_item%FOUND LOOP
2556: FND_FILE.PUT(FND_FILE.LOG,' PROCESSING ITEM '||LocalItemRec.item_code);
2557: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2558: g_doc_item_code := LocalItemRec.item_code;
2559: OPEN c_get_item_range;
2560: FETCH c_get_item_range INTO LocalItem;

Line 2557: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2553: FETCH c_get_item INTO LocalItemRec;
2554: IF c_get_item%FOUND THEN
2555: WHILE c_get_item%FOUND LOOP
2556: FND_FILE.PUT(FND_FILE.LOG,' PROCESSING ITEM '||LocalItemRec.item_code);
2557: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2558: g_doc_item_code := LocalItemRec.item_code;
2559: OPEN c_get_item_range;
2560: FETCH c_get_item_range INTO LocalItem;
2561: IF c_get_item_range%NOTFOUND THEN

Line 2562: FND_FILE.PUT(FND_FILE.LOG,' Document ' || g_default_document || ' not defined for item '||LocalItemRec.item_code);

2558: g_doc_item_code := LocalItemRec.item_code;
2559: OPEN c_get_item_range;
2560: FETCH c_get_item_range INTO LocalItem;
2561: IF c_get_item_range%NOTFOUND THEN
2562: FND_FILE.PUT(FND_FILE.LOG,' Document ' || g_default_document || ' not defined for item '||LocalItemRec.item_code);
2563: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2564: ELSE
2565: IF l_changed_after IS NOT NULL AND
2566: LocalItem.last_doc_update_date <= l_changed_after THEN

Line 2563: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2559: OPEN c_get_item_range;
2560: FETCH c_get_item_range INTO LocalItem;
2561: IF c_get_item_range%NOTFOUND THEN
2562: FND_FILE.PUT(FND_FILE.LOG,' Document ' || g_default_document || ' not defined for item '||LocalItemRec.item_code);
2563: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2564: ELSE
2565: IF l_changed_after IS NOT NULL AND
2566: LocalItem.last_doc_update_date <= l_changed_after THEN
2567: l_code_block := 'Do not print';

Line 2570: FND_FILE.PUT(FND_FILE.LOG,l_code_block);

2566: LocalItem.last_doc_update_date <= l_changed_after THEN
2567: l_code_block := 'Do not print';
2568: ELSE
2569: l_code_block := 'Print this recipient ' || LocalRecipient.recipient_code;
2570: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
2571: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2572: /*
2573: ** Print using the default language if the region code is null.
2574: */

Line 2571: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2567: l_code_block := 'Do not print';
2568: ELSE
2569: l_code_block := 'Print this recipient ' || LocalRecipient.recipient_code;
2570: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
2571: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2572: /*
2573: ** Print using the default language if the region code is null.
2574: */
2575: IF LocalRecipient.region_code IS NULL THEN

Line 2581: FND_FILE.PUT(FND_FILE.LOG,l_code_block);

2577: IF LocalRecipient.shipping_address = '1' OR
2578: LocalRecipient.invoice_address = '1' THEN
2579:
2580: l_code_block := 'Print the shipping or invoice address';
2581: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
2582: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2583:
2584: OPEN c_get_cust_address;
2585: FETCH c_get_cust_address INTO LocalCustRecord;

Line 2582: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2578: LocalRecipient.invoice_address = '1' THEN
2579:
2580: l_code_block := 'Print the shipping or invoice address';
2581: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
2582: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2583:
2584: OPEN c_get_cust_address;
2585: FETCH c_get_cust_address INTO LocalCustRecord;
2586: IF c_get_cust_address%FOUND THEN

Line 2613: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');

2609: LocalCustRecord.addr_id,
2610: l_return_status);
2611:
2612: IF l_return_status <> 'S' THEN
2613: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');
2614: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2615:
2616: RAISE Other_API_Error;
2617: END IF;

Line 2614: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2610: l_return_status);
2611:
2612: IF l_return_status <> 'S' THEN
2613: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 1');
2614: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2615:
2616: RAISE Other_API_Error;
2617: END IF;
2618: /*

Line 2632: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

2628: l_language_code,
2629: l_return_status);
2630:
2631: IF l_return_status <> 'S' THEN
2632: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
2633: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2634: END IF;
2635:
2636: /* Fix for B1270176 */

Line 2633: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2629: l_return_status);
2630:
2631: IF l_return_status <> 'S' THEN
2632: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
2633: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2634: END IF;
2635:
2636: /* Fix for B1270176 */
2637: l_return_status := 'S';

Line 2657: FND_FILE.PUT(FND_FILE.LOG,'Document print error - A');

2653: LocalRecipient.language,
2654: LocalRecipient.disclosure_code,
2655: l_return_status);
2656: IF l_return_status <> 'S' THEN
2657: FND_FILE.PUT(FND_FILE.LOG,'Document print error - A');
2658: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2659:
2660: RAISE Other_API_Error;
2661: ELSE

Line 2658: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2654: LocalRecipient.disclosure_code,
2655: l_return_status);
2656: IF l_return_status <> 'S' THEN
2657: FND_FILE.PUT(FND_FILE.LOG,'Document print error - A');
2658: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2659:
2660: RAISE Other_API_Error;
2661: ELSE
2662: l_print_count := l_print_count + 1;

Line 2678: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

2674: l_language_code,
2675: l_return_status);
2676:
2677: IF l_return_status <> 'S' THEN
2678: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
2679: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2680: END IF;
2681: /*
2682: ** Process inventory items if print all

Line 2679: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2675: l_return_status);
2676:
2677: IF l_return_status <> 'S' THEN
2678: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
2679: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2680: END IF;
2681: /*
2682: ** Process inventory items if print all
2683: */

Line 2712: FND_FILE.PUT(FND_FILE.LOG,'Document print error - B');

2708: LocalRecipient.language,
2709: LocalRecipient.disclosure_code,
2710: l_return_status);
2711: IF l_return_status <> 'S' THEN
2712: FND_FILE.PUT(FND_FILE.LOG,'Document print error - B');
2713: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2714:
2715: RAISE Other_API_Error;
2716: ELSE

Line 2713: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2709: LocalRecipient.disclosure_code,
2710: l_return_status);
2711: IF l_return_status <> 'S' THEN
2712: FND_FILE.PUT(FND_FILE.LOG,'Document print error - B');
2713: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2714:
2715: RAISE Other_API_Error;
2716: ELSE
2717: l_print_count := l_print_count + 1;

Line 2733: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

2729: l_language_code,
2730: l_return_status);
2731:
2732: IF l_return_status <> 'S' THEN
2733: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
2734: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2735: END IF;
2736: FETCH c_get_master_list INTO LocalInventList;
2737: END LOOP;

Line 2734: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2730: l_return_status);
2731:
2732: IF l_return_status <> 'S' THEN
2733: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
2734: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2735: END IF;
2736: FETCH c_get_master_list INTO LocalInventList;
2737: END LOOP;
2738: END IF;

Line 2753: FND_FILE.PUT(FND_FILE.LOG,l_code_block);

2749: IF g_get_other_addresses%FOUND THEN
2750: WHILE g_get_other_addresses%FOUND LOOP
2751:
2752: l_code_block := 'Other Addresses ';
2753: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
2754: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2755:
2756: /* Fix for B1270176 */
2757: l_return_status := 'S';

Line 2754: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2750: WHILE g_get_other_addresses%FOUND LOOP
2751:
2752: l_code_block := 'Other Addresses ';
2753: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
2754: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2755:
2756: /* Fix for B1270176 */
2757: l_return_status := 'S';
2758: GR_PROCESS_DOCUMENTS.Clear_Worksheet_Session

Line 2778: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 2');

2774: '',
2775: GlobalOtherAddrRecord.addr_id,
2776: l_return_status);
2777: IF l_return_status <> 'S' THEN
2778: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 2');
2779: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2780:
2781: RAISE Other_API_Error;
2782: END IF;

Line 2779: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2775: GlobalOtherAddrRecord.addr_id,
2776: l_return_status);
2777: IF l_return_status <> 'S' THEN
2778: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 2');
2779: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2780:
2781: RAISE Other_API_Error;
2782: END IF;
2783: /*

Line 2797: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

2793: l_language_code,
2794: l_return_status);
2795:
2796: IF l_return_status <> 'S' THEN
2797: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
2798: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2799: END IF;
2800:
2801: /* Fix for B1270176*/

Line 2798: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2794: l_return_status);
2795:
2796: IF l_return_status <> 'S' THEN
2797: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
2798: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2799: END IF;
2800:
2801: /* Fix for B1270176*/
2802: l_return_status := 'S';

Line 2822: FND_FILE.PUT(FND_FILE.LOG,'Document print error - C');

2818: LocalRecipient.language,
2819: LocalRecipient.disclosure_code,
2820: l_return_status);
2821: IF l_return_status <> 'S' THEN
2822: FND_FILE.PUT(FND_FILE.LOG,'Document print error - C');
2823: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2824:
2825: RAISE Other_API_Error;
2826: ELSE

Line 2823: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2819: LocalRecipient.disclosure_code,
2820: l_return_status);
2821: IF l_return_status <> 'S' THEN
2822: FND_FILE.PUT(FND_FILE.LOG,'Document print error - C');
2823: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2824:
2825: RAISE Other_API_Error;
2826: ELSE
2827: l_print_count := l_print_count + 1;

Line 2843: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

2839: l_language_code,
2840: l_return_status);
2841:
2842: IF l_return_status <> 'S' THEN
2843: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
2844: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2845: END IF;
2846: /*
2847: ** Process inventory items if print all

Line 2844: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2840: l_return_status);
2841:
2842: IF l_return_status <> 'S' THEN
2843: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
2844: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2845: END IF;
2846: /*
2847: ** Process inventory items if print all
2848: */

Line 2876: FND_FILE.PUT(FND_FILE.LOG,'Document print error - D');

2872: LocalRecipient.language,
2873: LocalRecipient.disclosure_code,
2874: l_return_status);
2875: IF l_return_status <> 'S' THEN
2876: FND_FILE.PUT(FND_FILE.LOG,'Document print error - D');
2877: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2878:
2879: RAISE Other_API_Error;
2880: ELSE

Line 2877: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2873: LocalRecipient.disclosure_code,
2874: l_return_status);
2875: IF l_return_status <> 'S' THEN
2876: FND_FILE.PUT(FND_FILE.LOG,'Document print error - D');
2877: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2878:
2879: RAISE Other_API_Error;
2880: ELSE
2881: l_print_count := l_print_count + 1;

Line 2897: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

2893: l_language_code,
2894: l_return_status);
2895:
2896: IF l_return_status <> 'S' THEN
2897: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
2898: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2899: END IF;
2900: FETCH c_get_master_list INTO LocalInventList;
2901: END LOOP;

Line 2898: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2894: l_return_status);
2895:
2896: IF l_return_status <> 'S' THEN
2897: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
2898: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2899: END IF;
2900: FETCH c_get_master_list INTO LocalInventList;
2901: END LOOP;
2902: END IF;

Line 2916: FND_FILE.PUT(FND_FILE.LOG,l_code_block);

2912: /*
2913: ** Print using the languages for the region
2914: */
2915: l_code_block := 'Print for regions';
2916: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
2917: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2918:
2919: OPEN c_get_region_language;
2920: FETCH c_get_region_language INTO LocalRgnLangRecord;

Line 2917: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2913: ** Print using the languages for the region
2914: */
2915: l_code_block := 'Print for regions';
2916: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
2917: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2918:
2919: OPEN c_get_region_language;
2920: FETCH c_get_region_language INTO LocalRgnLangRecord;
2921: IF c_get_region_language%FOUND THEN

Line 2953: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 3');

2949: '',
2950: LocalCustRecord.addr_id,
2951: l_return_status);
2952: IF l_return_status <> 'S' THEN
2953: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 3');
2954: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2955:
2956: RAISE Other_API_Error;
2957: END IF;

Line 2954: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2950: LocalCustRecord.addr_id,
2951: l_return_status);
2952: IF l_return_status <> 'S' THEN
2953: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 3');
2954: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2955:
2956: RAISE Other_API_Error;
2957: END IF;
2958: /*

Line 2972: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

2968: l_language_code,
2969: l_return_status);
2970:
2971: IF l_return_status <> 'S' THEN
2972: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
2973: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2974: END IF;
2975:
2976: /* Fix for B1270176 */

Line 2973: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2969: l_return_status);
2970:
2971: IF l_return_status <> 'S' THEN
2972: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
2973: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2974: END IF;
2975:
2976: /* Fix for B1270176 */
2977: l_return_status := 'S';

Line 2996: FND_FILE.PUT(FND_FILE.LOG,'Document print error - E');

2992: l_language_code,
2993: LocalRecipient.disclosure_code,
2994: l_return_status);
2995: IF l_return_status <> 'S' THEN
2996: FND_FILE.PUT(FND_FILE.LOG,'Document print error - E');
2997: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2998:
2999: RAISE Other_API_Error;
3000: ELSE

Line 2997: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2993: LocalRecipient.disclosure_code,
2994: l_return_status);
2995: IF l_return_status <> 'S' THEN
2996: FND_FILE.PUT(FND_FILE.LOG,'Document print error - E');
2997: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2998:
2999: RAISE Other_API_Error;
3000: ELSE
3001: l_print_count := l_print_count + 1;

Line 3017: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

3013: l_language_code,
3014: l_return_status);
3015:
3016: IF l_return_status <> 'S' THEN
3017: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3018: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3019: END IF;
3020: /*
3021: ** Process inventory items if print all

Line 3018: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3014: l_return_status);
3015:
3016: IF l_return_status <> 'S' THEN
3017: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3018: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3019: END IF;
3020: /*
3021: ** Process inventory items if print all
3022: */

Line 3051: FND_FILE.PUT(FND_FILE.LOG,'Document print error - F');

3047: LocalRecipient.language,
3048: LocalRecipient.disclosure_code,
3049: l_return_status);
3050: IF l_return_status <> 'S' THEN
3051: FND_FILE.PUT(FND_FILE.LOG,'Document print error - F');
3052: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3053:
3054: RAISE Other_API_Error;
3055: ELSE

Line 3052: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3048: LocalRecipient.disclosure_code,
3049: l_return_status);
3050: IF l_return_status <> 'S' THEN
3051: FND_FILE.PUT(FND_FILE.LOG,'Document print error - F');
3052: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3053:
3054: RAISE Other_API_Error;
3055: ELSE
3056: l_print_count := l_print_count + 1;

Line 3072: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

3068: l_language_code,
3069: l_return_status);
3070:
3071: IF l_return_status <> 'S' THEN
3072: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3073: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3074: END IF;
3075: FETCH c_get_master_list INTO LocalInventList;
3076: END LOOP;

Line 3073: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3069: l_return_status);
3070:
3071: IF l_return_status <> 'S' THEN
3072: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3073: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3074: END IF;
3075: FETCH c_get_master_list INTO LocalInventList;
3076: END LOOP;
3077: END IF;

Line 3114: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 4');

3110: '',
3111: GlobalOtherAddrRecord.addr_id,
3112: l_return_status);
3113: IF l_return_status <> 'S' THEN
3114: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 4');
3115: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3116:
3117: RAISE Other_API_Error;
3118: END IF;

Line 3115: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3111: GlobalOtherAddrRecord.addr_id,
3112: l_return_status);
3113: IF l_return_status <> 'S' THEN
3114: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error - 4');
3115: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3116:
3117: RAISE Other_API_Error;
3118: END IF;
3119: /*

Line 3133: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

3129: l_language_code,
3130: l_return_status);
3131:
3132: IF l_return_status <> 'S' THEN
3133: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3134: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3135: END IF;
3136:
3137: /* Fix for B1270176 */

Line 3134: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3130: l_return_status);
3131:
3132: IF l_return_status <> 'S' THEN
3133: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3134: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3135: END IF;
3136:
3137: /* Fix for B1270176 */
3138: l_return_status := 'S';

Line 3158: FND_FILE.PUT(FND_FILE.LOG,'Document print error - G');

3154: l_language_code,
3155: LocalRecipient.disclosure_code,
3156: l_return_status);
3157: IF l_return_status <> 'S' THEN
3158: FND_FILE.PUT(FND_FILE.LOG,'Document print error - G');
3159: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3160:
3161: RAISE Other_API_Error;
3162: ELSE

Line 3159: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3155: LocalRecipient.disclosure_code,
3156: l_return_status);
3157: IF l_return_status <> 'S' THEN
3158: FND_FILE.PUT(FND_FILE.LOG,'Document print error - G');
3159: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3160:
3161: RAISE Other_API_Error;
3162: ELSE
3163: l_print_count := l_print_count + 1;

Line 3179: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

3175: l_language_code,
3176: l_return_status);
3177:
3178: IF l_return_status <> 'S' THEN
3179: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3180: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3181: END IF;
3182: /*
3183: ** Process inventory items if print all

Line 3180: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3176: l_return_status);
3177:
3178: IF l_return_status <> 'S' THEN
3179: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3180: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3181: END IF;
3182: /*
3183: ** Process inventory items if print all
3184: */

Line 3213: FND_FILE.PUT(FND_FILE.LOG,'Document print error - H');

3209: LocalRecipient.language,
3210: LocalRecipient.disclosure_code,
3211: l_return_status);
3212: IF l_return_status <> 'S' THEN
3213: FND_FILE.PUT(FND_FILE.LOG,'Document print error - H');
3214: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3215:
3216: RAISE Other_API_Error;
3217: ELSE

Line 3214: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3210: LocalRecipient.disclosure_code,
3211: l_return_status);
3212: IF l_return_status <> 'S' THEN
3213: FND_FILE.PUT(FND_FILE.LOG,'Document print error - H');
3214: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3215:
3216: RAISE Other_API_Error;
3217: ELSE
3218: l_print_count := l_print_count + 1;

Line 3234: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

3230: l_language_code,
3231: l_return_status);
3232:
3233: IF l_return_status <> 'S' THEN
3234: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3235: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3236: END IF;
3237: FETCH c_get_master_list INTO LocalInventList;
3238: END LOOP;

Line 3235: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3231: l_return_status);
3232:
3233: IF l_return_status <> 'S' THEN
3234: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3235: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3236: END IF;
3237: FETCH c_get_master_list INTO LocalInventList;
3238: END LOOP;
3239: END IF;

Line 3272: FND_FILE.PUT(FND_FILE.LOG,l_code_block);

3268: (p_items_to_print = 'S' AND
3269: l_print_count = 0) THEN
3270:
3271: l_code_block := 'Process generic items';
3272: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
3273: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3274:
3275: OPEN c_get_invent_items;
3276: FETCH c_get_invent_items INTO LocalInventList;

Line 3273: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3269: l_print_count = 0) THEN
3270:
3271: l_code_block := 'Process generic items';
3272: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
3273: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3274:
3275: OPEN c_get_invent_items;
3276: FETCH c_get_invent_items INTO LocalInventList;
3277: IF c_get_invent_items%FOUND THEN

Line 3311: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error');

3307: '',
3308: LocalCustRecord.addr_id,
3309: l_return_status);
3310: IF l_return_status <> 'S' THEN
3311: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error');
3312: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3313:
3314: RAISE Other_API_Error;
3315: END IF;

Line 3312: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3308: LocalCustRecord.addr_id,
3309: l_return_status);
3310: IF l_return_status <> 'S' THEN
3311: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error');
3312: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3313:
3314: RAISE Other_API_Error;
3315: END IF;
3316: /*

Line 3330: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

3326: l_language_code,
3327: l_return_status);
3328:
3329: IF l_return_status <> 'S' THEN
3330: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3331: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3332: END IF;
3333:
3334: /* Fix for B1270176 */

Line 3331: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3327: l_return_status);
3328:
3329: IF l_return_status <> 'S' THEN
3330: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3331: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3332: END IF;
3333:
3334: /* Fix for B1270176 */
3335: l_return_status := 'S';

Line 3355: FND_FILE.PUT(FND_FILE.LOG,'Document print error - I');

3351: l_language_code,
3352: LocalRecipient.disclosure_code,
3353: l_return_status);
3354: IF l_return_status <> 'S' THEN
3355: FND_FILE.PUT(FND_FILE.LOG,'Document print error - I');
3356: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3357:
3358: RAISE Other_API_Error;
3359: END IF;

Line 3356: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3352: LocalRecipient.disclosure_code,
3353: l_return_status);
3354: IF l_return_status <> 'S' THEN
3355: FND_FILE.PUT(FND_FILE.LOG,'Document print error - I');
3356: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3357:
3358: RAISE Other_API_Error;
3359: END IF;
3360: /*

Line 3374: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

3370: l_language_code,
3371: l_return_status);
3372:
3373: IF l_return_status <> 'S' THEN
3374: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3375: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3376: END IF;
3377: ELSE
3378: FND_FILE.PUT(FND_FILE.LOG,'No inv/ship address for ' || LocalRecipient.recipient_code);

Line 3375: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3371: l_return_status);
3372:
3373: IF l_return_status <> 'S' THEN
3374: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3375: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3376: END IF;
3377: ELSE
3378: FND_FILE.PUT(FND_FILE.LOG,'No inv/ship address for ' || LocalRecipient.recipient_code);
3379: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

Line 3378: FND_FILE.PUT(FND_FILE.LOG,'No inv/ship address for ' || LocalRecipient.recipient_code);

3374: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3375: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3376: END IF;
3377: ELSE
3378: FND_FILE.PUT(FND_FILE.LOG,'No inv/ship address for ' || LocalRecipient.recipient_code);
3379: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3380: END IF;
3381: CLOSE c_get_cust_address;
3382: END IF;

Line 3379: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3375: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3376: END IF;
3377: ELSE
3378: FND_FILE.PUT(FND_FILE.LOG,'No inv/ship address for ' || LocalRecipient.recipient_code);
3379: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3380: END IF;
3381: CLOSE c_get_cust_address;
3382: END IF;
3383: /*

Line 3415: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error');

3411: '',
3412: LocalCustRecord.addr_id,
3413: l_return_status);
3414: IF l_return_status <> 'S' THEN
3415: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error');
3416: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3417:
3418: RAISE Other_API_Error;
3419: END IF;

Line 3416: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3412: LocalCustRecord.addr_id,
3413: l_return_status);
3414: IF l_return_status <> 'S' THEN
3415: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error');
3416: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3417:
3418: RAISE Other_API_Error;
3419: END IF;
3420: /*

Line 3434: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

3430: l_language_code,
3431: l_return_status);
3432:
3433: IF l_return_status <> 'S' THEN
3434: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3435: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3436: END IF;
3437:
3438: /* Fix for B1270176 */

Line 3435: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3431: l_return_status);
3432:
3433: IF l_return_status <> 'S' THEN
3434: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3435: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3436: END IF;
3437:
3438: /* Fix for B1270176 */
3439: l_return_status := 'S';

Line 3459: FND_FILE.PUT(FND_FILE.LOG,'Document print error - J');

3455: l_language_code,
3456: LocalRecipient.disclosure_code,
3457: l_return_status);
3458: IF l_return_status <> 'S' THEN
3459: FND_FILE.PUT(FND_FILE.LOG,'Document print error - J');
3460: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3461:
3462: RAISE Other_API_Error;
3463: END IF;

Line 3460: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3456: LocalRecipient.disclosure_code,
3457: l_return_status);
3458: IF l_return_status <> 'S' THEN
3459: FND_FILE.PUT(FND_FILE.LOG,'Document print error - J');
3460: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3461:
3462: RAISE Other_API_Error;
3463: END IF;
3464: /*

Line 3478: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

3474: l_language_code,
3475: l_return_status);
3476:
3477: IF l_return_status <> 'S' THEN
3478: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3479: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3480: END IF;
3481: FETCH g_get_other_addresses INTO GlobalOtherAddrRecord;
3482: END LOOP;

Line 3479: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3475: l_return_status);
3476:
3477: IF l_return_status <> 'S' THEN
3478: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3479: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3480: END IF;
3481: FETCH g_get_other_addresses INTO GlobalOtherAddrRecord;
3482: END LOOP;
3483: END IF;

Line 3524: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error');

3520: '',
3521: LocalCustRecord.addr_id,
3522: l_return_status);
3523: IF l_return_status <> 'S' THEN
3524: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error');
3525: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3526:
3527: RAISE Other_API_Error;
3528: END IF;

Line 3525: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3521: LocalCustRecord.addr_id,
3522: l_return_status);
3523: IF l_return_status <> 'S' THEN
3524: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error');
3525: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3526:
3527: RAISE Other_API_Error;
3528: END IF;
3529: /*

Line 3543: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

3539: l_language_code,
3540: l_return_status);
3541:
3542: IF l_return_status <> 'S' THEN
3543: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3544: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3545: END IF;
3546:
3547: /* Fix for B1270176 */

Line 3544: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3540: l_return_status);
3541:
3542: IF l_return_status <> 'S' THEN
3543: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3544: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3545: END IF;
3546:
3547: /* Fix for B1270176 */
3548: l_return_status := 'S';

Line 3584: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

3580: l_language_code,
3581: l_return_status);
3582:
3583: IF l_return_status <> 'S' THEN
3584: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3585: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3586: END IF;
3587: ELSE
3588: FND_FILE.PUT(FND_FILE.LOG,'No inv/ship address for ' || LocalRecipient.recipient_code);

Line 3585: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3581: l_return_status);
3582:
3583: IF l_return_status <> 'S' THEN
3584: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3585: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3586: END IF;
3587: ELSE
3588: FND_FILE.PUT(FND_FILE.LOG,'No inv/ship address for ' || LocalRecipient.recipient_code);
3589: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

Line 3588: FND_FILE.PUT(FND_FILE.LOG,'No inv/ship address for ' || LocalRecipient.recipient_code);

3584: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3585: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3586: END IF;
3587: ELSE
3588: FND_FILE.PUT(FND_FILE.LOG,'No inv/ship address for ' || LocalRecipient.recipient_code);
3589: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3590: END IF;
3591: CLOSE c_get_cust_address;
3592: END IF;

Line 3589: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3585: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3586: END IF;
3587: ELSE
3588: FND_FILE.PUT(FND_FILE.LOG,'No inv/ship address for ' || LocalRecipient.recipient_code);
3589: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3590: END IF;
3591: CLOSE c_get_cust_address;
3592: END IF;
3593: /*

Line 3625: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error');

3621: '',
3622: LocalCustRecord.addr_id,
3623: l_return_status);
3624: IF l_return_status <> 'S' THEN
3625: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error');
3626: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3627:
3628: RAISE Other_API_Error;
3629: END IF;

Line 3626: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3622: LocalCustRecord.addr_id,
3623: l_return_status);
3624: IF l_return_status <> 'S' THEN
3625: FND_FILE.PUT(FND_FILE.LOG,'Cover Letter error');
3626: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3627:
3628: RAISE Other_API_Error;
3629: END IF;
3630: /*

Line 3644: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

3640: l_language_code,
3641: l_return_status);
3642:
3643: IF l_return_status <> 'S' THEN
3644: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3645: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3646: END IF;
3647:
3648: /* Fix for B1270176 */

Line 3645: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3641: l_return_status);
3642:
3643: IF l_return_status <> 'S' THEN
3644: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3645: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3646: END IF;
3647:
3648: /* Fix for B1270176 */
3649: l_return_status := 'S';

Line 3686: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));

3682: l_language_code,
3683: l_return_status);
3684:
3685: IF l_return_status <> 'S' THEN
3686: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3687: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3688: END IF;
3689: FETCH g_get_other_addresses INTO GlobalOtherAddrRecord;
3690: END LOOP;

Line 3687: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3683: l_return_status);
3684:
3685: IF l_return_status <> 'S' THEN
3686: FND_FILE.PUT(FND_FILE.LOG,'Submission error for session ' || TO_CHAR(g_session_id));
3687: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3688: END IF;
3689: FETCH g_get_other_addresses INTO GlobalOtherAddrRecord;
3690: END LOOP;
3691: END IF;

Line 3745: FND_FILE.PUT(FND_FILE.LOG,'Unhandled Exception : ' || sqlerrm);

3741: x_msg_data,
3742: x_return_status);
3743:
3744: WHEN OTHERS THEN
3745: FND_FILE.PUT(FND_FILE.LOG,'Unhandled Exception : ' || sqlerrm);
3746: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3747: l_oracle_error := SQLCODE;
3748: /*l_code_block := SUBSTR(SQLERRM, 1, 200);*/
3749: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);

Line 3746: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3742: x_return_status);
3743:
3744: WHEN OTHERS THEN
3745: FND_FILE.PUT(FND_FILE.LOG,'Unhandled Exception : ' || sqlerrm);
3746: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3747: l_oracle_error := SQLCODE;
3748: /*l_code_block := SUBSTR(SQLERRM, 1, 200);*/
3749: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
3750: FND_MESSAGE.SET_NAME('GR',

Line 3875: FND_FILE.PUT(FND_FILE.LOG,' *** Duplicate order line record exists ***');

3871: l_selection_message,
3872: 'N',
3873: '');
3874: ELSE
3875: FND_FILE.PUT(FND_FILE.LOG,' *** Duplicate order line record exists ***');
3876: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3877: END IF;
3878:
3879: EXCEPTION

Line 3876: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3872: 'N',
3873: '');
3874: ELSE
3875: FND_FILE.PUT(FND_FILE.LOG,' *** Duplicate order line record exists ***');
3876: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3877: END IF;
3878:
3879: EXCEPTION
3880:

Line 3882: FND_FILE.PUT(FND_FILE.LOG,' Selection Insert Error:'||sqlerrm);

3878:
3879: EXCEPTION
3880:
3881: WHEN OTHERS THEN
3882: FND_FILE.PUT(FND_FILE.LOG,' Selection Insert Error:'||sqlerrm);
3883: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3884: x_return_status := FND_API.G_RET_STS_ERROR;
3885:
3886: END Insert_Selection_Row;

Line 3883: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3879: EXCEPTION
3880:
3881: WHEN OTHERS THEN
3882: FND_FILE.PUT(FND_FILE.LOG,' Selection Insert Error:'||sqlerrm);
3883: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3884: x_return_status := FND_API.G_RET_STS_ERROR;
3885:
3886: END Insert_Selection_Row;
3887: /*

Line 3973: FND_FILE.PUT(FND_FILE.LOG,'Order:'||g_order_number||'Line:'||g_order_line||' Recip:'||g_recipient_code||'Batch:'||g_batch_number||'Item:'||g_item_code);

3969: BEGIN
3970: --pg_fp := utl_file.fopen('/sqlcom/log/opm115m','check.log','w');
3971: x_return_status := FND_API.G_RET_STS_SUCCESS;
3972: l_print_flag := 'YS';
3973: FND_FILE.PUT(FND_FILE.LOG,'Order:'||g_order_number||'Line:'||g_order_line||' Recip:'||g_recipient_code||'Batch:'||g_batch_number||'Item:'||g_item_code);
3974: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3975: --utl_file.put_line(pg_fp, 'docco '||g_default_document);
3976: OPEN c_check_selections;
3977: FETCH c_check_selections INTO LocalSelection;

Line 3974: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3970: --pg_fp := utl_file.fopen('/sqlcom/log/opm115m','check.log','w');
3971: x_return_status := FND_API.G_RET_STS_SUCCESS;
3972: l_print_flag := 'YS';
3973: FND_FILE.PUT(FND_FILE.LOG,'Order:'||g_order_number||'Line:'||g_order_line||' Recip:'||g_recipient_code||'Batch:'||g_batch_number||'Item:'||g_item_code);
3974: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3975: --utl_file.put_line(pg_fp, 'docco '||g_default_document);
3976: OPEN c_check_selections;
3977: FETCH c_check_selections INTO LocalSelection;
3978: IF c_check_selections%FOUND THEN

Line 3981: FND_FILE.PUT(FND_FILE.LOG,l_code_block);

3977: FETCH c_check_selections INTO LocalSelection;
3978: IF c_check_selections%FOUND THEN
3979: CLOSE c_check_selections;
3980: l_code_block := ' Order line already selected in print job ';
3981: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
3982: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3983: --utl_file.put_line(pg_fp, 'cblock' ||l_code_block);
3984: l_return_status := FND_API.G_RET_STS_SUCCESS;
3985: Insert_Selection_Row

Line 3982: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3978: IF c_check_selections%FOUND THEN
3979: CLOSE c_check_selections;
3980: l_code_block := ' Order line already selected in print job ';
3981: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
3982: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3983: --utl_file.put_line(pg_fp, 'cblock' ||l_code_block);
3984: l_return_status := FND_API.G_RET_STS_SUCCESS;
3985: Insert_Selection_Row
3986: ('GR_ORDER_ALREADY_SELECTED',

Line 4014: FND_FILE.PUT(FND_FILE.LOG,l_code_block);

4010: FETCH g_get_generic_item INTO GlobalGenericRecord;
4011: IF g_get_generic_item%NOTFOUND THEN
4012: CLOSE g_get_generic_item;
4013: l_code_block := ' No safety information for this item';
4014: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
4015: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4016: --utl_file.put_line(pg_fp, 'cblock2' ||l_code_block);
4017: l_return_status := FND_API.G_RET_STS_SUCCESS;
4018: l_print_flag := 'NO';

Line 4015: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4011: IF g_get_generic_item%NOTFOUND THEN
4012: CLOSE g_get_generic_item;
4013: l_code_block := ' No safety information for this item';
4014: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
4015: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4016: --utl_file.put_line(pg_fp, 'cblock2' ||l_code_block);
4017: l_return_status := FND_API.G_RET_STS_SUCCESS;
4018: l_print_flag := 'NO';
4019: Insert_Selection_Row

Line 4045: FND_FILE.PUT(FND_FILE.LOG,l_code_block);

4041: ** is found.
4042: */
4043: IF l_print_flag = 'YS' THEN
4044: l_code_block := ' Check the dispatch history etc.';
4045: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
4046: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4047: --utl_file.put_line(pg_fp, 'cblock3' ||l_code_block);
4048: /*
4049: ** Get the recipient information. If not there then assume we

Line 4046: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4042: */
4043: IF l_print_flag = 'YS' THEN
4044: l_code_block := ' Check the dispatch history etc.';
4045: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
4046: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4047: --utl_file.put_line(pg_fp, 'cblock3' ||l_code_block);
4048: /*
4049: ** Get the recipient information. If not there then assume we
4050: ** have to generate a document and build the recipient info during

Line 4201: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);

4197: ELSE /* added for 2286375 rework*/
4198: --utl_file.put_line(pg_fp, 'else ');
4199: FND_MESSAGE.SET_NAME('GR', 'GR_ORDER_ALREADY_SELECTED');
4200: FND_MESSAGE.SET_TOKEN('CODE', '');
4201: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
4202: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
4203: END IF;
4204: ELSIF GlobalRecipient.document_print_frequency = 'S' THEN
4205: --utl_file.put_line(pg_fp, 'S');

Line 4202: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

4198: --utl_file.put_line(pg_fp, 'else ');
4199: FND_MESSAGE.SET_NAME('GR', 'GR_ORDER_ALREADY_SELECTED');
4200: FND_MESSAGE.SET_TOKEN('CODE', '');
4201: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
4202: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
4203: END IF;
4204: ELSIF GlobalRecipient.document_print_frequency = 'S' THEN
4205: --utl_file.put_line(pg_fp, 'S');
4206: IF ABS(MONTHS_BETWEEN (l_current_date,

Line 4226: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);

4222: END IF;
4223: ELSE /* added for 2286375 rework*/
4224: FND_MESSAGE.SET_NAME('GR', 'GR_ORDER_ALREADY_SELECTED');
4225: FND_MESSAGE.SET_TOKEN('CODE', '');
4226: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
4227: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
4228: END IF;
4229: ELSIF GlobalRecipient.document_print_frequency = 'Y' THEN
4230: --utl_file.put_line(pg_fp, 'Y');

Line 4227: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

4223: ELSE /* added for 2286375 rework*/
4224: FND_MESSAGE.SET_NAME('GR', 'GR_ORDER_ALREADY_SELECTED');
4225: FND_MESSAGE.SET_TOKEN('CODE', '');
4226: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
4227: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
4228: END IF;
4229: ELSIF GlobalRecipient.document_print_frequency = 'Y' THEN
4230: --utl_file.put_line(pg_fp, 'Y');
4231: IF ABS(MONTHS_BETWEEN (l_current_date,

Line 4251: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);

4247: END IF;
4248: ELSE /* added for 2286375 rework*/
4249: FND_MESSAGE.SET_NAME('GR', 'GR_ORDER_ALREADY_SELECTED');
4250: FND_MESSAGE.SET_TOKEN('CODE', '');
4251: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
4252: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
4253: END IF;
4254: /* GK B1253943 - added in code for testing print freq for different time periods*/
4255: /*ELSIF GlobalRecipient.document_print_frequency = 'R' THEN

Line 4252: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

4248: ELSE /* added for 2286375 rework*/
4249: FND_MESSAGE.SET_NAME('GR', 'GR_ORDER_ALREADY_SELECTED');
4250: FND_MESSAGE.SET_TOKEN('CODE', '');
4251: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
4252: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
4253: END IF;
4254: /* GK B1253943 - added in code for testing print freq for different time periods*/
4255: /*ELSIF GlobalRecipient.document_print_frequency = 'R' THEN
4256: l_time_period := GlobalRecipient.time_period;

Line 4276: FND_FILE.PUT(FND_FILE.LOG,' No document required');

4272: RAISE Selection_Insert_Error;
4273: END IF;
4274: END IF;*/
4275: ELSE
4276: FND_FILE.PUT(FND_FILE.LOG,' No document required');
4277: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4278: --utl_file.put_line(pg_fp, 'no doc');
4279: l_return_status := FND_API.G_RET_STS_SUCCESS;
4280: Insert_Selection_Row

Line 4277: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4273: END IF;
4274: END IF;*/
4275: ELSE
4276: FND_FILE.PUT(FND_FILE.LOG,' No document required');
4277: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4278: --utl_file.put_line(pg_fp, 'no doc');
4279: l_return_status := FND_API.G_RET_STS_SUCCESS;
4280: Insert_Selection_Row
4281: ('GR_NO_DOCUMENT_REQUIRED',

Line 4538: FND_FILE.PUT(FND_FILE.LOG, 'Processing Build_Item_Document for: ' || p_item_code || ' ' || TO_CHAR(g_session_id));

4534: /*
4535: ** Check and get the text id of the document.
4536: ** Build item document builds the document if required
4537: */
4538: FND_FILE.PUT(FND_FILE.LOG, 'Processing Build_Item_Document for: ' || p_item_code || ' ' || TO_CHAR(g_session_id));
4539: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4540:
4541: GR_PROCESS_DOCUMENTS.Build_Item_Document
4542: (l_commit,

Line 4539: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4535: ** Check and get the text id of the document.
4536: ** Build item document builds the document if required
4537: */
4538: FND_FILE.PUT(FND_FILE.LOG, 'Processing Build_Item_Document for: ' || p_item_code || ' ' || TO_CHAR(g_session_id));
4539: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4540:
4541: GR_PROCESS_DOCUMENTS.Build_Item_Document
4542: (l_commit,
4543: l_init_msg_list,

Line 4558: FND_FILE.PUT(FND_FILE.LOG,l_code_block);

4554: l_msg_data);
4555:
4556: IF l_document_text_id IS NULL THEN
4557: l_code_block := 'No document id for ' || p_document_code;
4558: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
4559: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4560: END IF;
4561:
4562: IF l_return_status <> 'S' THEN

Line 4559: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4555:
4556: IF l_document_text_id IS NULL THEN
4557: l_code_block := 'No document id for ' || p_document_code;
4558: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
4559: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4560: END IF;
4561:
4562: IF l_return_status <> 'S' THEN
4563: RAISE Build_Document_Error;

Line 4586: FND_FILE.PUT(FND_FILE.LOG,l_code_block);

4582: OPEN c_get_orgn_info;
4583: FETCH c_get_orgn_info INTO LocalOrgnRecord;
4584: IF c_get_orgn_info%NOTFOUND THEN
4585: l_code_block := 'No organization info for ' || g_default_orgn;
4586: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
4587: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4588: END IF;
4589: CLOSE c_get_orgn_info;
4590: -- ELSE

Line 4587: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4583: FETCH c_get_orgn_info INTO LocalOrgnRecord;
4584: IF c_get_orgn_info%NOTFOUND THEN
4585: l_code_block := 'No organization info for ' || g_default_orgn;
4586: FND_FILE.PUT(FND_FILE.LOG,l_code_block);
4587: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4588: END IF;
4589: CLOSE c_get_orgn_info;
4590: -- ELSE
4591: --OPEN c_get_orgn_info_v;

Line 4595: -- FND_FILE.PUT(FND_FILE.LOG,l_code_block);

4591: --OPEN c_get_orgn_info_v;
4592: --FETCH c_get_orgn_info_v INTO LocalOrgnOMRecord;
4593: --IF c_get_orgn_info_v%NOTFOUND THEN
4594: -- l_code_block := 'No organization info for ' || g_default_orgn;
4595: -- FND_FILE.PUT(FND_FILE.LOG,l_code_block);
4596: -- FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4597: --END IF;
4598: --CLOSE c_get_orgn_info_v;
4599: END IF; /* End changes*/

Line 4596: -- FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4592: --FETCH c_get_orgn_info_v INTO LocalOrgnOMRecord;
4593: --IF c_get_orgn_info_v%NOTFOUND THEN
4594: -- l_code_block := 'No organization info for ' || g_default_orgn;
4595: -- FND_FILE.PUT(FND_FILE.LOG,l_code_block);
4596: -- FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4597: --END IF;
4598: --CLOSE c_get_orgn_info_v;
4599: END IF; /* End changes*/
4600: /*

Line 4620: FND_FILE.PUT(FND_FILE.LOG,l_text_line);

4616: ** If no label info print the code and ????
4617: */
4618: IF c_get_label_info%NOTFOUND THEN
4619: l_text_line := l_label_code || ' ???? ' || g_default_orgn;
4620: FND_FILE.PUT(FND_FILE.LOG,l_text_line);
4621: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4622: l_return_status := 'S';
4623: Insert_Work_Row
4624: (p_item_code,

Line 4621: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4617: */
4618: IF c_get_label_info%NOTFOUND THEN
4619: l_text_line := l_label_code || ' ???? ' || g_default_orgn;
4620: FND_FILE.PUT(FND_FILE.LOG,l_text_line);
4621: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4622: l_return_status := 'S';
4623: Insert_Work_Row
4624: (p_item_code,
4625: LocalDocRecord.print_font,

Line 5361: FND_FILE.PUT(FND_FILE.LOG, TO_CHAR(g_session_id) || ' Error inserting work record');

5357:
5358: EXCEPTION
5359:
5360: WHEN OTHERS THEN
5361: FND_FILE.PUT(FND_FILE.LOG, TO_CHAR(g_session_id) || ' Error inserting work record');
5362: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
5363:
5364: END Insert_Work_Row;
5365: /*

Line 5362: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

5358: EXCEPTION
5359:
5360: WHEN OTHERS THEN
5361: FND_FILE.PUT(FND_FILE.LOG, TO_CHAR(g_session_id) || ' Error inserting work record');
5362: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
5363:
5364: END Insert_Work_Row;
5365: /*
5366: ** This procedure handles the submission of print jobs to the

Line 5457: FND_FILE.PUT(FND_FILE.LOG, ' Rebuild Flag is selected ');

5453: l_rebuild_flag := 'N';
5454: END IF;
5455:
5456: IF l_rebuild_flag = 'Y' THEN
5457: FND_FILE.PUT(FND_FILE.LOG, ' Rebuild Flag is selected ');
5458: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
5459: ELSE
5460: FND_FILE.PUT(FND_FILE.LOG, ' Rebuild Flag is not selected ');
5461: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 5458: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

5454: END IF;
5455:
5456: IF l_rebuild_flag = 'Y' THEN
5457: FND_FILE.PUT(FND_FILE.LOG, ' Rebuild Flag is selected ');
5458: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
5459: ELSE
5460: FND_FILE.PUT(FND_FILE.LOG, ' Rebuild Flag is not selected ');
5461: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
5462: END IF;

Line 5460: FND_FILE.PUT(FND_FILE.LOG, ' Rebuild Flag is not selected ');

5456: IF l_rebuild_flag = 'Y' THEN
5457: FND_FILE.PUT(FND_FILE.LOG, ' Rebuild Flag is selected ');
5458: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
5459: ELSE
5460: FND_FILE.PUT(FND_FILE.LOG, ' Rebuild Flag is not selected ');
5461: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
5462: END IF;
5463:
5464: /* 17-Jun-2003 Mercy Thomas BUG 2932007 - End of the code changes */

Line 5461: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

5457: FND_FILE.PUT(FND_FILE.LOG, ' Rebuild Flag is selected ');
5458: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
5459: ELSE
5460: FND_FILE.PUT(FND_FILE.LOG, ' Rebuild Flag is not selected ');
5461: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
5462: END IF;
5463:
5464: /* 17-Jun-2003 Mercy Thomas BUG 2932007 - End of the code changes */
5465:

Line 5548: FND_FILE.PUT(FND_FILE.LOG, p_message_code||' '||p_token_value);

5544: FND_MSG_PUB.Add;
5545: FND_MSG_PUB.Count_and_Get
5546: (p_count => l_msg_count,
5547: p_data => l_msg_data);
5548: FND_FILE.PUT(FND_FILE.LOG, p_message_code||' '||p_token_value);
5549: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
5550: END Handle_Error_Messages;
5551:
5552: END GR_PROCESS_ORDERS;

Line 5549: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

5545: FND_MSG_PUB.Count_and_Get
5546: (p_count => l_msg_count,
5547: p_data => l_msg_data);
5548: FND_FILE.PUT(FND_FILE.LOG, p_message_code||' '||p_token_value);
5549: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
5550: END Handle_Error_Messages;
5551:
5552: END GR_PROCESS_ORDERS;