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 371: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);

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

Line 383: FND_FILE.PUT_LINE(FND_FILE.LOG,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 831: FND_FILE.PUT_LINE(FND_FILE.LOG,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1166: FND_FILE.PUT_LINE(FND_FILE.LOG,

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

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

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

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

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

Line 1210: FND_FILE.PUT_LINE(FND_FILE.LOG,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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