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_MSG_PUB

Line 69: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

65: p_token_p VARCHAR2
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);

Line 74: FND_MSG_PUB.Add;

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

Line 89: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

85: ) IS
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;

Line 93: FND_MSG_PUB.Add;

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

Line 176: FND_MSG_PUB.add;

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:
180: END IS_CHARGE_LINE_TYPE_VALID;

Line 218: FND_MSG_PUB.add;

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:
222: END IS_INCIDENT_ID_VALID;

Line 260: FND_MSG_PUB.add;

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:
264: END IS_ESTIMATE_DETAIL_ID_VALID;

Line 319: FND_MSG_PUB.Add;

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

Line 343: FND_MSG_PUB.Add;

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:
347: ELSE

Line 366: FND_MSG_PUB.Add;

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:
370: ELSE

Line 391: fnd_msg_pub.count_and_get(p_count => x_msg_count

387: EXCEPTION
388:
389: WHEN FND_API.G_EXC_ERROR THEN
390: x_return_status := FND_API.G_RET_STS_ERROR;
391: fnd_msg_pub.count_and_get(p_count => x_msg_count
392: ,p_data => x_msg_data);
393:
394: WHEN NO_DATA_FOUND THEN
395: x_return_status := FND_API.G_RET_STS_ERROR;

Line 408: FND_MSG_PUB.Add;

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:
412: END Validate_Source;

Line 409: fnd_msg_pub.count_and_get(p_count => x_msg_count

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:
412: END Validate_Source;
413:

Line 453: fnd_msg_pub.count_and_get(

449: p_token_an => p_api_name,
450: p_token_v => to_char(p_org_id) ,
451: p_token_p => 'p_org_id') ;
452:
453: fnd_msg_pub.count_and_get(
454: p_count => x_msg_count
455: ,p_data => x_msg_data);
456:
457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 500: FND_MSG_PUB.add;

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:
504: END IS_ITEM_VALID;

Line 558: FND_MSG_PUB.add;

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

Line 604: FND_MSG_PUB.add;

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

Line 648: FND_MSG_PUB.add;

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

Line 689: FND_MSG_PUB.add;

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

Line 731: FND_MSG_PUB.add;

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:
735: END IS_CURRENCY_CODE_VALID;

Line 772: FND_MSG_PUB.add;

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:
776: END IS_COST_ID_VALID;

Line 902: fnd_msg_pub.count_and_get(

898: p_token_an => p_api_name,
899: p_token_v => to_char(p_transaction_type_id) ,
900: p_token_p => 'p_transaction_type_id') ;
901:
902: fnd_msg_pub.count_and_get(
903: p_count => x_msg_count
904: ,p_data => x_msg_data);
905:
906: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 999: fnd_msg_pub.count_and_get(

995: CS_COST_DETAILS_PVT.Add_Invalid_Argument_Msg(
996: p_token_an => p_api_name,
997: p_token_v => to_char(p_cost_id) ,
998: p_token_p => 'p_cost_id') ;
999: fnd_msg_pub.count_and_get(
1000: p_count => x_msg_count
1001: ,p_data => x_msg_data);
1002:
1003: WHEN RECORD_LOCK_EXCEPTION THEN

Line 1012: FND_MSG_PUB.add;

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

Line 1013: fnd_msg_pub.count_and_get(

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);
1016:
1017: END;

Line 1161: FND_MSG_PUB.add;

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

Line 1162: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

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;
1165:
1166: --===============================

Line 1323: FND_MSG_PUB.Add;

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

Line 1331: fnd_msg_pub.count_and_get(

1327: EXCEPTION
1328:
1329: WHEN FND_API.G_EXC_ERROR THEN
1330: x_return_status := FND_API.G_RET_STS_ERROR;
1331: fnd_msg_pub.count_and_get(
1332: p_count => x_msg_count
1333: ,p_data => x_msg_data);
1334:
1335: WHEN OTHERS THEN

Line 1340: FND_MSG_PUB.Add;

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

Line 1341: fnd_msg_pub.count_and_get(

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);
1344:
1345: END GET_TXN_BILLING_TYPE;

Line 1435: FND_MSG_PUB.Initialize;

1431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1432: END IF;
1433: -- Initialize message list if p_init_msg_list is set to TRUE
1434: IF FND_API.To_Boolean(p_init_msg_list) THEN
1435: FND_MSG_PUB.Initialize;
1436: END IF;
1437: -- Initialize API return status to success
1438: x_return_status := FND_API.G_RET_STS_SUCCESS;
1439:

Line 1538: FND_MSG_PUB.ADD;

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:
1542: --call get_charge_details to get the data from cs_estimate_details table

Line 1601: FND_MSG_PUB.ADD;

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:
1605: Else

Line 1608: FND_MSG_PUB.ADD;

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;
1612: --end Bug 6972425

Line 1672: FND_MSG_PUB.ADD;

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

Line 1677: 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;
1681: else -- transaction_type_id is null

Line 1779: FND_MSG_PUB.Add;

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
1783: THEN

Line 1992: FND_MSG_PUB.Count_And_Get

1988: 'After calling the Insert Row '
1989: );
1990: END IF;
1991:
1992: FND_MSG_PUB.Count_And_Get
1993: ( p_count => x_msg_count,
1994: p_data => x_msg_data,
1995: p_encoded => FND_API.G_FALSE) ;
1996:

Line 2005: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2001: IF FND_API.To_Boolean(p_transaction_control)
2002: THEN
2003: ROLLBACK TO Create_Cost_Details_PVT;
2004: END IF ;
2005: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2006: p_data => x_msg_data,
2007: p_encoded => FND_API.G_FALSE) ;
2008:
2009: WHEN G_WARNING THEN

Line 2015: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2011: IF FND_API.To_Boolean(p_transaction_control)
2012: THEN
2013: ROLLBACK TO Create_Cost_Details_PVT;
2014: END IF ;
2015: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2016: p_data => x_msg_data,
2017: p_encoded => FND_API.G_FALSE) ;
2018:
2019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2024: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2020: IF FND_API.To_Boolean(p_transaction_control) THEN
2021: ROLLBACK TO Create_Cost_Details_PVT;
2022: END IF ;
2023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2024: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2025: p_data => x_msg_data,
2026: p_encoded => FND_API.G_FALSE) ;
2027:
2028: WHEN OTHERS THEN

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

2029: IF FND_API.To_Boolean(p_transaction_control) THEN
2030: ROLLBACK TO Create_Cost_Details_PVT;
2031: END IF ;
2032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2033: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2034: THEN
2035: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2036: END IF;
2037: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

2031: END IF ;
2032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2033: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2034: THEN
2035: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2036: END IF;
2037: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2038: p_data => x_msg_data,
2039: p_encoded => FND_API.G_FALSE) ;

Line 2037: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2033: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2034: THEN
2035: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2036: END IF;
2037: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2038: p_data => x_msg_data,
2039: p_encoded => FND_API.G_FALSE) ;
2040:
2041: END create_cost_details;

Line 2140: FND_MSG_PUB.Initialize;

2136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2137: END IF;
2138: -- Initialize message list if p_init_msg_list is set to TRUE
2139: IF FND_API.To_Boolean(p_init_msg_list) THEN
2140: FND_MSG_PUB.Initialize;
2141: END IF;
2142: -- Initialize API return status to success
2143: x_return_status := FND_API.G_RET_STS_SUCCESS;
2144:

Line 2262: FND_MSG_PUB.ADD;

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:
2266: GET_CHARGE_DETAILS

Line 2324: FND_MSG_PUB.ADD;

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:
2328: Else

Line 2332: FND_MSG_PUB.ADD;

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:
2336: end if;

Line 2405: FND_MSG_PUB.Add;

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:
2409: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

Line 2608: FND_MSG_PUB.Count_And_Get

2604:
2605: END IF;
2606:
2607: -- Standard call to get message count and if count is 1, get message info
2608: FND_MSG_PUB.Count_And_Get
2609: ( p_count => x_msg_count,
2610: p_data => x_msg_data
2611: );
2612:

Line 2621: FND_MSG_PUB.Count_And_Get(

2617: IF FND_API.To_Boolean(p_transaction_control) THEN
2618: ROLLBACK TO Update_Cost_Details_PVT;
2619: END IF ;
2620: x_return_status := FND_API.G_RET_STS_ERROR;
2621: FND_MSG_PUB.Count_And_Get(
2622: p_count => x_msg_count,
2623: p_data => x_msg_data,
2624: p_encoded => FND_API.G_FALSE) ;
2625:

Line 2632: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2628:
2629: IF FND_API.To_Boolean(p_transaction_control) THEN
2630: ROLLBACK TO Update_Cost_Details_PVT;
2631: END IF ;
2632: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2633: p_data => x_msg_data,
2634: p_encoded => FND_API.G_FALSE) ;
2635:
2636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2641: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2637: IF FND_API.To_Boolean(p_transaction_control) THEN
2638: ROLLBACK TO Update_Cost_Details_PVT;
2639: END IF ;
2640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2641: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2642: p_data => x_msg_data,
2643: p_encoded => FND_API.G_FALSE) ;
2644: WHEN OTHERS THEN
2645: IF FND_API.To_Boolean(p_transaction_control) THEN

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

2645: IF FND_API.To_Boolean(p_transaction_control) THEN
2646: ROLLBACK TO Update_Cost_Details_PVT;
2647: END IF ;
2648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2649: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2650: THEN
2651: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2652: END IF;
2653: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

2647: END IF ;
2648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2649: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2650: THEN
2651: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2652: END IF;
2653: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2654: p_data => x_msg_data,
2655: p_encoded => FND_API.G_FALSE) ;

Line 2653: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2649: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2650: THEN
2651: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2652: END IF;
2653: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2654: p_data => x_msg_data,
2655: p_encoded => FND_API.G_FALSE) ;
2656:
2657:

Line 2713: FND_MSG_PUB.initialize ;

2709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2710: END IF ;
2711: --Initialize the message list if p_msg_list is set to TRUE
2712: IF FND_API.To_Boolean(p_init_msg_list) THEN
2713: FND_MSG_PUB.initialize ;
2714: END IF ;
2715:
2716: --Initialize the API Return Success to True
2717: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 2810: FND_MSG_PUB.ADD;

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

Line 2825: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

2821: COMMIT WORK ;
2822: END IF ;
2823:
2824: --Standard call to get message count and if count is 1 , get message info
2825: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
2826: p_data => x_msg_data) ;
2827:
2828: --Begin Exception Handling
2829:

Line 2837: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2833: IF FND_API.To_Boolean( p_transaction_control ) THEN
2834: ROLLBACK TO Delete_Cost_Details_PVT;
2835: END IF ;
2836: x_return_status := FND_API.G_RET_STS_ERROR ;
2837: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2838: p_data => x_msg_data,
2839: p_encoded => FND_API.G_FALSE) ;
2840:
2841: WHEN G_WARNING THEN

Line 2846: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2842: x_return_status := FND_API.G_RET_STS_SUCCESS;
2843: IF FND_API.To_Boolean(p_transaction_control) THEN
2844: ROLLBACK TO Delete_Cost_Details_PVT;
2845: END IF ;
2846: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2847: p_data => x_msg_data,
2848: p_encoded => FND_API.G_FALSE) ;
2849:
2850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2855: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2851: IF FND_API.To_Boolean( p_transaction_control ) THEN
2852: ROLLBACK TO Delete_Cost_Details_PVT;
2853: END IF ;
2854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2855: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2856: p_data => x_msg_data,
2857: p_encoded => FND_API.G_FALSE) ;
2858:
2859: WHEN OTHERS THEN

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

2860: IF FND_API.To_Boolean( p_transaction_control ) THEN
2861: ROLLBACK TO Delete_Cost_Details_PVT;
2862: END IF ;
2863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2864: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2865: THEN
2866: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2867: END IF ;
2868: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

2862: END IF ;
2863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2864: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2865: THEN
2866: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2867: END IF ;
2868: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2869: p_data => x_msg_data,
2870: p_encoded => FND_API.G_FALSE) ;

Line 2868: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2864: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2865: THEN
2866: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2867: END IF ;
2868: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2869: p_data => x_msg_data,
2870: p_encoded => FND_API.G_FALSE) ;
2871:
2872: End Delete_Cost_Details;

Line 3165: FND_MSG_PUB.ADD;

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:
3169: Else

Line 3174: FND_MSG_PUB.ADD;

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:
3178: end if;

Line 3186: FND_MSG_PUB.ADD;

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:
3190: Else

Line 3194: FND_MSG_PUB.ADD;

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:
3198: end if;

Line 3436: FND_MSG_PUB.ADD;

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;
3440: end if;

Line 3520: FND_MSG_PUB.ADD;

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

Line 3791: FND_MSG_PUB.ADD;

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
3795: --assign to the out record

Line 3815: FND_MSG_PUB.ADD;

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

Line 3854: FND_MSG_PUB.ADD;

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
3858: --assign to the out record

Line 3949: FND_MSG_PUB.ADD;

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:
3953: --assign to out record

Line 4008: FND_MSG_PUB.ADD;

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:
4012: --assign to out record

Line 4082: FND_MSG_PUB.ADD;

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:
4086: --assign to out record

Line 4141: FND_MSG_PUB.ADD;

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:
4145: --assign to out record

Line 4168: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

4164:
4165: WHEN FND_API.G_EXC_ERROR THEN
4166: x_return_status := FND_API.G_RET_STS_ERROR;
4167:
4168: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4169: p_data => x_msg_data,
4170: p_encoded => FND_API.G_FALSE) ;
4171: WHEN OTHERS THEN
4172: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4173: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

4169: p_data => x_msg_data,
4170: p_encoded => FND_API.G_FALSE) ;
4171: WHEN OTHERS THEN
4172: x_return_status := FND_API.G_RET_STS_ERROR;
4173: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4174: p_data => x_msg_data,
4175: p_encoded => FND_API.G_FALSE) ;
4176:
4177:

Line 4196: FND_MSG_PUB.Add;

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:
4200: PROCEDURE Validate_Who_Info(

Line 4437: FND_MSG_PUB.Count_And_Get

4433: , L_API_NAME
4434: , G_PKG_NAME
4435: )
4436: THEN
4437: FND_MSG_PUB.Count_And_Get
4438: (
4439: p_count => x_msg_count
4440: , p_data => x_msg_data
4441: );

Line 4447: FND_MSG_PUB.initialize;

4443: END IF ;
4444:
4445: IF FND_API.to_Boolean(p_init_msg_list)
4446: THEN
4447: FND_MSG_PUB.initialize;
4448: END IF ;
4449:
4450: ------------------------------------------------------------------------------
4451: -- Parameter Validations:

Line 4470: FND_MSG_PUB.ADD;

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

Line 4493: FND_MSG_PUB.ADD;

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

Line 4573: FND_MSG_PUB.ADD;

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
4577: FND_LOG.String