DBA Data[Home] [Help]

APPS.WSM_JOBCOPIES_PVT dependencies on FND_MESSAGE

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

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

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

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

Line 967: x_err_buf := fnd_message.get;

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

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

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

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

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

Line 978: x_err_buf := fnd_message.get;

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

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

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

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

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

Line 989: x_err_buf := fnd_message.get;

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

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

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

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

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

Line 999: x_err_buf := fnd_message.get;

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

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

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

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

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

Line 1010: x_err_buf := fnd_message.get;

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

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

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

Line 1029: x_err_buf := fnd_message.get;

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

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

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

Line 1235: x_err_buf := fnd_message.get;

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

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

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

Line 1367: x_err_buf := fnd_message.get;

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

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

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

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

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

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

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

Line 1491: x_err_buf := fnd_message.get;

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

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

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

Line 1567: x_err_buf := fnd_message.get;

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

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

2967: AND
2968: (t_comp_details(l_curr_op_total_comps).wip_supply_type=6)) THEN
2969:
2970: -- A loop has been detected in this Routing Network.
2971: fnd_message.set_name('WSM', 'WSM_NTWK_LOOP_EXISTS');
2972: x_err_buf := fnd_message.get;
2973: x_err_code := -2; --Error
2974:
2975: raise loop_in_bom_exception;

Line 2972: x_err_buf := fnd_message.get;

2968: (t_comp_details(l_curr_op_total_comps).wip_supply_type=6)) THEN
2969:
2970: -- A loop has been detected in this Routing Network.
2971: fnd_message.set_name('WSM', 'WSM_NTWK_LOOP_EXISTS');
2972: x_err_buf := fnd_message.get;
2973: x_err_code := -2; --Error
2974:
2975: raise loop_in_bom_exception;
2976: END IF;

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

3695: );
3696:
3697: IF (SQL%ROWCOUNT = 0) THEN
3698: -- No record created in WSM_LOT_BASED_JOBS
3699: fnd_message.set_name('WSM', 'WSM_NO_WLBJ_REC');
3700: x_err_buf := fnd_message.get;
3701: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
3702: x_err_code := -2; -- Error
3703:

Line 3700: x_err_buf := fnd_message.get;

3696:
3697: IF (SQL%ROWCOUNT = 0) THEN
3698: -- No record created in WSM_LOT_BASED_JOBS
3699: fnd_message.set_name('WSM', 'WSM_NO_WLBJ_REC');
3700: x_err_buf := fnd_message.get;
3701: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
3702: x_err_code := -2; -- Error
3703:
3704: return;