APPS.WIP_MOVE_VALIDATOR dependencies on WIP_SF_STATUS

Line 1026: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN1');

1022: AND wsc.status_move_flag = WIP_CONSTANTS.NO
1023: AND NVL(wsc.disable_date, SYSDATE + 1) > SYSDATE
1024: AND rownum = 1;
1025:
1026: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN1');
1027: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
1028: add_error(p_txn_id => enums(i),
1029: p_err_col => 'FM_INTRAOPERATION_STEP_TYPE',
1030: p_err_msg => fnd_message.get);

Line 1326: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN2');

1322: AND wsc.status_move_flag = WIP_CONSTANTS.NO
1323: AND NVL(wsc.disable_date, SYSDATE + 1) > SYSDATE
1324: and rownum = 1;
1325:
1326: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN2');
1327: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
1328: add_error(p_txn_id => enums(i),
1329: p_err_col => 'TO_INTRAOPERATION_STEP_TYPE',
1330: p_err_msg => fnd_message.get);

Line 1343: AND wip_sf_status.count_no_move_statuses(

1339: SET wmti.process_status = WIP_CONSTANTS.ERROR
1340: WHERE wmti.group_id = g_group_id
1341: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
1342: AND wmti.process_status = WIP_CONSTANTS.RUNNING
1343: AND wip_sf_status.count_no_move_statuses(
1344: wmti.organization_id, -- p_org_id
1345: wmti.wip_entity_id, -- p_wip_id
1346: wmti.line_id, -- p_line_id
1347: wmti.repetitive_schedule_id, -- p_sched_id

Line 1359: select wip_sf_status.get_no_move_status(

1355:
1356: /* Added the following for SUN enhancement in Bug 9758848*/
1357: if enums.count > 0 then
1358: for i in 1..enums.count loop
1359: select wip_sf_status.get_no_move_status(
1360: wmti.organization_id, -- p_org_id
1361: wmti.wip_entity_id, -- p_wip_id
1362: wmti.line_id, -- p_line_id
1363: wmti.repetitive_schedule_id, -- p_sched_id

Line 3258: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN1');

3254: AND wsc.status_move_flag = WIP_CONSTANTS.NO
3255: AND NVL(wsc.disable_date, SYSDATE + 1) > SYSDATE
3256: AND rownum = 1;
3257:
3258: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN1');
3259: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
3260: add_error(p_txn_id => enums(i),
3261: p_err_col => 'FM_INTRAOPERATION_STEP_TYPE',
3262: p_err_msg => fnd_message.get);

Line 3310: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN2');

3306: AND wsc.status_move_flag = WIP_CONSTANTS.NO
3307: AND NVL(wsc.disable_date, SYSDATE + 1) > SYSDATE
3308: and rownum = 1;
3309:
3310: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN2');
3311: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
3312: add_error(p_txn_id => enums(i),
3313: p_err_col => 'TO_INTRAOPERATION_STEP_TYPE',
3314: p_err_msg => fnd_message.get);

Line 3329: AND wip_sf_status.count_no_move_statuses(

3325: SET wmti.process_status = WIP_CONSTANTS.ERROR
3326: WHERE wmti.group_id = g_group_id
3327: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
3328: AND wmti.process_status = WIP_CONSTANTS.RUNNING
3329: AND wip_sf_status.count_no_move_statuses(
3330: wmti.organization_id, -- p_org_id
3331: wmti.wip_entity_id, -- p_wip_id
3332: wmti.line_id, -- p_line_id
3333: wmti.repetitive_schedule_id, -- p_sched_id

Line 3345: select wip_sf_status.get_no_move_status(

3341:
3342: /* Added the following for SUN enhancement in Bug 9758848*/
3343: if enums.count > 0 then
3344: for i in 1..enums.count loop
3345: select wip_sf_status.get_no_move_status(
3346: wmti.organization_id, -- p_org_id
3347: wmti.wip_entity_id, -- p_wip_id
3348: wmti.line_id, -- p_line_id
3349: wmti.repetitive_schedule_id, -- p_sched_id