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.PA_CUSTOMER_INFO dependencies on PA_INTERFACE_UTILS_PUB

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

199: X_Bill_To_Customer_id := X_Customer_id;
200: X_Ship_To_Customer_id := X_Customer_id;
201: /*Changes for 6630834*/
202: /*Changed as a part of 12907893 :START*/
203: /* elsif (X_Customer_id IS NOT NULL) OR (X_Customer_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN */
204: elsif (X_Customer_id IS NOT NULL) AND (X_Customer_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
205: /*Changed as a part of 12907893 :END*/
206: /* Changes for bug 8247716 start here */
207: if(NVL(X_Bill_To_Customer_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) Then

Line 204: elsif (X_Customer_id IS NOT NULL) AND (X_Customer_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

200: X_Ship_To_Customer_id := X_Customer_id;
201: /*Changes for 6630834*/
202: /*Changed as a part of 12907893 :START*/
203: /* elsif (X_Customer_id IS NOT NULL) OR (X_Customer_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN */
204: elsif (X_Customer_id IS NOT NULL) AND (X_Customer_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
205: /*Changed as a part of 12907893 :END*/
206: /* Changes for bug 8247716 start here */
207: if(NVL(X_Bill_To_Customer_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) Then
208: X_Bill_To_Customer_id := X_Customer_id;

Line 207: if(NVL(X_Bill_To_Customer_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) Then

203: /* elsif (X_Customer_id IS NOT NULL) OR (X_Customer_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN */
204: elsif (X_Customer_id IS NOT NULL) AND (X_Customer_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
205: /*Changed as a part of 12907893 :END*/
206: /* Changes for bug 8247716 start here */
207: if(NVL(X_Bill_To_Customer_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) Then
208: X_Bill_To_Customer_id := X_Customer_id;
209: end if;
210: if(NVL(X_Ship_To_Customer_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) Then
211: X_Ship_To_Customer_id := X_Customer_id;

Line 210: if(NVL(X_Ship_To_Customer_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) Then

206: /* Changes for bug 8247716 start here */
207: if(NVL(X_Bill_To_Customer_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) Then
208: X_Bill_To_Customer_id := X_Customer_id;
209: end if;
210: if(NVL(X_Ship_To_Customer_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) Then
211: X_Ship_To_Customer_id := X_Customer_id;
212: end if;
213: /* Changes for bug 8247716 end here */
214: /*Changes for 6630834 end here*/

Line 276: OR Pl_Ship_To_Address_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

272: if l_site_use_code = 'SHIP_TO' then
273: /* Code changes begin for BUg 3911782 */
274:
275: If Pl_Ship_To_Address_Id IS NULL
276: OR Pl_Ship_To_Address_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
277: Pl_Ship_To_Address_Id := l_address_id;
278: else
279: l_return_value := Is_Address_Valid(l_site_use_code => l_site_use_code ,
280: l_Customer_Id => X_Ship_To_Customer_Id,

Line 293: OR Pl_Ship_To_Contact_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

289: /* Code changes end for BUg 3911782 */
290: -- Pl_Ship_To_Contact_Id := l_contact_id; --commented for tracking bug
291: /* Changes begin for tracking bug by aditi */
292: If Pl_Ship_To_Contact_Id IS NULL
293: OR Pl_Ship_To_Contact_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
294: Pl_Ship_To_Contact_Id := l_contact_id;
295: Else
296: l_return_value := Is_Contact_Valid(l_site_use_code => l_site_use_code ,
297: l_Customer_Id => X_Ship_To_Customer_Id,

Line 317: OR Pl_Bill_To_Address_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

313: elsif l_site_use_code = 'BILL_TO' then
314: /* Code changes begin for BUg 3911782 */
315:
316: If Pl_Bill_To_Address_Id IS NULL
317: OR Pl_Bill_To_Address_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
318: Pl_Bill_To_Address_Id := l_address_id;
319: else
320: --dbms_output.put_line('Value of l_site_use_code' ||l_site_use_code);
321: --dbms_output.put_line('Value of X_Bill_To_Customer_Id' ||X_Bill_To_Customer_Id);

Line 340: OR Pl_Bill_To_Contact_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

336: /* Code changes end for BUg 3911782 */
337: -- Pl_Bill_To_Contact_Id := l_contact_id; --Commented for tracking bug
338: /* Changes begin for tracking bug by aditi */
339: If Pl_Bill_To_Contact_Id IS NULL
340: OR Pl_Bill_To_Contact_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
341: Pl_Bill_To_Contact_Id := l_contact_id;
342: Else
343: l_return_value := Is_Contact_Valid(l_site_use_code => l_site_use_code ,
344: l_Customer_Id => X_Bill_To_Customer_Id,

Line 408: 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

404:
405:
406: IF l_cust_acc_rel_code = 'Y' or l_cust_acc_rel_code = 'A' Then
407:
408: 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
409:
410: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NAME_OR_ID
411: ( p_customer_id => X_Bill_To_Customer_Id
412: ,p_check_id_flag => 'Y'

Line 434: 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

430: End if;
431:
432: End if;
433:
434: 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
435:
436: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NAME_OR_ID
437: ( p_customer_id => X_Ship_To_Customer_Id
438: ,p_check_id_flag => 'Y'

Line 545: OR Pl_Bill_To_Address_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

541:
542: if l_site_use_code = 'BILL_TO' then
543: /* Code changes begin for BUg 3911782 */
544: If Pl_Bill_To_Address_Id IS NULL
545: OR Pl_Bill_To_Address_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
546: Pl_Bill_To_Address_Id := l_address_id;
547: else
548:
549: l_return_value := Is_Address_Valid(l_site_use_code => l_site_use_code ,

Line 564: OR Pl_Bill_To_Contact_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

560: /* Code changes end for BUg 3911782 */
561: -- Pl_Bill_To_Contact_Id := l_contact_id;--Commented for tracking bug
562: /* Changes begin for tracking bug by aditi */
563: If Pl_Bill_To_Contact_Id IS NULL
564: OR Pl_Bill_To_Contact_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
565: Pl_Bill_To_Contact_Id := l_contact_id;
566: Else
567: l_return_value := Is_Contact_Valid(l_site_use_code => l_site_use_code ,
568: l_Customer_Id => X_Bill_To_Customer_Id,

Line 605: OR Pl_Ship_To_Address_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

601:
602: if l_site_use_code = 'SHIP_TO' then
603: /* Code changes begin for BUg 3911782 */
604: If Pl_Ship_To_Address_Id IS NULL
605: OR Pl_Ship_To_Address_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
606: Pl_Ship_To_Address_Id := l_address_id;
607: else
608: l_return_value := Is_Address_Valid(l_site_use_code => l_site_use_code ,
609: l_Customer_Id => X_Ship_To_Customer_Id,

Line 621: OR Pl_Ship_To_Contact_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then

617: /* Code changes end for BUg 3911782 */
618: -- Pl_Ship_To_Contact_Id := l_contact_id; --Commented for tracking bug
619: /* Changes begin for tracking bug by aditi */
620: If Pl_Ship_To_Contact_Id IS NULL
621: OR Pl_Ship_To_Contact_Id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
622: Pl_Ship_To_Contact_Id := l_contact_id;
623: Else
624: l_return_value := Is_Contact_Valid(l_site_use_code => l_site_use_code ,
625: l_Customer_Id => X_Ship_To_Customer_Id,