DBA Data[Home] [Help]

APPS.WSM_WIP_LOT_TXN_PVT dependencies on WSMPCNST

Line 581: if l_txn_header_rec.transaction_type_id = WSMPCNST.SPLIT then

577: END IF;
578: end if;
579: End if;
580:
581: if l_txn_header_rec.transaction_type_id = WSMPCNST.SPLIT then
582:
583: /*..... invoke split.. but also do the following checks...
584: i) Only one starting job...
585: ii) Atleast one resulting job....

Line 690: elsif l_txn_header_rec.transaction_type_id = WSMPCNST.MERGE then

686: end if;
687: l_stmt_num := 55;
688:
689: /* Is it Merge ?? If yes, go ahead */
690: elsif l_txn_header_rec.transaction_type_id = WSMPCNST.MERGE then
691:
692: l_stmt_num := 60;
693:
694: if l_starting_jobs_tbl.count < 2 then

Line 777: elsif l_txn_header_rec.transaction_type_id = WSMPCNST.UPDATE_ASSEMBLY then

773:
774: end if; --End AH
775:
776: /* Is it Update Assembly ?? If yes, go ahead */
777: elsif l_txn_header_rec.transaction_type_id = WSMPCNST.UPDATE_ASSEMBLY then
778:
779: if l_starting_jobs_tbl.count <> 1 then
780: /* error out... */
781: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN

Line 859: elsif l_txn_header_rec.transaction_type_id = WSMPCNST.UPDATE_ROUTING then

855: end if;
856: end if; --End AH
857:
858: /* Is it Update Routing ?? If yes, go ahead */
859: elsif l_txn_header_rec.transaction_type_id = WSMPCNST.UPDATE_ROUTING then
860:
861: if l_starting_jobs_tbl.count <> 1 then
862: /* error out... */
863: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN

Line 939: elsif l_txn_header_rec.transaction_type_id = WSMPCNST.UPDATE_QUANTITY then

935:
936: end if; --End AH
937:
938: /* Is it Update Qty ?? If yes, go ahead */
939: elsif l_txn_header_rec.transaction_type_id = WSMPCNST.UPDATE_QUANTITY then
940:
941: if l_starting_jobs_tbl.count <> 1 then
942: /* error out... */
943: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN

Line 1020: elsif l_txn_header_rec.transaction_type_id = WSMPCNST.UPDATE_LOT_NAME then

1016: end if;
1017: end if; --End AH
1018:
1019: /* Is it Update Lot Name ?? If yes, go ahead */
1020: elsif l_txn_header_rec.transaction_type_id = WSMPCNST.UPDATE_LOT_NAME then
1021:
1022: if l_starting_jobs_tbl.count <> 1 then
1023: /* error out... */
1024: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN

Line 1101: elsif l_txn_header_rec.transaction_type_id = WSMPCNST.BONUS then

1097: end if;
1098:
1099: end if; --End AH
1100:
1101: elsif l_txn_header_rec.transaction_type_id = WSMPCNST.BONUS then
1102:
1103: if l_resulting_jobs_tbl.count <> 1 then
1104: /* error out... */
1105: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN