[Home] [Help]
268:
269: -- Amit 2965841 : We shd first check for Number as it is unique. And if it is able to find the id then we shd skip the check for name
270: if ((p_customer_number <> FND_API.G_MISS_CHAR) AND (p_customer_number is not NULL)) OR
271: ((p_customer_id <> FND_API.G_MISS_NUM) AND (p_customer_id is not NULL)) then
272: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NUMBER_OR_ID
273: ( p_customer_id => p_customer_id
274: ,p_customer_number => p_customer_number
275: ,p_check_id_flag => l_check_id_flag
276: ,x_customer_id => l_customer_id
286:
287: if l_customer_id is null then -- Amit 2965841 :
288: if ((p_customer_name <> FND_API.G_MISS_CHAR) AND (p_customer_name is not NULL)) OR
289: ((p_customer_id <> FND_API.G_MISS_NUM) AND (p_customer_id is not NULL)) then
290: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NAME_OR_ID
291: ( p_customer_id => p_customer_id
292: ,p_customer_name => p_customer_name
293: ,x_customer_id => l_customer_id
294: ,x_return_status => l_return_status
302: --dbms_output.put_line('44444444444 Value of p_customer_id'||p_customer_id);
303: --dbms_output.put_line('44444444444444 Value of l_customer_id'||l_customer_id);
304: if ((p_customer_name <> FND_API.G_MISS_CHAR) AND (p_customer_name is not NULL)) AND
305: ((p_customer_number <> FND_API.G_MISS_CHAR) AND (p_customer_number is not NULL)) THEN
306: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NAME_AND_NUMBER
307: ( p_customer_name => p_customer_name
308: ,p_customer_number => p_customer_number
309: ,x_customer_id => l_customer_id
310: ,x_return_status => l_return_status
319: /* START For Bug 2731449 */
320: -- check whether bill to and ship to customer passes are valid or not
321: /* Amit : Not sufficient to check for id only. New code is added below
322: if(p_bill_to_customer_id <> NULL) THEN
323: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NAME_OR_ID
324: ( p_customer_id => p_bill_to_customer_id
325: ,p_check_id_flag => 'Y'
326: ,x_customer_id => l_bill_to_customer_id
327: ,x_return_status => l_return_status
332: end if;
333: end if;
334:
335: if(p_ship_to_customer_id <> NULL) THEN
336: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NAME_OR_ID
337: ( p_customer_id => p_ship_to_customer_id
338: ,p_check_id_flag => 'Y'
339: ,x_customer_id => l_ship_to_customer_id
340: ,x_return_status => l_return_status
352: -- or (p_bill_to_customer_name is not null and p_bill_to_customer_name <> FND_API.G_MISS_CHAR))
353: -- then
354: if ((p_bill_to_customer_number <> FND_API.G_MISS_CHAR) AND (p_bill_to_customer_number is not NULL)) OR
355: ((p_bill_to_customer_id <> FND_API.G_MISS_NUM) AND (p_bill_to_customer_id is not NULL)) then
356: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NUMBER_OR_ID
357: ( p_customer_id => p_bill_to_customer_id
358: ,p_customer_number => p_bill_to_customer_number
359: ,x_customer_id => l_bill_to_customer_id
360: ,x_return_status => l_return_status
367:
368: if l_bill_to_customer_id is null then -- Amit 2965841:
369: if ((p_bill_to_customer_name <> FND_API.G_MISS_CHAR) AND (p_bill_to_customer_name is not NULL)) OR
370: ((p_bill_to_customer_id <> FND_API.G_MISS_NUM) AND (p_bill_to_customer_id is not NULL)) then
371: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NAME_OR_ID
372: ( p_customer_id => p_bill_to_customer_id
373: ,p_customer_name => p_bill_to_customer_name
374: ,x_customer_id => l_bill_to_customer_id
375: ,x_return_status => l_return_status
382: end if; -- : Amit 2965841
383:
384: if ((p_bill_to_customer_name <> FND_API.G_MISS_CHAR) AND (p_bill_to_customer_name is not NULL)) AND
385: ((p_bill_to_customer_number <> FND_API.G_MISS_CHAR) AND (p_bill_to_customer_number is not NULL)) THEN
386: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NAME_AND_NUMBER
387: ( p_customer_name => p_bill_to_customer_name
388: ,p_customer_number => p_bill_to_customer_number
389: ,x_customer_id => l_bill_to_customer_id
390: ,x_return_status => l_return_status
408: -- Check for Ship Customer
409: -- Amit : We shd first check for Number as it is unique. And if it is able to find the id then we shd skip the check for name
410: if ((p_ship_to_customer_number <> FND_API.G_MISS_CHAR) AND (p_ship_to_customer_number is not NULL)) OR
411: ((p_ship_to_customer_id <> FND_API.G_MISS_NUM) AND (p_ship_to_customer_id is not NULL)) then
412: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NUMBER_OR_ID
413: ( p_customer_id => p_ship_to_customer_id
414: ,p_customer_number => p_ship_to_customer_number
415: ,x_customer_id => l_ship_to_customer_id
416: ,x_return_status => l_return_status
423:
424: if l_ship_to_customer_id is null then -- Amit 2965841:
425: if ((p_ship_to_customer_name <> FND_API.G_MISS_CHAR) AND (p_ship_to_customer_name is not NULL)) OR
426: ((p_ship_to_customer_id <> FND_API.G_MISS_NUM) AND (p_ship_to_customer_id is not NULL)) then
427: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NAME_OR_ID
428: ( p_customer_id => p_ship_to_customer_id
429: ,p_customer_name => p_ship_to_customer_name
430: ,x_customer_id => l_ship_to_customer_id
431: ,x_return_status => l_return_status
439:
440:
441: if ((p_ship_to_customer_name <> FND_API.G_MISS_CHAR) AND (p_ship_to_customer_name is not NULL)) AND
442: ((p_ship_to_customer_number <> FND_API.G_MISS_CHAR) AND (p_ship_to_customer_number is not NULL)) THEN
443: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NAME_AND_NUMBER
444: ( p_customer_name => p_ship_to_customer_name
445: ,p_customer_number => p_ship_to_customer_number
446: ,x_customer_id => l_ship_to_customer_id
447: ,x_return_status => l_return_status
492:
493: if ((p_bill_site_name <> FND_API.G_MISS_CHAR) AND (p_bill_site_name is not NULL)) AND
494: ((p_bill_to_address_id = FND_API.G_MISS_NUM) OR (p_bill_to_address_id is NULL)) then
495:
496: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_BILL_SITE_NAME_OR_ID
497: ( p_customer_id => l_bill_to_customer_id /* For Bug 2731449 */
498: ,p_bill_to_address_id => p_bill_to_address_id
499: ,p_bill_site_name => p_bill_site_name
500: ,x_bill_to_address_id => l_bill_to_address_id
507: end if;
508:
509: if ((p_bill_to_address_id <> FND_API.G_MISS_NUM) AND (p_bill_to_address_id is not NULL)) then
510:
511: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_BILL_SITE_NAME_OR_ID
512: ( p_customer_id => l_bill_to_customer_id /* For Bug 2731449 */
513: ,p_bill_to_address_id => p_bill_to_address_id
514: ,p_bill_site_name => p_bill_site_name
515: ,p_check_id_flag => 'Y' --bug 5563846
524:
525:
526: if((p_work_site_name <> FND_API.G_MISS_CHAR) AND (p_work_site_name is not NULL)) AND
527: ((p_ship_to_address_id = FND_API.G_MISS_NUM) OR (p_ship_to_address_id is NULL)) then
528: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_WORK_SITE_NAME_OR_ID
529: ( p_customer_id => l_ship_to_customer_id /* For Bug 2731449 */
530: ,p_ship_to_address_id => p_ship_to_address_id
531: ,p_work_site_name => p_work_site_name
532: ,x_ship_to_address_id => l_ship_to_address_id
538: end if;
539: end if;
540:
541: if((p_ship_to_address_id <> FND_API.G_MISS_NUM) AND (p_ship_to_address_id is not NULL)) then
542: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_WORK_SITE_NAME_OR_ID
543: ( p_customer_id => l_ship_to_customer_id /* For Bug 2731449 */
544: ,p_ship_to_address_id => p_ship_to_address_id
545: ,p_work_site_name => p_work_site_name
546: ,p_check_id_flag => 'Y' --bug 5563846
555:
556:
557: /*changes for bug 7225756 end here*/
558: /*
559: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_RECEIVER_PROJ_NAME_OR_ID
560: ( p_receiver_task_id => p_receiver_task_id
561: ,p_receiver_project_name => p_receiver_project_name
562: ,x_receiver_task_id => l_receiver_task_id
563: ,x_return_status => l_return_status
970: /* Amit 2965841: Chcecking only id is not sufficient. Added new code below
971:
972: -- check whether bill to and ship to customer passes are valid or not
973: if(p_bill_to_customer_id <> NULL) THEN
974: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NAME_OR_ID
975: ( p_customer_id => p_bill_to_customer_id
976: ,p_check_id_flag => 'Y'
977: ,x_customer_id => l_bill_to_customer_id
978: ,x_return_status => l_return_status
983: end if;
984: end if;
985:
986: if(p_ship_to_customer_id <> NULL) THEN
987: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NAME_OR_ID
988: ( p_customer_id => p_ship_to_customer_id
989: ,p_check_id_flag => 'Y'
990: ,x_customer_id => l_ship_to_customer_id
991: ,x_return_status => l_return_status
999: -- Check for Bill Customer
1000: -- Amit 2965841: We shd first check for Number as it is unique. And if it is able to find the id then we shd skip the check for name
1001: if ((p_bill_to_customer_number <> FND_API.G_MISS_CHAR) AND (p_bill_to_customer_number is not NULL)) OR
1002: ((p_bill_to_customer_id <> FND_API.G_MISS_NUM) AND (p_bill_to_customer_id is not NULL)) then
1003: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NUMBER_OR_ID
1004: ( p_customer_id => p_bill_to_customer_id
1005: ,p_customer_number => p_bill_to_customer_number
1006: ,x_customer_id => l_bill_to_customer_id
1007: ,x_return_status => l_return_status
1013: end if;
1014: if l_bill_to_customer_id is null then -- Amit 2965841:
1015: if ((p_bill_to_customer_name <> FND_API.G_MISS_CHAR) AND (p_bill_to_customer_name is not NULL)) OR
1016: ((p_bill_to_customer_id <> FND_API.G_MISS_NUM) AND (p_bill_to_customer_id is not NULL)) then
1017: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NAME_OR_ID
1018: ( p_customer_id => p_bill_to_customer_id
1019: ,p_customer_name => p_bill_to_customer_name
1020: ,x_customer_id => l_bill_to_customer_id
1021: ,x_return_status => l_return_status
1028: end if; -- : Amit 2965841
1029:
1030: if ((p_bill_to_customer_name <> FND_API.G_MISS_CHAR) AND (p_bill_to_customer_name is not NULL)) AND
1031: ((p_bill_to_customer_number <> FND_API.G_MISS_CHAR) AND (p_bill_to_customer_number is not NULL)) THEN
1032: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NAME_AND_NUMBER
1033: ( p_customer_name => p_bill_to_customer_name
1034: ,p_customer_number => p_bill_to_customer_number
1035: ,x_customer_id => l_bill_to_customer_id
1036: ,x_return_status => l_return_status
1055: -- Check for Ship Customer
1056: -- Amit 2965841: We shd first check for Number as it is unique. And if it is able to find the id then we shd skip the check for name
1057: if ((p_ship_to_customer_number <> FND_API.G_MISS_CHAR) AND (p_ship_to_customer_number is not NULL)) OR
1058: ((p_ship_to_customer_id <> FND_API.G_MISS_NUM) AND (p_ship_to_customer_id is not NULL)) then
1059: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NUMBER_OR_ID
1060: ( p_customer_id => p_ship_to_customer_id
1061: ,p_customer_number => p_ship_to_customer_number
1062: ,x_customer_id => l_ship_to_customer_id
1063: ,x_return_status => l_return_status
1070:
1071: if l_ship_to_customer_id is null then -- : Amit 2965841
1072: if ((p_ship_to_customer_name <> FND_API.G_MISS_CHAR) AND (p_ship_to_customer_name is not NULL)) OR
1073: ((p_ship_to_customer_id <> FND_API.G_MISS_NUM) AND (p_ship_to_customer_id is not NULL)) then
1074: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NAME_OR_ID
1075: ( p_customer_id => p_ship_to_customer_id
1076: ,p_customer_name => p_ship_to_customer_name
1077: ,x_customer_id => l_ship_to_customer_id
1078: ,x_return_status => l_return_status
1085: end if; -- : Amit 2965841
1086:
1087: if ((p_ship_to_customer_name <> FND_API.G_MISS_CHAR) AND (p_ship_to_customer_name is not NULL)) AND
1088: ((p_ship_to_customer_number <> FND_API.G_MISS_CHAR) AND (p_ship_to_customer_number is not NULL)) THEN
1089: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NAME_AND_NUMBER
1090: ( p_customer_name => p_ship_to_customer_name
1091: ,p_customer_number => p_ship_to_customer_number
1092: ,x_customer_id => l_ship_to_customer_id
1093: ,x_return_status => l_return_status
1138: l_check_id_flag := 'N';
1139: END IF;
1140: if ((p_bill_site_name <> FND_API.G_MISS_CHAR) AND (p_bill_site_name is not NULL)) OR
1141: ((p_bill_to_address_id <> FND_API.G_MISS_NUM) AND (p_bill_to_address_id is not NULL)) then
1142: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_BILL_SITE_NAME_OR_ID
1143: ( p_customer_id => l_bill_to_customer_id -- Amit 2965841
1144: ,p_bill_to_address_id => p_bill_to_address_id
1145: ,p_bill_site_name => p_bill_site_name
1146: ,p_check_id_flag => l_check_id_flag --Variable added for tarcking bug by aditi
1159: --dbms_output.put_line('Value of p_ship_to_address_id'||p_ship_to_address_id);
1160:
1161: if ((p_work_site_name <> FND_API.G_MISS_CHAR) AND (p_work_site_name is not NULL)) OR
1162: ((p_ship_to_address_id <> FND_API.G_MISS_NUM) AND (p_ship_to_address_id is not NULL)) then
1163: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_WORK_SITE_NAME_OR_ID
1164: ( p_customer_id => l_ship_to_customer_id -- Amit 2965841
1165: ,p_ship_to_address_id => p_ship_to_address_id
1166: ,p_work_site_name => p_work_site_name
1167: ,p_check_id_flag => l_check_id_flag --Variable added for tarcking bug by aditi
1179: --dbms_output.put_line('Value of p_ship_to_address_id after '||p_ship_to_address_id);
1180: --dbms_output.put_line('Value of l_ship_to_address_id after '||l_ship_to_address_id);
1181:
1182: /*
1183: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_RECEIVER_PROJ_NAME_OR_ID
1184: ( p_receiver_task_id => p_receiver_task_id
1185: ,p_receiver_project_name => p_receiver_project_name
1186: ,x_receiver_task_id => l_receiver_task_id
1187: ,x_return_status => l_return_status
1687:
1688: if p_calling_module <> 'FORM' then
1689: if ((p_project_contact_type_name <> FND_API.G_MISS_CHAR) AND (p_project_contact_type_name is not NULL)) OR
1690: ((p_project_contact_type_code <> FND_API.G_MISS_CHAR) AND (p_project_contact_type_code is not NULL)) then
1691: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CONTACT_TYP_NAME_OR_CODE
1692: ( p_project_contact_type_code => p_project_contact_type_code
1693: ,p_project_contact_type_name => p_project_contact_type_name
1694: ,p_check_id_flag => 'N'
1695: ,x_project_contact_type_code => l_project_contact_type_code
1714:
1715: -- check for contact id with respect to bill to or ship to or project customer depending on value of p_project_contact_type_code
1716: if ((p_contact_name <> FND_API.G_MISS_CHAR) AND (p_contact_name is not NULL)) OR
1717: ((p_contact_id <> FND_API.G_MISS_NUM) AND (p_contact_id is not NULL)) then
1718: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CONTACT_NAME_OR_ID
1719: ( p_customer_id => p_customer_id
1720: ,p_project_contact_type_code => l_project_contact_type_code
1721: ,p_contact_id => p_contact_id
1722: ,p_contact_name => p_contact_name
1782: END IF;
1783:
1784: -- check for contact id with respect to bill to or ship to or project customer depending on value of p_project_contact_type_code
1785: if ((l_project_contact_type_code <> 'BILLING') AND (l_project_contact_type_code <> 'SHIPPING'))THEN
1786: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CONTACT_NAME_OR_ID
1787: ( p_customer_id => p_customer_id
1788: ,p_project_contact_type_code => l_project_contact_type_code
1789: ,p_contact_id => p_contact_id
1790: ,p_contact_name => p_contact_name
1795: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1796: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
1797: end if;
1798: else
1799: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CONTACT_NAME_OR_ID
1800: ( p_customer_id => p_bill_ship_customer_id
1801: ,p_project_contact_type_code => l_project_contact_type_code
1802: ,p_contact_id => p_contact_id
1803: ,p_contact_name => p_contact_name
2053:
2054: if p_calling_module <> 'FORM' then
2055: if ((p_project_contact_type_name <> FND_API.G_MISS_CHAR) AND (p_project_contact_type_name is not NULL)) OR
2056: ((p_project_contact_type_code <> FND_API.G_MISS_CHAR) AND (p_project_contact_type_code is not NULL)) then
2057: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CONTACT_TYP_NAME_OR_CODE
2058: ( p_project_contact_type_code => p_project_contact_type_code
2059: ,p_project_contact_type_name => p_project_contact_type_name
2060: ,p_check_id_flag => 'N'
2061: ,x_project_contact_type_code => l_project_contact_type_code
2080: ((p_contact_id <> FND_API.G_MISS_NUM) AND (p_contact_id is not NULL)) then
2081: For Bug 2731449
2082: -- check for contact id with respect to bill to or ship to or project customer depending on value of p_project_contact_type_code
2083:
2084: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CONTACT_NAME_OR_ID
2085: ( p_customer_id => p_customer_id
2086: ,p_project_contact_type_code => l_project_contact_type_code
2087: ,p_contact_id => p_contact_id
2088: ,p_contact_name => p_contact_name
2148: END IF;
2149:
2150: -- check for contact id with respect to bill to or ship to or project customer depending on value of p_project_contact_type_code
2151: if ((l_project_contact_type_code <> 'BILLING') AND (l_project_contact_type_code <> 'SHIPPING'))THEN
2152: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CONTACT_NAME_OR_ID
2153: ( p_customer_id => p_customer_id
2154: ,p_project_contact_type_code => l_project_contact_type_code
2155: ,p_contact_id => p_contact_id
2156: ,p_contact_name => p_contact_name
2161: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2162: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
2163: end if;
2164: else
2165: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CONTACT_NAME_OR_ID
2166: ( p_customer_id => p_bill_ship_customer_id
2167: ,p_project_contact_type_code => l_project_contact_type_code
2168: ,p_contact_id => p_contact_id
2169: ,p_contact_name => p_contact_name