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

Line 156: fnd_file.put_line(fnd_file.log, 'Inside WSMPOPRN p_transaction_type_id '||p_transaction_type_id||

152: l_msg_data varchar2(4000);
153:
154: BEGIN
155: if (l_debug = 'Y') then
156: fnd_file.put_line(fnd_file.log, 'Inside WSMPOPRN p_transaction_type_id '||p_transaction_type_id||
157: ' P_Commit '||P_Commit||
158: ' X_Wip_Entity_Id '||X_Wip_Entity_Id||
159: ' X_Organization_Id '||X_Organization_Id||
160: ' X_From_Op '||X_From_Op||

Line 188: fnd_file.put_line(fnd_file.log, 'g_aps_wps_profile '||g_aps_wps_profile);

184: g_aps_wps_profile := 'N';
185: end if;
186:
187: if (l_debug = 'Y') then
188: fnd_file.put_line(fnd_file.log, 'g_aps_wps_profile '||g_aps_wps_profile);
189: END IF;
190:
191: -- Moved down to fix bug # 1497882
192: /*

Line 222: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation: Calling Disable_operations..');

218: -- BD: CZH.I_9999, 9999 is no longer the last op in WO
219: /************************
220: ELSIF (x_to_op = l_last_op_seq) THEN
221: if (l_debug = 'Y') then -- czh:BUG1995161
222: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation: Calling Disable_operations..');
223: end if; -- czh:BUG1995161
224:
225: Disable_operations (x_Wip_entity_id,
226: x_Organization_id,

Line 260: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation: Calling delete_operation..');

256: ************************/
257: -- ED: BUG1496147
258:
259: if (l_debug = 'Y') then -- czh:BUG1995161
260: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation: Calling delete_operation..');
261: end if; -- czh:BUG1995161
262:
263: -- Moved here from up to fix bug # 1497882
264: -- in form, opertion is added when to_op_seq is selected

Line 275: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation: Calling Disable_operations..');

271: -- End changes to fix bug # 1497882
272:
273:
274: if (l_debug = 'Y') then -- czh:BUG1995161
275: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation: Calling Disable_operations..');
276: end if; -- czh:BUG1995161
277:
278: -- CZH.I_9999, disable operation is called before adding the operation!
279: l_stat_num := 220;

Line 336: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation: l_count = '||l_count);

332: AND wco.operation_sequence_id = x_op_seq_id;
333: END IF;
334:
335: if (l_debug = 'Y') then -- czh:BUG1995161
336: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation: l_count = '||l_count);
337: end if; -- czh:BUG1995161
338:
339: --move enh added the IF
340: IF ((g_aps_wps_profile='N') OR (l_count=0)) THEN

Line 343: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation: NOT a Jump operation. Inserting into WO..');

339: --move enh added the IF
340: IF ((g_aps_wps_profile='N') OR (l_count=0)) THEN
341: IF(l_count > 0) THEN -- Not a Jump Operation
342: if (l_debug = 'Y') then -- czh:BUG1995161
343: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation: NOT a Jump operation. Inserting into WO..');
344: end if; -- czh:BUG1995161
345:
346: -- OSP FP I begin
347: l_stat_num := 260;

Line 356: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation calling WSMPUTIL.check_po_move: '||x_error_msg);

352: x_err_code => x_error_code ,
353: x_err_msg => x_error_msg ) ;
354:
355: IF (x_error_code <> 0) THEN
356: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation calling WSMPUTIL.check_po_move: '||x_error_msg);
357: return ;
358: END IF;
359: IF (l_po_move_exists) THEN
360: FND_MESSAGE.SET_NAME('WSM','WSM_OP_PO_MOVE');

Line 523: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation: Inserted '

519: X_REQUEST_ID => p_req_id);
520: end if;
521: --endfix 2026218
522: if (l_debug = 'Y') then -- czh:BUG1995161
523: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation: Inserted '
524: ||sql%rowcount||' records in WO.');
525: end if; -- czh:BUG1995161
526:
527:

Line 530: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation: JUMP operation. Inserting into WO..');

526:
527:
528: ELSE -- Jump Operation
529: if (l_debug = 'Y') then -- czh:BUG1995161
530: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation: JUMP operation. Inserting into WO..');
531: end if; -- czh:BUG1995161
532:
533:
534: -- OSP FP I begin

Line 545: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation '||

541: x_err_msg => x_error_msg ) ;
542:
543:
544: IF (x_error_code <> 0) THEN
545: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation '||
546: 'calling WSMPUTIL.check_po_move: '||x_error_msg);
547: return ;
548: END IF;
549: IF (l_po_move_exists) THEN

Line 702: fnd_file.put_line(fnd_file.log,

698: X_REQUEST_ID => p_req_id);
699: end if;
700:
701: if (l_debug = 'Y') then
702: fnd_file.put_line(fnd_file.log,
703: 'WSMPOPRN.add_operation: Inserted '||sql%rowcount||' records in WO.');
704: end if;
705: -- EA: bugfix 2626658/2681671
706: --mes

Line 766: fnd_file.put_line(fnd_file.log,

762: end if;
763: --endfix 2026218
764:
765: if (l_debug = 'Y') then
766: fnd_file.put_line(fnd_file.log,
767: 'WSMPOPRN.add_operation: Inserted '||sql%rowcount||' records in WO.');
768: end if;
769: ******/
770: -- ED: bugfix 2626658/2681671

Line 774: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation: Calling set_prev_next..');

770: -- ED: bugfix 2626658/2681671
771:
772: l_stat_num := 30;
773: if (l_debug = 'Y') then -- czh:BUG1995161
774: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation: Calling set_prev_next..');
775: end if; -- czh:BUG1995161
776: l_stat_num := 320;
777: -- Bug 4614970 : Changed the signature of set_prev_next so that only one row in WO is updated in the procedure
778: /******

Line 796: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation: Calling create_op_details..');

792: x_error_msg);
793:
794: l_stat_num := 40;
795: if (l_debug = 'Y') then -- czh:BUG1995161
796: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation: Calling create_op_details..');
797: end if; -- czh:BUG1995161
798:
799: -- abb H optional scrap modification begin
800:

Line 835: fnd_file.put_line(fnd_file.log, 'WSMOPRNB.create_op_details('||l_stat_num||')'|| x_error_msg);

831: x_error_code := -1;
832: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');
833: fnd_message.set_token('DEPT_ID',to_char(l_dept_id));
834: x_error_msg := FND_MESSAGE.GET;
835: fnd_file.put_line(fnd_file.log, 'WSMOPRNB.create_op_details('||l_stat_num||')'|| x_error_msg);
836: rollback;
837: return;
838: end if;
839:

Line 867: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation calling WSMPUTIL.check_po_move: '||x_error_msg);

863: x_err_code => x_error_code ,
864: x_err_msg => x_error_msg ) ;
865:
866: IF (x_error_code <> 0) THEN
867: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation calling WSMPUTIL.check_po_move: '||x_error_msg);
868: return ;
869: END IF;
870: IF (l_po_move_exists) THEN
871: FND_MESSAGE.SET_NAME('WSM','WSM_OP_PO_MOVE');

Line 909: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation calling WSMPUTIL.copy_plan_to_execution: '||x_error_msg);

905: , 'N'
906: , l_start_quantity);
907:
908: IF (x_error_code <> 0) THEN
909: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation calling WSMPUTIL.copy_plan_to_execution: '||x_error_msg);
910: return ;
911: ELSE
912: IF (l_debug = 'Y') THEN
913: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation calling WSMPUTIL.copy_plan_to_execution returned success');

Line 913: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation calling WSMPUTIL.copy_plan_to_execution returned success');

909: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation calling WSMPUTIL.copy_plan_to_execution: '||x_error_msg);
910: return ;
911: ELSE
912: IF (l_debug = 'Y') THEN
913: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation calling WSMPUTIL.copy_plan_to_execution returned success');
914: END IF;
915: END IF;
916:
917: --move enh 115.76 commented this out since this is merged with the previous sql

Line 952: fnd_file.put_line(fnd_file.log, 'WSMOPRNB.create_op_details('||l_stat_num||')'|| x_error_msg);

948: x_error_code := -1;
949: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');
950: fnd_message.set_token('DEPT_ID',to_char(l_dept_id));
951: x_error_msg := FND_MESSAGE.GET;
952: fnd_file.put_line(fnd_file.log, 'WSMOPRNB.create_op_details('||l_stat_num||')'|| x_error_msg);
953: rollback;
954: return;
955: end if;
956:

Line 960: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation: Inserted '

956:
957: END;
958: --endfix 2026218
959: if (l_debug = 'Y') then -- czh:BUG1995161
960: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation: Inserted '
961: ||sql%rowcount||' records in WO.');
962: end if; -- czh:BUG1995161
963:
964: END IF; --g_aps_wps=1

Line 1116: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation calling wsm_infinite_scheduler_pvt.schedule: '||x_error_msg);

1112: x_returnStatus => x_returnStatus,
1113: x_errorMsg => x_error_msg);
1114:
1115: IF (x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1116: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation calling wsm_infinite_scheduler_pvt.schedule: '||x_error_msg);
1117: x_error_code := -1;
1118: return ;
1119: ELSE
1120: IF (l_debug = 'Y') THEN

Line 1121: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation calling wsm_infinite_scheduler_pvt.schedule returned success');

1117: x_error_code := -1;
1118: return ;
1119: ELSE
1120: IF (l_debug = 'Y') THEN
1121: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation calling wsm_infinite_scheduler_pvt.schedule returned success');
1122: END IF;
1123: END IF;
1124: END IF;
1125: ***********/

Line 1137: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation: other excpn: (stmt'||l_stat_num

1133: WHEN others THEN
1134: x_error_code := SQLCODE;
1135: x_error_msg := 'WSMOPRNB.add_operation('||l_stat_num||')'|| substr(SQLERRM,1,200);
1136: -- czh:BUG1995161
1137: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation: other excpn: (stmt'||l_stat_num
1138: ||'):'||x_error_msg);
1139: END add_operation;
1140:
1141:

Line 1201: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.Disable_operations: other excpn: '|| x_err_msg);

1197: x_error_code := SQLCODE;
1198: x_err_msg := 'WSMOPRNB.disable_operation : '|| substr(SQLERRM,1,200);
1199:
1200: -- czh:BUG1995161
1201: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.Disable_operations: other excpn: '|| x_err_msg);
1202:
1203:
1204: END Disable_operations;
1205:

Line 1275: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.delete_operation: other excpn: '|| x_error_msg);

1271: x_error_code := SQLCODE;
1272: x_error_msg := 'WSMOPRNB.delete_operation('||l_stat_num||')'|| substr(SQLERRM,1,200);
1273:
1274: -- czh:BUG1995161
1275: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.delete_operation: other excpn: '|| x_error_msg);
1276:
1277: END delete_operation;
1278:
1279: PROCEDURE create_op_details (

Line 1431: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.create_op_details: other excpn: '|| x_error_msg);

1427: x_error_code := SQLCODE;
1428: x_error_msg := 'WSMOPRNB.create_op_details('||l_stat_num||')'|| substr(SQLERRM,1,200);
1429:
1430: -- czh:BUG1995161
1431: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.create_op_details: other excpn: '|| x_error_msg);
1432:
1433: END create_op_details;
1434:
1435: --

Line 1471: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.set_prev_next: other excpn: '|| x_error_msg);

1467: x_error_code := SQLCODE;
1468: x_error_msg := 'WSMOPRNB.set_prev_next('||l_stat_num||')'|| substr(SQLERRM,1,200);
1469:
1470: -- czh:BUG1995161
1471: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.set_prev_next: other excpn: '|| x_error_msg);
1472:
1473: END set_prev_next;
1474:
1475: -- Begin Changes Bug 4614970

Line 1508: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.set_prev_next overloaded : other excpn: '|| x_error_msg);

1504: EXCEPTION
1505: WHEN others THEN
1506: x_error_code := SQLCODE;
1507: x_error_msg := 'WSMOPRNB.set_prev_next overloaded ('||l_stat_num||')'|| substr(SQLERRM,1,200);
1508: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.set_prev_next overloaded : other excpn: '|| x_error_msg);
1509:
1510: END set_prev_next;
1511:
1512: -- End changes Bug 4614970

Line 1661: fnd_file.put_line(fnd_file.log, '*************************** p_std_op_id '||p_std_op_id||

1657: return(1);
1658: END;
1659:
1660: IF (l_debug = 'Y') THEN
1661: fnd_file.put_line(fnd_file.log, '*************************** p_std_op_id '||p_std_op_id||
1662: ' l_queue_flag '||l_queue_flag);
1663: END IF;
1664:
1665: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN

Line 1737: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.get_intra_operation_value: other excpn: '|| x_error_msg);

1733: x_error_code := SQLCODE;
1734: x_error_msg := 'WSMOPRNB.get_intra_operation_value('||l_stat_num||')'|| substr(SQLERRM,1,200);
1735:
1736: -- czh:BUG1995161
1737: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.get_intra_operation_value: other excpn: '|| x_error_msg);
1738:
1739: END get_intra_operation_value;
1740:
1741: FUNCTION get_next_mandatory_step(x_step IN NUMBER, x_flag IN NUMBER)

Line 1788: fnd_file.put_line (fnd_file.log, 'WSMPOPRN.get_sec_inv_loc: Calling WSMPUTIL.FIND_ROUTING_END ..');

1784: -- If you need to call this function, please let me know
1785:
1786: l_stat_num := 10;
1787: if (l_debug = 'Y') then -- czh:BUG1995161
1788: fnd_file.put_line (fnd_file.log, 'WSMPOPRN.get_sec_inv_loc: Calling WSMPUTIL.FIND_ROUTING_END ..');
1789: end if; -- czh:BUG1995161
1790:
1791: WSMPUTIL.FIND_ROUTING_END(p_routing_seq_id,
1792: l_end_op_seq_id,

Line 1823: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.get_sec_inv_loc: other excpn: '|| x_error_msg);

1819: x_error_code := SQLCODE;
1820: x_error_msg := 'WSMOPRNB.get_sec_inv_loc('||l_stat_num||')'|| substr(SQLERRM,1,200);
1821:
1822: -- czh:BUG1995161
1823: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.get_sec_inv_loc: other excpn: '|| x_error_msg);
1824:
1825: END get_sec_inv_loc;
1826:
1827: FUNCTION update_job_name (

Line 2051: fnd_file.put_line(fnd_file.log, x_error_msg);

2047: when no_data_found then
2048: x_error_code := SQLCODE;
2049: x_error_msg := 'WSMOPRNB.update_job_name('||l_stat_num||'): No Data Found';
2050: -- czh:BUG1995161
2051: fnd_file.put_line(fnd_file.log, x_error_msg);
2052: return(-1);
2053:
2054: when another_job_exists then
2055: FND_MESSAGE.SET_NAME('WSM', 'WSM_DUP_JOB_NAME');

Line 2059: fnd_file.put_line(fnd_file.log, x_error_msg);

2055: FND_MESSAGE.SET_NAME('WSM', 'WSM_DUP_JOB_NAME');
2056: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_new_name); -- bugfix 2820900: corrected the token name
2057: x_error_msg := fnd_message.get;
2058: x_error_code := -1;
2059: fnd_file.put_line(fnd_file.log, x_error_msg);
2060: return(-1);
2061:
2062:
2063: -- abb bug 2345650: added the exception block and no-data-found handler.

Line 2069: fnd_file.put_line(fnd_file.log, x_error_msg);

2065: FND_MESSAGE.SET_NAME('WSM', 'WSM_NO_SECTOR_SUBINV');
2066: FND_MESSAGE.SET_TOKEN('SUB', l_comp_subinv);
2067: x_error_msg := fnd_message.get;
2068: x_error_code := -1;
2069: fnd_file.put_line(fnd_file.log, x_error_msg);
2070: return(-1);
2071:
2072: when others then
2073: x_error_code := SQLCODE;

Line 2076: fnd_file.put_line(fnd_file.log, x_error_msg);

2072: when others then
2073: x_error_code := SQLCODE;
2074: x_error_msg := 'WSMOPRNB.update_job_name('||l_stat_num||')'|| substr(SQLERRM,1,200);
2075: -- czh:BUG1995161
2076: fnd_file.put_line(fnd_file.log, x_error_msg);
2077: return(-1);
2078:
2079: END update_job_name;
2080:

Line 2154: fnd_file.put_line(fnd_file.log, x_error_msg);

2150: when no_data_found then
2151: x_error_code := SQLCODE;
2152: x_error_msg := 'WSMOPRNB.update_job_name1('||l_stat_num||'): No Data Found';
2153: -- czh:BUG1995161
2154: fnd_file.put_line(fnd_file.log, x_error_msg);
2155:
2156: when another_job_exists then
2157: FND_MESSAGE.SET_NAME('WSM', 'WSM_DUP_JOB_NAME'); -- bugfix 2820900: added this
2158: FND_MESSAGE.SET_TOKEN('JOB_NAME', p_reentered_job_name); -- bugfix 2820900: corrected the token name

Line 2165: fnd_file.put_line(fnd_file.log, x_error_msg);

2161:
2162: --bugfix 2820900: commented
2163: --x_error_msg := 'WSMOPRNB.update_job_name1('||l_stat_num||'): Another job exists with the name ' || p_reentered_job_name;
2164: -- czh:BUG1995161
2165: fnd_file.put_line(fnd_file.log, x_error_msg);
2166:
2167: when others then
2168: x_error_code := SQLCODE;
2169: x_error_msg := 'WSMOPRNB.update_job_name1('||l_stat_num||')'|| substr(SQLERRM,1,200);

Line 2171: fnd_file.put_line(fnd_file.log, x_error_msg);

2167: when others then
2168: x_error_code := SQLCODE;
2169: x_error_msg := 'WSMOPRNB.update_job_name1('||l_stat_num||')'|| substr(SQLERRM,1,200);
2170: -- czh:BUG1995161
2171: fnd_file.put_line(fnd_file.log, x_error_msg);
2172:
2173: END update_job_name1;
2174: /*EA#1803065*/
2175:

Line 2233: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: p_org_id '||p_org_id||

2229: l_msg_data varchar2(4000);
2230: BEGIN
2231: l_stmt_num := 10;
2232: if (l_debug = 'Y') then
2233: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: p_org_id '||p_org_id||
2234: ' p_wip_entity_id '||p_wip_entity_id||
2235: ' p_to_job_op_seq_num '||p_to_job_op_seq_num||
2236: ' p_to_rtg_op_seq_num '||p_to_rtg_op_seq_num||
2237: ' p_to_op_seq_id '||p_to_op_seq_id||

Line 2386: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: Inserted ' ||sql%rowcount||' records in WO.');

2382: X_PROGRAM_ID => p_program_id,
2383: X_REQUEST_ID => p_request_id);
2384:
2385: if (l_debug = 'Y') then -- czh:BUG1995161
2386: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: Inserted ' ||sql%rowcount||' records in WO.');
2387: end if; -- czh:BUG1995161
2388: ELSE
2389: if (l_debug = 'Y') then
2390: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: Inserted '||sql%rowcount||' records in WO.');

Line 2390: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: Inserted '||sql%rowcount||' records in WO.');

2386: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: Inserted ' ||sql%rowcount||' records in WO.');
2387: end if; -- czh:BUG1995161
2388: ELSE
2389: if (l_debug = 'Y') then
2390: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: Inserted '||sql%rowcount||' records in WO.');
2391: end if;
2392: x_error_msg := 'WSMOPRNB.('||l_stmt_num||')'|| 'no rows in WO';
2393: x_error_code := -1;
2394: raise e_proc_error;

Line 2452: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: Inserted '||sql%rowcount||' records in WOY.');

2448: AND WCO.OPERATION_SEQ_NUM = WO.WSM_OP_SEQ_NUM;
2449:
2450:
2451: if (l_debug = 'Y') then
2452: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: Inserted '||sql%rowcount||' records in WOY.');
2453: end if;
2454:
2455: l_stmt_num := 30;
2456: --move enh?

Line 2487: fnd_file.put_line(fnd_file.log, 'WSMOPRNB.add_operation' ||'(stmt_num='||l_stmt_num||') :

2483: l_phantom_exists := 1;
2484: END;
2485:
2486: IF (l_debug='Y') THEN
2487: fnd_file.put_line(fnd_file.log, 'WSMOPRNB.add_operation' ||'(stmt_num='||l_stmt_num||') :
2488: l_phantom_exists '||l_phantom_exists);
2489: END IF;
2490:
2491: l_stmt_num := 40;

Line 2745: fnd_file.put_line(fnd_file.log, 'count '||v_inventory_item_id.count);

2741: , v_segment20
2742: , v_department_id;
2743:
2744: IF (l_debug = 'Y') THEN
2745: fnd_file.put_line(fnd_file.log, 'count '||v_inventory_item_id.count);
2746: END IF;
2747:
2748: LOOP
2749: l_stmt_num := 60;

Line 2815: fnd_file.put_line(fnd_file.log, 'count after consolidation'||v_inventory_item_id.count);

2811: END IF;
2812: END LOOP;
2813:
2814: IF (l_debug = 'Y') THEN
2815: fnd_file.put_line(fnd_file.log, 'count after consolidation'||v_inventory_item_id.count);
2816: END IF;
2817:
2818: l_no_of_rows := v_inventory_item_id.last;
2819: j := l_no_of_rows + 1;

Line 3165: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: Inserted '||SQL%ROWCOUNT||' records in WRO.');

3161:
3162: END IF;
3163:
3164: if (l_debug = 'Y') then
3165: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: Inserted '||SQL%ROWCOUNT||' records in WRO.');
3166: end if;
3167:
3168: l_stmt_num := 80;
3169:

Line 3266: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: l_wor_count '||l_wor_count||

3262:
3263: l_wor_count := SQL%ROWCOUNT;
3264:
3265: if (l_debug = 'Y') then
3266: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: l_wor_count '||l_wor_count||
3267: ' l_wor_reco_res '||l_wor_reco_res);
3268: end if;
3269:
3270: l_stmt_num := 80;

Line 3372: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: Inserted '||SQL%ROWCOUNT||

3368: AND WCOR.PHANTOM_ITEM_ID IS NULL
3369: AND WCOR.recommended<>'Y';
3370:
3371: if (l_debug = 'Y') then
3372: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: Inserted '||SQL%ROWCOUNT||
3373: ' records in WIP_SUB_OPERATION_RESOURCES.');
3374: end if;
3375:
3376: l_stmt_num := 90;

Line 3419: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: Inserted '||SQL%ROWCOUNT

3415: -- AND WOR.Operation_seq_num= WCORI.Operation_seq_num
3416: -- AND WOR.RESOURCE_SEQ_NUM= WCORI.RESOURCE_SEQ_NUM;
3417:
3418: if (l_debug = 'Y') then
3419: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: Inserted '||SQL%ROWCOUNT
3420: ||' rows in WIP_OP_RESOURCE_INSTANCES');
3421: end if;
3422:
3423: INSERT into wip_operation_resource_usage

Line 3479: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: Inserted '||SQL%ROWCOUNT

3475:
3476: END IF;
3477:
3478: if (l_debug = 'Y') then
3479: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: Inserted '||SQL%ROWCOUNT
3480: ||' rows in wip_operation_resource_usage');
3481: end if;
3482:
3483: l_stmt_num := 100;

Line 3486: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: Calling set_prev_next..');

3482:
3483: l_stmt_num := 100;
3484:
3485: if (l_debug = 'Y') then -- czh:BUG1995161
3486: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: Calling set_prev_next..');
3487: end if; -- czh:BUG1995161
3488:
3489: set_prev_next(p_wip_entity_id,
3490: p_org_id,

Line 3546: fnd_file.put_line(fnd_file.log, x_error_msg);

3542: -- This just means that the operation was already inserted
3543: WHEN e_proc_error THEN
3544: x_error_code := -1;
3545: x_error_msg := 'WSMPOPRN.copy_plan_to_execution('||l_stmt_num||'): '||x_error_msg;
3546: fnd_file.put_line(fnd_file.log, x_error_msg);
3547:
3548: WHEN dup_val_on_index THEN
3549: BEGIN
3550: IF (p_dup_val_ignore='N') THEN

Line 3554: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution other excpn: (stmt'||l_stmt_num ||'): dup_val_on_index');

3550: IF (p_dup_val_ignore='N') THEN
3551: x_error_code := SQLCODE;
3552: x_error_msg := 'WSMOPRNB.copy_plan_to_execution('||l_stmt_num||')'|| substr(SQLERRM,1,2000);
3553: ELSE
3554: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution other excpn: (stmt'||l_stmt_num ||'): dup_val_on_index');
3555: END IF;
3556: END;
3557:
3558: WHEN others THEN

Line 3562: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution other excpn: (stmt'||l_stmt_num ||'):'||x_error_msg);

3558: WHEN others THEN
3559: x_error_code := SQLCODE;
3560: x_error_msg := 'WSMOPRNB.copy_plan_to_execution('||l_stmt_num||')'|| substr(SQLERRM,1,2000);
3561: -- czh:BUG1995161
3562: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution other excpn: (stmt'||l_stmt_num ||'):'||x_error_msg);
3563:
3564: END copy_plan_to_execution;
3565:
3566: PROCEDURE call_infinite_scheduler(

Line 3594: fnd_file.put_line(fnd_file.log, 'To Op not present in WSM_COPY_OPERATIONS');

3590: AND operation_sequence_id = p_to_op_seq_id;
3591: EXCEPTION
3592: WHEN no_data_found THEN
3593: IF (l_debug = 'Y') THEN
3594: fnd_file.put_line(fnd_file.log, 'To Op not present in WSM_COPY_OPERATIONS');
3595: END IF;
3596: null;
3597: END;
3598:

Line 3625: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation calling wsm_infinite_scheduler_pvt.schedule: '||x_error_msg);

3621: x_returnStatus => x_returnStatus,
3622: x_errorMsg => x_error_msg);
3623:
3624: IF (x_returnStatus <> fnd_api.g_ret_sts_success) THEN
3625: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation calling wsm_infinite_scheduler_pvt.schedule: '||x_error_msg);
3626: x_error_code := -1;
3627: return ;
3628: ELSE
3629: IF (l_debug = 'Y') THEN

Line 3630: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation calling wsm_infinite_scheduler_pvt.schedule returned success');

3626: x_error_code := -1;
3627: return ;
3628: ELSE
3629: IF (l_debug = 'Y') THEN
3630: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.add_operation calling wsm_infinite_scheduler_pvt.schedule returned success');
3631: END IF;
3632: END IF;
3633: END IF;
3634: x_error_code := 0;

Line 3640: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.call_infinite_scheduler other excpn: (stmt'||l_stmt_num ||'):'||x_error_msg);

3636: WHEN others THEN
3637: x_error_code := SQLCODE;
3638: x_error_msg := 'WSMOPRNB.call_infinite_scheduler('||l_stmt_num||')'|| substr(SQLERRM,1,2000);
3639: -- czh:BUG1995161
3640: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.call_infinite_scheduler other excpn: (stmt'||l_stmt_num ||'):'||x_error_msg);
3641: END call_infinite_scheduler;
3642:
3643: --bug 3162358 115.78 added this new procedure which will be called from WSMTXSFM.pld and WSMLBMIB.pls
3644: /*

Line 3669: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.upd_cumulative_scrap_qty other excpn: (stmt'||l_stmt_num ||'):'||x_error_msg);

3665: WHEN others THEN
3666: x_error_code := SQLCODE;
3667: x_error_msg := 'WSMOPRNB.upd_cumulative_scrap_qty('||l_stmt_num||')'|| substr(SQLERRM,1,2000);
3668: -- czh:BUG1995161
3669: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.upd_cumulative_scrap_qty other excpn: (stmt'||l_stmt_num ||'):'||x_error_msg);
3670: END upd_cumulative_scrap_qty;
3671: */
3672:
3673: /******************************************************************************************