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_MESSAGE

Line 54: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');

50: p_msg_text IN VARCHAR2
51: )
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:

Line 55: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);

51: )
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: /**************************************************************

Line 82: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_RECORD');

78: BEGIN
79: IF G_header_logged = 'N'
80: THEN
81: G_header_logged := 'Y';
82: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_RECORD');
83: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);
84: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', p_adjustment_rec.organization_code);
85: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_adjustment_rec.inventory_item_id);
86: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER', p_adjustment_rec.item_number);

Line 83: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);

79: IF G_header_logged = 'N'
80: THEN
81: G_header_logged := 'Y';
82: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_RECORD');
83: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);
84: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', p_adjustment_rec.organization_code);
85: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_adjustment_rec.inventory_item_id);
86: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER', p_adjustment_rec.item_number);
87: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID', p_adjustment_rec.cost_type_id);

Line 84: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', p_adjustment_rec.organization_code);

80: THEN
81: G_header_logged := 'Y';
82: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_RECORD');
83: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);
84: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', p_adjustment_rec.organization_code);
85: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_adjustment_rec.inventory_item_id);
86: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER', p_adjustment_rec.item_number);
87: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID', p_adjustment_rec.cost_type_id);
88: FND_MESSAGE.SET_TOKEN('COST_MTHD_CODE', p_adjustment_rec.cost_mthd_code);

Line 85: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_adjustment_rec.inventory_item_id);

81: G_header_logged := 'Y';
82: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_RECORD');
83: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);
84: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', p_adjustment_rec.organization_code);
85: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_adjustment_rec.inventory_item_id);
86: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER', p_adjustment_rec.item_number);
87: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID', p_adjustment_rec.cost_type_id);
88: FND_MESSAGE.SET_TOKEN('COST_MTHD_CODE', p_adjustment_rec.cost_mthd_code);
89: FND_MESSAGE.SET_TOKEN('PERIOD_ID', p_adjustment_rec.period_id);

Line 86: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER', p_adjustment_rec.item_number);

82: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_RECORD');
83: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);
84: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', p_adjustment_rec.organization_code);
85: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_adjustment_rec.inventory_item_id);
86: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER', p_adjustment_rec.item_number);
87: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID', p_adjustment_rec.cost_type_id);
88: FND_MESSAGE.SET_TOKEN('COST_MTHD_CODE', p_adjustment_rec.cost_mthd_code);
89: FND_MESSAGE.SET_TOKEN('PERIOD_ID', p_adjustment_rec.period_id);
90: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_adjustment_rec.calendar_code);

Line 87: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID', p_adjustment_rec.cost_type_id);

83: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);
84: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', p_adjustment_rec.organization_code);
85: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_adjustment_rec.inventory_item_id);
86: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER', p_adjustment_rec.item_number);
87: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID', p_adjustment_rec.cost_type_id);
88: FND_MESSAGE.SET_TOKEN('COST_MTHD_CODE', p_adjustment_rec.cost_mthd_code);
89: FND_MESSAGE.SET_TOKEN('PERIOD_ID', p_adjustment_rec.period_id);
90: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_adjustment_rec.calendar_code);
91: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', p_adjustment_rec.period_code);

Line 88: FND_MESSAGE.SET_TOKEN('COST_MTHD_CODE', p_adjustment_rec.cost_mthd_code);

84: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', p_adjustment_rec.organization_code);
85: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_adjustment_rec.inventory_item_id);
86: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER', p_adjustment_rec.item_number);
87: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID', p_adjustment_rec.cost_type_id);
88: FND_MESSAGE.SET_TOKEN('COST_MTHD_CODE', p_adjustment_rec.cost_mthd_code);
89: FND_MESSAGE.SET_TOKEN('PERIOD_ID', p_adjustment_rec.period_id);
90: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_adjustment_rec.calendar_code);
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);

Line 89: FND_MESSAGE.SET_TOKEN('PERIOD_ID', p_adjustment_rec.period_id);

85: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_adjustment_rec.inventory_item_id);
86: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER', p_adjustment_rec.item_number);
87: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID', p_adjustment_rec.cost_type_id);
88: FND_MESSAGE.SET_TOKEN('COST_MTHD_CODE', p_adjustment_rec.cost_mthd_code);
89: FND_MESSAGE.SET_TOKEN('PERIOD_ID', p_adjustment_rec.period_id);
90: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_adjustment_rec.calendar_code);
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);

Line 90: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_adjustment_rec.calendar_code);

86: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER', p_adjustment_rec.item_number);
87: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID', p_adjustment_rec.cost_type_id);
88: FND_MESSAGE.SET_TOKEN('COST_MTHD_CODE', p_adjustment_rec.cost_mthd_code);
89: FND_MESSAGE.SET_TOKEN('PERIOD_ID', p_adjustment_rec.period_id);
90: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_adjustment_rec.calendar_code);
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);

Line 91: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', p_adjustment_rec.period_code);

87: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID', p_adjustment_rec.cost_type_id);
88: FND_MESSAGE.SET_TOKEN('COST_MTHD_CODE', p_adjustment_rec.cost_mthd_code);
89: FND_MESSAGE.SET_TOKEN('PERIOD_ID', p_adjustment_rec.period_id);
90: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_adjustment_rec.calendar_code);
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;

Line 92: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID', p_adjustment_rec.cost_cmpntcls_id);

88: FND_MESSAGE.SET_TOKEN('COST_MTHD_CODE', p_adjustment_rec.cost_mthd_code);
89: FND_MESSAGE.SET_TOKEN('PERIOD_ID', p_adjustment_rec.period_id);
90: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_adjustment_rec.calendar_code);
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;

Line 93: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_CODE', p_adjustment_rec.cost_cmpntcls_code);

89: FND_MESSAGE.SET_TOKEN('PERIOD_ID', p_adjustment_rec.period_id);
90: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_adjustment_rec.calendar_code);
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;

Line 94: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE', p_adjustment_rec.cost_analysis_code);

90: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_adjustment_rec.calendar_code);
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:

Line 174: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_APPLIED');

170: l_adjust_status := NULL;
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)

Line 185: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_HEADER_KEYS');

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;
188: END IF;
189: ELSE

Line 203: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE_ID');

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')
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;

Line 204: FND_MESSAGE.SET_TOKEN('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')
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)

Line 212: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');

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;
215: END IF;
216: END IF;

Line 213: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_adjustment_rec.cost_mthd_code);

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;
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)

Line 233: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE');

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
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;

Line 234: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_adjustment_rec.cost_mthd_code);

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

Line 239: FND_MESSAGE.SET_NAME('GMF','GMF_API_COST_TYPE_ID_REQ');

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');
240: FND_MSG_PUB.Add;
241: RAISE FND_API.G_EXC_ERROR;
242: END IF;
243: ELSE

Line 260: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_ID');

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)
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;

Line 261: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);

257: END IF;
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)

Line 269: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');

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;
272: END IF;
273: END IF;

Line 270: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', p_adjustment_rec.organization_code);

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;
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))

Line 287: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_CODE');

283: log_msg('Organization id : ' || p_adjustment_rec.organization_id);
284: END IF;
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;

Line 288: FND_MESSAGE.SET_TOKEN('ORG_CODE', p_adjustment_rec.organization_code);

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

Line 293: FND_MESSAGE.SET_NAME('GMF','GMF_API_ORGANIZATION_ID_REQ');

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');
294: FND_MSG_PUB.Add;
295: RAISE FND_API.G_EXC_ERROR;
296: END IF;
297: /******************

Line 308: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_ID');

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)
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;

Line 309: FND_MESSAGE.SET_TOKEN('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)
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;

Line 310: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);

306: IF NOT GMF_VALIDATIONS_PVT.Validate_inventory_item_Id(p_adjustment_rec.inventory_item_id, p_adjustment_rec.organization_id)
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)

Line 318: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ITEM_NO');

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);
321: FND_MSG_PUB.Add;
322: END IF;

Line 319: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_adjustment_rec.item_number);

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);
321: FND_MSG_PUB.Add;
322: END IF;
323: END IF;

Line 320: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);

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);
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)

Line 337: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_NO');

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
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;

Line 338: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_adjustment_rec.item_number);

334: END IF;
335: IF p_adjustment_rec.inventory_item_id IS NULL
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;

Line 339: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);

335: IF p_adjustment_rec.inventory_item_id IS NULL
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

Line 344: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_ID_REQ');

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');
345: FND_MSG_PUB.Add;
346: RAISE FND_API.G_EXC_ERROR;
347: END IF;
348: /********************

Line 359: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_PERIOD_ID');

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)
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;

Line 360: FND_MESSAGE.SET_TOKEN('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)
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

Line 373: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');

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);
376: FND_MSG_PUB.Add;
377: END IF;

Line 374: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_adjustment_rec.calendar_code);

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);
376: FND_MSG_PUB.Add;
377: END IF;
378: END IF;

Line 375: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', p_adjustment_rec.period_code);

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);
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)

Line 396: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CLDR_PERIOD');

392: log_msg('Period Id : ' || p_adjustment_rec.period_id);
393: END IF;
394: IF p_adjustment_rec.period_id IS NULL
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;

Line 397: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',p_adjustment_rec.calendar_code);

393: END IF;
394: IF p_adjustment_rec.period_id IS NULL
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;

Line 398: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_adjustment_rec.period_code);

394: IF p_adjustment_rec.period_id IS NULL
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

Line 403: FND_MESSAGE.SET_NAME('GMF','GMF_API_PERIOD_REQ');

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');
404: FND_MSG_PUB.Add;
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407: END IF;

Line 419: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNTCLS_ID');

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)
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;

Line 420: FND_MESSAGE.SET_TOKEN('CMPNTCLS_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)
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)

Line 428: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_CMPNTCLS_CODE');

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;
431: END IF;
432: END IF;

Line 429: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE', p_adjustment_rec.cost_cmpntcls_code);

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;
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)

Line 446: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNTCLS_CODE');

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
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;

Line 447: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE', p_adjustment_rec.cost_cmpntcls_code);

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

Line 452: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_ID_REQ');

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');
453: FND_MSG_PUB.Add;
454: RAISE FND_API.G_EXC_ERROR;
455: END IF;
456: /***************************

Line 467: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ANALYSIS_CODE');

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)
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;

Line 468: FND_MESSAGE.SET_TOKEN('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)
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

Line 473: FND_MESSAGE.SET_NAME('GMF','GMF_API_ANALYSIS_CODE_REQ');

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');
474: FND_MSG_PUB.Add;
475: RAISE FND_API.G_EXC_ERROR;
476: END IF;
477: /***********************************

Line 488: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ADJ_IND');

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)
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;

Line 489: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_IND',p_adjustment_rec.adjustment_ind);

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

Line 494: FND_MESSAGE.SET_NAME('GMF','GMF_API_ADJ_IND_REQ');

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');
495: FND_MSG_PUB.Add;
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498: IF P_OPERATION IN ('INSERT', 'UPDATE') THEN

Line 510: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_UM');

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)
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;

Line 511: FND_MESSAGE.SET_TOKEN('ITEM_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)
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

Line 516: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_UM_REQ');

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');
517: FND_MSG_PUB.Add;
518: RAISE FND_API.G_EXC_ERROR;
519: END IF;
520: /*****************************

Line 531: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_ADJ_COST');

527: log_msg('Validating Adjustment Cost');
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;

Line 555: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_REASON_CODE');

551: AND ROWNUM = 1;
552: EXCEPTION
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;

Line 556: FND_MESSAGE.SET_TOKEN('REASON_CODE',p_adjustment_rec.reason_code);

552: EXCEPTION
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

Line 561: FND_MESSAGE.SET_NAME('GMF','GMF_API_REASON_CODE_REQ');

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');
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)

Line 574: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_DELETE_MARK');

570: END IF;
571: IF p_adjustment_rec.delete_mark NOT IN (0,1)
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;

Line 575: FND_MESSAGE.SET_TOKEN('DELETE_MARK',p_adjustment_rec.delete_mark);

571: IF p_adjustment_rec.delete_mark NOT IN (0,1)
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'))

Line 582: FND_MESSAGE.SET_NAME('GMF','GMF_API_DELETE_MARK_REQ');

578: END IF;
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))

Line 589: FND_MESSAGE.SET_NAME('GMF','GMF_API_CANT_MARK_FOR_PURGE');

585: END IF;
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: /***********************************

Line 604: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_SUBLEDGER_IND');

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)
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

Line 605: FND_MESSAGE.SET_TOKEN('SUBLEDGER_IND',p_adjustment_rec.subledger_ind);

601: END IF;
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: /*****************************

Line 618: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_DATE_DEFAULT');

614: log_msg('Validating Adjustment date : ' || p_adjustment_rec.adjustment_date );
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

Line 641: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ACA_DATE');

637: l_start_date := NULL;
638: l_end_date := NULL;
639: END;
640: IF p_adjustment_rec.adjustment_date NOT BETWEEN l_start_date AND l_end_date THEN
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;

Line 642: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DATE',p_adjustment_rec.adjustment_date);

638: l_end_date := NULL;
639: END;
640: IF p_adjustment_rec.adjustment_date NOT BETWEEN l_start_date AND l_end_date THEN
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;

Line 643: FND_MESSAGE.SET_TOKEN('START_DATE', l_start_date);

639: END;
640: IF p_adjustment_rec.adjustment_date NOT BETWEEN l_start_date AND l_end_date THEN
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;

Line 644: FND_MESSAGE.SET_TOKEN('END_DATE', l_end_date);

640: IF p_adjustment_rec.adjustment_date NOT BETWEEN l_start_date AND l_end_date THEN
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;

Line 651: FND_MESSAGE.SET_NAME('GMF','GMF_API_SUBLEDGER_IND_REQ');

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

Line 671: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_USER_NAME');

667: x_user_id => x_user_id
668: );
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;

Line 672: FND_MESSAGE.SET_TOKEN('USER_NAME',p_adjustment_rec.user_name);

668: );
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

Line 677: FND_MESSAGE.SET_NAME('GMF','GMF_API_USER_NAME_REQ');

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');
678: FND_MSG_PUB.Add;
679: RAISE FND_API.G_EXC_ERROR;
680: END IF;
681: /***************************

Line 739: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_ADJUST_ID_NULL');

735: ' Cost Analysis Code ' || p_adjustment_rec.cost_analysis_code ||
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

Line 745: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_APPLIED');

741: RAISE FND_API.G_EXC_ERROR;
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;

Line 862: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');

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

Line 868: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');

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 );
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

Line 891: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');

887: );
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

Line 897: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');

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 );
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: /******************************

Line 1065: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');

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

Line 1071: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');

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 );
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

Line 1094: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');

1090: );
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

Line 1100: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');

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 );
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: /******************************

Line 1268: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');

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

Line 1274: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');

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 );
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

Line 1297: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');

1293: );
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

Line 1303: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');

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 );
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: /******************************