eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_AGREEMENT_PVT dependencies on PA_INTERFACE_UTILS_PUB

Line 23: -- pa_interface_utils_pub.map_new_amg_msg

19: -- to an agreement id.
20: --
21: --Called subprograms:
22: -- pa_agreement_pvt.fetch_agreement_id
23: -- pa_interface_utils_pub.map_new_amg_msg
24: --
25: --
26: --History:
27: -- 25-MAR-2000 Rakesh Raghavan Created.

Line 31: (p_pm_agreement_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

27: -- 25-MAR-2000 Rakesh Raghavan Created.
28: -- -----------------------------------------------------------------------------
29:
30: PROCEDURE convert_ag_ref_to_id
31: (p_pm_agreement_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
32: ,p_af_agreement_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
33: ,p_out_agreement_id OUT NOCOPY NUMBER /*file.sql.39*/
34: ,p_RETURN_status OUT NOCOPY VARCHAR2 /*file.sql.39*/)
35: IS

Line 32: ,p_af_agreement_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

28: -- -----------------------------------------------------------------------------
29:
30: PROCEDURE convert_ag_ref_to_id
31: (p_pm_agreement_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
32: ,p_af_agreement_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
33: ,p_out_agreement_id OUT NOCOPY NUMBER /*file.sql.39*/
34: ,p_RETURN_status OUT NOCOPY VARCHAR2 /*file.sql.39*/)
35: IS
36: CURSOR l_agreement_id_csr

Line 51: IF p_af_agreement_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

47: --dbms_output.put_line(' Inside the pvt ag_ref_to_id');
48: p_return_status := FND_API.G_RET_STS_SUCCESS;
49:
50:
51: IF p_af_agreement_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
52: AND p_af_agreement_id IS NOT NULL
53: THEN
54:
55: --check validity of this ID

Line 63: pa_interface_utils_pub.map_new_amg_msg

59: IF l_agreement_id_csr%NOTFOUND
60: THEN
61: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
62: THEN
63: pa_interface_utils_pub.map_new_amg_msg
64: ( p_old_message_code => 'PA_INVALID_AGMT_ID'
65: ,p_msg_attribute => 'CHANGE'
66: ,p_resize_flag => 'N'
67: ,p_msg_context => 'GENERAL'

Line 79: ELSIF p_pm_agreement_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

75: RAISE FND_API.G_EXC_ERROR;
76: END IF;
77: CLOSE l_agreement_id_csr;
78: p_out_agreement_id := p_af_agreement_id;
79: ELSIF p_pm_agreement_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
80: AND p_pm_agreement_reference IS NOT NULL
81: THEN
82: --dbms_output.put_line('Calling fetch agreement id');
83: l_agreement_id := pa_agreement_pvt.fetch_agreement_id(p_pm_agreement_reference => p_pm_agreement_reference);

Line 101: pa_interface_utils_pub.map_new_amg_msg

97: END IF;
98: ELSE
99: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
100: THEN
101: pa_interface_utils_pub.map_new_amg_msg
102: ( p_old_message_code => 'PA_AGMT_REF_AND_ID_MISS'
103: ,p_msg_attribute => 'CHANGE'
104: ,p_resize_flag => 'N'
105: ,p_msg_context => 'GENERAL'

Line 113: END IF; -- If p_af_agreement_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

109: ,p_attribute4 => ''
110: ,p_attribute5 => '');
111: END IF;
112: RAISE FND_API.G_EXC_ERROR;
113: END IF; -- If p_af_agreement_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
114: EXCEPTION
115: WHEN FND_API.G_EXC_ERROR
116: THEN
117: ----dbms_output.put_line('handling an G_EXC_ERROR exception');

Line 146: -- pa_interface_utils_pub.map_new_amg_msg

142: -- to a funding id.
143: --
144: --Called subprograms:
145: -- pa_agreement_pvt.fetch_funding_id
146: -- pa_interface_utils_pub.map_new_amg_msg
147: --
148: --
149: --History:
150: -- 25-MAR-2000 Rakesh Raghavan Created.

Line 153: (p_pm_funding_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

149: --History:
150: -- 25-MAR-2000 Rakesh Raghavan Created.
151: -- -----------------------------------------------------------------------------
152: PROCEDURE convert_fu_ref_to_id
153: (p_pm_funding_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
154: ,p_af_funding_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
155: ,p_out_funding_id OUT NOCOPY NUMBER /*file.sql.39*/
156: ,p_RETURN_status OUT NOCOPY VARCHAR2 /*file.sql.39*/)
157: IS

Line 154: ,p_af_funding_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

150: -- 25-MAR-2000 Rakesh Raghavan Created.
151: -- -----------------------------------------------------------------------------
152: PROCEDURE convert_fu_ref_to_id
153: (p_pm_funding_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
154: ,p_af_funding_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
155: ,p_out_funding_id OUT NOCOPY NUMBER /*file.sql.39*/
156: ,p_RETURN_status OUT NOCOPY VARCHAR2 /*file.sql.39*/)
157: IS
158: CURSOR l_funding_id_csr

Line 172: IF p_af_funding_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

168: BEGIN
169: --dbms_output.put_line('Inside fetch agreement id');
170: p_RETURN_status := FND_API.G_RET_STS_SUCCESS;
171:
172: IF p_af_funding_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
173: AND p_af_funding_id IS NOT NULL
174: THEN
175:
176: --check validity of this ID

Line 184: pa_interface_utils_pub.map_new_amg_msg

180: IF l_funding_id_csr%NOTFOUND
181: THEN
182: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
183: THEN
184: pa_interface_utils_pub.map_new_amg_msg
185: ( p_old_message_code => 'PA_INVALID_FUNDING_ID'
186: ,p_msg_attribute => 'CHANGE'
187: ,p_resize_flag => 'N'
188: ,p_msg_context => 'GENERAL'

Line 200: ELSIF p_pm_funding_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

196: RAISE FND_API.G_EXC_ERROR;
197: END IF;
198: CLOSE l_funding_id_csr;
199: p_out_funding_id := p_af_funding_id;
200: ELSIF p_pm_funding_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
201: AND p_pm_funding_reference IS NOT NULL
202: THEN
203: l_funding_id := fetch_funding_id(p_pm_funding_reference => p_pm_funding_reference);
204: IF l_funding_id IS NULL

Line 220: pa_interface_utils_pub.map_new_amg_msg

216: END IF;
217: ELSE
218: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
219: THEN
220: pa_interface_utils_pub.map_new_amg_msg
221: ( p_old_message_code => 'PA_FUND_REF_AND_ID_MISS'
222: ,p_msg_attribute => 'CHANGE'
223: ,p_resize_flag => 'Y'
224: ,p_msg_context => 'GENERAL'

Line 232: END IF; -- If p_af_agreement_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

228: ,p_attribute4 => ''
229: ,p_attribute5 => '');
230: END IF;
231: RAISE FND_API.G_EXC_ERROR;
232: END IF; -- If p_af_agreement_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
233: --dbms_output.put_line('Returning fetched funding id ='||nvl(to_char(p_out_funding_id),'NULL'));
234: EXCEPTION
235: WHEN FND_API.G_EXC_ERROR
236: THEN

Line 403: pa_interface_utils_pub.map_new_amg_msg

399: THEN
400: --dbms_output.put_line('Invalid Customer Id');
401: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
402: THEN
403: pa_interface_utils_pub.map_new_amg_msg
404: ( p_old_message_code => 'PA_INVALID_CUST'
405: ,p_msg_attribute => 'CHANGE'
406: ,p_resize_flag => 'N'
407: ,p_msg_context => 'AGREEMENT'

Line 425: pa_interface_utils_pub.map_new_amg_msg

421: THEN
422: --dbms_output.put_line('Invalid Agreement Type');
423: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
424: THEN
425: pa_interface_utils_pub.map_new_amg_msg
426: ( p_old_message_code => 'PA_INVALID_TYPE'
427: ,p_msg_attribute => 'CHANGE'
428: ,p_resize_flag => 'N'
429: ,p_msg_context => 'AGREEMENT'

Line 448: pa_interface_utils_pub.map_new_amg_msg

444: THEN
445: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
446: THEN
447: --dbms_output.put_line('Invalid Agreement Number');
448: pa_interface_utils_pub.map_new_amg_msg
449: ( p_old_message_code => 'PA_INVALID_AGMT_NUM'
450: ,p_msg_attribute => 'CHANGE'
451: ,p_resize_flag => 'N'
452: ,p_msg_context => 'AGREEMENT'

Line 471: pa_interface_utils_pub.map_new_amg_msg

467: THEN
468: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
469: THEN
470: --dbms_output.put_line('Invalid Term Name');
471: pa_interface_utils_pub.map_new_amg_msg
472: ( p_old_message_code => 'PA_INVALID_TERM_NAME'
473: ,p_msg_attribute => 'CHANGE'
474: ,p_resize_flag => 'N'
475: ,p_msg_context => 'AGREEMENT'

Line 495: pa_interface_utils_pub.map_new_amg_msg

491: THEN
492: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
493: THEN
494: --dbms_output.put_line('Invalid Template Flag');
495: pa_interface_utils_pub.map_new_amg_msg
496: ( p_old_message_code => 'PA_INVALID_TEMP_FLG'
497: ,p_msg_attribute => 'CHANGE'
498: ,p_resize_flag => 'N'
499: ,p_msg_context => 'AGREEMENT'

Line 518: pa_interface_utils_pub.map_new_amg_msg

514: THEN
515: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
516: THEN
517: --dbms_output.put_line('Invalid Revenue Limit Flag');
518: pa_interface_utils_pub.map_new_amg_msg
519: ( p_old_message_code => 'PA_INVALID_REV_LT_FLG'
520: ,p_msg_attribute => 'CHANGE'
521: ,p_resize_flag => 'N'
522: ,p_msg_context => 'AGREEMENT'

Line 541: pa_interface_utils_pub.map_new_amg_msg

537: THEN
538: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
539: THEN
540: --dbms_output.put_line('Invalid Owned By Person id');
541: pa_interface_utils_pub.map_new_amg_msg
542: ( p_old_message_code => 'PA_INVALID_OWND_BY_PRSN_ID'
543: ,p_msg_attribute => 'CHANGE'
544: ,p_resize_flag => 'N'
545: ,p_msg_context => 'AGREEMENT'

Line 565: pa_interface_utils_pub.map_new_amg_msg

561: THEN
562: --dbms_output.put_line('Agreement Not Unique');
563: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
564: THEN
565: pa_interface_utils_pub.map_new_amg_msg
566: ( p_old_message_code => 'PA_AGMT_NOT_UNIQUE'
567: ,p_msg_attribute => 'CHANGE'
568: ,p_resize_flag => 'N'
569: ,p_msg_context => 'AGREEMENT'

Line 584: (p_owning_organization_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )then /* Bug 2701579 */

580: -- valid owning organization id
581: --dbms_output.put_line('Check for valid owning orgn id ');
582:
583: IF (p_owning_organization_id is not null )and
584: (p_owning_organization_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )then /* Bug 2701579 */
585:
586: IF pa_agreement_utils.check_valid_owning_orgn_id
587: (p_owning_organization_id => p_owning_organization_id
588: ) = 'N'

Line 593: pa_interface_utils_pub.map_new_amg_msg

589: THEN
590: --dbms_output.put_line('Invalid owning organization_id ');
591: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
592: THEN
593: pa_interface_utils_pub.map_new_amg_msg
594: ( p_old_message_code => 'PA_OWNING_ORGN_ID_INVALID'
595: ,p_msg_attribute => 'CHANGE'
596: ,p_resize_flag => 'N'
597: ,p_msg_context => 'AGREEMENT'

Line 609: (p_agreement_currency_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) then /* Bug 2701579 */

605: END IF;
606: END IF;
607:
608: IF (p_agreement_currency_code is not null ) AND
609: (p_agreement_currency_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) then /* Bug 2701579 */
610:
611: IF pa_agreement_utils.check_valid_agr_curr_code
612: (p_agreement_currency_code => p_agreement_currency_code
613: ) = 'N'

Line 618: pa_interface_utils_pub.map_new_amg_msg

614: THEN
615: --dbms_output.put_line('Invalid agreement_currency_code ');
616: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
617: THEN
618: pa_interface_utils_pub.map_new_amg_msg
619: ( p_old_message_code => 'PA_CURR_NOT_VALID'
620: ,p_msg_attribute => 'CHANGE'
621: ,p_resize_flag => 'N'
622: ,p_msg_context => 'AGREEMENT'

Line 636: (p_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND

632:
633: /*Federal*/
634:
635: IF (p_start_date is not null ) AND
636: (p_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND
637: (p_end_date is not null) AND
638: (p_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) then
639:
640: IF (p_start_date >= p_end_date)

Line 638: (p_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) then

634:
635: IF (p_start_date is not null ) AND
636: (p_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND
637: (p_end_date is not null) AND
638: (p_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) then
639:
640: IF (p_start_date >= p_end_date)
641:
642: THEN

Line 646: pa_interface_utils_pub.map_new_amg_msg

642: THEN
643: --dbms_output.put_line('Invalid agreement_currency_code ');
644: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
645: THEN
646: pa_interface_utils_pub.map_new_amg_msg
647: ( p_old_message_code => 'PA_INVALID_START_DATE'
648: ,p_msg_attribute => 'CHANGE'
649: ,p_resize_flag => 'N'
650: ,p_msg_context => 'AGREEMENT'

Line 675: pa_interface_utils_pub.map_new_amg_msg

671: null;
672: ELSE
673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
674: THEN
675: pa_interface_utils_pub.map_new_amg_msg
676: ( p_old_message_code => 'PA_CLNT_ADV_CHECK'
677: ,p_msg_attribute => 'CHANGE'
678: ,p_resize_flag => 'N'
679: ,p_msg_context => 'AGREEMENT'

Line 691: pa_interface_utils_pub.map_new_amg_msg

687: END IF; /* client advance flag value
688: ELSE
689: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
690: THEN
691: pa_interface_utils_pub.map_new_amg_msg
692: ( p_old_message_code => 'PA_CLNT_ADV_CHECK'
693: ,p_msg_attribute => 'CHANGE'
694: ,p_resize_flag => 'N'
695: ,p_msg_context => 'AGREEMENT'

Line 708: p_billing_sequence <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

704: END IF; /*Advance required Commented for bug 5743599*/
705:
706:
707: IF ((p_billing_sequence <=0 or p_billing_sequence > 99) and
708: p_billing_sequence <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
709: then
710:
711: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
712: THEN

Line 713: pa_interface_utils_pub.map_new_amg_msg

709: then
710:
711: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
712: THEN
713: pa_interface_utils_pub.map_new_amg_msg
714: ( p_old_message_code => 'PA_INVALID_BILL_SEQ'
715: ,p_msg_attribute => 'CHANGE'
716: ,p_resize_flag => 'N'
717: ,p_msg_context => 'AGREEMENT'

Line 732: AND (p_invoice_limit_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) then /* Bug 2701579 */

728: -- invoice Limit Flag
729: --dbms_output.put_line('Check for valid invoice Limit Flag');
730:
731: IF (p_invoice_limit_flag is not null)
732: AND (p_invoice_limit_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) then /* Bug 2701579 */
733:
734: IF pa_agreement_pvt.check_yes_no
735: (p_val => p_invoice_limit_flag) = 'N'
736: THEN

Line 741: pa_interface_utils_pub.map_new_amg_msg

737:
738: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
739: THEN
740: --dbms_output.put_line('Invalid invoice Limit Flag');
741: pa_interface_utils_pub.map_new_amg_msg
742: ( p_old_message_code => 'PA_INVALID_INV_LT_FLG'
743: ,p_msg_attribute => 'CHANGE'
744: ,p_resize_flag => 'N'
745: ,p_msg_context => 'AGREEMENT'

Line 833: PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

829: -- VALIDATE THE INCOMING PARAMETERS
830: -- Customer Number
831: --dbms_output.put_line('Check for Valid Customer Id');
832: IF (p_customer_id IS NOT NULL AND p_customer_id <>
833: PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
834: AND p_customer_id <> l_agrcur.customer_id) THEN /* Bug 6602451 */
835: IF pa_agreement_utils.check_valid_customer
836: (p_customer_id => p_customer_id) = 'N'
837: THEN

Line 841: pa_interface_utils_pub.map_new_amg_msg

837: THEN
838: --dbms_output.put_line('Invalid Customer Id');
839: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
840: THEN
841: pa_interface_utils_pub.map_new_amg_msg
842: ( p_old_message_code => 'PA_INVALID_CUST'
843: ,p_msg_attribute => 'CHANGE'
844: ,p_resize_flag => 'N'
845: ,p_msg_context => 'AGREEMENT'

Line 861: IF (p_agreement_type IS NOT NULL AND p_agreement_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

857: END IF;
858:
859: -- Agreement Type
860: --dbms_output.put_line('Check for valid Agreement Type');
861: IF (p_agreement_type IS NOT NULL AND p_agreement_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
862: AND p_agreement_type <> l_agrcur.agreement_type) THEN /* Bug 6602451 */
863: IF pa_agreement_utils.check_valid_type
864: (p_agreement_type => p_agreement_type) = 'N'
865: THEN

Line 869: pa_interface_utils_pub.map_new_amg_msg

865: THEN
866: --dbms_output.put_line('Invalid Agreement Type');
867: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
868: THEN
869: pa_interface_utils_pub.map_new_amg_msg
870: ( p_old_message_code => 'PA_INVALID_TYPE'
871: ,p_msg_attribute => 'CHANGE'
872: ,p_resize_flag => 'N'
873: ,p_msg_context => 'AGREEMENT'

Line 896: pa_interface_utils_pub.map_new_amg_msg

892: THEN
893: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
894: THEN
895: --dbms_output.put_line('Invalid Agreement Number');
896: pa_interface_utils_pub.map_new_amg_msg
897: ( p_old_message_code => 'PA_INVALID_AGMT_NUM'
898: ,p_msg_attribute => 'CHANGE'
899: ,p_resize_flag => 'N'
900: ,p_msg_context => 'AGREEMENT'

Line 913: IF (p_term_id IS NOT NULL AND p_term_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

909: */
910:
911: -- Term Name
912: --dbms_output.put_line('Check for valid Term Name');
913: IF (p_term_id IS NOT NULL AND p_term_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
914: AND p_term_id <> l_agrcur.term_id) THEN /* Bug 6602451 */
915: IF pa_agreement_utils.check_valid_term_id
916: (p_term_id => p_term_id) = 'N'
917: THEN

Line 921: pa_interface_utils_pub.map_new_amg_msg

917: THEN
918: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
919: THEN
920: --dbms_output.put_line('Invalid Term Name');
921: pa_interface_utils_pub.map_new_amg_msg
922: ( p_old_message_code => 'PA_INVALID_TERM_NAME'
923: ,p_msg_attribute => 'CHANGE'
924: ,p_resize_flag => 'N'
925: ,p_msg_context => 'AGREEMENT'

Line 948: pa_interface_utils_pub.map_new_amg_msg

944: THEN
945: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
946: THEN
947: --dbms_output.put_line('Invalid Template Flag');
948: pa_interface_utils_pub.map_new_amg_msg
949: ( p_old_message_code => 'PA_INVALID_TEMP_FLG'
950: ,p_msg_attribute => 'CHANGE'
951: ,p_resize_flag => 'N'
952: ,p_msg_context => 'AGREEMENT'

Line 965: IF (p_revenue_limit_flag IS NOT NULL AND p_revenue_limit_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

961:
962: */
963: -- Revenue Limit Flag
964: --dbms_output.put_line('Check for valid Revenue Limit Flag');
965: IF (p_revenue_limit_flag IS NOT NULL AND p_revenue_limit_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
966: AND p_revenue_limit_flag <> l_agrcur.revenue_limit_flag) THEN /* Bug 6602451 */
967: IF pa_agreement_pvt.check_yes_no
968: (p_val => p_revenue_limit_flag) = 'N'
969: THEN

Line 973: pa_interface_utils_pub.map_new_amg_msg

969: THEN
970: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
971: THEN
972: --dbms_output.put_line('Invalid Revenue Limit Flag');
973: pa_interface_utils_pub.map_new_amg_msg
974: ( p_old_message_code => 'PA_INVALID_REV_LT_FLG'
975: ,p_msg_attribute => 'CHANGE'
976: ,p_resize_flag => 'N'
977: ,p_msg_context => 'AGREEMENT'

Line 993: IF (p_owned_by_person_id IS NOT NULL AND p_owned_by_person_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

989: END IF;
990:
991: -- Owned By Person Id
992: --dbms_output.put_line('Check for valid owned by person id');
993: IF (p_owned_by_person_id IS NOT NULL AND p_owned_by_person_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
994: AND p_owned_by_person_id <> l_agrcur.owned_by_person_id) THEN /* Bug 6602451 */
995: IF pa_agreement_utils.check_valid_owned_by_person_id
996: (p_owned_by_person_id => p_owned_by_person_id) = 'N'
997: THEN

Line 1001: pa_interface_utils_pub.map_new_amg_msg

997: THEN
998: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
999: THEN
1000: --dbms_output.put_line('Invalid Owned By Person id');
1001: pa_interface_utils_pub.map_new_amg_msg
1002: ( p_old_message_code => 'PA_INVALID_OWND_BY_PRSN_ID'
1003: ,p_msg_attribute => 'CHANGE'
1004: ,p_resize_flag => 'N'
1005: ,p_msg_context => 'AGREEMENT'

Line 1026: pa_interface_utils_pub.map_new_amg_msg

1022: ( p_funding_id => p_funding_id) = 'N'
1023: THEN
1024: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1025: THEN
1026: pa_interface_utils_pub.map_new_amg_msg
1027: ( p_old_message_code => 'PA_INVALID_FUND_REV_AMT'
1028: ,p_msg_attribute => 'CHANGE'
1029: ,p_resize_flag => 'N'
1030: ,p_msg_context => 'AGREEMENT'

Line 1061: IF (p_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN

1057: INTO l_tot_fund
1058: FROM pa_project_fundings
1059: WHERE agreement_id = p_agreement_id;
1060: */
1061: IF (p_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN
1062: l_start_date := cur_start_date;
1063: ELSE
1064: l_start_date := p_start_date;
1065: END IF;

Line 1067: IF (p_end_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN

1063: ELSE
1064: l_start_date := p_start_date;
1065: END IF;
1066:
1067: IF (p_end_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN
1068: l_end_date := cur_end_date;
1069: ELSE
1070: l_end_date := p_end_date;
1071: END IF;

Line 1073: IF (p_advance_required = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1069: ELSE
1070: l_end_date := p_end_date;
1071: END IF;
1072:
1073: IF (p_advance_required = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1074:
1075: l_adv_req := cur_adv_req;
1076: ELSE
1077: l_adv_req := nvl(p_advance_required,'N');/*Bug 5747269 */

Line 1084: IF (p_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

1080:
1081: IF (l_adv_req = 'Y') then
1082: l_agm_amt := cur_adv_amt;
1083: ELSE
1084: IF (p_amount = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1085: l_agm_amt := cur_agmt_amt;
1086: ELSE
1087: l_agm_amt := p_amount;
1088: END IF;

Line 1096: pa_interface_utils_pub.map_new_amg_msg

1092: THEN
1093: --dbms_output.put_line('Invalid agreement_currency_code ');
1094: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1095: THEN
1096: pa_interface_utils_pub.map_new_amg_msg
1097: ( p_old_message_code => 'PA_INVALID_START_DATE'
1098: ,p_msg_attribute => 'CHANGE'
1099: ,p_resize_flag => 'N'
1100: ,p_msg_context => 'AGREEMENT'

Line 1126: pa_interface_utils_pub.map_new_amg_msg

1122: THEN
1123: --dbms_output.put_line('Invalid agreement_currency_code ');
1124: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1125: THEN
1126: pa_interface_utils_pub.map_new_amg_msg
1127: ( p_old_message_code => 'PA_INVALID_EVENT_DATE'
1128: ,p_msg_attribute => 'CHANGE'
1129: ,p_resize_flag => 'N'
1130: ,p_msg_context => 'AGREEMENT'

Line 1150: pa_interface_utils_pub.map_new_amg_msg

1146:
1147: IF l_fund_count >0 THEN
1148: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1149: THEN
1150: pa_interface_utils_pub.map_new_amg_msg
1151: ( p_old_message_code => 'PA_CLNT_ADV_CHECK'
1152: ,p_msg_attribute => 'CHANGE'
1153: ,p_resize_flag => 'N'
1154: ,p_msg_context => 'AGREEMENT'

Line 1175: pa_interface_utils_pub.map_new_amg_msg

1171: null;
1172: ELSE
1173: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1174: THEN
1175: pa_interface_utils_pub.map_new_amg_msg
1176: ( p_old_message_code => 'PA_CLNT_ADV_CHECK'
1177: ,p_msg_attribute => 'CHANGE'
1178: ,p_resize_flag => 'N'
1179: ,p_msg_context => 'AGREEMENT'

Line 1191: pa_interface_utils_pub.map_new_amg_msg

1187: END IF; /* value from client ext*/
1188: ELSE
1189: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1190: THEN
1191: pa_interface_utils_pub.map_new_amg_msg
1192: ( p_old_message_code => 'PA_CLNT_ADV_CHECK'
1193: ,p_msg_attribute => 'CHANGE'
1194: ,p_resize_flag => 'N'
1195: ,p_msg_context => 'AGREEMENT'

Line 1210: p_billing_sequence <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)then

1206:
1207: /* 5684469 changed and to OR in the p_billing_sequence */
1208:
1209: IF ((p_billing_sequence <=0 or p_billing_sequence > 99)and
1210: p_billing_sequence <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)then
1211:
1212: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1213: THEN
1214: pa_interface_utils_pub.map_new_amg_msg

Line 1214: pa_interface_utils_pub.map_new_amg_msg

1210: p_billing_sequence <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)then
1211:
1212: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1213: THEN
1214: pa_interface_utils_pub.map_new_amg_msg
1215: ( p_old_message_code => 'PA_INVALID_BILL_SEQ'
1216: ,p_msg_attribute => 'CHANGE'
1217: ,p_resize_flag => 'N'
1218: ,p_msg_context => 'AGREEMENT'

Line 1237: pa_interface_utils_pub.map_new_amg_msg

1233: (p_agreement_id => p_agreement_id)= 'N'
1234: THEN
1235: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1236: THEN
1237: pa_interface_utils_pub.map_new_amg_msg
1238: ( p_old_message_code => 'PA_INVALID_REVENUE_LIMIT'
1239: ,p_msg_attribute => 'CHANGE'
1240: ,p_resize_flag => 'N'
1241: ,p_msg_context => 'AGREEMENT'

Line 1260: pa_interface_utils_pub.map_new_amg_msg

1256: IF (l_agm_amt < l_tot_fund)-- bug 5685032 changed to < from <=
1257: THEN
1258: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1259: THEN
1260: pa_interface_utils_pub.map_new_amg_msg
1261: ( p_old_message_code => 'PA_INVD_FUND_ALLOC'
1262: ,p_msg_attribute => 'CHANGE'
1263: ,p_resize_flag => 'N'
1264: ,p_msg_context => 'AGREEMENT'

Line 1279: IF (p_owning_organization_id IS NOT NULL AND p_owning_organization_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1275: -- valid owning organization id
1276: --dbms_output.put_line('Check for valid owning orgn id ');
1277: /* IF p_owning_organization_id is not null then Commenetd for Bug 6602451 and added the below IF condition*/
1278:
1279: IF (p_owning_organization_id IS NOT NULL AND p_owning_organization_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1280: AND p_owning_organization_id <> l_agrcur.owning_organization_id) THEN /* Bug 6602451 */
1281: IF pa_agreement_utils.check_valid_owning_orgn_id
1282: (p_owning_organization_id => p_owning_organization_id
1283: ) = 'N'

Line 1288: pa_interface_utils_pub.map_new_amg_msg

1284: THEN
1285: --dbms_output.put_line('Invalid owning organization_id ');
1286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1287: THEN
1288: pa_interface_utils_pub.map_new_amg_msg
1289: ( p_old_message_code => 'PA_OWNING_ORGN_ID_INVALID'
1290: ,p_msg_attribute => 'CHANGE'
1291: ,p_resize_flag => 'N'
1292: ,p_msg_context => 'AGREEMENT'

Line 1308: IF (p_agreement_currency_code IS NOT NULL AND p_agreement_currency_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1304: END IF;
1305:
1306: /* IF p_agreement_currency_code is not null then Commenetd for Bug 6602451 and added the below IF condition*/
1307:
1308: IF (p_agreement_currency_code IS NOT NULL AND p_agreement_currency_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1309: AND p_agreement_currency_code <> l_agrcur.agreement_currency_code) THEN /* Bug 6602451 */
1310: -- Start of Bugfix 2442176
1311: IF pa_agreement_utils.check_valid_agr_curr_code
1312: (p_agreement_currency_code => p_agreement_currency_code

Line 1327: pa_interface_utils_pub.map_new_amg_msg

1323: AND nvl(ALLOCATED_AMOUNT,0) <> 0));
1324: --dbms_output.put_line('Invalid agreement_currency_code ');
1325: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1326: THEN
1327: pa_interface_utils_pub.map_new_amg_msg
1328: ( p_old_message_code => 'PA_CURR_NOT_VALID'
1329: ,p_msg_attribute => 'CHANGE'
1330: ,p_resize_flag => 'N'
1331: ,p_msg_context => 'AGREEMENT'

Line 1353: pa_interface_utils_pub.map_new_amg_msg

1349:
1350: --dbms_output.put_line('Invalid agreement_currency_code ');
1351: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1352: THEN
1353: pa_interface_utils_pub.map_new_amg_msg
1354: ( p_old_message_code => 'PA_CURR_NOT_VALID'
1355: ,p_msg_attribute => 'CHANGE'
1356: ,p_resize_flag => 'N'
1357: ,p_msg_context => 'AGREEMENT'

Line 1375: IF (p_invoice_limit_flag IS NOT NULL AND p_invoice_limit_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1371: -- invoice Limit Flag
1372: --dbms_output.put_line('Check for valid invoice Limit Flag');
1373: /* IF p_invoice_limit_flag is not null THEN Commenetd for Bug 6602451 and added the below IF condition*/
1374:
1375: IF (p_invoice_limit_flag IS NOT NULL AND p_invoice_limit_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1376: AND p_invoice_limit_flag <> l_agrcur.invoice_limit_flag) THEN /* Bug 6602451 */
1377: IF pa_agreement_pvt.check_yes_no
1378: (p_val => p_invoice_limit_flag) = 'N' THEN
1379:

Line 1382: pa_interface_utils_pub.map_new_amg_msg

1378: (p_val => p_invoice_limit_flag) = 'N' THEN
1379:
1380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1381: --dbms_output.put_line('Invalid invoice Limit Flag');
1382: pa_interface_utils_pub.map_new_amg_msg
1383: ( p_old_message_code => 'PA_INVALID_INV_LT_FLG'
1384: ,p_msg_attribute => 'CHANGE'
1385: ,p_resize_flag => 'N'
1386: ,p_msg_context => 'AGREEMENT'

Line 1400: pa_interface_utils_pub.map_new_amg_msg

1396: IF pa_agreement_utils.check_invoice_limit
1397: (p_agreement_id => p_agreement_id)= 'N' THEN
1398:
1399: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1400: pa_interface_utils_pub.map_new_amg_msg
1401: ( p_old_message_code => 'PA_INVALID_INVOICE_LIMIT'
1402: ,p_msg_attribute => 'CHANGE'
1403: ,p_resize_flag => 'N'
1404: ,p_msg_context => 'AGREEMENT'

Line 1479: pa_interface_utils_pub.map_new_amg_msg

1475: IF l_RETURN = 'N'
1476: THEN
1477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1478: THEN
1479: pa_interface_utils_pub.map_new_amg_msg
1480: ( p_old_message_code => 'PA_CANT_DELETE_AGMT'
1481: ,p_msg_attribute => 'CHANGE'
1482: ,p_resize_flag => 'Y'
1483: ,p_msg_context => 'AGREEMENT'

Line 1509: pa_interface_utils_pub.map_new_amg_msg

1505: IF (l_count>0) THEN
1506: l_RETURN:='N';
1507: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1508: THEN
1509: pa_interface_utils_pub.map_new_amg_msg
1510: ( p_old_message_code => 'PA_RECP_DELETE_AGMT'
1511: ,p_msg_attribute => 'CHANGE'
1512: ,p_resize_flag => 'N' /*Bug 5909864 */
1513: ,p_msg_context => 'AGREEMENT'

Line 1534: pa_interface_utils_pub.map_new_amg_msg

1530: IF (l_count>0) THEN
1531: l_RETURN:='N';
1532: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1533: THEN
1534: pa_interface_utils_pub.map_new_amg_msg
1535: ( p_old_message_code => 'PA_EVENT_AGMT_DELETE'
1536: ,p_msg_attribute => 'CHANGE'
1537: ,p_resize_flag => 'Y'
1538: ,p_msg_context => 'AGREEMENT'

Line 1586: pa_interface_utils_pub.map_new_amg_msg

1582: /* code change for bug 2868818*/
1583:
1584: IF upper(p_funding_category) = 'REVALUATION'
1585: THEN
1586: pa_interface_utils_pub.map_new_amg_msg
1587: ( p_old_message_code => 'PA_INV_FUND_CAT'
1588: ,p_msg_attribute => 'CHANGE'
1589: ,p_resize_flag => 'N'
1590: ,p_msg_context => 'FUNDING'

Line 1617: pa_interface_utils_pub.map_new_amg_msg

1613: EXCEPTION
1614: WHEN NO_DATA_FOUND THEN
1615: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1616: THEN
1617: pa_interface_utils_pub.map_new_amg_msg
1618: ( p_old_message_code => 'PA_INV_FUND_CAT'
1619: ,p_msg_attribute => 'CHANGE'
1620: ,p_resize_flag => 'N'
1621: ,p_msg_context => 'FUNDING'

Line 1711: pa_interface_utils_pub.map_new_amg_msg

1707: )
1708: THEN
1709: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1710: THEN
1711: pa_interface_utils_pub.map_new_amg_msg
1712: ( p_old_message_code => 'PA_INVALID_PROJECT'
1713: ,p_msg_attribute => 'CHANGE'
1714: ,p_resize_flag => 'N'
1715: ,p_msg_context => 'FUNDING'

Line 1730: pa_interface_utils_pub.map_new_amg_msg

1726: (p_customer_id => p_customer_id) = 'N'
1727: THEN
1728: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1729: THEN
1730: pa_interface_utils_pub.map_new_amg_msg
1731: ( p_old_message_code => 'PA_INVALID_CUSTOMER'
1732: ,p_msg_attribute => 'CHANGE'
1733: ,p_resize_flag => 'N'
1734: ,p_msg_context => 'FUNDING'

Line 1755: pa_interface_utils_pub.map_new_amg_msg

1751: THEN
1752: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1753: THEN
1754: --dbms_output.put_line('Invalid Task');
1755: pa_interface_utils_pub.map_new_amg_msg
1756: ( p_old_message_code => 'PA_INVD_TASK'
1757: ,p_msg_attribute => 'CHANGE'
1758: ,p_resize_flag => 'N'
1759: ,p_msg_context => 'FUNDING'

Line 1784: pa_interface_utils_pub.map_new_amg_msg

1780: l_Inv_Method_Override_Flag = 'Y') THEN
1781: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1782: THEN
1783: --dbms_output.put_line('Invalid Funding level');
1784: pa_interface_utils_pub.map_new_amg_msg
1785: ( p_old_message_code => 'PA_TASK_LEVEL_FUND_REQD'
1786: ,p_msg_attribute => 'CHANGE'
1787: ,p_resize_flag => 'N'
1788: ,p_msg_context => 'FUNDING'

Line 1814: PA_Interface_Utils_Pub.Map_New_AMG_Msg (

1810: AND Task_ID = P_Task_ID
1811: AND Customer_ID = P_Customer_ID
1812: AND Rownum < 2;
1813: Exception when no_data_found then
1814: PA_Interface_Utils_Pub.Map_New_AMG_Msg (
1815: P_Old_Message_Code => 'PA_INVALID_TASK_CUSTOMER',
1816: P_Msg_Attribute => 'CHANGE',
1817: P_Msg_Context => 'FUNDING',
1818: p_resize_flag => 'N', -- Fix for bug 3523077

Line 1849: pa_interface_utils_pub.map_new_amg_msg

1845: OR (p_task_id IS NOT NULL and l_Allowable_Funding_Level_Code = 'P')
1846: THEN
1847: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1848: THEN
1849: pa_interface_utils_pub.map_new_amg_msg
1850: ( p_old_message_code => 'PA_INVD_FUNDING_LVL'
1851: ,p_msg_attribute => 'CHANGE'
1852: ,p_resize_flag => 'N'
1853: ,p_msg_context => 'FUNDING'

Line 1900: pa_interface_utils_pub.map_new_amg_msg

1896: THEN
1897: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1898: THEN
1899: --dbms_output.put_line('1.Invalid Funding level');
1900: pa_interface_utils_pub.map_new_amg_msg
1901: ( p_old_message_code => 'PA_PROJ_FUND_NO_TASK_TRANS'
1902: ,p_msg_attribute => 'CHANGE'
1903: ,p_resize_flag => 'N'
1904: ,p_msg_context => 'FUNDING'

Line 1918: pa_interface_utils_pub.map_new_amg_msg

1914: THEN
1915: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1916: THEN
1917: --dbms_output.put_line('Invalid Funding level PA_BU_PROJECT_ALLOC_ONLY');
1918: pa_interface_utils_pub.map_new_amg_msg
1919: ( p_old_message_code => 'PA_BU_PROJECT_ALLOC_ONLY'
1920: ,p_msg_attribute => 'CHANGE'
1921: ,p_resize_flag => 'N'
1922: ,p_msg_context => 'FUNDING'

Line 1936: pa_interface_utils_pub.map_new_amg_msg

1932: THEN
1933: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1934: THEN
1935: --dbms_output.put_line('3. Invalid Funding level');
1936: pa_interface_utils_pub.map_new_amg_msg
1937: ( p_old_message_code => 'PA_BU_TASK_ALLOC_ONLY'
1938: ,p_msg_attribute => 'CHANGE'
1939: ,p_resize_flag => 'N'
1940: ,p_msg_context => 'FUNDING'

Line 1954: pa_interface_utils_pub.map_new_amg_msg

1950: THEN
1951: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1952: THEN
1953: --dbms_output.put_line('4. Invalid Funding level');
1954: pa_interface_utils_pub.map_new_amg_msg
1955: ( p_old_message_code => 'PA_TASK_FUND_NO_PROJ_TRANS'
1956: ,p_msg_attribute => 'CHANGE'
1957: ,p_resize_flag => 'N'
1958: ,p_msg_context => 'FUNDING'

Line 1995: pa_interface_utils_pub.map_new_amg_msg

1991:
1992: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1993: THEN
1994: --dbms_output.put_line('4. Invalid Funding level');
1995: pa_interface_utils_pub.map_new_amg_msg
1996: ( p_old_message_code => 'PA_FP_CHK_FUNDING_LVL'
1997: ,p_msg_attribute => 'CHANGE'
1998: ,p_resize_flag => 'N'
1999: ,p_msg_context => 'FUNDING'

Line 2025: pa_interface_utils_pub.map_new_amg_msg

2021: IF l_valid_fund_amt in ('Z','M') THEN
2022: --dbms_output.put_line('INSIDE PVTmessage should popup');
2023: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2024: THEN
2025: pa_interface_utils_pub.map_new_amg_msg
2026: ( p_old_message_code => 'PA_INVD_FUND_ALLOC'
2027: ,p_msg_attribute => 'CHANGE'
2028: ,p_resize_flag => 'N'
2029: ,p_msg_context => 'FUNDING'

Line 2107: pa_interface_utils_pub.map_new_amg_msg

2103: p_funding_id => p_funding_id) = 'N' THEN
2104:
2105: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2106: THEN
2107: pa_interface_utils_pub.map_new_amg_msg
2108: ( p_old_message_code => 'PA_FUNDING_BASELINED'
2109: ,p_msg_attribute => 'CHANGE'
2110: ,p_resize_flag => 'N'
2111: ,p_msg_context => 'FUNDING'

Line 2132: pa_interface_utils_pub.map_new_amg_msg

2128: p_agreement_id => p_agreement_id) = 'N'
2129: THEN
2130: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2131: THEN
2132: pa_interface_utils_pub.map_new_amg_msg
2133: ( p_old_message_code => 'PA_INVALID_PROJECT_ID'
2134: ,p_msg_attribute => 'CHANGE'
2135: ,p_resize_flag => 'N'
2136: ,p_msg_context => 'FUNDING'

Line 2152: pa_interface_utils_pub.map_new_amg_msg

2148: (p_customer_id => p_customer_id) = 'N'
2149: THEN
2150: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2151: THEN
2152: pa_interface_utils_pub.map_new_amg_msg
2153: ( p_old_message_code => 'PA_INVALID_CUST'
2154: ,p_msg_attribute => 'CHANGE'
2155: ,p_resize_flag => 'N'
2156: ,p_msg_context => 'FUNDING'

Line 2175: pa_interface_utils_pub.map_new_amg_msg

2171: ,p_task_id => p_task_id) = 'N'
2172: THEN
2173: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2174: THEN
2175: pa_interface_utils_pub.map_new_amg_msg
2176: ( p_old_message_code => 'PA_INVALID_TASK'
2177: ,p_msg_attribute => 'CHANGE'
2178: ,p_resize_flag => 'N'
2179: ,p_msg_context => 'FUNDING'

Line 2206: pa_interface_utils_pub.map_new_amg_msg

2202: l_Inv_Method_Override_Flag = 'Y') THEN
2203: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2204: THEN
2205: --dbms_output.put_line('Invalid Funding level');
2206: pa_interface_utils_pub.map_new_amg_msg
2207: ( p_old_message_code => 'PA_TASK_LEVEL_FUND_REQD'
2208: ,p_msg_attribute => 'CHANGE'
2209: ,p_resize_flag => 'N'
2210: ,p_msg_context => 'FUNDING'

Line 2237: PA_Interface_Utils_Pub.Map_New_AMG_Msg (

2233: AND Task_ID = P_Task_ID
2234: AND Customer_ID = P_Customer_ID
2235: AND Rownum < 2;
2236: Exception when no_data_found then
2237: PA_Interface_Utils_Pub.Map_New_AMG_Msg (
2238: P_Old_Message_Code => 'PA_INVALID_TASK_CUSTOMER',
2239: P_Msg_Attribute => 'CHANGE',
2240: p_Resize_Flag => 'N',
2241: P_Msg_Context => 'FUNDING',

Line 2287: pa_interface_utils_pub.map_new_amg_msg

2283: IF l_check_proj_task_lvl_funding = 'A'
2284: THEN
2285: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2286: THEN
2287: pa_interface_utils_pub.map_new_amg_msg
2288: ( p_old_message_code => 'PA_PROJ_FUND_NO_TASK_TRANS'
2289: ,p_msg_attribute => 'CHANGE'
2290: ,p_resize_flag => 'N'
2291: ,p_msg_context => 'FUNDING'

Line 2304: pa_interface_utils_pub.map_new_amg_msg

2300: ELSIF l_check_proj_task_lvl_funding = 'P'
2301: THEN
2302: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2303: THEN
2304: pa_interface_utils_pub.map_new_amg_msg
2305: ( p_old_message_code => 'PA_BU_PROJECT_ALLOC_ONLY'
2306: ,p_msg_attribute => 'CHANGE'
2307: ,p_resize_flag => 'N'
2308: ,p_msg_context => 'FUNDING'

Line 2321: pa_interface_utils_pub.map_new_amg_msg

2317: ELSIF l_check_proj_task_lvl_funding = 'T'
2318: THEN
2319: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2320: THEN
2321: pa_interface_utils_pub.map_new_amg_msg
2322: ( p_old_message_code => 'PA_BU_TASK_ALLOC_ONLY'
2323: ,p_msg_attribute => 'CHANGE'
2324: ,p_resize_flag => 'N'
2325: ,p_msg_context => 'FUNDING'

Line 2338: pa_interface_utils_pub.map_new_amg_msg

2334: ELSIF l_check_proj_task_lvl_funding = 'B'
2335: THEN
2336: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2337: THEN
2338: pa_interface_utils_pub.map_new_amg_msg
2339: ( p_old_message_code => 'PA_TASK_FUND_NO_PROJ_TRANS'
2340: ,p_msg_attribute => 'CHANGE'
2341: ,p_resize_flag => 'N'
2342: ,p_msg_context => 'FUNDING'

Line 2379: pa_interface_utils_pub.map_new_amg_msg

2375: IF l_check_proj_task_lvl_funding='A' THEN
2376:
2377: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2378: THEN
2379: pa_interface_utils_pub.map_new_amg_msg
2380: ( p_old_message_code => 'PA_FP_CHK_FUNDING_LVL'
2381: ,p_msg_attribute => 'CHANGE'
2382: ,p_resize_flag => 'N'
2383: ,p_msg_context => 'FUNDING'

Line 2405: pa_interface_utils_pub.map_new_amg_msg

2401: ,p_funding_id => p_funding_id) ;
2402: IF l_valid_fund_amt in ('Z','M') 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_INVD_FUND_ALLOC'
2407: ,p_msg_attribute => 'CHANGE'
2408: ,p_resize_flag => 'N'
2409: ,p_msg_context => 'FUNDING'

Line 2423: pa_interface_utils_pub.map_new_amg_msg

2419: /* commented as check is covered in the previous loop
2420: ELSIF l_valid_fund_amt = 'M' THEN
2421: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2422: THEN
2423: pa_interface_utils_pub.map_new_amg_msg
2424: ( p_old_message_code => 'PA_INVD_FUND_ALLOC'
2425: ,p_msg_attribute => 'CHANGE'
2426: ,p_resize_flag => 'N'
2427: ,p_msg_context => 'AGREEMENT'

Line 2482: pa_interface_utils_pub.map_new_amg_msg

2478: (p_funding_id => p_funding_id) = 'N'
2479: THEN
2480: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2481: THEN
2482: pa_interface_utils_pub.map_new_amg_msg
2483: ( p_old_message_code => 'PA_INVD_BDGT_TYP_CODE'
2484: ,p_msg_attribute => 'CHANGE'
2485: ,p_resize_flag => 'Y'
2486: ,p_msg_context => 'FUNDING'

Line 2502: pa_interface_utils_pub.map_new_amg_msg

2498: (p_agreement_id => p_agreement_id) = 'N'
2499: THEN
2500: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2501: THEN
2502: pa_interface_utils_pub.map_new_amg_msg
2503: ( p_old_message_code => 'PA_INVALID_REVENUE_LIMIT'
2504: ,p_msg_attribute => 'CHANGE'
2505: ,p_resize_flag => 'Y'
2506: ,p_msg_context => 'FUNDING'

Line 2536: pa_interface_utils_pub.map_new_amg_msg

2532: ,p_funding_id => p_funding_id ) ;
2533: IF l_valid_fund_amt = 'Z' THEN
2534: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2535: THEN
2536: pa_interface_utils_pub.map_new_amg_msg
2537: ( p_old_message_code => 'PA_INVD_FUND_ALLOC'
2538: ,p_msg_attribute => 'CHANGE'
2539: ,p_resize_flag => 'N'
2540: ,p_msg_context => 'AGREEMENT'

Line 2551: pa_interface_utils_pub.map_new_amg_msg

2547: l_RETURN := 'N';
2548: ELSIF l_valid_fund_amt = 'M' THEN
2549: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2550: THEN
2551: pa_interface_utils_pub.map_new_amg_msg
2552: ( p_old_message_code => 'PA_INVD_FUND_ALLOC'
2553: ,p_msg_attribute => 'CHANGE'
2554: ,p_resize_flag => 'N'
2555: ,p_msg_context => 'AGREEMENT'

Line 2588: p_desc_flex_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2584: --History:
2585: -- 25-MAR-2000 Rakesh Raghavan Created.
2586: -- -----------------------------------------------------------------------------
2587: PROCEDURE validate_flex_fields(
2588: p_desc_flex_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2589: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2590: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2591: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2592: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2589: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2585: -- 25-MAR-2000 Rakesh Raghavan Created.
2586: -- -----------------------------------------------------------------------------
2587: PROCEDURE validate_flex_fields(
2588: p_desc_flex_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2589: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2590: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2591: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2592: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2593: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2590: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2586: -- -----------------------------------------------------------------------------
2587: PROCEDURE validate_flex_fields(
2588: p_desc_flex_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2589: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2590: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2591: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2592: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2593: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2594: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2591: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2587: PROCEDURE validate_flex_fields(
2588: p_desc_flex_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2589: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2590: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2591: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2592: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2593: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2594: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2595: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2592: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2588: p_desc_flex_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2589: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2590: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2591: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2592: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2593: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2594: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2595: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2596: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2593: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2589: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2590: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2591: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2592: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2593: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2594: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2595: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2596: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2597: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2594: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2590: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2591: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2592: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2593: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2594: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2595: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2596: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2597: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2598: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2595: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2591: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2592: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2593: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2594: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2595: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2596: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2597: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2598: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2599: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2596: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2592: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2593: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2594: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2595: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2596: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2597: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2598: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2599: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2600: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2597: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2593: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2594: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2595: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2596: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2597: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2598: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2599: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2600: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2601: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2598: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2594: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2595: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2596: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2597: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2598: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2599: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2600: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2601: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2602: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2599: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2595: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2596: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2597: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2598: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2599: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2600: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2601: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2602: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2603: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2600: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2596: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2597: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2598: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2599: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2600: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2601: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2602: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2603: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2604: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2601: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2597: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2598: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2599: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2600: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2601: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2602: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2603: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2604: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2605: ,p_attribute16 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2602: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2598: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2599: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2600: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2601: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2602: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2603: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2604: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2605: ,p_attribute16 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2606: ,p_attribute17 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2603: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2599: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2600: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2601: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2602: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2603: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2604: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2605: ,p_attribute16 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2606: ,p_attribute17 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2607: ,p_attribute18 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2604: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2600: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2601: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2602: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2603: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2604: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2605: ,p_attribute16 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2606: ,p_attribute17 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2607: ,p_attribute18 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2608: ,p_attribute19 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2605: ,p_attribute16 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2601: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2602: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2603: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2604: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2605: ,p_attribute16 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2606: ,p_attribute17 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2607: ,p_attribute18 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2608: ,p_attribute19 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2609: ,p_attribute20 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2606: ,p_attribute17 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2602: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2603: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2604: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2605: ,p_attribute16 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2606: ,p_attribute17 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2607: ,p_attribute18 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2608: ,p_attribute19 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2609: ,p_attribute20 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2610: ,p_attribute21 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2607: ,p_attribute18 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2603: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2604: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2605: ,p_attribute16 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2606: ,p_attribute17 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2607: ,p_attribute18 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2608: ,p_attribute19 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2609: ,p_attribute20 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2610: ,p_attribute21 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2611: ,p_attribute22 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2608: ,p_attribute19 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2604: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2605: ,p_attribute16 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2606: ,p_attribute17 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2607: ,p_attribute18 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2608: ,p_attribute19 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2609: ,p_attribute20 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2610: ,p_attribute21 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2611: ,p_attribute22 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2612: ,p_attribute23 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2609: ,p_attribute20 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2605: ,p_attribute16 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2606: ,p_attribute17 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2607: ,p_attribute18 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2608: ,p_attribute19 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2609: ,p_attribute20 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2610: ,p_attribute21 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2611: ,p_attribute22 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2612: ,p_attribute23 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2613: ,p_attribute24 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2610: ,p_attribute21 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2606: ,p_attribute17 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2607: ,p_attribute18 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2608: ,p_attribute19 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2609: ,p_attribute20 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2610: ,p_attribute21 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2611: ,p_attribute22 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2612: ,p_attribute23 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2613: ,p_attribute24 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2614: ,p_attribute25 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2611: ,p_attribute22 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2607: ,p_attribute18 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2608: ,p_attribute19 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2609: ,p_attribute20 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2610: ,p_attribute21 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2611: ,p_attribute22 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2612: ,p_attribute23 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2613: ,p_attribute24 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2614: ,p_attribute25 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2615: ,p_RETURN_msg OUT NOCOPY VARCHAR2 /*file.sql.39*/

Line 2612: ,p_attribute23 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2608: ,p_attribute19 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2609: ,p_attribute20 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2610: ,p_attribute21 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2611: ,p_attribute22 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2612: ,p_attribute23 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2613: ,p_attribute24 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2614: ,p_attribute25 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2615: ,p_RETURN_msg OUT NOCOPY VARCHAR2 /*file.sql.39*/
2616: ,p_validate_status OUT NOCOPY VARCHAR2 /*file.sql.39*/)

Line 2613: ,p_attribute24 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2609: ,p_attribute20 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2610: ,p_attribute21 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2611: ,p_attribute22 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2612: ,p_attribute23 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2613: ,p_attribute24 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2614: ,p_attribute25 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2615: ,p_RETURN_msg OUT NOCOPY VARCHAR2 /*file.sql.39*/
2616: ,p_validate_status OUT NOCOPY VARCHAR2 /*file.sql.39*/)
2617: IS

Line 2614: ,p_attribute25 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2610: ,p_attribute21 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2611: ,p_attribute22 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2612: ,p_attribute23 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2613: ,p_attribute24 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2614: ,p_attribute25 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2615: ,p_RETURN_msg OUT NOCOPY VARCHAR2 /*file.sql.39*/
2616: ,p_validate_status OUT NOCOPY VARCHAR2 /*file.sql.39*/)
2617: IS
2618: l_dummy VARCHAR2(1);