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 1444: FND_MSG_PUB.Initialize;

1440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1441: END IF;
1442: -- Initialize message list if p_init_msg_list is set to TRUE
1443: IF FND_API.To_Boolean(p_init_msg_list) THEN
1444: FND_MSG_PUB.Initialize;
1445: END IF;
1446: -- Initialize API return status to success
1447: x_return_status := FND_API.G_RET_STS_SUCCESS;
1448:

Line 1547: FND_MSG_PUB.ADD;

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

Line 1610: FND_MSG_PUB.ADD;

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

Line 1617: FND_MSG_PUB.ADD;

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

Line 1681: FND_MSG_PUB.ADD;

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

Line 1686: 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;
1690: else -- transaction_type_id is null

Line 1788: FND_MSG_PUB.Add;

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

Line 1910: FND_MSG_PUB.ADD;

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

Line 2036: FND_MSG_PUB.Count_And_Get

2032: 'After calling the Insert Row '
2033: );
2034: END IF;
2035:
2036: FND_MSG_PUB.Count_And_Get
2037: ( p_count => x_msg_count,
2038: p_data => x_msg_data,
2039: p_encoded => FND_API.G_FALSE) ;
2040:

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

2045: IF FND_API.To_Boolean(p_transaction_control)
2046: THEN
2047: ROLLBACK TO Create_Cost_Details_PVT;
2048: END IF ;
2049: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2050: p_data => x_msg_data,
2051: p_encoded => FND_API.G_FALSE) ;
2052:
2053: WHEN G_WARNING THEN

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

2055: IF FND_API.To_Boolean(p_transaction_control)
2056: THEN
2057: ROLLBACK TO Create_Cost_Details_PVT;
2058: END IF ;
2059: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2060: p_data => x_msg_data,
2061: p_encoded => FND_API.G_FALSE) ;
2062:
2063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2064: IF FND_API.To_Boolean(p_transaction_control) THEN
2065: ROLLBACK TO Create_Cost_Details_PVT;
2066: END IF ;
2067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2068: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2069: p_data => x_msg_data,
2070: p_encoded => FND_API.G_FALSE) ;
2071:
2072: WHEN OTHERS THEN

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

2073: IF FND_API.To_Boolean(p_transaction_control) THEN
2074: ROLLBACK TO Create_Cost_Details_PVT;
2075: END IF ;
2076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2077: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2078: THEN
2079: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2080: END IF;
2081: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

2075: END IF ;
2076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2077: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2078: THEN
2079: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2080: END IF;
2081: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2082: p_data => x_msg_data,
2083: p_encoded => FND_API.G_FALSE) ;

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

2077: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2078: THEN
2079: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2080: END IF;
2081: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2082: p_data => x_msg_data,
2083: p_encoded => FND_API.G_FALSE) ;
2084:
2085: END create_cost_details;

Line 2194: FND_MSG_PUB.Initialize;

2190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2191: END IF;
2192: -- Initialize message list if p_init_msg_list is set to TRUE
2193: IF FND_API.To_Boolean(p_init_msg_list) THEN
2194: FND_MSG_PUB.Initialize;
2195: END IF;
2196: -- Initialize API return status to success
2197: x_return_status := FND_API.G_RET_STS_SUCCESS;
2198:

Line 2316: FND_MSG_PUB.ADD;

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

Line 2378: FND_MSG_PUB.ADD;

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

Line 2386: FND_MSG_PUB.ADD;

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

Line 2459: FND_MSG_PUB.Add;

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

Line 2594: FND_MSG_PUB.ADD;

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

Line 2711: FND_MSG_PUB.Count_And_Get

2707:
2708: END IF;
2709:
2710: -- Standard call to get message count and if count is 1, get message info
2711: FND_MSG_PUB.Count_And_Get
2712: ( p_count => x_msg_count,
2713: p_data => x_msg_data
2714: );
2715:

Line 2724: FND_MSG_PUB.Count_And_Get(

2720: IF FND_API.To_Boolean(p_transaction_control) THEN
2721: ROLLBACK TO Update_Cost_Details_PVT;
2722: END IF ;
2723: x_return_status := FND_API.G_RET_STS_ERROR;
2724: FND_MSG_PUB.Count_And_Get(
2725: p_count => x_msg_count,
2726: p_data => x_msg_data,
2727: p_encoded => FND_API.G_FALSE) ;
2728:

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

2731:
2732: IF FND_API.To_Boolean(p_transaction_control) THEN
2733: ROLLBACK TO Update_Cost_Details_PVT;
2734: END IF ;
2735: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2736: p_data => x_msg_data,
2737: p_encoded => FND_API.G_FALSE) ;
2738:
2739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2740: IF FND_API.To_Boolean(p_transaction_control) THEN
2741: ROLLBACK TO Update_Cost_Details_PVT;
2742: END IF ;
2743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2744: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2745: p_data => x_msg_data,
2746: p_encoded => FND_API.G_FALSE) ;
2747: WHEN OTHERS THEN
2748: IF FND_API.To_Boolean(p_transaction_control) THEN

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

2748: IF FND_API.To_Boolean(p_transaction_control) THEN
2749: ROLLBACK TO Update_Cost_Details_PVT;
2750: END IF ;
2751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2752: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2753: THEN
2754: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2755: END IF;
2756: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

2750: END IF ;
2751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2752: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2753: THEN
2754: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2755: END IF;
2756: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2757: p_data => x_msg_data,
2758: p_encoded => FND_API.G_FALSE) ;

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

2752: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2753: THEN
2754: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2755: END IF;
2756: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2757: p_data => x_msg_data,
2758: p_encoded => FND_API.G_FALSE) ;
2759:
2760:

Line 2816: FND_MSG_PUB.initialize ;

2812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2813: END IF ;
2814: --Initialize the message list if p_msg_list is set to TRUE
2815: IF FND_API.To_Boolean(p_init_msg_list) THEN
2816: FND_MSG_PUB.initialize ;
2817: END IF ;
2818:
2819: --Initialize the API Return Success to True
2820: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 2913: FND_MSG_PUB.ADD;

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

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

2924: COMMIT WORK ;
2925: END IF ;
2926:
2927: --Standard call to get message count and if count is 1 , get message info
2928: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
2929: p_data => x_msg_data) ;
2930:
2931: --Begin Exception Handling
2932:

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

2936: IF FND_API.To_Boolean( p_transaction_control ) THEN
2937: ROLLBACK TO Delete_Cost_Details_PVT;
2938: END IF ;
2939: x_return_status := FND_API.G_RET_STS_ERROR ;
2940: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2941: p_data => x_msg_data,
2942: p_encoded => FND_API.G_FALSE) ;
2943:
2944: WHEN G_WARNING THEN

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

2945: x_return_status := FND_API.G_RET_STS_SUCCESS;
2946: IF FND_API.To_Boolean(p_transaction_control) THEN
2947: ROLLBACK TO Delete_Cost_Details_PVT;
2948: END IF ;
2949: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2950: p_data => x_msg_data,
2951: p_encoded => FND_API.G_FALSE) ;
2952:
2953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2954: IF FND_API.To_Boolean( p_transaction_control ) THEN
2955: ROLLBACK TO Delete_Cost_Details_PVT;
2956: END IF ;
2957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2958: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2959: p_data => x_msg_data,
2960: p_encoded => FND_API.G_FALSE) ;
2961:
2962: WHEN OTHERS THEN

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

2963: IF FND_API.To_Boolean( p_transaction_control ) THEN
2964: ROLLBACK TO Delete_Cost_Details_PVT;
2965: END IF ;
2966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2967: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2968: THEN
2969: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2970: END IF ;
2971: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

2965: END IF ;
2966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2967: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2968: THEN
2969: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2970: END IF ;
2971: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2972: p_data => x_msg_data,
2973: p_encoded => FND_API.G_FALSE) ;

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

2967: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2968: THEN
2969: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2970: END IF ;
2971: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2972: p_data => x_msg_data,
2973: p_encoded => FND_API.G_FALSE) ;
2974:
2975: End Delete_Cost_Details;

Line 3268: FND_MSG_PUB.ADD;

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

Line 3277: FND_MSG_PUB.ADD;

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

Line 3289: FND_MSG_PUB.ADD;

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

Line 3297: FND_MSG_PUB.ADD;

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

Line 3539: FND_MSG_PUB.ADD;

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

Line 3623: FND_MSG_PUB.ADD;

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

Line 3894: FND_MSG_PUB.ADD;

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

Line 3918: FND_MSG_PUB.ADD;

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

Line 3957: FND_MSG_PUB.ADD;

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

Line 4052: FND_MSG_PUB.ADD;

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

Line 4111: FND_MSG_PUB.ADD;

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

Line 4185: FND_MSG_PUB.ADD;

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

Line 4244: FND_MSG_PUB.ADD;

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

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

4267:
4268: WHEN FND_API.G_EXC_ERROR THEN
4269: x_return_status := FND_API.G_RET_STS_ERROR;
4270:
4271: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4272: p_data => x_msg_data,
4273: p_encoded => FND_API.G_FALSE) ;
4274: WHEN OTHERS THEN
4275: x_return_status := FND_API.G_RET_STS_ERROR;

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

4272: p_data => x_msg_data,
4273: p_encoded => FND_API.G_FALSE) ;
4274: WHEN OTHERS THEN
4275: x_return_status := FND_API.G_RET_STS_ERROR;
4276: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4277: p_data => x_msg_data,
4278: p_encoded => FND_API.G_FALSE) ;
4279:
4280:

Line 4299: FND_MSG_PUB.Add;

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

Line 4540: FND_MSG_PUB.Count_And_Get

4536: , L_API_NAME
4537: , G_PKG_NAME
4538: )
4539: THEN
4540: FND_MSG_PUB.Count_And_Get
4541: (
4542: p_count => x_msg_count
4543: , p_data => x_msg_data
4544: );

Line 4550: FND_MSG_PUB.initialize;

4546: END IF ;
4547:
4548: IF FND_API.to_Boolean(p_init_msg_list)
4549: THEN
4550: FND_MSG_PUB.initialize;
4551: END IF ;
4552:
4553: ------------------------------------------------------------------------------
4554: -- Parameter Validations:

Line 4573: FND_MSG_PUB.ADD;

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

Line 4596: FND_MSG_PUB.ADD;

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

Line 4676: FND_MSG_PUB.ADD;

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