DBA Data[Home] [Help]

APPS.PA_CUSTOMERS_CONTACTS_PUB dependencies on PA_CUSTOMERS_CONTACTS_PVT

Line 628: --dbms_output.put_line('Before calling PA_CUSTOMERS_CONTACTS_PVT.CREATE_PROJECT_CUSTOMER');

624: END IF;
625: IF l_ship_to_customer_id is null then
626: l_ship_to_customer_id := l_customer_id;
627: END IF;
628: --dbms_output.put_line('Before calling PA_CUSTOMERS_CONTACTS_PVT.CREATE_PROJECT_CUSTOMER');
629: --dbms_output.put_line('Before calling value of l_customer_id'||l_customer_id);
630:
631: PA_CUSTOMERS_CONTACTS_PVT.CREATE_PROJECT_CUSTOMER
632: ( p_commit => FND_API.G_FALSE

Line 631: PA_CUSTOMERS_CONTACTS_PVT.CREATE_PROJECT_CUSTOMER

627: END IF;
628: --dbms_output.put_line('Before calling PA_CUSTOMERS_CONTACTS_PVT.CREATE_PROJECT_CUSTOMER');
629: --dbms_output.put_line('Before calling value of l_customer_id'||l_customer_id);
630:
631: PA_CUSTOMERS_CONTACTS_PVT.CREATE_PROJECT_CUSTOMER
632: ( p_commit => FND_API.G_FALSE
633: ,p_validate_only => p_validate_only
634: ,p_validation_level => p_validation_level
635: ,p_calling_module => p_calling_module

Line 658: --dbms_output.put_line('Before calling PA_CUSTOMERS_CONTACTS_PVT.CREATE_PROJECT_CUSTOMER l_return_status'||l_return_status);

654: ,x_msg_data => l_msg_data
655: ,p_project_party_id => p_project_party_id
656: --Billing setup related changes for FP_M development. Tracking bug 3279981
657: ,p_Default_Top_Task_Cust_Flag => p_Default_Top_Task_Cust_Flag );
658: --dbms_output.put_line('Before calling PA_CUSTOMERS_CONTACTS_PVT.CREATE_PROJECT_CUSTOMER l_return_status'||l_return_status);
659:
660: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
661: x_msg_count := FND_MSG_PUB.count_msg;
662: if x_msg_count = 1 then

Line 1334: PA_CUSTOMERS_CONTACTS_PVT.UPDATE_PROJECT_CUSTOMER

1330: --dbms_output.put_line('Value of l_bill_to_address_id before pvt '||l_bill_to_address_id);
1331: --dbms_output.put_line('Value of l_ship_to_address_id before pvt '||l_ship_to_address_id);
1332: --dbms_output.put_line('Value of l_ship_to_customer_id before pvt '||l_ship_to_customer_id);
1333: --dbms_output.put_line('Value of p_bill_another_project_flag before pvt '||p_bill_another_project_flag);
1334: PA_CUSTOMERS_CONTACTS_PVT.UPDATE_PROJECT_CUSTOMER
1335: ( p_commit => FND_API.G_FALSE
1336: ,p_validate_only => p_validate_only
1337: ,p_validation_level => p_validation_level
1338: ,p_calling_module => p_calling_module

Line 1477: PA_CUSTOMERS_CONTACTS_PVT.DELETE_PROJECT_CUSTOMER

1473: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
1474: FND_MSG_PUB.initialize;
1475: end if;
1476:
1477: PA_CUSTOMERS_CONTACTS_PVT.DELETE_PROJECT_CUSTOMER
1478: ( p_commit => FND_API.G_FALSE
1479: ,p_validate_only => p_validate_only
1480: ,p_validation_level => p_validation_level
1481: ,p_calling_module => p_calling_module

Line 1836: PA_CUSTOMERS_CONTACTS_PVT.CREATE_CUSTOMER_CONTACT

1832: end if;
1833: raise FND_API.G_EXC_ERROR;
1834: end if;
1835:
1836: PA_CUSTOMERS_CONTACTS_PVT.CREATE_CUSTOMER_CONTACT
1837: ( p_commit => FND_API.G_FALSE
1838: ,p_validate_only => p_validate_only
1839: ,p_validation_level => p_validation_level
1840: ,p_calling_module => p_calling_module

Line 2201: PA_CUSTOMERS_CONTACTS_PVT.UPDATE_CUSTOMER_CONTACT

2197: end if;
2198: raise FND_API.G_EXC_ERROR;
2199: end if;
2200:
2201: PA_CUSTOMERS_CONTACTS_PVT.UPDATE_CUSTOMER_CONTACT
2202: ( p_commit => FND_API.G_FALSE
2203: ,p_validate_only => p_validate_only
2204: ,p_validation_level => p_validation_level
2205: ,p_calling_module => p_calling_module

Line 2337: PA_CUSTOMERS_CONTACTS_PVT.DELETE_CUSTOMER_CONTACT

2333: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
2334: FND_MSG_PUB.initialize;
2335: end if;
2336:
2337: PA_CUSTOMERS_CONTACTS_PVT.DELETE_CUSTOMER_CONTACT
2338: ( p_commit => FND_API.G_FALSE
2339: ,p_validate_only => p_validate_only
2340: ,p_validation_level => p_validation_level
2341: ,p_calling_module => p_calling_module

Line 2463: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Delete_All_BILL_SHIP_Contacts BEGIN');

2459:
2460: pa_debug.init_err_stack('PA_CUSTOMERS_CONTACTS_PUB.Delete_All_Bill_Ship_Contacts');
2461:
2462: if (p_debug_mode = 'Y') then
2463: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Delete_All_BILL_SHIP_Contacts BEGIN');
2464: end if;
2465:
2466: if p_commit = FND_API.G_TRUE then
2467: savepoint delete_all_bill_ship_contacts;

Line 2479: PA_CUSTOMERS_CONTACTS_PVT.DELETE_CUSTOMER_CONTACT

2475: FND_MSG_PUB.initialize;
2476: end if;
2477:
2478: for l_recinfo in C(p_project_id, p_customer_id, p_bill_ship_customer_id, p_project_contact_type_code) loop
2479: PA_CUSTOMERS_CONTACTS_PVT.DELETE_CUSTOMER_CONTACT
2480: ( p_commit => FND_API.G_FALSE
2481: ,p_validate_only => p_validate_only
2482: ,p_validation_level => p_validation_level
2483: ,p_calling_module => 'FORM'

Line 2511: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Delete_All_BILL_SHIP_Contacts END');

2507: commit work;
2508: end if;
2509:
2510: if (p_debug_mode = 'Y') then
2511: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Delete_All_BILL_SHIP_Contacts END');
2512: end if;
2513:
2514: EXCEPTION
2515: when FND_API.G_EXC_ERROR then

Line 2525: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PVT',

2521: if p_commit = FND_API.G_TRUE then
2522: rollback to delete_all_bill_ship_contacts;
2523: end if;
2524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2525: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PVT',
2526: p_procedure_name => 'Delete_All_Bill_Ship_Contacts',
2527: p_error_text => SUBSTRB(SQLERRM,1,240));
2528: raise;
2529: END DELETE_ALL_BILL_SHIP_CONTACTS;