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.CS_COST_DETAILS_PVT dependencies on FND_MESSAGE

Line 70: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');

66: ) IS
67: BEGIN
68:
69: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
70: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
71: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
72: FND_MESSAGE.Set_Token('VALUE', p_token_v);
73: FND_MESSAGE.Set_Token('PARAMETER', p_token_p);
74: FND_MSG_PUB.Add;

Line 71: FND_MESSAGE.Set_Token('API_NAME', p_token_an);

67: BEGIN
68:
69: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
70: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
71: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
72: FND_MESSAGE.Set_Token('VALUE', p_token_v);
73: FND_MESSAGE.Set_Token('PARAMETER', p_token_p);
74: FND_MSG_PUB.Add;
75: END IF;

Line 72: FND_MESSAGE.Set_Token('VALUE', p_token_v);

68:
69: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
70: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
71: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
72: FND_MESSAGE.Set_Token('VALUE', p_token_v);
73: FND_MESSAGE.Set_Token('PARAMETER', p_token_p);
74: FND_MSG_PUB.Add;
75: END IF;
76:

Line 73: FND_MESSAGE.Set_Token('PARAMETER', p_token_p);

69: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
70: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
71: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
72: FND_MESSAGE.Set_Token('VALUE', p_token_v);
73: FND_MESSAGE.Set_Token('PARAMETER', p_token_p);
74: FND_MSG_PUB.Add;
75: END IF;
76:
77: END Add_Invalid_Argument_Msg;

Line 90: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_NULL_PARAMETER');

86:
87: BEGIN
88:
89: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
90: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_NULL_PARAMETER');
91: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
92: FND_MESSAGE.Set_Token('NULL_PARAM', p_token_np);
93: FND_MSG_PUB.Add;
94: END IF;

Line 91: FND_MESSAGE.Set_Token('API_NAME', p_token_an);

87: BEGIN
88:
89: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
90: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_NULL_PARAMETER');
91: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
92: FND_MESSAGE.Set_Token('NULL_PARAM', p_token_np);
93: FND_MSG_PUB.Add;
94: END IF;
95:

Line 92: FND_MESSAGE.Set_Token('NULL_PARAM', p_token_np);

88:
89: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
90: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_NULL_PARAMETER');
91: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
92: FND_MESSAGE.Set_Token('NULL_PARAM', p_token_np);
93: FND_MSG_PUB.Add;
94: END IF;
95:
96: END Add_Null_Parameter_Msg;

Line 172: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);

168:
169: EXCEPTION
170:
171: WHEN OTHERS THEN
172: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
173: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
174: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
175: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
176: FND_MSG_PUB.add;

Line 173: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);

169: EXCEPTION
170:
171: WHEN OTHERS THEN
172: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
173: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
174: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
175: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
176: FND_MSG_PUB.add;
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 174: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);

170:
171: WHEN OTHERS THEN
172: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
173: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
174: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
175: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
176: FND_MSG_PUB.add;
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: RETURN lv_exists_flag;

Line 175: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);

171: WHEN OTHERS THEN
172: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
173: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
174: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
175: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
176: FND_MSG_PUB.add;
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: RETURN lv_exists_flag;
179:

Line 214: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);

210:
211: EXCEPTION
212:
213: WHEN OTHERS THEN
214: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
215: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
216: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
217: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
218: FND_MSG_PUB.add;

Line 215: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);

211: EXCEPTION
212:
213: WHEN OTHERS THEN
214: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
215: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
216: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
217: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
218: FND_MSG_PUB.add;
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 216: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);

212:
213: WHEN OTHERS THEN
214: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
215: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
216: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
217: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
218: FND_MSG_PUB.add;
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220: RETURN lv_exists_flag;

Line 217: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);

213: WHEN OTHERS THEN
214: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
215: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
216: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
217: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
218: FND_MSG_PUB.add;
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220: RETURN lv_exists_flag;
221:

Line 256: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);

252: EXCEPTION
253:
254: WHEN OTHERS THEN
255:
256: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
257: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
258: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
259: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
260: FND_MSG_PUB.add;

Line 257: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);

253:
254: WHEN OTHERS THEN
255:
256: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
257: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
258: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
259: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
260: FND_MSG_PUB.add;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 258: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);

254: WHEN OTHERS THEN
255:
256: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
257: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
258: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
259: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
260: FND_MSG_PUB.add;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: RETURN lv_exists_flag;

Line 259: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);

255:
256: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
257: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
258: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
259: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
260: FND_MSG_PUB.add;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: RETURN lv_exists_flag;
263:

Line 316: FND_MESSAGE.Set_Name('CS', 'CS_CHG_INVALID_SOURCE');

312: END LOOP;
313:
314: IF lv_exists_flag <> 'Y' THEN
315:
316: FND_MESSAGE.Set_Name('CS', 'CS_CHG_INVALID_SOURCE');
317: FND_MESSAGE.SET_TOKEN('SOURCE_CODE', p_source_code);
318: FND_MESSAGE.SET_TOKEN('SOURCE_ID', p_source_id);
319: FND_MSG_PUB.Add;
320: RAISE FND_API.G_EXC_ERROR;

Line 317: FND_MESSAGE.SET_TOKEN('SOURCE_CODE', p_source_code);

313:
314: IF lv_exists_flag <> 'Y' THEN
315:
316: FND_MESSAGE.Set_Name('CS', 'CS_CHG_INVALID_SOURCE');
317: FND_MESSAGE.SET_TOKEN('SOURCE_CODE', p_source_code);
318: FND_MESSAGE.SET_TOKEN('SOURCE_ID', p_source_id);
319: FND_MSG_PUB.Add;
320: RAISE FND_API.G_EXC_ERROR;
321:

Line 318: FND_MESSAGE.SET_TOKEN('SOURCE_ID', p_source_id);

314: IF lv_exists_flag <> 'Y' THEN
315:
316: FND_MESSAGE.Set_Name('CS', 'CS_CHG_INVALID_SOURCE');
317: FND_MESSAGE.SET_TOKEN('SOURCE_CODE', p_source_code);
318: FND_MESSAGE.SET_TOKEN('SOURCE_ID', p_source_id);
319: FND_MSG_PUB.Add;
320: RAISE FND_API.G_EXC_ERROR;
321:
322: END IF;

Line 340: FND_MESSAGE.Set_Name('CS', 'CS_CHG_INVALID_SOURCE');

336:
337: IF lv_exists_flag <> 'Y' THEN
338: --RAISE FND_API.G_EXC_ERROR;
339: --null;
340: FND_MESSAGE.Set_Name('CS', 'CS_CHG_INVALID_SOURCE');
341: FND_MESSAGE.SET_TOKEN('SOURCE_CODE', p_source_code);
342: FND_MESSAGE.SET_TOKEN('SOURCE_ID', p_source_id);
343: FND_MSG_PUB.Add;
344: RAISE FND_API.G_EXC_ERROR;

Line 341: FND_MESSAGE.SET_TOKEN('SOURCE_CODE', p_source_code);

337: IF lv_exists_flag <> 'Y' THEN
338: --RAISE FND_API.G_EXC_ERROR;
339: --null;
340: FND_MESSAGE.Set_Name('CS', 'CS_CHG_INVALID_SOURCE');
341: FND_MESSAGE.SET_TOKEN('SOURCE_CODE', p_source_code);
342: FND_MESSAGE.SET_TOKEN('SOURCE_ID', p_source_id);
343: FND_MSG_PUB.Add;
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;

Line 342: FND_MESSAGE.SET_TOKEN('SOURCE_ID', p_source_id);

338: --RAISE FND_API.G_EXC_ERROR;
339: --null;
340: FND_MESSAGE.Set_Name('CS', 'CS_CHG_INVALID_SOURCE');
341: FND_MESSAGE.SET_TOKEN('SOURCE_CODE', p_source_code);
342: FND_MESSAGE.SET_TOKEN('SOURCE_ID', p_source_id);
343: FND_MSG_PUB.Add;
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
346:

Line 363: FND_MESSAGE.Set_Name('CS', 'CS_CHG_INVALID_SOURCE');

359:
360: IF lv_exists_flag <> 'Y' THEN
361: --RAISE FND_API.G_EXC_ERROR;
362: --null;
363: FND_MESSAGE.Set_Name('CS', 'CS_CHG_INVALID_SOURCE');
364: FND_MESSAGE.SET_TOKEN('SOURCE_CODE', p_source_code);
365: FND_MESSAGE.SET_TOKEN('SOURCE_ID', p_source_id);
366: FND_MSG_PUB.Add;
367: RAISE FND_API.G_EXC_ERROR;

Line 364: FND_MESSAGE.SET_TOKEN('SOURCE_CODE', p_source_code);

360: IF lv_exists_flag <> 'Y' THEN
361: --RAISE FND_API.G_EXC_ERROR;
362: --null;
363: FND_MESSAGE.Set_Name('CS', 'CS_CHG_INVALID_SOURCE');
364: FND_MESSAGE.SET_TOKEN('SOURCE_CODE', p_source_code);
365: FND_MESSAGE.SET_TOKEN('SOURCE_ID', p_source_id);
366: FND_MSG_PUB.Add;
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;

Line 365: FND_MESSAGE.SET_TOKEN('SOURCE_ID', p_source_id);

361: --RAISE FND_API.G_EXC_ERROR;
362: --null;
363: FND_MESSAGE.Set_Name('CS', 'CS_CHG_INVALID_SOURCE');
364: FND_MESSAGE.SET_TOKEN('SOURCE_CODE', p_source_code);
365: FND_MESSAGE.SET_TOKEN('SOURCE_ID', p_source_id);
366: FND_MSG_PUB.Add;
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;
369:

Line 405: FND_MESSAGE.Set_Name('CS', 'CS_CHG_INVALID_SOURCE');

401: END IF ;
402:
403: WHEN OTHERS THEN
404: x_return_status := FND_API.G_RET_STS_ERROR;
405: FND_MESSAGE.Set_Name('CS', 'CS_CHG_INVALID_SOURCE');
406: FND_MESSAGE.SET_TOKEN('SOURCE_CODE', p_source_code);
407: FND_MESSAGE.SET_TOKEN('SOURCE_ID', p_source_id);
408: FND_MSG_PUB.Add;
409: fnd_msg_pub.count_and_get(p_count => x_msg_count

Line 406: FND_MESSAGE.SET_TOKEN('SOURCE_CODE', p_source_code);

402:
403: WHEN OTHERS THEN
404: x_return_status := FND_API.G_RET_STS_ERROR;
405: FND_MESSAGE.Set_Name('CS', 'CS_CHG_INVALID_SOURCE');
406: FND_MESSAGE.SET_TOKEN('SOURCE_CODE', p_source_code);
407: FND_MESSAGE.SET_TOKEN('SOURCE_ID', p_source_id);
408: FND_MSG_PUB.Add;
409: fnd_msg_pub.count_and_get(p_count => x_msg_count
410: ,p_data => x_msg_data);

Line 407: FND_MESSAGE.SET_TOKEN('SOURCE_ID', p_source_id);

403: WHEN OTHERS THEN
404: x_return_status := FND_API.G_RET_STS_ERROR;
405: FND_MESSAGE.Set_Name('CS', 'CS_CHG_INVALID_SOURCE');
406: FND_MESSAGE.SET_TOKEN('SOURCE_CODE', p_source_code);
407: FND_MESSAGE.SET_TOKEN('SOURCE_ID', p_source_id);
408: FND_MSG_PUB.Add;
409: fnd_msg_pub.count_and_get(p_count => x_msg_count
410: ,p_data => x_msg_data);
411:

Line 496: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);

492: EXCEPTION
493:
494: WHEN OTHERS THEN
495:
496: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
497: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
498: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
499: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
500: FND_MSG_PUB.add;

Line 497: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);

493:
494: WHEN OTHERS THEN
495:
496: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
497: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
498: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
499: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
500: FND_MSG_PUB.add;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 498: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);

494: WHEN OTHERS THEN
495:
496: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
497: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
498: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
499: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
500: FND_MSG_PUB.add;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: RETURN lv_exists_flag;

Line 499: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);

495:
496: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
497: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
498: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
499: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
500: FND_MSG_PUB.add;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: RETURN lv_exists_flag;
503:

Line 554: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);

550: EXCEPTION
551:
552: WHEN OTHERS THEN
553:
554: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
555: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
556: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
557: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
558: FND_MSG_PUB.add;

Line 555: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);

551:
552: WHEN OTHERS THEN
553:
554: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
555: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
556: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
557: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
558: FND_MSG_PUB.add;
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 556: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);

552: WHEN OTHERS THEN
553:
554: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
555: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
556: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
557: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
558: FND_MSG_PUB.add;
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
560: RETURN lv_exists_flag;

Line 557: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);

553:
554: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
555: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
556: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
557: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
558: FND_MSG_PUB.add;
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
560: RETURN lv_exists_flag;
561: END;

Line 601: FND_MESSAGE.Set_Name('CS', 'CS_CHG_GET_UOM_FAILED');

597: EXCEPTION
598:
599: WHEN OTHERS THEN
600:
601: FND_MESSAGE.Set_Name('CS', 'CS_CHG_GET_UOM_FAILED');
602: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);
603: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', cs_std.get_item_valdn_orgzn_id);
604: FND_MSG_PUB.add;
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 602: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);

598:
599: WHEN OTHERS THEN
600:
601: FND_MESSAGE.Set_Name('CS', 'CS_CHG_GET_UOM_FAILED');
602: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);
603: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', cs_std.get_item_valdn_orgzn_id);
604: FND_MSG_PUB.add;
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
606:

Line 603: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', cs_std.get_item_valdn_orgzn_id);

599: WHEN OTHERS THEN
600:
601: FND_MESSAGE.Set_Name('CS', 'CS_CHG_GET_UOM_FAILED');
602: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);
603: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', cs_std.get_item_valdn_orgzn_id);
604: FND_MSG_PUB.add;
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
606:
607: END GET_PRIMARY_UOM;

Line 644: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);

640:
641: EXCEPTION
642:
643: WHEN OTHERS THEN
644: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
645: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
646: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
647: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
648: FND_MSG_PUB.add;

Line 645: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);

641: EXCEPTION
642:
643: WHEN OTHERS THEN
644: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
645: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
646: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
647: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
648: FND_MSG_PUB.add;
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 646: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);

642:
643: WHEN OTHERS THEN
644: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
645: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
646: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
647: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
648: FND_MSG_PUB.add;
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
650: RETURN lv_exists_flag;

Line 647: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);

643: WHEN OTHERS THEN
644: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
645: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
646: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
647: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
648: FND_MSG_PUB.add;
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
650: RETURN lv_exists_flag;
651: END;

Line 688: FND_MESSAGE.Set_Name('CS', 'CS_COST_GET_CURRENCY_FAILED');

684: EXCEPTION
685:
686: WHEN OTHERS THEN
687:
688: FND_MESSAGE.Set_Name('CS', 'CS_COST_GET_CURRENCY_FAILED');
689: FND_MSG_PUB.add;
690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
691:
692: END GET_CURRENCY_CODE;

Line 727: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);

723: EXCEPTION
724:
725: WHEN OTHERS THEN
726:
727: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
728: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
729: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
730: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
731: FND_MSG_PUB.add;

Line 728: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);

724:
725: WHEN OTHERS THEN
726:
727: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
728: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
729: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
730: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
731: FND_MSG_PUB.add;
732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 729: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);

725: WHEN OTHERS THEN
726:
727: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
728: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
729: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
730: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
731: FND_MSG_PUB.add;
732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
733: RETURN lv_exists_flag;

Line 730: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);

726:
727: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
728: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
729: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
730: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
731: FND_MSG_PUB.add;
732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
733: RETURN lv_exists_flag;
734:

Line 768: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);

764:
765: EXCEPTION
766:
767: WHEN OTHERS THEN
768: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
769: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
770: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
771: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
772: FND_MSG_PUB.add;

Line 769: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);

765: EXCEPTION
766:
767: WHEN OTHERS THEN
768: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
769: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
770: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
771: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
772: FND_MSG_PUB.add;
773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 770: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);

766:
767: WHEN OTHERS THEN
768: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
769: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
770: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
771: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
772: FND_MSG_PUB.add;
773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
774: RETURN lv_exists_flag;

Line 771: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);

767: WHEN OTHERS THEN
768: FND_MESSAGE.SET_NAME(G_APP_NAME, G_DB_ERROR);
769: FND_MESSAGE.SET_TOKEN(token => G_PROG_NAME_TOKEN, value => l_prog_name);
770: FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
771: FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
772: FND_MSG_PUB.add;
773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
774: RETURN lv_exists_flag;
775:

Line 1010: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_COST_FAILED');

1006: p_token_an => p_api_name);
1007:
1008: WHEN OTHERS THEN
1009: x_return_status := FND_API.G_RET_STS_ERROR;
1010: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_COST_FAILED');
1011: FND_MESSAGE.SET_TOKEN('API_NAME', p_api_name);
1012: FND_MSG_PUB.add;
1013: fnd_msg_pub.count_and_get(
1014: p_count => x_msg_count

Line 1011: FND_MESSAGE.SET_TOKEN('API_NAME', p_api_name);

1007:
1008: WHEN OTHERS THEN
1009: x_return_status := FND_API.G_RET_STS_ERROR;
1010: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_COST_FAILED');
1011: FND_MESSAGE.SET_TOKEN('API_NAME', p_api_name);
1012: FND_MSG_PUB.add;
1013: fnd_msg_pub.count_and_get(
1014: p_count => x_msg_count
1015: ,p_data => x_msg_data);

Line 1159: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_GET_CHARGE_FAILED');

1155: RAISE FND_API.G_EXC_ERROR;
1156:
1157: WHEN OTHERS THEN
1158: x_return_status := FND_API.G_RET_STS_ERROR;
1159: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_GET_CHARGE_FAILED');
1160: FND_MESSAGE.SET_TOKEN('API_NAME', p_api_name);
1161: FND_MSG_PUB.add;
1162: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1163:

Line 1160: FND_MESSAGE.SET_TOKEN('API_NAME', p_api_name);

1156:
1157: WHEN OTHERS THEN
1158: x_return_status := FND_API.G_RET_STS_ERROR;
1159: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_GET_CHARGE_FAILED');
1160: FND_MESSAGE.SET_TOKEN('API_NAME', p_api_name);
1161: FND_MSG_PUB.add;
1162: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1163:
1164: END Get_charge_details;

Line 1320: FND_MESSAGE.Set_Name('CS', 'CS_CHG_ITM_BILL_TYP_NOT_IN_TXN');

1316: lv_exists_flag := 'Y';
1317: END LOOP;
1318:
1319: IF lv_exists_flag <> 'Y' THEN
1320: FND_MESSAGE.Set_Name('CS', 'CS_CHG_ITM_BILL_TYP_NOT_IN_TXN');
1321: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inv_id);
1322: FND_MESSAGE.SET_TOKEN('TXN_TYPE_ID', p_txn_type_id);
1323: FND_MSG_PUB.Add;
1324: RAISE FND_API.G_EXC_ERROR;

Line 1321: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inv_id);

1317: END LOOP;
1318:
1319: IF lv_exists_flag <> 'Y' THEN
1320: FND_MESSAGE.Set_Name('CS', 'CS_CHG_ITM_BILL_TYP_NOT_IN_TXN');
1321: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inv_id);
1322: FND_MESSAGE.SET_TOKEN('TXN_TYPE_ID', p_txn_type_id);
1323: FND_MSG_PUB.Add;
1324: RAISE FND_API.G_EXC_ERROR;
1325: END IF;

Line 1322: FND_MESSAGE.SET_TOKEN('TXN_TYPE_ID', p_txn_type_id);

1318:
1319: IF lv_exists_flag <> 'Y' THEN
1320: FND_MESSAGE.Set_Name('CS', 'CS_CHG_ITM_BILL_TYP_NOT_IN_TXN');
1321: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inv_id);
1322: FND_MESSAGE.SET_TOKEN('TXN_TYPE_ID', p_txn_type_id);
1323: FND_MSG_PUB.Add;
1324: RAISE FND_API.G_EXC_ERROR;
1325: END IF;
1326:

Line 1337: FND_MESSAGE.Set_Name('CS', 'CS_CHG_ITM_BILL_TYP_NOT_IN_TXN');

1333: ,p_data => x_msg_data);
1334:
1335: WHEN OTHERS THEN
1336: x_return_status := FND_API.G_RET_STS_ERROR;
1337: FND_MESSAGE.Set_Name('CS', 'CS_CHG_ITM_BILL_TYP_NOT_IN_TXN');
1338: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inv_id);
1339: FND_MESSAGE.SET_TOKEN('TXN_TYPE_ID', p_txn_type_id);
1340: FND_MSG_PUB.Add;
1341: fnd_msg_pub.count_and_get(

Line 1338: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inv_id);

1334:
1335: WHEN OTHERS THEN
1336: x_return_status := FND_API.G_RET_STS_ERROR;
1337: FND_MESSAGE.Set_Name('CS', 'CS_CHG_ITM_BILL_TYP_NOT_IN_TXN');
1338: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inv_id);
1339: FND_MESSAGE.SET_TOKEN('TXN_TYPE_ID', p_txn_type_id);
1340: FND_MSG_PUB.Add;
1341: fnd_msg_pub.count_and_get(
1342: p_count => x_msg_count

Line 1339: FND_MESSAGE.SET_TOKEN('TXN_TYPE_ID', p_txn_type_id);

1335: WHEN OTHERS THEN
1336: x_return_status := FND_API.G_RET_STS_ERROR;
1337: FND_MESSAGE.Set_Name('CS', 'CS_CHG_ITM_BILL_TYP_NOT_IN_TXN');
1338: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inv_id);
1339: FND_MESSAGE.SET_TOKEN('TXN_TYPE_ID', p_txn_type_id);
1340: FND_MSG_PUB.Add;
1341: fnd_msg_pub.count_and_get(
1342: p_count => x_msg_count
1343: ,p_data => x_msg_data);

Line 1546: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CHARGE_EXIST');

1542: FETCH c_check_cost_exst into lv_cost_id;
1543: CLOSE c_check_cost_exst;
1544:
1545: if lv_cost_id is not null then
1546: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CHARGE_EXIST');
1547: FND_MSG_PUB.ADD;
1548: RAISE FND_API.G_EXC_ERROR;
1549: end if;
1550:

Line 1609: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_INSERT');

1605: END IF;
1606:
1607: If l_create_charge_flag ='N' and l_create_cost_flag = 'Y' then
1608: if l_disallow_request_update='Y' THEN
1609: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_INSERT');
1610: FND_MSG_PUB.ADD;
1611: RAISE FND_API.G_EXC_ERROR;
1612: end if;
1613:

Line 1616: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_INSERT');

1612: end if;
1613:
1614: Else
1615: if l_disallow_new_charge = 'Y' OR l_disallow_request_update='Y' THEN
1616: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_INSERT');
1617: FND_MSG_PUB.ADD;
1618: RAISE FND_API.G_EXC_ERROR;
1619: end if;
1620: end if;

Line 1680: FND_MESSAGE.SET_NAME('CS', 'CS_COST_INVALID_BUS_PROCESS');

1676: x_return_status => l_return_status
1677: ) ;
1678:
1679: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1680: FND_MESSAGE.SET_NAME('CS', 'CS_COST_INVALID_BUS_PROCESS');
1681: FND_MSG_PUB.ADD;
1682: RAISE FND_API.G_EXC_ERROR;
1683: END IF;
1684: Else

Line 1685: FND_MESSAGE.SET_NAME('CS', 'CS_COST_INVALID_COST_FLAG');

1681: FND_MSG_PUB.ADD;
1682: RAISE FND_API.G_EXC_ERROR;
1683: END IF;
1684: Else
1685: FND_MESSAGE.SET_NAME('CS', 'CS_COST_INVALID_COST_FLAG');
1686: FND_MSG_PUB.ADD;
1687: RAISE G_WARNING;
1688: end if;
1689: end if;

Line 1786: FND_MESSAGE.Set_Name('CS', 'CS_COST_VALIDATE_COST_DTL_ER');

1782: x_return_status => l_return_status
1783: );
1784:
1785: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1786: FND_MESSAGE.Set_Name('CS', 'CS_COST_VALIDATE_COST_DTL_ER');
1787: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1788: FND_MSG_PUB.Add;
1789: RAISE FND_API.G_EXC_ERROR;
1790: END IF;

Line 1787: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

1783: );
1784:
1785: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1786: FND_MESSAGE.Set_Name('CS', 'CS_COST_VALIDATE_COST_DTL_ER');
1787: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1788: FND_MSG_PUB.Add;
1789: RAISE FND_API.G_EXC_ERROR;
1790: END IF;
1791: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

Line 1909: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_NO_INV_ORG');

1905:
1906:
1907: -- for 12.2.2 service projects integration
1908: If l_cost_inv_org_id is null then
1909: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_NO_INV_ORG');
1910: FND_MSG_PUB.ADD;
1911: Raise FND_API.G_EXC_ERROR;
1912: End If;
1913: --end;

Line 2315: FND_MESSAGE.SET_NAME('CS', 'CS_COST_NO_CHARGE_EXIST');

2311:
2312: CLOSE c_check_cost_exst;
2313:
2314: if lv_cost_id is null then
2315: FND_MESSAGE.SET_NAME('CS', 'CS_COST_NO_CHARGE_EXIST');
2316: FND_MSG_PUB.ADD;
2317: RAISE G_WARNING;
2318: end if;
2319:

Line 2377: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_UPDATE');

2373:
2374: If l_create_charge_flag ='N' and l_create_cost_flag = 'Y' then
2375:
2376: if l_disallow_request_update='Y' THEN
2377: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_UPDATE');
2378: FND_MSG_PUB.ADD;
2379: RAISE FND_API.G_EXC_ERROR;
2380: end if;
2381:

Line 2385: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_UPDATE');

2381:
2382: Else
2383:
2384: if l_disallow_charge_update = 'Y' OR l_disallow_request_update='Y' THEN
2385: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_UPDATE');
2386: FND_MSG_PUB.ADD;
2387: RAISE FND_API.G_EXC_ERROR;
2388: end if;
2389:

Line 2457: FND_MESSAGE.Set_Name('CS', 'CS_COST_VALIDATE_COST_DTL_ER');

2453: );
2454:
2455:
2456: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2457: FND_MESSAGE.Set_Name('CS', 'CS_COST_VALIDATE_COST_DTL_ER');
2458: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
2459: FND_MSG_PUB.Add;
2460: RAISE FND_API.G_EXC_ERROR;
2461: END IF;

Line 2458: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

2454:
2455:
2456: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2457: FND_MESSAGE.Set_Name('CS', 'CS_COST_VALIDATE_COST_DTL_ER');
2458: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
2459: FND_MSG_PUB.Add;
2460: RAISE FND_API.G_EXC_ERROR;
2461: END IF;
2462:

Line 2593: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_NO_INV_ORG');

2589:
2590:
2591:
2592: If l_cost_inv_org_id is null then
2593: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_NO_INV_ORG');
2594: FND_MSG_PUB.ADD;
2595: RAISE FND_API.G_EXC_ERROR;
2596: End If;
2597:

Line 2912: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_DELETE');

2908: l_return_status
2909: ) ;
2910:
2911: if l_valid_check ='Y' then
2912: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_DELETE');
2913: FND_MSG_PUB.ADD;
2914: RAISE G_WARNING;
2915: end if;
2916:

Line 3267: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_INSERT');

3263: If l_create_charge_flag ='N' and l_create_cost_flag = 'Y' then
3264: if l_disallow_request_update='Y' THEN
3265:
3266:
3267: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_INSERT');
3268: FND_MSG_PUB.ADD;
3269: RAISE FND_API.G_EXC_ERROR;
3270: end if;
3271:

Line 3276: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_INSERT');

3272: Else
3273: if l_disallow_new_charge = 'Y' OR l_disallow_request_update='Y' THEN
3274:
3275:
3276: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_INSERT');
3277: FND_MSG_PUB.ADD;
3278: RAISE FND_API.G_EXC_ERROR;
3279: end if;
3280:

Line 3288: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_UPDATE');

3284:
3285:
3286: If l_create_charge_flag ='N' and l_create_cost_flag = 'Y' then
3287: if l_disallow_request_update='Y' THEN
3288: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_UPDATE');
3289: FND_MSG_PUB.ADD;
3290: RAISE FND_API.G_EXC_ERROR;
3291: end if;
3292:

Line 3296: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_UPDATE');

3292:
3293: Else
3294: if l_disallow_charge_update = 'Y' OR l_disallow_request_update='Y' THEN
3295:
3296: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_UPDATE');
3297: FND_MSG_PUB.ADD;
3298: RAISE FND_API.G_EXC_ERROR;
3299: end if;
3300:

Line 3537: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CANNOT_CHANGE_OU');

3533: -- dbms_output.put_line(' OU 1 l_profile : '||l_profile||pv_cost_rec.org_id||'-'||l_org_id);
3534: if pv_cost_rec.org_id <> l_org_id then
3535: --raise error
3536: --Need to define error here
3537: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CANNOT_CHANGE_OU');
3538: FND_MESSAGE.SET_TOKEN('API_NAME', p_api_name);
3539: FND_MSG_PUB.ADD;
3540: RAISE FND_API.G_EXC_ERROR;
3541: else

Line 3538: FND_MESSAGE.SET_TOKEN('API_NAME', p_api_name);

3534: if pv_cost_rec.org_id <> l_org_id then
3535: --raise error
3536: --Need to define error here
3537: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CANNOT_CHANGE_OU');
3538: FND_MESSAGE.SET_TOKEN('API_NAME', p_api_name);
3539: FND_MSG_PUB.ADD;
3540: RAISE FND_API.G_EXC_ERROR;
3541: else
3542: x_cost_rec.org_id := pv_cost_rec.org_id;

Line 3621: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CANNOT_CHANGE_OU');

3617:
3618: ELSE
3619: IF pv_cost_rec.org_id <> l_db_det_rec.org_id THEN
3620: --raise error
3621: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CANNOT_CHANGE_OU');
3622: FND_MESSAGE.SET_TOKEN('API_NAME', p_api_name);
3623: FND_MSG_PUB.ADD;
3624: RAISE FND_API.G_EXC_ERROR;
3625: ELSE

Line 3622: FND_MESSAGE.SET_TOKEN('API_NAME', p_api_name);

3618: ELSE
3619: IF pv_cost_rec.org_id <> l_db_det_rec.org_id THEN
3620: --raise error
3621: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CANNOT_CHANGE_OU');
3622: FND_MESSAGE.SET_TOKEN('API_NAME', p_api_name);
3623: FND_MSG_PUB.ADD;
3624: RAISE FND_API.G_EXC_ERROR;
3625: ELSE
3626: x_cost_rec.org_id := pv_cost_rec.org_id;

Line 3892: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_INVALID_TXN_BILLING_TYP');

3888: ELSE
3889: IF pv_cost_rec.txn_billing_type_id IS NOT NULL THEN
3890: IF pv_cost_rec.txn_billing_type_id <> l_txn_billing_type_id THEN
3891: --RAISE ERROR
3892: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_INVALID_TXN_BILLING_TYP');
3893: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID', pv_cost_rec.txn_billing_type_id);
3894: FND_MSG_PUB.ADD;
3895: RAISE FND_API.G_EXC_ERROR;
3896: ELSE --

Line 3893: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID', pv_cost_rec.txn_billing_type_id);

3889: IF pv_cost_rec.txn_billing_type_id IS NOT NULL THEN
3890: IF pv_cost_rec.txn_billing_type_id <> l_txn_billing_type_id THEN
3891: --RAISE ERROR
3892: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_INVALID_TXN_BILLING_TYP');
3893: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID', pv_cost_rec.txn_billing_type_id);
3894: FND_MSG_PUB.ADD;
3895: RAISE FND_API.G_EXC_ERROR;
3896: ELSE --
3897: --the ids match

Line 3916: FND_MESSAGE.SET_NAME('CS', 'CS_COST_INVALID_OU_BILLING_TYP');

3912: x_msg_count => l_msg_count,
3913: x_msg_data => l_msg_data);
3914:
3915: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3916: FND_MESSAGE.SET_NAME('CS', 'CS_COST_INVALID_OU_BILLING_TYP');
3917: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID', pv_cost_rec.txn_billing_type_id);
3918: FND_MSG_PUB.ADD;
3919: RAISE FND_API.G_EXC_ERROR;
3920: End if;

Line 3917: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID', pv_cost_rec.txn_billing_type_id);

3913: x_msg_data => l_msg_data);
3914:
3915: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3916: FND_MESSAGE.SET_NAME('CS', 'CS_COST_INVALID_OU_BILLING_TYP');
3917: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID', pv_cost_rec.txn_billing_type_id);
3918: FND_MSG_PUB.ADD;
3919: RAISE FND_API.G_EXC_ERROR;
3920: End if;
3921:

Line 3955: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_INVALID_TXN_BILLING_TYP');

3951: pv_cost_rec.txn_billing_type_id IS NOT NULL THEN
3952: IF pv_cost_rec.txn_billing_type_id <> l_txn_billing_type_id THEN
3953:
3954: --RAISE ERROR
3955: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_INVALID_TXN_BILLING_TYP');
3956: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID', pv_cost_rec.txn_billing_type_id);
3957: FND_MSG_PUB.ADD;
3958: RAISE FND_API.G_EXC_ERROR;
3959: ELSE --

Line 3956: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID', pv_cost_rec.txn_billing_type_id);

3952: IF pv_cost_rec.txn_billing_type_id <> l_txn_billing_type_id THEN
3953:
3954: --RAISE ERROR
3955: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_INVALID_TXN_BILLING_TYP');
3956: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID', pv_cost_rec.txn_billing_type_id);
3957: FND_MSG_PUB.ADD;
3958: RAISE FND_API.G_EXC_ERROR;
3959: ELSE --
3960: --the ids match

Line 4050: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_PRIMARY_UOM_ERROR');

4046:
4047: --IF l_return_status <> 'S' THEN
4048: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4049: --raise error
4050: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_PRIMARY_UOM_ERROR');
4051: FND_MESSAGE.SET_TOKEN('INV_ID', x_cost_rec.inventory_item_id);
4052: FND_MSG_PUB.ADD;
4053: RAISE FND_API.G_EXC_ERROR;
4054: END IF;

Line 4051: FND_MESSAGE.SET_TOKEN('INV_ID', x_cost_rec.inventory_item_id);

4047: --IF l_return_status <> 'S' THEN
4048: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4049: --raise error
4050: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_PRIMARY_UOM_ERROR');
4051: FND_MESSAGE.SET_TOKEN('INV_ID', x_cost_rec.inventory_item_id);
4052: FND_MSG_PUB.ADD;
4053: RAISE FND_API.G_EXC_ERROR;
4054: END IF;
4055:

Line 4109: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_PRIMARY_UOM_ERROR');

4105:
4106: --IF l_return_status <> 'S' THEN
4107: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
4108: --raise error
4109: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_PRIMARY_UOM_ERROR');
4110: FND_MESSAGE.SET_TOKEN('INV_ID', x_cost_rec.inventory_item_id);
4111: FND_MSG_PUB.ADD;
4112: RAISE FND_API.G_EXC_ERROR;
4113: end if;

Line 4110: FND_MESSAGE.SET_TOKEN('INV_ID', x_cost_rec.inventory_item_id);

4106: --IF l_return_status <> 'S' THEN
4107: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
4108: --raise error
4109: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_PRIMARY_UOM_ERROR');
4110: FND_MESSAGE.SET_TOKEN('INV_ID', x_cost_rec.inventory_item_id);
4111: FND_MSG_PUB.ADD;
4112: RAISE FND_API.G_EXC_ERROR;
4113: end if;
4114:

Line 4183: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_PRIMARY_UOM_ERROR');

4179:
4180: --IF l_return_status <> 'S' THEN
4181: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4182: --raise error
4183: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_PRIMARY_UOM_ERROR');
4184: FND_MESSAGE.SET_TOKEN('INV_ID', pv_cost_rec.unit_of_measure_code);
4185: FND_MSG_PUB.ADD;
4186: RAISE FND_API.G_EXC_ERROR;
4187: END IF;

Line 4184: FND_MESSAGE.SET_TOKEN('INV_ID', pv_cost_rec.unit_of_measure_code);

4180: --IF l_return_status <> 'S' THEN
4181: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4182: --raise error
4183: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_PRIMARY_UOM_ERROR');
4184: FND_MESSAGE.SET_TOKEN('INV_ID', pv_cost_rec.unit_of_measure_code);
4185: FND_MSG_PUB.ADD;
4186: RAISE FND_API.G_EXC_ERROR;
4187: END IF;
4188:

Line 4242: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_PRIMARY_UOM_ERROR');

4238:
4239:
4240: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4241: --raise error
4242: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_PRIMARY_UOM_ERROR');
4243: FND_MESSAGE.SET_TOKEN('INV_ID', pv_cost_rec.unit_of_measure_code);
4244: FND_MSG_PUB.ADD;
4245: RAISE FND_API.G_EXC_ERROR;
4246: END IF;

Line 4243: FND_MESSAGE.SET_TOKEN('INV_ID', pv_cost_rec.unit_of_measure_code);

4239:
4240: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4241: --raise error
4242: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_PRIMARY_UOM_ERROR');
4243: FND_MESSAGE.SET_TOKEN('INV_ID', pv_cost_rec.unit_of_measure_code);
4244: FND_MSG_PUB.ADD;
4245: RAISE FND_API.G_EXC_ERROR;
4246: END IF;
4247:

Line 4297: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_CANT_LOCK_RECORD');

4293: IS
4294:
4295: BEGIN
4296:
4297: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_CANT_LOCK_RECORD');
4298: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
4299: FND_MSG_PUB.Add;
4300: END Record_IS_Locked_Msg;
4301:

Line 4298: FND_MESSAGE.Set_Token('API_NAME', p_token_an);

4294:
4295: BEGIN
4296:
4297: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_CANT_LOCK_RECORD');
4298: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
4299: FND_MSG_PUB.Add;
4300: END Record_IS_Locked_Msg;
4301:
4302:

Line 4569: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');

4565: , 'p_object_type has to be SR.'
4566: );
4567: END IF ;
4568:
4569: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
4570: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4571: FND_MESSAGE.Set_Token('PARAM', 'p_object_type');
4572: FND_MESSAGE.Set_Token('CURRVAL', p_object_type);
4573: FND_MSG_PUB.ADD;

Line 4570: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);

4566: );
4567: END IF ;
4568:
4569: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
4570: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4571: FND_MESSAGE.Set_Token('PARAM', 'p_object_type');
4572: FND_MESSAGE.Set_Token('CURRVAL', p_object_type);
4573: FND_MSG_PUB.ADD;
4574:

Line 4571: FND_MESSAGE.Set_Token('PARAM', 'p_object_type');

4567: END IF ;
4568:
4569: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
4570: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4571: FND_MESSAGE.Set_Token('PARAM', 'p_object_type');
4572: FND_MESSAGE.Set_Token('CURRVAL', p_object_type);
4573: FND_MSG_PUB.ADD;
4574:
4575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4572: FND_MESSAGE.Set_Token('CURRVAL', p_object_type);

4568:
4569: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
4570: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4571: FND_MESSAGE.Set_Token('PARAM', 'p_object_type');
4572: FND_MESSAGE.Set_Token('CURRVAL', p_object_type);
4573: FND_MSG_PUB.ADD;
4574:
4575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4576: END IF;

Line 4592: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');

4588: , 'p_processing_set_id should not be NULL.'
4589: );
4590: END IF ;
4591:
4592: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
4593: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4594: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
4595: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
4596: FND_MSG_PUB.ADD;

Line 4593: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);

4589: );
4590: END IF ;
4591:
4592: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
4593: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4594: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
4595: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
4596: FND_MSG_PUB.ADD;
4597:

Line 4594: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');

4590: END IF ;
4591:
4592: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
4593: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4594: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
4595: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
4596: FND_MSG_PUB.ADD;
4597:
4598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4595: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));

4591:
4592: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
4593: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4594: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
4595: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
4596: FND_MSG_PUB.ADD;
4597:
4598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4599: END IF;

Line 4673: FND_MESSAGE.Set_Name('CS', 'CS_COST_LINE_DEL_FAIL');

4669: END IF ;
4670:
4671: WHEN OTHERS THEN
4672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4673: FND_MESSAGE.Set_Name('CS', 'CS_COST_LINE_DEL_FAIL');
4674: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4675: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
4676: FND_MSG_PUB.ADD;
4677:

Line 4674: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);

4670:
4671: WHEN OTHERS THEN
4672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4673: FND_MESSAGE.Set_Name('CS', 'CS_COST_LINE_DEL_FAIL');
4674: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4675: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
4676: FND_MSG_PUB.ADD;
4677:
4678: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

Line 4675: FND_MESSAGE.Set_Token('ERROR', SQLERRM);

4671: WHEN OTHERS THEN
4672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4673: FND_MESSAGE.Set_Name('CS', 'CS_COST_LINE_DEL_FAIL');
4674: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4675: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
4676: FND_MSG_PUB.ADD;
4677:
4678: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
4679: THEN