[Home] [Help]
205: --sunkalya:federal bug#5511353
206:
207: IF l_en_top_task_cust_flag = 'N' AND nvl(l_date_eff_funds_consumption,'N') ='N' THEN --bug#5511353
208: if p_customer_bill_split is NULL then
209: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
210: ,p_msg_name => 'PA_CUST_BILL_SPLIT_INVALID');
211: end if;
212: END IF;
213:
213:
214: --sunkalya:federal bug#5511353
215:
216: if p_project_relationship_code is NULL then
217: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
218: ,p_msg_name => 'PA_RELATIONSHIP_CODE_REQD');
219: end if;
220:
221:
222: /* START For Bug 2731449 */
223: -- checking for not null values as bill to customer and shipt to customer are mandatory fields
224: /* Amit 2965841 : Commented as not sufficent to check only for id. New check is added below.
225: if p_bill_to_customer_id is NULL then
226: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
227: ,p_msg_name => 'PA_BILL_TO_CUST_NAME_REQD');
228: end if;
229:
230: if p_ship_to_customer_id is NULL then
227: ,p_msg_name => 'PA_BILL_TO_CUST_NAME_REQD');
228: end if;
229:
230: if p_ship_to_customer_id is NULL then
231: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
232: ,p_msg_name => 'PA_SHIP_TO_CUST_NAME_REQD');
233: end if;
234: : Amit 2965841*/
235: /* End For Bug 2731449 */
239:
240: if ((p_customer_name = FND_API.G_MISS_CHAR) OR (p_customer_name is NULL)) AND
241: ((p_customer_number = FND_API.G_MISS_CHAR) OR (p_customer_number is NULL)) AND
242: ((p_customer_id = FND_API.G_MISS_NUM) OR (p_customer_id is NULL)) then
243: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
244: ,p_msg_name => 'PA_CUST_NAME_OR_NUM_REQD');
245: end if;
246: -- Amit : Bug 2965841 New two checks are added below
247: if ((p_bill_to_customer_name = FND_API.G_MISS_CHAR) OR (p_bill_to_customer_name is NULL)) AND
246: -- Amit : Bug 2965841 New two checks are added below
247: if ((p_bill_to_customer_name = FND_API.G_MISS_CHAR) OR (p_bill_to_customer_name is NULL)) AND
248: ((p_bill_to_customer_number = FND_API.G_MISS_CHAR) OR (p_bill_to_customer_number is NULL)) AND
249: ((p_bill_to_customer_id = FND_API.G_MISS_NUM) OR (p_bill_to_customer_id is NULL)) then
250: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
251: ,p_msg_name => 'PA_BILL_TO_CUST_NAME_REQD');
252: end if;
253:
254: if ((p_ship_to_customer_name = FND_API.G_MISS_CHAR) OR (p_ship_to_customer_name is NULL)) AND
253:
254: if ((p_ship_to_customer_name = FND_API.G_MISS_CHAR) OR (p_ship_to_customer_name is NULL)) AND
255: ((p_ship_to_customer_number = FND_API.G_MISS_CHAR) OR (p_ship_to_customer_number is NULL)) AND
256: ((p_ship_to_customer_id = FND_API.G_MISS_NUM) OR (p_ship_to_customer_id is NULL)) then
257: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
258: ,p_msg_name => 'PA_SHIP_TO_CUST_NAME_REQD');
259: end if;
260:
261: IF p_calling_module = 'AMG' THEN
277: ,x_return_status => l_return_status
278: ,x_error_msg_code => l_error_msg_code);
279:
280: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
281: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
282: end if;
283: end if;
284: --dbms_output.put_line('33333333333 Value of p_customer_id'||p_customer_id);
285: --dbms_output.put_line('33333333333333 Value of l_customer_id'||l_customer_id);
294: ,x_return_status => l_return_status
295: ,x_error_msg_code => l_error_msg_code);
296:
297: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
298: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
299: end if;
300: end if;
301: end if; -- : Amit 2965841
302: --dbms_output.put_line('44444444444 Value of p_customer_id'||p_customer_id);
310: ,x_return_status => l_return_status
311: ,x_error_msg_code => l_error_msg_code);
312:
313: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
314: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
315: end if;
316: end if;
317: --dbms_output.put_line('5555555 Value of p_customer_id'||p_customer_id);
318: --dbms_output.put_line('5555555555555 Value of l_customer_id'||l_customer_id);
327: ,x_return_status => l_return_status
328: ,x_error_msg_code => l_error_msg_code);
329:
330: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
331: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
332: end if;
333: end if;
334:
335: if(p_ship_to_customer_id <> NULL) THEN
340: ,x_return_status => l_return_status
341: ,x_error_msg_code => l_error_msg_code);
342:
343: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
344: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
345: end if;
346: end if;
347: : Amit */
348:
360: ,x_return_status => l_return_status
361: ,x_error_msg_code => l_error_msg_code);
362:
363: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
364: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name =>l_error_msg_code||'_BILL');-- Amit 2965841
365: end if;
366: end if;
367:
368: if l_bill_to_customer_id is null then -- Amit 2965841:
375: ,x_return_status => l_return_status
376: ,x_error_msg_code => l_error_msg_code);
377:
378: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
379: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code||'_BILL');-- Amit 2965841
380: end if;
381: end if;
382: end if; -- : Amit 2965841
383:
395: l_error_msg_code := l_error_msg_code||'_B';
396: else
397: l_error_msg_code := l_error_msg_code||'_BILL';
398: end if;
399: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
400: end if;
401: end if;
402: -- Bug 2984882 : added following condition
403: if (l_bill_to_customer_id is null and p_bill_to_customer_id is not null and p_bill_to_customer_id <> FND_API.G_MISS_NUM and l_return_status = FND_API.G_RET_STS_SUCCESS) then
416: ,x_return_status => l_return_status
417: ,x_error_msg_code => l_error_msg_code);
418:
419: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
420: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code||'_SHIP');-- Amit 2965841
421: end if;
422: end if;
423:
424: if l_ship_to_customer_id is null then -- Amit 2965841:
431: ,x_return_status => l_return_status
432: ,x_error_msg_code => l_error_msg_code);
433:
434: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
435: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code||'_SHIP');-- Amit 2965841
436: end if;
437: end if;
438: end if; -- : Amit 2965841
439:
452: l_error_msg_code := l_error_msg_code||'_S';
453: else
454: l_error_msg_code := l_error_msg_code||'_SHIP';
455: end if;
456: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
457: end if;
458: end if;
459:
460: -- Bug 2984882 : added following condition
471: IF (l_bill_to_customer_id <> l_customer_id) THEN
472: OPEN C2;
473: FETCH C2 INTO l_valid_bill_id;
474: IF C2%NOTFOUND Then
475: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => 'PA_BILL_TO_NOT_VALID');
476: End If;
477: CLOSE C2; --Bug 3865203
478: END IF;
479: --BUG#2876256
480: IF (l_ship_to_customer_id <> l_customer_id) THEN
481: OPEN C3;
482: FETCH C3 INTO l_valid_ship_id;
483: IF C3%NOTFOUND Then
484: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => 'PA_SHIP_TO_NOT_VALID');
485: End If;
486: CLOSE C3; --Bug 3865203
487: END IF;
488: END If;
501: ,x_return_status => l_return_status
502: ,x_error_msg_code => l_error_msg_code);
503:
504: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
505: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
506: end if;
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
517: ,x_return_status => l_return_status
518: ,x_error_msg_code => l_error_msg_code);
519:
520: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
521: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
522: end if;
523: end if;
524:
525:
533: ,x_return_status => l_return_status
534: ,x_error_msg_code => l_error_msg_code);
535:
536: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
537: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
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
548: ,x_return_status => l_return_status
549: ,x_error_msg_code => l_error_msg_code);
550:
551: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
552: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
553: end if;
554: end if;
555:
556:
563: ,x_return_status => l_return_status
564: ,x_error_msg_code => l_error_msg_code);
565:
566: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
567: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
568: end if;
569: */
570:
571: --Added by Ansari for currency name to code check.
581: ,x_return_status => l_return_status
582: ,x_error_msg_code => l_error_msg_code);
583:
584: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
585: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
586: end if;
587: end if;
588:
589:
921: --added the AND condition in the IF below for federal changes.Sunkalya bug#5511353
922:
923: IF l_en_top_task_cust_flag = 'N' AND nvl(l_date_eff_funds_consumption,'N') ='N' THEN
924: if p_customer_bill_split is NULL then
925: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
926: ,p_msg_name => 'PA_CUST_BILL_SPLIT_INVALID');
927: end if;
928: END IF;
929: if p_project_relationship_code is NULL then
926: ,p_msg_name => 'PA_CUST_BILL_SPLIT_INVALID');
927: end if;
928: END IF;
929: if p_project_relationship_code is NULL then
930: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
931: ,p_msg_name => 'PA_RELATIONSHIP_CODE_REQD');
932: end if;
933: /* START For Bug 2731449 */
934: -- checking for not null values as bill to customer and ship to customer are mandatory fields
933: /* START For Bug 2731449 */
934: -- checking for not null values as bill to customer and ship to customer are mandatory fields
935: /* Amit 2965841: Chcecking only id is not sufficient . New code added below.
936: if p_bill_to_customer_id is NULL then
937: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
938: ,p_msg_name => 'PA_BILL_TO_CUST_NAME_REQD');
939: end if;
940:
941: if p_ship_to_customer_id is NULL then
938: ,p_msg_name => 'PA_BILL_TO_CUST_NAME_REQD');
939: end if;
940:
941: if p_ship_to_customer_id is NULL then
942: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
943: ,p_msg_name => 'PA_SHIP_TO_CUST_NAME_REQD');
944: end if;
945: : Amit 2965841 */
946:
949:
950: if ((p_bill_to_customer_name = FND_API.G_MISS_CHAR) OR (p_bill_to_customer_name is NULL)) AND
951: ((p_bill_to_customer_number = FND_API.G_MISS_CHAR) OR (p_bill_to_customer_number is NULL)) AND
952: ((p_bill_to_customer_id = FND_API.G_MISS_NUM) OR (p_bill_to_customer_id is NULL)) then
953: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
954: ,p_msg_name => 'PA_BILL_TO_CUST_NAME_REQD');
955: end if;
956:
957: if ((p_ship_to_customer_name = FND_API.G_MISS_CHAR) OR (p_ship_to_customer_name is NULL)) AND
956:
957: if ((p_ship_to_customer_name = FND_API.G_MISS_CHAR) OR (p_ship_to_customer_name is NULL)) AND
958: ((p_ship_to_customer_number = FND_API.G_MISS_CHAR) OR (p_ship_to_customer_number is NULL)) AND
959: ((p_ship_to_customer_id = FND_API.G_MISS_NUM) OR (p_ship_to_customer_id is NULL)) then
960: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
961: ,p_msg_name => 'PA_SHIP_TO_CUST_NAME_REQD');
962: end if;
963:
964:
978: ,x_return_status => l_return_status
979: ,x_error_msg_code => l_error_msg_code);
980:
981: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
982: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
983: end if;
984: end if;
985:
986: if(p_ship_to_customer_id <> NULL) THEN
991: ,x_return_status => l_return_status
992: ,x_error_msg_code => l_error_msg_code);
993:
994: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
995: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
996: end if;
997: end if;
998: : Amit 2965841*/
999: -- Check for Bill Customer
1007: ,x_return_status => l_return_status
1008: ,x_error_msg_code => l_error_msg_code);
1009:
1010: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1011: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name =>l_error_msg_code||'_BILL'); -- Amit 2965841
1012: end if;
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
1021: ,x_return_status => l_return_status
1022: ,x_error_msg_code => l_error_msg_code);
1023:
1024: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1025: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code||'_BILL');-- Amit 2965841
1026: end if;
1027: end if;
1028: end if; -- : Amit 2965841
1029:
1041: l_error_msg_code := l_error_msg_code||'_B';
1042: else
1043: l_error_msg_code := l_error_msg_code||'_BILL';
1044: end if;
1045: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
1046: end if;
1047: end if;
1048:
1049: -- Bug 2984882 : added following condition
1063: ,x_return_status => l_return_status
1064: ,x_error_msg_code => l_error_msg_code);
1065:
1066: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1067: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code||'_SHIP');-- Amit 2965841
1068: end if;
1069: end if;
1070:
1071: if l_ship_to_customer_id is null then -- : Amit 2965841
1078: ,x_return_status => l_return_status
1079: ,x_error_msg_code => l_error_msg_code);
1080:
1081: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1082: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code||'_SHIP');-- Amit 2965841
1083: end if;
1084: end if;
1085: end if; -- : Amit 2965841
1086:
1098: l_error_msg_code := l_error_msg_code||'_S';
1099: else
1100: l_error_msg_code := l_error_msg_code||'_SHIP';
1101: end if;
1102: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
1103: end if;
1104: end if;
1105:
1106: -- Bug 2984882 : added following condition
1116: IF (l_bill_to_customer_id <> p_customer_id) THEN
1117: OPEN C3;
1118: FETCH C3 INTO l_valid_bill_id;
1119: IF C3%NOTFOUND Then
1120: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => 'PA_BILL_TO_NOT_VALID');
1121: End If;
1122: CLOSE C3; --Bug 3865203
1123: END IF;
1124: --BUG#2876256
1125: IF (l_ship_to_customer_id <> p_customer_id) THEN
1126: OPEN C4;
1127: FETCH C4 INTO l_valid_ship_id;
1128: IF C4%NOTFOUND Then
1129: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => 'PA_SHIP_TO_NOT_VALID');
1130: End If;
1131: CLOSE C4; --Bug 3865203
1132: END IF;
1133: END If;
1148: ,x_return_status => l_return_status
1149: ,x_error_msg_code => l_error_msg_code);
1150:
1151: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1152: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
1153: end if;
1154: end if;
1155: --dbms_output.put_line('Value of l_bill_to_customer_id after '||l_bill_to_customer_id);
1156: --dbms_output.put_line('Value of p_bill_to_address_id after '||p_bill_to_address_id);
1171:
1172: /* End For Bug 2731449 */
1173:
1174: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1175: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
1176: end if;
1177: end if;
1178: --dbms_output.put_line('Value of l_ship_to_customer_id after '||l_ship_to_customer_id);
1179: --dbms_output.put_line('Value of p_ship_to_address_id after '||p_ship_to_address_id);
1187: ,x_return_status => l_return_status
1188: ,x_error_msg_code => l_error_msg_code);
1189:
1190: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1191: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
1192: end if;
1193: */
1194:
1195: --Added by Ansari for currency name to code check.
1205: ,x_return_status => l_return_status
1206: ,x_error_msg_code => l_error_msg_code);
1207:
1208: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1209: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
1210: end if;
1211: end if;
1212: /* START For Bug 2731449 */
1213: -- Delete all the contacts of type billing or shipping respective of either bill to customer or ship to customer has been changed
1680: end if;
1681:
1682: if ((p_project_contact_type_code = FND_API.G_MISS_CHAR) OR (p_project_contact_type_code is NULL)) AND
1683: ((p_project_contact_type_name = FND_API.G_MISS_CHAR) OR (p_project_contact_type_name is NULL)) then
1684: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1685: ,p_msg_name => 'PA_CONTACT_TYPE_REQD');
1686: end if;
1687:
1688: if p_calling_module <> 'FORM' then
1696: ,x_return_status => l_return_status
1697: ,x_error_msg_code => l_error_msg_code);
1698:
1699: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1700: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
1701: end if;
1702: end if;
1703: end if;
1704:
1703: end if;
1704:
1705: if ((p_contact_id = FND_API.G_MISS_NUM) OR (p_contact_id is NULL)) AND
1706: ((p_contact_name = FND_API.G_MISS_CHAR) OR (p_contact_name is NULL)) then
1707: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1708: ,p_msg_name => 'PA_CONTACT_NAME_REQD');
1709: end if;
1710:
1711: -- Amit 2965841 : Commented the whole code for p_calling_module <> 'FORM' condition and added new code below it.
1724: ,x_return_status => l_return_status
1725: ,x_error_msg_code => l_error_msg_code);
1726:
1727: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1728: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
1729: end if;
1730: end if;
1731:
1732: if ((p_project_contact_type_code <> 'BILLING') AND (p_project_contact_type_code <> 'SHIPPING'))THEN
1733:
1734: OPEN C2;
1735: FETCH C2 INTO l_validate;
1736: IF C2%NOTFOUND THEN
1737: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => 'PA_INV_CONTRACT_CONTACT');
1738: END IF;
1739: CLOSE C2; -- Bug 2874261
1740: else
1741: if(p_project_contact_type_code <> 'BILLING') Then
1746: OPEN C1;
1747: FETCH C1 INTO l_validate;
1748: IF C1%NOTFOUND THEN
1749: if(p_project_contact_type_code <> 'BILLING') Then
1750: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => 'PA_INV_SHIP_CONTACT');
1751: else
1752: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => 'PA_INV_BILL_CONTACT');
1753: end if;
1754: END IF;
1748: IF C1%NOTFOUND THEN
1749: if(p_project_contact_type_code <> 'BILLING') Then
1750: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => 'PA_INV_SHIP_CONTACT');
1751: else
1752: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => 'PA_INV_BILL_CONTACT');
1753: end if;
1754: END IF;
1755: CLOSE C1; -- Bug 2874261
1756: End if;
1792: ,x_return_status => l_return_status
1793: ,x_error_msg_code => l_error_msg_code);
1794:
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
1806: ,x_return_status => l_return_status
1807: ,x_error_msg_code => l_error_msg_code);
1808:
1809: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1810: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
1811: end if;
1812: end if;
1813:
1814: else -- p_calling_module <> 'FORM'
2044: end if;
2045:
2046: if ((p_project_contact_type_code = FND_API.G_MISS_CHAR) OR (p_project_contact_type_code is NULL)) AND
2047: ((p_project_contact_type_name = FND_API.G_MISS_CHAR) OR (p_project_contact_type_name is NULL)) then
2048: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2049: ,p_msg_name => 'PA_CONTACT_TYPE_REQD');
2050: end if;
2051:
2052: -- Amit 2965841: Uncommented the below code. It is required.
2062: ,x_return_status => l_return_status
2063: ,x_error_msg_code => l_error_msg_code);
2064:
2065: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2066: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
2067: end if;
2068: end if;
2069: end if;
2070:
2069: end if;
2070:
2071: if ((p_contact_id = FND_API.G_MISS_NUM) OR (p_contact_id is NULL)) AND
2072: ((p_contact_name = FND_API.G_MISS_CHAR) OR (p_contact_name is NULL)) then
2073: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2074: ,p_msg_name => 'PA_CONTACT_NAME_REQD');
2075: end if;
2076:
2077: -- Amit 2965841: Commented the whole code for p_calling_module <> 'FORM' condition and added new code below it.
2090: ,x_return_status => l_return_status
2091: ,x_error_msg_code => l_error_msg_code);
2092:
2093: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2094: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
2095: end if;
2096: end if;
2097:
2098: if ((p_project_contact_type_code <> 'BILLING') AND (p_project_contact_type_code <> 'SHIPPING'))THEN
2099:
2100: OPEN C2;
2101: FETCH C2 INTO l_validate;
2102: IF C2%NOTFOUND THEN
2103: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => 'PA_INV_CONTRACT_CONTACT');
2104: END IF;
2105: CLOSE C2;
2106: else
2107: if(p_project_contact_type_code <> 'BILLING') Then
2112: OPEN C1;
2113: FETCH C1 INTO l_validate;
2114: IF C1%NOTFOUND THEN
2115: if(p_project_contact_type_code <> 'BILLING') Then
2116: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => 'PA_INV_SHIP_CONTACT');
2117: else
2118: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => 'PA_INV_BILL_CONTACT');
2119: end if;
2120: END IF;
2114: IF C1%NOTFOUND THEN
2115: if(p_project_contact_type_code <> 'BILLING') Then
2116: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => 'PA_INV_SHIP_CONTACT');
2117: else
2118: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => 'PA_INV_BILL_CONTACT');
2119: end if;
2120: END IF;
2121: CLOSE C1;
2122: End if;
2158: ,x_return_status => l_return_status
2159: ,x_error_msg_code => l_error_msg_code);
2160:
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
2172: ,x_return_status => l_return_status
2173: ,x_error_msg_code => l_error_msg_code);
2174:
2175: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2176: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
2177: end if;
2178: end if;
2179:
2180: else -- p_calling_module <> 'FORM'