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 4102: fnd_file.put_line(fnd_file.log, 'WSMPUTIL.validate_lbj_before_close: Updated '||sql%rowcount|| ' LBJ records to ERROR.');

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

Line 4119: fnd_file.put_line(fnd_file.log, 'WSMPUTIL.validate_lbj_before_close: Successfully updated status of '||sql%rowcount|| ' records to FAILED CLOSE.');

4115: and wt.wip_entity_id = we.wip_entity_id
4116: and we.entity_type = 5); -- we will touch only the LBJs.
4117:
4118: if (l_debug = 'Y') then
4119: fnd_file.put_line(fnd_file.log, 'WSMPUTIL.validate_lbj_before_close: Successfully updated status of '||sql%rowcount|| ' records to FAILED CLOSE.');
4120: end if;
4121:
4122: if (sql%rowcount > 0) then
4123: fnd_file.put_line(fnd_file.log, 'Following jobs failed the close process because of unprocessed/uncosted WIP lot transactions:');

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

4119: fnd_file.put_line(fnd_file.log, 'WSMPUTIL.validate_lbj_before_close: Successfully updated status of '||sql%rowcount|| ' records to FAILED CLOSE.');
4120: end if;
4121:
4122: if (sql%rowcount > 0) then
4123: fnd_file.put_line(fnd_file.log, 'Following jobs failed the close process because of unprocessed/uncosted WIP lot transactions:');
4124:
4125: -- Print the entities which FAILED CLOSE
4126: for rec in (select tm.wip_entity_id, we.wip_entity_name
4127: from wip_dj_close_temp tm, wip_entities we

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 5671: FND_FILE.PUT_LINE(FND_FILE.LOG,

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

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

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

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

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

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

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