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_ML_UPDATE_PVT dependencies on FND_API

Line 8: l_miss_char CONSTANT VARCHAR2 (1) := fnd_api.g_miss_char;

4: g_action_replace CONSTANT VARCHAR2 (30) := 'R';
5: g_procstat_valid CONSTANT VARCHAR2 (30) := 'R';
6: g_procstat_processed CONSTANT VARCHAR2 (30) := 'P';
7: g_procstat_error CONSTANT VARCHAR2 (30) := 'E';
8: l_miss_char CONSTANT VARCHAR2 (1) := fnd_api.g_miss_char;
9: l_miss_num CONSTANT NUMBER := fnd_api.g_miss_num;
10: l_miss_date CONSTANT DATE := fnd_api.g_miss_date;
11:
12: PROCEDURE populate_recs (

Line 9: l_miss_num CONSTANT NUMBER := fnd_api.g_miss_num;

5: g_procstat_valid CONSTANT VARCHAR2 (30) := 'R';
6: g_procstat_processed CONSTANT VARCHAR2 (30) := 'P';
7: g_procstat_error CONSTANT VARCHAR2 (30) := 'E';
8: l_miss_char CONSTANT VARCHAR2 (1) := fnd_api.g_miss_char;
9: l_miss_num CONSTANT NUMBER := fnd_api.g_miss_num;
10: l_miss_date CONSTANT DATE := fnd_api.g_miss_date;
11:
12: PROCEDURE populate_recs (
13: p_txn_identifier IN VARCHAR2,

Line 10: l_miss_date CONSTANT DATE := fnd_api.g_miss_date;

6: g_procstat_processed CONSTANT VARCHAR2 (30) := 'P';
7: g_procstat_error CONSTANT VARCHAR2 (30) := 'E';
8: l_miss_char CONSTANT VARCHAR2 (1) := fnd_api.g_miss_char;
9: l_miss_num CONSTANT NUMBER := fnd_api.g_miss_num;
10: l_miss_date CONSTANT DATE := fnd_api.g_miss_date;
11:
12: PROCEDURE populate_recs (
13: p_txn_identifier IN VARCHAR2,
14: p_source_system_name IN VARCHAR2,

Line 111: x_return_status := fnd_api.g_ret_sts_success;

107: price_idx PLS_INTEGER := 0;
108: asset_idx PLS_INTEGER := 0; -- Asset index
109: e_restriction EXCEPTION;
110: BEGIN
111: x_return_status := fnd_api.g_ret_sts_success;
112: x_error_message := NULL;
113:
114: FOR inst_intf_rec IN inst_intf_cur (p_txn_identifier,
115: p_source_system_name)

Line 118: IF inst_intf_rec.instance_id <> fnd_api.g_miss_num

114: FOR inst_intf_rec IN inst_intf_cur (p_txn_identifier,
115: p_source_system_name)
116: LOOP
117: -- Start code addition for bug 6368180, section 1 of 2
118: IF inst_intf_rec.instance_id <> fnd_api.g_miss_num
119: THEN
120: -- We populate the record only if it is not for creating a new instance
121: -- End code addition for bug 6368180, section 1 of 2
122: inst_idx := inst_idx + 1;

Line 629: fnd_api.g_true, -- CHECK_FOR_INSTANCE_EXPIRY

625: l_miss_char, NULL,
626: inst_intf_rec.instance_usage_code
627: ),
628: */
629: fnd_api.g_true, -- CHECK_FOR_INSTANCE_EXPIRY
630: DECODE (
631: inst_intf_rec.instance_description,
632: NULL, l_miss_char,
633: l_miss_char, NULL,

Line 2120: fnd_api.g_false, --CALL_CONTRACTS

2116: NULL, l_miss_char,
2117: l_miss_char, NULL,
2118: party_intf_rec.account1_attribute15
2119: ),
2120: fnd_api.g_false, --CALL_CONTRACTS
2121: l_miss_num --VLD_ORGANIZATION_ID
2122: INTO x_account_tbl (ptyacc_idx).party_account_id,
2123: x_account_tbl (ptyacc_idx).relationship_type_code,
2124: x_account_tbl (ptyacc_idx).bill_to_address,

Line 2300: fnd_api.g_false, --CALL_CONTRACTS

2296: NULL, l_miss_char,
2297: l_miss_char, NULL,
2298: party_intf_rec.account2_attribute15
2299: ),
2300: fnd_api.g_false, --CALL_CONTRACTS
2301: l_miss_num --VLD_ORGANIZATION_ID
2302: INTO x_account_tbl (ptyacc_idx).party_account_id,
2303: x_account_tbl (ptyacc_idx).relationship_type_code,
2304: x_account_tbl (ptyacc_idx).bill_to_address,

Line 2480: fnd_api.g_false, --CALL_CONTRACTS

2476: NULL, l_miss_char,
2477: l_miss_char, NULL,
2478: party_intf_rec.account3_attribute15
2479: ),
2480: fnd_api.g_false, --CALL_CONTRACTS
2481: l_miss_num --VLD_ORGANIZATION_ID
2482: INTO x_account_tbl (ptyacc_idx).party_account_id,
2483: x_account_tbl (ptyacc_idx).relationship_type_code,
2484: x_account_tbl (ptyacc_idx).bill_to_address,

Line 2510: party_intf_rec.contact_party_id <> fnd_api.g_miss_num

2506: FROM DUAL;
2507: END IF; ---party_account3
2508:
2509: IF party_intf_rec.contact_party_id IS NOT NULL AND
2510: party_intf_rec.contact_party_id <> fnd_api.g_miss_num
2511: THEN
2512: prty_idx:=prty_idx + 1;
2513: x_party_tbl(prty_idx).instance_party_id:=fnd_api.g_miss_num;
2514: x_party_tbl(prty_idx).instance_id:=inst_intf_rec.instance_id;

Line 2513: x_party_tbl(prty_idx).instance_party_id:=fnd_api.g_miss_num;

2509: IF party_intf_rec.contact_party_id IS NOT NULL AND
2510: party_intf_rec.contact_party_id <> fnd_api.g_miss_num
2511: THEN
2512: prty_idx:=prty_idx + 1;
2513: x_party_tbl(prty_idx).instance_party_id:=fnd_api.g_miss_num;
2514: x_party_tbl(prty_idx).instance_id:=inst_intf_rec.instance_id;
2515: x_party_tbl(prty_idx).party_source_table:=party_intf_rec.party_source_table;
2516: x_party_tbl(prty_idx).party_id:=party_intf_rec.contact_party_id;
2517: x_party_tbl(prty_idx).relationship_type_code:=party_intf_rec.contact_party_rel_type;

Line 2688: END IF; ---IF inst_intf_rec.instance_id <> fnd_api.g_miss_num

2684: asset_idx := asset_idx + 1; -- Increment asset index
2685:
2686: END LOOP; --end of asset loop
2687: -- Start code addition for bug 6368180, section 2 of 2
2688: END IF; ---IF inst_intf_rec.instance_id <> fnd_api.g_miss_num
2689: -- End code addition for bug 6368180, section 2 of 2
2690: END LOOP; ---inst_intf_cur
2691: EXCEPTION
2692: WHEN e_restriction

Line 2694: x_return_status := fnd_api.g_ret_sts_error;

2690: END LOOP; ---inst_intf_cur
2691: EXCEPTION
2692: WHEN e_restriction
2693: THEN
2694: x_return_status := fnd_api.g_ret_sts_error;
2695: x_error_message := l_error_message;
2696: WHEN OTHERS
2697: THEN
2698: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2698: x_return_status := fnd_api.g_ret_sts_unexp_error;

2694: x_return_status := fnd_api.g_ret_sts_error;
2695: x_error_message := l_error_message;
2696: WHEN OTHERS
2697: THEN
2698: x_return_status := fnd_api.g_ret_sts_unexp_error;
2699: x_error_message := SQLERRM;
2700:
2701: END populate_recs;
2702: