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_SR_EXTATTRIBUTES_PVT dependencies on FND_MSG_PUB

Line 374: FND_MSG_PUB.initialize;

370: END IF;
371:
372: -- Initialize message list if p_init_msg_list is set to TRUE.
373: IF FND_API.to_Boolean(p_init_msg_list) THEN
374: FND_MSG_PUB.initialize;
375: END IF;
376:
377: -- Initialize API return status to SUCCESS
378: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 471: FND_MSG_PUB.Add;

467: , x_msg_data => x_msg_data
468: );
469: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
470: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');
471: FND_MSG_PUB.Add;
472: RAISE FND_API.G_EXC_ERROR;
473: END IF;
474:
475: -- Added FND_LOG

Line 524: FND_MSG_PUB.Add;

520:
521:
522: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
523: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');
524: FND_MSG_PUB.Add;
525: RAISE FND_API.G_EXC_ERROR;
526: END IF;
527:
528: --Added FND_LOG

Line 552: FND_MSG_PUB.Add;

548:
549: IF l_rec_found = 'N' THEN
550: --raise error
551: FND_MESSAGE.Set_Name('CS', 'CS_API_POP_SR_EXT_ATTR_WARN');
552: FND_MSG_PUB.Add;
553: RAISE FND_API.G_EXC_ERROR;
554: END IF;
555: END LOOP;
556:

Line 579: FND_MSG_PUB.Add;

575:
576: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
577: --raise error
578: FND_MESSAGE.Set_Name('CS', 'CS_API_POP_SR_EXT_ATTR_WARN');
579: FND_MSG_PUB.Add;
580: RAISE FND_API.G_EXC_ERROR;
581: END IF;
582:
583: --Added FND_LOG

Line 1178: FND_MSG_PUB.Add;

1174: , x_msg_data => x_msg_data
1175: );
1176: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1177: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');
1178: FND_MSG_PUB.Add;
1179: RAISE FND_API.G_EXC_ERROR;
1180: END IF;
1181: END IF; -- l_cont_chg_on_update = 'Y'
1182: --on last record

Line 1218: FND_MSG_PUB.Add;

1214: --DBMS_OUTPUT.PUT_LINE('x_msg_data'||x_msg_data);
1215:
1216: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1217: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');
1218: FND_MSG_PUB.Add;
1219: RAISE FND_API.G_EXC_ERROR;
1220: END IF;
1221:
1222: --DBMS_OUTPUT.PUT_LINE('Calling populate_sr_ext_attr_audit_rec'); --executed

Line 1255: FND_MSG_PUB.Add;

1251:
1252: IF l_rec_found = 'N' THEN
1253: --raise error
1254: FND_MESSAGE.Set_Name('CS', 'CS_API_POP_SR_EXT_ATTR_WARN');
1255: FND_MSG_PUB.Add;
1256: RAISE FND_API.G_EXC_ERROR;
1257: END IF;
1258: END LOOP;
1259:

Line 1350: FND_MSG_PUB.Add;

1346:
1347: *****************************************************/
1348: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1349: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');
1350: FND_MSG_PUB.Add;
1351: RAISE FND_API.G_EXC_ERROR;
1352: END IF;
1353:
1354:

Line 1399: FND_MSG_PUB.Add;

1395: ,x_msg_data => x_msg_data );
1396:
1397: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1398: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');
1399: FND_MSG_PUB.Add;
1400: RAISE FND_API.G_EXC_ERROR;
1401: END IF;
1402:
1403: --reset the old_context to null;

Line 1426: FND_MSG_PUB.Add;

1422:
1423: IF l_rec_found = 'N' THEN
1424: --raise error
1425: FND_MESSAGE.Set_Name('CS', 'CS_API_POP_PR_EXT_ATTR_WARN');
1426: FND_MSG_PUB.Add;
1427: RAISE FND_API.G_EXC_ERROR;
1428: END IF;
1429: END LOOP;
1430:

Line 1670: FND_MSG_PUB.Add;

1666: -- call check_sr_context_change to check if context has changed during the update
1667: -- operation
1668: -- Raise error
1669: FND_MESSAGE.Set_Name('CS', 'CS_API_POP_PR_EXT_ATTR_WARN');
1670: FND_MSG_PUB.Add;
1671: RAISE FND_API.G_EXC_ERROR;
1672:
1673: ELSE
1674: --treat this record as a 'UPDATE'

Line 1721: FND_MSG_PUB.Add;

1717: -- call check_sr_context_change to check if context has changed during the update
1718: -- operation
1719: -- Raise error
1720: FND_MESSAGE.Set_Name('CS', 'CS_API_POP_PR_EXT_ATTR_WARN');
1721: FND_MSG_PUB.Add;
1722: RAISE FND_API.G_EXC_ERROR;
1723:
1724: ELSE
1725: --treat this record as a 'UPDATE'

Line 1891: FND_MSG_PUB.Add;

1887: ,x_msg_data => x_msg_data );
1888:
1889: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1890: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');
1891: FND_MSG_PUB.Add;
1892: RAISE FND_API.G_EXC_ERROR;
1893: END IF;
1894:
1895:

Line 1915: FND_MSG_PUB.Add;

1911:
1912: IF l_rec_found = 'N' THEN
1913: --raise error
1914: FND_MESSAGE.Set_Name('CS', 'CS_API_POP_PR_EXT_ATTR_WARN');
1915: FND_MSG_PUB.Add;
1916: RAISE FND_API.G_EXC_ERROR;
1917: END IF;
1918: END LOOP;
1919:

Line 1964: FND_MSG_PUB.Count_And_Get

1960:
1961: WHEN FND_API.G_EXC_ERROR THEN
1962: ROLLBACK TO CS_EXTENSIBILITY_PVT;
1963: x_return_status := FND_API.G_RET_STS_ERROR;
1964: FND_MSG_PUB.Count_And_Get
1965: ( p_count => x_msg_count,
1966: p_data => x_msg_data
1967: );
1968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1971: FND_MSG_PUB.Count_And_Get

1967: );
1968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1969: ROLLBACK TO CS_EXTENSIBILITY_PVT;
1970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1971: FND_MSG_PUB.Count_And_Get
1972: ( p_count => x_msg_count,
1973: p_data => x_msg_data
1974: );
1975: WHEN OTHERS THEN

Line 1978: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1974: );
1975: WHEN OTHERS THEN
1976: ROLLBACK TO CS_EXTENSIBILITY_PVT;
1977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1978: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1979: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1980: END IF;
1981: FND_MSG_PUB.Count_And_Get
1982: ( p_count => x_msg_count,

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

1975: WHEN OTHERS THEN
1976: ROLLBACK TO CS_EXTENSIBILITY_PVT;
1977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1978: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1979: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1980: END IF;
1981: FND_MSG_PUB.Count_And_Get
1982: ( p_count => x_msg_count,
1983: p_data => x_msg_data

Line 1981: FND_MSG_PUB.Count_And_Get

1977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1978: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1979: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1980: END IF;
1981: FND_MSG_PUB.Count_And_Get
1982: ( p_count => x_msg_count,
1983: p_data => x_msg_data
1984: );
1985:

Line 2016: --FND_MSG_PUB.add;

2012: --FND_MESSAGE.SET_NAME(G_APP_NAME);
2013: --FND_MESSAGE.SET_TOKEN(token => G_PROC_NAME_TOKEN, value => l_prog_name);
2014: --FND_MESSAGE.SET_TOKEN(token => G_SQLCODE_TOKEN, value => SQLCODE);
2015: --FND_MESSAGE.SET_TOKEN(token => G_SQLERRM_TOKEN, value => SQLERRM);
2016: --FND_MSG_PUB.add;
2017:
2018: END Get_Attr_Group_Metadata;
2019:
2020: PROCEDURE Get_Attr_Metadata (

Line 4033: FND_MSG_PUB.initialize;

4029: END IF;
4030:
4031: -- Initialize message list if p_init_msg_list is set to TRUE.
4032: IF FND_API.to_Boolean(p_init_msg_list) THEN
4033: FND_MSG_PUB.initialize;
4034: END IF;
4035:
4036: -- Initialize API return status to SUCCESS
4037: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4234: FND_MSG_PUB.ADD;

4230: -- Raise error
4231: --composite key missing
4232: FND_MESSAGE.SET_NAME('CS', 'CS_API_SR_EXTATTR_COMP_KEY_REQ');
4233: FND_MESSAGE.SET_TOKEN('API_NAME', l_api_name);
4234: FND_MSG_PUB.ADD;
4235: RAISE FND_API.G_EXC_ERROR;
4236: END IF; -- composite key end if
4237:
4238:

Line 4260: FND_MSG_PUB.ADD;

4256: --attribute group is null
4257: --raise error
4258: FND_MESSAGE.SET_NAME('CS', 'CS_API_SR_EXT_ATTR_GROUP_REQ');
4259: FND_MESSAGE.SET_TOKEN('API_NAME', l_api_name);
4260: FND_MSG_PUB.ADD;
4261: RAISE FND_API.G_EXC_ERROR;
4262: END IF; --v_get_sr_ext_attr.attr_group_id IS NOT NULL
4263:
4264: END LOOP;

Line 4340: FND_MSG_PUB.Add;

4336:
4337:
4338: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4339: FND_MESSAGE.Set_Name('CS', 'CS_API_GET_SR_EXT_ATTR_WARNING');
4340: FND_MSG_PUB.Add;
4341: RAISE FND_API.G_EXC_ERROR;
4342: END IF;
4343:
4344: --populate the out parameters with the value returned from PLM

Line 4566: FND_MSG_PUB.ADD;

4562: --composite key missing
4563: -- MAYA need to add
4564: FND_MESSAGE.SET_NAME('CS', 'CS_API_SR_EXTATTR_COMP_KEY_REQ');
4565: FND_MESSAGE.SET_TOKEN('API_NAME', l_api_name);
4566: FND_MSG_PUB.ADD;
4567: RAISE FND_API.G_EXC_ERROR;
4568: END IF; -- composite key end if
4569:
4570:

Line 4590: FND_MSG_PUB.ADD;

4586: --attribute group is null
4587: --raise error
4588: FND_MESSAGE.SET_NAME('CS', 'CS_API_SR_EXT_ATTR_GROUP_REQ');
4589: FND_MESSAGE.SET_TOKEN('API_NAME', l_api_name);
4590: FND_MSG_PUB.ADD;
4591: RAISE FND_API.G_EXC_ERROR;
4592:
4593: END IF; --v_get_pr_ext_attr.attr_group_id IS NOT NULL
4594:

Line 4660: FND_MSG_PUB.Add;

4656: END IF;
4657:
4658: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4659: FND_MESSAGE.Set_Name('CS', 'CS_API_GET_SR_EXT_ATTR_WARNING');
4660: FND_MSG_PUB.Add;
4661: RAISE FND_API.G_EXC_ERROR;
4662: END IF;
4663:
4664: --populate the out parameters with the value returned from PLM

Line 4791: FND_MSG_PUB.Count_And_Get

4787:
4788: EXCEPTION
4789: WHEN FND_API.G_EXC_ERROR THEN
4790: x_return_status := FND_API.G_RET_STS_ERROR;
4791: FND_MSG_PUB.Count_And_Get
4792: ( p_count => x_msg_count,
4793: p_data => x_msg_data
4794: );
4795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4797: FND_MSG_PUB.Count_And_Get

4793: p_data => x_msg_data
4794: );
4795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4797: FND_MSG_PUB.Count_And_Get
4798: ( p_count => x_msg_count,
4799: p_data => x_msg_data
4800: );
4801:

Line 4807: FND_MSG_PUB.ADD;

4803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4804: FND_MESSAGE.Set_Name('CS', 'CS_GET_SR_EXT_ATTR_FAIL');
4805: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4806: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
4807: FND_MSG_PUB.ADD;
4808:
4809: END;
4810:
4811: PROCEDURE Create_Ext_Attr_Audit(

Line 5133: FND_MSG_PUB.Count_And_Get

5129: END LOOP;
5130: EXCEPTION
5131: WHEN OTHERS THEN
5132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5133: FND_MSG_PUB.Count_And_Get
5134: (p_count => x_msg_count,
5135: p_data => x_msg_data);
5136:
5137: END Merge_Ext_Attrs_Details;

Line 5759: FND_MSG_PUB.ADD;

5755: --DBMS_OUTPUT.PUT_LINE('when other ..');
5756: --DBMS_OUTPUT.PUT_LINE(substr(SQLERRM,1,200));
5757: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5758: FND_MESSAGE.set_token('P_TEXT','cs_sr_ext_attr_data_pvt.insert_sr_row'||'-'||substr(SQLERRM,1,200));
5759: FND_MSG_PUB.ADD;
5760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5761:
5762: END insert_sr_row;
5763:

Line 6382: FND_MSG_PUB.ADD;

6378: WHEN OTHERS THEN
6379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6380: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6381: FND_MESSAGE.set_token('P_TEXT','cs_sr_ext_attr_data_pvt.insert_sr_row'||'-'||substr(SQLERRM,1,200));
6382: FND_MSG_PUB.ADD;
6383: FND_MSG_PUB.Count_And_Get
6384: ( p_count => x_msg_count
6385: , p_data => x_msg_data
6386: );

Line 6383: FND_MSG_PUB.Count_And_Get

6379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6380: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6381: FND_MESSAGE.set_token('P_TEXT','cs_sr_ext_attr_data_pvt.insert_sr_row'||'-'||substr(SQLERRM,1,200));
6382: FND_MSG_PUB.ADD;
6383: FND_MSG_PUB.Count_And_Get
6384: ( p_count => x_msg_count
6385: , p_data => x_msg_data
6386: );
6387: