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.MTL_CCEOI_CONC_PVT dependencies on FND_FILE

Line 38: FND_FILE.PUT_NAMES(v_log_name,v_log_name,v_log_name);

34: select substr(value,v_st_position+1,v_w_position)
35: into v_log_name from v$parameter
36: where upper(name) = 'UTL_FILE_DIR';
37: v_log_name := ltrim(v_log_name);
38: FND_FILE.PUT_NAMES(v_log_name,v_log_name,v_log_name);
39: end;
40: end;
41: --
42: -- Concurrent Program Export

Line 151: --FND_FILE.PUT_NAMES('/sqlcom/log', '/sqlcom/log', '/sqlcom/log');

147: END IF;
148: RETCODE := 'SUCCESS';
149: --
150: inv_cceoi_set_log_file;
151: --FND_FILE.PUT_NAMES('/sqlcom/log', '/sqlcom/log', '/sqlcom/log');
152: --
153: IF p_cycle_count_entry_id IS NULL THEN
154: -- Validate Input parameter
155: MTL_INV_VALIDATE_GRP.Validate_CountHeader(

Line 370: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);

366: L_rec_counter_neg := L_rec_counter_neg + 1;
367: --
368: -- Write Text according to the error code to ERRBUF
369: ERRBUF := L_msg_data;
370: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
371: END IF;
372: L_counter := L_counter + 1;
373: END LOOP;
374: -- COMMIT;

Line 382: FND_FILE.PUT_LINE(FND_FILE.LOG,

378: IF (l_debug = 1) THEN
379: mdebug('debug - 1');
380: END IF;
381: -- How many rows are exported
382: FND_FILE.PUT_LINE(FND_FILE.LOG,
383: 'Exported rows ='|| TO_CHAR(L_rec_counter_pos));
384: IF (l_debug = 1) THEN
385: mdebug('debug - 2');
386: END IF;

Line 387: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Not Exported rows ='

383: 'Exported rows ='|| TO_CHAR(L_rec_counter_pos));
384: IF (l_debug = 1) THEN
385: mdebug('debug - 2');
386: END IF;
387: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Not Exported rows ='
388: || TO_CHAR(L_rec_counter_neg));
389: IF (l_debug = 1) THEN
390: mdebug('debug - 3');
391: END IF;

Line 487: --FND_FILE.PUT_NAMES('/sqlcom/log', '/sqlcom/log', '/sqlcom/log');

483:
484: RETCODE := 'SUCCESS';
485: --
486: inv_cceoi_set_log_file;
487: --FND_FILE.PUT_NAMES('/sqlcom/log', '/sqlcom/log', '/sqlcom/log');
488: --
489: -- Validate the input parameter before calling another procedures
490: IF p_number_of_worker < 1 THEN
491: RETCODE := 'ERROR';

Line 493: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);

489: -- Validate the input parameter before calling another procedures
490: IF p_number_of_worker < 1 THEN
491: RETCODE := 'ERROR';
492: ERRBUF := FND_MESSAGE.GET_STRING('INV', 'INV_CCEOI_WRONG_COUNTOFWORKER');
493: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
494: APP_EXCEPTION.RAISE_EXCEPTION;
495: END IF;
496: IF p_commit_point < 1 THEN
497: RETCODE := 'ERROR';

Line 499: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);

495: END IF;
496: IF p_commit_point < 1 THEN
497: RETCODE := 'ERROR';
498: ERRBUF := FND_MESSAGE.GET_STRING('INV', 'INV_CCEOI_WRONG_COMMITPOINT');
499: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
500: APP_EXCEPTION.RAISE_EXCEPTION;
501: END IF;
502: IF P_ErrorReportLev NOT IN(1, 2) THEN
503: RETCODE := 'ERROR';

Line 505: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);

501: END IF;
502: IF P_ErrorReportLev NOT IN(1, 2) THEN
503: RETCODE := 'ERROR';
504: ERRBUF :=FND_MESSAGE.GET_STRING('INV', 'INV_CCEOI_WRONG_ERRORLEVEL');
505: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
506: APP_EXCEPTION.RAISE_EXCEPTION;
507: END IF;
508: IF P_DeleteProcRec NOT IN(1, 2) THEN
509: RETCODE := 'ERROR';

Line 511: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);

507: END IF;
508: IF P_DeleteProcRec NOT IN(1, 2) THEN
509: RETCODE := 'ERROR';
510: ERRBUF :=FND_MESSAGE.GET_STRING('INV', 'INV_CCEOI_WRONG_DELETEREC');
511: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
512: APP_EXCEPTION.RAISE_EXCEPTION;
513: END IF;
514: --
515: IF p_cycle_count_header_id IS NOT NULL THEN

Line 529: FND_FILE.PUT_LINE(FND_FILE.LOG, L_msg_data);

525: --
526: IF L_errorcode <> 0 THEN
527: RETCODE := 'ERROR';
528: ERRBUF := L_msg_data;
529: FND_FILE.PUT_LINE(FND_FILE.LOG, L_msg_data);
530: APP_EXCEPTION.RAISE_EXCEPTION;
531: END IF;
532: END IF;
533: -- END OF VALIDATION

Line 564: FND_FILE.PUT_LINE(FND_FILE.LOG, to_number(L_MaxNumRows)||' will be processed by the Import concurrent program.');

560: AND NVL(PROCESS_MODE, 3) = 3;
561: END IF;
562:
563: --dbms_output.put_line(to_number(L_MaxNumRows)||' will be processed by the Import concurrent program. ');
564: FND_FILE.PUT_LINE(FND_FILE.LOG, to_number(L_MaxNumRows)||' will be processed by the Import concurrent program.');
565: IF L_MaxNumRows = 0 THEN
566: -- No rows retrieved
567: RETCODE := 'WARNING';
568: ERRBUF := 'No rows retrieved.';

Line 569: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No rows retrieved!'||

565: IF L_MaxNumRows = 0 THEN
566: -- No rows retrieved
567: RETCODE := 'WARNING';
568: ERRBUF := 'No rows retrieved.';
569: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No rows retrieved!'||
570: ' Worker do not started.');
571: L_CountWorker := 0;
572: ELSIF L_MaxNumRows <= P_Number_Of_Worker THEN
573: -- only one worker neccessary

Line 600: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker = '||

596: END IF;
597: END IF;
598: --
599: --dbms_output.put_line('Worker');
600: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker = '||
601: TO_CHAR(L_CountWorker));
602: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rows/Worker = '||
603: TO_CHAR(L_CountRows));
604: --

Line 602: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rows/Worker = '||

598: --
599: --dbms_output.put_line('Worker');
600: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker = '||
601: TO_CHAR(L_CountWorker));
602: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rows/Worker = '||
603: TO_CHAR(L_CountRows));
604: --
605: -- New Logic to initialize the grpId before assign
606: UPDATE mtl_cc_entries_interface

Line 692: FND_FILE.PUT_LINE(FND_FILE.LOG, L_ErrorText);

688: -- the request.
689: IF L_NewReqID = 0 THEN
690: -- Write error to log file and exit.
691: L_ErrorText := FND_MESSAGE.GET;
692: FND_FILE.PUT_LINE(FND_FILE.LOG, L_ErrorText);
693: APP_EXCEPTION.RAISE_EXCEPTION;
694: ELSE
695: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Record set with '||
696: 'CC_ENTRY_INTERFACE_GROUP_ID = '||

Line 695: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Record set with '||

691: L_ErrorText := FND_MESSAGE.GET;
692: FND_FILE.PUT_LINE(FND_FILE.LOG, L_ErrorText);
693: APP_EXCEPTION.RAISE_EXCEPTION;
694: ELSE
695: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Record set with '||
696: 'CC_ENTRY_INTERFACE_GROUP_ID = '||
697: TO_CHAR(L_NextGroupID) || 'created.');
698: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Record set processed'||
699: ' by the worker request '|| TO_CHAR(L_NewReqID));

Line 698: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Record set processed'||

694: ELSE
695: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Record set with '||
696: 'CC_ENTRY_INTERFACE_GROUP_ID = '||
697: TO_CHAR(L_NextGroupID) || 'created.');
698: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Record set processed'||
699: ' by the worker request '|| TO_CHAR(L_NewReqID));
700: COMMIT;
701: END IF;
702: END LOOP;

Line 776: --FND_FILE.PUT_NAMES('/sqlcom/log', '/sqlcom/log', '/sqlcom/log');

772: --
773: RETCODE := 'SUCCESS';
774: --
775: inv_cceoi_set_log_file ;
776: --FND_FILE.PUT_NAMES('/sqlcom/log', '/sqlcom/log', '/sqlcom/log');
777: -- Test area
778: begin
779: select count(*)
780: into L_recs

Line 786: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleting rows : '||to_char(L_recs));

782: MTL_CC_ENTRIES_INTERFACE
783: WHERE
784: (ERROR_FLAG = 2 AND STATUS_FLAG IN (0, 1))
785: OR DELETE_FLAG = 1;
786: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleting rows : '||to_char(L_recs));
787: RETCODE := 'SUCCESS';
788: exception
789: when others then null;
790: end;

Line 830: FND_FILE.PUT_LINE(FND_FILE.LOG,

826: --
827: -- COMMIT;
828: --
829: -- How many rows are deleted
830: FND_FILE.PUT_LINE(FND_FILE.LOG,
831: 'Deleted rows ='|| TO_CHAR(L_counter));
832: --
833: IF RETCODE = 'SUCCESS'THEN
834: L_CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',

Line 926: ---FND_FILE.PUT_NAMES('/sqlcom/log', '/sqlcom/log', '/sqlcom/log');

922: BEGIN
923:
924: --
925: inv_cceoi_set_log_file ;
926: ---FND_FILE.PUT_NAMES('/sqlcom/log', '/sqlcom/log', '/sqlcom/log');
927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker');
928: --
929: -- Validate the input parameters
930: IF P_CC_Interface_Group_Id < 1 THEN

Line 927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker');

923:
924: --
925: inv_cceoi_set_log_file ;
926: ---FND_FILE.PUT_NAMES('/sqlcom/log', '/sqlcom/log', '/sqlcom/log');
927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker');
928: --
929: -- Validate the input parameters
930: IF P_CC_Interface_Group_Id < 1 THEN
931: ERRBUF := FND_MESSAGE.GET_STRING('INV', 'INV_CCEOI_WRONG_GROUPID');

Line 932: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);

928: --
929: -- Validate the input parameters
930: IF P_CC_Interface_Group_Id < 1 THEN
931: ERRBUF := FND_MESSAGE.GET_STRING('INV', 'INV_CCEOI_WRONG_GROUPID');
932: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
933: APP_EXCEPTION.RAISE_EXCEPTION;
934: END IF;
935: --
936:

Line 939: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);

935: --
936:
937: IF p_commit_point < 1 THEN
938: ERRBUF := FND_MESSAGE.GET_STRING('INV', 'INV_CCEOI_WRONG_COMMITPOINT');
939: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
940: APP_EXCEPTION.RAISE_EXCEPTION;
941: END IF;
942: --
943:

Line 946: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);

942: --
943:
944: IF P_ErrorReportLev NOT IN(1, 2) THEN
945: ERRBUF := FND_MESSAGE.GET_STRING('INV', 'INV_CCEOI_WRONG_ERRORLEVEL');
946: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
947: APP_EXCEPTION.RAISE_EXCEPTION;
948: END IF;
949: --
950:

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

949: --
950:
951: IF P_DeleteProcRec NOT IN(1, 2) THEN
952: ERRBUF := FND_MESSAGE.GET_STRING('INV', 'INV_CCEOI_WRONG_DELETEREC');
953: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
954: APP_EXCEPTION.RAISE_EXCEPTION;
955: END IF;
956:
957: -- END OF VALIDATION

Line 960: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: before process lock all recs');

956:
957: -- END OF VALIDATION
958: --
959: -- Before processing lock all records for this worker
960: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: before process lock all recs');
961: UPDATE mtl_cc_entries_interface
962: SET
963: LAST_UPDATE_DATE = SYSDATE,
964: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,

Line 979: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: After process lock all recs');

975: AND NVL(PROCESS_MODE, 3) IN(2, 3);
976: commit;
977:
978: --
979: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: After process lock all recs');
980: FOR c_rec IN L_CCEOI_records_CSR(P_CC_Interface_Group_ID) LOOP
981:
982: -- Current processed interface RECORD
983: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Inside Loop-process IR ');

Line 983: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Inside Loop-process IR ');

979: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: After process lock all recs');
980: FOR c_rec IN L_CCEOI_records_CSR(P_CC_Interface_Group_ID) LOOP
981:
982: -- Current processed interface RECORD
983: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Inside Loop-process IR ');
984: MTL_CCEOI_VAR_PVT.G_cc_entry_interface_id :=
985: c_rec.cc_entry_interface_id;
986: -- Defined by suresh
987: MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID := c_rec.inventory_item_id;

Line 1000: FND_FILE.PUT_LINE(FND_FILE.LOG, 'System Qty before assign IRec '||to_char(c_rec.system_quantity));

996: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER := c_rec.LOT_NUMBER;
997: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER := c_rec.SERIAL_NUMBER;
998:
999: --p_sku_rec.revision := c_rec.revision;
1000: FND_FILE.PUT_LINE(FND_FILE.LOG, 'System Qty before assign IRec '||to_char(c_rec.system_quantity));
1001: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CCEntry ID '||to_char(c_rec.cycle_count_entry_id));
1002: -- End of definition
1003: --
1004: L_iface_rec.parent_lpn_id := c_rec.parent_lpn_id;

Line 1001: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CCEntry ID '||to_char(c_rec.cycle_count_entry_id));

997: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER := c_rec.SERIAL_NUMBER;
998:
999: --p_sku_rec.revision := c_rec.revision;
1000: FND_FILE.PUT_LINE(FND_FILE.LOG, 'System Qty before assign IRec '||to_char(c_rec.system_quantity));
1001: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CCEntry ID '||to_char(c_rec.cycle_count_entry_id));
1002: -- End of definition
1003: --
1004: L_iface_rec.parent_lpn_id := c_rec.parent_lpn_id;
1005: L_iface_rec.outermost_lpn_id := c_rec.outermost_lpn_id;

Line 1147: FND_FILE.PUT_LINE(FND_FILE.LOG,'Worker :CountQty '||to_char(L_iface_rec.count_quantity));

1143:
1144:
1145: --
1146: --
1147: FND_FILE.PUT_LINE(FND_FILE.LOG,'Worker :CountQty '||to_char(L_iface_rec.count_quantity));
1148: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Action-'||to_char(c_rec.action_code));
1149:
1150: MTL_CCEOI_ACTION_PUB.Import_CountRequest(
1151: p_api_version => 0.9,

Line 1148: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Action-'||to_char(c_rec.action_code));

1144:
1145: --
1146: --
1147: FND_FILE.PUT_LINE(FND_FILE.LOG,'Worker :CountQty '||to_char(L_iface_rec.count_quantity));
1148: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Action-'||to_char(c_rec.action_code));
1149:
1150: MTL_CCEOI_ACTION_PUB.Import_CountRequest(
1151: p_api_version => 0.9,
1152: p_init_msg_list => FND_API.G_TRUE,

Line 1165: FND_FILE.PUT_LINE(FND_FILE.LOG,

1161: IF c_rec.action_code = 10 THEN
1162: -- Export not supported by the worker
1163: ERRBUF := FND_MESSAGE.GET_STRING('INV',
1164: 'INV_CCEOI_UNKNOWN_ACTION_CODE');
1165: FND_FILE.PUT_LINE(FND_FILE.LOG,
1166: ERRBUF);
1167: ELSIF
1168: c_rec.action_code = MTL_CCEOI_VAR_PVT.G_VALIDATE THEN
1169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Action-is Vaildate ');

Line 1169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Action-is Vaildate ');

1165: FND_FILE.PUT_LINE(FND_FILE.LOG,
1166: ERRBUF);
1167: ELSIF
1168: c_rec.action_code = MTL_CCEOI_VAR_PVT.G_VALIDATE THEN
1169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Action-is Vaildate ');
1170: MTL_CCEOI_ACTION_PVT.Validate_CountRequest(
1171: p_api_version => 0.9,
1172: p_init_msg_list => FND_API.G_TRUE,
1173: x_return_status => L_return_status,

Line 1197: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Action-is process ');

1193: x_msg_data => L_msg_data,
1194: P_interface_rec => L_iface_rec);
1195: ELSIF
1196: c_rec.action_code = MTL_CCEOI_VAR_PVT.G_PROCESS THEN
1197: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Action-is process ');
1198: MTL_CCEOI_ACTION_PVT.Process_CountRequest(
1199: p_api_version => 0.9,
1200: p_init_msg_list => FND_API.G_TRUE,
1201: x_return_status => L_return_status,

Line 1209: FND_FILE.PUT_LINE(FND_FILE.LOG,

1205: ELSE
1206: --Action code NOT known
1207: ERRBUF :=FND_MESSAGE.GET_STRING('INV',
1208: 'INV_CCEOI_UNKNOWN_ACTION_CODE');
1209: FND_FILE.PUT_LINE(FND_FILE.LOG,
1210: ERRBUF);
1211:
1212: IF p_errorreportlev = 1 THEN
1213: --

Line 1215: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: switch back lockflag-After Failure ');

1211:
1212: IF p_errorreportlev = 1 THEN
1213: --
1214: -- Reswitch the Lockflag after failure
1215: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: switch back lockflag-After Failure ');
1216: UPDATE mtl_cc_entries_interface
1217: SET
1218: LAST_UPDATE_DATE = SYSDATE,
1219: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,

Line 1237: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);

1233: */
1234: --
1235: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1236: ERRBUF := L_msg_data;
1237: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
1238: --
1239: IF P_ErrorReportLev = 1 THEN
1240: --
1241: -- Reswitch the Lockflag after failure

Line 1242: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: switch back lock-flag -2 ');

1238: --
1239: IF P_ErrorReportLev = 1 THEN
1240: --
1241: -- Reswitch the Lockflag after failure
1242: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: switch back lock-flag -2 ');
1243: UPDATE mtl_cc_entries_interface
1244: SET
1245: LAST_UPDATE_DATE = SYSDATE,
1246: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,

Line 1270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: switch back lock-flag -3 ');

1266: END LOOP;
1267: commit;
1268: --
1269: -- Reswitch the Lockflag after failure
1270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: switch back lock-flag -3 ');
1271: UPDATE mtl_cc_entries_interface
1272: SET
1273: LAST_UPDATE_DATE = SYSDATE,
1274: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,

Line 1286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Unexport all of them successfully processed');

1282: cc_entry_interface_group_id = P_CC_Interface_Group_ID;
1283: --
1284: commit;
1285: begin
1286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Unexport all of them successfully processed');
1287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker:'||to_char(P_CC_Interface_Group_ID));
1288: Update mtl_cycle_count_entries
1289: set export_flag = 2
1290: where cycle_count_entry_id

Line 1287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker:'||to_char(P_CC_Interface_Group_ID));

1283: --
1284: commit;
1285: begin
1286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Unexport all of them successfully processed');
1287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker:'||to_char(P_CC_Interface_Group_ID));
1288: Update mtl_cycle_count_entries
1289: set export_flag = 2
1290: where cycle_count_entry_id
1291: in (select cycle_count_entry_id

Line 1300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Unexport Not updated ');

1296: commit;
1297: exception
1298: when others
1299: then
1300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Unexport Not updated ');
1301: end;
1302: IF P_DeleteProcRec = 1 THEN
1303: -- DELETE completed interface records
1304: -- All records which are marked FOR deletion delete_flag =1