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 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: fnd_message.set_token('START_DATE_PER_1', l_start_date);

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: fnd_message.set_token('START_DATE_PER_1', l_start_date);
867: fnd_message.set_token('END_DATE_PER_1' , l_end_date);

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: fnd_message.set_token('START_DATE_PER_1', l_start_date);
867: fnd_message.set_token('END_DATE_PER_1' , l_end_date);
868: fnd_message.set_token('START_DATE_PER_2', p_start_date);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

945: NULL; -- Ok the existing period ends before the entered period start
946: ELSE
947: arp_standard.debug(' overlapping issue :');
948: arp_standard.debug(' existing start :'||l_start_date|| ' end :'||l_end_date);
949: arp_standard.debug(' entered start :'||p_start_date|| ' end :'||p_end_date);
950: fnd_message.set_name('AR', 'AR_DATE_OVERLAPP');
951: fnd_message.set_token('START_DATE_PER_1', l_start_date);
952: fnd_message.set_token('END_DATE_PER_1' , l_end_date);
953: fnd_message.set_token('START_DATE_PER_2', p_start_date);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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