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_fnd_g_false VARCHAR2(1) := FND_API.G_FALSE; --bug#13072088

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_fnd_g_false VARCHAR2(1) := FND_API.G_FALSE; --bug#13072088
40: l_api_name VARCHAR2(255) :=

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_fnd_g_false VARCHAR2(1) := FND_API.G_FALSE; --bug#13072088
40: l_api_name VARCHAR2(255) :=
41: 'CSI_ML_CREATE_PVT.GET_IFACE_CREATE_RECS';

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_fnd_g_false VARCHAR2(1) := FND_API.G_FALSE; --bug#13072088
40: l_api_name VARCHAR2(255) :=
41: 'CSI_ML_CREATE_PVT.GET_IFACE_CREATE_RECS';
42:

Line 39: l_fnd_g_false VARCHAR2(1) := FND_API.G_FALSE; --bug#13072088

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_fnd_g_false VARCHAR2(1) := FND_API.G_FALSE; --bug#13072088
40: l_api_name VARCHAR2(255) :=
41: 'CSI_ML_CREATE_PVT.GET_IFACE_CREATE_RECS';
42:
43: l_sql_error VARCHAR2(2000);

Line 1417: r_prty.contact_party_id <> fnd_api.g_miss_num

1413: -- Added the following code to handle contacts.
1414: -- If contact_party_id is passed then I assume
1415: -- a contact should be created for the party.
1416: IF r_prty.contact_party_id IS NOT NULL AND
1417: r_prty.contact_party_id <> fnd_api.g_miss_num
1418: THEN
1419: prty_idx:=prty_idx + 1;
1420: p_party_tbl(prty_idx).instance_party_id:=fnd_api.g_miss_num;
1421: p_party_tbl(prty_idx).instance_id:=fnd_api.g_miss_num;

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

1416: IF r_prty.contact_party_id IS NOT NULL AND
1417: r_prty.contact_party_id <> fnd_api.g_miss_num
1418: THEN
1419: prty_idx:=prty_idx + 1;
1420: p_party_tbl(prty_idx).instance_party_id:=fnd_api.g_miss_num;
1421: p_party_tbl(prty_idx).instance_id:=fnd_api.g_miss_num;
1422: p_party_tbl(prty_idx).party_source_table:=r_prty.party_source_table;
1423: p_party_tbl(prty_idx).party_id:=r_prty.contact_party_id;
1424: p_party_tbl(prty_idx).relationship_type_code:=r_prty.contact_party_rel_type;

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

1417: r_prty.contact_party_id <> fnd_api.g_miss_num
1418: THEN
1419: prty_idx:=prty_idx + 1;
1420: p_party_tbl(prty_idx).instance_party_id:=fnd_api.g_miss_num;
1421: p_party_tbl(prty_idx).instance_id:=fnd_api.g_miss_num;
1422: p_party_tbl(prty_idx).party_source_table:=r_prty.party_source_table;
1423: p_party_tbl(prty_idx).party_id:=r_prty.contact_party_id;
1424: p_party_tbl(prty_idx).relationship_type_code:=r_prty.contact_party_rel_type;
1425: p_party_tbl(prty_idx).contact_flag:='Y';

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

2521: x_error_message OUT NOCOPY VARCHAR2) IS
2522:
2523: rel_idx PLS_INTEGER;
2524: txn_idx PLS_INTEGER;
2525: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2526: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2527: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2528: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
2529: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

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

2522:
2523: rel_idx PLS_INTEGER;
2524: txn_idx PLS_INTEGER;
2525: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2526: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2527: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2528: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
2529: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
2530: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

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

2523: rel_idx PLS_INTEGER;
2524: txn_idx PLS_INTEGER;
2525: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2526: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2527: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2528: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
2529: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
2530: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
2531: l_fnd_g_true VARCHAR2(1) := FND_API.G_TRUE;

Line 2528: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;

2524: txn_idx PLS_INTEGER;
2525: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2526: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2527: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2528: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
2529: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
2530: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
2531: l_fnd_g_true VARCHAR2(1) := FND_API.G_TRUE;
2532: l_api_name VARCHAR2(255) :=

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

2525: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2526: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2527: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2528: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
2529: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
2530: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
2531: l_fnd_g_true VARCHAR2(1) := FND_API.G_TRUE;
2532: l_api_name VARCHAR2(255) :=
2533: 'CSI_ML_CREATE_PVT.GET_IFACE_REL_RECS';

Line 2530: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

2526: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2527: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2528: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
2529: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
2530: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
2531: l_fnd_g_true VARCHAR2(1) := FND_API.G_TRUE;
2532: l_api_name VARCHAR2(255) :=
2533: 'CSI_ML_CREATE_PVT.GET_IFACE_REL_RECS';
2534:

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

2527: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2528: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
2529: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
2530: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
2531: l_fnd_g_true VARCHAR2(1) := FND_API.G_TRUE;
2532: l_api_name VARCHAR2(255) :=
2533: 'CSI_ML_CREATE_PVT.GET_IFACE_REL_RECS';
2534:
2535: l_sql_error VARCHAR2(2000);