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.WSM_WLT_VALIDATE_PVT dependencies on WSMPUTIL

Line 169: wsmputil.find_common_routing( p_routing_sequence_id => x_rtg_seq_id,

165:
166: l_stmt_num := 30;
167: -- Get common routing seq id
168: -- No error code is set in find_common_routing... so compare based on x_msg_data..
169: wsmputil.find_common_routing( p_routing_sequence_id => x_rtg_seq_id,
170: p_common_routing_sequence_id => p_common_rtg_seq_id, --x_common_rtg_seq_id -- VJ: Changed
171: x_err_code => l_err_code,
172: x_err_msg => x_error_msg
173: );

Line 1008: l_acct_period_id := WSMPUTIL.GET_INV_ACCT_PERIOD(x_err_code => l_err_num,

1004: l_err_num := 0;
1005: l_err_msg := null;
1006:
1007: -- Invoke the UTIL procedure to check for an open period...
1008: l_acct_period_id := WSMPUTIL.GET_INV_ACCT_PERIOD(x_err_code => l_err_num,
1009: x_err_msg => l_err_msg,
1010: p_organization_id => p_wltx_header.organization_id,
1011: p_date => p_wltx_header.transaction_date);
1012:

Line 1021: p_msg_text => 'WSMPUTIL.GET_INV_ACCT_PERIOD returned failure : ' || l_msg_data ,

1017: -- Log the Procedure exit point....
1018: if( g_log_level_statement >= l_log_level ) then
1019: l_msg_tokens.delete;
1020: WSM_log_PVT.logMessage(p_module_name => l_module ,
1021: p_msg_text => 'WSMPUTIL.GET_INV_ACCT_PERIOD returned failure : ' || l_msg_data ,
1022: p_stmt_num => l_stmt_num ,
1023: p_msg_tokens => l_msg_tokens,
1024: p_fnd_log_level => g_log_level_statement,
1025: p_run_log_level => l_log_level

Line 2449: -- call WSMPUTIL.find_routing_start to validate first operation in N/W.

2445: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2446: END IF;
2447: end if;
2448:
2449: -- call WSMPUTIL.find_routing_start to validate first operation in N/W.
2450: -- added for bug 5386675.
2451:
2452: wsmputil.find_routing_start (p_routing_sequence_id => p_resulting_job_rec.common_routing_sequence_id,
2453: p_routing_rev_date => p_resulting_job_rec.routing_revision_date,

Line 2452: wsmputil.find_routing_start (p_routing_sequence_id => p_resulting_job_rec.common_routing_sequence_id,

2448:
2449: -- call WSMPUTIL.find_routing_start to validate first operation in N/W.
2450: -- added for bug 5386675.
2451:
2452: wsmputil.find_routing_start (p_routing_sequence_id => p_resulting_job_rec.common_routing_sequence_id,
2453: p_routing_rev_date => p_resulting_job_rec.routing_revision_date,
2454: start_op_seq_id => l_start_op_seq_id,
2455: x_err_code => l_error_code,
2456: x_err_msg => l_msg_data);

Line 2475: -- call WSMPUTIL.find_routing_end to validate last operation in N/W.

2471: raise FND_API.G_EXC_ERROR;
2472:
2473: end if;
2474:
2475: -- call WSMPUTIL.find_routing_end to validate last operation in N/W.
2476: -- added for bug 5386675.
2477:
2478: wsmputil.find_routing_end (p_routing_sequence_id => p_resulting_job_rec.common_routing_sequence_id,
2479: p_routing_rev_date => p_resulting_job_rec.routing_revision_date,

Line 2478: wsmputil.find_routing_end (p_routing_sequence_id => p_resulting_job_rec.common_routing_sequence_id,

2474:
2475: -- call WSMPUTIL.find_routing_end to validate last operation in N/W.
2476: -- added for bug 5386675.
2477:
2478: wsmputil.find_routing_end (p_routing_sequence_id => p_resulting_job_rec.common_routing_sequence_id,
2479: p_routing_rev_date => p_resulting_job_rec.routing_revision_date,
2480: end_op_seq_id => l_end_op_seq_id,
2481: x_err_code => l_error_code,
2482: x_err_msg => l_msg_data);

Line 2705: -- call WSMPUTIL.find_routing_start to validate first operation in N/W.

2701: END IF;
2702: raise FND_API.G_EXC_ERROR;
2703: end if;
2704:
2705: -- call WSMPUTIL.find_routing_start to validate first operation in N/W.
2706: -- added for bug 5386675.
2707:
2708: wsmputil.find_routing_start (p_routing_sequence_id => p_resulting_job_rec.common_routing_sequence_id,
2709: p_routing_rev_date => p_resulting_job_rec.routing_revision_date,

Line 2708: wsmputil.find_routing_start (p_routing_sequence_id => p_resulting_job_rec.common_routing_sequence_id,

2704:
2705: -- call WSMPUTIL.find_routing_start to validate first operation in N/W.
2706: -- added for bug 5386675.
2707:
2708: wsmputil.find_routing_start (p_routing_sequence_id => p_resulting_job_rec.common_routing_sequence_id,
2709: p_routing_rev_date => p_resulting_job_rec.routing_revision_date,
2710: start_op_seq_id => l_start_op_seq_id,
2711: x_err_code => l_error_code,
2712: x_err_msg => l_msg_data);

Line 2731: -- call WSMPUTIL.find_routing_end to validate last operation in N/W.

2727: raise FND_API.G_EXC_ERROR;
2728:
2729: end if;
2730:
2731: -- call WSMPUTIL.find_routing_end to validate last operation in N/W.
2732: -- added for bug 5386675.
2733:
2734: wsmputil.find_routing_end (p_routing_sequence_id => p_resulting_job_rec.common_routing_sequence_id,
2735: p_routing_rev_date => p_resulting_job_rec.routing_revision_date,

Line 2734: wsmputil.find_routing_end (p_routing_sequence_id => p_resulting_job_rec.common_routing_sequence_id,

2730:
2731: -- call WSMPUTIL.find_routing_end to validate last operation in N/W.
2732: -- added for bug 5386675.
2733:
2734: wsmputil.find_routing_end (p_routing_sequence_id => p_resulting_job_rec.common_routing_sequence_id,
2735: p_routing_rev_date => p_resulting_job_rec.routing_revision_date,
2736: end_op_seq_id => l_end_op_seq_id,
2737: x_err_code => l_error_code,
2738: x_err_msg => l_msg_data);

Line 4654: -- call WSMPUTIL.find_routing_start to validate first operation in N/W.

4650: END IF;
4651: end if ;
4652:
4653: l_stmt_num := 135;
4654: -- call WSMPUTIL.find_routing_start to validate first operation in N/W.
4655: -- added for bug 5386675.
4656:
4657: wsmputil.find_routing_start (p_routing_sequence_id => p_resulting_jobs_tbl(l_counter).common_routing_sequence_id,
4658: p_routing_rev_date => p_resulting_jobs_tbl(l_counter).routing_revision_date,

Line 4657: wsmputil.find_routing_start (p_routing_sequence_id => p_resulting_jobs_tbl(l_counter).common_routing_sequence_id,

4653: l_stmt_num := 135;
4654: -- call WSMPUTIL.find_routing_start to validate first operation in N/W.
4655: -- added for bug 5386675.
4656:
4657: wsmputil.find_routing_start (p_routing_sequence_id => p_resulting_jobs_tbl(l_counter).common_routing_sequence_id,
4658: p_routing_rev_date => p_resulting_jobs_tbl(l_counter).routing_revision_date,
4659: start_op_seq_id => l_start_op_seq_id,
4660: x_err_code => l_error_code,
4661: x_err_msg => l_msg_data);

Line 4680: -- call WSMPUTIL.find_routing_end to validate last operation in N/W.

4676: raise FND_API.G_EXC_ERROR;
4677:
4678: end if;
4679:
4680: -- call WSMPUTIL.find_routing_end to validate last operation in N/W.
4681: -- added for bug 5386675.
4682:
4683: wsmputil.find_routing_end (p_routing_sequence_id => p_resulting_jobs_tbl(l_counter).common_routing_sequence_id,
4684: p_routing_rev_date => p_resulting_jobs_tbl(l_counter).routing_revision_date,

Line 4683: wsmputil.find_routing_end (p_routing_sequence_id => p_resulting_jobs_tbl(l_counter).common_routing_sequence_id,

4679:
4680: -- call WSMPUTIL.find_routing_end to validate last operation in N/W.
4681: -- added for bug 5386675.
4682:
4683: wsmputil.find_routing_end (p_routing_sequence_id => p_resulting_jobs_tbl(l_counter).common_routing_sequence_id,
4684: p_routing_rev_date => p_resulting_jobs_tbl(l_counter).routing_revision_date,
4685: end_op_seq_id => l_end_op_seq_id,
4686: x_err_code => l_error_code,
4687: x_err_msg => l_msg_data);

Line 5268: p_resulting_job_rec.scheduled_completion_date := WSMPUTIL.GET_SCHEDULED_DATE( p_organization_id => p_resulting_job_rec.organization_id,

5264:
5265: else
5266: -- Obtain the scheduled completion date information
5267: if p_resulting_job_rec.scheduled_completion_date is null then
5268: p_resulting_job_rec.scheduled_completion_date := WSMPUTIL.GET_SCHEDULED_DATE( p_organization_id => p_resulting_job_rec.organization_id,
5269: p_primary_item_id => p_resulting_job_rec.primary_item_id,
5270: p_schedule_method => 'F',
5271: p_input_date => p_resulting_job_rec.scheduled_start_date,
5272: p_quantity => p_resulting_job_rec.start_quantity,

Line 5277: p_resulting_job_rec.scheduled_completion_date := WSMPUTIL.GET_SCHEDULED_DATE( p_organization_id => p_resulting_job_rec.organization_id,

5273: x_err_code => l_err_code,
5274: x_err_msg => l_err_msg);
5275:
5276: elsif p_resulting_job_rec.scheduled_start_date is null then
5277: p_resulting_job_rec.scheduled_completion_date := WSMPUTIL.GET_SCHEDULED_DATE( p_organization_id => p_resulting_job_rec.organization_id,
5278: p_primary_item_id => p_resulting_job_rec.primary_item_id,
5279: p_schedule_method => 'B',
5280: p_input_date => p_resulting_job_rec.scheduled_completion_date,
5281: p_quantity => p_resulting_job_rec.start_quantity,

Line 5526: l_class_code := WSMPUTIL.GET_DEF_ACCT_CLASS_CODE( p_txn_org_id,

5522: -- class code check .....dependent on the subinventory....
5523: l_stmt_num := 110;
5524: BEGIN
5525: if p_resulting_job_rec.class_code is null then
5526: l_class_code := WSMPUTIL.GET_DEF_ACCT_CLASS_CODE( p_txn_org_id,
5527: p_resulting_job_rec.primary_item_id,
5528: p_resulting_job_rec.completion_subinventory,
5529: l_err_code,
5530: l_err_msg

Line 5576: IF wsmputil.WSM_ESA_ENABLED( p_wip_entity_id => NULL,

5572: p_resulting_job_rec.class_code := l_class_code;
5573:
5574: l_stmt_num := 135;
5575: -- IF Estimated Scrap account is enabled... check accounts of the defaulted class code....
5576: IF wsmputil.WSM_ESA_ENABLED( p_wip_entity_id => NULL,
5577: err_code => l_err_code,
5578: err_msg => l_err_msg,
5579: p_org_id => p_txn_org_id,
5580: p_job_type => p_resulting_job_rec.job_type

Line 6838: p_msg_text => 'Calling WSMPUTIL.operation_is_standard_repeats',

6834:
6835: if( g_log_level_statement >= l_log_level ) then
6836: l_msg_tokens.delete;
6837: WSM_log_PVT.logMessage(p_module_name => l_module ,
6838: p_msg_text => 'Calling WSMPUTIL.operation_is_standard_repeats',
6839: p_stmt_num => l_stmt_num ,
6840: p_msg_tokens => l_msg_tokens,
6841: p_fnd_log_level => g_log_level_statement,
6842: p_run_log_level => l_log_level

Line 6849: WSMPUTIL.operation_is_standard_repeats ( p_routing_sequence_id => p_new_comm_rtg_seq_id,

6845:
6846: -- logic goes here.....
6847: l_err_code := 0;
6848: l_err_msg := null;
6849: WSMPUTIL.operation_is_standard_repeats ( p_routing_sequence_id => p_new_comm_rtg_seq_id,
6850: p_routing_revision_date => p_new_rtg_rev_date,
6851: p_standard_operation_id => p_curr_std_op_id,
6852: p_operation_code => p_curr_op_code,
6853: p_organization_id => p_txn_org_id,

Line 6865: p_msg_text => 'WSMPUTIL.operation_is_standard_repeats returned failure',

6861: if( g_log_level_statement >= l_log_level ) then
6862:
6863: l_msg_tokens.delete;
6864: WSM_log_PVT.logMessage(p_module_name => l_module ,
6865: p_msg_text => 'WSMPUTIL.operation_is_standard_repeats returned failure',
6866: p_stmt_num => l_stmt_num ,
6867: p_msg_tokens => l_msg_tokens,
6868: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6869: p_fnd_log_level => G_LOG_LEVEL_ERROR ,

Line 7124: If WSMPUTIL.CHECK_PO_MOVE( p_sequence_id => p_new_op_seq_id ,

7120: end if;
7121:
7122: -- check for PO_MOVE....
7123: l_err_code := 0;
7124: If WSMPUTIL.CHECK_PO_MOVE( p_sequence_id => p_new_op_seq_id ,
7125: p_sequence_id_type => 'O' ,
7126: p_routing_rev_date => p_new_rtg_rev_date ,
7127: x_err_code => l_err_code ,
7128: x_err_msg => l_err_msg)

Line 7860: WSMPUTIL.find_routing_start (p_routing_sequence_id => p_rtg_seq_id,

7856: l_stmt_num := 10;
7857: l_err_code := 0;
7858: l_err_msg := null;
7859:
7860: WSMPUTIL.find_routing_start (p_routing_sequence_id => p_rtg_seq_id,
7861: p_routing_rev_date => p_revision_date,
7862: start_op_seq_id => l_start_op_seq_id,
7863: x_err_code => l_err_code,
7864: x_err_msg => l_err_msg);

Line 7871: p_msg_text => 'WSMPUTIL.find_routing_start returned failure:'||l_err_msg,

7867: if( g_log_level_statement >= l_log_level ) then
7868:
7869: l_msg_tokens.delete;
7870: WSM_log_PVT.logMessage(p_module_name => l_module ,
7871: p_msg_text => 'WSMPUTIL.find_routing_start returned failure:'||l_err_msg,
7872: p_stmt_num => l_stmt_num ,
7873: p_msg_tokens => l_msg_tokens,
7874: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7875: p_fnd_log_level => G_LOG_LEVEL_ERROR ,

Line 7883: l_start_op_seq_id := WSMPUTIL.replacement_op_seq_id(l_start_op_seq_id,p_revision_date);

7879: RAISE FND_API.G_EXC_ERROR;
7880: end if;
7881:
7882: --Bug 5395091: Get replacement op seq id for the starting op seq id determined above.
7883: l_start_op_seq_id := WSMPUTIL.replacement_op_seq_id(l_start_op_seq_id,p_revision_date);
7884:
7885: l_stmt_num := 20;
7886: l_err_code := 0;
7887: l_err_msg := null;

Line 7889: WSMPUTIL.find_routing_end ( p_routing_sequence_id => p_rtg_seq_id,

7885: l_stmt_num := 20;
7886: l_err_code := 0;
7887: l_err_msg := null;
7888:
7889: WSMPUTIL.find_routing_end ( p_routing_sequence_id => p_rtg_seq_id,
7890: p_routing_rev_date => p_revision_date,
7891: end_op_seq_id => l_end_op_seq_id,
7892: x_err_code => l_err_code,
7893: x_err_msg => l_err_msg);

Line 7900: p_msg_text => 'WSMPUTIL.find_routing_end returned failure:'||l_err_msg,

7896: if( g_log_level_statement >= l_log_level ) then
7897:
7898: l_msg_tokens.delete;
7899: WSM_log_PVT.logMessage(p_module_name => l_module ,
7900: p_msg_text => 'WSMPUTIL.find_routing_end returned failure:'||l_err_msg,
7901: p_stmt_num => l_stmt_num ,
7902: p_msg_tokens => l_msg_tokens,
7903: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7904: p_fnd_log_level => G_LOG_LEVEL_ERROR ,

Line 7911: l_end_op_seq_id := WSMPUTIL.replacement_op_seq_id(l_end_op_seq_id,p_revision_date);

7907: END IF;
7908: RAISE FND_API.G_EXC_ERROR;
7909: end if;
7910: --Bug 5395091: Get replacement op seq id for the end op seq id determined above.
7911: l_end_op_seq_id := WSMPUTIL.replacement_op_seq_id(l_end_op_seq_id,p_revision_date);
7912:
7913: l_stmt_num := 30;
7914: if p_start_op_seq_num IS null and p_start_op_seq_id IS null and p_start_op_seq_code IS null then
7915: select bos.OPERATION_SEQ_NUM ,

Line 7988: --and WSMPUTIL.replacement_op_seq_id(bon.from_op_seq_id,

7984: bom_operation_sequences bos
7985: where bon.transition_type = 1 -- Primary
7986: and nvl(bon.disable_date, sysdate+1) > p_revision_date -- or is it sysdate
7987: -- Start : Fix for bug 4494368/4576184 --
7988: --and WSMPUTIL.replacement_op_seq_id(bon.from_op_seq_id,
7989: -- p_revision_date) = bos.operation_sequence_id
7990: and bon.from_op_seq_id = bos.operation_sequence_id
7991: and p_revision_date between bos.effectivity_date and nvl(bos.disable_date, p_revision_date+1)
7992: -- End : Fix for bug 4494368/4576184 --

Line 8002: --where WSMPUTIL.replacement_op_seq_id(bon.to_op_seq_id,

7998: select 1
7999: from bom_operation_networks bon,
8000: bom_operation_sequences bos
8001: -- Start : Fix for bug 4494368/4576184 --
8002: --where WSMPUTIL.replacement_op_seq_id(bon.to_op_seq_id,
8003: -- p_revision_date) = bos.operation_sequence_id
8004: where bon.to_op_seq_id = bos.operation_sequence_id
8005: and p_revision_date between bos.effectivity_date and nvl(bos.disable_date, p_revision_date+1)
8006: -- End : Fix for bug 4494368/4576184 --

Line 8012: where WSMPUTIL.replacement_op_seq_id (

8008: and bos.operation_seq_num = p_start_op_seq_num
8009: and bon.to_op_seq_id not in ( select bon1.from_op_seq_id
8010: from bom_operation_networks bon1,
8011: bom_operation_sequences bos1
8012: where WSMPUTIL.replacement_op_seq_id (
8013: bon1.from_op_seq_id,
8014: p_revision_date) = bos1.operation_sequence_id
8015: and bos1.routing_sequence_id = p_rtg_seq_id)
8016: );

Line 8039: IF (WSMPUTIL.primary_path_is_effective_till( p_routing_sequence_id => p_rtg_seq_id,

8035: END;
8036:
8037: -- Checks if primary path exists till the start....
8038: l_stmt_num := 60;
8039: IF (WSMPUTIL.primary_path_is_effective_till( p_routing_sequence_id => p_rtg_seq_id,
8040: p_routing_rev_date => p_revision_date,
8041: p_start_op_seq_id => p_start_op_seq_id,
8042: p_op_seq_num => p_start_op_seq_num,
8043: x_err_code => l_err_code,