DBA Data[Home] [Help]

APPS.WSM_JOBCOPIES_PVT dependencies on FND_MESSAGE

Line 966: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

962: -- Start : Basic validations for the input parameters --
963: IF (nvl(p_primary_item_id, 0) = 0) OR
964: (nvl(p_primary_item_id, -1) = -1)
965: THEN
966: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
967: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Primary Item ID in Job');
968: x_err_buf := fnd_message.get;
969: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
970: x_err_code := -2; -- Error

Line 967: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Primary Item ID in Job');

963: IF (nvl(p_primary_item_id, 0) = 0) OR
964: (nvl(p_primary_item_id, -1) = -1)
965: THEN
966: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
967: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Primary Item ID in Job');
968: x_err_buf := fnd_message.get;
969: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
970: x_err_code := -2; -- Error
971: return;

Line 968: x_err_buf := fnd_message.get;

964: (nvl(p_primary_item_id, -1) = -1)
965: THEN
966: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
967: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Primary Item ID in Job');
968: x_err_buf := fnd_message.get;
969: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
970: x_err_code := -2; -- Error
971: return;
972: END IF;

Line 977: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

973:
974: IF (nvl(p_routing_item_id, 0) = 0) OR
975: (nvl(p_routing_item_id, -1) = -1)
976: THEN
977: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
978: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Routing Item ID in Job');
979: x_err_buf := fnd_message.get;
980: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
981: x_err_code := -2; -- Error

Line 978: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Routing Item ID in Job');

974: IF (nvl(p_routing_item_id, 0) = 0) OR
975: (nvl(p_routing_item_id, -1) = -1)
976: THEN
977: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
978: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Routing Item ID in Job');
979: x_err_buf := fnd_message.get;
980: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
981: x_err_code := -2; -- Error
982: return;

Line 979: x_err_buf := fnd_message.get;

975: (nvl(p_routing_item_id, -1) = -1)
976: THEN
977: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
978: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Routing Item ID in Job');
979: x_err_buf := fnd_message.get;
980: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
981: x_err_code := -2; -- Error
982: return;
983: END IF;

Line 988: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

984:
985: IF (nvl(p_common_rtg_seq_id, 0) = 0) OR
986: (nvl(p_common_rtg_seq_id, -1) = -1)
987: THEN
988: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
989: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Common Routing Sequence ID in Job');
990: x_err_buf := fnd_message.get;
991: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
992: x_err_code := -2; -- Error

Line 989: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Common Routing Sequence ID in Job');

985: IF (nvl(p_common_rtg_seq_id, 0) = 0) OR
986: (nvl(p_common_rtg_seq_id, -1) = -1)
987: THEN
988: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
989: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Common Routing Sequence ID in Job');
990: x_err_buf := fnd_message.get;
991: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
992: x_err_code := -2; -- Error
993: return;

Line 990: x_err_buf := fnd_message.get;

986: (nvl(p_common_rtg_seq_id, -1) = -1)
987: THEN
988: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
989: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Common Routing Sequence ID in Job');
990: x_err_buf := fnd_message.get;
991: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
992: x_err_code := -2; -- Error
993: return;
994: END IF;

Line 998: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

994: END IF;
995:
996: IF (p_rtg_rev_date IS NULL)
997: THEN
998: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
999: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Routing Revision Date in Job');
1000: x_err_buf := fnd_message.get;
1001: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
1002: x_err_code := -2; -- Error

Line 999: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Routing Revision Date in Job');

995:
996: IF (p_rtg_rev_date IS NULL)
997: THEN
998: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
999: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Routing Revision Date in Job');
1000: x_err_buf := fnd_message.get;
1001: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
1002: x_err_code := -2; -- Error
1003: return;

Line 1000: x_err_buf := fnd_message.get;

996: IF (p_rtg_rev_date IS NULL)
997: THEN
998: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
999: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Routing Revision Date in Job');
1000: x_err_buf := fnd_message.get;
1001: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
1002: x_err_code := -2; -- Error
1003: return;
1004: END IF;

Line 1009: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

1005:
1006: IF (nvl(p_wip_supply_type, 0) = 0) OR
1007: (nvl(p_wip_supply_type, -1) = -1)
1008: THEN
1009: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1010: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Supply Type in Job');
1011: x_err_buf := fnd_message.get;
1012: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
1013: x_err_code := -2; -- Error

Line 1010: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Supply Type in Job');

1006: IF (nvl(p_wip_supply_type, 0) = 0) OR
1007: (nvl(p_wip_supply_type, -1) = -1)
1008: THEN
1009: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1010: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Supply Type in Job');
1011: x_err_buf := fnd_message.get;
1012: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
1013: x_err_code := -2; -- Error
1014: return;

Line 1011: x_err_buf := fnd_message.get;

1007: (nvl(p_wip_supply_type, -1) = -1)
1008: THEN
1009: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1010: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Supply Type in Job');
1011: x_err_buf := fnd_message.get;
1012: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
1013: x_err_code := -2; -- Error
1014: return;
1015: END IF;

Line 1029: fnd_message.set_name('WSM', 'WSM_INVALID_INFSCH_MODE');

1025: )
1026: )
1027: THEN
1028: -- Invalid Infinite Scheduling Mode
1029: fnd_message.set_name('WSM', 'WSM_INVALID_INFSCH_MODE');
1030: x_err_buf := fnd_message.get;
1031: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
1032: x_err_code := -2; -- Error
1033: return;

Line 1030: x_err_buf := fnd_message.get;

1026: )
1027: THEN
1028: -- Invalid Infinite Scheduling Mode
1029: fnd_message.set_name('WSM', 'WSM_INVALID_INFSCH_MODE');
1030: x_err_buf := fnd_message.get;
1031: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
1032: x_err_code := -2; -- Error
1033: return;
1034: END IF;

Line 1235: fnd_message.set_name('WSM', 'WSM_NO_VALID_OPS');

1231: END LOOP;
1232:
1233: IF v_job_ops.count = 0 THEN
1234: -- No valid operations exist for the job
1235: fnd_message.set_name('WSM', 'WSM_NO_VALID_OPS');
1236: x_err_buf := fnd_message.get;
1237: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.process_job_op_nw('||l_stmt_num||'): '||x_err_buf);
1238: x_err_code := -2; -- Error
1239:

Line 1236: x_err_buf := fnd_message.get;

1232:
1233: IF v_job_ops.count = 0 THEN
1234: -- No valid operations exist for the job
1235: fnd_message.set_name('WSM', 'WSM_NO_VALID_OPS');
1236: x_err_buf := fnd_message.get;
1237: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.process_job_op_nw('||l_stmt_num||'): '||x_err_buf);
1238: x_err_code := -2; -- Error
1239:
1240: return;

Line 1367: fnd_message.set_name('WSM', 'WSM_NO_VALID_NWK_LINKS');

1363: -- Refresh is run, But as of the job's rtg rev date, only ops 10 and 20 are effective
1364: -- In this case, the job has valid ops 10, 20; but no valid network.
1365:
1366: -- No valid network links exist for the job
1367: fnd_message.set_name('WSM', 'WSM_NO_VALID_NWK_LINKS');
1368: x_err_buf := fnd_message.get;
1369: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.process_job_op_nw('||l_stmt_num||'): '||x_err_buf);
1370: x_err_code := -2; -- Error
1371:

Line 1368: x_err_buf := fnd_message.get;

1364: -- In this case, the job has valid ops 10, 20; but no valid network.
1365:
1366: -- No valid network links exist for the job
1367: fnd_message.set_name('WSM', 'WSM_NO_VALID_NWK_LINKS');
1368: x_err_buf := fnd_message.get;
1369: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.process_job_op_nw('||l_stmt_num||'): '||x_err_buf);
1370: x_err_code := -2; -- Error
1371:
1372: return; -- This should not be commented out, since later it may get overwritten.

Line 1438: fnd_message.set_name('WSM', 'WSM_NET_START_NOT_EFFECTIVE');

1434: If t_eff_opseq_num.exists(l_start_op_seq_id) then
1435: v_job_ops(t_eff_opseqid_pos(l_start_op_seq_id)).network_start_end := 'S';
1436: l_start_op_seq_num := t_eff_opseq_num(l_start_op_seq_id);
1437: else
1438: fnd_message.set_name('WSM', 'WSM_NET_START_NOT_EFFECTIVE');
1439: --x_err_buf := fnd_message.get;
1440: x_err_buf := 'l_count is'||to_char(l_start_op_seq_id);
1441: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
1442: x_err_code := -1; -- Warning

Line 1439: --x_err_buf := fnd_message.get;

1435: v_job_ops(t_eff_opseqid_pos(l_start_op_seq_id)).network_start_end := 'S';
1436: l_start_op_seq_num := t_eff_opseq_num(l_start_op_seq_id);
1437: else
1438: fnd_message.set_name('WSM', 'WSM_NET_START_NOT_EFFECTIVE');
1439: --x_err_buf := fnd_message.get;
1440: x_err_buf := 'l_count is'||to_char(l_start_op_seq_id);
1441: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
1442: x_err_code := -1; -- Warning
1443: --Bug 4264364:Added exception handling

Line 1491: fnd_message.set_name('WSM', 'WSM_NET_END_NOT_EFFECTIVE');

1487: v_job_ops(t_eff_opseqid_pos(l_end_op_seq_id)).reco_path_seq_num := l_reco_path_seq_num;
1488: v_job_ops(t_eff_opseqid_pos(l_end_op_seq_id)).recommended := 'Y';
1489: else
1490: l_reco_path_seq_num := -1;
1491: fnd_message.set_name('WSM', 'WSM_NET_END_NOT_EFFECTIVE');
1492: x_err_buf := fnd_message.get;
1493: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.process_job_op_nw('||l_stmt_num||'): '||x_err_buf);
1494: x_err_code := -1; -- Warning
1495:

Line 1492: x_err_buf := fnd_message.get;

1488: v_job_ops(t_eff_opseqid_pos(l_end_op_seq_id)).recommended := 'Y';
1489: else
1490: l_reco_path_seq_num := -1;
1491: fnd_message.set_name('WSM', 'WSM_NET_END_NOT_EFFECTIVE');
1492: x_err_buf := fnd_message.get;
1493: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.process_job_op_nw('||l_stmt_num||'): '||x_err_buf);
1494: x_err_code := -1; -- Warning
1495:
1496: --Bug 4264364:Added exception handling

Line 1567: fnd_message.set_name('WSM', 'WSM_DISABLED_PRIMARY_PATH');

1563: END LOOP;
1564: end if; --end of check on l_reco_path_seq_num
1565: l_stmt_num := 40.1;
1566: If l_curr_opseq_id <> l_start_op_seq_id or l_reco_path_seq_num = -1 then
1567: fnd_message.set_name('WSM', 'WSM_DISABLED_PRIMARY_PATH');
1568: x_err_buf := fnd_message.get;
1569: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.process_job_op_nw('||l_stmt_num||'): '||x_err_buf);
1570: x_err_code := -1; -- Warning
1571: l_inf_sch_flag := 'N'; -- Do not infinite schedule this job

Line 1568: x_err_buf := fnd_message.get;

1564: end if; --end of check on l_reco_path_seq_num
1565: l_stmt_num := 40.1;
1566: If l_curr_opseq_id <> l_start_op_seq_id or l_reco_path_seq_num = -1 then
1567: fnd_message.set_name('WSM', 'WSM_DISABLED_PRIMARY_PATH');
1568: x_err_buf := fnd_message.get;
1569: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.process_job_op_nw('||l_stmt_num||'): '||x_err_buf);
1570: x_err_code := -1; -- Warning
1571: l_inf_sch_flag := 'N'; -- Do not infinite schedule this job
1572: END IF;

Line 3202: fnd_message.set_name('WSM', 'WSM_NTWK_LOOP_EXISTS');

3198: AND
3199: (t_comp_details(l_curr_op_total_comps).wip_supply_type=6)) THEN
3200:
3201: -- A loop has been detected in this Routing Network.
3202: fnd_message.set_name('WSM', 'WSM_NTWK_LOOP_EXISTS');
3203: x_err_buf := fnd_message.get;
3204: x_err_code := -2; --Error
3205:
3206: raise loop_in_bom_exception;

Line 3203: x_err_buf := fnd_message.get;

3199: (t_comp_details(l_curr_op_total_comps).wip_supply_type=6)) THEN
3200:
3201: -- A loop has been detected in this Routing Network.
3202: fnd_message.set_name('WSM', 'WSM_NTWK_LOOP_EXISTS');
3203: x_err_buf := fnd_message.get;
3204: x_err_code := -2; --Error
3205:
3206: raise loop_in_bom_exception;
3207: END IF;

Line 3930: fnd_message.set_name('WSM', 'WSM_NO_WLBJ_REC');

3926: );
3927:
3928: IF (SQL%ROWCOUNT = 0) THEN
3929: -- No record created in WSM_LOT_BASED_JOBS
3930: fnd_message.set_name('WSM', 'WSM_NO_WLBJ_REC');
3931: x_err_buf := fnd_message.get;
3932: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
3933: x_err_code := -2; -- Error
3934:

Line 3931: x_err_buf := fnd_message.get;

3927:
3928: IF (SQL%ROWCOUNT = 0) THEN
3929: -- No record created in WSM_LOT_BASED_JOBS
3930: fnd_message.set_name('WSM', 'WSM_NO_WLBJ_REC');
3931: x_err_buf := fnd_message.get;
3932: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
3933: x_err_code := -2; -- Error
3934:
3935: return;