DBA Data[Home] [Help]

APPS.AMS_APPROVAL_UTIL_PVT dependencies on FND_MSG_PUB

Line 29: Fnd_Msg_Pub.ADD;

25:
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:

Line 52: Fnd_Msg_Pub.ADD;

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;
55: END IF;
56:

Line 97: Fnd_Msg_Pub.ADD;

93: aname => 'AMS_ACTIVITY_TYPE');
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:

Line 105: Fnd_Msg_Pub.ADD;

101:
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:

Line 142: Fnd_Msg_Pub.ADD;

138: FETCH l_owner_details INTO l_owner_id;
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;

Line 194: Fnd_Msg_Pub.ADD;

190:
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:

Line 220: Fnd_Msg_Pub.ADD;

216: IF c_fund_owner%NOTFOUND THEN
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;

Line 229: Fnd_Msg_Pub.ADD;

225:
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:

Line 242: Fnd_Msg_Pub.ADD;

238: IF c_budget_source_owner%NOTFOUND THEN
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;

Line 289: Fnd_Msg_Pub.ADD;

285: aname => 'AMS_ACTIVITY_TYPE');
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:

Line 307: Fnd_Msg_Pub.ADD;

303: FETCH c_parent_fund_owner INTO l_owner_id;
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;

Line 318: Fnd_Msg_Pub.ADD;

314: FETCH c_budget_source_par_owner INTO l_owner_id;
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;