DBA Data[Home] [Help]

APPS.CS_SR_EXTATTRIBUTES_PVT dependencies on CS_SERVICEREQUEST_UTIL

Line 615: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(

611:
612: --Check If pk_column_1 is passed
613: IF p_ext_attr_grp_tbl(i).pk_column_1 IS NULL THEN
614: --raise error
615: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(
616: p_token_an => l_api_name_full
617: ,p_token_mp => 'PK_COLUMN_1');
618: RAISE FND_API.G_EXC_ERROR;
619:

Line 628: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(

624: FETCH c_check_sr_pk_col_1 INTO l_pk_col_1, l_context;
625: CLOSE c_check_sr_pk_col_1;
626:
627: IF l_pk_col_1 IS NULL THEN
628: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
629: p_token_an => l_api_name_full
630: ,p_token_v => p_ext_attr_grp_tbl(i).pk_column_1
631: ,p_token_p => 'PK_COLUMN_1');
632: RAISE FND_API.G_EXC_ERROR;

Line 636: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(

632: RAISE FND_API.G_EXC_ERROR;
633: END IF;
634:
635: IF l_context IS NULL THEN
636: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
637: p_token_an => l_api_name_full
638: ,p_token_v => p_ext_attr_grp_tbl(i).context
639: ,p_token_p => 'CONTEXT');
640: RAISE FND_API.G_EXC_ERROR;

Line 676: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(

672:
673: --DBMS_OUTPUT.PUT_LINE('p_ext_attr_grp_tbl(i).context'||p_ext_attr_grp_tbl(i).context);
674: IF p_ext_attr_grp_tbl(i).context IS NULL THEN
675: --raise error
676: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(
677: p_token_an => l_api_name_full
678: ,p_token_mp => 'CONTEXT');
679: RAISE FND_API.G_EXC_ERROR;
680:

Line 689: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(

685: --DBMS_OUTPUT.PUT_LINE('l_context'||l_context);
686: IF p_ext_attr_grp_tbl(i).context <> l_context AND
687: p_ext_attr_grp_tbl(i).context <> '-1' THEN
688: --raise error
689: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
690: p_token_an => l_api_name_full
691: ,p_token_v => p_ext_attr_grp_tbl(i).context
692: ,p_token_p => 'CONTEXT');
693: RAISE FND_API.G_EXC_ERROR;

Line 785: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(

781: END IF;
782: ELSE
783: --Attr Group Information is null
784: -- Raise Error
785: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(
786: p_token_an => l_api_name_full
787: ,p_token_mp => 'ATTR_GROUP_ID');
788: RAISE FND_API.G_EXC_ERROR;
789:

Line 1033: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(

1029:
1030: ELSE
1031: --Attr Group Information is null
1032: -- Raise Error
1033: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(
1034: p_token_an => l_api_name_full
1035: ,p_token_mp => 'ATTR_GROUP_ID');
1036: RAISE FND_API.G_EXC_ERROR;
1037:

Line 1044: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(

1040: ELSIF p_ext_attr_grp_tbl(i).operation = 'DELETE' THEN
1041:
1042: -- 5230517
1043: IF p_ext_attr_grp_tbl(i).attr_group_id IS NULL THEN
1044: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(
1045: p_token_an => l_api_name_full
1046: ,p_token_mp => 'ATTR_GROUP_ID');
1047: RAISE FND_API.G_EXC_ERROR;
1048:

Line 1468: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(

1464: p_ext_attr_grp_tbl(i).pk_column_2 IS NULL OR
1465: p_ext_attr_grp_tbl(i).pk_column_3 IS NULL OR
1466: p_ext_attr_grp_tbl(i).pk_column_4 IS NULL THEN
1467: --raise error
1468: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(
1469: p_token_an => l_api_name_full
1470: ,p_token_mp => 'PARTY_ROLE_COMPOSITE_KEY');
1471: RAISE FND_API.G_EXC_ERROR;
1472: ELSE

Line 1493: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(

1489: --raise error
1490: l_composite_key := p_ext_attr_grp_tbl(i).pk_column_1||' , '||p_ext_attr_grp_tbl(i).pk_column_2||
1491: ' , '||p_ext_attr_grp_tbl(i).pk_column_3||' , '||p_ext_attr_grp_tbl(i).pk_column_4;
1492:
1493: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
1494: p_token_an => l_api_name_full
1495: ,p_token_v => l_composite_key
1496: ,p_token_p => 'COMPOSITE_KEY');
1497: RAISE FND_API.G_EXC_ERROR;

Line 1529: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(

1525: --DBMS_OUTPUT.PUT_LINE('validating context');
1526: --Check if context is passed
1527: IF p_ext_attr_grp_tbl(i).context IS NULL THEN
1528: --raise error
1529: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(
1530: p_token_an => l_api_name_full
1531: ,p_token_mp => 'PARTY CONTEXT');
1532: RAISE FND_API.G_EXC_ERROR;
1533: ELSE

Line 1539: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(

1535: --context is passed
1536: --Check the context for the validated incident.
1537: IF p_ext_attr_grp_tbl(i).context <> p_ext_attr_grp_tbl(i).pk_column_4 THEN
1538: --raise error
1539: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
1540: p_token_an => l_api_name_full
1541: ,p_token_v => p_ext_attr_grp_tbl(i).context
1542: ,p_token_p => 'PARTY CONTEXT');
1543: RAISE FND_API.G_EXC_ERROR;

Line 1618: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(

1614: END IF;
1615: ELSE
1616: -- Raise Error
1617: --Attr Group Information is null
1618: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(
1619: p_token_an => l_api_name_full
1620: ,p_token_mp => 'ATTR_GROUP_ID');
1621: RAISE FND_API.G_EXC_ERROR;
1622: END IF;

Line 1738: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(

1734: ELSE
1735: -- Raise Error
1736: -- MAYA NEED TO ADD
1737: --Attr Group Information is null
1738: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(
1739: p_token_an => l_api_name_full
1740: ,p_token_mp => 'ATTR_GROUP_ID');
1741: RAISE FND_API.G_EXC_ERROR;
1742: END IF;

Line 1754: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(

1750: ELSIF p_ext_attr_grp_tbl(i).operation = 'DELETE' THEN
1751:
1752: -- 5230517
1753: IF p_ext_attr_grp_tbl(i).attr_group_id IS NULL THEN
1754: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(
1755: p_token_an => l_api_name_full
1756: ,p_token_mp => 'ATTR_GROUP_ID');
1757: RAISE FND_API.G_EXC_ERROR;
1758:

Line 1940: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(

1936: END IF; -- l_count_if_eof
1937:
1938: --5230846
1939: ELSE -- if not CS_SERVICE_REQUEST and CS_PARTY_ROLE
1940: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
1941: p_token_an => l_api_name_full
1942: ,p_token_v => p_ext_attr_grp_tbl(i).object_name
1943: ,p_token_p => 'OBJECT_NAME');
1944: RAISE FND_API.G_EXC_ERROR;

Line 4089: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(

4085: CLOSE c_check_incident_id;
4086:
4087: IF l_incident_id IS NULL THEN
4088: --raise error
4089: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
4090: p_token_an => l_api_name_full
4091: ,p_token_v => p_incident_id
4092: ,p_token_p => 'P_INCIDENT_ID');
4093: RAISE FND_API.G_EXC_ERROR;

Line 4100: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(

4096: --DBMS_OUTPUT.PUT_LINE ('Pass pk1 validation');
4097:
4098: ELSE
4099: --raise error
4100: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(
4101: p_token_an => l_api_name_full
4102: ,p_token_mp => 'P_INCIDENT_ID');
4103: RAISE FND_API.G_EXC_ERROR;
4104:

Line 7086: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg

7082: END LOOP;
7083:
7084: EXCEPTION
7085: WHEN no_data_found THEN
7086: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
7087: (p_token_an => 'Populate_Ext_Attr_Audit_Tbl',
7088: p_token_v => TO_CHAR(P_EXTENSION_ID),
7089: p_token_p => 'P_EXTENSION_ID' ,
7090: p_table_name => 'CS_SR_CONTACTX_EXT',