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

4228:
4229: ELSE
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

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

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

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

4254:
4255: ELSE
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

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

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

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

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

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

4560: ELSE
4561: -- Raise error
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

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

4561: -- Raise error
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:

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

4584: l_attr_group_type,l_attr_group_name,'PARTY_ROLE_LEVEL', NULL, NULL,NULL,NULL,NULL, l_internal_name_str);
4585: ELSE
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:

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

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

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

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

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

4800: );
4801:
4802: WHEN OTHERS THEN
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:

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

4801:
4802: WHEN OTHERS THEN
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;

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

4802: WHEN OTHERS THEN
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:

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

5753: EXCEPTION
5754: WHEN OTHERS THEN
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:

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

5754: WHEN OTHERS THEN
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;

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

6376:
6377: EXCEPTION
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

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

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