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.CSI_DIAGNOSTICS_PKG dependencies on CSI_TRANSACTIONS

Line 1446: SELECT csi_transactions_s.nextval

1442: END IF;
1443: -- Get the Transaction Type ID for Txn Type MIGRATED
1444: v_txn_type_id := correction_txn_type_id;
1445:
1446: SELECT csi_transactions_s.nextval
1447: INTO l_txn_id
1448: FROM sys.dual;
1449:
1450: --

Line 2776: INSERT INTO CSI_TRANSACTIONS(

2772: ,1);
2773: END IF;
2774: --
2775: IF l_instance_tbl.count > 0 THEN
2776: INSERT INTO CSI_TRANSACTIONS(
2777: TRANSACTION_ID
2778: ,TRANSACTION_DATE
2779: ,SOURCE_TRANSACTION_DATE
2780: ,SOURCE_HEADER_REF

Line 3164: csi_transactions_pvt.create_txn_error (

3160: log(' '||l_error_rec.inv_material_transaction_id||' '||l_error_rec.source_type||' '||
3161: l_error_rec.transaction_type_id||' '||p_mtl_type_id||' '||p_mtl_action_id||' '||
3162: p_mtl_source_type_id);
3163:
3164: csi_transactions_pvt.create_txn_error (
3165: p_api_version => 1.0,
3166: p_init_msg_list => fnd_api.g_true,
3167: p_commit => fnd_api.g_false,
3168: p_validation_level => fnd_api.g_valid_level_full,

Line 3448: SELECT '1' FROM csi_transactions

3444: BEGIN
3445: SELECT 'Y' INTO l_processed_flag
3446: FROM sys.dual
3447: WHERE exists(
3448: SELECT '1' FROM csi_transactions
3449: WHERE inv_material_transaction_id = wip_txn_rec.mtl_txn_id);
3450: l_processed := true;
3451: EXCEPTION
3452: WHEN no_data_found THEN

Line 3584: SELECT '1' FROM csi_transactions

3580: IF all_txn_rec.mtl_action_id in (2,3,28) THEN
3581: SELECT 'Y' INTO l_processed_flag
3582: FROM sys.dual
3583: WHERE exists(
3584: SELECT '1' FROM csi_transactions
3585: WHERE (inv_material_transaction_id = all_txn_rec.mtl_txn_id
3586: OR
3587: inv_material_transaction_id = all_txn_rec.mtl_xfer_txn_id));
3588: ELSE

Line 3592: SELECT '1' FROM csi_transactions

3588: ELSE
3589: SELECT 'Y' INTO l_processed_flag
3590: FROM sys.dual
3591: WHERE exists(
3592: SELECT '1' FROM csi_transactions
3593: WHERE inv_material_transaction_id = all_txn_rec.mtl_txn_id);
3594: END IF;
3595: l_processed := true;
3596: EXCEPTION

Line 4303: FROM csi_transactions

4299: SELECT transaction_id,
4300: transaction_type_id
4301: INTO l_csi_txn_id,
4302: l_csi_txn_type_id
4303: FROM csi_transactions
4304: WHERE (inv_material_transaction_id = txn_rec.mtl_txn_id
4305: OR
4306: inv_material_transaction_id = txn_rec.mtl_xfer_txn_id)
4307: AND rownum = 1;

Line 4313: FROM csi_transactions

4309: SELECT transaction_id,
4310: transaction_type_id
4311: INTO l_csi_txn_id,
4312: l_csi_txn_type_id
4313: FROM csi_transactions
4314: WHERE inv_material_transaction_id = txn_rec.mtl_txn_id
4315: AND rownum = 1;
4316: END IF;
4317: EXCEPTION

Line 4534: csi_transactions_pvt.create_transaction (

4530: l_txn_rec.source_transaction_date := l_err_txn_date;
4531: l_txn_rec.transaction_date := sysdate;
4532: l_txn_rec.inv_material_transaction_id := l_mtl_txn_id_tab(ind);
4533:
4534: csi_transactions_pvt.create_transaction (
4535: p_api_version => 1.0,
4536: p_commit => fnd_api.g_false,
4537: p_init_msg_list => fnd_api.g_true,
4538: p_validation_level => fnd_api.g_valid_level_full,

Line 5289: FROM csi_transactions

5285: END IF;
5286:
5287: BEGIN
5288: SELECT transaction_id INTO l_txn_rec.transaction_id
5289: FROM csi_transactions
5290: WHERE inv_material_transaction_id = missing_csi_rec.mtl_txn_id;
5291: EXCEPTION
5292: WHEN no_data_found THEN
5293:

Line 5302: csi_transactions_pvt.create_transaction (

5298: l_txn_rec.source_transaction_date := missing_csi_rec.mtl_txn_date;
5299: l_txn_rec.transaction_date := sysdate;
5300: l_txn_rec.inv_material_transaction_id := missing_csi_rec.mtl_txn_id;
5301:
5302: csi_transactions_pvt.create_transaction (
5303: p_api_version => 1.0,
5304: p_commit => fnd_api.g_false,
5305: p_init_msg_list => fnd_api.g_true,
5306: p_validation_level => fnd_api.g_valid_level_full,

Line 6032: FROM csi_transactions

6028: AND processed_flag in ('E', 'R');
6029:
6030: BEGIN
6031: SELECT transaction_id INTO l_txn_rec.transaction_id
6032: FROM csi_transactions
6033: WHERE inv_material_transaction_id = knock_rec.mtl_txn_id;
6034: EXCEPTION
6035: WHEN no_data_found THEN
6036:

Line 6045: csi_transactions_pvt.create_transaction (

6041: l_txn_rec.source_transaction_date := knock_rec.mtl_txn_date;
6042: l_txn_rec.transaction_date := sysdate;
6043: l_txn_rec.inv_material_transaction_id := knock_rec.mtl_txn_id;
6044:
6045: csi_transactions_pvt.create_transaction (
6046: p_api_version => 1.0,
6047: p_commit => fnd_api.g_false,
6048: p_init_msg_list => fnd_api.g_true,
6049: p_validation_level => fnd_api.g_valid_level_full,

Line 6098: csi_transactions_pvt.create_transaction (

6094: l_pty_accts_tbl := p_pty_accts_tbl;
6095:
6096: savepoint create_instance;
6097:
6098: csi_transactions_pvt.create_transaction (
6099: p_api_version => 1.0,
6100: p_commit => fnd_api.g_false,
6101: p_init_msg_list => fnd_api.g_true,
6102: p_validation_level => fnd_api.g_valid_level_full,

Line 6167: UPDATE csi_transactions

6163: raise fnd_api.g_exc_error;
6164: END IF;
6165:
6166: IF nvl(l_txn_rec.transaction_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
6167: UPDATE csi_transactions
6168: SET inv_material_transaction_id = null
6169: WHERE transaction_id = l_txn_rec.transaction_id;
6170: END IF;
6171:

Line 6247: csi_transactions_pvt.create_transaction (

6243: IF l_not_the_same THEN
6244:
6245: log(' not the same');
6246:
6247: csi_transactions_pvt.create_transaction (
6248: p_api_version => 1.0,
6249: p_commit => fnd_api.g_false,
6250: p_init_msg_list => fnd_api.g_true,
6251: p_validation_level => fnd_api.g_valid_level_full,

Line 6328: UPDATE csi_transactions

6324: raise fnd_api.g_exc_error;
6325: END IF;
6326:
6327: IF nvl(l_txn_rec.transaction_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
6328: UPDATE csi_transactions
6329: SET inv_material_transaction_id = null
6330: WHERE transaction_id = l_txn_rec.transaction_id;
6331: END IF;
6332:

Line 9065: SELECT 'Y' FROM csi_transactions

9061: BEGIN
9062: SELECT 'X' INTO l_txn_is_in_csi
9063: FROM sys.dual
9064: WHERE exists (
9065: SELECT 'Y' FROM csi_transactions
9066: WHERE inv_material_transaction_id = all_txn_rec.mtl_txn_id);
9067: l_txn_rec.inv_material_transaction_id := null;
9068: EXCEPTION
9069: WHEN no_data_found THEN

Line 9353: FROM csi_transactions

9349: CURSOR rma_txn_cur IS
9350: SELECT transaction_id,
9351: source_line_ref_id,
9352: inv_material_transaction_id
9353: FROM csi_transactions
9354: WHERE transaction_type_id = 53
9355: AND inv_material_transaction_id is null;
9356:
9357: l_inventory_item_id number;

Line 9409: UPDATE csi_transactions

9405: END IF;
9406: END LOOP;
9407:
9408: FORALL u_ind in 1 .. l_csi_txn_id_tab.count
9409: UPDATE csi_transactions
9410: SET inv_material_transaction_id = l_mtl_txn_id_tab(u_ind)
9411: WHERE transaction_id = l_csi_txn_id_tab(u_ind);
9412:
9413: commit;

Line 9611: DELETE FROM CSI_TRANSACTIONS WHERE transaction_id = l_txn_tbl(j);

9607: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_txn_tbl(j);
9608: FORALL j in l_txn_tbl.FIRST .. l_txn_tbl.LAST
9609: DELETE FROM CSI_I_VERSION_LABELS_H WHERE transaction_id = l_txn_tbl(j);
9610: FORALL j in l_txn_tbl.FIRST .. l_txn_tbl.LAST
9611: DELETE FROM CSI_TRANSACTIONS WHERE transaction_id = l_txn_tbl(j);
9612: END;
9613: END IF;
9614: commit;
9615: --

Line 10238: DELETE FROM CSI_TRANSACTIONS WHERE transaction_id = l_del_txn_tbl(j);

10234: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_del_txn_tbl(j);
10235: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
10236: DELETE FROM CSI_I_VERSION_LABELS_H WHERE transaction_id = l_del_txn_tbl(j);
10237: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
10238: DELETE FROM CSI_TRANSACTIONS WHERE transaction_id = l_del_txn_tbl(j);
10239: END;
10240: END IF;
10241: commit;
10242: END; -- First

Line 10735: select CSI_TRANSACTIONS_S.nextval

10731: IF l_inst_tbl.count = 0 THEN
10732: RAISE Comp_error;
10733: END IF;
10734: --
10735: select CSI_TRANSACTIONS_S.nextval
10736: into l_txn_id from dual;
10737: --
10738: INSERT INTO CSI_TRANSACTIONS(
10739: TRANSACTION_ID

Line 10738: INSERT INTO CSI_TRANSACTIONS(

10734: --
10735: select CSI_TRANSACTIONS_S.nextval
10736: into l_txn_id from dual;
10737: --
10738: INSERT INTO CSI_TRANSACTIONS(
10739: TRANSACTION_ID
10740: ,TRANSACTION_DATE
10741: ,SOURCE_TRANSACTION_DATE
10742: ,SOURCE_HEADER_REF

Line 10879: UPDATE CSI_TRANSACTIONS

10875: END LOOP;
10876: END IF;
10877: --
10878: IF px_oks_txn_inst_tbl.count > 0 THEN
10879: UPDATE CSI_TRANSACTIONS
10880: set contracts_invoked = 'Y'
10881: where transaction_id = l_txn_id;
10882: --
10883: OKS_IBINT_PUB.IB_interface

Line 11370: select CSI_TRANSACTIONS_S.nextval

11366: --
11367: commit;
11368: END IF;
11369: --
11370: select CSI_TRANSACTIONS_S.nextval
11371: into v_txn_id from dual;
11372: --
11373: OPEN CSI_CUR;
11374: LOOP

Line 11482: -- Insert one record into CSI_TRANSACTIONS

11478: commit;
11479: EXIT WHEN CSI_CUR%NOTFOUND;
11480: END LOOP;
11481: CLOSE CSI_CUR;
11482: -- Insert one record into CSI_TRANSACTIONS
11483: IF l_ins_flag = 'Y' THEN
11484: INSERT INTO CSI_TRANSACTIONS(
11485: TRANSACTION_ID
11486: ,TRANSACTION_DATE

Line 11484: INSERT INTO CSI_TRANSACTIONS(

11480: END LOOP;
11481: CLOSE CSI_CUR;
11482: -- Insert one record into CSI_TRANSACTIONS
11483: IF l_ins_flag = 'Y' THEN
11484: INSERT INTO CSI_TRANSACTIONS(
11485: TRANSACTION_ID
11486: ,TRANSACTION_DATE
11487: ,SOURCE_TRANSACTION_DATE
11488: ,SOURCE_HEADER_REF

Line 11521: UPDATE CSI_TRANSACTIONS

11517: END IF;
11518: -- Call Expire_Item_Instance wraper to Expire Contracts
11519: l_contracts_status := FND_PROFILE.VALUE('CSI_CONTRACTS_ENABLED');
11520: IF UPPER(l_contracts_status) = 'Y' THEN
11521: UPDATE CSI_TRANSACTIONS
11522: set contracts_invoked = 'Y'
11523: where transaction_id = v_txn_id;
11524: --
11525: v_request_id := 0;

Line 11764: select CSI_TRANSACTIONS_S.nextval

11760: v_err_msg := 'Unable to get the ID for Txn Type DATA_CORRECTION from CSI_TXN_TYPES';
11761: Raise comp_error;
11762: End;
11763: --
11764: select CSI_TRANSACTIONS_S.nextval
11765: into v_srl_txn_id from dual;
11766: --
11767: select CSI_TRANSACTIONS_S.nextval
11768: into v_lot_txn_id from dual;

Line 11767: select CSI_TRANSACTIONS_S.nextval

11763: --
11764: select CSI_TRANSACTIONS_S.nextval
11765: into v_srl_txn_id from dual;
11766: --
11767: select CSI_TRANSACTIONS_S.nextval
11768: into v_lot_txn_id from dual;
11769: --
11770: /* commenting the following cursors for the bug 5989350 ,Since there is
11771: no need to nullify the serial and lot number for the instances

Line 12097: -- Insert one record into CSI_TRANSACTIONS

12093: commit;
12094: CLOSE INV_CSI_LOT_CUR; */
12095: -- Commented for bug#14835893
12096: --
12097: -- Insert one record into CSI_TRANSACTIONS
12098: IF l_srl_ins_flag = 'Y' THEN
12099: INSERT INTO CSI_TRANSACTIONS(
12100: TRANSACTION_ID
12101: ,TRANSACTION_DATE

Line 12099: INSERT INTO CSI_TRANSACTIONS(

12095: -- Commented for bug#14835893
12096: --
12097: -- Insert one record into CSI_TRANSACTIONS
12098: IF l_srl_ins_flag = 'Y' THEN
12099: INSERT INTO CSI_TRANSACTIONS(
12100: TRANSACTION_ID
12101: ,TRANSACTION_DATE
12102: ,SOURCE_TRANSACTION_DATE
12103: ,SOURCE_HEADER_REF

Line 12131: INSERT INTO CSI_TRANSACTIONS(

12127: END IF;
12128: --
12129: -- Commented for bug#14835893
12130: /* IF l_lot_ins_flag = 'Y' THEN
12131: INSERT INTO CSI_TRANSACTIONS(
12132: TRANSACTION_ID
12133: ,TRANSACTION_DATE
12134: ,SOURCE_TRANSACTION_DATE
12135: ,SOURCE_HEADER_REF

Line 12378: select CSI_TRANSACTIONS_S.nextval

12374: Raise Process_next;
12375: End;
12376: --
12377: Begin
12378: select CSI_TRANSACTIONS_S.nextval
12379: into v_txn_id
12380: from DUAL;
12381: End;
12382: --

Line 12384: INSERT INTO CSI_TRANSACTIONS(

12380: from DUAL;
12381: End;
12382: --
12383: Begin
12384: INSERT INTO CSI_TRANSACTIONS(
12385: TRANSACTION_ID
12386: ,TRANSACTION_DATE
12387: ,SOURCE_TRANSACTION_DATE
12388: ,SOURCE_HEADER_REF

Line 12412: v_err_msg := 'Error while Inserting into CSI_TRANSACTIONS '||substr(sqlerrm,1,1000);

12408: ,1
12409: );
12410: Exception
12411: when others then
12412: v_err_msg := 'Error while Inserting into CSI_TRANSACTIONS '||substr(sqlerrm,1,1000);
12413: raise_application_error(-20000, v_err_msg );
12414: Raise;
12415: End;
12416: --

Line 12860: select CSI_TRANSACTIONS_S.nextval

12856: Raise Process_next;
12857: End;
12858: --
12859: Begin
12860: select CSI_TRANSACTIONS_S.nextval
12861: into v_txn_id
12862: from DUAL;
12863: End;
12864: --

Line 12866: INSERT INTO CSI_TRANSACTIONS(

12862: from DUAL;
12863: End;
12864: --
12865: Begin
12866: INSERT INTO CSI_TRANSACTIONS(
12867: TRANSACTION_ID
12868: ,TRANSACTION_DATE
12869: ,SOURCE_TRANSACTION_DATE
12870: ,SOURCE_HEADER_REF

Line 12894: v_err_msg := 'Error while Inserting into CSI_TRANSACTIONS '||substr(sqlerrm,1,1000);

12890: ,1
12891: );
12892: Exception
12893: when others then
12894: v_err_msg := 'Error while Inserting into CSI_TRANSACTIONS '||substr(sqlerrm,1,1000);
12895: raise_application_error(-20000, v_err_msg );
12896: Raise;
12897: End;
12898: --

Line 13446: (SELECT '1' FROM csi_transactions

13442: SELECT 'Y'
13443: INTO l_last_rma_processed
13444: FROM sys.dual
13445: WHERE exists
13446: (SELECT '1' FROM csi_transactions
13447: WHERE inv_material_transaction_id = l_last_mtl_txn_id);
13448: EXCEPTION
13449: WHEN no_data_found THEN
13450: l_last_rma_processed := 'N';

Line 13847: select CSI_TRANSACTIONS_S.nextval

13843: ,last_vld_organization_id = organization_id_mig(i)
13844: where instance_id = v_instance_id;
13845: --
13846: Begin
13847: select CSI_TRANSACTIONS_S.nextval
13848: into v_txn_id
13849: from DUAL;
13850: End;
13851: --

Line 13853: INSERT INTO CSI_TRANSACTIONS(

13849: from DUAL;
13850: End;
13851: --
13852: Begin
13853: INSERT INTO CSI_TRANSACTIONS(
13854: TRANSACTION_ID
13855: ,TRANSACTION_DATE
13856: ,SOURCE_TRANSACTION_DATE
13857: ,SOURCE_HEADER_REF

Line 13881: v_err_msg := 'Error while Inserting into CSI_TRANSACTIONS '||substr(sqlerrm,1,1000);

13877: ,1
13878: );
13879: Exception
13880: when others then
13881: v_err_msg := 'Error while Inserting into CSI_TRANSACTIONS '||substr(sqlerrm,1,1000);
13882: raise_application_error(-20000, v_err_msg );
13883: Raise;
13884: End;
13885: -- Tie the Transaction with the instance history

Line 13919: -- For each record, we insert a record into CSI_TRANSACTIONS. This Transaction ID will be used

13915: Raise Process_next;
13916: END IF; -- Check for instance existance
13917: --
13918: -- If instance is not found then create the INV instance
13919: -- For each record, we insert a record into CSI_TRANSACTIONS. This Transaction ID will be used
13920: -- to populate the History Record.
13921: Begin
13922: select CSI_TRANSACTIONS_S.nextval
13923: into v_txn_id

Line 13922: select CSI_TRANSACTIONS_S.nextval

13918: -- If instance is not found then create the INV instance
13919: -- For each record, we insert a record into CSI_TRANSACTIONS. This Transaction ID will be used
13920: -- to populate the History Record.
13921: Begin
13922: select CSI_TRANSACTIONS_S.nextval
13923: into v_txn_id
13924: from DUAL;
13925: End;
13926: --

Line 13928: INSERT INTO CSI_TRANSACTIONS(

13924: from DUAL;
13925: End;
13926: --
13927: Begin
13928: INSERT INTO CSI_TRANSACTIONS(
13929: TRANSACTION_ID
13930: ,TRANSACTION_DATE
13931: ,SOURCE_TRANSACTION_DATE
13932: ,SOURCE_HEADER_REF

Line 13956: v_err_msg := 'Error while Inserting into CSI_TRANSACTIONS '||substr(sqlerrm,1,1000);

13952: ,1
13953: );
13954: Exception
13955: when others then
13956: v_err_msg := 'Error while Inserting into CSI_TRANSACTIONS '||substr(sqlerrm,1,1000);
13957: raise_application_error(-20000, v_err_msg );
13958: Raise;
13959: End;
13960: --

Line 14604: select CSI_TRANSACTIONS_S.nextval

14600: Raise comp_error;
14601: when others then
14602: Raise comp_error;
14603: End;
14604: select CSI_TRANSACTIONS_S.nextval
14605: into l_txn_id from dual;
14606: --
14607: OPEN CSI_CUR;
14608: LOOP

Line 14708: INSERT INTO CSI_TRANSACTIONS(

14704: END LOOP;
14705: CLOSE CSI_CUR;
14706: --
14707: IF l_ins_flag = 'Y' THEN
14708: INSERT INTO CSI_TRANSACTIONS(
14709: TRANSACTION_ID
14710: ,TRANSACTION_DATE
14711: ,SOURCE_TRANSACTION_DATE
14712: ,SOURCE_HEADER_REF

Line 15689: SELECT 'X' FROM csi_transactions

15685: BEGIN
15686: SELECT 'Y' INTO l_txn_processed
15687: FROM sys.dual
15688: WHERE exists (
15689: SELECT 'X' FROM csi_transactions
15690: WHERE inv_material_transaction_id = err_rec.inv_material_transaction_id);
15691:
15692: UPDATE csi_txn_errors
15693: SET processed_flag = 'D'