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

Line 18: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

14: l_stmt VARCHAR2(200);
15: l_owner_id NUMBER;
16:
17: BEGIN
18: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
19: -- Determine the Activity Type
20:
21: l_activity_type := Wf_Engine.GetItemAttrText(
22: itemtype => itemtype,

Line 30: x_return_status := Fnd_Api.G_RET_STS_ERROR;

26: IF l_activity_type NOT IN ('CAMP','CSCH','EVEH', 'EVEO', 'EONE',
27: 'DELV','OFFR') THEN -- 4378800 Added OFFR
28: Fnd_Message.Set_Name('AMS','AMS_APPR_FUNC_INVALID');
29: Fnd_Msg_Pub.ADD;
30: x_return_status := Fnd_Api.G_RET_STS_ERROR;
31: RETURN;
32: END IF;
33:
34: -- Determine the Primary Key

Line 50: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

46: x_table_name => l_table_name,
47: x_pk_name => l_pk_name);
48:
49:
50: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
51: Fnd_Message.Set_Name('AMS','AMS_APPR_FUNC_NOAPPR');
52: Fnd_Msg_Pub.ADD;
53: x_return_status := Fnd_Api.G_RET_STS_ERROR;
54: RETURN;

Line 53: x_return_status := Fnd_Api.G_RET_STS_ERROR;

49:
50: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
51: Fnd_Message.Set_Name('AMS','AMS_APPR_FUNC_NOAPPR');
52: Fnd_Msg_Pub.ADD;
53: x_return_status := Fnd_Api.G_RET_STS_ERROR;
54: RETURN;
55: END IF;
56:
57: -- Get the owner_user_id from the table

Line 86: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

82: TYPE owner_csr_type IS REF CURSOR ;
83: l_owner_details owner_csr_type;
84:
85: BEGIN
86: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
87:
88: -- Determine the Activity Type
89:
90: l_activity_type := Wf_Engine.GetItemAttrText(

Line 98: x_return_status := Fnd_Api.G_RET_STS_ERROR;

94:
95: IF l_activity_type NOT IN ('CSCH','EVEO', 'OFFR') THEN
96: Fnd_Message.Set_Name('AMS','AMS_APPR_FUNC_INVALID');
97: Fnd_Msg_Pub.ADD;
98: x_return_status := Fnd_Api.G_RET_STS_ERROR;
99: RETURN;
100: END IF;
101:
102: IF l_activity_type IN ('CSCH','EVEO') AND

Line 106: x_return_status := Fnd_Api.G_RET_STS_ERROR;

102: IF l_activity_type IN ('CSCH','EVEO') AND
103: NVL(Fnd_Profile.Value(name => 'AMS_SOURCE_FROM_PARENT'), 'N') = 'N' THEN
104: Fnd_Message.Set_Name('AMS','AMS_APPR_FUNC_INVALID');
105: Fnd_Msg_Pub.ADD;
106: x_return_status := Fnd_Api.G_RET_STS_ERROR;
107: RETURN;
108: END IF;
109:
110: -- Determine the Primary Key

Line 143: x_return_status := Fnd_Api.G_RET_STS_ERROR;

139: IF l_owner_details%NOTFOUND THEN
140: CLOSE l_owner_details;
141: Fnd_Message.Set_Name('AMS','AMS_APPR_FUNC_NOAPPR');
142: Fnd_Msg_Pub.ADD;
143: x_return_status := Fnd_Api.G_RET_STS_ERROR;
144: RETURN;
145: END IF;
146: CLOSE l_owner_details;
147:

Line 183: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

179: WHERE f.fund_id = a.budget_source_id
180: AND a.activity_budget_id = l_activity_id;
181:
182: BEGIN
183: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
184:
185: l_activity_type := Wf_Engine.GetItemAttrText(
186: itemtype => itemtype,
187: itemkey => itemkey,

Line 195: x_return_status := Fnd_Api.G_RET_STS_ERROR;

191: IF l_activity_type NOT IN ('CAMP','CSCH','EVEH', 'EVEO', 'EONE',
192: 'DELV', 'FREQ','OFFR') THEN -- 4378800 Added OFFR
193: Fnd_Message.Set_Name('AMS','AMS_APPR_FUNC_INVALID');
194: Fnd_Msg_Pub.ADD;
195: x_return_status := Fnd_Api.G_RET_STS_ERROR;
196: RETURN;
197: END IF;
198:
199: l_activity_id := Wf_Engine.GetItemAttrNumber(

Line 221: x_return_status := Fnd_Api.G_RET_STS_ERROR;

217: CLOSE c_fund_owner;
218: -- Set Message here
219: Fnd_Message.Set_Name('AMS','AMS_CAMP_BAD_FUND_SOURCE_ID');
220: Fnd_Msg_Pub.ADD;
221: x_return_status := Fnd_Api.G_RET_STS_ERROR;
222: RETURN;
223: END IF;
224: CLOSE c_fund_owner;
225:

Line 230: x_return_status := Fnd_Api.G_RET_STS_ERROR;

226: ELSE
227:
228: Fnd_Message.Set_Name('AMS','AMS_APPR_FUNC_INVALID'); -- Not Budget Line
229: Fnd_Msg_Pub.ADD;
230: x_return_status := Fnd_Api.G_RET_STS_ERROR;
231: RETURN;
232: END IF;
233:
234: ELSE -- it is FREQ

Line 243: x_return_status := Fnd_Api.G_RET_STS_ERROR;

239: CLOSE c_budget_source_owner;
240: -- Set Message here
241: Fnd_Message.Set_Name('AMS','AMS_CAMP_BAD_FUND_SOURCE_ID');
242: Fnd_Msg_Pub.ADD;
243: x_return_status := Fnd_Api.G_RET_STS_ERROR;
244: RETURN;
245: END IF;
246: CLOSE c_budget_source_owner;
247:

Line 280: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

276: WHERE activity_budget_id = l_activity_id);
277:
278:
279: BEGIN
280: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
281:
282: l_activity_type := Wf_Engine.GetItemAttrText(
283: itemtype => itemtype,
284: itemkey => itemkey,

Line 290: x_return_status := Fnd_Api.G_RET_STS_ERROR;

286:
287: IF l_activity_type NOT IN ('RFRQ', 'FREQ') THEN
288: Fnd_Message.Set_Name('AMS','AMS_APPR_FUNC_INVALID');
289: Fnd_Msg_Pub.ADD;
290: x_return_status := Fnd_Api.G_RET_STS_ERROR;
291: RETURN;
292: END IF;
293:
294: -- Determine the Budget ID

Line 308: x_return_status := Fnd_Api.G_RET_STS_ERROR;

304: IF c_parent_fund_owner%NOTFOUND THEN
305: CLOSE c_parent_fund_owner;
306: Fnd_Message.Set_Name('AMS','AMS_CAMP_BAD_FUND_SOURCE_ID');
307: Fnd_Msg_Pub.ADD;
308: x_return_status := Fnd_Api.G_RET_STS_ERROR;
309: RETURN;
310: END IF;
311: CLOSE c_parent_fund_owner;
312: ELSE

Line 319: x_return_status := Fnd_Api.G_RET_STS_ERROR;

315: IF c_budget_source_par_owner%NOTFOUND THEN
316: CLOSE c_budget_source_par_owner;
317: Fnd_Message.Set_Name('AMS','AMS_CAMP_BAD_FUND_SOURCE_ID');
318: Fnd_Msg_Pub.ADD;
319: x_return_status := Fnd_Api.G_RET_STS_ERROR;
320: RETURN;
321: END IF;
322: CLOSE c_budget_source_par_owner;
323: END IF;