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 2113: fnd_api.g_false, --CALL_CONTRACTS

2109: NULL, l_miss_char,
2110: l_miss_char, NULL,
2111: party_intf_rec.account1_attribute15
2112: ),
2113: fnd_api.g_false, --CALL_CONTRACTS
2114: l_miss_num --VLD_ORGANIZATION_ID
2115: INTO x_account_tbl (ptyacc_idx).party_account_id,
2116: x_account_tbl (ptyacc_idx).relationship_type_code,
2117: x_account_tbl (ptyacc_idx).bill_to_address,

Line 2293: fnd_api.g_false, --CALL_CONTRACTS

2289: NULL, l_miss_char,
2290: l_miss_char, NULL,
2291: party_intf_rec.account2_attribute15
2292: ),
2293: fnd_api.g_false, --CALL_CONTRACTS
2294: l_miss_num --VLD_ORGANIZATION_ID
2295: INTO x_account_tbl (ptyacc_idx).party_account_id,
2296: x_account_tbl (ptyacc_idx).relationship_type_code,
2297: x_account_tbl (ptyacc_idx).bill_to_address,

Line 2473: fnd_api.g_false, --CALL_CONTRACTS

2469: NULL, l_miss_char,
2470: l_miss_char, NULL,
2471: party_intf_rec.account3_attribute15
2472: ),
2473: fnd_api.g_false, --CALL_CONTRACTS
2474: l_miss_num --VLD_ORGANIZATION_ID
2475: INTO x_account_tbl (ptyacc_idx).party_account_id,
2476: x_account_tbl (ptyacc_idx).relationship_type_code,
2477: x_account_tbl (ptyacc_idx).bill_to_address,

Line 2503: party_intf_rec.contact_party_id <> fnd_api.g_miss_num

2499: FROM DUAL;
2500: END IF; ---party_account3
2501:
2502: IF party_intf_rec.contact_party_id IS NOT NULL AND
2503: party_intf_rec.contact_party_id <> fnd_api.g_miss_num
2504: THEN
2505: prty_idx:=prty_idx + 1;
2506: x_party_tbl(prty_idx).instance_party_id:=fnd_api.g_miss_num;
2507: x_party_tbl(prty_idx).instance_id:=inst_intf_rec.instance_id;

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

2502: IF party_intf_rec.contact_party_id IS NOT NULL AND
2503: party_intf_rec.contact_party_id <> fnd_api.g_miss_num
2504: THEN
2505: prty_idx:=prty_idx + 1;
2506: x_party_tbl(prty_idx).instance_party_id:=fnd_api.g_miss_num;
2507: x_party_tbl(prty_idx).instance_id:=inst_intf_rec.instance_id;
2508: x_party_tbl(prty_idx).party_source_table:=party_intf_rec.party_source_table;
2509: x_party_tbl(prty_idx).party_id:=party_intf_rec.contact_party_id;
2510: x_party_tbl(prty_idx).relationship_type_code:=party_intf_rec.contact_party_rel_type;

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

2677: asset_idx := asset_idx + 1; -- Increment asset index
2678:
2679: END LOOP; --end of asset loop
2680: -- Start code addition for bug 6368180, section 2 of 2
2681: END IF; ---IF inst_intf_rec.instance_id <> fnd_api.g_miss_num
2682: -- End code addition for bug 6368180, section 2 of 2
2683: END LOOP; ---inst_intf_cur
2684: EXCEPTION
2685: WHEN e_restriction

Line 2687: x_return_status := fnd_api.g_ret_sts_error;

2683: END LOOP; ---inst_intf_cur
2684: EXCEPTION
2685: WHEN e_restriction
2686: THEN
2687: x_return_status := fnd_api.g_ret_sts_error;
2688: x_error_message := l_error_message;
2689: WHEN OTHERS
2690: THEN
2691: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2691: x_return_status := fnd_api.g_ret_sts_unexp_error;

2687: x_return_status := fnd_api.g_ret_sts_error;
2688: x_error_message := l_error_message;
2689: WHEN OTHERS
2690: THEN
2691: x_return_status := fnd_api.g_ret_sts_unexp_error;
2692: x_error_message := SQLERRM;
2693:
2694: END populate_recs;
2695: