DBA Data[Home] [Help]

APPS.CS_SR_EXTATTRIBUTES_PVT dependencies on FND_MESSAGE

Line 470: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');

466: , x_msg_count => x_msg_count
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:

Line 523: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');

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

Line 551: FND_MESSAGE.Set_Name('CS', 'CS_API_POP_SR_EXT_ATTR_WARN');

547: ,x_rec_found => l_rec_found);
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;

Line 578: FND_MESSAGE.Set_Name('CS', 'CS_API_POP_SR_EXT_ATTR_WARN');

574: ,x_msg_data => x_msg_data);
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:

Line 1177: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');

1173: , x_msg_count => x_msg_count
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'

Line 1217: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');

1213: --DBMS_OUTPUT.PUT_LINE('x_failed_row_id_list'||x_failed_row_id_list);
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:

Line 1254: FND_MESSAGE.Set_Name('CS', 'CS_API_POP_SR_EXT_ATTR_WARN');

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

Line 1349: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');

1345: ,x_msg_data => x_msg_data );
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:

Line 1398: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');

1394: ,x_msg_count => x_msg_count
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:

Line 1425: FND_MESSAGE.Set_Name('CS', 'CS_API_POP_PR_EXT_ATTR_WARN');

1421: ,x_rec_found => l_rec_found);
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;

Line 1669: FND_MESSAGE.Set_Name('CS', 'CS_API_POP_PR_EXT_ATTR_WARN');

1665: IF l_rec_found = 'N' THEN
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

Line 1720: FND_MESSAGE.Set_Name('CS', 'CS_API_POP_PR_EXT_ATTR_WARN');

1716: IF l_rec_found = 'N' THEN
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

Line 1890: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');

1886: ,x_msg_count => x_msg_count
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:

Line 1914: FND_MESSAGE.Set_Name('CS', 'CS_API_POP_PR_EXT_ATTR_WARN');

1910: ,x_rec_found => l_rec_found);
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;

Line 2012: --FND_MESSAGE.SET_NAME(G_APP_NAME);

2008: EXCEPTION
2009:
2010: WHEN OTHERS THEN
2011: null;
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;

Line 2013: --FND_MESSAGE.SET_TOKEN(token => G_PROC_NAME_TOKEN, value => l_prog_name);

2009:
2010: WHEN OTHERS THEN
2011: null;
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:

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

2010: WHEN OTHERS THEN
2011: null;
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;

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

2011: null;
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:

Line 4234: FND_MESSAGE.SET_NAME('CS', 'CS_API_SR_EXTATTR_COMP_KEY_REQ');

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

Line 4235: FND_MESSAGE.SET_TOKEN('API_NAME', l_api_name);

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

Line 4260: FND_MESSAGE.SET_NAME('CS', 'CS_API_SR_EXT_ATTR_GROUP_REQ');

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

Line 4261: FND_MESSAGE.SET_TOKEN('API_NAME', l_api_name);

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

Line 4341: FND_MESSAGE.Set_Name('CS', 'CS_API_GET_SR_EXT_ATTR_WARNING');

4337: END IF;
4338:
4339:
4340: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4341: FND_MESSAGE.Set_Name('CS', 'CS_API_GET_SR_EXT_ATTR_WARNING');
4342: FND_MSG_PUB.Add;
4343: RAISE FND_API.G_EXC_ERROR;
4344: END IF;
4345:

Line 4566: FND_MESSAGE.SET_NAME('CS', 'CS_API_SR_EXTATTR_COMP_KEY_REQ');

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

Line 4567: FND_MESSAGE.SET_TOKEN('API_NAME', l_api_name);

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

Line 4590: FND_MESSAGE.SET_NAME('CS', 'CS_API_SR_EXT_ATTR_GROUP_REQ');

4586: l_attr_group_type,l_attr_group_name,'PARTY_ROLE_LEVEL', NULL, NULL,NULL,NULL,NULL, l_internal_name_str);
4587: ELSE
4588: --attribute group is null
4589: --raise error
4590: FND_MESSAGE.SET_NAME('CS', 'CS_API_SR_EXT_ATTR_GROUP_REQ');
4591: FND_MESSAGE.SET_TOKEN('API_NAME', l_api_name);
4592: FND_MSG_PUB.ADD;
4593: RAISE FND_API.G_EXC_ERROR;
4594:

Line 4591: FND_MESSAGE.SET_TOKEN('API_NAME', l_api_name);

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

Line 4661: FND_MESSAGE.Set_Name('CS', 'CS_API_GET_SR_EXT_ATTR_WARNING');

4657: );
4658: END IF;
4659:
4660: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4661: FND_MESSAGE.Set_Name('CS', 'CS_API_GET_SR_EXT_ATTR_WARNING');
4662: FND_MSG_PUB.Add;
4663: RAISE FND_API.G_EXC_ERROR;
4664: END IF;
4665:

Line 4806: FND_MESSAGE.Set_Name('CS', 'CS_GET_SR_EXT_ATTR_FAIL');

4802: );
4803:
4804: WHEN OTHERS THEN
4805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4806: FND_MESSAGE.Set_Name('CS', 'CS_GET_SR_EXT_ATTR_FAIL');
4807: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4808: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
4809: FND_MSG_PUB.ADD;
4810:

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

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

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

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

Line 5771: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');

5767: EXCEPTION
5768: WHEN OTHERS THEN
5769: --DBMS_OUTPUT.PUT_LINE('when other ..');
5770: --DBMS_OUTPUT.PUT_LINE(substr(SQLERRM,1,200));
5771: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5772: FND_MESSAGE.set_token('P_TEXT','cs_sr_ext_attr_data_pvt.insert_sr_row'||'-'||substr(SQLERRM,1,200));
5773: FND_MSG_PUB.ADD;
5774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5775:

Line 5772: FND_MESSAGE.set_token('P_TEXT','cs_sr_ext_attr_data_pvt.insert_sr_row'||'-'||substr(SQLERRM,1,200));

5768: WHEN OTHERS THEN
5769: --DBMS_OUTPUT.PUT_LINE('when other ..');
5770: --DBMS_OUTPUT.PUT_LINE(substr(SQLERRM,1,200));
5771: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5772: FND_MESSAGE.set_token('P_TEXT','cs_sr_ext_attr_data_pvt.insert_sr_row'||'-'||substr(SQLERRM,1,200));
5773: FND_MSG_PUB.ADD;
5774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5775:
5776: END insert_sr_row;

Line 6407: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');

6403:
6404: EXCEPTION
6405: WHEN OTHERS THEN
6406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6407: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6408: FND_MESSAGE.set_token('P_TEXT','cs_sr_ext_attr_data_pvt.insert_sr_row'||'-'||substr(SQLERRM,1,200));
6409: FND_MSG_PUB.ADD;
6410: FND_MSG_PUB.Count_And_Get
6411: ( p_count => x_msg_count

Line 6408: FND_MESSAGE.set_token('P_TEXT','cs_sr_ext_attr_data_pvt.insert_sr_row'||'-'||substr(SQLERRM,1,200));

6404: EXCEPTION
6405: WHEN OTHERS THEN
6406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6407: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6408: FND_MESSAGE.set_token('P_TEXT','cs_sr_ext_attr_data_pvt.insert_sr_row'||'-'||substr(SQLERRM,1,200));
6409: FND_MSG_PUB.ADD;
6410: FND_MSG_PUB.Count_And_Get
6411: ( p_count => x_msg_count
6412: , p_data => x_msg_data