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 11763: select CSI_TRANSACTIONS_S.nextval

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

Line 11766: select CSI_TRANSACTIONS_S.nextval

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

Line 12094: -- Insert one record into CSI_TRANSACTIONS

12090: END LOOP;
12091: commit;
12092: CLOSE INV_CSI_LOT_CUR;
12093: --
12094: -- Insert one record into CSI_TRANSACTIONS
12095: IF l_srl_ins_flag = 'Y' THEN
12096: INSERT INTO CSI_TRANSACTIONS(
12097: TRANSACTION_ID
12098: ,TRANSACTION_DATE

Line 12096: INSERT INTO CSI_TRANSACTIONS(

12092: CLOSE INV_CSI_LOT_CUR;
12093: --
12094: -- Insert one record into CSI_TRANSACTIONS
12095: IF l_srl_ins_flag = 'Y' THEN
12096: INSERT INTO CSI_TRANSACTIONS(
12097: TRANSACTION_ID
12098: ,TRANSACTION_DATE
12099: ,SOURCE_TRANSACTION_DATE
12100: ,SOURCE_HEADER_REF

Line 12127: INSERT INTO CSI_TRANSACTIONS(

12123: );
12124: END IF;
12125: --
12126: IF l_lot_ins_flag = 'Y' THEN
12127: INSERT INTO CSI_TRANSACTIONS(
12128: TRANSACTION_ID
12129: ,TRANSACTION_DATE
12130: ,SOURCE_TRANSACTION_DATE
12131: ,SOURCE_HEADER_REF

Line 12373: select CSI_TRANSACTIONS_S.nextval

12369: Raise Process_next;
12370: End;
12371: --
12372: Begin
12373: select CSI_TRANSACTIONS_S.nextval
12374: into v_txn_id
12375: from DUAL;
12376: End;
12377: --

Line 12379: INSERT INTO CSI_TRANSACTIONS(

12375: from DUAL;
12376: End;
12377: --
12378: Begin
12379: INSERT INTO CSI_TRANSACTIONS(
12380: TRANSACTION_ID
12381: ,TRANSACTION_DATE
12382: ,SOURCE_TRANSACTION_DATE
12383: ,SOURCE_HEADER_REF

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

12403: ,1
12404: );
12405: Exception
12406: when others then
12407: v_err_msg := 'Error while Inserting into CSI_TRANSACTIONS '||substr(sqlerrm,1,1000);
12408: raise_application_error(-20000, v_err_msg );
12409: Raise;
12410: End;
12411: --

Line 12855: select CSI_TRANSACTIONS_S.nextval

12851: Raise Process_next;
12852: End;
12853: --
12854: Begin
12855: select CSI_TRANSACTIONS_S.nextval
12856: into v_txn_id
12857: from DUAL;
12858: End;
12859: --

Line 12861: INSERT INTO CSI_TRANSACTIONS(

12857: from DUAL;
12858: End;
12859: --
12860: Begin
12861: INSERT INTO CSI_TRANSACTIONS(
12862: TRANSACTION_ID
12863: ,TRANSACTION_DATE
12864: ,SOURCE_TRANSACTION_DATE
12865: ,SOURCE_HEADER_REF

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

12885: ,1
12886: );
12887: Exception
12888: when others then
12889: v_err_msg := 'Error while Inserting into CSI_TRANSACTIONS '||substr(sqlerrm,1,1000);
12890: raise_application_error(-20000, v_err_msg );
12891: Raise;
12892: End;
12893: --

Line 13441: (SELECT '1' FROM csi_transactions

13437: SELECT 'Y'
13438: INTO l_last_rma_processed
13439: FROM sys.dual
13440: WHERE exists
13441: (SELECT '1' FROM csi_transactions
13442: WHERE inv_material_transaction_id = l_last_mtl_txn_id);
13443: EXCEPTION
13444: WHEN no_data_found THEN
13445: l_last_rma_processed := 'N';

Line 13842: select CSI_TRANSACTIONS_S.nextval

13838: ,last_vld_organization_id = organization_id_mig(i)
13839: where instance_id = v_instance_id;
13840: --
13841: Begin
13842: select CSI_TRANSACTIONS_S.nextval
13843: into v_txn_id
13844: from DUAL;
13845: End;
13846: --

Line 13848: INSERT INTO CSI_TRANSACTIONS(

13844: from DUAL;
13845: End;
13846: --
13847: Begin
13848: INSERT INTO CSI_TRANSACTIONS(
13849: TRANSACTION_ID
13850: ,TRANSACTION_DATE
13851: ,SOURCE_TRANSACTION_DATE
13852: ,SOURCE_HEADER_REF

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

13872: ,1
13873: );
13874: Exception
13875: when others then
13876: v_err_msg := 'Error while Inserting into CSI_TRANSACTIONS '||substr(sqlerrm,1,1000);
13877: raise_application_error(-20000, v_err_msg );
13878: Raise;
13879: End;
13880: -- Tie the Transaction with the instance history

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

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

Line 13917: select CSI_TRANSACTIONS_S.nextval

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

Line 13923: INSERT INTO CSI_TRANSACTIONS(

13919: from DUAL;
13920: End;
13921: --
13922: Begin
13923: INSERT INTO CSI_TRANSACTIONS(
13924: TRANSACTION_ID
13925: ,TRANSACTION_DATE
13926: ,SOURCE_TRANSACTION_DATE
13927: ,SOURCE_HEADER_REF

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

13947: ,1
13948: );
13949: Exception
13950: when others then
13951: v_err_msg := 'Error while Inserting into CSI_TRANSACTIONS '||substr(sqlerrm,1,1000);
13952: raise_application_error(-20000, v_err_msg );
13953: Raise;
13954: End;
13955: --

Line 14599: select CSI_TRANSACTIONS_S.nextval

14595: Raise comp_error;
14596: when others then
14597: Raise comp_error;
14598: End;
14599: select CSI_TRANSACTIONS_S.nextval
14600: into l_txn_id from dual;
14601: --
14602: OPEN CSI_CUR;
14603: LOOP

Line 14697: INSERT INTO CSI_TRANSACTIONS(

14693: END LOOP;
14694: CLOSE CSI_CUR;
14695: --
14696: IF l_ins_flag = 'Y' THEN
14697: INSERT INTO CSI_TRANSACTIONS(
14698: TRANSACTION_ID
14699: ,TRANSACTION_DATE
14700: ,SOURCE_TRANSACTION_DATE
14701: ,SOURCE_HEADER_REF

Line 15678: SELECT 'X' FROM csi_transactions

15674: BEGIN
15675: SELECT 'Y' INTO l_txn_processed
15676: FROM sys.dual
15677: WHERE exists (
15678: SELECT 'X' FROM csi_transactions
15679: WHERE inv_material_transaction_id = err_rec.inv_material_transaction_id);
15680:
15681: UPDATE csi_txn_errors
15682: SET processed_flag = 'D'