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 WIP_CONSTANTS

Line 1570: ELSIF (l_status_type <> WIP_CONSTANTS.RELEASED) THEN

1566: THEN
1567: l_valid := false;
1568: l_field_name := 'Organization Id';
1569: raise e_invalid_field;
1570: ELSIF (l_status_type <> WIP_CONSTANTS.RELEASED) THEN
1571: l_valid := false;
1572: l_field_name := 'Job Status : Job has to be released to perform WIP Lot Transactions';
1573: raise e_invalid_field;
1574: END IF;

Line 1675: if nvl(p_starting_job_rec.intraoperation_step,wip_constants.queue) <> wip_constants.queue then

1671: -- Validate the op info....
1672: IF l_valid = TRUE THEN
1673: if nvl(l_quantity_in_queue,0) > 0 then
1674: -- Validate the current intraperation step provided
1675: if nvl(p_starting_job_rec.intraoperation_step,wip_constants.queue) <> wip_constants.queue then
1676: l_valid :=false;
1677: l_field_name := 'Job Intraoperation Step';
1678: raise e_invalid_field;
1679: end if;

Line 1681: p_starting_job_rec.intraoperation_step := WIP_CONSTANTS.QUEUE;

1677: l_field_name := 'Job Intraoperation Step';
1678: raise e_invalid_field;
1679: end if;
1680:
1681: p_starting_job_rec.intraoperation_step := WIP_CONSTANTS.QUEUE;
1682: elsif nvl(l_quantity_waiting_to_move,0) > 0 then
1683:
1684: if nvl(p_starting_job_rec.intraoperation_step,wip_constants.tomove) <> wip_constants.tomove then
1685: l_valid :=false;

Line 1684: if nvl(p_starting_job_rec.intraoperation_step,wip_constants.tomove) <> wip_constants.tomove then

1680:
1681: p_starting_job_rec.intraoperation_step := WIP_CONSTANTS.QUEUE;
1682: elsif nvl(l_quantity_waiting_to_move,0) > 0 then
1683:
1684: if nvl(p_starting_job_rec.intraoperation_step,wip_constants.tomove) <> wip_constants.tomove then
1685: l_valid :=false;
1686: l_field_name := 'Job Intraoperation Step';
1687: raise e_invalid_field;
1688: END IF;

Line 1689: p_starting_job_rec.intraoperation_step := WIP_CONSTANTS.TOMOVE;

1685: l_valid :=false;
1686: l_field_name := 'Job Intraoperation Step';
1687: raise e_invalid_field;
1688: END IF;
1689: p_starting_job_rec.intraoperation_step := WIP_CONSTANTS.TOMOVE;
1690: END IF;
1691: ELSE
1692: RAISE e_invalid_field;
1693: END IF;

Line 2539: p_resulting_job_rec.starting_intraoperation_step := WIP_CONSTANTS.QUEUE;

2535: END IF;
2536: end if;
2537:
2538: -- Always overwrite the starting intraop step for Update Assy txn..
2539: p_resulting_job_rec.starting_intraoperation_step := WIP_CONSTANTS.QUEUE;
2540:
2541: -- Completion subinv derivation....
2542: derive_val_compl_subinv( p_job_type => p_resulting_job_rec.job_type,
2543: p_old_rtg_seq_id => p_starting_job_rec.common_routing_sequence_id,

Line 2795: p_resulting_job_rec.starting_intraoperation_step := WIP_CONSTANTS.QUEUE;

2791: END IF;
2792: END IF;
2793:
2794: -- Always overwrite the starting intraop step for Update Rtg txn..
2795: p_resulting_job_rec.starting_intraoperation_step := WIP_CONSTANTS.QUEUE;
2796:
2797: -- Completion subinv derivation....
2798: l_return_status := null;
2799: l_msg_count := 0;

Line 4744: p_resulting_jobs_tbl(l_counter).starting_intraoperation_step := WIP_CONSTANTS.QUEUE;

4740: END IF;
4741: end if ;
4742:
4743: -- Always overwrite the starting intraop step for Split and Update Assy txn..
4744: p_resulting_jobs_tbl(l_counter).starting_intraoperation_step := WIP_CONSTANTS.QUEUE;
4745:
4746: end if; -- End Check on Split and Update Flag
4747:
4748: l_stmt_num := 150;

Line 5035: p_resulting_job_rec.job_type := WIP_CONSTANTS.STANDARD;

5031:
5032: l_stmt_num := 20;
5033: -- Default the job type to be Standard
5034: if p_resulting_job_rec.job_type is null then
5035: p_resulting_job_rec.job_type := WIP_CONSTANTS.STANDARD;
5036:
5037: -- Bug 5487991 added elsif condition to validate the job_type is either 1 or 3
5038: -- these are two valid values for lot based jobs
5039:

Line 5064: p_resulting_job_rec.wip_supply_type := WIP_CONSTANTS.BASED_ON_BOM;

5060: end if;
5061:
5062: -- Deafult the BOM supply type..
5063: if p_resulting_job_rec.wip_supply_type is null then
5064: p_resulting_job_rec.wip_supply_type := WIP_CONSTANTS.BASED_ON_BOM;
5065: end if;
5066:
5067: -- Default the organization info..
5068: if p_resulting_job_rec.organization_id is null then

Line 5426: p_resulting_job_rec.starting_intraoperation_step := nvl(p_resulting_job_rec.starting_intraoperation_step,WIP_CONSTANTS.QUEUE);

5422: end if ;
5423:
5424: l_stmt_num := 90;
5425: -- If the starting intraop step isnt specified, default to QUEUE
5426: p_resulting_job_rec.starting_intraoperation_step := nvl(p_resulting_job_rec.starting_intraoperation_step,WIP_CONSTANTS.QUEUE);
5427:
5428: IF p_resulting_job_rec.starting_intraoperation_step <> 1 THEN
5429: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5430:

Line 5811: if p_sj_job_type = WIP_CONSTANTS.NONSTANDARD then

5807: p_fnd_log_level => l_log_level
5808: );
5809: END IF;
5810:
5811: if p_sj_job_type = WIP_CONSTANTS.NONSTANDARD then
5812: -- if both null then copy from the starting....
5813: if p_rj_rtg_reference_id is null and p_rj_rtg_reference_item is null then
5814: --p_rj_rtg_reference_id := p_sj_rtg_reference_id; (AH)
5815: --error out as user has to specify some info...(AH)

Line 5889: IF p_sj_job_type = wip_constants.nonstandard THEN

5885: l_stmt_num := 19;
5886:
5887: -- Check if a OSFM routing
5888: l_row_exists := 0;
5889: IF p_sj_job_type = wip_constants.nonstandard THEN
5890: l_item_id := p_rj_rtg_reference_id;
5891: ELSE
5892: l_item_id := p_rj_primary_item_id;
5893: END IF;

Line 5942: if p_sj_job_type = wip_constants.nonstandard THEN

5938: p_rj_rtg_revision_date := sysdate;
5939:
5940: END IF;
5941:
5942: if p_sj_job_type = wip_constants.nonstandard THEN
5943: l_item_id := p_rj_rtg_reference_id;
5944: ELSE
5945: l_item_id := p_rj_primary_item_id;
5946: END IF;

Line 5977: IF p_sj_job_type = wip_constants.nonstandard THEN

5973: -- ST : Fix for bug 5218479 : end --
5974: ELSE -- revision date is not null
5975: l_rtg_revision := null;
5976:
5977: IF p_sj_job_type = wip_constants.nonstandard THEN
5978: l_item_id := p_rj_rtg_reference_id;
5979: ELSE
5980: l_item_id := p_rj_primary_item_id;
5981: END IF;

Line 6192: -- ( (p_sj_job_type = WIP_CONSTANTS.STANDARD) AND

6188: l_stmt_num := 18;
6189:
6190: IF -- ST : Fix for bug 5101841 Commenting the below statement for Standard job.
6191: -- Standard Jobs will always have a BOM
6192: -- ( (p_sj_job_type = WIP_CONSTANTS.STANDARD) AND
6193: -- (p_rj_alternate_bom_desig IS NULL) AND
6194: -- (p_rj_common_bom_seq_id IS NULL) AND
6195: -- (p_rj_bom_revision IS NULL) AND
6196: -- (p_rj_bom_revision_date IS NULL)

Line 6199: ( (p_sj_job_type = WIP_CONSTANTS.NONSTANDARD) and

6195: -- (p_rj_bom_revision IS NULL) AND
6196: -- (p_rj_bom_revision_date IS NULL)
6197: -- )
6198: -- OR
6199: ( (p_sj_job_type = WIP_CONSTANTS.NONSTANDARD) and
6200: (p_rj_bom_reference_id IS NULL) and
6201: (p_rj_bom_reference_item IS NULL)
6202: )
6203: then

Line 6216: if p_sj_job_type = WIP_CONSTANTS.NONSTANDARD then

6212: end if;
6213:
6214: l_stmt_num := 20;
6215:
6216: if p_sj_job_type = WIP_CONSTANTS.NONSTANDARD then
6217: -- if both null then copy from the starting....
6218: if p_rj_bom_reference_id is null and p_rj_bom_reference_item is null then
6219: --p_rj_bom_reference_id := p_sj_bom_reference_id; (AH)
6220: --error out as user has to specify some info...(AH)

Line 6291: if p_sj_job_type = wip_constants.nonstandard then

6287: -- yes..... assign bom_revision_date to job start date or sysdate
6288: p_rj_bom_revision_date := sysdate;
6289: end if;
6290:
6291: if p_sj_job_type = wip_constants.nonstandard then
6292: l_item_id := p_rj_bom_reference_id;
6293: else
6294: l_item_id := p_rj_primary_item_id;
6295: end if;

Line 6315: if p_sj_job_type = wip_constants.nonstandard then

6311:
6312: else -- revision date is not null
6313: l_bom_revision := null;
6314:
6315: if p_sj_job_type = wip_constants.nonstandard then
6316: l_item_id := p_rj_bom_reference_id;
6317: else
6318: l_item_id := p_rj_primary_item_id;
6319: end if;

Line 6526: IF p_job_type = WIP_CONSTANTS.STANDARD THEN

6522: );
6523: END IF;
6524:
6525: l_stmt_num := 20;
6526: IF p_job_type = WIP_CONSTANTS.STANDARD THEN
6527: l_rtg_item_id := p_primary_item_id;
6528: ELSE
6529: l_rtg_item_id := p_rj_rtg_reference_item_id;
6530: END IF;

Line 6832: if p_curr_intra_op_step = WIP_CONSTANTS.QUEUE then

6828: p_run_log_level => l_log_level
6829: );
6830: End if;
6831:
6832: if p_curr_intra_op_step = WIP_CONSTANTS.QUEUE then
6833: l_stmt_num :=20;
6834:
6835: if( g_log_level_statement >= l_log_level ) then
6836: l_msg_tokens.delete;

Line 7462: WIP_CONSTANTS.COMPLETED,

7458: WSMPLOAD.G_GROUP_ID,
7459: p_wltx_header.REASON_ID,
7460: p_wltx_header.TRANSACTION_DATE,
7461: p_wltx_header.TRANSACTION_REFERENCE,
7462: WIP_CONSTANTS.COMPLETED,
7463: null,--p_wltx_header.SUSPENSE_ACCT_ID,
7464: sysdate,
7465: fnd_global.user_id,
7466: sysdate,

Line 7490: decode(p_wltx_header.transaction_type_id,3,WIP_CONSTANTS.COMPLETED,

7486: FND_GLOBAL.PROG_APPL_ID,
7487: FND_GLOBAL.CONC_PROGRAM_ID,
7488: sysdate,
7489: p_wltx_header.EMPLOYEE_ID ,--Added for MES
7490: decode(p_wltx_header.transaction_type_id,3,WIP_CONSTANTS.COMPLETED,
7491: 5,WIP_CONSTANTS.COMPLETED,
7492: 7,WIP_CONSTANTS.COMPLETED,
7493: WIP_CONSTANTS.PENDING
7494: )

Line 7491: 5,WIP_CONSTANTS.COMPLETED,

7487: FND_GLOBAL.CONC_PROGRAM_ID,
7488: sysdate,
7489: p_wltx_header.EMPLOYEE_ID ,--Added for MES
7490: decode(p_wltx_header.transaction_type_id,3,WIP_CONSTANTS.COMPLETED,
7491: 5,WIP_CONSTANTS.COMPLETED,
7492: 7,WIP_CONSTANTS.COMPLETED,
7493: WIP_CONSTANTS.PENDING
7494: )
7495: );

Line 7492: 7,WIP_CONSTANTS.COMPLETED,

7488: sysdate,
7489: p_wltx_header.EMPLOYEE_ID ,--Added for MES
7490: decode(p_wltx_header.transaction_type_id,3,WIP_CONSTANTS.COMPLETED,
7491: 5,WIP_CONSTANTS.COMPLETED,
7492: 7,WIP_CONSTANTS.COMPLETED,
7493: WIP_CONSTANTS.PENDING
7494: )
7495: );
7496:

Line 7493: WIP_CONSTANTS.PENDING

7489: p_wltx_header.EMPLOYEE_ID ,--Added for MES
7490: decode(p_wltx_header.transaction_type_id,3,WIP_CONSTANTS.COMPLETED,
7491: 5,WIP_CONSTANTS.COMPLETED,
7492: 7,WIP_CONSTANTS.COMPLETED,
7493: WIP_CONSTANTS.PENDING
7494: )
7495: );
7496:
7497: if( g_log_level_statement >= l_log_level ) then