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.AS_TCA_PVT dependencies on FND_API

Line 28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

24: --
25: -- NOTES:
26: --
27: PROCEDURE Validate_party_id (
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29: p_party_id IN NUMBER,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_msg_count OUT NOCOPY NUMBER,
32: x_msg_data OUT NOCOPY VARCHAR2

Line 47: IF FND_API.to_Boolean(p_init_msg_list) THEN

43: BEGIN
44:
45: -- initialize message list if p_init_msg_list is set to TRUE;
46:
47: IF FND_API.to_Boolean(p_init_msg_list) THEN
48: FND_MSG_PUB.initialize;
49: END IF;
50:
51: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 51: l_return_status := FND_API.G_RET_STS_SUCCESS;

47: IF FND_API.to_Boolean(p_init_msg_list) THEN
48: FND_MSG_PUB.initialize;
49: END IF;
50:
51: l_return_status := FND_API.G_RET_STS_SUCCESS;
52: open C_Party_Exists(p_party_id);
53: fetch C_Party_Exists into l_val;
54: IF (C_Party_Exists%NOTFOUND) THEN
55: x_return_status := FND_API.G_RET_STS_ERROR;

Line 55: x_return_status := FND_API.G_RET_STS_ERROR;

51: l_return_status := FND_API.G_RET_STS_SUCCESS;
52: open C_Party_Exists(p_party_id);
53: fetch C_Party_Exists into l_val;
54: IF (C_Party_Exists%NOTFOUND) THEN
55: x_return_status := FND_API.G_RET_STS_ERROR;
56: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
57: THEN
58: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
59: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);

Line 81: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

77: --
78: -- NOTES:
79: --
80: PROCEDURE Validate_party_site_id (
81: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
82: p_party_id IN NUMBER,
83: p_party_site_id IN NUMBER,
84: x_return_status OUT NOCOPY VARCHAR2,
85: x_msg_count OUT NOCOPY NUMBER,

Line 102: IF FND_API.to_Boolean(p_init_msg_list) THEN

98: BEGIN
99:
100: -- initialize message list if p_init_msg_list is set to TRUE;
101:
102: IF FND_API.to_Boolean(p_init_msg_list) THEN
103: FND_MSG_PUB.initialize;
104: END IF;
105:
106: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 106: l_return_status := FND_API.G_RET_STS_SUCCESS;

102: IF FND_API.to_Boolean(p_init_msg_list) THEN
103: FND_MSG_PUB.initialize;
104: END IF;
105:
106: l_return_status := FND_API.G_RET_STS_SUCCESS;
107: open C_Party_Site_Exists(p_party_id, p_party_site_id);
108: fetch C_Party_Site_Exists into l_val;
109: IF (C_Party_Site_Exists%NOTFOUND) THEN
110: x_return_status := FND_API.G_RET_STS_ERROR;

Line 110: x_return_status := FND_API.G_RET_STS_ERROR;

106: l_return_status := FND_API.G_RET_STS_SUCCESS;
107: open C_Party_Site_Exists(p_party_id, p_party_site_id);
108: fetch C_Party_Site_Exists into l_val;
109: IF (C_Party_Site_Exists%NOTFOUND) THEN
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
112: THEN
113: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
114: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_SITE_ID', FALSE);

Line 134: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

130: --
131: -- NOTES:
132: --
133: PROCEDURE Validate_contact_point_id (
134: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
135: p_party_id IN NUMBER,
136: p_org_contact_id IN NUMBER,
137: p_contact_point_id IN NUMBER,
138: x_return_status OUT NOCOPY VARCHAR2,

Line 163: IF FND_API.to_Boolean(p_init_msg_list) THEN

159: BEGIN
160:
161: -- initialize message list if p_init_msg_list is set to TRUE;
162:
163: IF FND_API.to_Boolean(p_init_msg_list) THEN
164: FND_MSG_PUB.initialize;
165: END IF;
166:
167: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 167: l_return_status := FND_API.G_RET_STS_SUCCESS;

163: IF FND_API.to_Boolean(p_init_msg_list) THEN
164: FND_MSG_PUB.initialize;
165: END IF;
166:
167: l_return_status := FND_API.G_RET_STS_SUCCESS;
168:
169: If(p_org_contact_id is NULL) then
170: open C_Party_Cnt_Point_Exists(p_party_id, p_contact_point_id);
171: fetch C_Party_Cnt_Point_Exists into l_val;

Line 173: x_return_status := FND_API.G_RET_STS_ERROR;

169: If(p_org_contact_id is NULL) then
170: open C_Party_Cnt_Point_Exists(p_party_id, p_contact_point_id);
171: fetch C_Party_Cnt_Point_Exists into l_val;
172: IF (C_Party_Cnt_Point_Exists%NOTFOUND) THEN
173: x_return_status := FND_API.G_RET_STS_ERROR;
174: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
175: THEN
176: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
177: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);

Line 186: x_return_status := FND_API.G_RET_STS_ERROR;

182: elsIf(p_party_id is NULL)then
183: open C_Org_Contact_Cnt_Point_Exists(p_org_contact_id, p_contact_point_id);
184: fetch C_Org_Contact_Cnt_Point_Exists into l_val;
185: IF (C_Org_Contact_Cnt_Point_Exists%NOTFOUND) THEN
186: x_return_status := FND_API.G_RET_STS_ERROR;
187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
188: THEN
189: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
190: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT_ID', FALSE);

Line 196: x_return_status := FND_API.G_RET_STS_ERROR;

192: END IF;
193: END IF;
194: close C_Org_Contact_Cnt_Point_Exists;
195: else
196: x_return_status := FND_API.G_RET_STS_ERROR;
197: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
198: THEN
199: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
200: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);

Line 223: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

219: --
220: -- NOTES:
221: --
222: PROCEDURE Validate_contact_id (
223: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
224: p_party_id IN NUMBER,
225: p_contact_id IN NUMBER,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,

Line 244: IF FND_API.to_Boolean(p_init_msg_list) THEN

240: BEGIN
241:
242: -- initialize message list if p_init_msg_list is set to TRUE;
243:
244: IF FND_API.to_Boolean(p_init_msg_list) THEN
245: FND_MSG_PUB.initialize;
246: END IF;
247:
248: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 248: l_return_status := FND_API.G_RET_STS_SUCCESS;

244: IF FND_API.to_Boolean(p_init_msg_list) THEN
245: FND_MSG_PUB.initialize;
246: END IF;
247:
248: l_return_status := FND_API.G_RET_STS_SUCCESS;
249: open C_Contact_Exists(p_contact_id, p_party_id);
250: fetch C_Contact_Exists into l_val;
251: IF (C_Contact_Exists%NOTFOUND) THEN
252: x_return_status := FND_API.G_RET_STS_ERROR;

Line 252: x_return_status := FND_API.G_RET_STS_ERROR;

248: l_return_status := FND_API.G_RET_STS_SUCCESS;
249: open C_Contact_Exists(p_contact_id, p_party_id);
250: fetch C_Contact_Exists into l_val;
251: IF (C_Contact_Exists%NOTFOUND) THEN
252: x_return_status := FND_API.G_RET_STS_ERROR;
253: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
254: THEN
255: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
256: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);