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.CSP_SHIP_TO_ADDRESS_PVT dependencies on CSP_SHIP_TO_ADDRESS_PVT

Line 1: PACKAGE BODY CSP_SHIP_TO_ADDRESS_PVT AS

1: PACKAGE BODY CSP_SHIP_TO_ADDRESS_PVT AS
2: /*$Header: cspvstab.pls 120.6.12000000.2 2007/04/12 22:15:54 jjalla ship $*/
3: ------------------------------------------------------------------------------------------------------------------------
4: --
5: -- Procedure Name : Main procedure name is ship_to_address_handler. All calling programs should call it directly.

Line 86: csp_ship_to_address_pvt.g_rs_cust_relation_id := null;

82: from csp_rs_cust_relations
83: where resource_type = p_resource_type and resource_id = p_resource_id;
84:
85: BEGIN
86: csp_ship_to_address_pvt.g_rs_cust_relation_id := null;
87: OPEN l_rs_relation_csr;
88: FETCH l_rs_relation_csr INTO l_rs_cust_relation_id,
89: l_customer_id,
90: l_created_by,

Line 168: csp_ship_to_address_pvt.g_rs_cust_relation_id := l_rs_cust_relation_id;

164: p_ATTRIBUTE14 => NULL,
165: p_ATTRIBUTE15 => NULL);
166:
167: END IF;
168: csp_ship_to_address_pvt.g_rs_cust_relation_id := l_rs_cust_relation_id;
169:
170: END do_rs_cust_relations;
171:
172:

Line 2614: csp_ship_to_address_pvt.g_rs_cust_relation_id := null;

2610: END IF;
2611:
2612: x_return_status := FND_API.G_RET_STS_SUCCESS;
2613: select userenv('LANG') into s_language from dual;
2614: csp_ship_to_address_pvt.g_rs_cust_relation_id := null;
2615: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','SHIP_TO_ADDRESS_HANDLER','B',x_return_status);
2616:
2617: -- If task assignment id and addresses are both null, return error.
2618: IF (p_task_assignment_id IS NULL) and (p_country IS NULL) THEN

Line 2615: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','SHIP_TO_ADDRESS_HANDLER','B',x_return_status);

2611:
2612: x_return_status := FND_API.G_RET_STS_SUCCESS;
2613: select userenv('LANG') into s_language from dual;
2614: csp_ship_to_address_pvt.g_rs_cust_relation_id := null;
2615: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','SHIP_TO_ADDRESS_HANDLER','B',x_return_status);
2616:
2617: -- If task assignment id and addresses are both null, return error.
2618: IF (p_task_assignment_id IS NULL) and (p_country IS NULL) THEN
2619: FND_MESSAGE.SET_NAME ('CSP', 'CSP_TSK_ASSGN_ID_OR_ADDR_REQD');

Line 2810: csp_ship_to_address_pvt.g_rs_cust_relation_id := l_rs_cust_relation_id;

2806: -- Retrieve customer_id from CSP_RS_CUST_RELATIONS
2807: -- If found, no need to create new customer account for this resource
2808: OPEN l_customer_id_csr;
2809: FETCH l_customer_id_csr INTO l_rs_cust_relation_id,l_customer_id;
2810: csp_ship_to_address_pvt.g_rs_cust_relation_id := l_rs_cust_relation_id;
2811: IF l_customer_id_csr%FOUND and l_customer_id IS NOT NULL THEN
2812: CLOSE l_customer_id_csr;
2813:
2814: -- Use the customer_id to retrieve party_id from hz_cust_accounts

Line 3710: csp_ship_to_address_pvt.g_inv_loc_id := l_inv_location_id;

3706: p_customer_id := l_customer_id;
3707:
3708: -- -- Create or update resource/customer relationship record in csp_rs_cust_relations
3709: -- do_rs_cust_relations(l_resource_type, l_resource_id, l_resource_name, l_customer_id);
3710: csp_ship_to_address_pvt.g_inv_loc_id := l_inv_location_id;
3711: IF l_process_type = 'INSERT' THEN
3712: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','SHIP_TO_ADDRESS_HANDLER','A',x_return_status);
3713: ELSIF l_process_type = 'UPDATE' THEN
3714: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','UPDATE_LOCATION','A',x_return_status);

Line 3712: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','SHIP_TO_ADDRESS_HANDLER','A',x_return_status);

3708: -- -- Create or update resource/customer relationship record in csp_rs_cust_relations
3709: -- do_rs_cust_relations(l_resource_type, l_resource_id, l_resource_name, l_customer_id);
3710: csp_ship_to_address_pvt.g_inv_loc_id := l_inv_location_id;
3711: IF l_process_type = 'INSERT' THEN
3712: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','SHIP_TO_ADDRESS_HANDLER','A',x_return_status);
3713: ELSIF l_process_type = 'UPDATE' THEN
3714: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','UPDATE_LOCATION','A',x_return_status);
3715: END IF;
3716: -- If no error occurs, commit.

Line 3714: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','UPDATE_LOCATION','A',x_return_status);

3710: csp_ship_to_address_pvt.g_inv_loc_id := l_inv_location_id;
3711: IF l_process_type = 'INSERT' THEN
3712: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','SHIP_TO_ADDRESS_HANDLER','A',x_return_status);
3713: ELSIF l_process_type = 'UPDATE' THEN
3714: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','UPDATE_LOCATION','A',x_return_status);
3715: END IF;
3716: -- If no error occurs, commit.
3717: IF p_commit = FND_API.G_TRUE THEN
3718: COMMIT;

Line 4602: END CSP_SHIP_TO_ADDRESS_PVT;

4598: x_return_status := FND_API.G_RET_STS_ERROR;
4599:
4600: END;
4601:
4602: END CSP_SHIP_TO_ADDRESS_PVT;