APPS.WSM_WLT_VALIDATE_PVT dependencies on WSMPCNST

Line 1714: if p_txn_type <> WSMPCNST.MERGE THEN

1710: where STANDARD_OPERATION_ID = p_starting_job_rec.standard_operation_id;
1711:
1712: end if;
1713:
1714: if p_txn_type <> WSMPCNST.MERGE THEN
1715:
1716: l_stmt_num := 140;
1717: p_starting_job_rec.representative_flag := 'Y';
1718: --'Modified the representative flag to : ' || p_starting_job_rec.representative_flag );

Line 1738: IF (p_txn_type in (WSMPCNST.SPLIT,WSMPCNST.UPDATE_ROUTING,WSMPCNST.UPDATE_ASSEMBLY) ) THEN

1734: End if;
1735:
1736: l_stmt_num := 155;
1737: -- add update BOM also
1738: IF (p_txn_type in (WSMPCNST.SPLIT,WSMPCNST.UPDATE_ROUTING,WSMPCNST.UPDATE_ASSEMBLY) ) THEN
1739:
1740: l_stmt_num := 160;
1741: -- change the code to call by name
1742: IF wip_osp.po_req_exists(p_starting_job_rec.wip_entity_id,

Line 1941: p_txn_type => WSMPCNST.MERGE,

1937: End if;
1938:
1939: -- Invoke the derive_val_st_job_details for the starting job
1940: derive_val_st_job_details( p_txn_org_id => p_txn_org_id,
1941: p_txn_type => WSMPCNST.MERGE,
1942: -- ST : Added Txn date for bug 4351071
1943: p_txn_date => p_txn_date,
1944: p_starting_job_rec => p_starting_jobs_tbl(l_counter),
1945: x_return_status => l_return_status,

Line 2292: if p_txn_type = WSMPCNST.UPDATE_ASSEMBLY then

2288: );
2289: End if;
2290: l_stmt_num := 40;
2291:
2292: if p_txn_type = WSMPCNST.UPDATE_ASSEMBLY then
2293:
2294: -- Copy all the non-txn related fields
2295:
2296: -- Job name and description

Line 2582: elsif p_txn_type = WSMPCNST.UPDATE_ROUTING then

2578: END IF;
2579:
2580: l_stmt_num := 50;
2581:
2582: elsif p_txn_type = WSMPCNST.UPDATE_ROUTING then
2583:
2584: -- Job name and description
2585: p_resulting_job_rec.wip_entity_name := p_starting_job_rec.wip_entity_name;
2586: p_resulting_job_rec.description := p_starting_job_rec.description;

Line 2843: elsif p_txn_type = WSMPCNST.UPDATE_QUANTITY then

2839:
2840: -- update routing done.....
2841: l_stmt_num := 60;
2842:
2843: elsif p_txn_type = WSMPCNST.UPDATE_QUANTITY then
2844:
2845: -- Copy all the non-txn related fields
2846: -- Job name and description
2847: p_resulting_job_rec.wip_entity_name := p_starting_job_rec.wip_entity_name;

Line 3104: elsif p_txn_type = WSMPCNST.UPDATE_LOT_NAME then

3100:
3101: -- update qty is done..... */
3102: l_stmt_num := 70;
3103:
3104: elsif p_txn_type = WSMPCNST.UPDATE_LOT_NAME then
3105:
3106: -- The only fields that the user can specify is Job name and Description */
3107:
3108: -- Primary info ..... --

Line 3276: elsif (p_txn_type = 8) then -- WSMPCNST.UPDATE_COMPL_SUBINV

3272:
3273: -- update lot name complete.....--
3274: l_stmt_num := 90;
3275:
3276: elsif (p_txn_type = 8) then -- WSMPCNST.UPDATE_COMPL_SUBINV
3277:
3278: -- The only fields that the user can specify is completion subinv. locator, locator id
3279:
3280: -- Job name and description --

Line 3363: ELSIF p_txn_type = 9 THEN --WSMPCNST.UPDATE_STATUS--

3359: -- error out..
3360: null;
3361: end if;
3362:
3363: ELSIF p_txn_type = 9 THEN --WSMPCNST.UPDATE_STATUS--
3364: --- copy all fields except for status type...
3365: -- Job name and description --
3366: p_resulting_job_rec.wip_entity_name := p_starting_job_rec.wip_entity_name;
3367: p_resulting_job_rec.description := p_starting_job_rec.description;

Line 3521: elsif p_txn_type = 10 then -- WSMPCNST.UPDATE_BOM*

3517: -- error out,..... --
3518: null;
3519: end if;
3520:
3521: elsif p_txn_type = 10 then -- WSMPCNST.UPDATE_BOM*
3522:
3523: -- this section is incomplete... will update it at the end.... --
3524:
3525: -- copy all fields except for bom related ...

Line 3714: if p_txn_type <> WSMPCNST.MERGE then

3710: l_null_char varchar2(10) := FND_API.G_NULL_CHAR;
3711:
3712: begin
3713: l_stmt_num := 10;
3714: if p_txn_type <> WSMPCNST.MERGE then
3715: --error out... --
3716: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
3717: l_msg_tokens.delete;
3718: l_msg_tokens(1).TokenName := 'FLD_NAME';

Line 4057: if p_txn_type <> WSMPCNST.SPLIT then

4053: p_run_log_level => l_log_level
4054: );
4055: End if;
4056:
4057: if p_txn_type <> WSMPCNST.SPLIT then
4058: -- error out....--
4059: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
4060: l_msg_tokens.delete;
4061: l_msg_tokens(1).TokenName := 'FLD_NAME';

Line 5016: if p_txn_type <> WSMPCNST.BONUS then

5012: BEGIN
5013:
5014: l_stmt_num := 10;
5015:
5016: if p_txn_type <> WSMPCNST.BONUS then
5017: -- error out...
5018: if( g_log_level_statement >= l_log_level ) then
5019: l_msg_tokens.delete;
5020: WSM_log_PVT.logMessage(p_module_name => l_module ,