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.AR_CHARGE_SCHEDULE_PKG dependencies on ARP_STANDARD

Line 31: arp_standard.debug('Insert_schedule_Row +');

27: P_OBJECT_VERSION_NUMBER IN NUMBER,
28: x_return_status IN OUT NOCOPY VARCHAR2)
29: IS
30: BEGIN
31: arp_standard.debug('Insert_schedule_Row +');
32: INSERT INTO AR_CHARGE_SCHEDULES
33: (SCHEDULE_ID ,
34: SCHEDULE_NAME ,
35: SCHEDULE_DESCRIPTION,

Line 85: arp_standard.debug('Insert_schedule_Row -');

81: NVL(FND_GLOBAL.user_id,-1),
82: TRUNC(SYSDATE),
83: NVL(FND_GLOBAL.login_id,-1));
84:
85: arp_standard.debug('Insert_schedule_Row -');
86: EXCEPTION
87: WHEN OTHERS THEN
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 119: arp_standard.debug('Insert_schedule_Row +');

115: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
116: x_return_status IN OUT NOCOPY VARCHAR2)
117: IS
118: BEGIN
119: arp_standard.debug('Insert_schedule_Row +');
120: UPDATE AR_CHARGE_SCHEDULES SET
121: SCHEDULE_DESCRIPTION = DECODE(P_SCHEDULE_DESCRIPTION,
122: FND_API.G_MISS_CHAR, NULL,
123: NULL , SCHEDULE_DESCRIPTION, P_SCHEDULE_DESCRIPTION ),

Line 178: arp_standard.debug('Insert_schedule_Row -');

174: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),
175: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id,-1)
176: WHERE SCHEDULE_ID = P_SCHEDULE_ID
177: RETURNING OBJECT_VERSION_NUMBER INTO x_OBJECT_VERSION_NUMBER;
178: arp_standard.debug('Insert_schedule_Row -');
179: EXCEPTION
180: WHEN OTHERS THEN
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 220: arp_standard.debug('Insert_Head_Row +');

216: P_OBJECT_VERSION_NUMBER IN NUMBER,
217: x_return_status IN OUT NOCOPY VARCHAR2)
218: IS
219: BEGIN
220: arp_standard.debug('Insert_Head_Row +');
221: INSERT INTO AR_charge_SCHEDULE_HDRS
222: (SCHEDULE_HEADER_ID,
223: SCHEDULE_ID ,
224: SCHEDULE_HEADER_TYPE,

Line 282: arp_standard.debug('Insert_Head_Row -');

278: NVL(FND_GLOBAL.user_id,-1),
279: TRUNC(SYSDATE),
280: NVL(FND_GLOBAL.login_id,-1));
281:
282: arp_standard.debug('Insert_Head_Row -');
283: EXCEPTION
284: WHEN OTHERS THEN
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 324: arp_standard.debug('Update_Head_Row +');

320: x_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
321: x_return_status IN OUT NOCOPY VARCHAR2)
322: IS
323: BEGIN
324: arp_standard.debug('Update_Head_Row +');
325:
326: UPDATE ar_charge_schedule_hdrs SET
327: END_DATE = DECODE(P_END_DATE,
328: FND_API.G_MISS_DATE, NULL,

Line 388: arp_standard.debug('Update_Head_Row -');

384: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id,-1)
385: WHERE SCHEDULE_HEADER_ID = P_SCHEDULE_HEADER_ID
386: RETURNING OBJECT_VERSION_NUMBER INTO x_OBJECT_VERSION_NUMBER;
387:
388: arp_standard.debug('Update_Head_Row -');
389: EXCEPTION
390: WHEN OTHERS THEN
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 430: arp_standard.debug('Insert_Line_Row +');

426: P_OBJECT_VERSION_NUMBER IN NUMBER,
427: x_return_status IN OUT NOCOPY VARCHAR2)
428: IS
429: BEGIN
430: arp_standard.debug('Insert_Line_Row +');
431: INSERT INTO AR_charge_SCHEDULE_LINES
432: (SCHEDULE_LINE_ID ,
433: SCHEDULE_HEADER_ID ,
434: SCHEDULE_ID ,

Line 492: arp_standard.debug('Insert_Line_Row -');

488: NVL(FND_GLOBAL.user_id,-1),
489: TRUNC(SYSDATE),
490: NVL(FND_GLOBAL.login_id,-1));
491:
492: arp_standard.debug('Insert_Line_Row -');
493: EXCEPTION
494: WHEN OTHERS THEN
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 526: arp_standard.debug('Update_Line_Row +');

522: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
523: x_return_status IN OUT NOCOPY VARCHAR2)
524: IS
525: BEGIN
526: arp_standard.debug('Update_Line_Row +');
527: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
528: UPDATE AR_charge_SCHEDULE_LINES SET
529: AMOUNT = DECODE(p_amount,
530: fnd_api.g_miss_num, NULL,

Line 590: arp_standard.debug('Update_Line_Row -');

586: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id,-1)
587: WHERE SCHEDULE_LINE_ID = P_SCHEDULE_LINE_ID;
588:
589:
590: arp_standard.debug('Update_Line_Row -');
591: EXCEPTION
592: WHEN OTHERS THEN
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
594: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 670: arp_standard.debug(' Validate schedule_name +');

666: BEGIN
667: -------------------------
668: -- Validate schedule_name
669: -------------------------
670: arp_standard.debug(' Validate schedule_name +');
671: IF p_mode = 'INSERT' THEN
672: IF p_schedule_name IS NULL OR p_schedule_name = FND_API.G_MISS_CHAR THEN
673: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
674: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_name' );

Line 679: arp_standard.debug(' Validate schedule_name -');

675: FND_MSG_PUB.ADD;
676: x_return_status := FND_API.G_RET_STS_ERROR;
677: END IF;
678: END IF;
679: arp_standard.debug(' Validate schedule_name -');
680: END;
681:
682:
683:

Line 728: arp_standard.debug('validate_schedule_header +');

724: l_cpt NUMBER := 0;
725: l_c VARCHAR2(1);
726: BEGIN
727:
728: arp_standard.debug('validate_schedule_header +');
729:
730:
731: IF p_mode IN ('INSERT') THEN
732: -------------------------------------

Line 735: arp_standard.debug(' Validate schedule_id +');

731: IF p_mode IN ('INSERT') THEN
732: -------------------------------------
733: -- Validate schedule_id
734: -------------------------------------
735: arp_standard.debug(' Validate schedule_id +');
736: IF P_SCHEDULE_ID IS NULL OR P_SCHEDULE_ID = fnd_api.g_miss_num THEN
737: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
738: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'SCHEDULE_ID' );
739: FND_MSG_PUB.ADD;

Line 753: arp_standard.debug(' Validate schedule_id -');

749: FND_MSG_PUB.ADD;
750: x_return_status := FND_API.G_RET_STS_ERROR;
751: END IF;
752: CLOSE c_schedule_id;
753: arp_standard.debug(' Validate schedule_id -');
754:
755: --------------------------------------------------------------------------
756: -- Validate SCHEDULE_HEADER_TYPE lookup code in lookup type SCHEDULE_HEADER_TYPE
757: --------------------------------------------------------------------------

Line 758: arp_standard.debug(' Validate schedule_header_type +');

754:
755: --------------------------------------------------------------------------
756: -- Validate SCHEDULE_HEADER_TYPE lookup code in lookup type SCHEDULE_HEADER_TYPE
757: --------------------------------------------------------------------------
758: arp_standard.debug(' Validate schedule_header_type +');
759: IF p_schedule_header_type IS NULL OR p_schedule_header_type = fnd_api.g_miss_char THEN
760: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
761: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_header_type' );
762: FND_MSG_PUB.ADD;

Line 767: arp_standard.debug(' schedule type should be lookup code for the lookup type SCHEDULE_HEADER_TYPE');

763: x_return_status := FND_API.G_RET_STS_ERROR;
764: END IF;
765:
766: IF validate_lookup('SCHEDULE_HEADER_TYPE',p_schedule_header_type) = FALSE THEN
767: arp_standard.debug(' schedule type should be lookup code for the lookup type SCHEDULE_HEADER_TYPE');
768: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
769: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule header type' );
770: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'SCHEDULE_HEADER_TYPE' );
771: FND_MSG_PUB.ADD;

Line 774: arp_standard.debug(' Validate schedule_header_type -');

770: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'SCHEDULE_HEADER_TYPE' );
771: FND_MSG_PUB.ADD;
772: x_return_status := FND_API.G_RET_STS_ERROR;
773: END IF;
774: arp_standard.debug(' Validate schedule_header_type -');
775:
776:
777: -------------------------------------------------------------
778: -- Validate STATUS lookup code in lookup type REGISTRY_STATUS

Line 780: arp_standard.debug(' Validate status +');

776:
777: -------------------------------------------------------------
778: -- Validate STATUS lookup code in lookup type REGISTRY_STATUS
779: -------------------------------------------------------------
780: arp_standard.debug(' Validate status +');
781: IF p_status IS NULL OR p_status = fnd_api.g_miss_char THEN
782: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
783: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
784: FND_MSG_PUB.ADD;

Line 789: arp_standard.debug(' status should be lookup code for the lookup type REGISTRY_STATUS');

785: x_return_status := FND_API.G_RET_STS_ERROR;
786: END IF;
787:
788: IF validate_lookup('REGISTRY_STATUS',p_status) = FALSE THEN
789: arp_standard.debug(' status should be lookup code for the lookup type REGISTRY_STATUS');
790: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
791: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
792: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'REGISTRY_STATUS' );
793: FND_MSG_PUB.ADD;

Line 796: arp_standard.debug(' Validate status -');

792: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'REGISTRY_STATUS' );
793: FND_MSG_PUB.ADD;
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: END IF;
796: arp_standard.debug(' Validate status -');
797:
798:
799: -----------------------------
800: -- Validate P_AGING_BUCKET_ID

Line 802: arp_standard.debug(' validate aging_bucket +');

798:
799: -----------------------------
800: -- Validate P_AGING_BUCKET_ID
801: -----------------------------
802: arp_standard.debug(' validate aging_bucket +');
803: IF P_AGING_BUCKET_ID IS NULL OR P_AGING_BUCKET_ID = FND_API.G_MISS_NUM THEN
804: NULL;
805: ELSE
806: OPEN c_aging_bucket;

Line 818: arp_standard.debug(' validate aging_bucket -');

814: x_return_status := FND_API.G_RET_STS_ERROR;
815: END IF;
816: CLOSE c_aging_bucket;
817: END IF;
818: arp_standard.debug(' validate aging_bucket -');
819:
820:
821: ----------------------------------------------------
822: -- Validate start_date and end_date

Line 824: arp_standard.debug(' validate start and end dates +');

820:
821: ----------------------------------------------------
822: -- Validate start_date and end_date
823: ----------------------------------------------------
824: arp_standard.debug(' validate start and end dates +');
825:
826: IF p_start_date IS NULL OR p_start_date = fnd_api.g_miss_date THEN
827: arp_standard.debug(' validate start date is mandatory');
828: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

Line 827: arp_standard.debug(' validate start date is mandatory');

823: ----------------------------------------------------
824: arp_standard.debug(' validate start and end dates +');
825:
826: IF p_start_date IS NULL OR p_start_date = fnd_api.g_miss_date THEN
827: arp_standard.debug(' validate start date is mandatory');
828: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
829: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_start_date' );
830: FND_MSG_PUB.ADD;
831: x_return_status := FND_API.G_RET_STS_ERROR;

Line 838: arp_standard.debug(' end date should be greater than the start date');

834: l_val := compare(date1 => p_start_date,
835: date2 => p_end_date );
836:
837: IF l_val = 1 THEN
838: arp_standard.debug(' end date should be greater than the start date');
839: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
840: fnd_message.set_token('DATE2', 'end_date');
841: fnd_message.set_token('DATE1', 'start_date');
842: fnd_msg_pub.add;

Line 848: arp_standard.debug(' Check overlappings of periods');

844: END IF;
845:
846:
847: IF x_return_status = fnd_api.g_ret_sts_success THEN
848: arp_standard.debug(' Check overlappings of periods');
849: OPEN c_overlapp;
850: LOOP
851: FETCH c_overlapp INTO l_start_date, l_end_date;
852: EXIT WHEN c_overlapp%NOTFOUND;

Line 856: arp_standard.debug('Entered start date :'|| p_start_date ||' greater than existing end date :'||l_end_date);

852: EXIT WHEN c_overlapp%NOTFOUND;
853: l_cpt := l_cpt + 1;
854: l_val := compare(p_start_date,l_end_date);
855: IF l_val = 1 THEN
856: arp_standard.debug('Entered start date :'|| p_start_date ||' greater than existing end date :'||l_end_date);
857: ELSE
858: l_val := compare(l_start_date,p_end_date);
859: IF l_val = 1 THEN
860: arp_standard.debug('Existing start date :'|| l_start_date ||' greater than existing entered end date :'||p_end_date);

Line 860: arp_standard.debug('Existing start date :'|| l_start_date ||' greater than existing entered end date :'||p_end_date);

856: arp_standard.debug('Entered start date :'|| p_start_date ||' greater than existing end date :'||l_end_date);
857: ELSE
858: l_val := compare(l_start_date,p_end_date);
859: IF l_val = 1 THEN
860: arp_standard.debug('Existing start date :'|| l_start_date ||' greater than existing entered end date :'||p_end_date);
861: ELSE
862: arp_standard.debug(' overlapping issue :');
863: arp_standard.debug(' existing start :'||l_start_date|| ' end :'||l_end_date);
864: arp_standard.debug(' entered start :'||p_start_date|| ' end :'||p_end_date);

Line 862: arp_standard.debug(' overlapping issue :');

858: l_val := compare(l_start_date,p_end_date);
859: IF l_val = 1 THEN
860: arp_standard.debug('Existing start date :'|| l_start_date ||' greater than existing entered end date :'||p_end_date);
861: ELSE
862: arp_standard.debug(' overlapping issue :');
863: arp_standard.debug(' existing start :'||l_start_date|| ' end :'||l_end_date);
864: arp_standard.debug(' entered start :'||p_start_date|| ' end :'||p_end_date);
865: fnd_message.set_name('AR', 'AR_DATE_OVERLAPP');
866: --Int'l Calendar Project

Line 863: arp_standard.debug(' existing start :'||l_start_date|| ' end :'||l_end_date);

859: IF l_val = 1 THEN
860: arp_standard.debug('Existing start date :'|| l_start_date ||' greater than existing entered end date :'||p_end_date);
861: ELSE
862: arp_standard.debug(' overlapping issue :');
863: arp_standard.debug(' existing start :'||l_start_date|| ' end :'||l_end_date);
864: arp_standard.debug(' entered start :'||p_start_date|| ' end :'||p_end_date);
865: fnd_message.set_name('AR', 'AR_DATE_OVERLAPP');
866: --Int'l Calendar Project
867: fnd_message.set_token('START_DATE_PER_1', fnd_date.date_to_chardate(l_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));

Line 864: arp_standard.debug(' entered start :'||p_start_date|| ' end :'||p_end_date);

860: arp_standard.debug('Existing start date :'|| l_start_date ||' greater than existing entered end date :'||p_end_date);
861: ELSE
862: arp_standard.debug(' overlapping issue :');
863: arp_standard.debug(' existing start :'||l_start_date|| ' end :'||l_end_date);
864: arp_standard.debug(' entered start :'||p_start_date|| ' end :'||p_end_date);
865: fnd_message.set_name('AR', 'AR_DATE_OVERLAPP');
866: --Int'l Calendar Project
867: fnd_message.set_token('START_DATE_PER_1', fnd_date.date_to_chardate(l_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
868: fnd_message.set_token('END_DATE_PER_1' , fnd_date.date_to_chardate(l_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));

Line 881: arp_standard.debug(' validate start and end dates -');

877: END IF;
878: END LOOP;
879: CLOSE c_overlapp;
880: END IF;
881: arp_standard.debug(' validate start and end dates -');
882:
883: END IF;
884:
885:

Line 890: arp_standard.debug(' Validate status +');

886: IF p_mode IN ('UPDATE') THEN
887: -------------------------------------------------------------
888: -- Validate STATUS lookup code in lookup type REGISTRY_STATUS
889: -------------------------------------------------------------
890: arp_standard.debug(' Validate status +');
891: IF p_status = fnd_api.g_miss_char THEN
892: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
893: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
894: FND_MSG_PUB.ADD;

Line 900: arp_standard.debug(' status should be lookup code for the lookup type REGISTRY_STATUS');

896: END IF;
897:
898: IF p_status IS NOT NULL THEN
899: IF validate_lookup('REGISTRY_STATUS',p_status) = FALSE THEN
900: arp_standard.debug(' status should be lookup code for the lookup type REGISTRY_STATUS');
901: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
902: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
903: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'REGISTRY_STATUS' );
904: FND_MSG_PUB.ADD;

Line 910: arp_standard.debug(' Schedule Header can not be reactivated');

906: END IF;
907: END IF;
908:
909: IF p_old_status = 'I' AND p_status = 'A' THEN
910: arp_standard.debug(' Schedule Header can not be reactivated');
911: FND_MESSAGE.SET_NAME( 'AR', 'AR_NO_REACTIVATE_ALLOW' );
912: FND_MSG_PUB.ADD;
913: x_return_status := FND_API.G_RET_STS_ERROR;
914: END IF;

Line 916: arp_standard.debug(' Validate status -');

912: FND_MSG_PUB.ADD;
913: x_return_status := FND_API.G_RET_STS_ERROR;
914: END IF;
915:
916: arp_standard.debug(' Validate status -');
917:
918: -----------------------------------
919: -- Validate start_date and end_date
920: -----------------------------------

Line 921: arp_standard.debug(' validate start and end dates +');

917:
918: -----------------------------------
919: -- Validate start_date and end_date
920: -----------------------------------
921: arp_standard.debug(' validate start and end dates +');
922: IF p_end_date IS NOT NULL AND p_end_date <> FND_API.G_MISS_DATE THEN
923: l_val := compare(date1 => p_start_date,
924: date2 => p_end_date );
925: IF l_val = 1 THEN

Line 926: arp_standard.debug(' end date should be greater than the start date');

922: IF p_end_date IS NOT NULL AND p_end_date <> FND_API.G_MISS_DATE THEN
923: l_val := compare(date1 => p_start_date,
924: date2 => p_end_date );
925: IF l_val = 1 THEN
926: arp_standard.debug(' end date should be greater than the start date');
927: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
928: fnd_message.set_token('DATE2', 'end_date');
929: fnd_message.set_token('DATE1', 'start_date');
930: fnd_msg_pub.add;

Line 934: arp_standard.debug(' Check overlappings of periods');

930: fnd_msg_pub.add;
931: x_return_status := fnd_api.g_ret_sts_error;
932: END IF;
933: IF x_return_status = fnd_api.g_ret_sts_success THEN
934: arp_standard.debug(' Check overlappings of periods');
935: OPEN c_overlapp_upd;
936: LOOP
937: FETCH c_overlapp_upd INTO l_start_date, l_end_date;
938: EXIT WHEN c_overlapp_upd%NOTFOUND;

Line 948: arp_standard.debug(' overlapping issue :');

944: l_val := compare(l_start_date,p_end_date);
945: IF l_val = 1 THEN
946: NULL; -- Ok the existing period ends before the entered period start
947: ELSE
948: arp_standard.debug(' overlapping issue :');
949: arp_standard.debug(' existing start :'||l_start_date|| ' end :'||l_end_date);
950: arp_standard.debug(' entered start :'||p_start_date|| ' end :'||p_end_date);
951: fnd_message.set_name('AR', 'AR_DATE_OVERLAPP');
952: --Int'l Calendar Project

Line 949: arp_standard.debug(' existing start :'||l_start_date|| ' end :'||l_end_date);

945: IF l_val = 1 THEN
946: NULL; -- Ok the existing period ends before the entered period start
947: ELSE
948: arp_standard.debug(' overlapping issue :');
949: arp_standard.debug(' existing start :'||l_start_date|| ' end :'||l_end_date);
950: arp_standard.debug(' entered start :'||p_start_date|| ' end :'||p_end_date);
951: fnd_message.set_name('AR', 'AR_DATE_OVERLAPP');
952: --Int'l Calendar Project
953: fnd_message.set_token('START_DATE_PER_1', fnd_date.date_to_chardate(l_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));

Line 950: arp_standard.debug(' entered start :'||p_start_date|| ' end :'||p_end_date);

946: NULL; -- Ok the existing period ends before the entered period start
947: ELSE
948: arp_standard.debug(' overlapping issue :');
949: arp_standard.debug(' existing start :'||l_start_date|| ' end :'||l_end_date);
950: arp_standard.debug(' entered start :'||p_start_date|| ' end :'||p_end_date);
951: fnd_message.set_name('AR', 'AR_DATE_OVERLAPP');
952: --Int'l Calendar Project
953: fnd_message.set_token('START_DATE_PER_1', fnd_date.date_to_chardate(l_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
954: fnd_message.set_token('END_DATE_PER_1' , fnd_date.date_to_chardate(l_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));

Line 967: arp_standard.debug(' validate start and end dates -');

963: END IF;
964: END LOOP;
965: CLOSE c_overlapp_upd;
966: END IF;
967: arp_standard.debug(' validate start and end dates -');
968: END IF;
969: END IF;
970: arp_standard.debug('validate_schedule_header -');
971: END;

Line 970: arp_standard.debug('validate_schedule_header -');

966: END IF;
967: arp_standard.debug(' validate start and end dates -');
968: END IF;
969: END IF;
970: arp_standard.debug('validate_schedule_header -');
971: END;
972:
973:
974: PROCEDURE validate_schedule_line

Line 1028: arp_standard.debug(' Validate schedule_header_id +');

1024: BEGIN
1025: -------------------------------------
1026: -- Validate schedule_header_id
1027: -------------------------------------
1028: arp_standard.debug(' Validate schedule_header_id +');
1029:
1030: IF p_schedule_header_id IS NULL OR p_schedule_header_id = fnd_api.g_miss_num THEN
1031: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1032: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_header_id' );

Line 1048: arp_standard.debug(' Validate schedule_header_id -');

1044: FND_MSG_PUB.ADD;
1045: x_return_status := FND_API.G_RET_STS_ERROR;
1046: END IF;
1047: CLOSE c_header;
1048: arp_standard.debug(' Validate schedule_header_id -');
1049:
1050:
1051: ------------------------
1052: -- Validate schedule_id

Line 1054: arp_standard.debug(' Validate schedule_id +');

1050:
1051: ------------------------
1052: -- Validate schedule_id
1053: ------------------------
1054: arp_standard.debug(' Validate schedule_id +');
1055: IF p_schedule_id IS NULL OR p_schedule_id = fnd_api.g_miss_num THEN
1056: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1057: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_id' );
1058: FND_MSG_PUB.ADD;

Line 1070: arp_standard.debug(' Validate schedule_id -');

1066: FND_MSG_PUB.ADD;
1067: x_return_status := FND_API.G_RET_STS_ERROR;
1068: END IF;
1069: END IF;
1070: arp_standard.debug(' Validate schedule_id -');
1071:
1072:
1073: ---------------------------
1074: -- Validate aging_bucket_id

Line 1076: arp_standard.debug(' Validate aging_bucket_id +');

1072:
1073: ---------------------------
1074: -- Validate aging_bucket_id
1075: ---------------------------
1076: arp_standard.debug(' Validate aging_bucket_id +');
1077: IF P_AGING_BUCKET_ID IS NULL OR P_AGING_BUCKET_ID = fnd_api.g_miss_num THEN
1078: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1079: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_AGING_BUCKET_ID' );
1080: FND_MSG_PUB.ADD;

Line 1092: arp_standard.debug(' Validate aging_bucket_id -');

1088: FND_MSG_PUB.ADD;
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090: END IF;
1091: END IF;
1092: arp_standard.debug(' Validate aging_bucket_id -');
1093:
1094:
1095: ----------------------------------------------------
1096: -- Unidicity of the combination schedule_header_id, aging_bucket, aging_bucket_line

Line 1098: arp_standard.debug(' unidicity of ar_schedule_line_u2 +');

1094:
1095: ----------------------------------------------------
1096: -- Unidicity of the combination schedule_header_id, aging_bucket, aging_bucket_line
1097: ----------------------------------------------------
1098: arp_standard.debug(' unidicity of ar_schedule_line_u2 +');
1099: OPEN ar_schedule_line_u2(
1100: p_SCHEDULE_HEADER_ID ,
1101: p_aging_bucket_id ,
1102: p_aging_bucket_line_id);

Line 1105: arp_standard.debug(' A Record in ar_charge_schedule_lines exists with '||

1101: p_aging_bucket_id ,
1102: p_aging_bucket_line_id);
1103: FETCH ar_schedule_line_u2 INTO l_c;
1104: IF ar_schedule_line_u2%FOUND THEN
1105: arp_standard.debug(' A Record in ar_charge_schedule_lines exists with '||
1106: ' schedule_header_id - aging_bucket_id - aging_bucket_line_id');
1107: fnd_message.set_name('AR', 'AR_API_REC_COMB_EXISTS');
1108: fnd_message.set_token('COLUMN1', 'schedule_header_id');
1109: fnd_message.set_token('COLUMN2', 'aging_bucket_id');

Line 1115: arp_standard.debug(' unidicity of ar_schedule_line_u2 -');

1111: fnd_msg_pub.add;
1112: x_return_status := fnd_api.g_ret_sts_error;
1113: END IF;
1114: CLOSE ar_schedule_line_u2;
1115: arp_standard.debug(' unidicity of ar_schedule_line_u2 -');
1116:
1117:
1118: ---------------------------------
1119: -- Validate aging_bucket_line_id

Line 1121: arp_standard.debug(' Validate aging_bucket_id and aging_bucket_line_id +');

1117:
1118: ---------------------------------
1119: -- Validate aging_bucket_line_id
1120: ---------------------------------
1121: arp_standard.debug(' Validate aging_bucket_id and aging_bucket_line_id +');
1122: IF p_aging_bucket_line_id IS NULL OR p_aging_bucket_line_id = fnd_api.g_miss_num
1123: THEN
1124: IF p_aging_bucket_line_id IS NULL or p_aging_bucket_line_id = fnd_api.g_miss_num THEN
1125: arp_standard.debug(' AGING_BUCKET_LINE_ID missing');

Line 1125: arp_standard.debug(' AGING_BUCKET_LINE_ID missing');

1121: arp_standard.debug(' Validate aging_bucket_id and aging_bucket_line_id +');
1122: IF p_aging_bucket_line_id IS NULL OR p_aging_bucket_line_id = fnd_api.g_miss_num
1123: THEN
1124: IF p_aging_bucket_line_id IS NULL or p_aging_bucket_line_id = fnd_api.g_miss_num THEN
1125: arp_standard.debug(' AGING_BUCKET_LINE_ID missing');
1126: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1127: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'AGING_BUCKET_LINE_ID' );
1128: FND_MSG_PUB.ADD;
1129: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1136: arp_standard.debug(' AGING_BUCKET_ID/AGING_BUCKET_LINE_ID are not valid');

1132: IF p_aging_bucket_id IS NOT NULL AND p_aging_bucket_id <> FND_API.G_MISS_NUM THEN
1133: OPEN c_aging_bucket_id(p_aging_bucket_id, p_aging_bucket_line_id);
1134: FETCH c_aging_bucket_id INTO l_c;
1135: IF c_aging_bucket_id%NOTFOUND THEN
1136: arp_standard.debug(' AGING_BUCKET_ID/AGING_BUCKET_LINE_ID are not valid');
1137: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
1138: FND_MESSAGE.SET_TOKEN( 'FK', 'aging_bucket_id' );
1139: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'aging_bucket_id' );
1140: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_aging_buckets');

Line 1152: arp_standard.debug(' Validate aging_bucket_line_id -');

1148: END IF;
1149: CLOSE c_aging_bucket_id;
1150: END IF;
1151: END IF;
1152: arp_standard.debug(' Validate aging_bucket_line_id -');
1153:
1154:
1155:
1156: --------------------------

Line 1159: arp_standard.debug(' validate amount or rate +');

1155:
1156: --------------------------
1157: -- Validate amount or rate
1158: --------------------------
1159: arp_standard.debug(' validate amount or rate +');
1160:
1161: OPEN cl;
1162: FETCH cl INTO l_c;
1163: CLOSE cl;

Line 1168: arp_standard.debug(' The amount column is mandatory for SCHEDULE_HEADER_TYPE :'||l_c);

1164:
1165: IF (p_amount IS NULL OR p_amount = FND_API.G_MISS_NUM) AND
1166: (l_c = 'AMOUNT')
1167: THEN
1168: arp_standard.debug(' The amount column is mandatory for SCHEDULE_HEADER_TYPE :'||l_c);
1169: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
1170: fnd_message.set_token('COLUMN', 'AMOUNT');
1171: FND_MSG_PUB.ADD;
1172: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1178: arp_standard.debug(' The rate column is mandatory for SCHEDULE_HEADER_TYPE:'||l_c);

1174:
1175: IF (p_rate IS NULL OR p_rate = FND_API.G_MISS_NUM) AND
1176: (l_c = 'PERCENTAGE')
1177: THEN
1178: arp_standard.debug(' The rate column is mandatory for SCHEDULE_HEADER_TYPE:'||l_c);
1179: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
1180: fnd_message.set_token('COLUMN', 'RATE');
1181: fnd_msg_pub.add;
1182: FND_MSG_PUB.ADD;

Line 1185: arp_standard.debug(' validate amount or rate -');

1181: fnd_msg_pub.add;
1182: FND_MSG_PUB.ADD;
1183: x_return_status := FND_API.G_RET_STS_ERROR;
1184: END IF;
1185: arp_standard.debug(' validate amount or rate -');
1186: END;
1187:
1188:
1189:

Line 1225: arp_standard.debug('create_schedule +');

1221: l_schedule_id NUMBER;
1222: l_n VARCHAR2(10);
1223: BEGIN
1224: l_n := 0;
1225: arp_standard.debug('create_schedule +');
1226: arp_standard.debug(' P_SCHEDULE_NAME :'||P_SCHEDULE_NAME);
1227: arp_standard.debug(' P_SCHEDULE_DESCRIPTION :'||P_SCHEDULE_DESCRIPTION);
1228:
1229: SAVEPOINT create_schedule;

Line 1226: arp_standard.debug(' P_SCHEDULE_NAME :'||P_SCHEDULE_NAME);

1222: l_n VARCHAR2(10);
1223: BEGIN
1224: l_n := 0;
1225: arp_standard.debug('create_schedule +');
1226: arp_standard.debug(' P_SCHEDULE_NAME :'||P_SCHEDULE_NAME);
1227: arp_standard.debug(' P_SCHEDULE_DESCRIPTION :'||P_SCHEDULE_DESCRIPTION);
1228:
1229: SAVEPOINT create_schedule;
1230:

Line 1227: arp_standard.debug(' P_SCHEDULE_DESCRIPTION :'||P_SCHEDULE_DESCRIPTION);

1223: BEGIN
1224: l_n := 0;
1225: arp_standard.debug('create_schedule +');
1226: arp_standard.debug(' P_SCHEDULE_NAME :'||P_SCHEDULE_NAME);
1227: arp_standard.debug(' P_SCHEDULE_DESCRIPTION :'||P_SCHEDULE_DESCRIPTION);
1228:
1229: SAVEPOINT create_schedule;
1230:
1231: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 1286: arp_standard.debug('create_schedule -');

1282: END IF;
1283:
1284: x_schedule_id := l_schedule_id;
1285:
1286: arp_standard.debug('create_schedule -');
1287:
1288: EXCEPTION
1289: WHEN FND_API.G_EXC_ERROR THEN
1290: ROLLBACK TO create_schedule;

Line 1295: arp_standard.debug('EXCEPTION create_schedule:'||x_msg_data);

1291: FND_MSG_PUB.Count_And_Get(
1292: p_encoded => FND_API.G_FALSE,
1293: p_count => x_msg_count,
1294: p_data => x_msg_data);
1295: arp_standard.debug('EXCEPTION create_schedule:'||x_msg_data);
1296:
1297: WHEN OTHERS THEN
1298: ROLLBACK TO create_schedule;
1299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1307: arp_standard.debug('EXCEPTION create_schedule:'||x_msg_data);

1303: FND_MSG_PUB.Count_And_Get(
1304: p_encoded => FND_API.G_FALSE,
1305: p_count => x_msg_count,
1306: p_data => x_msg_data);
1307: arp_standard.debug('EXCEPTION create_schedule:'||x_msg_data);
1308: END;
1309:
1310:
1311: PROCEDURE update_schedule

Line 1362: arp_standard.debug('update_schedule +');

1358: WHERE schedule_id = P_SCHEDULE_ID
1359: FOR UPDATE NOWAIT;
1360: l_rec c%ROWTYPE;
1361: BEGIN
1362: arp_standard.debug('update_schedule +');
1363: arp_standard.debug(' P_SCHEDULE_ID :'||P_SCHEDULE_ID);
1364: arp_standard.debug(' P_SCHEDULE_DESCRIPTION :'||P_SCHEDULE_DESCRIPTION);
1365:
1366: SAVEPOINT update_schedule;

Line 1363: arp_standard.debug(' P_SCHEDULE_ID :'||P_SCHEDULE_ID);

1359: FOR UPDATE NOWAIT;
1360: l_rec c%ROWTYPE;
1361: BEGIN
1362: arp_standard.debug('update_schedule +');
1363: arp_standard.debug(' P_SCHEDULE_ID :'||P_SCHEDULE_ID);
1364: arp_standard.debug(' P_SCHEDULE_DESCRIPTION :'||P_SCHEDULE_DESCRIPTION);
1365:
1366: SAVEPOINT update_schedule;
1367:

Line 1364: arp_standard.debug(' P_SCHEDULE_DESCRIPTION :'||P_SCHEDULE_DESCRIPTION);

1360: l_rec c%ROWTYPE;
1361: BEGIN
1362: arp_standard.debug('update_schedule +');
1363: arp_standard.debug(' P_SCHEDULE_ID :'||P_SCHEDULE_ID);
1364: arp_standard.debug(' P_SCHEDULE_DESCRIPTION :'||P_SCHEDULE_DESCRIPTION);
1365:
1366: SAVEPOINT update_schedule;
1367:
1368: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1457: arp_standard.debug('Update_schedule -');

1453: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1454: RAISE fnd_api.g_exc_error;
1455: END IF;
1456:
1457: arp_standard.debug('Update_schedule -');
1458:
1459: EXCEPTION
1460: WHEN FND_API.G_EXC_ERROR THEN
1461: ROLLBACK TO Update_schedule;

Line 1466: arp_standard.debug('EXCEPTION Update_schedule:'||x_msg_data);

1462: FND_MSG_PUB.Count_And_Get(
1463: p_encoded => FND_API.G_FALSE,
1464: p_count => x_msg_count,
1465: p_data => x_msg_data);
1466: arp_standard.debug('EXCEPTION Update_schedule:'||x_msg_data);
1467:
1468: WHEN OTHERS THEN
1469: ROLLBACK TO Update_schedule;
1470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1478: arp_standard.debug('EXCEPTION Update_schedule:'||x_msg_data);

1474: FND_MSG_PUB.Count_And_Get(
1475: p_encoded => FND_API.G_FALSE,
1476: p_count => x_msg_count,
1477: p_data => x_msg_data);
1478: arp_standard.debug('EXCEPTION Update_schedule:'||x_msg_data);
1479: END;
1480:
1481:
1482:

Line 1520: arp_standard.debug('create_schedule_header +');

1516: SELECT ar_charge_schedule_hdrs_s.nextval
1517: FROM DUAL;
1518: l_header_id NUMBER;
1519: BEGIN
1520: arp_standard.debug('create_schedule_header +');
1521: arp_standard.debug(' P_SCHEDULE_HEADER_TYPE :'||P_SCHEDULE_HEADER_TYPE);
1522: arp_standard.debug(' P_AGING_BUCKET_ID :'||P_AGING_BUCKET_ID);
1523: arp_standard.debug(' p_start_date :'||p_start_date);
1524: arp_standard.debug(' p_end_date :'||p_end_date);

Line 1521: arp_standard.debug(' P_SCHEDULE_HEADER_TYPE :'||P_SCHEDULE_HEADER_TYPE);

1517: FROM DUAL;
1518: l_header_id NUMBER;
1519: BEGIN
1520: arp_standard.debug('create_schedule_header +');
1521: arp_standard.debug(' P_SCHEDULE_HEADER_TYPE :'||P_SCHEDULE_HEADER_TYPE);
1522: arp_standard.debug(' P_AGING_BUCKET_ID :'||P_AGING_BUCKET_ID);
1523: arp_standard.debug(' p_start_date :'||p_start_date);
1524: arp_standard.debug(' p_end_date :'||p_end_date);
1525:

Line 1522: arp_standard.debug(' P_AGING_BUCKET_ID :'||P_AGING_BUCKET_ID);

1518: l_header_id NUMBER;
1519: BEGIN
1520: arp_standard.debug('create_schedule_header +');
1521: arp_standard.debug(' P_SCHEDULE_HEADER_TYPE :'||P_SCHEDULE_HEADER_TYPE);
1522: arp_standard.debug(' P_AGING_BUCKET_ID :'||P_AGING_BUCKET_ID);
1523: arp_standard.debug(' p_start_date :'||p_start_date);
1524: arp_standard.debug(' p_end_date :'||p_end_date);
1525:
1526: savepoint create_schedule_header;

Line 1523: arp_standard.debug(' p_start_date :'||p_start_date);

1519: BEGIN
1520: arp_standard.debug('create_schedule_header +');
1521: arp_standard.debug(' P_SCHEDULE_HEADER_TYPE :'||P_SCHEDULE_HEADER_TYPE);
1522: arp_standard.debug(' P_AGING_BUCKET_ID :'||P_AGING_BUCKET_ID);
1523: arp_standard.debug(' p_start_date :'||p_start_date);
1524: arp_standard.debug(' p_end_date :'||p_end_date);
1525:
1526: savepoint create_schedule_header;
1527:

Line 1524: arp_standard.debug(' p_end_date :'||p_end_date);

1520: arp_standard.debug('create_schedule_header +');
1521: arp_standard.debug(' P_SCHEDULE_HEADER_TYPE :'||P_SCHEDULE_HEADER_TYPE);
1522: arp_standard.debug(' P_AGING_BUCKET_ID :'||P_AGING_BUCKET_ID);
1523: arp_standard.debug(' p_start_date :'||p_start_date);
1524: arp_standard.debug(' p_end_date :'||p_end_date);
1525:
1526: savepoint create_schedule_header;
1527:
1528: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 1590: arp_standard.debug('create_schedule_header -');

1586: END IF;
1587:
1588: x_SCHEDULE_HEADER_ID := l_header_id;
1589:
1590: arp_standard.debug('create_schedule_header -');
1591:
1592: EXCEPTION
1593: WHEN FND_API.G_EXC_ERROR THEN
1594: ROLLBACK TO create_schedule_header;

Line 1599: arp_standard.debug('EXCEPTION create_schedule_header:'||x_msg_data);

1595: FND_MSG_PUB.Count_And_Get(
1596: p_encoded => FND_API.G_FALSE,
1597: p_count => x_msg_count,
1598: p_data => x_msg_data);
1599: arp_standard.debug('EXCEPTION create_schedule_header:'||x_msg_data);
1600:
1601: WHEN OTHERS THEN
1602: ROLLBACK TO create_schedule_header;
1603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1611: arp_standard.debug('EXCEPTION create_schedule_header:'||x_msg_data);

1607: FND_MSG_PUB.Count_And_Get(
1608: p_encoded => FND_API.G_FALSE,
1609: p_count => x_msg_count,
1610: p_data => x_msg_data);
1611: arp_standard.debug('EXCEPTION create_schedule_header:'||x_msg_data);
1612: END;
1613:
1614:
1615: PROCEDURE Update_schedule_header

Line 1672: arp_standard.debug('Update_schedule_header +');

1668: FOR UPDATE NOWAIT;
1669:
1670: l_rec c%ROWTYPE;
1671: BEGIN
1672: arp_standard.debug('Update_schedule_header +');
1673: arp_standard.debug(' P_SCHEDULE_HEADER_ID :'||P_SCHEDULE_HEADER_ID);
1674: arp_standard.debug(' p_end_date :'||p_end_date);
1675: arp_standard.debug(' X_OBJECT_VERSION_NUMBER :'||X_OBJECT_VERSION_NUMBER);
1676:

Line 1673: arp_standard.debug(' P_SCHEDULE_HEADER_ID :'||P_SCHEDULE_HEADER_ID);

1669:
1670: l_rec c%ROWTYPE;
1671: BEGIN
1672: arp_standard.debug('Update_schedule_header +');
1673: arp_standard.debug(' P_SCHEDULE_HEADER_ID :'||P_SCHEDULE_HEADER_ID);
1674: arp_standard.debug(' p_end_date :'||p_end_date);
1675: arp_standard.debug(' X_OBJECT_VERSION_NUMBER :'||X_OBJECT_VERSION_NUMBER);
1676:
1677: savepoint Update_schedule_header;

Line 1674: arp_standard.debug(' p_end_date :'||p_end_date);

1670: l_rec c%ROWTYPE;
1671: BEGIN
1672: arp_standard.debug('Update_schedule_header +');
1673: arp_standard.debug(' P_SCHEDULE_HEADER_ID :'||P_SCHEDULE_HEADER_ID);
1674: arp_standard.debug(' p_end_date :'||p_end_date);
1675: arp_standard.debug(' X_OBJECT_VERSION_NUMBER :'||X_OBJECT_VERSION_NUMBER);
1676:
1677: savepoint Update_schedule_header;
1678:

Line 1675: arp_standard.debug(' X_OBJECT_VERSION_NUMBER :'||X_OBJECT_VERSION_NUMBER);

1671: BEGIN
1672: arp_standard.debug('Update_schedule_header +');
1673: arp_standard.debug(' P_SCHEDULE_HEADER_ID :'||P_SCHEDULE_HEADER_ID);
1674: arp_standard.debug(' p_end_date :'||p_end_date);
1675: arp_standard.debug(' X_OBJECT_VERSION_NUMBER :'||X_OBJECT_VERSION_NUMBER);
1676:
1677: savepoint Update_schedule_header;
1678:
1679: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1780: arp_standard.debug('Update_schedule_header -');

1776: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1777: RAISE fnd_api.g_exc_error;
1778: END IF;
1779:
1780: arp_standard.debug('Update_schedule_header -');
1781:
1782: EXCEPTION
1783: WHEN FND_API.G_EXC_ERROR THEN
1784: ROLLBACK TO Update_schedule_header;

Line 1789: arp_standard.debug('EXCEPTION Update_schedule_header:'||x_msg_data);

1785: FND_MSG_PUB.Count_And_Get(
1786: p_encoded => FND_API.G_FALSE,
1787: p_count => x_msg_count,
1788: p_data => x_msg_data);
1789: arp_standard.debug('EXCEPTION Update_schedule_header:'||x_msg_data);
1790:
1791: WHEN OTHERS THEN
1792: ROLLBACK TO Update_schedule_header;
1793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1801: arp_standard.debug('EXCEPTION Update_schedule_header:'||x_msg_data);

1797: FND_MSG_PUB.Count_And_Get(
1798: p_encoded => FND_API.G_FALSE,
1799: p_count => x_msg_count,
1800: p_data => x_msg_data);
1801: arp_standard.debug('EXCEPTION Update_schedule_header:'||x_msg_data);
1802: END;
1803:
1804:
1805:

Line 1841: arp_standard.debug('create_schedule_line +');

1837: SELECT ar_charge_schedule_lines_s.NEXTVAL
1838: FROM dual;
1839: l_line_id NUMBER;
1840: BEGIN
1841: arp_standard.debug('create_schedule_line +');
1842: arp_standard.debug(' P_SCHEDULE_HEADER_ID :'||P_SCHEDULE_HEADER_ID);
1843: arp_standard.debug(' P_SCHEDULE_ID :'||P_SCHEDULE_ID);
1844: arp_standard.debug(' P_AGING_BUCKET_ID :'||P_AGING_BUCKET_ID);
1845: arp_standard.debug(' P_AGING_BUCKET_LINE_ID :'||P_AGING_BUCKET_LINE_ID);

Line 1842: arp_standard.debug(' P_SCHEDULE_HEADER_ID :'||P_SCHEDULE_HEADER_ID);

1838: FROM dual;
1839: l_line_id NUMBER;
1840: BEGIN
1841: arp_standard.debug('create_schedule_line +');
1842: arp_standard.debug(' P_SCHEDULE_HEADER_ID :'||P_SCHEDULE_HEADER_ID);
1843: arp_standard.debug(' P_SCHEDULE_ID :'||P_SCHEDULE_ID);
1844: arp_standard.debug(' P_AGING_BUCKET_ID :'||P_AGING_BUCKET_ID);
1845: arp_standard.debug(' P_AGING_BUCKET_LINE_ID :'||P_AGING_BUCKET_LINE_ID);
1846: arp_standard.debug(' P_AMOUNT :'||P_amount);

Line 1843: arp_standard.debug(' P_SCHEDULE_ID :'||P_SCHEDULE_ID);

1839: l_line_id NUMBER;
1840: BEGIN
1841: arp_standard.debug('create_schedule_line +');
1842: arp_standard.debug(' P_SCHEDULE_HEADER_ID :'||P_SCHEDULE_HEADER_ID);
1843: arp_standard.debug(' P_SCHEDULE_ID :'||P_SCHEDULE_ID);
1844: arp_standard.debug(' P_AGING_BUCKET_ID :'||P_AGING_BUCKET_ID);
1845: arp_standard.debug(' P_AGING_BUCKET_LINE_ID :'||P_AGING_BUCKET_LINE_ID);
1846: arp_standard.debug(' P_AMOUNT :'||P_amount);
1847: arp_standard.debug(' P_RATE :'||P_RATE);

Line 1844: arp_standard.debug(' P_AGING_BUCKET_ID :'||P_AGING_BUCKET_ID);

1840: BEGIN
1841: arp_standard.debug('create_schedule_line +');
1842: arp_standard.debug(' P_SCHEDULE_HEADER_ID :'||P_SCHEDULE_HEADER_ID);
1843: arp_standard.debug(' P_SCHEDULE_ID :'||P_SCHEDULE_ID);
1844: arp_standard.debug(' P_AGING_BUCKET_ID :'||P_AGING_BUCKET_ID);
1845: arp_standard.debug(' P_AGING_BUCKET_LINE_ID :'||P_AGING_BUCKET_LINE_ID);
1846: arp_standard.debug(' P_AMOUNT :'||P_amount);
1847: arp_standard.debug(' P_RATE :'||P_RATE);
1848:

Line 1845: arp_standard.debug(' P_AGING_BUCKET_LINE_ID :'||P_AGING_BUCKET_LINE_ID);

1841: arp_standard.debug('create_schedule_line +');
1842: arp_standard.debug(' P_SCHEDULE_HEADER_ID :'||P_SCHEDULE_HEADER_ID);
1843: arp_standard.debug(' P_SCHEDULE_ID :'||P_SCHEDULE_ID);
1844: arp_standard.debug(' P_AGING_BUCKET_ID :'||P_AGING_BUCKET_ID);
1845: arp_standard.debug(' P_AGING_BUCKET_LINE_ID :'||P_AGING_BUCKET_LINE_ID);
1846: arp_standard.debug(' P_AMOUNT :'||P_amount);
1847: arp_standard.debug(' P_RATE :'||P_RATE);
1848:
1849: SAVEPOINT create_schedule_line;

Line 1846: arp_standard.debug(' P_AMOUNT :'||P_amount);

1842: arp_standard.debug(' P_SCHEDULE_HEADER_ID :'||P_SCHEDULE_HEADER_ID);
1843: arp_standard.debug(' P_SCHEDULE_ID :'||P_SCHEDULE_ID);
1844: arp_standard.debug(' P_AGING_BUCKET_ID :'||P_AGING_BUCKET_ID);
1845: arp_standard.debug(' P_AGING_BUCKET_LINE_ID :'||P_AGING_BUCKET_LINE_ID);
1846: arp_standard.debug(' P_AMOUNT :'||P_amount);
1847: arp_standard.debug(' P_RATE :'||P_RATE);
1848:
1849: SAVEPOINT create_schedule_line;
1850:

Line 1847: arp_standard.debug(' P_RATE :'||P_RATE);

1843: arp_standard.debug(' P_SCHEDULE_ID :'||P_SCHEDULE_ID);
1844: arp_standard.debug(' P_AGING_BUCKET_ID :'||P_AGING_BUCKET_ID);
1845: arp_standard.debug(' P_AGING_BUCKET_LINE_ID :'||P_AGING_BUCKET_LINE_ID);
1846: arp_standard.debug(' P_AMOUNT :'||P_amount);
1847: arp_standard.debug(' P_RATE :'||P_RATE);
1848:
1849: SAVEPOINT create_schedule_line;
1850:
1851: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 1911: arp_standard.debug('create_schedule_line -');

1907: END IF;
1908:
1909: X_SCHEDULE_LINE_ID := l_line_id;
1910:
1911: arp_standard.debug('create_schedule_line -');
1912:
1913: EXCEPTION
1914: WHEN FND_API.G_EXC_ERROR THEN
1915: ROLLBACK TO create_schedule_line;

Line 1920: arp_standard.debug('EXCEPTION create_schedule_line :'||x_msg_data);

1916: FND_MSG_PUB.Count_And_Get(
1917: p_encoded => FND_API.G_FALSE,
1918: p_count => x_msg_count,
1919: p_data => x_msg_data);
1920: arp_standard.debug('EXCEPTION create_schedule_line :'||x_msg_data);
1921:
1922: WHEN OTHERS THEN
1923: ROLLBACK TO create_schedule_line;
1924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1932: arp_standard.debug('EXCEPTION create_schedule_line :'||x_msg_data);

1928: FND_MSG_PUB.Count_And_Get(
1929: p_encoded => FND_API.G_FALSE,
1930: p_count => x_msg_count,
1931: p_data => x_msg_data);
1932: arp_standard.debug('EXCEPTION create_schedule_line :'||x_msg_data);
1933: END;
1934:
1935: PROCEDURE Update_schedule_line
1936: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

Line 1990: arp_standard.debug('Update_schedule_line +');

1986: FOR UPDATE NOWAIT;
1987:
1988: l_rec c%ROWTYPE;
1989: BEGIN
1990: arp_standard.debug('Update_schedule_line +');
1991: arp_standard.debug(' P_SCHEDULE_line_ID :'||P_SCHEDULE_line_ID);
1992: arp_standard.debug(' p_amount :'||p_amount);
1993: arp_standard.debug(' p_rate :'||p_rate);
1994: arp_standard.debug(' X_OBJECT_VERSION_NUMBER :'||X_OBJECT_VERSION_NUMBER);

Line 1991: arp_standard.debug(' P_SCHEDULE_line_ID :'||P_SCHEDULE_line_ID);

1987:
1988: l_rec c%ROWTYPE;
1989: BEGIN
1990: arp_standard.debug('Update_schedule_line +');
1991: arp_standard.debug(' P_SCHEDULE_line_ID :'||P_SCHEDULE_line_ID);
1992: arp_standard.debug(' p_amount :'||p_amount);
1993: arp_standard.debug(' p_rate :'||p_rate);
1994: arp_standard.debug(' X_OBJECT_VERSION_NUMBER :'||X_OBJECT_VERSION_NUMBER);
1995:

Line 1992: arp_standard.debug(' p_amount :'||p_amount);

1988: l_rec c%ROWTYPE;
1989: BEGIN
1990: arp_standard.debug('Update_schedule_line +');
1991: arp_standard.debug(' P_SCHEDULE_line_ID :'||P_SCHEDULE_line_ID);
1992: arp_standard.debug(' p_amount :'||p_amount);
1993: arp_standard.debug(' p_rate :'||p_rate);
1994: arp_standard.debug(' X_OBJECT_VERSION_NUMBER :'||X_OBJECT_VERSION_NUMBER);
1995:
1996: savepoint Update_schedule_line;

Line 1993: arp_standard.debug(' p_rate :'||p_rate);

1989: BEGIN
1990: arp_standard.debug('Update_schedule_line +');
1991: arp_standard.debug(' P_SCHEDULE_line_ID :'||P_SCHEDULE_line_ID);
1992: arp_standard.debug(' p_amount :'||p_amount);
1993: arp_standard.debug(' p_rate :'||p_rate);
1994: arp_standard.debug(' X_OBJECT_VERSION_NUMBER :'||X_OBJECT_VERSION_NUMBER);
1995:
1996: savepoint Update_schedule_line;
1997:

Line 1994: arp_standard.debug(' X_OBJECT_VERSION_NUMBER :'||X_OBJECT_VERSION_NUMBER);

1990: arp_standard.debug('Update_schedule_line +');
1991: arp_standard.debug(' P_SCHEDULE_line_ID :'||P_SCHEDULE_line_ID);
1992: arp_standard.debug(' p_amount :'||p_amount);
1993: arp_standard.debug(' p_rate :'||p_rate);
1994: arp_standard.debug(' X_OBJECT_VERSION_NUMBER :'||X_OBJECT_VERSION_NUMBER);
1995:
1996: savepoint Update_schedule_line;
1997:
1998: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 2096: arp_standard.debug('Update_schedule_line -');

2092: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
2093: RAISE fnd_api.g_exc_error;
2094: END IF;
2095:
2096: arp_standard.debug('Update_schedule_line -');
2097:
2098: EXCEPTION
2099: WHEN FND_API.G_EXC_ERROR THEN
2100: ROLLBACK TO Update_schedule_line;

Line 2105: arp_standard.debug('EXCEPTION Update_schedule_line:'||x_msg_data);

2101: FND_MSG_PUB.Count_And_Get(
2102: p_encoded => FND_API.G_FALSE,
2103: p_count => x_msg_count,
2104: p_data => x_msg_data);
2105: arp_standard.debug('EXCEPTION Update_schedule_line:'||x_msg_data);
2106:
2107: WHEN OTHERS THEN
2108: ROLLBACK TO Update_schedule_header;
2109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2117: arp_standard.debug('EXCEPTION Update_schedule_line:'||x_msg_data);

2113: FND_MSG_PUB.Count_And_Get(
2114: p_encoded => FND_API.G_FALSE,
2115: p_count => x_msg_count,
2116: p_data => x_msg_data);
2117: arp_standard.debug('EXCEPTION Update_schedule_line:'||x_msg_data);
2118: END;
2119:
2120:
2121: END;