DBA Data[Home] [Help]

APPS.WSMPOPRN dependencies on WSMPUTIL

Line 174: --move enh 115.78 changed from WSMPCNST to WSMPUTIL

170: -- We use program_id of -999 to indicate that the record is
171: -- created by the custom moves form
172:
173: l_stat_num := 10;
174: --move enh 115.78 changed from WSMPCNST to WSMPUTIL
175: IF WSMPUTIL.REFER_SITE_LEVEL_PROFILE = 'Y' THEN
176: l_job_copy_flag := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE;
177: ELSE
178: l_job_copy_flag := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(x_organization_id);

Line 175: IF WSMPUTIL.REFER_SITE_LEVEL_PROFILE = 'Y' THEN

171: -- created by the custom moves form
172:
173: l_stat_num := 10;
174: --move enh 115.78 changed from WSMPCNST to WSMPUTIL
175: IF WSMPUTIL.REFER_SITE_LEVEL_PROFILE = 'Y' THEN
176: l_job_copy_flag := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE;
177: ELSE
178: l_job_copy_flag := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(x_organization_id);
179: END IF;

Line 176: l_job_copy_flag := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE;

172:
173: l_stat_num := 10;
174: --move enh 115.78 changed from WSMPCNST to WSMPUTIL
175: IF WSMPUTIL.REFER_SITE_LEVEL_PROFILE = 'Y' THEN
176: l_job_copy_flag := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE;
177: ELSE
178: l_job_copy_flag := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(x_organization_id);
179: END IF;
180:

Line 178: l_job_copy_flag := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(x_organization_id);

174: --move enh 115.78 changed from WSMPCNST to WSMPUTIL
175: IF WSMPUTIL.REFER_SITE_LEVEL_PROFILE = 'Y' THEN
176: l_job_copy_flag := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE;
177: ELSE
178: l_job_copy_flag := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(x_organization_id);
179: END IF;
180:
181: if (l_job_copy_flag = 1) then
182: g_aps_wps_profile := 'Y';

Line 348: l_po_move_exists := WSMPUTIL.check_po_move (

344: end if; -- czh:BUG1995161
345:
346: -- OSP FP I begin
347: l_stat_num := 260;
348: l_po_move_exists := WSMPUTIL.check_po_move (
349: p_sequence_id => x_op_seq_id,
350: p_sequence_id_type => 'O' ,
351: p_routing_rev_date => p_rtg_rev_date,
352: x_err_code => x_error_code ,

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 536: l_po_move_exists := WSMPUTIL.check_po_move (

532:
533:
534: -- OSP FP I begin
535: l_stat_num := 290;
536: l_po_move_exists := WSMPUTIL.check_po_move (
537: p_sequence_id => x_standard_operation_id,
538: p_sequence_id_type => 'S' ,
539: p_routing_rev_date => p_rtg_rev_date,
540: x_err_code => x_error_code ,

Line 546: 'calling WSMPUTIL.check_po_move: '||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
550: FND_MESSAGE.SET_NAME('WSM','WSM_OP_PO_MOVE');

Line 821: l_est_scrap_acc := WSMPUTIL.WSM_ESA_ENABLED(x_wip_entity_id, x_error_code, x_error_msg);

817: where wip_entity_id = x_wip_entity_id;
818:
819: l_stat_num := 40.2;
820: x_error_code := 0;
821: l_est_scrap_acc := WSMPUTIL.WSM_ESA_ENABLED(x_wip_entity_id, x_error_code, x_error_msg);
822: if x_error_code <> 0 then
823: x_error_msg := 'WSMOPRNB.create_op_details('||l_stat_num||')'|| x_error_msg;
824: rollback;
825: return;

Line 859: /* l_po_move_exists := WSMPUTIL.check_po_move (

855: x_error_msg);
856: ELSE --(g_aps_wps_profile='Y')
857: l_stat_num := 260;
858: --move enh 115.76 removed the po_move check since it is done during copy creation
859: /* l_po_move_exists := WSMPUTIL.check_po_move (
860: p_sequence_id => x_op_seq_id,
861: p_sequence_id_type => 'O' ,
862: p_routing_rev_date => p_rtg_rev_date,
863: x_err_code => x_error_code ,

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 937: l_est_scrap_acc := WSMPUTIL.WSM_ESA_ENABLED(X_Wip_Entity_Id, x_error_code, x_error_msg);

933:
934: l_stat_num := 90;
935:
936: x_error_code := 0;
937: l_est_scrap_acc := WSMPUTIL.WSM_ESA_ENABLED(X_Wip_Entity_Id, x_error_code, x_error_msg);
938: if x_error_code <> 0 then
939: x_error_msg := 'WSMOPRNB.('||l_stat_num||')'|| x_error_msg;
940: rollback;
941: return;

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 1791: WSMPUTIL.FIND_ROUTING_END(p_routing_seq_id,

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,
1793: x_error_code,
1794: x_error_msg);
1795: