DBA Data[Home] [Help]

APPS.CSTPSMUT dependencies on WIP_TRANSACTIONS

Line 829: x_err_msg := 'Error inserting into Wip Transactions: CSTPSMUT.COST_SPLIT_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

825: x_err_msg := 'Error Balancing Accounts: CSTPSMUT.COST_SPLIT_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
826: WHEN FAILED_INSERTING_WT THEN
827: x_err_num := -1;
828: x_err_code := 9999;
829: x_err_msg := 'Error inserting into Wip Transactions: CSTPSMUT.COST_SPLIT_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
830: WHEN FAILED_INSERTING_WTA THEN
831: x_err_num := -1;
832: x_err_code := 'Error inserting into Wip Transaction Accounts';
833: x_err_msg := 'Error inserting into Wip Transaction Accounts: CSTPSMUT.COST_SPLIT_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

Line 1686: x_err_code := 'Error inserting into Wip Transactions';

1682: x_err_code := 'Error Balancing Accounts';
1683: x_err_msg := 'Error Balancing Accounts: CSTPSMUT.COST_MERGE_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
1684: WHEN FAILED_INSERTING_WT THEN
1685: x_err_num := -1;
1686: x_err_code := 'Error inserting into Wip Transactions';
1687: x_err_msg := 'Error inserting into Wip Transactions: CSTPSMUT.COST_MERGE_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
1688: WHEN FAILED_INSERTING_WTA THEN
1689: x_err_num := -1;
1690: x_err_code := 'Error inserting into Wip Transaction Accounts';

Line 1687: x_err_msg := 'Error inserting into Wip Transactions: CSTPSMUT.COST_MERGE_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

1683: x_err_msg := 'Error Balancing Accounts: CSTPSMUT.COST_MERGE_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
1684: WHEN FAILED_INSERTING_WT THEN
1685: x_err_num := -1;
1686: x_err_code := 'Error inserting into Wip Transactions';
1687: x_err_msg := 'Error inserting into Wip Transactions: CSTPSMUT.COST_MERGE_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
1688: WHEN FAILED_INSERTING_WTA THEN
1689: x_err_num := -1;
1690: x_err_code := 'Error inserting into Wip Transaction Accounts';
1691: x_err_msg := 'Error inserting into Wip Transaction Accounts: CSTPSMUT.COST_MERGE_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

Line 2246: x_err_code := 'Error inserting into Wip Transactions';

2242: x_err_code := 'Error Balancing Accounts';
2243: x_err_msg := 'Error Balancing Accounts: CSTPSMUT.COST_UPDATE_QTY_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2244: WHEN FAILED_INSERTING_WT THEN
2245: x_err_num := -1;
2246: x_err_code := 'Error inserting into Wip Transactions';
2247: x_err_msg := 'Error inserting into Wip Transactions: CSTPSMUT.COST_UPDATE_QTY_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2248: WHEN FAILED_INSERTING_WTA THEN
2249: x_err_num := -1;
2250: x_err_code := 'Error inserting into Wip Transaction Accounts';

Line 2247: x_err_msg := 'Error inserting into Wip Transactions: CSTPSMUT.COST_UPDATE_QTY_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

2243: x_err_msg := 'Error Balancing Accounts: CSTPSMUT.COST_UPDATE_QTY_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2244: WHEN FAILED_INSERTING_WT THEN
2245: x_err_num := -1;
2246: x_err_code := 'Error inserting into Wip Transactions';
2247: x_err_msg := 'Error inserting into Wip Transactions: CSTPSMUT.COST_UPDATE_QTY_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2248: WHEN FAILED_INSERTING_WTA THEN
2249: x_err_num := -1;
2250: x_err_code := 'Error inserting into Wip Transaction Accounts';
2251: x_err_msg := 'Error inserting into Wip Transaction Accounts: CSTPSMUT.COST_UPDATE_QTY_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

Line 2812: x_err_code := 'Error inserting into Wip Transactions';

2808: x_err_code := 'Error Balancing Accounts';
2809: x_err_msg := 'Error Balancing Accounts: CSTPSMUT.COST_BONUS_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2810: WHEN FAILED_INSERTING_WT THEN
2811: x_err_num := -1;
2812: x_err_code := 'Error inserting into Wip Transactions';
2813: x_err_msg := 'Error inserting into Wip Transactions: CSTPSMUT.COST_BONUS_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2814: WHEN FAILED_INSERTING_WTA THEN
2815: x_err_num := -1;
2816: x_err_code := 'Error inserting into Wip Transaction Accounts';

Line 2813: x_err_msg := 'Error inserting into Wip Transactions: CSTPSMUT.COST_BONUS_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

2809: x_err_msg := 'Error Balancing Accounts: CSTPSMUT.COST_BONUS_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2810: WHEN FAILED_INSERTING_WT THEN
2811: x_err_num := -1;
2812: x_err_code := 'Error inserting into Wip Transactions';
2813: x_err_msg := 'Error inserting into Wip Transactions: CSTPSMUT.COST_BONUS_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2814: WHEN FAILED_INSERTING_WTA THEN
2815: x_err_num := -1;
2816: x_err_code := 'Error inserting into Wip Transaction Accounts';
2817: x_err_msg := 'Error inserting into Wip Transaction Accounts: CSTPSMUT.COST_BONUS_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

Line 2857: SELECT wip_transactions_s.nextval

2853: BEGIN
2854: l_stmt_num := 10;
2855: x_err_num := 0;
2856:
2857: SELECT wip_transactions_s.nextval
2858: INTO x_wip_txn_id
2859: FROM dual;
2860:
2861: EXCEPTION

Line 4334: INSERT INTO wip_transactions

4330: WHERE MMT.TRANSACTION_ID = p_txn_id
4331: AND MSI.INVENTORY_ITEM_ID = MMT.INVENTORY_ITEM_ID
4332: AND MSI.ORGANIZATION_ID = MMT.ORGANIZATION_ID;
4333:
4334: INSERT INTO wip_transactions
4335: (TRANSACTION_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
4336: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
4337: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,
4338: PROGRAM_UPDATE_DATE,

Line 4366: 'into wip_transactions.');

4362: l_rows_inserted := SQL%ROWCOUNT;
4363: IF (l_rows_inserted > 0 and p_debug = 'Y') THEN
4364: FND_FILE.put_line(FND_FILE.LOG,to_char(l_rows_inserted)
4365: || ' row(s) inserted ' ||
4366: 'into wip_transactions.');
4367: END IF;
4368: l_rows_inserted := 0;
4369:
4370: EXCEPTION