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.

[Home] [Help]

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 1537: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CHARGE_EXIST');

1533: FETCH c_check_cost_exst into lv_cost_id;
1534: CLOSE c_check_cost_exst;
1535:
1536: if lv_cost_id is not null then
1537: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CHARGE_EXIST');
1538: FND_MSG_PUB.ADD;
1539: RAISE FND_API.G_EXC_ERROR;
1540: end if;
1541:

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

1596: END IF;
1597:
1598: If l_create_charge_flag ='N' and l_create_cost_flag = 'Y' then
1599: if l_disallow_request_update='Y' THEN
1600: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_INSERT');
1601: FND_MSG_PUB.ADD;
1602: RAISE FND_API.G_EXC_ERROR;
1603: end if;
1604:

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

1603: end if;
1604:
1605: Else
1606: if l_disallow_new_charge = 'Y' OR l_disallow_request_update='Y' THEN
1607: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_INSERT');
1608: FND_MSG_PUB.ADD;
1609: RAISE FND_API.G_EXC_ERROR;
1610: end if;
1611: end if;

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

1667: x_return_status => l_return_status
1668: ) ;
1669:
1670: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1671: FND_MESSAGE.SET_NAME('CS', 'CS_COST_INVALID_BUS_PROCESS');
1672: FND_MSG_PUB.ADD;
1673: RAISE FND_API.G_EXC_ERROR;
1674: END IF;
1675: Else

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

1672: FND_MSG_PUB.ADD;
1673: RAISE FND_API.G_EXC_ERROR;
1674: END IF;
1675: Else
1676: FND_MESSAGE.SET_NAME('CS', 'CS_COST_INVALID_COST_FLAG');
1677: FND_MSG_PUB.ADD;
1678: RAISE G_WARNING;
1679: end if;
1680: end if;

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

1773: x_return_status => l_return_status
1774: );
1775:
1776: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1777: FND_MESSAGE.Set_Name('CS', 'CS_COST_VALIDATE_COST_DTL_ER');
1778: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1779: FND_MSG_PUB.Add;
1780: RAISE FND_API.G_EXC_ERROR;
1781: END IF;

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

1774: );
1775:
1776: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1777: FND_MESSAGE.Set_Name('CS', 'CS_COST_VALIDATE_COST_DTL_ER');
1778: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1779: FND_MSG_PUB.Add;
1780: RAISE FND_API.G_EXC_ERROR;
1781: END IF;
1782: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

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

2257:
2258: CLOSE c_check_cost_exst;
2259:
2260: if lv_cost_id is null then
2261: FND_MESSAGE.SET_NAME('CS', 'CS_COST_NO_CHARGE_EXIST');
2262: FND_MSG_PUB.ADD;
2263: RAISE G_WARNING;
2264: end if;
2265:

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

2319:
2320: If l_create_charge_flag ='N' and l_create_cost_flag = 'Y' then
2321:
2322: if l_disallow_request_update='Y' THEN
2323: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_UPDATE');
2324: FND_MSG_PUB.ADD;
2325: RAISE FND_API.G_EXC_ERROR;
2326: end if;
2327:

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

2327:
2328: Else
2329:
2330: if l_disallow_charge_update = 'Y' OR l_disallow_request_update='Y' THEN
2331: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_UPDATE');
2332: FND_MSG_PUB.ADD;
2333: RAISE FND_API.G_EXC_ERROR;
2334: end if;
2335:

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

2399: );
2400:
2401:
2402: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2403: FND_MESSAGE.Set_Name('CS', 'CS_COST_VALIDATE_COST_DTL_ER');
2404: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
2405: FND_MSG_PUB.Add;
2406: RAISE FND_API.G_EXC_ERROR;
2407: END IF;

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

2400:
2401:
2402: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2403: FND_MESSAGE.Set_Name('CS', 'CS_COST_VALIDATE_COST_DTL_ER');
2404: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
2405: FND_MSG_PUB.Add;
2406: RAISE FND_API.G_EXC_ERROR;
2407: END IF;
2408:

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

2805: l_return_status
2806: ) ;
2807:
2808: if l_valid_check ='Y' then
2809: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_DELETE');
2810: FND_MSG_PUB.ADD;
2811: RAISE G_WARNING;
2812: end if;
2813:

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

3160: If l_create_charge_flag ='N' and l_create_cost_flag = 'Y' then
3161: if l_disallow_request_update='Y' THEN
3162:
3163:
3164: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_INSERT');
3165: FND_MSG_PUB.ADD;
3166: RAISE FND_API.G_EXC_ERROR;
3167: end if;
3168:

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

3169: Else
3170: if l_disallow_new_charge = 'Y' OR l_disallow_request_update='Y' THEN
3171:
3172:
3173: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_INSERT');
3174: FND_MSG_PUB.ADD;
3175: RAISE FND_API.G_EXC_ERROR;
3176: end if;
3177:

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

3181:
3182:
3183: If l_create_charge_flag ='N' and l_create_cost_flag = 'Y' then
3184: if l_disallow_request_update='Y' THEN
3185: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_UPDATE');
3186: FND_MSG_PUB.ADD;
3187: RAISE FND_API.G_EXC_ERROR;
3188: end if;
3189:

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

3189:
3190: Else
3191: if l_disallow_charge_update = 'Y' OR l_disallow_request_update='Y' THEN
3192:
3193: FND_MESSAGE.SET_NAME('CS', 'CS_COST_CANNOT_UPDATE');
3194: FND_MSG_PUB.ADD;
3195: RAISE FND_API.G_EXC_ERROR;
3196: end if;
3197:

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

3430: -- dbms_output.put_line(' OU 1 l_profile : '||l_profile||pv_cost_rec.org_id||'-'||l_org_id);
3431: if pv_cost_rec.org_id <> l_org_id then
3432: --raise error
3433: --Need to define error here
3434: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CANNOT_CHANGE_OU');
3435: FND_MESSAGE.SET_TOKEN('API_NAME', p_api_name);
3436: FND_MSG_PUB.ADD;
3437: RAISE FND_API.G_EXC_ERROR;
3438: else

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

3431: if pv_cost_rec.org_id <> l_org_id then
3432: --raise error
3433: --Need to define error here
3434: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CANNOT_CHANGE_OU');
3435: FND_MESSAGE.SET_TOKEN('API_NAME', p_api_name);
3436: FND_MSG_PUB.ADD;
3437: RAISE FND_API.G_EXC_ERROR;
3438: else
3439: x_cost_rec.org_id := pv_cost_rec.org_id;

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

3514:
3515: ELSE
3516: IF pv_cost_rec.org_id <> l_db_det_rec.org_id THEN
3517: --raise error
3518: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CANNOT_CHANGE_OU');
3519: FND_MESSAGE.SET_TOKEN('API_NAME', p_api_name);
3520: FND_MSG_PUB.ADD;
3521: RAISE FND_API.G_EXC_ERROR;
3522: ELSE

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

3515: ELSE
3516: IF pv_cost_rec.org_id <> l_db_det_rec.org_id THEN
3517: --raise error
3518: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CANNOT_CHANGE_OU');
3519: FND_MESSAGE.SET_TOKEN('API_NAME', p_api_name);
3520: FND_MSG_PUB.ADD;
3521: RAISE FND_API.G_EXC_ERROR;
3522: ELSE
3523: x_cost_rec.org_id := pv_cost_rec.org_id;

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

3785: ELSE
3786: IF pv_cost_rec.txn_billing_type_id IS NOT NULL THEN
3787: IF pv_cost_rec.txn_billing_type_id <> l_txn_billing_type_id THEN
3788: --RAISE ERROR
3789: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_INVALID_TXN_BILLING_TYP');
3790: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID', pv_cost_rec.txn_billing_type_id);
3791: FND_MSG_PUB.ADD;
3792: RAISE FND_API.G_EXC_ERROR;
3793: ELSE --

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

3786: IF pv_cost_rec.txn_billing_type_id IS NOT NULL THEN
3787: IF pv_cost_rec.txn_billing_type_id <> l_txn_billing_type_id THEN
3788: --RAISE ERROR
3789: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_INVALID_TXN_BILLING_TYP');
3790: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID', pv_cost_rec.txn_billing_type_id);
3791: FND_MSG_PUB.ADD;
3792: RAISE FND_API.G_EXC_ERROR;
3793: ELSE --
3794: --the ids match

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

3809: x_msg_count => l_msg_count,
3810: x_msg_data => l_msg_data);
3811:
3812: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3813: FND_MESSAGE.SET_NAME('CS', 'CS_COST_INVALID_OU_BILLING_TYP');
3814: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID', pv_cost_rec.txn_billing_type_id);
3815: FND_MSG_PUB.ADD;
3816: RAISE FND_API.G_EXC_ERROR;
3817: End if;

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

3810: x_msg_data => l_msg_data);
3811:
3812: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3813: FND_MESSAGE.SET_NAME('CS', 'CS_COST_INVALID_OU_BILLING_TYP');
3814: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID', pv_cost_rec.txn_billing_type_id);
3815: FND_MSG_PUB.ADD;
3816: RAISE FND_API.G_EXC_ERROR;
3817: End if;
3818:

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

3848: pv_cost_rec.txn_billing_type_id IS NOT NULL THEN
3849: IF pv_cost_rec.txn_billing_type_id <> l_txn_billing_type_id THEN
3850:
3851: --RAISE ERROR
3852: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_INVALID_TXN_BILLING_TYP');
3853: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID', pv_cost_rec.txn_billing_type_id);
3854: FND_MSG_PUB.ADD;
3855: RAISE FND_API.G_EXC_ERROR;
3856: ELSE --

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

3849: IF pv_cost_rec.txn_billing_type_id <> l_txn_billing_type_id THEN
3850:
3851: --RAISE ERROR
3852: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_INVALID_TXN_BILLING_TYP');
3853: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID', pv_cost_rec.txn_billing_type_id);
3854: FND_MSG_PUB.ADD;
3855: RAISE FND_API.G_EXC_ERROR;
3856: ELSE --
3857: --the ids match

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

3943:
3944: --IF l_return_status <> 'S' THEN
3945: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3946: --raise error
3947: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_PRIMARY_UOM_ERROR');
3948: FND_MESSAGE.SET_TOKEN('INV_ID', x_cost_rec.inventory_item_id);
3949: FND_MSG_PUB.ADD;
3950: RAISE FND_API.G_EXC_ERROR;
3951: END IF;

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

3944: --IF l_return_status <> 'S' THEN
3945: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3946: --raise error
3947: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_PRIMARY_UOM_ERROR');
3948: FND_MESSAGE.SET_TOKEN('INV_ID', x_cost_rec.inventory_item_id);
3949: FND_MSG_PUB.ADD;
3950: RAISE FND_API.G_EXC_ERROR;
3951: END IF;
3952:

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

4002:
4003: --IF l_return_status <> 'S' THEN
4004: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
4005: --raise error
4006: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_PRIMARY_UOM_ERROR');
4007: FND_MESSAGE.SET_TOKEN('INV_ID', x_cost_rec.inventory_item_id);
4008: FND_MSG_PUB.ADD;
4009: RAISE FND_API.G_EXC_ERROR;
4010: end if;

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

4003: --IF l_return_status <> 'S' THEN
4004: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
4005: --raise error
4006: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_PRIMARY_UOM_ERROR');
4007: FND_MESSAGE.SET_TOKEN('INV_ID', x_cost_rec.inventory_item_id);
4008: FND_MSG_PUB.ADD;
4009: RAISE FND_API.G_EXC_ERROR;
4010: end if;
4011:

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

4076:
4077: --IF l_return_status <> 'S' THEN
4078: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4079: --raise error
4080: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_PRIMARY_UOM_ERROR');
4081: FND_MESSAGE.SET_TOKEN('INV_ID', pv_cost_rec.unit_of_measure_code);
4082: FND_MSG_PUB.ADD;
4083: RAISE FND_API.G_EXC_ERROR;
4084: END IF;

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

4077: --IF l_return_status <> 'S' THEN
4078: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4079: --raise error
4080: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_PRIMARY_UOM_ERROR');
4081: FND_MESSAGE.SET_TOKEN('INV_ID', pv_cost_rec.unit_of_measure_code);
4082: FND_MSG_PUB.ADD;
4083: RAISE FND_API.G_EXC_ERROR;
4084: END IF;
4085:

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

4135:
4136:
4137: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4138: --raise error
4139: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_PRIMARY_UOM_ERROR');
4140: FND_MESSAGE.SET_TOKEN('INV_ID', pv_cost_rec.unit_of_measure_code);
4141: FND_MSG_PUB.ADD;
4142: RAISE FND_API.G_EXC_ERROR;
4143: END IF;

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

4136:
4137: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4138: --raise error
4139: FND_MESSAGE.SET_NAME('CS', 'CS_COST_GET_PRIMARY_UOM_ERROR');
4140: FND_MESSAGE.SET_TOKEN('INV_ID', pv_cost_rec.unit_of_measure_code);
4141: FND_MSG_PUB.ADD;
4142: RAISE FND_API.G_EXC_ERROR;
4143: END IF;
4144:

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

4190: IS
4191:
4192: BEGIN
4193:
4194: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_CANT_LOCK_RECORD');
4195: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
4196: FND_MSG_PUB.Add;
4197: END Record_IS_Locked_Msg;
4198:

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

4191:
4192: BEGIN
4193:
4194: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_CANT_LOCK_RECORD');
4195: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
4196: FND_MSG_PUB.Add;
4197: END Record_IS_Locked_Msg;
4198:
4199:

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

4462: , 'p_object_type has to be SR.'
4463: );
4464: END IF ;
4465:
4466: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
4467: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4468: FND_MESSAGE.Set_Token('PARAM', 'p_object_type');
4469: FND_MESSAGE.Set_Token('CURRVAL', p_object_type);
4470: FND_MSG_PUB.ADD;

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

4463: );
4464: END IF ;
4465:
4466: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
4467: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4468: FND_MESSAGE.Set_Token('PARAM', 'p_object_type');
4469: FND_MESSAGE.Set_Token('CURRVAL', p_object_type);
4470: FND_MSG_PUB.ADD;
4471:

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

4464: END IF ;
4465:
4466: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
4467: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4468: FND_MESSAGE.Set_Token('PARAM', 'p_object_type');
4469: FND_MESSAGE.Set_Token('CURRVAL', p_object_type);
4470: FND_MSG_PUB.ADD;
4471:
4472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4465:
4466: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
4467: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4468: FND_MESSAGE.Set_Token('PARAM', 'p_object_type');
4469: FND_MESSAGE.Set_Token('CURRVAL', p_object_type);
4470: FND_MSG_PUB.ADD;
4471:
4472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4473: END IF;

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

4485: , 'p_processing_set_id should not be NULL.'
4486: );
4487: END IF ;
4488:
4489: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
4490: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4491: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
4492: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
4493: FND_MSG_PUB.ADD;

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

4486: );
4487: END IF ;
4488:
4489: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
4490: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4491: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
4492: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
4493: FND_MSG_PUB.ADD;
4494:

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

4487: END IF ;
4488:
4489: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
4490: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4491: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
4492: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
4493: FND_MSG_PUB.ADD;
4494:
4495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4488:
4489: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
4490: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4491: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
4492: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
4493: FND_MSG_PUB.ADD;
4494:
4495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4496: END IF;

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

4566: END IF ;
4567:
4568: WHEN OTHERS THEN
4569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4570: FND_MESSAGE.Set_Name('CS', 'CS_COST_LINE_DEL_FAIL');
4571: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4572: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
4573: FND_MSG_PUB.ADD;
4574:

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

4567:
4568: WHEN OTHERS THEN
4569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4570: FND_MESSAGE.Set_Name('CS', 'CS_COST_LINE_DEL_FAIL');
4571: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4572: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
4573: FND_MSG_PUB.ADD;
4574:
4575: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

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

4568: WHEN OTHERS THEN
4569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4570: FND_MESSAGE.Set_Name('CS', 'CS_COST_LINE_DEL_FAIL');
4571: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4572: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
4573: FND_MSG_PUB.ADD;
4574:
4575: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
4576: THEN