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.GMF_ACTUAL_COST_ADJUSTMENT_PUB dependencies on FND_MSG_PUB

Line 29: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ;

25: /*******************
26: * Global Variables *
27: *******************/
28: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMF_ACTUAL_COST_ADJUSTMENT_PUB';
29: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ;
30: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold;
31: G_header_logged VARCHAR2(1) := 'N';
32:
33: /**************************************************************

Line 30: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold;

26: * Global Variables *
27: *******************/
28: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMF_ACTUAL_COST_ADJUSTMENT_PUB';
29: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ;
30: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold;
31: G_header_logged VARCHAR2(1) := 'N';
32:
33: /**************************************************************
34: * PROCEDURE *

Line 56: FND_MSG_PUB.Add;

52: IS
53: BEGIN
54: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
55: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
56: FND_MSG_PUB.Add;
57: END log_msg ;
58:
59: /**************************************************************
60: * PROCEDURE *

Line 95: FND_MSG_PUB.Add;

91: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', p_adjustment_rec.period_code);
92: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID', p_adjustment_rec.cost_cmpntcls_id);
93: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_CODE', p_adjustment_rec.cost_cmpntcls_code);
94: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE', p_adjustment_rec.cost_analysis_code);
95: FND_MSG_PUB.Add;
96: END IF;
97: END ADD_RECORD_TO_ERROR_STACK;
98:
99: /**************************************************************

Line 145: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

141:
142: IF P_OPERATION IN ('INSERT', 'UPDATE', 'DELETE', 'GET')
143: THEN
144: IF p_adjustment_rec.cost_adjust_id IS NOT NULL AND P_OPERATION = 'INSERT' THEN
145: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
146: THEN
147: log_msg('Resetting Cost Adjust Id to NULL for Operation: ' || P_OPERATION);
148: END IF;
149: p_adjustment_rec.cost_adjust_id := NULL;

Line 175: FND_MSG_PUB.Add;

171: END;
172: IF l_adjust_status = 1 AND P_OPERATION IN ('UPDATE', 'DELETE')
173: THEN
174: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_APPLIED');
175: FND_MSG_PUB.Add;
176: RAISE FND_API.G_EXC_ERROR;
177: END IF;
178: IF (p_adjustment_rec.organization_id IS NOT NULL OR p_adjustment_rec.organization_code IS NOT NULL)
179: AND (p_adjustment_rec.cost_type_id IS NOT NULL OR p_adjustment_rec.cost_mthd_code IS NOT NULL)

Line 183: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

179: AND (p_adjustment_rec.cost_type_id IS NOT NULL OR p_adjustment_rec.cost_mthd_code IS NOT NULL)
180: AND (p_adjustment_rec.inventory_item_id IS NOT NULL OR p_adjustment_rec.item_number IS NOT NULL)
181: AND (p_adjustment_rec.period_id IS NOT NULL OR (p_adjustment_rec.calendar_code IS NOT NULL AND p_adjustment_rec.period_code IS NOT NULL))
182: THEN
183: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
184: THEN
185: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_HEADER_KEYS');
186: FND_MSG_PUB.Add;
187: END IF;

Line 186: FND_MSG_PUB.Add;

182: THEN
183: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
184: THEN
185: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_HEADER_KEYS');
186: FND_MSG_PUB.Add;
187: END IF;
188: END IF;
189: ELSE
190: IF (p_adjustment_rec.period_id = FND_API.G_MISS_NUM) OR (p_adjustment_rec.period_id IS NULL)

Line 197: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

193: * Cost Type Validation *
194: ***********************/
195: IF (p_adjustment_rec.cost_type_id <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.cost_type_id IS NOT NULL)
196: THEN
197: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
198: THEN
199: log_msg('Validating Cost Type Id : ' || p_adjustment_rec.cost_type_id);
200: END IF;
201: IF NOT gmf_validations_pvt.validate_cost_type_id (p_adjustment_rec.cost_type_id, 'A')

Line 205: FND_MSG_PUB.Add;

201: IF NOT gmf_validations_pvt.validate_cost_type_id (p_adjustment_rec.cost_type_id, 'A')
202: THEN
203: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE_ID');
204: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID', p_adjustment_rec.cost_type_id);
205: FND_MSG_PUB.Add;
206: RAISE FND_API.G_EXC_ERROR;
207: END IF;
208: IF (p_adjustment_rec.cost_mthd_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.cost_mthd_code IS NOT NULL)
209: THEN

Line 210: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

206: RAISE FND_API.G_EXC_ERROR;
207: END IF;
208: IF (p_adjustment_rec.cost_mthd_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.cost_mthd_code IS NOT NULL)
209: THEN
210: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
211: THEN
212: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');
213: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_adjustment_rec.cost_mthd_code);
214: FND_MSG_PUB.Add;

Line 214: FND_MSG_PUB.Add;

210: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
211: THEN
212: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');
213: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_adjustment_rec.cost_mthd_code);
214: FND_MSG_PUB.Add;
215: END IF;
216: END IF;
217: ELSIF (p_adjustment_rec.cost_mthd_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.cost_mthd_code IS NOT NULL)
218: THEN

Line 222: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

218: THEN
219: /************************
220: * Convert Code into ID. *
221: ************************/
222: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
223: THEN
224: log_msg('Validating Cost Type Code : ' || p_adjustment_rec.cost_mthd_code);
225: END IF;
226: p_adjustment_rec.cost_type_id := GMF_VALIDATIONS_PVT.Validate_Cost_type_code(p_adjustment_rec.cost_mthd_code, 'A');

Line 227: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

223: THEN
224: log_msg('Validating Cost Type Code : ' || p_adjustment_rec.cost_mthd_code);
225: END IF;
226: p_adjustment_rec.cost_type_id := GMF_VALIDATIONS_PVT.Validate_Cost_type_code(p_adjustment_rec.cost_mthd_code, 'A');
227: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
228: THEN
229: log_msg('Cost Type Id : ' || p_adjustment_rec.cost_type_id);
230: END IF;
231: IF p_adjustment_rec.cost_type_id IS NULL

Line 235: FND_MSG_PUB.Add;

231: IF p_adjustment_rec.cost_type_id IS NULL
232: THEN
233: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE');
234: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_adjustment_rec.cost_mthd_code);
235: FND_MSG_PUB.Add;
236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238: ELSE
239: FND_MESSAGE.SET_NAME('GMF','GMF_API_COST_TYPE_ID_REQ');

Line 240: FND_MSG_PUB.Add;

236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238: ELSE
239: FND_MESSAGE.SET_NAME('GMF','GMF_API_COST_TYPE_ID_REQ');
240: FND_MSG_PUB.Add;
241: RAISE FND_API.G_EXC_ERROR;
242: END IF;
243: ELSE
244: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

Line 244: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

240: FND_MSG_PUB.Add;
241: RAISE FND_API.G_EXC_ERROR;
242: END IF;
243: ELSE
244: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
245: THEN
246: log_msg('Skipping Cost Type validation since Period Id is passed');
247: END IF;
248: END IF;

Line 254: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

250: * Organization Validation *
251: **************************/
252: IF ((p_adjustment_rec.organization_id <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.organization_id IS NOT NULL))
253: THEN
254: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
255: THEN
256: log_msg('Validating Organization Id : ' || p_adjustment_rec.organization_id);
257: END IF;
258: IF NOT gmf_validations_pvt.validate_organization_id(p_adjustment_rec.organization_id)

Line 262: FND_MSG_PUB.Add;

258: IF NOT gmf_validations_pvt.validate_organization_id(p_adjustment_rec.organization_id)
259: THEN
260: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_ID');
261: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);
262: FND_MSG_PUB.Add;
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265: IF (p_adjustment_rec.organization_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.organization_code IS NOT NULL)
266: THEN

Line 267: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265: IF (p_adjustment_rec.organization_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.organization_code IS NOT NULL)
266: THEN
267: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
268: THEN
269: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');
270: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', p_adjustment_rec.organization_code);
271: FND_MSG_PUB.Add;

Line 271: FND_MSG_PUB.Add;

267: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
268: THEN
269: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');
270: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', p_adjustment_rec.organization_code);
271: FND_MSG_PUB.Add;
272: END IF;
273: END IF;
274: ELSIF ((p_adjustment_rec.organization_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.organization_code IS NOT NULL))
275: THEN

Line 276: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

272: END IF;
273: END IF;
274: ELSIF ((p_adjustment_rec.organization_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.organization_code IS NOT NULL))
275: THEN
276: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
277: THEN
278: log_msg('Validating Organization Code : ' || p_adjustment_rec.organization_code);
279: END IF;
280: p_adjustment_rec.organization_id := gmf_validations_pvt.validate_organization_code(p_adjustment_rec.organization_code);

Line 281: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

277: THEN
278: log_msg('Validating Organization Code : ' || p_adjustment_rec.organization_code);
279: END IF;
280: p_adjustment_rec.organization_id := gmf_validations_pvt.validate_organization_code(p_adjustment_rec.organization_code);
281: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
282: THEN
283: log_msg('Organization id : ' || p_adjustment_rec.organization_id);
284: END IF;
285: IF p_adjustment_rec.organization_id IS NULL

Line 289: FND_MSG_PUB.Add;

285: IF p_adjustment_rec.organization_id IS NULL
286: THEN
287: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_CODE');
288: FND_MESSAGE.SET_TOKEN('ORG_CODE', p_adjustment_rec.organization_code);
289: FND_MSG_PUB.Add;
290: RAISE FND_API.G_EXC_ERROR;
291: END IF;
292: ELSE
293: FND_MESSAGE.SET_NAME('GMF','GMF_API_ORGANIZATION_ID_REQ');

Line 294: FND_MSG_PUB.Add;

290: RAISE FND_API.G_EXC_ERROR;
291: END IF;
292: ELSE
293: FND_MESSAGE.SET_NAME('GMF','GMF_API_ORGANIZATION_ID_REQ');
294: FND_MSG_PUB.Add;
295: RAISE FND_API.G_EXC_ERROR;
296: END IF;
297: /******************
298: * Item Validation *

Line 302: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

298: * Item Validation *
299: ******************/
300: IF (p_adjustment_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.inventory_item_id IS NOT NULL)
301: THEN
302: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
303: THEN
304: log_msg('Validating Inventory Item Id : ' || p_adjustment_rec.inventory_item_id);
305: END IF;
306: IF NOT GMF_VALIDATIONS_PVT.Validate_inventory_item_Id(p_adjustment_rec.inventory_item_id, p_adjustment_rec.organization_id)

Line 311: FND_MSG_PUB.Add;

307: THEN
308: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_ID');
309: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_adjustment_rec.inventory_item_id);
310: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);
311: FND_MSG_PUB.Add;
312: RAISE FND_API.G_EXC_ERROR;
313: END IF;
314: IF (p_adjustment_rec.item_number <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.item_number IS NOT NULL)
315: THEN

Line 316: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

312: RAISE FND_API.G_EXC_ERROR;
313: END IF;
314: IF (p_adjustment_rec.item_number <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.item_number IS NOT NULL)
315: THEN
316: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
317: THEN
318: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ITEM_NO');
319: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_adjustment_rec.item_number);
320: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);

Line 321: FND_MSG_PUB.Add;

317: THEN
318: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ITEM_NO');
319: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_adjustment_rec.item_number);
320: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);
321: FND_MSG_PUB.Add;
322: END IF;
323: END IF;
324: ELSIF (p_adjustment_rec.item_number <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.item_number IS NOT NULL)
325: THEN

Line 326: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

322: END IF;
323: END IF;
324: ELSIF (p_adjustment_rec.item_number <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.item_number IS NOT NULL)
325: THEN
326: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
327: THEN
328: log_msg('Validating Item Number : ' || p_adjustment_rec.item_number);
329: END IF;
330: p_adjustment_rec.inventory_item_id := GMF_VALIDATIONS_PVT.Validate_Item_Number(p_adjustment_rec.item_number, p_adjustment_rec.organization_id);

Line 331: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

327: THEN
328: log_msg('Validating Item Number : ' || p_adjustment_rec.item_number);
329: END IF;
330: p_adjustment_rec.inventory_item_id := GMF_VALIDATIONS_PVT.Validate_Item_Number(p_adjustment_rec.item_number, p_adjustment_rec.organization_id);
331: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
332: THEN
333: log_msg('Inventory Item id : ' || p_adjustment_rec.inventory_item_id);
334: END IF;
335: IF p_adjustment_rec.inventory_item_id IS NULL

Line 340: FND_MSG_PUB.Add;

336: THEN
337: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_NO');
338: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_adjustment_rec.item_number);
339: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);
340: FND_MSG_PUB.Add;
341: RAISE FND_API.G_EXC_ERROR;
342: END IF;
343: ELSE
344: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_ID_REQ');

Line 345: FND_MSG_PUB.Add;

341: RAISE FND_API.G_EXC_ERROR;
342: END IF;
343: ELSE
344: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_ID_REQ');
345: FND_MSG_PUB.Add;
346: RAISE FND_API.G_EXC_ERROR;
347: END IF;
348: /********************
349: * Period Validation *

Line 353: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

349: * Period Validation *
350: ********************/
351: IF (p_adjustment_rec.period_id <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.period_id IS NOT NULL)
352: THEN
353: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
354: THEN
355: log_msg('Validating Period Id : ' || p_adjustment_rec.Period_id);
356: END IF;
357: IF NOT gmf_validations_pvt.validate_period_id(p_adjustment_rec.period_id, p_adjustment_rec.cost_type_id)

Line 361: FND_MSG_PUB.Add;

357: IF NOT gmf_validations_pvt.validate_period_id(p_adjustment_rec.period_id, p_adjustment_rec.cost_type_id)
358: THEN
359: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_PERIOD_ID');
360: FND_MESSAGE.SET_TOKEN('PERIOD_ID', p_adjustment_rec.period_id);
361: FND_MSG_PUB.Add;
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;
364: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
365: THEN

Line 364: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

360: FND_MESSAGE.SET_TOKEN('PERIOD_ID', p_adjustment_rec.period_id);
361: FND_MSG_PUB.Add;
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;
364: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
365: THEN
366: log_msg('Cost Type Id fetched based on Period Id is: '||p_adjustment_rec.cost_type_id);
367: END IF;
368: IF ((p_adjustment_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.calendar_code IS NOT NULL))

Line 371: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

367: END IF;
368: IF ((p_adjustment_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.calendar_code IS NOT NULL))
369: AND ((p_adjustment_rec.period_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.period_code IS NOT NULL))
370: THEN
371: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
372: THEN
373: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');
374: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_adjustment_rec.calendar_code);
375: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', p_adjustment_rec.period_code);

Line 376: FND_MSG_PUB.Add;

372: THEN
373: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');
374: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_adjustment_rec.calendar_code);
375: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', p_adjustment_rec.period_code);
376: FND_MSG_PUB.Add;
377: END IF;
378: END IF;
379: ELSIF (p_adjustment_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.calendar_code IS NOT NULL)
380: AND ((p_adjustment_rec.period_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.period_code IS NOT NULL))

Line 385: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

381: THEN
382: /************************
383: * Convert Code into ID. *
384: ************************/
385: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
386: THEN
387: log_msg('Validating Calendar Code : ' || p_adjustment_rec.calendar_code||', Period Code : '||p_adjustment_rec.period_code);
388: END IF;
389: p_adjustment_rec.period_id := GMF_VALIDATIONS_PVT.Validate_period_code(p_adjustment_rec.organization_id, p_adjustment_rec.calendar_code, p_adjustment_rec.period_code, p_adjustment_rec.cost_type_id);

Line 390: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

386: THEN
387: log_msg('Validating Calendar Code : ' || p_adjustment_rec.calendar_code||', Period Code : '||p_adjustment_rec.period_code);
388: END IF;
389: p_adjustment_rec.period_id := GMF_VALIDATIONS_PVT.Validate_period_code(p_adjustment_rec.organization_id, p_adjustment_rec.calendar_code, p_adjustment_rec.period_code, p_adjustment_rec.cost_type_id);
390: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
391: THEN
392: log_msg('Period Id : ' || p_adjustment_rec.period_id);
393: END IF;
394: IF p_adjustment_rec.period_id IS NULL

Line 399: FND_MSG_PUB.Add;

395: THEN
396: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CLDR_PERIOD');
397: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',p_adjustment_rec.calendar_code);
398: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_adjustment_rec.period_code);
399: FND_MSG_PUB.Add;
400: RAISE FND_API.G_EXC_ERROR;
401: END IF;
402: ELSE
403: FND_MESSAGE.SET_NAME('GMF','GMF_API_PERIOD_REQ');

Line 404: FND_MSG_PUB.Add;

400: RAISE FND_API.G_EXC_ERROR;
401: END IF;
402: ELSE
403: FND_MESSAGE.SET_NAME('GMF','GMF_API_PERIOD_REQ');
404: FND_MSG_PUB.Add;
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407: END IF;
408: /**********************************

Line 413: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

409: * Cost Component Class Validation *
410: **********************************/
411: IF (p_adjustment_rec.cost_cmpntcls_id <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.cost_cmpntcls_id IS NOT NULL)
412: THEN
413: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
414: THEN
415: log_msg('Validating Cost Component Class ID :'|| p_adjustment_rec.cost_cmpntcls_id);
416: END IF;
417: IF NOT GMF_VALIDATIONS_PVT.Validate_Cost_Cmpntcls_Id (p_adjustment_rec.cost_cmpntcls_id)

Line 421: FND_MSG_PUB.Add;

417: IF NOT GMF_VALIDATIONS_PVT.Validate_Cost_Cmpntcls_Id (p_adjustment_rec.cost_cmpntcls_id)
418: THEN
419: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNTCLS_ID');
420: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',p_adjustment_rec.cost_cmpntcls_id);
421: FND_MSG_PUB.Add;
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;
424: IF (p_adjustment_rec.cost_cmpntcls_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.cost_cmpntcls_code IS NOT NULL)
425: THEN

Line 426: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

422: RAISE FND_API.G_EXC_ERROR;
423: END IF;
424: IF (p_adjustment_rec.cost_cmpntcls_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.cost_cmpntcls_code IS NOT NULL)
425: THEN
426: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
427: THEN
428: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_CMPNTCLS_CODE');
429: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE', p_adjustment_rec.cost_cmpntcls_code);
430: FND_MSG_PUB.Add;

Line 430: FND_MSG_PUB.Add;

426: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
427: THEN
428: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_CMPNTCLS_CODE');
429: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE', p_adjustment_rec.cost_cmpntcls_code);
430: FND_MSG_PUB.Add;
431: END IF;
432: END IF;
433: ELSIF (p_adjustment_rec.cost_cmpntcls_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.cost_cmpntcls_code IS NOT NULL)
434: THEN

Line 435: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

431: END IF;
432: END IF;
433: ELSIF (p_adjustment_rec.cost_cmpntcls_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.cost_cmpntcls_code IS NOT NULL)
434: THEN
435: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
436: THEN
437: log_msg('Validating Cost Component Class Code : ' || p_adjustment_rec.cost_cmpntcls_code);
438: END IF;
439: p_adjustment_rec.cost_cmpntcls_id := GMF_VALIDATIONS_PVT.Validate_Cost_Cmpntcls_Code (p_adjustment_rec.cost_cmpntcls_code);

Line 440: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

436: THEN
437: log_msg('Validating Cost Component Class Code : ' || p_adjustment_rec.cost_cmpntcls_code);
438: END IF;
439: p_adjustment_rec.cost_cmpntcls_id := GMF_VALIDATIONS_PVT.Validate_Cost_Cmpntcls_Code (p_adjustment_rec.cost_cmpntcls_code);
440: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
441: THEN
442: log_msg('Component Class Id := ' || p_adjustment_rec.cost_cmpntcls_id);
443: END IF;
444: IF p_adjustment_rec.cost_cmpntcls_id IS NULL

Line 448: FND_MSG_PUB.Add;

444: IF p_adjustment_rec.cost_cmpntcls_id IS NULL
445: THEN
446: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNTCLS_CODE');
447: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE', p_adjustment_rec.cost_cmpntcls_code);
448: FND_MSG_PUB.Add;
449: RAISE FND_API.G_EXC_ERROR;
450: END IF;
451: ELSE
452: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_ID_REQ');

Line 453: FND_MSG_PUB.Add;

449: RAISE FND_API.G_EXC_ERROR;
450: END IF;
451: ELSE
452: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_ID_REQ');
453: FND_MSG_PUB.Add;
454: RAISE FND_API.G_EXC_ERROR;
455: END IF;
456: /***************************
457: * Analysis Code Validation *

Line 461: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

457: * Analysis Code Validation *
458: ***************************/
459: IF (p_adjustment_rec.cost_analysis_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.cost_analysis_code IS NOT NULL)
460: THEN
461: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
462: THEN
463: log_msg('Validating Cost Analysis code :' || p_adjustment_rec.cost_analysis_code);
464: END IF;
465: IF NOT GMF_VALIDATIONS_PVT.Validate_Analysis_Code(p_adjustment_rec.cost_analysis_code)

Line 469: FND_MSG_PUB.Add;

465: IF NOT GMF_VALIDATIONS_PVT.Validate_Analysis_Code(p_adjustment_rec.cost_analysis_code)
466: THEN
467: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ANALYSIS_CODE');
468: FND_MESSAGE.SET_TOKEN('ANALYSIS_CODE', p_adjustment_rec.cost_analysis_code);
469: FND_MSG_PUB.Add;
470: RAISE FND_API.G_EXC_ERROR;
471: END IF;
472: ELSE
473: FND_MESSAGE.SET_NAME('GMF','GMF_API_ANALYSIS_CODE_REQ');

Line 474: FND_MSG_PUB.Add;

470: RAISE FND_API.G_EXC_ERROR;
471: END IF;
472: ELSE
473: FND_MESSAGE.SET_NAME('GMF','GMF_API_ANALYSIS_CODE_REQ');
474: FND_MSG_PUB.Add;
475: RAISE FND_API.G_EXC_ERROR;
476: END IF;
477: /***********************************
478: * Adjustment Indicator Validation *

Line 482: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

478: * Adjustment Indicator Validation *
479: ***********************************/
480: IF (p_adjustment_rec.adjustment_ind <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.adjustment_ind IS NOT NULL)
481: THEN
482: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
483: THEN
484: log_msg('Validating Adjustment Indicator : ' || p_adjustment_rec.adjustment_ind );
485: END IF;
486: IF p_adjustment_rec.adjustment_ind NOT IN (0, 1, 2)

Line 490: FND_MSG_PUB.Add;

486: IF p_adjustment_rec.adjustment_ind NOT IN (0, 1, 2)
487: THEN
488: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ADJ_IND');
489: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_IND',p_adjustment_rec.adjustment_ind);
490: FND_MSG_PUB.Add;
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493: ELSE
494: FND_MESSAGE.SET_NAME('GMF','GMF_API_ADJ_IND_REQ');

Line 495: FND_MSG_PUB.Add;

491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493: ELSE
494: FND_MESSAGE.SET_NAME('GMF','GMF_API_ADJ_IND_REQ');
495: FND_MSG_PUB.Add;
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498: IF P_OPERATION IN ('INSERT', 'UPDATE') THEN
499: /************************

Line 504: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

500: * Adjust UOM Validation *
501: ************************/
502: IF (p_adjustment_rec.adjust_qty_uom <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.adjust_qty_uom IS NOT NULL)
503: THEN
504: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
505: THEN
506: log_msg('Validating Adjust Qty UOM :' || p_adjustment_rec.adjust_qty_uom);
507: END IF;
508: IF NOT GMF_VALIDATIONS_PVT.Validate_same_class_Uom(p_adjustment_rec.adjust_qty_uom, p_adjustment_rec.inventory_item_id, p_adjustment_rec.organization_id)

Line 512: FND_MSG_PUB.Add;

508: IF NOT GMF_VALIDATIONS_PVT.Validate_same_class_Uom(p_adjustment_rec.adjust_qty_uom, p_adjustment_rec.inventory_item_id, p_adjustment_rec.organization_id)
509: THEN
510: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_UM');
511: FND_MESSAGE.SET_TOKEN('ITEM_UOM', p_adjustment_rec.adjust_qty_uom);
512: FND_MSG_PUB.Add;
513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515: ELSE
516: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_UM_REQ');

Line 517: FND_MSG_PUB.Add;

513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515: ELSE
516: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_UM_REQ');
517: FND_MSG_PUB.Add;
518: RAISE FND_API.G_EXC_ERROR;
519: END IF;
520: /*****************************
521: * Adjustment Cost validation *

Line 525: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

521: * Adjustment Cost validation *
522: *****************************/
523: IF P_OPERATION IN ('UPDATE', 'INSERT')
524: THEN
525: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
526: THEN
527: log_msg('Validating Adjustment Cost');
528: END IF;
529: IF p_adjustment_rec.adjust_cost IS NULL

Line 532: FND_MSG_PUB.Add;

528: END IF;
529: IF p_adjustment_rec.adjust_cost IS NULL
530: THEN
531: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_ADJ_COST');
532: FND_MSG_PUB.Add;
533: RAISE FND_API.G_EXC_ERROR;
534: END IF;
535: END IF;
536: /*************************

Line 541: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

537: * Reason Code Validation *
538: *************************/
539: IF ((p_adjustment_rec.reason_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.reason_code IS NOT NULL))
540: THEN
541: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
542: THEN
543: log_msg('Validating Reason Code: ' || p_adjustment_rec.reason_code );
544: END IF;
545: BEGIN

Line 557: FND_MSG_PUB.Add;

553: WHEN NO_DATA_FOUND
554: THEN
555: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_REASON_CODE');
556: FND_MESSAGE.SET_TOKEN('REASON_CODE',p_adjustment_rec.reason_code);
557: FND_MSG_PUB.Add;
558: RAISE FND_API.G_EXC_ERROR;
559: END;
560: ELSE
561: FND_MESSAGE.SET_NAME('GMF','GMF_API_REASON_CODE_REQ');

Line 562: FND_MSG_PUB.Add;

558: RAISE FND_API.G_EXC_ERROR;
559: END;
560: ELSE
561: FND_MESSAGE.SET_NAME('GMF','GMF_API_REASON_CODE_REQ');
562: FND_MSG_PUB.Add;
563: RAISE FND_API.G_EXC_ERROR;
564: END IF;
565: IF (p_adjustment_rec.delete_mark <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.delete_mark IS NOT NULL)
566: THEN

Line 567: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

563: RAISE FND_API.G_EXC_ERROR;
564: END IF;
565: IF (p_adjustment_rec.delete_mark <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.delete_mark IS NOT NULL)
566: THEN
567: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
568: THEN
569: log_msg('Validating Delete_mark : ' || p_adjustment_rec.delete_mark);
570: END IF;
571: IF p_adjustment_rec.delete_mark NOT IN (0,1)

Line 576: FND_MSG_PUB.Add;

572: THEN
573: add_record_to_error_stack(p_adjustment_rec);
574: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_DELETE_MARK');
575: FND_MESSAGE.SET_TOKEN('DELETE_MARK',p_adjustment_rec.delete_mark);
576: FND_MSG_PUB.Add;
577: RAISE FND_API.G_EXC_ERROR;
578: END IF;
579: ELSIF (p_adjustment_rec.delete_mark = FND_API.G_MISS_NUM AND p_operation IN ('UPDATE', 'INSERT'))
580: THEN

Line 583: FND_MSG_PUB.Add;

579: ELSIF (p_adjustment_rec.delete_mark = FND_API.G_MISS_NUM AND p_operation IN ('UPDATE', 'INSERT'))
580: THEN
581: add_record_to_error_stack(p_adjustment_rec);
582: FND_MESSAGE.SET_NAME('GMF','GMF_API_DELETE_MARK_REQ');
583: FND_MSG_PUB.Add;
584: RAISE FND_API.G_EXC_ERROR;
585: END IF;
586: IF ((p_operation IN ('UPDATE','INSERT')) AND (p_adjustment_rec.delete_mark = 1))
587: THEN

Line 590: FND_MSG_PUB.Add;

586: IF ((p_operation IN ('UPDATE','INSERT')) AND (p_adjustment_rec.delete_mark = 1))
587: THEN
588: add_record_to_error_stack(p_adjustment_rec);
589: FND_MESSAGE.SET_NAME('GMF','GMF_API_CANT_MARK_FOR_PURGE');
590: FND_MSG_PUB.Add;
591: RAISE FND_API.G_EXC_ERROR;
592: END IF;
593: /***********************************
594: * Subledger Indicator Validation *

Line 598: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

594: * Subledger Indicator Validation *
595: ***********************************/
596: IF (p_adjustment_rec.subledger_ind <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.subledger_ind IS NOT NULL)
597: THEN
598: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
599: THEN
600: log_msg('Validating Subledger Ind : ' || p_adjustment_rec.subledger_ind );
601: END IF;
602: IF p_adjustment_rec.subledger_ind NOT IN (0,1)

Line 606: FND_MSG_PUB.Add;

602: IF p_adjustment_rec.subledger_ind NOT IN (0,1)
603: THEN
604: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_SUBLEDGER_IND');
605: FND_MESSAGE.SET_TOKEN('SUBLEDGER_IND',p_adjustment_rec.subledger_ind);
606: FND_MSG_PUB.Add;
607: RAISE FND_API.G_EXC_ERROR;
608: ELSE
609: /*****************************
610: * Adjustment Date Validation *

Line 612: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

608: ELSE
609: /*****************************
610: * Adjustment Date Validation *
611: *****************************/
612: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
613: THEN
614: log_msg('Validating Adjustment date : ' || p_adjustment_rec.adjustment_date );
615: END IF;
616: IF p_adjustment_rec.adjustment_date IS NULL

Line 619: FND_MSG_PUB.Add;

615: END IF;
616: IF p_adjustment_rec.adjustment_date IS NULL
617: THEN
618: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_DATE_DEFAULT');
619: FND_MSG_PUB.Add;
620: BEGIN
621: SELECT start_date
622: INTO p_adjustment_rec.adjustment_date
623: FROM gmf_period_statuses

Line 645: FND_MSG_PUB.Add;

641: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ACA_DATE');
642: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DATE',p_adjustment_rec.adjustment_date);
643: FND_MESSAGE.SET_TOKEN('START_DATE', l_start_date);
644: FND_MESSAGE.SET_TOKEN('END_DATE', l_end_date);
645: FND_MSG_PUB.Add;
646: RAISE FND_API.G_EXC_ERROR;
647: END IF;
648: END IF;
649: END IF;

Line 652: FND_MSG_PUB.Add;

648: END IF;
649: END IF;
650: ELSE
651: FND_MESSAGE.SET_NAME('GMF','GMF_API_SUBLEDGER_IND_REQ');
652: FND_MSG_PUB.Add;
653: RAISE FND_API.G_EXC_ERROR;
654: END IF;
655: END IF;
656: /**********************

Line 661: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

657: * Username Validation *
658: **********************/
659: IF (p_adjustment_rec.user_name <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.user_name IS NOT NULL)
660: THEN
661: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
662: THEN
663: log_msg('Validating user name : ' || p_adjustment_rec.user_name);
664: END IF;
665: GMA_GLOBAL_GRP.Get_who (

Line 673: FND_MSG_PUB.Add;

669: IF x_user_id = -1
670: THEN
671: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_USER_NAME');
672: FND_MESSAGE.SET_TOKEN('USER_NAME',p_adjustment_rec.user_name);
673: FND_MSG_PUB.Add;
674: RAISE FND_API.G_EXC_ERROR;
675: END IF;
676: ELSE
677: FND_MESSAGE.SET_NAME('GMF','GMF_API_USER_NAME_REQ');

Line 678: FND_MSG_PUB.Add;

674: RAISE FND_API.G_EXC_ERROR;
675: END IF;
676: ELSE
677: FND_MESSAGE.SET_NAME('GMF','GMF_API_USER_NAME_REQ');
678: FND_MSG_PUB.Add;
679: RAISE FND_API.G_EXC_ERROR;
680: END IF;
681: /***************************
682: * Adjustment ID validation *

Line 695: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

691: AND (p_adjustment_rec.cost_cmpntcls_id IS NOT NULL OR p_adjustment_rec.cost_cmpntcls_code IS NOT NULL)
692: AND p_adjustment_rec.cost_analysis_code IS NOT NULL
693: AND p_adjustment_rec.adjustment_ind IS NOT NULL
694: THEN
695: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
696: THEN
697: log_msg(' Fetching Cost Adjust ID for Code Combination for ' ||
698: ' Organization ' || p_adjustment_rec.Organization_id ||
699: ' Cost Type Id ' || p_adjustment_rec.cost_type_id ||

Line 727: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

723: l_adjust_status := NULL;
724: END;
725: IF p_adjustment_rec.cost_adjust_id IS NULL
726: THEN
727: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
728: THEN
729: log_msg( ' Cost Adjust ID for Code Combination for ' ||
730: ' Organization ' || p_adjustment_rec.Organization_id ||
731: ' Cost Type Id ' || p_adjustment_rec.cost_type_id ||

Line 740: FND_MSG_PUB.Add;

736: ' Adjustment Indicator ' || p_adjustment_rec.adjustment_ind ||
737: ' for '|| p_operation || ' Does''nt Exist');
738: END IF;
739: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_ADJUST_ID_NULL');
740: FND_MSG_PUB.Add;
741: RAISE FND_API.G_EXC_ERROR;
742: END IF;
743: IF l_adjust_status = 1
744: THEN

Line 746: FND_MSG_PUB.Add;

742: END IF;
743: IF l_adjust_status = 1
744: THEN
745: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_APPLIED');
746: FND_MSG_PUB.Add;
747: RAISE FND_API.G_EXC_ERROR;
748: END IF;
749: END IF;
750: END IF;

Line 817: FND_MSG_PUB.initialize;

813: * Initialize message list if p_init_msg_list is set to TRUE. *
814: *************************************************************/
815: IF FND_API.to_Boolean( p_init_msg_list )
816: THEN
817: FND_MSG_PUB.initialize;
818: END IF;
819:
820: /*************************************************
821: * Standard call to check for call compatibility. *

Line 840: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

836: ******************************************/
837: x_return_status := FND_API.G_RET_STS_SUCCESS;
838: G_header_logged := 'N';
839:
840: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
841: THEN
842: log_msg('Beginning Public Create Actual Cost Adjustment API');
843: END IF;
844: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

Line 844: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

840: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
841: THEN
842: log_msg('Beginning Public Create Actual Cost Adjustment API');
843: END IF;
844: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
845: THEN
846: log_msg('Validating input parameters');
847: END IF;
848: VALIDATE_INPUT_PARAMS

Line 855: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

851: p_operation => 'INSERT',
852: x_user_id => l_user_id,
853: x_return_status => l_return_status
854: );
855: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
856: THEN
857: log_msg('Return Status after validating : ' || l_return_status);
858: END IF;
859: IF l_return_status = FND_API.G_RET_STS_ERROR

Line 863: FND_MSG_PUB.Add;

859: IF l_return_status = FND_API.G_RET_STS_ERROR
860: THEN
861: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
862: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
863: FND_MSG_PUB.Add;
864: RAISE FND_API.G_EXC_ERROR;
865: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
866: THEN
867: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );

Line 869: FND_MSG_PUB.Add;

865: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
866: THEN
867: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
868: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
869: FND_MSG_PUB.Add;
870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
871: END IF;
872: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
873: THEN

Line 872: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

868: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
869: FND_MSG_PUB.Add;
870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
871: END IF;
872: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
873: THEN
874: log_msg('Calling private API to insert record...');
875: END IF;
876: /*************************

Line 892: FND_MSG_PUB.Add;

888: IF l_return_status = FND_API.G_RET_STS_ERROR
889: THEN
890: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
891: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
892: FND_MSG_PUB.Add;
893: RAISE FND_API.G_EXC_ERROR;
894: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
895: THEN
896: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );

Line 898: FND_MSG_PUB.Add;

894: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
895: THEN
896: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
897: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
898: FND_MSG_PUB.Add;
899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
900: END IF;
901: /******************************
902: * Standard check of p_commit. *

Line 911: FND_MSG_PUB.Count_And_Get

907: END IF;
908: /**************************************************************************
909: * Standard call to get message count and if count is 1, get message info. *
910: **************************************************************************/
911: FND_MSG_PUB.Count_And_Get
912: (
913: p_count => x_msg_count,
914: p_data => x_msg_data
915: );

Line 922: FND_MSG_PUB.Count_And_Get

918: THEN
919: ROLLBACK TO CREATE_ACT_COST_ADJUSTMENT_PUB;
920: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
921: x_return_status := FND_API.G_RET_STS_ERROR ;
922: FND_MSG_PUB.Count_And_Get
923: (
924: p_count => x_msg_count,
925: p_data => x_msg_data
926: );

Line 932: FND_MSG_PUB.Count_And_Get

928: THEN
929: ROLLBACK TO CREATE_ACT_COST_ADJUSTMENT_PUB;
930: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
932: FND_MSG_PUB.Count_And_Get
933: (
934: p_count => x_msg_count,
935: p_data => x_msg_data
936: );

Line 942: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

938: THEN
939: ROLLBACK TO CREATE_ACT_COST_ADJUSTMENT_PUB;
940: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
942: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
943: THEN
944: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
945: END IF;
946: FND_MSG_PUB.Count_And_Get

Line 944: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

940: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
942: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
943: THEN
944: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
945: END IF;
946: FND_MSG_PUB.Count_And_Get
947: (
948: p_count => x_msg_count,

Line 946: FND_MSG_PUB.Count_And_Get

942: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
943: THEN
944: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
945: END IF;
946: FND_MSG_PUB.Count_And_Get
947: (
948: p_count => x_msg_count,
949: p_data => x_msg_data
950: );

Line 1017: FND_MSG_PUB.initialize;

1013: * Initialize message list if p_init_msg_list is set to TRUE. *
1014: *************************************************************/
1015: IF FND_API.to_Boolean( p_init_msg_list )
1016: THEN
1017: FND_MSG_PUB.initialize;
1018: END IF;
1019:
1020: /*************************************************
1021: * Standard call to check for call compatibility. *

Line 1040: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1036: ******************************************/
1037: x_return_status := FND_API.G_RET_STS_SUCCESS;
1038: G_header_logged := 'N';
1039:
1040: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1041: THEN
1042: log_msg('Beginning Public Update Actual Cost Adjustment API');
1043: END IF;
1044:

Line 1045: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1041: THEN
1042: log_msg('Beginning Public Update Actual Cost Adjustment API');
1043: END IF;
1044:
1045: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1046: THEN
1047: log_msg('Validating input parameters');
1048: END IF;
1049:

Line 1058: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1054: x_user_id => l_user_id,
1055: x_return_status => l_return_status
1056: );
1057:
1058: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1059: THEN
1060: log_msg('Return Status after validating : ' || l_return_status);
1061: END IF;
1062: IF l_return_status = FND_API.G_RET_STS_ERROR

Line 1066: FND_MSG_PUB.Add;

1062: IF l_return_status = FND_API.G_RET_STS_ERROR
1063: THEN
1064: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1065: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1066: FND_MSG_PUB.Add;
1067: RAISE FND_API.G_EXC_ERROR;
1068: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1069: THEN
1070: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );

Line 1072: FND_MSG_PUB.Add;

1068: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1069: THEN
1070: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1071: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1072: FND_MSG_PUB.Add;
1073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1074: END IF;
1075: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1076: THEN

Line 1075: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1071: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1072: FND_MSG_PUB.Add;
1073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1074: END IF;
1075: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1076: THEN
1077: log_msg('Calling private API to update record...');
1078: END IF;
1079: /*************************

Line 1095: FND_MSG_PUB.Add;

1091: IF l_return_status = FND_API.G_RET_STS_ERROR
1092: THEN
1093: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1094: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1095: FND_MSG_PUB.Add;
1096: RAISE FND_API.G_EXC_ERROR;
1097: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1098: THEN
1099: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );

Line 1101: FND_MSG_PUB.Add;

1097: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1098: THEN
1099: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1100: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1101: FND_MSG_PUB.Add;
1102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1103: END IF;
1104: /******************************
1105: * Standard check of p_commit. *

Line 1114: FND_MSG_PUB.Count_And_Get

1110: END IF;
1111: /**************************************************************************
1112: * Standard call to get message count and if count is 1, get message info. *
1113: **************************************************************************/
1114: FND_MSG_PUB.Count_And_Get
1115: (
1116: p_count => x_msg_count,
1117: p_data => x_msg_data
1118: );

Line 1125: FND_MSG_PUB.Count_And_Get

1121: THEN
1122: ROLLBACK TO UPDATE_ACT_COST_ADJUSTMENT_PUB;
1123: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1124: x_return_status := FND_API.G_RET_STS_ERROR ;
1125: FND_MSG_PUB.Count_And_Get
1126: (
1127: p_count => x_msg_count,
1128: p_data => x_msg_data
1129: );

Line 1135: FND_MSG_PUB.Count_And_Get

1131: THEN
1132: ROLLBACK TO UPDATE_ACT_COST_ADJUSTMENT_PUB;
1133: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1135: FND_MSG_PUB.Count_And_Get
1136: (
1137: p_count => x_msg_count,
1138: p_data => x_msg_data
1139: );

Line 1145: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1141: THEN
1142: ROLLBACK TO UPDATE_ACT_COST_ADJUSTMENT_PUB;
1143: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1145: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1146: THEN
1147: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1148: END IF;
1149: FND_MSG_PUB.Count_And_Get

Line 1147: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

1143: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1145: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1146: THEN
1147: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1148: END IF;
1149: FND_MSG_PUB.Count_And_Get
1150: (
1151: p_count => x_msg_count,

Line 1149: FND_MSG_PUB.Count_And_Get

1145: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1146: THEN
1147: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1148: END IF;
1149: FND_MSG_PUB.Count_And_Get
1150: (
1151: p_count => x_msg_count,
1152: p_data => x_msg_data
1153: );

Line 1220: FND_MSG_PUB.initialize;

1216: * Initialize message list if p_init_msg_list is set to TRUE. *
1217: *************************************************************/
1218: IF FND_API.to_Boolean( p_init_msg_list )
1219: THEN
1220: FND_MSG_PUB.initialize;
1221: END IF;
1222:
1223: /*************************************************
1224: * Standard call to check for call compatibility. *

Line 1243: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1239: ******************************************/
1240: x_return_status := FND_API.G_RET_STS_SUCCESS;
1241: G_header_logged := 'N';
1242:
1243: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1244: THEN
1245: log_msg('Beginning Public Delete Actual Cost Adjustment API');
1246: END IF;
1247:

Line 1248: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1244: THEN
1245: log_msg('Beginning Public Delete Actual Cost Adjustment API');
1246: END IF;
1247:
1248: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1249: THEN
1250: log_msg('Validating input parameters');
1251: END IF;
1252:

Line 1261: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1257: x_user_id => l_user_id,
1258: x_return_status => l_return_status
1259: );
1260:
1261: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1262: THEN
1263: log_msg('Return Status after validating : ' || l_return_status);
1264: END IF;
1265: IF l_return_status = FND_API.G_RET_STS_ERROR

Line 1269: FND_MSG_PUB.Add;

1265: IF l_return_status = FND_API.G_RET_STS_ERROR
1266: THEN
1267: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1268: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1269: FND_MSG_PUB.Add;
1270: RAISE FND_API.G_EXC_ERROR;
1271: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1272: THEN
1273: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );

Line 1275: FND_MSG_PUB.Add;

1271: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1272: THEN
1273: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1274: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1275: FND_MSG_PUB.Add;
1276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1277: END IF;
1278: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1279: THEN

Line 1278: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1274: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1275: FND_MSG_PUB.Add;
1276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1277: END IF;
1278: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1279: THEN
1280: log_msg('Calling private API to delete record...');
1281: END IF;
1282: /*************************

Line 1298: FND_MSG_PUB.Add;

1294: IF l_return_status = FND_API.G_RET_STS_ERROR
1295: THEN
1296: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1297: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1298: FND_MSG_PUB.Add;
1299: RAISE FND_API.G_EXC_ERROR;
1300: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1301: THEN
1302: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );

Line 1304: FND_MSG_PUB.Add;

1300: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1301: THEN
1302: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1303: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1304: FND_MSG_PUB.Add;
1305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1306: END IF;
1307: /******************************
1308: * Standard check of p_commit. *

Line 1317: FND_MSG_PUB.Count_And_Get

1313: END IF;
1314: /**************************************************************************
1315: * Standard call to get message count and if count is 1, get message info. *
1316: **************************************************************************/
1317: FND_MSG_PUB.Count_And_Get
1318: (
1319: p_count => x_msg_count,
1320: p_data => x_msg_data
1321: );

Line 1328: FND_MSG_PUB.Count_And_Get

1324: THEN
1325: ROLLBACK TO DELETE_ACT_COST_ADJUSTMENT_PUB;
1326: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1327: x_return_status := FND_API.G_RET_STS_ERROR ;
1328: FND_MSG_PUB.Count_And_Get
1329: (
1330: p_count => x_msg_count,
1331: p_data => x_msg_data
1332: );

Line 1338: FND_MSG_PUB.Count_And_Get

1334: THEN
1335: ROLLBACK TO DELETE_ACT_COST_ADJUSTMENT_PUB;
1336: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1338: FND_MSG_PUB.Count_And_Get
1339: (
1340: p_count => x_msg_count,
1341: p_data => x_msg_data
1342: );

Line 1348: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1344: THEN
1345: ROLLBACK TO DELETE_ACT_COST_ADJUSTMENT_PUB;
1346: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1348: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1349: THEN
1350: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1351: END IF;
1352: FND_MSG_PUB.Count_And_Get

Line 1350: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

1346: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1348: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1349: THEN
1350: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1351: END IF;
1352: FND_MSG_PUB.Count_And_Get
1353: (
1354: p_count => x_msg_count,

Line 1352: FND_MSG_PUB.Count_And_Get

1348: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1349: THEN
1350: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1351: END IF;
1352: FND_MSG_PUB.Count_And_Get
1353: (
1354: p_count => x_msg_count,
1355: p_data => x_msg_data
1356: );

Line 1417: FND_MSG_PUB.initialize;

1413: * Initialize message list if p_init_msg_list is set to TRUE. *
1414: *************************************************************/
1415: IF FND_API.to_Boolean( p_init_msg_list )
1416: THEN
1417: FND_MSG_PUB.initialize;
1418: END IF;
1419:
1420: /*************************************************
1421: * Standard call to check for call compatibility. *

Line 1440: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1436: ******************************************/
1437: x_return_status := FND_API.G_RET_STS_SUCCESS;
1438: G_header_logged := 'N';
1439:
1440: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1441: THEN
1442: log_msg('Beginning Public Get Actual Cost Adjustment API');
1443: END IF;
1444:

Line 1445: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1441: THEN
1442: log_msg('Beginning Public Get Actual Cost Adjustment API');
1443: END IF;
1444:
1445: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1446: THEN
1447: log_msg('Validating input parameters');
1448: END IF;
1449:

Line 1458: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1454: x_user_id => l_user_id,
1455: x_return_status => l_return_status
1456: );
1457:
1458: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1459: THEN
1460: log_msg('Return Status after validating : ' || l_return_status);
1461: END IF;
1462: IF l_return_status = FND_API.G_RET_STS_ERROR

Line 1471: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1467: THEN
1468: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1470: END IF;
1471: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1472: THEN
1473: log_msg('Calling private API to get record...');
1474: END IF;
1475: /*************************

Line 1499: FND_MSG_PUB.Count_And_Get

1495: END IF;
1496: /**************************************************************************
1497: * Standard call to get message count and if count is 1, get message info. *
1498: **************************************************************************/
1499: FND_MSG_PUB.Count_And_Get
1500: (
1501: p_count => x_msg_count,
1502: p_data => x_msg_data
1503: );

Line 1509: FND_MSG_PUB.Count_And_Get

1505: WHEN FND_API.G_EXC_ERROR
1506: THEN
1507: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1508: x_return_status := FND_API.G_RET_STS_ERROR ;
1509: FND_MSG_PUB.Count_And_Get
1510: (
1511: p_count => x_msg_count,
1512: p_data => x_msg_data
1513: );

Line 1518: FND_MSG_PUB.Count_And_Get

1514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1515: THEN
1516: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1518: FND_MSG_PUB.Count_And_Get
1519: (
1520: p_count => x_msg_count,
1521: p_data => x_msg_data
1522: );

Line 1527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1523: WHEN OTHERS
1524: THEN
1525: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1528: THEN
1529: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1530: END IF;
1531: FND_MSG_PUB.Count_And_Get

Line 1529: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

1525: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1528: THEN
1529: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1530: END IF;
1531: FND_MSG_PUB.Count_And_Get
1532: (
1533: p_count => x_msg_count,

Line 1531: FND_MSG_PUB.Count_And_Get

1527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1528: THEN
1529: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1530: END IF;
1531: FND_MSG_PUB.Count_And_Get
1532: (
1533: p_count => x_msg_count,
1534: p_data => x_msg_data
1535: );