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 WSMPOPRN

Line 1: PACKAGE BODY WSMPOPRN AS

1: PACKAGE BODY WSMPOPRN AS
2: /* $Header: WSMOPRNB.pls 120.25.12010000.2 2008/09/24 15:39:09 tbhande ship $ */
3:
4: /*============================================================================+
5: | Copyright (c) 1996 Oracle Corporation, Redwood Shores, California, USA |

Line 148: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPOPRN.add_operation';

144:
145: -- Logging variables.....
146: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
147: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
148: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPOPRN.add_operation';
149: l_param_tbl WSM_Log_PVT.param_tbl_type;
150: l_return_status VARCHAR2(1);
151: l_msg_count number;
152: l_msg_data varchar2(4000);

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 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 703: 'WSMPOPRN.add_operation: Inserted '||sql%rowcount||' records in WO.');

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
707: UPDATE WSM_LOT_BASED_JOBS

Line 767: 'WSMPOPRN.add_operation: Inserted '||sql%rowcount||' records in WO.');

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
771:

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 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 890: WSMPOPRN.copy_plan_to_execution(x_error_code

886: AND operation_sequence_id = x_op_seq_id;
887:
888: l_stat_num := 60;
889:
890: WSMPOPRN.copy_plan_to_execution(x_error_code
891: , x_error_msg
892: , X_Organization_Id
893: , X_Wip_Entity_Id
894: , x_to_op

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 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 1622: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPOPRN.get_intra_operation_value';

1618: l_row_count NUMBER;
1619: -- Logging variables.....
1620: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1621: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1622: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPOPRN.get_intra_operation_value';
1623: l_param_tbl WSM_Log_PVT.param_tbl_type;
1624: l_error_count NUMBER;
1625: l_return_code NUMBER;
1626: l_error_msg VARCHAR2(4000);

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 2225: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPOPRN.copy_plan_to_execution';

2221:
2222: -- Logging variables.....
2223: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2224: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2225: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPOPRN.copy_plan_to_execution';
2226: l_param_tbl WSM_Log_PVT.param_tbl_type;
2227: l_return_status VARCHAR2(1);
2228: l_msg_count number;
2229: l_msg_data varchar2(4000);

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 2385: fnd_file.put_line(fnd_file.log, 'WSMPOPRN.copy_plan_to_execution: Inserted ' ||sql%rowcount||' records in WO.');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3531: p_msg_text => 'WSMPOPRN.copy_to_op_mes_info returned successfully',

3527: IF (l_return_status = g_ret_success) THEN
3528: l_msg_tokens.delete;
3529: WSM_log_PVT.logMessage (
3530: p_module_name => l_module ,
3531: p_msg_text => 'WSMPOPRN.copy_to_op_mes_info returned successfully',
3532: p_stmt_num => l_stmt_num ,
3533: p_msg_tokens => l_msg_tokens ,
3534: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
3535: p_run_log_level => l_log_level

Line 3544: x_error_msg := 'WSMPOPRN.copy_plan_to_execution('||l_stmt_num||'): '||x_error_msg;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3891: ddrosetta_retval := WSMPOPRN.update_job_name(p_wip_entity_id,

3887: else ddp_update_flag := true;
3888: end if;
3889:
3890: -- here's the delegated call to the old PL/SQL routine
3891: ddrosetta_retval := WSMPOPRN.update_job_name(p_wip_entity_id,
3892: p_subinventory,
3893: p_org_id,
3894: p_txn_type,
3895: ddp_update_flag,

Line 3905: END WSMPOPRN;

3901:
3902: return ddrosetta_retval;
3903: end;
3904: --end bug 5337172
3905: END WSMPOPRN;
3906: