DBA Data[Home] [Help]

APPS.PA_CUSTOMERS_CONTACTS_UTILS dependencies on PA_CUSTOMERS_CONTACTS_UTILS

Line 1: PACKAGE BODY PA_CUSTOMERS_CONTACTS_UTILS AS

1: PACKAGE BODY PA_CUSTOMERS_CONTACTS_UTILS AS
2: /* $Header: PARPCCUB.pls 120.5 2007/02/06 09:54:26 dthakker ship $ */
3:
4:
5: -- Global constant

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_CUSTOMERS_CONTACTS_UTILS';

2: /* $Header: PARPCCUB.pls 120.5 2007/02/06 09:54:26 dthakker ship $ */
3:
4:
5: -- Global constant
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_CUSTOMERS_CONTACTS_UTILS';
7:
8:
9: -- API name : Check_Customer_Name_Or_Id
10: -- Type : Utility

Line 113: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_UTILS', p_procedure_name => 'CHECK_CUSTOMER_NAME_OR_ID');

109: x_error_msg_code := 'PA_CUST_NAME_NOT_UNIQUE';
110: when OTHERS then
111: x_customer_id := NULL;
112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
113: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_UTILS', p_procedure_name => 'CHECK_CUSTOMER_NAME_OR_ID');
114: raise;
115: END CHECK_CUSTOMER_NAME_OR_ID;
116:
117:

Line 221: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_UTILS', p_procedure_name => 'CHECK_CUSTOMER_NUMBER_OR_ID');

217: x_error_msg_code := 'PA_CUST_NUM_NOT_UNIQUE';
218: when OTHERS then
219: x_customer_id := NULL;
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_UTILS', p_procedure_name => 'CHECK_CUSTOMER_NUMBER_OR_ID');
222: raise;
223:
224: END CHECK_CUSTOMER_NUMBER_OR_ID;
225:

Line 334: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_UTILS', p_procedure_name => 'CHECK_BILL_SITE_NAME_OR_ID');

330: x_error_msg_code := 'PA_BILL_TO_ADDR_NOT_UNIQUE';
331: when OTHERS then
332: x_bill_to_address_id := NULL;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_UTILS', p_procedure_name => 'CHECK_BILL_SITE_NAME_OR_ID');
335: raise;
336: END CHECK_BILL_SITE_NAME_OR_ID;
337:
338:

Line 582: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_UTILS', p_procedure_name => 'CHECK_CONTACT_NAME_OR_ID');

578: x_error_msg_code := 'PA_CONTACT_NAME_NOT_UNIQUE';
579: when OTHERS then
580: x_contact_id := NULL;
581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
582: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_UTILS', p_procedure_name => 'CHECK_CONTACT_NAME_OR_ID');
583: raise;
584: END CHECK_CONTACT_NAME_OR_ID;
585:
586:

Line 695: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_UTILS', p_procedure_name => 'CHECK_CONTACT_TYP_NAME_OR_CODE');

691: x_error_msg_code := 'PA_CONT_TYP_CODE_NOT_UNIQUE';
692: when OTHERS then
693: x_project_contact_type_code := NULL;
694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
695: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_UTILS', p_procedure_name => 'CHECK_CONTACT_TYP_NAME_OR_CODE');
696: raise;
697: END CHECK_CONTACT_TYP_NAME_OR_CODE;
698:
699:

Line 1406: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_UTILS', p_procedure_name => 'CHECK_CUSTOMER_NAME_AND_NUMBER');

1402: x_error_msg_code := 'PA_CUST_NAME_NOT_UNIQUE';
1403: when OTHERS then
1404: x_customer_id := NULL;
1405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1406: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_UTILS', p_procedure_name => 'CHECK_CUSTOMER_NAME_AND_NUMBER');
1407: raise;
1408: END CHECK_CUSTOMER_NAME_AND_NUMBER;
1409:
1410:

Line 1543: Pa_Debug.g_err_stage:= 'PA_CUSTOMERS_CONTACTS_UTILS : Get_Highest_Contr_Fed_Cust :

1539:
1540: IF ( p_project_id IS NULL OR p_project_id = FND_API.G_MISS_NUM)
1541: THEN
1542: IF l_debug_mode = 'Y' THEN
1543: Pa_Debug.g_err_stage:= 'PA_CUSTOMERS_CONTACTS_UTILS : Get_Highest_Contr_Fed_Cust :
1544: p_project_id is NULL';
1545: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
1546: l_debug_level3);
1547: END IF;

Line 1604: x_msg_data := ' PA_CUSTOMERS_CONTACTS_UTILS : Get_Highest_Contr_Fed_Cust : NULL parameters passed';

1600:
1601: WHEN Invalid_Arg_Exc THEN
1602: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1603: x_msg_count := 1;
1604: x_msg_data := ' PA_CUSTOMERS_CONTACTS_UTILS : Get_Highest_Contr_Fed_Cust : NULL parameters passed';
1605:
1606:
1607: x_highst_contr_cust_id := null;
1608:

Line 1615: ( p_pkg_name => 'PA_CUSTOMERS_CONTACTS_UTILS'

1611: ROLLBACK TO get_highest_cont_cust_svpt;
1612: END IF;
1613:
1614: Fnd_Msg_Pub.add_exc_msg
1615: ( p_pkg_name => 'PA_CUSTOMERS_CONTACTS_UTILS'
1616: , p_procedure_name => 'Get_Highest_Contr_Fed_Cust'
1617: , p_error_text => x_msg_data);
1618:
1619: IF l_debug_mode = 'Y' THEN

Line 1641: ( p_pkg_name => 'PA_CUSTOMERS_CONTACTS_UTILS'

1637: ROLLBACK TO get_highest_cont_cust_svpt;
1638: END IF;
1639:
1640: Fnd_Msg_Pub.add_exc_msg
1641: ( p_pkg_name => 'PA_CUSTOMERS_CONTACTS_UTILS'
1642: , p_procedure_name => 'Get_Highest_Contr_Fed_Cust'
1643: , p_error_text => x_msg_data);
1644:
1645: IF l_debug_mode = 'Y' THEN

Line 1659: END PA_CUSTOMERS_CONTACTS_UTILS;

1655: --sunkalya federal changes Bug#5511353
1656:
1657:
1658:
1659: END PA_CUSTOMERS_CONTACTS_UTILS;