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.CSTPSMCW dependencies on WIP_CONSTANTS

Line 79: WHERE costed = WIP_CONSTANTS.PENDING

75: transaction_type_id,
76: organization_id,
77: transaction_date
78: FROM wsm_split_merge_transactions
79: WHERE costed = WIP_CONSTANTS.PENDING
80: AND status = WIP_CONSTANTS.COMPLETED
81: AND organization_id = p_org_id
82: AND group_id = p_group_id
83: ORDER BY transaction_date,transaction_id;

Line 80: AND status = WIP_CONSTANTS.COMPLETED

76: organization_id,
77: transaction_date
78: FROM wsm_split_merge_transactions
79: WHERE costed = WIP_CONSTANTS.PENDING
80: AND status = WIP_CONSTANTS.COMPLETED
81: AND organization_id = p_org_id
82: AND group_id = p_group_id
83: ORDER BY transaction_date,transaction_id;
84:

Line 165: SET costed = WIP_CONSTANTS.COMPLETED

161:
162: l_stmt_num := 50;
163:
164: UPDATE wsm_split_merge_transactions
165: SET costed = WIP_CONSTANTS.COMPLETED
166: WHERE transaction_type_id in (3,5,7)
167: AND costed = WIP_CONSTANTS.PENDING
168: AND status = WIP_CONSTANTS.COMPLETED
169: AND organization_id = p_org_id

Line 167: AND costed = WIP_CONSTANTS.PENDING

163:
164: UPDATE wsm_split_merge_transactions
165: SET costed = WIP_CONSTANTS.COMPLETED
166: WHERE transaction_type_id in (3,5,7)
167: AND costed = WIP_CONSTANTS.PENDING
168: AND status = WIP_CONSTANTS.COMPLETED
169: AND organization_id = p_org_id
170: AND group_id = p_group_id;
171:

Line 168: AND status = WIP_CONSTANTS.COMPLETED

164: UPDATE wsm_split_merge_transactions
165: SET costed = WIP_CONSTANTS.COMPLETED
166: WHERE transaction_type_id in (3,5,7)
167: AND costed = WIP_CONSTANTS.PENDING
168: AND status = WIP_CONSTANTS.COMPLETED
169: AND organization_id = p_org_id
170: AND group_id = p_group_id;
171:
172: l_stmt_num := 60;

Line 497: SET costed = WIP_CONSTANTS.COMPLETED

493:
494: l_stmt_num := 40;
495:
496: UPDATE wsm_split_merge_transactions txn
497: SET costed = WIP_CONSTANTS.COMPLETED
498: WHERE transaction_type_id = 4
499: AND transaction_id = l_wsmt_transaction_id /* Added for bug 5008413 */
500: AND costed = WIP_CONSTANTS.PENDING
501: AND status = WIP_CONSTANTS.COMPLETED

Line 500: AND costed = WIP_CONSTANTS.PENDING

496: UPDATE wsm_split_merge_transactions txn
497: SET costed = WIP_CONSTANTS.COMPLETED
498: WHERE transaction_type_id = 4
499: AND transaction_id = l_wsmt_transaction_id /* Added for bug 5008413 */
500: AND costed = WIP_CONSTANTS.PENDING
501: AND status = WIP_CONSTANTS.COMPLETED
502: AND EXISTS ( SELECT 'Queue Intraop'
503: FROM wsm_sm_resulting_jobs rj,
504: bom_operation_sequences bos,

Line 501: AND status = WIP_CONSTANTS.COMPLETED

497: SET costed = WIP_CONSTANTS.COMPLETED
498: WHERE transaction_type_id = 4
499: AND transaction_id = l_wsmt_transaction_id /* Added for bug 5008413 */
500: AND costed = WIP_CONSTANTS.PENDING
501: AND status = WIP_CONSTANTS.COMPLETED
502: AND EXISTS ( SELECT 'Queue Intraop'
503: FROM wsm_sm_resulting_jobs rj,
504: bom_operation_sequences bos,
505: wip_operations wo

Line 705: WIP_CONSTANTS.COMPLETED,

701:
702: /* l_err_msg is populated if the Op Yield Process fails */
703: l_stmt_num := 100;
704: l_ret_update := UPDATE_WSMT_TXN_STATUS ( l_wsmt_transaction_id,
705: WIP_CONSTANTS.COMPLETED,
706: NULL, -- Error Message
707: p_request_id,
708: l_prog_application_id,
709: l_program_id );

Line 719: WIP_CONSTANTS.ERROR,

715: l_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num)||'):' || l_err_msg || substr(SQLERRM, 1, 200);
716: FND_FILE.put_line(fnd_file.log, 'API Version Obsoleted'|| l_err_msg );
717: x_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num);
718: l_ret_update := UPDATE_WSMT_TXN_STATUS ( l_wsmt_transaction_id,
719: WIP_CONSTANTS.ERROR,
720: l_err_msg,
721: p_request_id,
722: l_prog_application_id,
723: l_program_id );

Line 732: WIP_CONSTANTS.ERROR,

728: FND_FILE.put_line(fnd_file.log, 'Unknown Transaction Type passed... Catastrophic Failure'|| l_err_msg );
729: x_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num);
730:
731: l_ret_update := UPDATE_WSMT_TXN_STATUS ( l_wsmt_transaction_id,
732: WIP_CONSTANTS.ERROR,
733: l_err_msg,
734: p_request_id,
735: l_prog_application_id,
736: l_program_id );

Line 745: WIP_CONSTANTS.ERROR,

741: l_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num)||'): ' || l_err_msg;
742: x_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num)||'):';
743: FND_FILE.put_line(fnd_file.log, 'MMT not populated with Transaction ID from WSMT'|| l_err_msg );
744: l_ret_update := UPDATE_WSMT_TXN_STATUS ( l_wsmt_transaction_id,
745: WIP_CONSTANTS.ERROR,
746: l_err_msg,
747: p_request_id,
748: l_prog_application_id,
749: l_program_id );

Line 756: WIP_CONSTANTS.ERROR,

752: x_err_code := 'Transaction Costing Failed';
753: l_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num)||'): ' || l_err_msg;
754: FND_FILE.put_line(fnd_file.log, 'Transaction Costing Failed'|| l_err_msg );
755: l_ret_update := UPDATE_WSMT_TXN_STATUS ( l_wsmt_transaction_id,
756: WIP_CONSTANTS.ERROR,
757: l_err_msg,
758: p_request_id,
759: l_prog_application_id,
760: l_program_id );

Line 768: WIP_CONSTANTS.ERROR,

764: l_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num)||'): ' || l_err_msg;
765: x_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num)||'):';
766: FND_FILE.put_line(fnd_file.log, 'Failed to Update Job Info: Transaction Costing Failed'|| l_err_msg );
767: l_ret_update := UPDATE_WSMT_TXN_STATUS ( l_wsmt_transaction_id,
768: WIP_CONSTANTS.ERROR,
769: l_err_msg,
770: p_request_id,
771: l_prog_application_id,
772: l_program_id );

Line 780: WIP_CONSTANTS.ERROR,

776: l_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num)||'): ' || l_err_msg;
777: x_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num)||'):';
778: FND_FILE.put_line(fnd_file.log, 'Update of Wip Operation Yields Failed'|| l_err_msg );
779: l_ret_update := UPDATE_WSMT_TXN_STATUS ( l_wsmt_transaction_id,
780: WIP_CONSTANTS.ERROR,
781: l_err_msg,
782: p_request_id,
783: l_prog_application_id,
784: l_program_id );

Line 792: WIP_CONSTANTS.ERROR,

788: l_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num)||'): ' || l_err_msg;
789: x_err_msg := 'CSTPSMCW.COST_LOT_TXN('||to_char(l_stmt_num)||'):';
790: FND_FILE.put_line(fnd_file.log, 'Operation Yield Costing Failed'|| l_err_msg );
791: l_ret_update := UPDATE_WSMT_TXN_STATUS ( l_wsmt_transaction_id,
792: WIP_CONSTANTS.ERROR,
793: l_err_msg,
794: p_request_id,
795: l_prog_application_id,
796: l_program_id );