eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSMPUTIL dependencies on FND_FILE

Line 111: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

107: EXCEPTION
108: WHEN OTHERS THEN
109: x_err_code := SQLCODE;
110: x_err_msg := 'WSMPUTIL.CHECK_WSM_ORG: (stmt_num='||l_stmt_num||'): '||SUBSTR(SQLERRM,1,60);
111: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
112: return(0);
113:
114: END CHECK_WSM_ORG;
115:

Line 283: -- FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

279: EXCEPTION
280: WHEN OTHERS THEN
281: x_err_code := SQLCODE;
282: x_err_msg := 'WSMPUTIL.FIND_ROUTING_START '|| SUBSTR(SQLERRM,1,60);
283: -- FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
284: RETURN;
285:
286: END find_routing_start;
287:

Line 432: -- BD: 1964044 -- FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg); -- ED: 1964044

428: EXCEPTION
429: WHEN OTHERS THEN
430: x_err_code := SQLCODE;
431: x_err_msg := 'WSMPUTIL.FIND_ROUTING_END '|| SUBSTR(SQLERRM,1,60);
432: -- BD: 1964044 -- FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg); -- ED: 1964044
433: RETURN;
434:
435: END find_routing_end;
436:

Line 601: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

597: WHEN OTHERS THEN
598: x_err_code := SQLCODE;
599: x_err_msg := 'WSMPUTIL.GET_SCHEDULED_DATE('||l_stmt_num||
600: '): '|| SUBSTR(SQLERRM,1,60);
601: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
602: return SYSDATE;
603:
604: END GET_SCHEDULED_DATE;
605:

Line 691: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

687: EXCEPTION
688: WHEN OTHERS THEN
689: x_err_code := SQLCODE;
690: x_err_msg := 'WSMPTUIL.GET_DEF_ACCT_CLASS_CODE('||l_stmt_num||'): '||SUBSTR(SQLERRM,1,60);
691: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
692: return NULL;
693: END GET_DEF_ACCT_CLASS_CODE;
694:
695:

Line 838: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

834: x_locator_id := NULL;
835: x_err_code := SQLCODE;
836: x_err_msg := 'WSMPTUIL.GET_DEF_COMPLETION_SUB_DTLS('||l_stmt_num||
837: '): '|| SUBSTR(SQLERRM,1,60);
838: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
839: return ;
840: -- EA NSO-WLT
841:
842: WHEN OTHERS THEN

Line 846: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

842: WHEN OTHERS THEN
843: x_err_code := SQLCODE;
844: x_err_msg := 'WSMPTUIL.GET_DEF_COMPLETION_SUB_DTLS('||l_stmt_num||
845: '): '|| SUBSTR(SQLERRM,1,60);
846: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
847: return ;
848:
849: END GET_DEF_COMPLETION_SUB_DTLS;
850:

Line 927: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

923: WHEN NO_DATA_FOUND THEN
924:
925: FND_MESSAGE.SET_NAME('WSM','WSM_START_SHOULD_BE_PRIMARY');
926: x_err_msg:= FND_MESSAGE.GET;
927: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
928: RETURN 1;
929:
930: WHEN TOO_MANY_ROWS THEN
931:

Line 934: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

930: WHEN TOO_MANY_ROWS THEN
931:
932: FND_MESSAGE.SET_NAME('WSM','WSM_MULT_PRIMARY_STARTS');
933: x_err_msg:= FND_MESSAGE.GET;
934: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
935: RETURN 1;
936: END;
937:
938: l_st_num := 20;

Line 953: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

949: WHEN NO_DATA_FOUND THEN
950:
951: FND_MESSAGE.SET_NAME('WSM','WSM_END_SHOULD_BE_PRIMARY');
952: x_err_msg := FND_MESSAGE.GET;
953: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
954: RETURN 1;
955:
956: WHEN TOO_MANY_ROWS THEN
957: FND_MESSAGE.SET_NAME('WSM','WSM_MULT_PRIMARY_ENDS');

Line 959: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

955:
956: WHEN TOO_MANY_ROWS THEN
957: FND_MESSAGE.SET_NAME('WSM','WSM_MULT_PRIMARY_ENDS');
958: x_err_msg:= FND_MESSAGE.GET;
959: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
960: RETURN 1;
961:
962: END;
963:

Line 995: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

991: FND_MESSAGE.SET_NAME('WSM','WSM_DUPLICATE_LINK');
992: fnd_message.set_token('FROM_OPSEQ_NUM', l_from_opseq_num);
993: fnd_message.set_token('TO_OPSEQ_NUM', l_to_opseq_num);
994: x_err_msg:= FND_MESSAGE.GET;
995: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
996: RETURN 1;
997: End If;
998:
999: EXCEPTION

Line 1006: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

1002:
1003: WHEN TOO_MANY_ROWS THEN
1004: FND_MESSAGE.SET_NAME('WSM','WSM_DUPLICATE_LINKS_EXIST');
1005: x_err_msg:= FND_MESSAGE.GET;
1006: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1007: RETURN 1;
1008:
1009: END;
1010:

Line 1054: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

1050: WHEN TOO_MANY_ROWS then
1051: FND_MESSAGE.SET_NAME('WSM','WSM_MULTIPLE_PRIMARY_PATHS_START');
1052: FND_MESSAGE.SET_TOKEN('WSM_SEQ_NUM',x_meet_num);
1053: x_err_msg:= FND_MESSAGE.GET;
1054: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1055: RETURN 1;
1056:
1057: WHEN NO_DATA_FOUND THEN
1058: FND_MESSAGE.SET_NAME('WSM','WSM_PRIMARY_PATH_END_IMPROPER');

Line 1061: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

1057: WHEN NO_DATA_FOUND THEN
1058: FND_MESSAGE.SET_NAME('WSM','WSM_PRIMARY_PATH_END_IMPROPER');
1059: FND_MESSAGE.SET_TOKEN('WSM_SEQ_NUM',x_meet_num);
1060: x_err_msg:= FND_MESSAGE.GET;
1061: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1062: RETURN 1;
1063: END;
1064:
1065: l_st_num := 40;

Line 1101: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

1097: WHEN OTHERS THEN
1098: x_err_code := SQLCODE;
1099: x_err_msg := 'WSMPTUIL.PRIMARY_LOOP_TEST.('||l_st_num||
1100: '): '|| SUBSTR(SQLERRM,1,60);
1101: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1102: RETURN 1;
1103:
1104: END primary_loop_test;
1105:

Line 1167: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

1163: WHEN NO_SUB THEN
1164: x_err_code := -1;
1165: FND_MESSAGE.SET_NAME('WSM','WSM_END_OPERATION_STK_PT');
1166: x_err_msg:= FND_MESSAGE.GET||' '||x_completion_subinventory;
1167: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1168:
1169: -- BA NSO-WLT
1170: WHEN NOT_STD_OP THEN
1171: x_err_code := -1;

Line 1174: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

1170: WHEN NOT_STD_OP THEN
1171: x_err_code := -1;
1172: FND_MESSAGE.SET_NAME('WSM','WSM_END_OPERATION_STK_PT');
1173: x_err_msg:= FND_MESSAGE.GET||' '||x_completion_subinventory;
1174: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1175: -- EA NSO-WLT
1176:
1177: WHEN NO_DATA_FOUND THEN
1178: x_err_code := -1;

Line 1181: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

1177: WHEN NO_DATA_FOUND THEN
1178: x_err_code := -1;
1179: FND_MESSAGE.SET_NAME('WSM','WSM_END_OPERATION_STK_PT');
1180: x_err_msg:= FND_MESSAGE.GET||' '||x_completion_subinventory;
1181: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1182:
1183: WHEN OTHERS THEN
1184: x_err_code := SQLCODE;
1185: x_err_msg := 'WSMPTUIL.DEFAULT_SUB_LOC:' || SUBSTR(SQLERRM,1,60);

Line 1186: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

1182:
1183: WHEN OTHERS THEN
1184: x_err_code := SQLCODE;
1185: x_err_msg := 'WSMPTUIL.DEFAULT_SUB_LOC:' || SUBSTR(SQLERRM,1,60);
1186: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1187:
1188: END GET_DEFAULT_SUB_LOC;
1189:
1190: /************************************************************************/

Line 1213: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

1209:
1210: WHEN OTHERS THEN
1211: x_err_code := SQLCODE;
1212: x_err_msg := 'WSMPTUIL.UPDATE_SUB_LOC:' || SUBSTR(SQLERRM,1,60);
1213: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1214:
1215: END UPDATE_SUB_LOC;
1216:
1217:

Line 1359: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

1355: EXCEPTION
1356: When e_primaryCostMethod Then
1357: x_err_code := 1;
1358: x_err_msg := fnd_message.get;
1359: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1360: return(x_err_code);
1361:
1362: When e_lotNumberUniqueness Then
1363: x_err_code := 2;

Line 1365: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

1361:
1362: When e_lotNumberUniqueness Then
1363: x_err_code := 2;
1364: x_err_msg := fnd_message.get;
1365: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1366: return(x_err_code);
1367:
1368: When e_lotNumberDefaultType Then
1369: x_err_code := 3;

Line 1371: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

1367:
1368: When e_lotNumberDefaultType Then
1369: x_err_code := 3;
1370: x_err_msg := fnd_message.get;
1371: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1372: return(x_err_code);
1373:
1374: When e_wpsEnabled Then
1375: x_err_code := 4;

Line 1377: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

1373:
1374: When e_wpsEnabled Then
1375: x_err_code := 4;
1376: x_err_msg := fnd_message.get;
1377: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1378: return(x_err_code);
1379:
1380: /*BA#1490834*/
1381: When e_wmsEnabled Then

Line 1391: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

1387: -- Bug#2131807 PJM enabled check.
1388: When e_pjmEnabled Then -- Bug#2131807 check PJM enabled
1389: x_err_code := 6;
1390: x_err_msg := fnd_message.get;
1391: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1392: return(x_err_code);
1393:
1394: WHEN OTHERS Then
1395: x_err_code := SQLCODE;

Line 1400: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

1396: x_err_msg :=
1397: 'WSMPUTIL.CHECK_IF_ORG_IS_VALID: (stmt_num='||
1398: l_stmt_num||'): '||
1399: SUBSTR(SQLERRM,1,60);
1400: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1401: return(x_err_code);
1402:
1403:
1404: End CHECK_IF_ORG_IS_VALID;

Line 1456: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

1452:
1453: WHEN OTHERS THEN
1454: x_err_code := SQLCODE;
1455: x_err_msg := 'WSMPTUIL.WRITE_TO_WIE:' || SUBSTR(SQLERRM,1,60);
1456: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1457:
1458: END WRITE_TO_WIE;
1459:
1460: /*BA#1577747*/

Line 1522: -- FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

1518:
1519: WHEN OTHERS THEN
1520: x_err_code := SQLCODE;
1521: x_err_msg := 'WSMPTUIL.FIND_COMMON_ROUTING:' || SUBSTR(SQLERRM,1,60);
1522: -- FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1523:
1524: End find_common_routing;
1525:
1526: /*EA#1577747*/

Line 1583: -- FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

1579: return v_op_seq_num;
1580:
1581: EXCEPTION
1582: WHEN E_USER_EXCEPTION THEN
1583: -- FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1584: return 0;
1585:
1586: WHEN OTHERS THEN
1587: x_err_code := SQLCODE;

Line 1589: -- FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

1585:
1586: WHEN OTHERS THEN
1587: x_err_code := SQLCODE;
1588: x_err_msg := 'WSMPTUIL.GET_ROUTING_START' || SUBSTR(SQLERRM,1,60);
1589: -- FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1590: return 0;
1591:
1592: End get_routing_start;
1593:

Line 1649: -- BD: 1964044 -- FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg); -- ED: 1964044

1645: return v_op_seq_num;
1646:
1647: EXCEPTION
1648: WHEN E_USER_EXCEPTION THEN
1649: -- BD: 1964044 -- FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg); -- ED: 1964044
1650: return 0;
1651:
1652: WHEN OTHERS THEN
1653: x_err_code := SQLCODE;

Line 1655: -- BD: 1964044 -- FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg); -- ED: 1964044

1651:
1652: WHEN OTHERS THEN
1653: x_err_code := SQLCODE;
1654: x_err_msg := 'WSMPTUIL.GET_ROUTING_END' || SUBSTR(SQLERRM,1,60);
1655: -- BD: 1964044 -- FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg); -- ED: 1964044
1656: return 0;
1657:
1658: End get_routing_end;
1659:

Line 2159: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

2155: EXCEPTION
2156: WHEN OTHERS THEN
2157: x_err_code := SQLCODE;
2158: x_err_msg := substr('WSMPUTIL.OPERATION_IS_STANDARD_REPEATS' ||sqlerrm,1,2000);
2159: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
2160: return;
2161:
2162: END OPERATION_IS_STANDARD_REPEATS;
2163: -- BA: NSO-WLT

Line 3307: fnd_file.put_line(fnd_file.log, 'WSMPUTIL.check_charges_exist parameters are :'||

3303: BEGIN
3304: l_stmt_num := 10;
3305:
3306: IF (l_debug = 'Y') THEN
3307: fnd_file.put_line(fnd_file.log, 'WSMPUTIL.check_charges_exist parameters are :'||
3308: 'p_wip_entity_id='||p_wip_entity_id||
3309: ', p_organization_id='||p_organization_id||
3310: ', p_op_seq_num='||p_op_seq_num||
3311: ', p_op_seq_id='||p_op_seq_id);

Line 3362: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' l_rtg_op_seq_num='||l_rtg_op_seq_num);

3358: and wo.organization_id = p_organization_id
3359: and wo.repetitive_schedule_id is NULL;
3360:
3361: IF (l_debug = 'Y') THEN
3362: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' l_rtg_op_seq_num='||l_rtg_op_seq_num);
3363: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' l_qty_at_tomove='||l_qty_at_tomove);
3364: END IF;
3365:
3366: Exception

Line 3363: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' l_qty_at_tomove='||l_qty_at_tomove);

3359: and wo.repetitive_schedule_id is NULL;
3360:
3361: IF (l_debug = 'Y') THEN
3362: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' l_rtg_op_seq_num='||l_rtg_op_seq_num);
3363: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' l_qty_at_tomove='||l_qty_at_tomove);
3364: END IF;
3365:
3366: Exception
3367: WHEN NO_DATA_FOUND Then -- Job is not at this opseqnum or is at a Jump Operation.

Line 3396: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' p_manually_added_comp='||p_manually_added_comp);

3392: and wdj.wip_entity_id = wro.wip_entity_id
3393: and wdj.organization_id = wro.organization_id);
3394:
3395: IF (l_debug = 'Y') THEN
3396: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' p_manually_added_comp='||p_manually_added_comp);
3397: END IF;
3398:
3399: EXCEPTION
3400:

Line 3545: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' p_manually_added_comp='||p_manually_added_comp);

3541: End If;
3542:
3543:
3544: IF (l_debug = 'Y') THEN
3545: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' p_manually_added_comp='||p_manually_added_comp);
3546: END IF;
3547:
3548: EXCEPTION
3549:

Line 3641: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' l_dummy_number='||l_dummy_number);

3637: p_issued_material := 1;
3638: End If;
3639:
3640: IF (l_debug = 'Y') THEN
3641: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' l_dummy_number='||l_dummy_number);
3642: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' p_issued_material='||p_issued_material);
3643: END IF;
3644:
3645: EXCEPTION

Line 3642: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' p_issued_material='||p_issued_material);

3638: End If;
3639:
3640: IF (l_debug = 'Y') THEN
3641: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' l_dummy_number='||l_dummy_number);
3642: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' p_issued_material='||p_issued_material);
3643: END IF;
3644:
3645: EXCEPTION
3646: WHEN NO_DATA_FOUND THEN

Line 3723: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' l_dummy_number='||l_dummy_number);

3719: p_issued_resource := 1;
3720: End If;
3721:
3722: IF (l_debug = 'Y') THEN
3723: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' l_dummy_number='||l_dummy_number);
3724: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' p_issued_resource='||p_issued_resource);
3725: END IF;
3726:
3727: EXCEPTION

Line 3724: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' p_issued_resource='||p_issued_resource);

3720: End If;
3721:
3722: IF (l_debug = 'Y') THEN
3723: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' l_dummy_number='||l_dummy_number);
3724: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' p_issued_resource='||p_issued_resource);
3725: END IF;
3726:
3727: EXCEPTION
3728: WHEN NO_DATA_FOUND THEN

Line 3793: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' p_manually_added_resource='||p_manually_added_resource);

3789: p_manually_added_resource := 1;
3790: End If;
3791:
3792: IF (l_debug = 'Y') THEN
3793: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' p_manually_added_resource='||p_manually_added_resource);
3794: END IF;
3795:
3796:
3797: EXCEPTION

Line 3835: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' p_charges_exist='||p_charges_exist);

3831: p_charges_exist := 1;
3832: end if;
3833:
3834: IF (l_debug = 'Y') THEN
3835: fnd_file.put_line(fnd_file.log, 'At '||l_stmt_num||' p_charges_exist='||p_charges_exist);
3836: END IF;
3837:
3838: EXCEPTION
3839:

Line 3989: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

3985:
3986: WHEN OTHERS THEN
3987: x_err_code := SQLCODE;
3988: x_err_msg := 'WSMPUTIL.CHECK_PO_MOVE' ||substrb(sqlerrm, 1,1000);
3989: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
3990: return FALSE;
3991:
3992: END check_po_move ;
3993:

Line 4104: fnd_file.put_line(fnd_file.log, 'WSMPUTIL.validate_lbj_before_close: Updated LBJ records to ERROR.');

4100: if sql%rowcount > 0 then
4101: x_err_code := 0; -- this is needed by WIP to figure out whether to end the request in warning or success.
4102: end if;
4103: if (l_debug = 'Y') then
4104: fnd_file.put_line(fnd_file.log, 'WSMPUTIL.validate_lbj_before_close: Updated LBJ records to ERROR.');
4105: end if;
4106:
4107:
4108: -- Update the WDJ status type to 15

Line 4121: fnd_file.put_line(fnd_file.log, 'Following jobs failed the close process because of unprocessed/uncosted WIP lot transactions or Move transactions:');

4117: and wt.wip_entity_id = we.wip_entity_id
4118: and we.entity_type = 5); -- we will touch only the LBJs.
4119:
4120: if (sql%rowcount > 0) then
4121: fnd_file.put_line(fnd_file.log, 'Following jobs failed the close process because of unprocessed/uncosted WIP lot transactions or Move transactions:');
4122:
4123: -- Print the entities which FAILED CLOSE
4124: for rec in (select tm.wip_entity_id, we.wip_entity_name
4125: from wip_dj_close_temp tm, wip_entities we

Line 4133: fnd_file.put_line(fnd_file.log, rec.wip_entity_name);

4129: and tm.organization_id = p_organization_id
4130: and tm.status_type = 99
4131: and we.entity_type = 5)
4132: loop
4133: fnd_file.put_line(fnd_file.log, rec.wip_entity_name);
4134: end loop;
4135:
4136: end if;
4137:

Line 4145: fnd_file.put_line(fnd_file.log, 'WSMPUTIL.validate_lbj_before_close: Successfully cleaned up temp table by deleting '||sql%rowcount|| ' records.');

4141: and organization_id = p_organization_id
4142: and status_type = 99;
4143:
4144: if (l_debug = 'Y') then
4145: fnd_file.put_line(fnd_file.log, 'WSMPUTIL.validate_lbj_before_close: Successfully cleaned up temp table by deleting '||sql%rowcount|| ' records.');
4146: end if;
4147:
4148: EXCEPTION
4149: when others then

Line 4150: fnd_file.put_line(fnd_file.log, 'WSMPUTIL.validate_lbj_before_close: Unexpected Error: '||sqlerrm);

4146: end if;
4147:
4148: EXCEPTION
4149: when others then
4150: fnd_file.put_line(fnd_file.log, 'WSMPUTIL.validate_lbj_before_close: Unexpected Error: '||sqlerrm);
4151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4152:
4153: END validate_lbj_before_close;
4154:

Line 4585: FND_FILE.PUT_LINE(FND_FILE.LOG, p_err_msg);

4581: EXCEPTION
4582: WHEN OTHERS THEN
4583: p_err_code := SQLCODE;
4584: p_err_msg := substr('WSMPUTIL.return_att_quantity :' ||sqlerrm, 1,2000);
4585: FND_FILE.PUT_LINE(FND_FILE.LOG, p_err_msg);
4586: return;
4587: END return_att_quantity;
4588:
4589:

Line 4723: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPUTIL.check_wlmti: Returned Success');

4719: x_err_code := 0;
4720: x_err_msg := 'WSMPUTIL.CHECK_WLMTI:Success';
4721:
4722: If (l_debug = 'Y') Then
4723: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPUTIL.check_wlmti: Returned Success');
4724: End If;
4725:
4726: RETURN l_rowcount;
4727:

Line 4736: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

4732:
4733: WHEN OTHERS THEN
4734: x_err_code := SQLCODE;
4735: x_err_msg := 'WSMPUTIL.check_wlmti(stmt_num='||l_stmt_num||' :'||SUBSTR(SQLERRM,1,1000);
4736: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
4737:
4738: END CHECK_WLMTI;
4739:
4740: --

Line 4826: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

4822:
4823:
4824: IF (l_rowcount > 0 ) THEN
4825: x_err_msg := 'WSMPUTIL.check_wmti('||l_stmt_num||') : Returning error';
4826: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
4827: RETURN l_rowcount;
4828: END IF;
4829:
4830: ELSIF (p_wip_entity_name IS NOT NULL) THEN

Line 4851: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

4847:
4848:
4849: IF (l_rowcount > 0 ) THEN
4850: x_err_msg := 'WSMPUTIL.check_wmti('||l_stmt_num||') : Returning error';
4851: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
4852: RETURN l_rowcount;
4853: END IF;
4854:
4855: END IF;

Line 4862: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

4858:
4859: x_err_code := 0;
4860: x_err_msg := 'WSMPUTIL.CHECK_WMTI:Returned Success';
4861: IF (l_debug = 'Y') THEN
4862: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
4863: END IF;
4864: RETURN 0;
4865:
4866: EXCEPTION

Line 4874: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

4870:
4871: WHEN OTHERS THEN
4872: x_err_code := SQLCODE;
4873: x_err_msg := 'WSMPUTIL.check_wmti('||l_stmt_num||') :'||SUBSTR(SQLERRM,1,1000);
4874: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
4875: return 1; -- return a nonzero value.
4876:
4877: END CHECK_WMTI;
4878:

Line 4949: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_wip_entity_id ='||p_wip_entity_id);

4945: /***************************************************************
4946: -- Fixed bug #3453139: Stubbed out this procedure, since it should not be called from anywhere.
4947:
4948: if l_debug = 'Y' then
4949: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_wip_entity_id ='||p_wip_entity_id);
4950: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_id ='||p_transaction_id);
4951: end if;
4952:
4953:

Line 4950: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_id ='||p_transaction_id);

4946: -- Fixed bug #3453139: Stubbed out this procedure, since it should not be called from anywhere.
4947:
4948: if l_debug = 'Y' then
4949: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_wip_entity_id ='||p_wip_entity_id);
4950: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_id ='||p_transaction_id);
4951: end if;
4952:
4953:
4954: l_sj_rowcount := 0;

Line 5018: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

5014:
5015:
5016: IF (l_sj_rowcount > 0 ) THEN
5017: x_err_msg := 'WSMPUTIL.check_wsmt('||l_stmt_num||') : Returning error';
5018: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
5019: RETURN l_sj_rowcount;
5020: END IF;
5021:
5022: l_stmt_num := 90;

Line 5078: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

5074: END IF;
5075:
5076: IF (l_rj_rowcount > 0 ) THEN
5077: x_err_msg := 'WSMPUTIL.check_wsmt('||l_stmt_num||') : Returning error';
5078: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
5079: RETURN l_rj_rowcount;
5080: END IF;
5081:
5082: l_stmt_num := 160;

Line 5150: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

5146: END IF;
5147:
5148: IF (l_rj_rowcount > 0 ) THEN
5149: x_err_msg := 'WSMPUTIL.check_wsmt('||l_stmt_num||') : Returning error';
5150: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
5151: RETURN l_rj_rowcount;
5152: END IF;
5153:
5154: END IF;

Line 5159: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

5155:
5156: x_err_code := 0;
5157: x_err_msg := 'WSMPUTIL.CHECK_WSMT:Returned Success';
5158: IF (l_debug = 'Y') THEN
5159: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
5160: END IF;
5161:
5162: ***************************************************************/
5163:

Line 5171: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

5167:
5168: WHEN OTHERS THEN
5169: x_err_code := SQLCODE;
5170: x_err_msg := 'WSMPUTIL.CHECK_WSMT' ||'(stmt_num='||l_stmt_num||') : '||substrb(sqlerrm, 1,1000);
5171: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
5172: return 1; -- return a nonzerovalue.
5173:
5174: END CHECK_WSMT;
5175:

Line 5259: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

5255:
5256:
5257: IF (l_rowcount > 0 ) THEN
5258: x_err_msg := 'WSMPUTIL.check_wmt('||l_stmt_num||') : error: Move Txn with a later txn date found.';
5259: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
5260: RETURN l_rowcount;
5261: END IF;
5262:
5263: ELSIF (p_wip_entity_name IS NOT NULL) THEN

Line 5280: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

5276:
5277:
5278: IF (l_rowcount > 0 ) THEN
5279: x_err_msg := 'WSMPUTIL.check_wmt('||l_stmt_num||') : error: Move Txn with a later txn date found.';
5280: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
5281: RETURN l_rowcount;
5282: END IF;
5283:
5284: END IF;

Line 5296: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

5292: WHEN NO_DATA_FOUND THEN
5293: l_rowcount := 0;
5294: x_err_msg := 'WSMPUTIL.CHECK_WMT:Returned Success';
5295: IF (l_debug = 'Y') THEN
5296: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
5297: END IF;
5298: return l_rowcount;
5299:
5300: WHEN OTHERS THEN

Line 5303: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

5299:
5300: WHEN OTHERS THEN
5301: x_err_code := SQLCODE;
5302: x_err_msg := 'WSMPUTIL.check_wmt('||l_stmt_num||') :'||SUBSTR(SQLERRM,1,1000);
5303: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
5304: return 1; -- return a nonzero value.
5305:
5306: END CHECK_WMT;
5307:

Line 5340: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPUTIL.check_wsmti('||l_stmt_num||') Input parameters are ...');

5336: /***************************************************************
5337: -- Fixed bug #3453139: Stubbed out this procedure, since it is not called from anywhere.
5338:
5339: if l_debug = 'Y' then
5340: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPUTIL.check_wsmti('||l_stmt_num||') Input parameters are ...');
5341: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_wip_entity_id ='||p_wip_entity_id);
5342: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_wip_entity_name ='||p_wip_entity_name);
5343: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id ='||p_organization_id);
5344: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_date ='||to_char(p_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));

Line 5341: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_wip_entity_id ='||p_wip_entity_id);

5337: -- Fixed bug #3453139: Stubbed out this procedure, since it is not called from anywhere.
5338:
5339: if l_debug = 'Y' then
5340: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPUTIL.check_wsmti('||l_stmt_num||') Input parameters are ...');
5341: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_wip_entity_id ='||p_wip_entity_id);
5342: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_wip_entity_name ='||p_wip_entity_name);
5343: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id ='||p_organization_id);
5344: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_date ='||to_char(p_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
5345: end if;

Line 5342: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_wip_entity_name ='||p_wip_entity_name);

5338:
5339: if l_debug = 'Y' then
5340: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPUTIL.check_wsmti('||l_stmt_num||') Input parameters are ...');
5341: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_wip_entity_id ='||p_wip_entity_id);
5342: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_wip_entity_name ='||p_wip_entity_name);
5343: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id ='||p_organization_id);
5344: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_date ='||to_char(p_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
5345: end if;
5346:

Line 5343: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id ='||p_organization_id);

5339: if l_debug = 'Y' then
5340: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPUTIL.check_wsmti('||l_stmt_num||') Input parameters are ...');
5341: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_wip_entity_id ='||p_wip_entity_id);
5342: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_wip_entity_name ='||p_wip_entity_name);
5343: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id ='||p_organization_id);
5344: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_date ='||to_char(p_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
5345: end if;
5346:
5347: l_sj_rowcount := 0;

Line 5344: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_date ='||to_char(p_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));

5340: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPUTIL.check_wsmti('||l_stmt_num||') Input parameters are ...');
5341: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_wip_entity_id ='||p_wip_entity_id);
5342: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_wip_entity_name ='||p_wip_entity_name);
5343: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_organization_id ='||p_organization_id);
5344: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_transaction_date ='||to_char(p_transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
5345: end if;
5346:
5347: l_sj_rowcount := 0;
5348: l_rj_rowcount := 0;

Line 5377: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

5373: End;
5374:
5375: IF (l_sj_rowcount > 0 ) THEN
5376: x_err_msg := 'WSMPUTIL.check_wsmti('||l_stmt_num||') : Returning error - Unprocessed earlier WSJI Txn';
5377: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
5378: RETURN l_sj_rowcount;
5379:
5380: END IF;
5381:

Line 5415: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

5411: End;
5412:
5413: IF (l_rj_rowcount > 0 ) THEN
5414: x_err_msg := 'WSMPUTIL.check_wsmti('||l_stmt_num||') : Returning error - Unprocessed earlier WRJI Txn';
5415: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
5416: RETURN l_rj_rowcount;
5417: END IF;
5418:
5419: ELSIF (p_wip_entity_name IS NOT NULL) THEN

Line 5451: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

5447: End;
5448:
5449: IF (l_sj_rowcount > 0 ) THEN
5450: x_err_msg := 'WSMPUTIL.check_wsmti('||l_stmt_num||') : Returning error - Unprocessed earlier WSJI Txn';
5451: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
5452: RETURN l_sj_rowcount;
5453:
5454: END IF;
5455:

Line 5482: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

5478: End;
5479:
5480: IF (l_rj_rowcount > 0 ) THEN
5481: x_err_msg := 'WSMPUTIL.check_wsmti('||l_stmt_num||') : Returning error - Unprocessed earlier WRJI Txn';
5482: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
5483: RETURN l_rj_rowcount;
5484: END IF;
5485:
5486: END IF;

Line 5491: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

5487:
5488: x_err_code := 0;
5489: x_err_msg := 'WSMPUTIL.CHECK_WSMTI:Returned Success - No Unprocessed WSMTI Txns for this lot';
5490: IF (l_debug = 'Y') THEN
5491: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
5492: END IF;
5493:
5494: ***************************************************************/
5495:

Line 5503: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

5499:
5500: WHEN OTHERS THEN
5501: x_err_code := SQLCODE;
5502: x_err_msg := 'WSMPUTIL.CHECK_WSMTI' ||'(stmt_num='||l_stmt_num||') : '||substrb(sqlerrm, 1,1000);
5503: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
5504: return 1; -- return a nonzerovalue.
5505:
5506: END CHECK_WSMTI;
5507:

Line 5668: FND_FILE.PUT_LINE(FND_FILE.LOG,

5664: NAME => 'MFG_ORGANIZATION_ID'
5665: , USER_ID => FND_GLOBAL.user_id);
5666:
5667:
5668: FND_FILE.PUT_LINE(FND_FILE.LOG,
5669: ('User value is '|| to_char(FND_GLOBAL.user_id)
5670: ||', Org Id is '|| l_mfg_org_id)
5671: );
5672:

Line 5815: fnd_file.put_line(fnd_file.log, 'WSMPUTIL.GET_INV_ACCT_PERIOD: '||x_err_msg

5811: fnd_message.set_name('WSM', 'WSM_ACCT_PERIOD_NOT_OPEN');
5812: x_err_code := -1;
5813: x_err_msg := FND_MESSAGE.GET;
5814: IF (l_debug = 'Y') THEN -- bug 3373637
5815: fnd_file.put_line(fnd_file.log, 'WSMPUTIL.GET_INV_ACCT_PERIOD: '||x_err_msg
5816: || ' (organization_id = ' || p_organization_id || ')');
5817: END IF;
5818: l_acct_period_id := 0;
5819: end if;

Line 5832: fnd_file.put_line(fnd_file.log, 'WSMPUTIL.GET_INV_ACCT_PERIOD: '||x_err_msg);

5828: /*WHEN NO_DATA_FOUND then
5829: x_err_code := -1;
5830: fnd_message.set_name('WSM', 'WSM_ACCT_PERIOD_NOT_OPEN');
5831: x_err_msg := FND_MESSAGE.GET;
5832: fnd_file.put_line(fnd_file.log, 'WSMPUTIL.GET_INV_ACCT_PERIOD: '||x_err_msg);
5833: l_acct_period_id := 0; -- Date passed is in a NON-OPEN Period.
5834: Return l_acct_period_id;*/
5835:
5836: WHEN OTHERS THEN

Line 5839: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

5835:
5836: WHEN OTHERS THEN
5837: x_err_code := SQLCODE;
5838: x_err_msg := 'WSMPUTIL.GET_INV_ACCT_PERIOD: ' || substrb(sqlerrm, 1,1000);
5839: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
5840: l_acct_period_id := 0; -- Date passed is in a NON-OPEN Period.
5841: Return l_acct_period_id;
5842: END GET_INV_ACCT_PERIOD;
5843: