DBA Data[Home] [Help]

APPS.PA_CUSTOMER_INFO dependencies on PA_INTERFACE_UTILS_PUB

Line 202: elsif (X_Customer_id IS NOT NULL) OR (X_Customer_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

198: If l_ic_billing='Y' Then
199: X_Bill_To_Customer_id := X_Customer_id;
200: X_Ship_To_Customer_id := X_Customer_id;
201: /*Changes for 6630834*/
202: elsif (X_Customer_id IS NOT NULL) OR (X_Customer_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
203: X_Bill_To_Customer_id := X_Customer_id;
204: X_Ship_To_Customer_id := X_Customer_id;
205: /*Changes for 6630834 end here*/
206: End if;

Line 267: OR Pl_Ship_To_Address_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

263: if l_site_use_code = 'SHIP_TO' then
264: /* Code changes begin for BUg 3911782 */
265:
266: If Pl_Ship_To_Address_Id IS NULL
267: OR Pl_Ship_To_Address_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
268: Pl_Ship_To_Address_Id := l_address_id;
269: else
270: l_return_value := Is_Address_Valid(l_site_use_code => l_site_use_code ,
271: l_Customer_Id => X_Ship_To_Customer_Id,

Line 284: OR Pl_Ship_To_Contact_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

280: /* Code changes end for BUg 3911782 */
281: -- Pl_Ship_To_Contact_Id := l_contact_id; --commented for tracking bug
282: /* Changes begin for tracking bug by aditi */
283: If Pl_Ship_To_Contact_Id IS NULL
284: OR Pl_Ship_To_Contact_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
285: Pl_Ship_To_Contact_Id := l_contact_id;
286: Else
287: l_return_value := Is_Contact_Valid(l_site_use_code => l_site_use_code ,
288: l_Customer_Id => X_Ship_To_Customer_Id,

Line 308: OR Pl_Bill_To_Address_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

304: elsif l_site_use_code = 'BILL_TO' then
305: /* Code changes begin for BUg 3911782 */
306:
307: If Pl_Bill_To_Address_Id IS NULL
308: OR Pl_Bill_To_Address_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
309: Pl_Bill_To_Address_Id := l_address_id;
310: else
311: --dbms_output.put_line('Value of l_site_use_code' ||l_site_use_code);
312: --dbms_output.put_line('Value of X_Bill_To_Customer_Id' ||X_Bill_To_Customer_Id);

Line 331: OR Pl_Bill_To_Contact_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

327: /* Code changes end for BUg 3911782 */
328: -- Pl_Bill_To_Contact_Id := l_contact_id; --Commented for tracking bug
329: /* Changes begin for tracking bug by aditi */
330: If Pl_Bill_To_Contact_Id IS NULL
331: OR Pl_Bill_To_Contact_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
332: Pl_Bill_To_Contact_Id := l_contact_id;
333: Else
334: l_return_value := Is_Contact_Valid(l_site_use_code => l_site_use_code ,
335: l_Customer_Id => X_Bill_To_Customer_Id,

Line 399: IF X_Bill_To_Customer_Id IS NOT NULL OR X_Bill_To_Customer_Id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN --Changed if Condition for Bug 6630834

395:
396:
397: IF l_cust_acc_rel_code = 'Y' or l_cust_acc_rel_code = 'A' Then
398:
399: IF X_Bill_To_Customer_Id IS NOT NULL OR X_Bill_To_Customer_Id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN --Changed if Condition for Bug 6630834
400:
401: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NAME_OR_ID
402: ( p_customer_id => X_Bill_To_Customer_Id
403: ,p_check_id_flag => 'Y'

Line 425: IF X_Ship_To_Customer_Id IS NOT NULL OR X_Ship_To_Customer_Id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN --Changed if Condition for Bug 6630834

421: End if;
422:
423: End if;
424:
425: IF X_Ship_To_Customer_Id IS NOT NULL OR X_Ship_To_Customer_Id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN --Changed if Condition for Bug 6630834
426:
427: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NAME_OR_ID
428: ( p_customer_id => X_Ship_To_Customer_Id
429: ,p_check_id_flag => 'Y'

Line 536: OR Pl_Bill_To_Address_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

532:
533: if l_site_use_code = 'BILL_TO' then
534: /* Code changes begin for BUg 3911782 */
535: If Pl_Bill_To_Address_Id IS NULL
536: OR Pl_Bill_To_Address_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
537: Pl_Bill_To_Address_Id := l_address_id;
538: else
539:
540: l_return_value := Is_Address_Valid(l_site_use_code => l_site_use_code ,

Line 555: OR Pl_Bill_To_Contact_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

551: /* Code changes end for BUg 3911782 */
552: -- Pl_Bill_To_Contact_Id := l_contact_id;--Commented for tracking bug
553: /* Changes begin for tracking bug by aditi */
554: If Pl_Bill_To_Contact_Id IS NULL
555: OR Pl_Bill_To_Contact_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
556: Pl_Bill_To_Contact_Id := l_contact_id;
557: Else
558: l_return_value := Is_Contact_Valid(l_site_use_code => l_site_use_code ,
559: l_Customer_Id => X_Bill_To_Customer_Id,

Line 596: OR Pl_Ship_To_Address_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

592:
593: if l_site_use_code = 'SHIP_TO' then
594: /* Code changes begin for BUg 3911782 */
595: If Pl_Ship_To_Address_Id IS NULL
596: OR Pl_Ship_To_Address_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
597: Pl_Ship_To_Address_Id := l_address_id;
598: else
599: l_return_value := Is_Address_Valid(l_site_use_code => l_site_use_code ,
600: l_Customer_Id => X_Ship_To_Customer_Id,

Line 612: OR Pl_Ship_To_Contact_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

608: /* Code changes end for BUg 3911782 */
609: -- Pl_Ship_To_Contact_Id := l_contact_id; --Commented for tracking bug
610: /* Changes begin for tracking bug by aditi */
611: If Pl_Ship_To_Contact_Id IS NULL
612: OR Pl_Ship_To_Contact_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
613: Pl_Ship_To_Contact_Id := l_contact_id;
614: Else
615: l_return_value := Is_Contact_Valid(l_site_use_code => l_site_use_code ,
616: l_Customer_Id => X_Ship_To_Customer_Id,