[Home] [Help]
16: --Description: This procedure can be used to create an agreement for an
17: -- existing project or template.
18: --
19: --Called subprograms:
20: -- pa_interface_utils_pub.map_new_amg_msg
21: -- pa_agreement_pub.check_create_agreement_ok
22: -- pa_agreement_utils.validate_flex_fields
23: -- pa_agreement_pvt.convert_ag_ref_to_id
24: -- pa_agreement_utils.create_agreement
34: -- update_agreement procedure.
35: -- ---------------------------------------------------------------------------
36:
37: PROCEDURE create_agreement
38: (p_api_version_number IN NUMBER --:=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
39: ,p_commit IN VARCHAR2 --:= FND_API.G_FALSE
40: ,p_init_msg_list IN VARCHAR2 --:= FND_API.G_FALSE
41: ,p_msg_count OUT NOCOPY NUMBER /*file.sql.39*/
42: ,p_msg_data OUT NOCOPY VARCHAR2 /*file.sql.39*/
40: ,p_init_msg_list IN VARCHAR2 --:= FND_API.G_FALSE
41: ,p_msg_count OUT NOCOPY NUMBER /*file.sql.39*/
42: ,p_msg_data OUT NOCOPY VARCHAR2 /*file.sql.39*/
43: ,p_return_status OUT NOCOPY VARCHAR2
44: ,p_pm_product_code IN VARCHAR2 --:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
45: ,p_agreement_in_rec IN Agreement_Rec_In_Type
46: ,p_agreement_out_rec OUT NOCOPY Agreement_Rec_Out_Type /*file.sql.39*/
47: ,p_funding_in_tbl IN funding_in_tbl_type
48: ,p_funding_out_tbl OUT NOCOPY funding_out_tbl_type /*File.sql.39*/
118: END IF;
119:
120:
121: IF l_function_allowed = 'N' THEN
122: pa_interface_utils_pub.map_new_amg_msg
123: ( p_old_message_code => 'PA_FUNC_SECURITY_ENFORCED'
124: ,p_msg_attribute => 'CHANGE'
125: ,p_resize_flag => 'Y'
126: ,p_msg_context => 'GENERAL'
150: -- CHECK WHETHER MANDATORY INCOMING PARAMETERS EXIST
151:
152: -- Product Code
153: IF (p_pm_product_code IS NULL)
154: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
155: THEN
156: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
157: THEN
158: pa_interface_utils_pub.map_new_amg_msg
154: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
155: THEN
156: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
157: THEN
158: pa_interface_utils_pub.map_new_amg_msg
159: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISS'
160: ,p_msg_attribute => 'CHANGE'
161: ,p_resize_flag => 'N'
162: ,p_msg_context => 'GENERAL'
172: END IF;
173:
174: -- Agreement Reference
175: IF (p_agreement_in_rec.pm_agreement_reference IS NULL)
176: OR (p_agreement_in_rec.pm_agreement_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
177: THEN
178: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
179: THEN
180: pa_interface_utils_pub.map_new_amg_msg
176: OR (p_agreement_in_rec.pm_agreement_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
177: THEN
178: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
179: THEN
180: pa_interface_utils_pub.map_new_amg_msg
181: ( p_old_message_code => 'PA_AGMT_REF_IS_MISS'
182: ,p_msg_attribute => 'CHANGE'
183: ,p_resize_flag => 'N'
184: ,p_msg_context => 'GENERAL'
194: END IF;
195:
196: -- Agreement Number
197: IF (p_agreement_in_rec.agreement_num IS NULL)
198: OR (p_agreement_in_rec.agreement_num = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
199: THEN
200: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
201: THEN
202: pa_interface_utils_pub.map_new_amg_msg
198: OR (p_agreement_in_rec.agreement_num = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
199: THEN
200: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
201: THEN
202: pa_interface_utils_pub.map_new_amg_msg
203: ( p_old_message_code => 'PA_AGMT_NUM_IS_MISS'
204: ,p_msg_attribute => 'CHANGE'
205: ,p_resize_flag => 'N'
206: ,p_msg_context => 'AGREEMENT'
217:
218: -- Customer Id
219:
220: IF (p_agreement_in_rec.customer_id IS NULL)
221: OR (p_agreement_in_rec.customer_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
222: THEN
223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
224: THEN
225: pa_interface_utils_pub.map_new_amg_msg
221: OR (p_agreement_in_rec.customer_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
222: THEN
223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
224: THEN
225: pa_interface_utils_pub.map_new_amg_msg
226: ( p_old_message_code => 'PA_CUST_ID_IS_MISS'
227: ,p_msg_attribute => 'CHANGE'
228: ,p_resize_flag => 'N'
229: ,p_msg_context => 'AGREEMENT'
239: END IF;
240:
241: -- Customer Number
242: IF (p_agreement_in_rec.customer_num IS NULL)
243: OR (p_agreement_in_rec.customer_num = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
244: THEN
245: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
246: THEN
247: pa_interface_utils_pub.map_new_amg_msg
243: OR (p_agreement_in_rec.customer_num = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
244: THEN
245: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
246: THEN
247: pa_interface_utils_pub.map_new_amg_msg
248: ( p_old_message_code => 'PA_CUST_NUM_IS_MISS'
249: ,p_msg_attribute => 'CHANGE'
250: ,p_resize_flag => 'N'
251: ,p_msg_context => 'AGREEMENT'
261: END IF;
262:
263: -- Agreement Type
264: IF (p_agreement_in_rec.agreement_type IS NULL)
265: OR (p_agreement_in_rec.agreement_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
266: THEN
267: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
268: THEN
269: pa_interface_utils_pub.map_new_amg_msg
265: OR (p_agreement_in_rec.agreement_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
266: THEN
267: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
268: THEN
269: pa_interface_utils_pub.map_new_amg_msg
270: ( p_old_message_code => 'PA_AGMT_TYPE_IS_MISS'
271: ,p_msg_attribute => 'CHANGE'
272: ,p_resize_flag => 'N'
273: ,p_msg_context => 'AGREEMENT'
283: END IF;
284:
285: -- Term Id
286: IF (p_agreement_in_rec.term_id IS NULL)
287: OR (p_agreement_in_rec.term_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
288: THEN
289: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
290: THEN
291: pa_interface_utils_pub.map_new_amg_msg
287: OR (p_agreement_in_rec.term_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
288: THEN
289: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
290: THEN
291: pa_interface_utils_pub.map_new_amg_msg
292: ( p_old_message_code => 'PA_TERM_ID_IS_MISS'
293: ,p_msg_attribute => 'CHANGE'
294: ,p_resize_flag => 'N'
295: ,p_msg_context => 'AGREEMENT'
305: END IF;
306: /*
307: -- Template Flag
308: IF (p_agreement_in_rec.template_flag IS NULL)
309: OR (p_agreement_in_rec.template_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
310: THEN
311: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
312: THEN
313: pa_interface_utils_pub.map_new_amg_msg
309: OR (p_agreement_in_rec.template_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
310: THEN
311: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
312: THEN
313: pa_interface_utils_pub.map_new_amg_msg
314: ( p_old_message_code => 'PA_TEMP_FLG_IS_MISS'
315: ,p_msg_attribute => 'CHANGE'
316: ,p_resize_flag => 'N'
317: ,p_msg_context => 'AGREEMENT'
327: END IF;
328: */
329: -- Revenue Limit Flag
330: IF (p_agreement_in_rec.revenue_limit_flag IS NULL)
331: OR (p_agreement_in_rec.revenue_limit_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
332: THEN
333: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
334: THEN
335: pa_interface_utils_pub.map_new_amg_msg
331: OR (p_agreement_in_rec.revenue_limit_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
332: THEN
333: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
334: THEN
335: pa_interface_utils_pub.map_new_amg_msg
336: ( p_old_message_code => 'PA_REV_LT_FLG_IS_MISS'
337: ,p_msg_attribute => 'CHANGE'
338: ,p_resize_flag => 'N'
339: ,p_msg_context => 'AGREEMENT'
349: END IF;
350:
351: -- Owned By Person Id
352: IF (p_agreement_in_rec.owned_by_person_id IS NULL)
353: OR (p_agreement_in_rec.owned_by_person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
354: THEN
355: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
356: THEN
357: pa_interface_utils_pub.map_new_amg_msg
353: OR (p_agreement_in_rec.owned_by_person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
354: THEN
355: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
356: THEN
357: pa_interface_utils_pub.map_new_amg_msg
358: ( p_old_message_code => 'PA_OWND_BY_PRSN_ID_MISS'
359: ,p_msg_attribute => 'CHANGE'
360: ,p_resize_flag => 'N'
361: ,p_msg_context => 'AGREEMENT'
371: END IF;
372:
373: -- Amount
374: IF (p_agreement_in_rec.amount IS NULL)
375: OR (p_agreement_in_rec.amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
376: THEN
377: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
378: THEN
379: pa_interface_utils_pub.map_new_amg_msg
375: OR (p_agreement_in_rec.amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
376: THEN
377: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
378: THEN
379: pa_interface_utils_pub.map_new_amg_msg
380: ( p_old_message_code => 'PA_ALLOC_AMT_IS_MISS_AMG'
381: ,p_msg_attribute => 'CHANGE'
382: ,p_resize_flag => 'N'
383: ,p_msg_context => 'AGREEMENT'
421: -- Flex Field Validations
422:
423: IF (p_agreement_in_rec.desc_flex_name IS NOT NULL)
424:
425: AND (p_agreement_in_rec.desc_flex_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
426: THEN
427: /*Changed for federal*/
428: pa_agreement_pvt.validate_flex_fields
429: (p_desc_flex_name => p_agreement_in_rec.desc_flex_name
459: IF l_validate_status = 'N'
460: THEN
461: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
462: THEN
463: pa_interface_utils_pub.map_new_amg_msg
464: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
465: ,p_msg_attribute => 'CHANGE'
466: ,p_resize_flag => 'N'
467: ,p_msg_context => 'FLEX'
499: */
500:
501: l_agreement_in_rec := p_agreement_in_rec;
502:
503: IF l_agreement_in_rec.expiration_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE Then
504: l_agreement_in_rec.expiration_date := NULL;
505: END IF;
506:
507: IF l_agreement_in_rec.description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
503: IF l_agreement_in_rec.expiration_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE Then
504: l_agreement_in_rec.expiration_date := NULL;
505: END IF;
506:
507: IF l_agreement_in_rec.description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
508: l_agreement_in_rec.description := NULL;
509: END IF;
510:
511: IF l_agreement_in_rec.desc_flex_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
507: IF l_agreement_in_rec.description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
508: l_agreement_in_rec.description := NULL;
509: END IF;
510:
511: IF l_agreement_in_rec.desc_flex_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
512: l_agreement_in_rec.desc_flex_name := NULL;
513: END IF;
514:
515: IF l_agreement_in_rec.attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
511: IF l_agreement_in_rec.desc_flex_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
512: l_agreement_in_rec.desc_flex_name := NULL;
513: END IF;
514:
515: IF l_agreement_in_rec.attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
516: l_agreement_in_rec.attribute_category := NULL;
517: END IF;
518: IF l_agreement_in_rec.attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
519: l_agreement_in_rec.attribute1 := NULL;
514:
515: IF l_agreement_in_rec.attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
516: l_agreement_in_rec.attribute_category := NULL;
517: END IF;
518: IF l_agreement_in_rec.attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
519: l_agreement_in_rec.attribute1 := NULL;
520: END IF;
521:
522: IF l_agreement_in_rec.attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
518: IF l_agreement_in_rec.attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
519: l_agreement_in_rec.attribute1 := NULL;
520: END IF;
521:
522: IF l_agreement_in_rec.attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
523: l_agreement_in_rec.attribute2 := NULL;
524: END IF;
525: IF l_agreement_in_rec.template_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
526: l_agreement_in_rec.template_flag := NULL;
521:
522: IF l_agreement_in_rec.attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
523: l_agreement_in_rec.attribute2 := NULL;
524: END IF;
525: IF l_agreement_in_rec.template_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
526: l_agreement_in_rec.template_flag := NULL;
527: END IF;
528:
529: IF l_agreement_in_rec.attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
525: IF l_agreement_in_rec.template_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
526: l_agreement_in_rec.template_flag := NULL;
527: END IF;
528:
529: IF l_agreement_in_rec.attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
530: l_agreement_in_rec.attribute3 := NULL;
531: END IF;
532: IF l_agreement_in_rec.attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
533: l_agreement_in_rec.attribute4 := NULL;
528:
529: IF l_agreement_in_rec.attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
530: l_agreement_in_rec.attribute3 := NULL;
531: END IF;
532: IF l_agreement_in_rec.attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
533: l_agreement_in_rec.attribute4 := NULL;
534: END IF;
535: IF l_agreement_in_rec.attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
536: l_agreement_in_rec.attribute5 := NULL;
531: END IF;
532: IF l_agreement_in_rec.attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
533: l_agreement_in_rec.attribute4 := NULL;
534: END IF;
535: IF l_agreement_in_rec.attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
536: l_agreement_in_rec.attribute5 := NULL;
537: END IF;
538: IF l_agreement_in_rec.attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
539: l_agreement_in_rec.attribute6 := NULL;
534: END IF;
535: IF l_agreement_in_rec.attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
536: l_agreement_in_rec.attribute5 := NULL;
537: END IF;
538: IF l_agreement_in_rec.attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
539: l_agreement_in_rec.attribute6 := NULL;
540: END IF;
541: IF l_agreement_in_rec.attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
542: l_agreement_in_rec.attribute7 := NULL;
537: END IF;
538: IF l_agreement_in_rec.attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
539: l_agreement_in_rec.attribute6 := NULL;
540: END IF;
541: IF l_agreement_in_rec.attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
542: l_agreement_in_rec.attribute7 := NULL;
543: END IF;
544: IF l_agreement_in_rec.attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
545: l_agreement_in_rec.attribute8 := NULL;
540: END IF;
541: IF l_agreement_in_rec.attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
542: l_agreement_in_rec.attribute7 := NULL;
543: END IF;
544: IF l_agreement_in_rec.attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
545: l_agreement_in_rec.attribute8 := NULL;
546: END IF;
547: IF l_agreement_in_rec.attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
548: l_agreement_in_rec.attribute9 := NULL;
543: END IF;
544: IF l_agreement_in_rec.attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
545: l_agreement_in_rec.attribute8 := NULL;
546: END IF;
547: IF l_agreement_in_rec.attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
548: l_agreement_in_rec.attribute9 := NULL;
549: END IF;
550: IF l_agreement_in_rec.attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
551: l_agreement_in_rec.attribute10 := NULL;
546: END IF;
547: IF l_agreement_in_rec.attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
548: l_agreement_in_rec.attribute9 := NULL;
549: END IF;
550: IF l_agreement_in_rec.attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
551: l_agreement_in_rec.attribute10 := NULL;
552: END IF;
553:
554: IF l_agreement_in_rec.template_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
550: IF l_agreement_in_rec.attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
551: l_agreement_in_rec.attribute10 := NULL;
552: END IF;
553:
554: IF l_agreement_in_rec.template_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
555: l_agreement_in_rec.template_flag := NULL;
556: END IF;
557:
558: /* Start Bug 2701579 Initialized owning_organization_id,invoice_limit_flag
556: END IF;
557:
558: /* Start Bug 2701579 Initialized owning_organization_id,invoice_limit_flag
559: and agreement_currency_code */
560: IF l_agreement_in_rec.owning_organization_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
561: l_agreement_in_rec.owning_organization_id := NULL;
562: END IF;
563:
564: IF l_agreement_in_rec.invoice_limit_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
560: IF l_agreement_in_rec.owning_organization_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
561: l_agreement_in_rec.owning_organization_id := NULL;
562: END IF;
563:
564: IF l_agreement_in_rec.invoice_limit_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
565: l_agreement_in_rec.invoice_limit_flag := 'N';
566: END IF;
567:
568: IF l_agreement_in_rec.agreement_currency_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
564: IF l_agreement_in_rec.invoice_limit_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
565: l_agreement_in_rec.invoice_limit_flag := 'N';
566: END IF;
567:
568: IF l_agreement_in_rec.agreement_currency_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
569: SELECT pa_currency.get_currency_code
570: INTO l_agreement_in_rec.agreement_currency_code from dual;
571: END IF;
572: /* End- Bug 2701579 */
572: /* End- Bug 2701579 */
573:
574: /*Federal*/
575:
576: IF l_agreement_in_rec.customer_order_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
577: l_agreement_in_rec.customer_order_number := NULL;
578: END IF;
579:
580: /* Code commented for bug 5743599 syarts
577: l_agreement_in_rec.customer_order_number := NULL;
578: END IF;
579:
580: /* Code commented for bug 5743599 syarts
581: IF l_agreement_in_rec.Advance_required = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
582: l_agreement_in_rec.Advance_required := 'N';
583: END IF;
584: Code commented for bug 5743599 ends */
585:
598: END IF;
599: ELSE
600: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
601: THEN
602: pa_interface_utils_pub.map_new_amg_msg
603: ( p_old_message_code => 'PA_CLNT_ADV_CHECK'
604: ,p_msg_attribute => 'CHANGE'
605: ,p_resize_flag => 'N'
606: ,p_msg_context => 'AGREEMENT'
614: RAISE FND_API.G_EXC_ERROR;
615: END IF;
616:
617: IF (l_agreement_in_rec.Advance_required IS NOT NULL and
618: l_agreement_in_rec.Advance_required <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) then
619:
620: IF (FND_FUNCTION.TEST('PA_PAXINEAG_ADVREQ')) THEN
621: null;
622: ELSE
627: END IF;
628:
629: /* Code Added for bug 5743599 ends */
630:
631: IF l_agreement_in_rec.start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE Then
632: l_agreement_in_rec.start_date := NULL;
633: END IF;
634:
635: IF l_agreement_in_rec.Billing_sequence = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
631: IF l_agreement_in_rec.start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE Then
632: l_agreement_in_rec.start_date := NULL;
633: END IF;
634:
635: IF l_agreement_in_rec.Billing_sequence = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
636: l_agreement_in_rec.Billing_sequence := NUll;
637: END IF;
638:
639: IF l_agreement_in_rec.line_of_account = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
635: IF l_agreement_in_rec.Billing_sequence = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
636: l_agreement_in_rec.Billing_sequence := NUll;
637: END IF;
638:
639: IF l_agreement_in_rec.line_of_account = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
640: l_agreement_in_rec.line_of_account := NULL;
641: END IF;
642:
643: IF l_agreement_in_rec.attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
639: IF l_agreement_in_rec.line_of_account = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
640: l_agreement_in_rec.line_of_account := NULL;
641: END IF;
642:
643: IF l_agreement_in_rec.attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
644: l_agreement_in_rec.attribute11 := NULL;
645: END IF;
646:
647: IF l_agreement_in_rec.attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
643: IF l_agreement_in_rec.attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
644: l_agreement_in_rec.attribute11 := NULL;
645: END IF;
646:
647: IF l_agreement_in_rec.attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
648: l_agreement_in_rec.attribute12 := NULL;
649: END IF;
650:
651: IF l_agreement_in_rec.attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
647: IF l_agreement_in_rec.attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
648: l_agreement_in_rec.attribute12 := NULL;
649: END IF;
650:
651: IF l_agreement_in_rec.attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
652: l_agreement_in_rec.attribute13 := NULL;
653: END IF;
654:
655: IF l_agreement_in_rec.attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
651: IF l_agreement_in_rec.attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
652: l_agreement_in_rec.attribute13 := NULL;
653: END IF;
654:
655: IF l_agreement_in_rec.attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
656: l_agreement_in_rec.attribute14 := NULL;
657: END IF;
658:
659: IF l_agreement_in_rec.attribute15 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
655: IF l_agreement_in_rec.attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
656: l_agreement_in_rec.attribute14 := NULL;
657: END IF;
658:
659: IF l_agreement_in_rec.attribute15 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
660: l_agreement_in_rec.attribute15 := NULL;
661: END IF;
662:
663: IF l_agreement_in_rec.attribute16 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
659: IF l_agreement_in_rec.attribute15 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
660: l_agreement_in_rec.attribute15 := NULL;
661: END IF;
662:
663: IF l_agreement_in_rec.attribute16 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
664: l_agreement_in_rec.attribute16 := NULL;
665: END IF;
666:
667: IF l_agreement_in_rec.attribute17 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
663: IF l_agreement_in_rec.attribute16 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
664: l_agreement_in_rec.attribute16 := NULL;
665: END IF;
666:
667: IF l_agreement_in_rec.attribute17 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
668: l_agreement_in_rec.attribute17 := NULL;
669: END IF;
670:
671: IF l_agreement_in_rec.attribute18 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
667: IF l_agreement_in_rec.attribute17 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
668: l_agreement_in_rec.attribute17 := NULL;
669: END IF;
670:
671: IF l_agreement_in_rec.attribute18 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
672: l_agreement_in_rec.attribute18 := NULL;
673: END IF;
674:
675: IF l_agreement_in_rec.attribute19 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
671: IF l_agreement_in_rec.attribute18 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
672: l_agreement_in_rec.attribute18 := NULL;
673: END IF;
674:
675: IF l_agreement_in_rec.attribute19 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
676: l_agreement_in_rec.attribute19 := NULL;
677: END IF;
678:
679: IF l_agreement_in_rec.attribute20 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
675: IF l_agreement_in_rec.attribute19 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
676: l_agreement_in_rec.attribute19 := NULL;
677: END IF;
678:
679: IF l_agreement_in_rec.attribute20 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
680: l_agreement_in_rec.attribute20 := NULL;
681: END IF;
682:
683: IF l_agreement_in_rec.attribute21 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
679: IF l_agreement_in_rec.attribute20 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
680: l_agreement_in_rec.attribute20 := NULL;
681: END IF;
682:
683: IF l_agreement_in_rec.attribute21 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
684: l_agreement_in_rec.attribute21 := NULL;
685: END IF;
686:
687: IF l_agreement_in_rec.attribute22 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
683: IF l_agreement_in_rec.attribute21 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
684: l_agreement_in_rec.attribute21 := NULL;
685: END IF;
686:
687: IF l_agreement_in_rec.attribute22 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
688: l_agreement_in_rec.attribute22 := NULL;
689: END IF;
690:
691: IF l_agreement_in_rec.attribute23 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
687: IF l_agreement_in_rec.attribute22 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
688: l_agreement_in_rec.attribute22 := NULL;
689: END IF;
690:
691: IF l_agreement_in_rec.attribute23 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
692: l_agreement_in_rec.attribute23 := NULL;
693: END IF;
694:
695: IF l_agreement_in_rec.attribute24 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
691: IF l_agreement_in_rec.attribute23 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
692: l_agreement_in_rec.attribute23 := NULL;
693: END IF;
694:
695: IF l_agreement_in_rec.attribute24 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
696: l_agreement_in_rec.attribute24 := NULL;
697: END IF;
698:
699: IF l_agreement_in_rec.attribute25 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
695: IF l_agreement_in_rec.attribute24 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
696: l_agreement_in_rec.attribute24 := NULL;
697: END IF;
698:
699: IF l_agreement_in_rec.attribute25 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
700: l_agreement_in_rec.attribute25 := NULL;
701: END IF;
702:
703: -- CREATE AGREEMENT
775: if (l_funding_in_rec.project_id is NULL
776: or l_funding_in_rec.date_allocated is NULL
777: or l_funding_in_rec.allocated_amount is NULL
778: --or l_funding_in_rec.funding_category is NULL /* Commented for the bug 6780803 */
779: or l_funding_in_rec.project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
780: or l_funding_in_rec.date_allocated = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
781: or l_funding_in_rec.allocated_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
782: --or l_funding_in_rec.funding_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) /* Commented for the bug 6780803 */
783: then
776: or l_funding_in_rec.date_allocated is NULL
777: or l_funding_in_rec.allocated_amount is NULL
778: --or l_funding_in_rec.funding_category is NULL /* Commented for the bug 6780803 */
779: or l_funding_in_rec.project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
780: or l_funding_in_rec.date_allocated = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
781: or l_funding_in_rec.allocated_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
782: --or l_funding_in_rec.funding_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) /* Commented for the bug 6780803 */
783: then
784: --dbms_output.put_line('Funding not entered. ');
777: or l_funding_in_rec.allocated_amount is NULL
778: --or l_funding_in_rec.funding_category is NULL /* Commented for the bug 6780803 */
779: or l_funding_in_rec.project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
780: or l_funding_in_rec.date_allocated = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
781: or l_funding_in_rec.allocated_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
782: --or l_funding_in_rec.funding_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) /* Commented for the bug 6780803 */
783: then
784: --dbms_output.put_line('Funding not entered. ');
785: exit;
778: --or l_funding_in_rec.funding_category is NULL /* Commented for the bug 6780803 */
779: or l_funding_in_rec.project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
780: or l_funding_in_rec.date_allocated = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
781: or l_funding_in_rec.allocated_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
782: --or l_funding_in_rec.funding_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) /* Commented for the bug 6780803 */
783: then
784: --dbms_output.put_line('Funding not entered. ');
785: exit;
786: end if;
819:
820: IF l_valid_currency='N' THEN
821: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
822: THEN
823: pa_interface_utils_pub.map_new_amg_msg
824: ( p_old_message_code => 'PA_CURR_NOT_VALID'
825: ,p_msg_attribute => 'CHANGE'
826: ,p_resize_flag => 'N'
827: ,p_msg_context => 'AGREEMENT'
946: --Description: This procedure can be used to delete an agreement for an
947: -- existing project or template.
948: --
949: --Called subprograms:
950: -- pa_interface_utils_pub.map_new_amg_msg
951: -- pa_agreement_pub.check_delete_agreement_ok
952: -- pa_agreement_pvt.convert_ag_ref_to_id
953: -- pa_agreement_utils.delete_agreement
954:
1031: THEN
1032: RAISE FND_API.G_EXC_ERROR;
1033: END IF;
1034: IF l_function_allowed = 'N' THEN
1035: pa_interface_utils_pub.map_new_amg_msg
1036: ( p_old_message_code => 'PA_FUNC_SECURITY_ENFORCED'
1037: ,p_msg_attribute => 'CHANGE'
1038: ,p_resize_flag => 'Y'
1039: ,p_msg_context => 'GENERAL'
1063: -- CHECK WHETHER MANDATORY INCOMING PARAMETERS EXIST
1064:
1065: -- Product Code
1066: IF (p_pm_product_code IS NULL)
1067: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1068: THEN
1069: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1070: THEN
1071: pa_interface_utils_pub.map_new_amg_msg
1067: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1068: THEN
1069: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1070: THEN
1071: pa_interface_utils_pub.map_new_amg_msg
1072: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISS'
1073: ,p_msg_attribute => 'CHANGE'
1074: ,p_resize_flag => 'N'
1075: ,p_msg_context => 'GENERAL'
1084: END IF;
1085:
1086: -- Agreement Reference
1087: IF (p_pm_agreement_reference IS NULL)
1088: OR (p_pm_agreement_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1089: THEN
1090: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1091: THEN
1092: pa_interface_utils_pub.map_new_amg_msg
1088: OR (p_pm_agreement_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1089: THEN
1090: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1091: THEN
1092: pa_interface_utils_pub.map_new_amg_msg
1093: ( p_old_message_code => 'PA_AGMT_REF_IS_MISS'
1094: ,p_msg_attribute => 'CHANGE'
1095: ,p_resize_flag => 'N'
1096: ,p_msg_context => 'GENERAL'
1105: END IF;
1106: /* NOT REQUIRED
1107: -- Agreement Id
1108: IF (p_agreement_id IS NULL)
1109: OR (p_agreement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1110: THEN
1111: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1112: THEN
1113: pa_interface_utils_pub.map_new_amg_msg
1109: OR (p_agreement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1110: THEN
1111: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1112: THEN
1113: pa_interface_utils_pub.map_new_amg_msg
1114: ( p_old_message_code => 'PA_AGMT_ID_IS_MISS'
1115: ,p_msg_attribute => 'CHANGE'
1116: ,p_resize_flag => 'N'
1117: ,p_msg_context => 'AGREEMENT'
1255: --Description: This procedure can be used to update an agreement for an
1256: -- existing project or template.
1257: --
1258: --Called subprograms:
1259: -- pa_interface_utils_pub.map_new_amg_msg
1260: -- pa_agreement_pub.check_update_agreement_ok
1261: -- pa_agreement_utils.validate_flex_fields
1262: -- pa_agreement_pvt.convert_ag_ref_to_id
1263: -- pa_agreement_utils.update_agreement
1346: THEN
1347: RAISE FND_API.G_EXC_ERROR;
1348: END IF;
1349: IF l_function_allowed = 'N' THEN
1350: pa_interface_utils_pub.map_new_amg_msg
1351: ( p_old_message_code => 'PA_FUNC_SECURITY_ENFORCED'
1352: ,p_msg_attribute => 'CHANGE'
1353: ,p_resize_flag => 'Y'
1354: ,p_msg_context => 'GENERAL'
1379: -- CHECK WHETHER MANDATORY INCOMING PARAMETERS EXIST
1380:
1381: -- Product Code
1382: IF (p_pm_product_code IS NULL)
1383: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1384: THEN
1385: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1386: THEN
1387: pa_interface_utils_pub.map_new_amg_msg
1383: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1384: THEN
1385: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1386: THEN
1387: pa_interface_utils_pub.map_new_amg_msg
1388: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISS'
1389: ,p_msg_attribute => 'CHANGE'
1390: ,p_resize_flag => 'N'
1391: ,p_msg_context => 'GENERAL'
1402:
1403: /*Commented the validation for non mandatory parameter 'pm_agreement_reference' for bug 6601566
1404: -- Agreement Reference
1405: IF (l_agreement_in_rec.pm_agreement_reference IS NULL)
1406: OR (l_agreement_in_rec.pm_agreement_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1407: THEN
1408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1409: THEN
1410: pa_interface_utils_pub.map_new_amg_msg
1406: OR (l_agreement_in_rec.pm_agreement_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1407: THEN
1408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1409: THEN
1410: pa_interface_utils_pub.map_new_amg_msg
1411: ( p_old_message_code => 'PA_AGMT_REF_IS_MISS'
1412: ,p_msg_attribute => 'CHANGE'
1413: ,p_resize_flag => 'N'
1414: ,p_msg_context => 'GENERAL'
1426:
1427: /* Commented the validations for non mandatory parameters for bug 6602451
1428: -- Customer Id
1429: IF (l_agreement_in_rec.customer_ID IS NULL)
1430: OR (l_agreement_in_rec.customer_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1431: THEN
1432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1433: THEN
1434: pa_interface_utils_pub.map_new_amg_msg
1430: OR (l_agreement_in_rec.customer_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1431: THEN
1432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1433: THEN
1434: pa_interface_utils_pub.map_new_amg_msg
1435: ( p_old_message_code => 'PA_CUST_ID_IS_MISS'
1436: ,p_msg_attribute => 'CHANGE'
1437: ,p_resize_flag => 'N'
1438: ,p_msg_context => 'AGREEMENT'
1448: END IF;
1449:
1450: -- Customer Number
1451: IF (l_agreement_in_rec.customer_num IS NULL)
1452: OR (l_agreement_in_rec.customer_num = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1453: THEN
1454: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1455: THEN
1456: pa_interface_utils_pub.map_new_amg_msg
1452: OR (l_agreement_in_rec.customer_num = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1453: THEN
1454: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1455: THEN
1456: pa_interface_utils_pub.map_new_amg_msg
1457: ( p_old_message_code => 'PA_CUST_NUM_IS_MISS'
1458: ,p_msg_attribute => 'CHANGE'
1459: ,p_resize_flag => 'N'
1460: ,p_msg_context => 'AGREEMENT'
1470: END IF;
1471:
1472: -- Agreement Type
1473: IF (l_agreement_in_rec.agreement_type IS NULL)
1474: OR (l_agreement_in_rec.agreement_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1475: THEN
1476: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1477: THEN
1478: pa_interface_utils_pub.map_new_amg_msg
1474: OR (l_agreement_in_rec.agreement_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1475: THEN
1476: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1477: THEN
1478: pa_interface_utils_pub.map_new_amg_msg
1479: ( p_old_message_code => 'PA_AGMT_TYPE_IS_MISS'
1480: ,p_msg_attribute => 'CHANGE'
1481: ,p_resize_flag => 'N'
1482: ,p_msg_context => 'AGREEMENT'
1492: END IF;
1493:
1494: -- Agreement Number
1495: IF (l_agreement_in_rec.agreement_num IS NULL)
1496: OR (l_agreement_in_rec.agreement_num = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1497: THEN
1498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1499: THEN
1500: pa_interface_utils_pub.map_new_amg_msg
1496: OR (l_agreement_in_rec.agreement_num = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1497: THEN
1498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1499: THEN
1500: pa_interface_utils_pub.map_new_amg_msg
1501: ( p_old_message_code => 'PA_AGMT_NUM_IS_MISS'
1502: ,p_msg_attribute => 'CHANGE'
1503: ,p_resize_flag => 'N'
1504: ,p_msg_context => 'AGREEMENT'
1526:
1527: /*Commented code for bug 7110396
1528: /* Start Bug 3511175 Initialized owning_organization_id,invoice_limit_flag
1529: and agreement_currency_code
1530: IF l_agreement_in_rec.owning_organization_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
1531: l_agreement_in_rec.owning_organization_id := NULL;
1532: END IF;
1533:
1534: IF l_agreement_in_rec.invoice_limit_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
1530: IF l_agreement_in_rec.owning_organization_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM Then
1531: l_agreement_in_rec.owning_organization_id := NULL;
1532: END IF;
1533:
1534: IF l_agreement_in_rec.invoice_limit_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
1535: l_agreement_in_rec.invoice_limit_flag := 'N';
1536: END IF;
1537:
1538: IF l_agreement_in_rec.agreement_currency_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
1534: IF l_agreement_in_rec.invoice_limit_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
1535: l_agreement_in_rec.invoice_limit_flag := 'N';
1536: END IF;
1537:
1538: IF l_agreement_in_rec.agreement_currency_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
1539: SELECT pa_currency.get_currency_code
1540: INTO l_agreement_in_rec.agreement_currency_code from dual;
1541: END IF;
1542:
1587: if (l_funding_in_rec.project_id is NULL
1588: or l_funding_in_rec.date_allocated is NULL
1589: or l_funding_in_rec.allocated_amount is NULL
1590: --or l_funding_in_rec.funding_category is NULL /* Commented for the bug 6780803 */
1591: or l_funding_in_rec.project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1592: or l_funding_in_rec.date_allocated = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1593: or l_funding_in_rec.allocated_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1594: --or l_funding_in_rec.funding_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) /* Commented for the bug 6780803 */
1595: then
1588: or l_funding_in_rec.date_allocated is NULL
1589: or l_funding_in_rec.allocated_amount is NULL
1590: --or l_funding_in_rec.funding_category is NULL /* Commented for the bug 6780803 */
1591: or l_funding_in_rec.project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1592: or l_funding_in_rec.date_allocated = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1593: or l_funding_in_rec.allocated_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1594: --or l_funding_in_rec.funding_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) /* Commented for the bug 6780803 */
1595: then
1596: --dbms_output.put_line('Funding not entered. ');
1589: or l_funding_in_rec.allocated_amount is NULL
1590: --or l_funding_in_rec.funding_category is NULL /* Commented for the bug 6780803 */
1591: or l_funding_in_rec.project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1592: or l_funding_in_rec.date_allocated = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1593: or l_funding_in_rec.allocated_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1594: --or l_funding_in_rec.funding_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) /* Commented for the bug 6780803 */
1595: then
1596: --dbms_output.put_line('Funding not entered. ');
1597: exit;
1590: --or l_funding_in_rec.funding_category is NULL /* Commented for the bug 6780803 */
1591: or l_funding_in_rec.project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1592: or l_funding_in_rec.date_allocated = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1593: or l_funding_in_rec.allocated_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1594: --or l_funding_in_rec.funding_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) /* Commented for the bug 6780803 */
1595: then
1596: --dbms_output.put_line('Funding not entered. ');
1597: exit;
1598: end if;
1605:
1606: /** Bug 2180350 - Replaced OR with AND in the following IF conmdition **/
1607:
1608: IF (l_agreement_in_rec.desc_flex_name IS NOT NULL)
1609: AND (l_agreement_in_rec.desc_flex_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1610: THEN
1611: pa_agreement_pvt.validate_flex_fields
1612: (p_desc_flex_name => l_agreement_in_rec.desc_flex_name
1613: ,p_attribute_category => l_agreement_in_rec.attribute_category
1642: IF l_validate_status = 'N'
1643: THEN
1644: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1645: THEN
1646: pa_interface_utils_pub.map_new_amg_msg
1647: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
1648: ,p_msg_attribute => 'CHANGE'
1649: ,p_resize_flag => 'N'
1650: ,p_msg_context => 'FLEX'
1731: if (l_funding_in_rec.project_id is NULL
1732: or l_funding_in_rec.date_allocated is NULL
1733: or l_funding_in_rec.allocated_amount is NULL
1734: --or l_funding_in_rec.funding_category is NULL /* Commented for the bug 6780803 */
1735: or l_funding_in_rec.project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1736: or l_funding_in_rec.date_allocated = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1737: or l_funding_in_rec.allocated_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1738: --or l_funding_in_rec.funding_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) /* Commented for the bug 6780803 */
1739: then
1732: or l_funding_in_rec.date_allocated is NULL
1733: or l_funding_in_rec.allocated_amount is NULL
1734: --or l_funding_in_rec.funding_category is NULL /* Commented for the bug 6780803 */
1735: or l_funding_in_rec.project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1736: or l_funding_in_rec.date_allocated = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1737: or l_funding_in_rec.allocated_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1738: --or l_funding_in_rec.funding_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) /* Commented for the bug 6780803 */
1739: then
1740: --dbms_output.put_line('Funding not entered. ');
1733: or l_funding_in_rec.allocated_amount is NULL
1734: --or l_funding_in_rec.funding_category is NULL /* Commented for the bug 6780803 */
1735: or l_funding_in_rec.project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1736: or l_funding_in_rec.date_allocated = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1737: or l_funding_in_rec.allocated_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1738: --or l_funding_in_rec.funding_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) /* Commented for the bug 6780803 */
1739: then
1740: --dbms_output.put_line('Funding not entered. ');
1741: exit;
1734: --or l_funding_in_rec.funding_category is NULL /* Commented for the bug 6780803 */
1735: or l_funding_in_rec.project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1736: or l_funding_in_rec.date_allocated = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1737: or l_funding_in_rec.allocated_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1738: --or l_funding_in_rec.funding_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) /* Commented for the bug 6780803 */
1739: then
1740: --dbms_output.put_line('Funding not entered. ');
1741: exit;
1742: end if;
1882: p_data => p_msg_data );
1883:
1884: WHEN NO_DATA_FOUND
1885: THEN
1886: pa_interface_utils_pub.map_new_amg_msg
1887: ( p_old_message_code => 'PA_NO_DATA_FOUND'
1888: ,p_msg_attribute => 'CHANGE'
1889: ,p_resize_flag => 'N'
1890: ,p_msg_context => 'GENERAL'
1934: --Description: This procedure can be used to create funding for an existing for an
1935: -- agreement.
1936: --
1937: --Called subprograms:
1938: -- pa_interface_utils_pub.map_new_amg_msg
1939: -- pa_agreement_pub.check_add_funding_ok
1940: -- pa_agreement_utils.validate_flex_fields
1941: -- pa_agreement_pvt.convert_fu_ref_to_id
1942: -- pa_agreement_utils.add_funding
2051: -- since the user does not have access to such functions
2052:
2053: -- This call is added for patchset K project role based security check
2054:
2055: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := p_pa_project_id;
2056:
2057:
2058: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
2059: (p_api_version_number => p_api_version_number,
2073: THEN
2074: RAISE FND_API.G_EXC_ERROR;
2075: END IF;
2076: IF l_function_allowed = 'N' THEN
2077: pa_interface_utils_pub.map_new_amg_msg
2078: ( p_old_message_code => 'PA_FUNC_SECURITY_ENFORCED'
2079: ,p_msg_attribute => 'CHANGE'
2080: ,p_resize_flag => 'Y'
2081: ,p_msg_context => 'GENERAL'
2105:
2106:
2107: -- Product Code
2108: IF (p_pm_product_code IS NULL)
2109: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2110: THEN
2111: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2112: THEN
2113: pa_interface_utils_pub.map_new_amg_msg
2109: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2110: THEN
2111: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2112: THEN
2113: pa_interface_utils_pub.map_new_amg_msg
2114: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISS'
2115: ,p_msg_attribute => 'CHANGE'
2116: ,p_resize_flag => 'N'
2117: ,p_msg_context => 'GENERAL'
2127:
2128: /* NOT REQUIRED
2129: -- Agreement Reference
2130: IF (p_pm_agreement_reference IS NULL)
2131: OR (p_pm_agreement_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2132: THEN
2133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2134: THEN
2135: pa_interface_utils_pub.map_new_amg_msg
2131: OR (p_pm_agreement_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2132: THEN
2133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2134: THEN
2135: pa_interface_utils_pub.map_new_amg_msg
2136: ( p_old_message_code => 'PA_AGMT_REF_IS_MISS'
2137: ,p_msg_attribute => 'CHANGE'
2138: ,p_resize_flag => 'N'
2139: ,p_msg_context => 'GENERAL'
2149:
2150:
2151: -- Project Reference
2152: IF (p_pm_project_reference IS NULL)
2153: OR (p_pm_project_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2154: THEN
2155: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2156: THEN
2157: pa_interface_utils_pub.map_new_amg_msg
2153: OR (p_pm_project_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2154: THEN
2155: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2156: THEN
2157: pa_interface_utils_pub.map_new_amg_msg
2158: ( p_old_message_code => 'PA_PROJ_REF_IS_MISS'
2159: ,p_msg_attribute => 'CHANGE'
2160: ,p_resize_flag => 'N'
2161: ,p_msg_context => 'GENERAL'
2174:
2175: -- Funding category
2176: /* Commented for 2483081 */
2177: /* IF (p_funding_category IS NULL)
2178: OR (p_funding_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2179: THEN
2180: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2181: THEN
2182: pa_interface_utils_pub.map_new_amg_msg
2178: OR (p_funding_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2179: THEN
2180: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2181: THEN
2182: pa_interface_utils_pub.map_new_amg_msg
2183: ( p_old_message_code => 'PA_FUND_CAT_IS_MISS'
2184: ,p_msg_attribute => 'CHANGE'
2185: ,p_resize_flag => 'N'
2186: ,p_msg_context => 'GENERAL'
2197:
2198: -- Validate funding category
2199: /* Added IF condition for bug 2838872 */
2200: IF (p_funding_category IS NULL)
2201: OR (p_funding_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2202: THEN
2203: l_funding_category := 'ADDITIONAL';
2204: ELSE
2205: l_funding_category := p_funding_category;
2220:
2221:
2222: -- Funding Reference
2223: IF (p_pm_funding_reference IS NULL)
2224: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2225: THEN
2226: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2227: THEN
2228: pa_interface_utils_pub.map_new_amg_msg
2224: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2225: THEN
2226: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2227: THEN
2228: pa_interface_utils_pub.map_new_amg_msg
2229: ( p_old_message_code => 'PA_FUND_REF_IS_MISS'
2230: ,p_msg_attribute => 'CHANGE'
2231: ,p_resize_flag => 'N'
2232: ,p_msg_context => 'GENERAL'
2241: END IF;
2242:
2243: -- Project Id
2244: IF (p_pa_project_id IS NULL)
2245: OR (p_pa_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2246: THEN
2247: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2248: THEN
2249: pa_interface_utils_pub.map_new_amg_msg
2245: OR (p_pa_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2246: THEN
2247: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2248: THEN
2249: pa_interface_utils_pub.map_new_amg_msg
2250: ( p_old_message_code => 'PA_PROJ_ID_IS_MISS'
2251: ,p_msg_attribute => 'CHANGE'
2252: ,p_resize_flag => 'N'
2253: ,p_msg_context => 'FUNDING'
2263:
2264: -- Task Id
2265: /*
2266: IF (p_pa_task_id IS NULL)
2267: OR (p_pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2268: THEN
2269: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2270: THEN
2271: pa_interface_utils_pub.map_new_amg_msg
2267: OR (p_pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2268: THEN
2269: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2270: THEN
2271: pa_interface_utils_pub.map_new_amg_msg
2272: ( p_old_message_code => 'PA_TASK_ID_IS_MISS'
2273: ,p_msg_attribute => 'CHANGE'
2274: ,p_resize_flag => 'N'
2275: ,p_msg_context => 'FUNDING'
2284: END IF;
2285: */
2286: -- Date Allocated
2287: IF (p_date_allocated IS NULL)
2288: OR (p_date_allocated = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
2289: THEN
2290: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2291: THEN
2292: pa_interface_utils_pub.map_new_amg_msg
2288: OR (p_date_allocated = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
2289: THEN
2290: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2291: THEN
2292: pa_interface_utils_pub.map_new_amg_msg
2293: ( p_old_message_code => 'PA_DATE_ALLOC_IS_MISS'
2294: ,p_msg_attribute => 'CHANGE'
2295: ,p_resize_flag => 'N'
2296: ,p_msg_context => 'FUNDING'
2305: END IF;
2306:
2307: -- Allocated Amount
2308: IF (p_allocated_amount IS NULL)
2309: OR (p_allocated_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2310: THEN
2311: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2312: THEN
2313: pa_interface_utils_pub.map_new_amg_msg
2309: OR (p_allocated_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2310: THEN
2311: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2312: THEN
2313: pa_interface_utils_pub.map_new_amg_msg
2314: ( p_old_message_code => 'PA_ALLOC_AMT_IS_MISS'
2315: ,p_msg_attribute => 'CHANGE'
2316: ,p_resize_flag => 'N'
2317: ,p_msg_context => 'FUNDING'
2328: END IF;
2329:
2330: -- Agreement Id
2331: IF (p_agreement_id IS NULL)
2332: OR (p_agreement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2333: THEN
2334: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2335: THEN
2336: pa_interface_utils_pub.map_new_amg_msg
2332: OR (p_agreement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2333: THEN
2334: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2335: THEN
2336: pa_interface_utils_pub.map_new_amg_msg
2337: ( p_old_message_code => 'PA_AGMT_ID_IS_MISS'
2338: ,p_msg_attribute => 'CHANGE'
2339: ,p_resize_flag => 'N'
2340: ,p_msg_context => 'FUNDING'
2377:
2378:
2379: -- Flex Field Validations
2380: IF (p_desc_flex_name IS NOT NULL)
2381: AND (p_desc_flex_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2382: -- OR (p_desc_flex_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2383: THEN
2384: pa_agreement_pvt.validate_flex_fields
2385: (p_desc_flex_name => p_desc_flex_name
2378:
2379: -- Flex Field Validations
2380: IF (p_desc_flex_name IS NOT NULL)
2381: AND (p_desc_flex_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2382: -- OR (p_desc_flex_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2383: THEN
2384: pa_agreement_pvt.validate_flex_fields
2385: (p_desc_flex_name => p_desc_flex_name
2386: ,p_attribute_category => p_attribute_category
2401: IF l_validate_status = 'N'
2402: THEN
2403: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2404: THEN
2405: pa_interface_utils_pub.map_new_amg_msg
2406: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
2407: ,p_msg_attribute => 'CHANGE'
2408: ,p_resize_flag => 'N'
2409: ,p_msg_context => 'FLEX'
2447: p_return_status := l_return_status;
2448: */
2449: --HERE
2450: --TO BE CORRECTED - BUDGET_TYPE_CODE - NIKHIL
2451: IF p_pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_pa_task_id IS NOT NULL THEN
2452: l_pa_task_id := p_pa_task_id;
2453: ELSIF p_pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM then
2454: l_pa_task_id := NULL;
2455: END IF;
2449: --HERE
2450: --TO BE CORRECTED - BUDGET_TYPE_CODE - NIKHIL
2451: IF p_pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_pa_task_id IS NOT NULL THEN
2452: l_pa_task_id := p_pa_task_id;
2453: ELSIF p_pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM then
2454: l_pa_task_id := NULL;
2455: END IF;
2456:
2457:
2456:
2457:
2458: /* 2315767 Added Else condition for all the Flex Field Attributes
2459: so that proper value is passed if corresponding p_attribute's are not NULL
2460: or not the default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR */
2461: IF p_desc_flex_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2462: l_desc_flex_name:= NULL;
2463: ELSE
2464: l_desc_flex_name := p_desc_flex_name;
2457:
2458: /* 2315767 Added Else condition for all the Flex Field Attributes
2459: so that proper value is passed if corresponding p_attribute's are not NULL
2460: or not the default PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR */
2461: IF p_desc_flex_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2462: l_desc_flex_name:= NULL;
2463: ELSE
2464: l_desc_flex_name := p_desc_flex_name;
2465: END IF;
2462: l_desc_flex_name:= NULL;
2463: ELSE
2464: l_desc_flex_name := p_desc_flex_name;
2465: END IF;
2466: IF p_attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2467: l_attribute_category := NULL;
2468: ELSE
2469: l_attribute_category := p_attribute_category;
2470: END IF;
2467: l_attribute_category := NULL;
2468: ELSE
2469: l_attribute_category := p_attribute_category;
2470: END IF;
2471: IF p_attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2472: l_attribute1 := NULL;
2473: ELSE
2474: l_attribute1 := p_attribute1;
2475: END IF;
2472: l_attribute1 := NULL;
2473: ELSE
2474: l_attribute1 := p_attribute1;
2475: END IF;
2476: IF p_attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2477: l_attribute2 := NULL;
2478: ELSE
2479: l_attribute2 := p_attribute2;
2480: END IF;
2477: l_attribute2 := NULL;
2478: ELSE
2479: l_attribute2 := p_attribute2;
2480: END IF;
2481: IF p_attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2482: l_attribute3 := NULL;
2483: ELSE
2484: l_attribute3 := p_attribute3;/* 2315767 Modified l_attribute4 to l_attribute3 */
2485: END IF;
2483: ELSE
2484: l_attribute3 := p_attribute3;/* 2315767 Modified l_attribute4 to l_attribute3 */
2485: END IF;
2486: /* 2315767 Added code for attribute4 of flexfield */
2487: IF p_attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2488: l_attribute4 := NULL;
2489: ELSE
2490: l_attribute4 := p_attribute4;
2491: END IF;
2488: l_attribute4 := NULL;
2489: ELSE
2490: l_attribute4 := p_attribute4;
2491: END IF;
2492: IF p_attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2493: l_attribute5 := NULL;
2494: ELSE
2495: l_attribute5 := p_attribute5;
2496: END IF;
2493: l_attribute5 := NULL;
2494: ELSE
2495: l_attribute5 := p_attribute5;
2496: END IF;
2497: IF p_attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2498: l_attribute6 := NULL;
2499: ELSE
2500: l_attribute6 := p_attribute6;
2501: END IF;
2498: l_attribute6 := NULL;
2499: ELSE
2500: l_attribute6 := p_attribute6;
2501: END IF;
2502: IF p_attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2503: l_attribute7 := NULL;
2504: ELSE
2505: l_attribute7 := p_attribute7;
2506: END IF;
2503: l_attribute7 := NULL;
2504: ELSE
2505: l_attribute7 := p_attribute7;
2506: END IF;
2507: IF p_attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2508: l_attribute8 := NULL;
2509: ELSE
2510: l_attribute8 := p_attribute8;
2511: END IF;
2508: l_attribute8 := NULL;
2509: ELSE
2510: l_attribute8 := p_attribute8;
2511: END IF;
2512: IF p_attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2513: l_attribute9 := NULL;
2514: ELSE
2515: l_attribute9 := p_attribute9;
2516: END IF;
2513: l_attribute9 := NULL;
2514: ELSE
2515: l_attribute9 := p_attribute9;
2516: END IF;
2517: IF p_attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2518: l_attribute10 := NULL;
2519: ELSE
2520: l_attribute10 := p_attribute10;
2521: END IF;
2521: END IF;
2522:
2523: /* Changes for bug 5554070-Start */
2524:
2525: IF p_project_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2526: l_project_rate_type := null;
2527: else
2528: l_project_rate_type :=p_project_rate_type;
2529: end if;
2527: else
2528: l_project_rate_type :=p_project_rate_type;
2529: end if;
2530:
2531: If p_projfunc_rate_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2532: l_projfunc_rate_type :=null;
2533: else
2534: l_projfunc_rate_type := p_projfunc_rate_type;
2535: end if;
2533: else
2534: l_projfunc_rate_type := p_projfunc_rate_type;
2535: end if;
2536:
2537: If p_projfunc_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
2538: l_projfunc_rate_date :=null;
2539: else
2540: l_projfunc_rate_date := p_projfunc_rate_date;
2541: end if;
2539: else
2540: l_projfunc_rate_date := p_projfunc_rate_date;
2541: end if;
2542:
2543: If p_project_rate_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
2544: l_project_rate_date :=null;
2545: else
2546: l_project_rate_date := p_project_rate_date;
2547: end if;
2608: /* End - Bug 2902096 */
2609:
2610: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2611: THEN
2612: pa_interface_utils_pub.map_new_amg_msg
2613: ( p_old_message_code => l_err_msg
2614: ,p_msg_attribute => 'CHANGE'
2615: /* ,p_resize_flag => 'N' changed for bug 2902096 */
2616: ,p_resize_flag => l_resize_flag
2681: --Description: This procedure can be used to delete funding for an existing for an
2682: -- agreement.
2683: --
2684: --Called subprograms:
2685: -- pa_interface_utils_pub.map_new_amg_msg
2686: -- pa_agreement_pub.check_delete_funding_ok
2687: -- pa_agreement_pvt.convert_fu_ref_to_id
2688: -- pa_agreement_utils.delete_agreement
2689: --
2758: -- Get the project id from this project funding line
2759: l_project_id := pa_agreement_utils.get_project_id(p_funding_id => p_funding_id,
2760: p_funding_reference => p_pm_funding_reference);
2761:
2762: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := l_project_id;
2763:
2764: -- End of the security changes
2765:
2766:
2788: THEN
2789: RAISE FND_API.G_EXC_ERROR;
2790: END IF;
2791: IF l_function_allowed = 'N' THEN
2792: pa_interface_utils_pub.map_new_amg_msg
2793: ( p_old_message_code => 'PA_FUNC_SECURITY_ENFORCED'
2794: ,p_msg_attribute => 'CHANGE'
2795: ,p_resize_flag => 'Y'
2796: ,p_msg_context => 'GENERAL'
2819: -- CHECK WHETHER MANDATORY INCOMING PARAMETERS EXIST
2820:
2821: -- Product Code
2822: IF (p_pm_product_code IS NULL)
2823: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2824: THEN
2825: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2826: THEN
2827: pa_interface_utils_pub.map_new_amg_msg
2823: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2824: THEN
2825: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2826: THEN
2827: pa_interface_utils_pub.map_new_amg_msg
2828: ( p_old_message_code => 'PA_CUST_NUM_IS_MISS'
2829: ,p_msg_attribute => 'CHANGE'
2830: ,p_resize_flag => 'N'
2831: ,p_msg_context => 'GENERAL'
2840: END IF;
2841:
2842: -- Funding Reference
2843: IF (p_pm_funding_reference IS NULL)
2844: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2845: THEN
2846: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2847: THEN
2848: pa_interface_utils_pub.map_new_amg_msg
2844: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2845: THEN
2846: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2847: THEN
2848: pa_interface_utils_pub.map_new_amg_msg
2849: ( p_old_message_code => 'PA_FUND_REF_IS_MISS'
2850: ,p_msg_attribute => 'CHANGE'
2851: ,p_resize_flag => 'N'
2852: ,p_msg_context => 'GENERAL'
2862:
2863: /* NOT REQUIRED
2864: -- Funding Id
2865: IF (p_funding_id IS NULL)
2866: OR (p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2867: THEN
2868: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2869: THEN
2870: pa_interface_utils_pub.map_new_amg_msg
2866: OR (p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2867: THEN
2868: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2869: THEN
2870: pa_interface_utils_pub.map_new_amg_msg
2871: ( p_old_message_code => 'PA_FUND_ID_IS_MISS'
2872: ,p_msg_attribute => 'CHANGE'
2873: ,p_resize_flag => 'N'
2874: ,p_msg_context => 'FUNDING'
2892: close c1;
2893:
2894: IF l_funding_category = 'REVALUATION'
2895: THEN
2896: pa_interface_utils_pub.map_new_amg_msg
2897: ( p_old_message_code => 'PA_UPDATE_DELETE_REVAL'
2898: ,p_msg_attribute => 'CHANGE'
2899: ,p_resize_flag => 'N'
2900: ,p_msg_context => 'GENERAL'
3118: l_resp_id := FND_GLOBAL.Resp_id;
3119:
3120: -- This call is added for patchset K project role based security check
3121:
3122: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := p_project_id;
3123:
3124:
3125: -- Actions performed using the APIs would be subject to
3126: -- function security. If the responsibility does not allow
3146: THEN
3147: RAISE FND_API.G_EXC_ERROR;
3148: END IF;
3149: IF l_function_allowed = 'N' THEN
3150: pa_interface_utils_pub.map_new_amg_msg
3151: ( p_old_message_code => 'PA_FUNC_SECURITY_ENFORCED'
3152: ,p_msg_attribute => 'CHANGE'
3153: ,p_resize_flag => 'Y'
3154: ,p_msg_context => 'GENERAL'
3176: -- CHECK WHETHER MANDATORY INCOMING PARAMETERS EXIST
3177:
3178: -- Product Code
3179: IF (p_pm_product_code IS NULL)
3180: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3181: THEN
3182: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3183: THEN
3184: pa_interface_utils_pub.map_new_amg_msg
3180: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3181: THEN
3182: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3183: THEN
3184: pa_interface_utils_pub.map_new_amg_msg
3185: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISS'
3186: ,p_msg_attribute => 'CHANGE'
3187: ,p_resize_flag => 'N'
3188: ,p_msg_context => 'GENERAL'
3198:
3199: /* Bug 5686790. If Miss char is passed then this check is not required, as
3200: customer doesn't want to change the funding category*/
3201:
3202: IF (p_funding_category <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3203: -- Code added for Bug 2403652 starts here
3204:
3205: -- Funding category is NULL
3206: /* Added IF condition for bug 2838872 */
3204:
3205: -- Funding category is NULL
3206: /* Added IF condition for bug 2838872 */
3207: IF (p_funding_category IS NULL)
3208: /*OR (p_funding_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3209: Bug 5686790 */
3210: THEN
3211: l_funding_category := 'ADDITIONAL';
3212: ELSE
3212: ELSE
3213: l_funding_category := p_funding_category;
3214: /***** IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3215: THEN
3216: pa_interface_utils_pub.map_new_amg_msg
3217: ( p_old_message_code => 'PA_FUND_CAT_IS_MISS'
3218: ,p_msg_attribute => 'CHANGE'
3219: ,p_resize_flag => 'N'
3220: ,p_msg_context => 'GENERAL'
3247:
3248:
3249: -- Funding Reference
3250: IF (p_pm_funding_reference IS NULL)
3251: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3252: THEN
3253: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3254: THEN
3255: pa_interface_utils_pub.map_new_amg_msg
3251: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3252: THEN
3253: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3254: THEN
3255: pa_interface_utils_pub.map_new_amg_msg
3256: ( p_old_message_code => 'PA_FUND_REF_IS_MISS'
3257: ,p_msg_attribute => 'CHANGE'
3258: ,p_resize_flag => 'N'
3259: ,p_msg_context => 'GENERAL'
3268: END IF;
3269: /* NOT REQUIED
3270: -- Funding Id
3271: IF (p_funding_id IS NULL)
3272: OR (p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
3273: THEN
3274: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3275: THEN
3276: pa_interface_utils_pub.map_new_amg_msg
3272: OR (p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
3273: THEN
3274: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3275: THEN
3276: pa_interface_utils_pub.map_new_amg_msg
3277: ( p_old_message_code => 'PA_FUND_ID_IS_MISS'
3278: ,p_msg_attribute => 'CHANGE'
3279: ,p_resize_flag => 'N'
3280: ,p_msg_context => 'FUNDING'
3300:
3301:
3302: IF l_funding_category = 'REVALUATION'
3303: THEN
3304: pa_interface_utils_pub.map_new_amg_msg
3305: ( p_old_message_code => 'PA_UPDATE_DELETE_REVAL'
3306: ,p_msg_attribute => 'CHANGE'
3307: ,p_resize_flag => 'N'
3308: ,p_msg_context => 'GENERAL'
3356:
3357:
3358: -- Flex Field Validations
3359: IF (p_desc_flex_name IS NOT NULL)
3360: AND (p_desc_flex_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3361: -- Nikhil OR (p_desc_flex_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3362: THEN
3363: pa_agreement_pvt.validate_flex_fields
3364: (p_desc_flex_name => p_desc_flex_name
3357:
3358: -- Flex Field Validations
3359: IF (p_desc_flex_name IS NOT NULL)
3360: AND (p_desc_flex_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3361: -- Nikhil OR (p_desc_flex_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3362: THEN
3363: pa_agreement_pvt.validate_flex_fields
3364: (p_desc_flex_name => p_desc_flex_name
3365: ,p_attribute_category => p_attribute_category
3380: IF l_validate_status = 'N'
3381: THEN
3382: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3383: THEN
3384: pa_interface_utils_pub.map_new_amg_msg
3385: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
3386: ,p_msg_attribute => 'CHANGE'
3387: ,p_resize_flag => 'N'
3388: ,p_msg_context => 'FLEX'
3418: ***** Commented bug 2434153 **/
3419:
3420: /* Added for bug 5686790*/
3421:
3422: IF (p_funding_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3423: SELECT funding_category
3424: INTO l_funding_category
3425: FROM pa_project_fundings
3426: WHERE PROJECT_FUNDING_ID = l_out_funding_id;
3483: /* End - Bug 2902096 */
3484:
3485: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3486: THEN
3487: pa_interface_utils_pub.map_new_amg_msg
3488: ( p_old_message_code => l_err_msg
3489: ,p_msg_attribute => 'CHANGE'
3490: /* ,p_resize_flag => 'N' changed for bug 2902096 */
3491: ,p_resize_flag => l_resize_flag
3713: THEN
3714: RAISE FND_API.G_EXC_ERROR;
3715: END IF;
3716: IF l_function_allowed = 'N' THEN
3717: pa_interface_utils_pub.map_new_amg_msg
3718: ( p_old_message_code => 'PA_FUNC_SECURITY_ENFORCED'
3719: ,p_msg_attribute => 'CHANGE'
3720: ,p_resize_flag => 'Y'
3721: ,p_msg_context => 'GENERAL'
3922: THEN
3923: RAISE FND_API.G_EXC_ERROR;
3924: END IF;
3925: IF l_function_allowed = 'N' THEN
3926: pa_interface_utils_pub.map_new_amg_msg
3927: ( p_old_message_code => 'PA_FUNC_SECURITY_ENFORCED'
3928: ,p_msg_attribute => 'CHANGE'
3929: ,p_resize_flag => 'Y'
3930: ,p_msg_context => 'GENERAL'
4084: THEN
4085: RAISE FND_API.G_EXC_ERROR;
4086: END IF;
4087: IF l_function_allowed = 'N' THEN
4088: pa_interface_utils_pub.map_new_amg_msg
4089: ( p_old_message_code => 'PA_FUNC_SECURITY_ENFORCED'
4090: ,p_msg_attribute => 'CHANGE'
4091: ,p_resize_flag => 'Y'
4092: ,p_msg_context => 'GENERAL'
4135: RAISE FND_API.G_EXC_ERROR;
4136: END IF;
4137:
4138: -- ASSIGN OUTGOING VALUES TO OUTGOING PARAMETERS
4139: IF G_agreement_out_rec.agreement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4140: THEN
4141: p_agreement_id_out := NULL;
4142: ELSE
4143: p_agreement_id_out := G_agreement_out_rec.agreement_id;
4142: ELSE
4143: p_agreement_id_out := G_agreement_out_rec.agreement_id;
4144: END IF;
4145:
4146: IF G_agreement_out_rec.customer_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4147: THEN
4148: p_customer_id_out := NULL;
4149: ELSE
4150: p_customer_id_out := G_agreement_out_rec.customer_id;
4267: THEN
4268: RAISE FND_API.G_EXC_ERROR;
4269: END IF;
4270: IF l_function_allowed = 'N' THEN
4271: pa_interface_utils_pub.map_new_amg_msg
4272: ( p_old_message_code => 'PA_FUNC_SECURITY_ENFORCED'
4273: ,p_msg_attribute => 'CHANGE'
4274: ,p_resize_flag => 'Y'
4275: ,p_msg_context => 'GENERAL'
4435: THEN
4436: RAISE FND_API.G_EXC_ERROR;
4437: END IF;
4438: IF l_function_allowed = 'N' THEN
4439: pa_interface_utils_pub.map_new_amg_msg
4440: ( p_old_message_code => 'PA_FUNC_SECURITY_ENFORCED'
4441: ,p_msg_attribute => 'CHANGE'
4442: ,p_resize_flag => 'Y'
4443: ,p_msg_context => 'GENERAL'
4463:
4464: p_return_status := FND_API.G_RET_STS_SUCCESS;
4465:
4466: -- Check Funding index value, when they don't provide an index we will error out
4467: IF p_funding_index = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4468: OR p_funding_index IS NULL
4469: THEN
4470: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4471: THEN
4468: OR p_funding_index IS NULL
4469: THEN
4470: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4471: THEN
4472: pa_interface_utils_pub.map_new_amg_msg
4473: ( p_old_message_code => 'PA_FUND_INDEX_NOT_PROV'
4474: ,p_msg_attribute => 'CHANGE'
4475: ,p_resize_flag => 'N'
4476: ,p_msg_context => 'GENERAL'
4488: IF G_funding_out_tbl.exists(l_index)
4489: THEN
4490: -- assign global table fields to the outgoing parameter
4491: -- we don't want to return the big number G_PA_MISS_NUM
4492: IF G_funding_out_tbl(l_index).project_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4493: THEN
4494: p_funding_id := NULL;
4495: ELSE
4496: p_funding_id := G_funding_out_tbl(l_index).project_funding_id;
4637: THEN
4638: RAISE FND_API.G_EXC_ERROR;
4639: END IF;
4640: IF l_function_allowed = 'N' THEN
4641: pa_interface_utils_pub.map_new_amg_msg
4642: ( p_old_message_code => 'PA_FUNC_SECURITY_ENFORCED'
4643: ,p_msg_attribute => 'CHANGE'
4644: ,p_resize_flag => 'Y'
4645: ,p_msg_context => 'GENERAL'
4669: -- CHECK WHETHER MANDATORY INCOMING PARAMETERS EXIST
4670:
4671: -- Agreement Reference
4672: IF (p_pm_agreement_reference IS NULL)
4673: OR (p_pm_agreement_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
4674: THEN
4675: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4676: THEN
4677: pa_interface_utils_pub.map_new_amg_msg
4673: OR (p_pm_agreement_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
4674: THEN
4675: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4676: THEN
4677: pa_interface_utils_pub.map_new_amg_msg
4678: ( p_old_message_code => 'PA_AGMT_REF_IS_MISS'
4679: ,p_msg_attribute => 'CHANGE'
4680: ,p_resize_flag => 'N'
4681: ,p_msg_context => 'GENERAL'
4690: END IF;
4691: /* NOT REQUIRED
4692: -- Agreement Id
4693: IF (p_agreement_id IS NULL)
4694: OR (p_agreement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
4695: THEN
4696: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4697: THEN
4698: pa_interface_utils_pub.map_new_amg_msg
4694: OR (p_agreement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
4695: THEN
4696: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4697: THEN
4698: pa_interface_utils_pub.map_new_amg_msg
4699: ( p_old_message_code => 'PA_AGMT_ID_IS_MISS'
4700: ,p_msg_attribute => 'CHANGE'
4701: ,p_resize_flag => 'N'
4702: ,p_msg_context => 'AGREEMENT'
4717: IF pa_agreement_utils.check_valid_agreement_ref(p_agreement_reference => p_pm_agreement_reference) = 'N'
4718: THEN
4719: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4720: THEN
4721: pa_interface_utils_pub.map_new_amg_msg
4722: ( p_old_message_code => 'PA_INVD_AGMT_REF'
4723: ,p_msg_attribute => 'CHANGE'
4724: ,p_resize_flag => 'N'
4725: ,p_msg_context => 'GENERAL'
4738: IF pa_agreement_utils.check_valid_agreement_id(p_agreement_id => p_agreement_id) = 'N'
4739: THEN
4740: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4741: THEN
4742: pa_interface_utils_pub.map_new_amg_msg
4743: ( p_old_message_code => 'PA_INVD_AGMT_ID'
4744: ,p_msg_attribute => 'CHANGE'
4745: ,p_resize_flag => 'N'
4746: ,p_msg_context => 'AGREEMENT'
4888: l_resp_id := FND_GLOBAL.Resp_id;
4889:
4890: -- This call is added for patchset K project role based security check
4891:
4892: PA_INTERFACE_UTILS_PUB.G_PROJECt_ID := p_project_id;
4893:
4894:
4895:
4896: -- Actions performed using the APIs would be subject to
4917: THEN
4918: RAISE FND_API.G_EXC_ERROR;
4919: END IF;
4920: IF l_function_allowed = 'N' THEN
4921: pa_interface_utils_pub.map_new_amg_msg
4922: ( p_old_message_code => 'PA_FUNC_SECURITY_ENFORCED'
4923: ,p_msg_attribute => 'CHANGE'
4924: ,p_resize_flag => 'Y'
4925: ,p_msg_context => 'GENERAL'
4948: -- CHECK WHETHER MANDATORY INCOMING PARAMETERS EXIST
4949:
4950: -- Agreement Reference
4951: IF (p_pm_agreement_reference IS NULL)
4952: OR (p_pm_agreement_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
4953: THEN
4954: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4955: THEN
4956: pa_interface_utils_pub.map_new_amg_msg
4952: OR (p_pm_agreement_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
4953: THEN
4954: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4955: THEN
4956: pa_interface_utils_pub.map_new_amg_msg
4957: ( p_old_message_code => 'PA_AGMT_REF_IS_MISS'
4958: ,p_msg_attribute => 'CHANGE'
4959: ,p_resize_flag => 'N'
4960: ,p_msg_context => 'GENERAL'
4969: END IF;
4970:
4971: -- Project Id
4972: IF (p_project_id IS NULL)
4973: OR (p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
4974: THEN
4975: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4976: THEN
4977: pa_interface_utils_pub.map_new_amg_msg
4973: OR (p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
4974: THEN
4975: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4976: THEN
4977: pa_interface_utils_pub.map_new_amg_msg
4978: ( p_old_message_code => 'PA_PROJ_ID_IS_MISS'
4979: ,p_msg_attribute => 'CHANGE'
4980: ,p_resize_flag => 'N'
4981: ,p_msg_context => 'FUNDING'
4990: END IF;
4991: /*
4992: -- Task Id
4993: IF (p_task_id IS NULL)
4994: OR (p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
4995: THEN
4996: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4997: THEN
4998: pa_interface_utils_pub.map_new_amg_msg
4994: OR (p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
4995: THEN
4996: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4997: THEN
4998: pa_interface_utils_pub.map_new_amg_msg
4999: ( p_old_message_code => 'PA_TASK_ID_IS_MISS'
5000: ,p_msg_attribute => 'CHANGE'
5001: ,p_resize_flag => 'N'
5002: ,p_msg_context => 'FUNDING'
5011: END IF;
5012: */
5013: -- Funding Reference
5014: IF (p_pm_funding_reference IS NULL)
5015: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
5016: THEN
5017: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5018: THEN
5019: pa_interface_utils_pub.map_new_amg_msg
5015: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
5016: THEN
5017: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5018: THEN
5019: pa_interface_utils_pub.map_new_amg_msg
5020: ( p_old_message_code => 'PA_FUND_REF_IS_MISS'
5021: ,p_msg_attribute => 'CHANGE'
5022: ,p_resize_flag => 'N'
5023: ,p_msg_context => 'GENERAL'
5033:
5034: /* NOT REQUIRED
5035: -- Funding Id
5036: IF (p_funding_id IS NULL)
5037: OR (p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
5038: THEN
5039: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5040: THEN
5041: pa_interface_utils_pub.map_new_amg_msg
5037: OR (p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
5038: THEN
5039: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5040: THEN
5041: pa_interface_utils_pub.map_new_amg_msg
5042: ( p_old_message_code => 'PA_FUND_ID_IS_MISS'
5043: ,p_msg_attribute => 'CHANGE'
5044: ,p_resize_flag => 'N'
5045: ,p_msg_context => 'GENERAL'
5061: IF pa_agreement_utils.check_valid_agreement_ref(p_agreement_reference => p_pm_agreement_reference) = 'N'
5062: THEN
5063: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5064: THEN
5065: pa_interface_utils_pub.map_new_amg_msg
5066: ( p_old_message_code => 'PA_INVD_AGMT_REF'
5067: ,p_msg_attribute => 'CHANGE'
5068: ,p_resize_flag => 'Y'
5069: ,p_msg_context => 'AGREEMENT'
5082: ,p_agreement_id => p_agreement_id) = 'N'
5083: THEN
5084: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5085: THEN
5086: pa_interface_utils_pub.map_new_amg_msg
5087: ( p_old_message_code => 'PA_INVD_FUND_REF'
5088: ,p_msg_attribute => 'CHANGE'
5089: ,p_resize_flag => 'N'
5090: ,p_msg_context => 'FUNDING'
5245: p_funding_reference => p_pm_funding_reference);
5246:
5247: -- This call is added for patchset K project role based security check
5248:
5249: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := l_project_id;
5250:
5251: -- Actions performed using the APIs would be subject to
5252: -- function security. If the responsibility does not allow
5253: -- such functions to be executed, the API should not proceed further
5272: THEN
5273: RAISE FND_API.G_EXC_ERROR;
5274: END IF;
5275: IF l_function_allowed = 'N' THEN
5276: pa_interface_utils_pub.map_new_amg_msg
5277: ( p_old_message_code => 'PA_FUNC_SECURITY_ENFORCED'
5278: ,p_msg_attribute => 'CHANGE'
5279: ,p_resize_flag => 'Y'
5280: ,p_msg_context => 'GENERAL'
5303: -- CHECK WHETHER MANDATORY INCOMING PARAMETERS EXIST
5304:
5305: -- Funding Reference
5306: IF (p_pm_funding_reference IS NULL)
5307: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
5308: THEN
5309: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5310: THEN
5311: pa_interface_utils_pub.map_new_amg_msg
5307: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
5308: THEN
5309: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5310: THEN
5311: pa_interface_utils_pub.map_new_amg_msg
5312: ( p_old_message_code => 'PA_FUND_REF_IS_MISS'
5313: ,p_msg_attribute => 'CHANGE'
5314: ,p_resize_flag => 'N'
5315: ,p_msg_context => 'GENERAL'
5324: END IF;
5325: /* NOT REQUIRED
5326: -- Funding Id
5327: IF (p_funding_id IS NULL)
5328: OR (p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
5329: THEN
5330: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5331: THEN
5332: pa_interface_utils_pub.map_new_amg_msg
5328: OR (p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
5329: THEN
5330: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5331: THEN
5332: pa_interface_utils_pub.map_new_amg_msg
5333: ( p_old_message_code => 'PA_FUND_ID_IS_MISS'
5334: ,p_msg_attribute => 'CHANGE'
5335: ,p_resize_flag => 'N'
5336: ,p_msg_context => 'GENERAL'
5354: ,p_funding_reference => p_pm_funding_reference)) = 'N'
5355: THEN
5356: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5357: THEN
5358: pa_interface_utils_pub.map_new_amg_msg
5359: ( p_old_message_code => 'PA_INVD_FUND_REF'
5360: ,p_msg_attribute => 'CHANGE'
5361: ,p_resize_flag => 'N'
5362: ,p_msg_context => 'AGREEMENT'
5376: ,p_funding_id => pa_agreement_utils.get_funding_id(p_funding_reference => p_pm_funding_reference)) = 'N'
5377: THEN
5378: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5379: THEN
5380: pa_interface_utils_pub.map_new_amg_msg
5381: ( p_old_message_code => 'PA_INVD_FUND_ID'
5382: ,p_msg_attribute => 'CHANGE'
5383: ,p_resize_flag => 'N'
5384: ,p_msg_context => 'FUNDING'
5526: l_resp_id := FND_GLOBAL.Resp_id;
5527:
5528: -- This call is added for patchset K project role based security check
5529:
5530: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := p_project_id;
5531:
5532:
5533: -- Actions performed using the APIs would be subject to
5534: -- function security. If the responsibility does not allow
5554: THEN
5555: RAISE FND_API.G_EXC_ERROR;
5556: END IF;
5557: IF l_function_allowed = 'N' THEN
5558: pa_interface_utils_pub.map_new_amg_msg
5559: ( p_old_message_code => 'PA_FUNC_SECURITY_ENFORCED'
5560: ,p_msg_attribute => 'CHANGE'
5561: ,p_resize_flag => 'Y'
5562: ,p_msg_context => 'GENERAL'
5585: -- CHECK WHETHER MANDATORY INCOMING PARAMETERS EXIST
5586:
5587: -- Funding Reference
5588: IF (p_pm_funding_reference IS NULL)
5589: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
5590: THEN
5591: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5592: THEN
5593: pa_interface_utils_pub.map_new_amg_msg
5589: OR (p_pm_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
5590: THEN
5591: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5592: THEN
5593: pa_interface_utils_pub.map_new_amg_msg
5594: ( p_old_message_code => 'PA_FUND_REF_IS_MISS'
5595: ,p_msg_attribute => 'CHANGE'
5596: ,p_resize_flag => 'N'
5597: ,p_msg_context => 'GENERAL'
5606: END IF;
5607:
5608: -- Funding Id
5609: IF (p_funding_id IS NULL)
5610: OR (p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
5611: THEN
5612: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5613: THEN
5614: pa_interface_utils_pub.map_new_amg_msg
5610: OR (p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
5611: THEN
5612: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5613: THEN
5614: pa_interface_utils_pub.map_new_amg_msg
5615: ( p_old_message_code => 'PA_FUND_ID_IS_MISS'
5616: ,p_msg_attribute => 'CHANGE'
5617: ,p_resize_flag => 'N'
5618: ,p_msg_context => 'GENERAL'
5633: ,p_agreement_id => p_agreement_id) = 'N'
5634: THEN
5635: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5636: THEN
5637: pa_interface_utils_pub.map_new_amg_msg
5638: ( p_old_message_code => 'PA_INVD_FUND_REF'
5639: ,p_msg_attribute => 'CHANGE'
5640: ,p_resize_flag => 'Y'
5641: ,p_msg_context => 'AGREEMENT'
5654: (p_agreement_id => p_agreement_id) = 'N'
5655: THEN
5656: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5657: THEN
5658: pa_interface_utils_pub.map_new_amg_msg
5659: ( p_old_message_code => 'PA_INVALID_FUNDING_ID'
5660: ,p_msg_attribute => 'CHANGE'
5661: ,p_resize_flag => 'Y'
5662: ,p_msg_context => 'AGREEMENT'
5691: IF l_validate_status = 'N'
5692: THEN
5693: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5694: THEN
5695: pa_interface_utils_pub.map_new_amg_msg
5696: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
5697: ,p_msg_attribute => 'CHANGE'
5698: ,p_resize_flag => 'N'
5699: ,p_msg_context => 'FLEX'
5773: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
5774: ,p_msg_count OUT NOCOPY NUMBER /*File.sql.39*/
5775: ,p_msg_data OUT NOCOPY VARCHAR2 /*File.sql.39*/
5776: ,p_return_status OUT NOCOPY VARCHAR2 /*File.sql.39*/
5777: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5778: ,p_pm_budget_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5779: -- ,p_budget_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5780: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5781: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5774: ,p_msg_count OUT NOCOPY NUMBER /*File.sql.39*/
5775: ,p_msg_data OUT NOCOPY VARCHAR2 /*File.sql.39*/
5776: ,p_return_status OUT NOCOPY VARCHAR2 /*File.sql.39*/
5777: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5778: ,p_pm_budget_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5779: -- ,p_budget_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5780: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5781: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5782: -- ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Always "AR"
5775: ,p_msg_data OUT NOCOPY VARCHAR2 /*File.sql.39*/
5776: ,p_return_status OUT NOCOPY VARCHAR2 /*File.sql.39*/
5777: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5778: ,p_pm_budget_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5779: -- ,p_budget_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5780: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5781: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5782: -- ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Always "AR"
5783: ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5776: ,p_return_status OUT NOCOPY VARCHAR2 /*File.sql.39*/
5777: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5778: ,p_pm_budget_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5779: -- ,p_budget_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5780: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5781: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5782: -- ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Always "AR"
5783: ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5784: -- ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5777: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5778: ,p_pm_budget_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5779: -- ,p_budget_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5780: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5781: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5782: -- ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Always "AR"
5783: ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5784: -- ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5785: -- ,p_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5778: ,p_pm_budget_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5779: -- ,p_budget_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5780: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5781: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5782: -- ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Always "AR"
5783: ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5784: -- ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5785: -- ,p_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5786: -- ,p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5779: -- ,p_budget_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5780: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5781: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5782: -- ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Always "AR"
5783: ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5784: -- ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5785: -- ,p_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5786: -- ,p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5787: -- ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5780: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5781: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5782: -- ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Always "AR"
5783: ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5784: -- ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5785: -- ,p_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5786: -- ,p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5787: -- ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5788: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5781: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5782: -- ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Always "AR"
5783: ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5784: -- ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5785: -- ,p_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5786: -- ,p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5787: -- ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5788: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5789: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5782: -- ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Always "AR"
5783: ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5784: -- ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5785: -- ,p_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5786: -- ,p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5787: -- ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5788: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5789: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5790: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5783: ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5784: -- ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5785: -- ,p_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5786: -- ,p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5787: -- ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5788: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5789: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5790: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5791: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5784: -- ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5785: -- ,p_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5786: -- ,p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5787: -- ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5788: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5789: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5790: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5791: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5792: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5785: -- ,p_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5786: -- ,p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5787: -- ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5788: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5789: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5790: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5791: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5792: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5793: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5786: -- ,p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5787: -- ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5788: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5789: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5790: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5791: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5792: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5793: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5794: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5787: -- ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5788: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5789: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5790: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5791: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5792: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5793: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5794: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5795: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5788: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5789: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5790: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5791: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5792: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5793: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5794: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5795: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5796: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5789: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5790: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5791: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5792: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5793: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5794: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5795: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5796: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5797: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5790: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5791: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5792: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5793: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5794: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5795: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5796: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5797: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5798: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5791: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5792: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5793: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5794: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5795: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5796: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5797: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5798: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5799: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5792: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5793: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5794: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5795: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5796: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5797: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5798: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5799: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5800: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5793: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5794: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5795: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5796: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5797: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5798: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5799: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5800: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5801: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5794: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5795: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5796: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5797: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5798: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5799: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5800: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5801: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5802: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5795: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5796: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5797: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5798: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5799: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5800: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5801: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5802: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5803: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5796: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5797: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5798: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5799: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5800: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5801: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5802: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5803: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5804: )
5797: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5798: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5799: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5800: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5801: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5802: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5803: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5804: )
5805: IS
5798: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5799: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5800: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5801: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5802: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5803: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5804: )
5805: IS
5806: CURSOR res_info IS
5799: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5800: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5801: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5802: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5803: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5804: )
5805: IS
5806: CURSOR res_info IS
5807: SELECT R1.resource_list_id resource_list_id,
5969: p_return_status := FND_API.G_RET_STS_ERROR;
5970:
5971: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5972: THEN
5973: pa_interface_utils_pub.map_new_amg_msg
5974: ( p_old_message_code => 'PA_INVALID_PROJECT'
5975: ,p_msg_attribute => 'CHANGE'
5976: ,p_resize_flag => 'N'
5977: ,p_msg_context => 'CONTRACT'
5996: IF (proj_dates_rec.completion_date is null or proj_dates_rec.start_date is null) then
5997: -- Set API return status to success
5998: P_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
5999:
6000: pa_interface_utils_pub.map_new_amg_msg
6001: ( p_old_message_code => 'PA_BU_NO_PROJ_END_DATE'
6002: ,p_msg_attribute => 'CHANGE'
6003: ,p_resize_flag => 'N'
6004: ,p_msg_context => 'BUDG'
6015:
6016:
6017: P_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
6018:
6019: pa_interface_utils_pub.map_new_amg_msg
6020: ( p_old_message_code => 'PA_NO_BASELINE_FUNDING'
6021: ,p_msg_attribute => 'CHANGE'
6022: ,p_resize_flag => 'N'
6023: ,p_msg_context => 'BUDG'
6040: x_err_stage => l_err_stage,
6041: x_err_stack => l_err_stack);
6042:
6043: IF l_err_code <> 0 then
6044: pa_interface_utils_pub.map_new_amg_msg
6045: ( p_old_message_code => l_err_code
6046: ,p_msg_attribute => 'CHANGE'
6047: ,p_resize_flag => 'N'
6048: ,p_msg_context => 'BUDG'