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

Line 32: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

28: price_idx PLS_INTEGER;
29: txn_idx PLS_INTEGER;
30: prty_contact_idx PLS_INTEGER;
31: asset_idx PLS_INTEGER; --bnarayan added for open interface
32: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
33: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
34: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
35: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
36: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

Line 33: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

29: txn_idx PLS_INTEGER;
30: prty_contact_idx PLS_INTEGER;
31: asset_idx PLS_INTEGER; --bnarayan added for open interface
32: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
33: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
34: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
35: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
36: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
37: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

Line 34: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

30: prty_contact_idx PLS_INTEGER;
31: asset_idx PLS_INTEGER; --bnarayan added for open interface
32: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
33: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
34: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
35: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
36: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
37: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
38: l_fnd_g_true VARCHAR2(1) := FND_API.G_TRUE;

Line 35: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;

31: asset_idx PLS_INTEGER; --bnarayan added for open interface
32: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
33: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
34: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
35: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
36: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
37: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
38: l_fnd_g_true VARCHAR2(1) := FND_API.G_TRUE;
39: l_api_name VARCHAR2(255) :=

Line 36: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

32: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
33: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
34: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
35: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
36: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
37: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
38: l_fnd_g_true VARCHAR2(1) := FND_API.G_TRUE;
39: l_api_name VARCHAR2(255) :=
40: 'CSI_ML_CREATE_PVT.GET_IFACE_CREATE_RECS';

Line 37: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

33: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
34: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
35: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
36: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
37: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
38: l_fnd_g_true VARCHAR2(1) := FND_API.G_TRUE;
39: l_api_name VARCHAR2(255) :=
40: 'CSI_ML_CREATE_PVT.GET_IFACE_CREATE_RECS';
41:

Line 38: l_fnd_g_true VARCHAR2(1) := FND_API.G_TRUE;

34: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
35: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
36: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
37: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
38: l_fnd_g_true VARCHAR2(1) := FND_API.G_TRUE;
39: l_api_name VARCHAR2(255) :=
40: 'CSI_ML_CREATE_PVT.GET_IFACE_CREATE_RECS';
41:
42: l_sql_error VARCHAR2(2000);

Line 1399: r_prty.contact_party_id <> fnd_api.g_miss_num

1395: -- Added the following code to handle contacts.
1396: -- If contact_party_id is passed then I assume
1397: -- a contact should be created for the party.
1398: IF r_prty.contact_party_id IS NOT NULL AND
1399: r_prty.contact_party_id <> fnd_api.g_miss_num
1400: THEN
1401: prty_idx:=prty_idx + 1;
1402: p_party_tbl(prty_idx).instance_party_id:=fnd_api.g_miss_num;
1403: p_party_tbl(prty_idx).instance_id:=fnd_api.g_miss_num;

Line 1402: p_party_tbl(prty_idx).instance_party_id:=fnd_api.g_miss_num;

1398: IF r_prty.contact_party_id IS NOT NULL AND
1399: r_prty.contact_party_id <> fnd_api.g_miss_num
1400: THEN
1401: prty_idx:=prty_idx + 1;
1402: p_party_tbl(prty_idx).instance_party_id:=fnd_api.g_miss_num;
1403: p_party_tbl(prty_idx).instance_id:=fnd_api.g_miss_num;
1404: p_party_tbl(prty_idx).party_source_table:=r_prty.party_source_table;
1405: p_party_tbl(prty_idx).party_id:=r_prty.contact_party_id;
1406: p_party_tbl(prty_idx).relationship_type_code:=r_prty.contact_party_rel_type;

Line 1403: p_party_tbl(prty_idx).instance_id:=fnd_api.g_miss_num;

1399: r_prty.contact_party_id <> fnd_api.g_miss_num
1400: THEN
1401: prty_idx:=prty_idx + 1;
1402: p_party_tbl(prty_idx).instance_party_id:=fnd_api.g_miss_num;
1403: p_party_tbl(prty_idx).instance_id:=fnd_api.g_miss_num;
1404: p_party_tbl(prty_idx).party_source_table:=r_prty.party_source_table;
1405: p_party_tbl(prty_idx).party_id:=r_prty.contact_party_id;
1406: p_party_tbl(prty_idx).relationship_type_code:=r_prty.contact_party_rel_type;
1407: p_party_tbl(prty_idx).contact_flag:='Y';

Line 2507: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2503: x_error_message OUT NOCOPY VARCHAR2) IS
2504:
2505: rel_idx PLS_INTEGER;
2506: txn_idx PLS_INTEGER;
2507: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2508: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2509: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2510: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
2511: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

Line 2508: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

2504:
2505: rel_idx PLS_INTEGER;
2506: txn_idx PLS_INTEGER;
2507: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2508: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2509: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2510: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
2511: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
2512: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

Line 2509: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

2505: rel_idx PLS_INTEGER;
2506: txn_idx PLS_INTEGER;
2507: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2508: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2509: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2510: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
2511: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
2512: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
2513: l_fnd_g_true VARCHAR2(1) := FND_API.G_TRUE;

Line 2510: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;

2506: txn_idx PLS_INTEGER;
2507: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2508: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2509: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2510: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
2511: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
2512: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
2513: l_fnd_g_true VARCHAR2(1) := FND_API.G_TRUE;
2514: l_api_name VARCHAR2(255) :=

Line 2511: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

2507: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2508: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2509: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2510: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
2511: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
2512: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
2513: l_fnd_g_true VARCHAR2(1) := FND_API.G_TRUE;
2514: l_api_name VARCHAR2(255) :=
2515: 'CSI_ML_CREATE_PVT.GET_IFACE_REL_RECS';

Line 2512: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

2508: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2509: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2510: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
2511: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
2512: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
2513: l_fnd_g_true VARCHAR2(1) := FND_API.G_TRUE;
2514: l_api_name VARCHAR2(255) :=
2515: 'CSI_ML_CREATE_PVT.GET_IFACE_REL_RECS';
2516:

Line 2513: l_fnd_g_true VARCHAR2(1) := FND_API.G_TRUE;

2509: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2510: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
2511: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
2512: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
2513: l_fnd_g_true VARCHAR2(1) := FND_API.G_TRUE;
2514: l_api_name VARCHAR2(255) :=
2515: 'CSI_ML_CREATE_PVT.GET_IFACE_REL_RECS';
2516:
2517: l_sql_error VARCHAR2(2000);