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_DEPOSIT_LIB_PVT dependencies on ARP_UTIL

Line 29: arp_util.debug('ar_deposit_lib_pvt.get_salesrep_name_id() +' );

25: l_default_srep_number VARCHAR2(30);
26: l_return number := 1;
27:
28: BEGIN
29: arp_util.debug('ar_deposit_lib_pvt.get_salesrep_name_id() +' );
30: SELECT name,
31: salesrep_number
32: INTO l_default_srep_name,
33: l_default_srep_number

Line 41: arp_util.debug('ar_deposit_lib_pvt.get_salesrep_name_id() -' );

37: AND p_deposit_date between nvl(start_date_active, p_deposit_date) and
38: nvl(end_date_active, p_deposit_date);
39:
40: return(p_default_salesrep_id);
41: arp_util.debug('ar_deposit_lib_pvt.get_salesrep_name_id() -' );
42: EXCEPTION
43: WHEN NO_DATA_FOUND THEN
44:
45: l_return:= -1;

Line 46: arp_util.debug('EXCEPTION :ar_deposit_lib_pvt.

42: EXCEPTION
43: WHEN NO_DATA_FOUND THEN
44:
45: l_return:= -1;
46: arp_util.debug('EXCEPTION :ar_deposit_lib_pvt.
47: get_salesrep_name_id(NO_DATA_FOUND)' );
48: return(l_return);
49: WHEN OTHERS THEN
50: l_return:= -1;

Line 51: arp_util.debug('EXCEPTION :

47: get_salesrep_name_id(NO_DATA_FOUND)' );
48: return(l_return);
49: WHEN OTHERS THEN
50: l_return:= -1;
51: arp_util.debug('EXCEPTION :
52: ar_deposit_lib_pvt.get_salesrep_name_id(OTHERS)' );
53: return(l_return);
54:
55: END;

Line 130: arp_util.debug('ar_deposit_lib_pvt.default_bill_to_contact() +' );

126: ORDER BY 1;
127:
128:
129: BEGIN
130: arp_util.debug('ar_deposit_lib_pvt.default_bill_to_contact() +' );
131: /*
132: 1) If the customer defines one contact at customer level and the contact
133: is active and not define a contact at address level, the contact at
134: customer level will default.

Line 211: arp_util.debug('ar_deposit_lib_pvt.default_bill_to_contact() -' );

207: END IF;
208: END IF;
209: p_contact_id :=l_dft_contact_id;
210:
211: arp_util.debug('ar_deposit_lib_pvt.default_bill_to_contact() -' );
212: END;
213: /*=======================================================================+
214: | PROCEDURE get_salesrep_defaults will find the defaulted salesrep
215: +=======================================================================*/

Line 237: arp_util.debug('ar_deposit_lib_pvt.get_salesrep_defaults() +' );

233: l_salesreprequiredflag VARCHAR2(1);
234:
235: BEGIN
236:
237: arp_util.debug('ar_deposit_lib_pvt.get_salesrep_defaults() +' );
238:
239: p_salesrep_id :=null;
240: begin
241: SELECT SALESREP_REQUIRED_FLAG,ORG_ID

Line 247: arp_util.debug(' profile not defined()- ');

243: FROM AR_SYSTEM_PARAMETERS;
244:
245: exception
246: when no_data_found then
247: arp_util.debug(' profile not defined()- ');
248: when others then
249: arp_util.debug(' profile others : exception ');
250: end;
251: /* **********************************************************************

Line 249: arp_util.debug(' profile others : exception ');

245: exception
246: when no_data_found then
247: arp_util.debug(' profile not defined()- ');
248: when others then
249: arp_util.debug(' profile others : exception ');
250: end;
251: /* **********************************************************************
252: Procedure:
253: Salesrep Information defaulting.

Line 296: arp_util.debug('l_default_srep_id_1 '||to_char(l_default_srep_id_1));

292:
293: IF (l_return <> -1 ) THEN
294: p_salesrep_id :=l_default_srep_id_1;
295: END IF;
296: arp_util.debug('l_default_srep_id_1 '||to_char(l_default_srep_id_1));
297: return;
298: exception
299: when no_data_found then
300: arp_util.debug('no data : l_default_srep_id_1 ');

Line 300: arp_util.debug('no data : l_default_srep_id_1 ');

296: arp_util.debug('l_default_srep_id_1 '||to_char(l_default_srep_id_1));
297: return;
298: exception
299: when no_data_found then
300: arp_util.debug('no data : l_default_srep_id_1 ');
301: l_default_srep_id_1:=null;
302: when others then
303: arp_util.debug('others : l_default_srep_id_1 ');
304: l_default_srep_id_1:=null;

Line 303: arp_util.debug('others : l_default_srep_id_1 ');

299: when no_data_found then
300: arp_util.debug('no data : l_default_srep_id_1 ');
301: l_default_srep_id_1:=null;
302: when others then
303: arp_util.debug('others : l_default_srep_id_1 ');
304: l_default_srep_id_1:=null;
305:
306: end;
307:

Line 344: arp_util.debug('l_default_srep_id_2 '||to_char(l_default_srep_id_2));

340: IF (l_return <> -1 ) THEN
341: p_salesrep_id :=l_default_srep_id_2;
342: END IF;
343:
344: arp_util.debug('l_default_srep_id_2 '||to_char(l_default_srep_id_2));
345: return;
346:
347: exception
348: when no_data_found then

Line 394: arp_util.debug('ar_deposit_lib_pvt.get_salesrep_defaults() - ' );

390: return;
391: END IF;
392:
393:
394: arp_util.debug('ar_deposit_lib_pvt.get_salesrep_defaults() - ' );
395: END get_salesrep_defaults;
396:
397: /*=======================================================================+
398: | Default_commitment_Date will find the default commitment date

Line 405: arp_util.debug('ar_deposit_lib_pvt.Default_commitment_Date() +' );

401: p_start_date_commitment IN OUT NOCOPY DATE,
402: p_end_date_commitment IN OUT NOCOPY DATE,
403: p_return_status OUT NOCOPY VARCHAR2) IS
404: BEGIN
405: arp_util.debug('ar_deposit_lib_pvt.Default_commitment_Date() +' );
406: p_return_status := FND_API.G_RET_STS_SUCCESS;
407:
408: IF p_start_date_commitment IS NULL THEN
409: p_start_date_commitment:=p_deposit_date;

Line 442: arp_util.debug('ar_deposit_lib_pvt.Default_commitment_Date() -' );

438: FND_MSG_PUB.Add;
439: p_return_status := FND_API.G_RET_STS_ERROR;
440: END IF;*/
441:
442: arp_util.debug('ar_deposit_lib_pvt.Default_commitment_Date() -' );
443: END Default_commitment_Date;
444:
445: /*=======================================================================+
446: | FUNCTION Get_Territory_id will find the default Territory_id

Line 468: arp_util.debug('ar_deposit_lib_pvt.Get_Territory_id() +' );

464: AND p_deposit_date BETWEEN NVL(st.start_date_active(+), p_deposit_date )
465: AND NVL(st.end_date_active(+), p_deposit_date );
466: BEGIN
467:
468: arp_util.debug('ar_deposit_lib_pvt.Get_Territory_id() +' );
469: p_return_status := FND_API.G_RET_STS_SUCCESS;
470: begin
471: select DEFAULT_TERRITORY
472: into l_territory_default

Line 476: arp_util.debug('System option not defined for the org');

472: into l_territory_default
473: from ar_system_parameters;
474: exception
475: when no_data_found then
476: arp_util.debug('System option not defined for the org');
477: when others then
478: arp_util.debug('EXCEPTIONS: Others system option selection');
479: end;
480:

Line 478: arp_util.debug('EXCEPTIONS: Others system option selection');

474: exception
475: when no_data_found then
476: arp_util.debug('System option not defined for the org');
477: when others then
478: arp_util.debug('EXCEPTIONS: Others system option selection');
479: end;
480:
481: IF ( l_territory_default = 'BILL' ) THEN
482: declare

Line 496: arp_util.debug('EXCEPTIONS: Others in territory_id TO SITE,');

492: exception
493: when no_data_found then
494: l_territory_id := null;
495: when others then
496: arp_util.debug('EXCEPTIONS: Others in territory_id TO SITE,');
497: end;
498:
499: ELSIF ( l_territory_default = 'SHIP' ) THEN
500: declare

Line 514: arp_util.debug('EXCEPTIONS: Others in territory_id TO SITE,');

510: exception
511: when no_data_found then
512: l_territory_id := null;
513: when others then
514: arp_util.debug('EXCEPTIONS: Others in territory_id TO SITE,');
515: end;
516:
517: ELSIF ( l_territory_default = 'SALES' ) THEN
518:

Line 529: arp_util.debug('Copied Territory_id from Salesperson') ;

525: END LOOP;
526: IF (c_salesrep_territory%ROWCOUNT > 1) THEN
527: l_territory_id :=null;
528: ELSE
529: arp_util.debug('Copied Territory_id from Salesperson') ;
530:
531: END IF;
532: close c_salesrep_territory;
533:

Line 539: arp_util.debug('ar_deposit_lib_pvt.Get_Territory_id() -' );

535:
536:
537: END IF;
538: RETURN(l_territory_id);
539: arp_util.debug('ar_deposit_lib_pvt.Get_Territory_id() -' );
540: END;
541:
542: /*=======================================================================+
543: | FUNCTION Get_Ship_Via will get Ship_Via

Line 561: arp_util.debug('ar_deposit_lib_pvt.Get_Ship_Via() +' );

557: l_Ship_Via_bill_site_default VARCHAR2(100):=NULL;
558:
559: BEGIN
560: p_return_status := FND_API.G_RET_STS_SUCCESS;
561: arp_util.debug('ar_deposit_lib_pvt.Get_Ship_Via() +' );
562:
563: IF p_ship_to_customer_id IS NOT NULL AND
564: p_ship_to_location IS NOT NULL
565: THEN

Line 581: arp_util.debug('EXCEPTIONS: Others in

577: when no_data_found then
578: l_ship_via_ship_site_default := null;
579: when others then
580: l_ship_via_ship_site_default := null;
581: arp_util.debug('EXCEPTIONS: Others in
582: SHIP TO SITE, Get_ship_via_POINT()');
583: end;
584:
585: END IF;

Line 597: arp_util.debug('EXCEPTIONS: Others in

593: when no_data_found then
594: l_ship_via_ship_default := null;
595: when others then
596: l_ship_via_ship_default := null;
597: arp_util.debug('EXCEPTIONS: Others in
598: SHIP TO Get_ship_via_POINT()');
599: end;
600: ELSE
601: RETURN(l_ship_via_ship_site_default);

Line 623: arp_util.debug('EXCEPTIONS: Others in

619: when no_data_found then
620: l_ship_via_bill_site_default := null;
621: when others then
622: l_ship_via_bill_site_default := null;
623: arp_util.debug('EXCEPTIONS: Others in
624: BILL_TO site, Get_ship_via_POINT()');
625: end;
626:
627: END IF;

Line 642: arp_util.debug('EXCEPTIONS: Others in

638: when no_data_found then
639: l_ship_via_bill_default := null;
640: when others then
641: l_ship_via_bill_default := null;
642: arp_util.debug('EXCEPTIONS: Others in
643: BILL_TO , Get_ship_via_POINT()');
644: end;
645: ELSE
646: RETURN(l_ship_via_bill_site_default);

Line 654: arp_util.debug('ar_deposit_lib_pvt.Get_Ship_Via() -' );

650: END IF;
651: --if nothing is retreived
652: RETURN(l_ship_via_bill_default);
653:
654: arp_util.debug('ar_deposit_lib_pvt.Get_Ship_Via() -' );
655:
656: END Get_Ship_Via;
657:
658: /*=======================================================================+

Line 677: arp_util.debug('ar_deposit_lib_pvt.Get_FOB_POINT() +' );

673: l_fob_bill_site_default VARCHAR2(100):=NULL;
674:
675: BEGIN
676:
677: arp_util.debug('ar_deposit_lib_pvt.Get_FOB_POINT() +' );
678: p_return_status := FND_API.G_RET_STS_SUCCESS;
679:
680: IF p_ship_to_customer_id IS NOT NULL AND
681: p_ship_to_location IS NOT NULL

Line 683: arp_util.debug('p_ship_to_customer_id IS NOT NULL

679:
680: IF p_ship_to_customer_id IS NOT NULL AND
681: p_ship_to_location IS NOT NULL
682: THEN
683: arp_util.debug('p_ship_to_customer_id IS NOT NULL
684: AND p_ship_to_location IS NOT NULL');
685: declare
686: l_Site_Use_Id number := Get_Site_Use_Id(p_ship_to_customer_id,
687: p_ship_to_location,

Line 697: arp_util.debug('no_data');

693: where site_use_id =l_Site_Use_Id ;
694:
695: exception
696: when no_data_found then
697: arp_util.debug('no_data');
698: l_fob_ship_site_default := null;
699: when others then
700: l_fob_ship_site_default := null;
701: arp_util.debug('EXCEPTIONS: Others in

Line 701: arp_util.debug('EXCEPTIONS: Others in

697: arp_util.debug('no_data');
698: l_fob_ship_site_default := null;
699: when others then
700: l_fob_ship_site_default := null;
701: arp_util.debug('EXCEPTIONS: Others in
702: SHIP TO SITE, Get_FOB_POINT()');
703: end;
704:
705: END IF;

Line 717: arp_util.debug('EXCEPTIONS: Others in SHIP TO Get_FOB_POINT()');

713: when no_data_found then
714: l_fob_ship_default := null;
715: when others then
716: l_fob_ship_default := null;
717: arp_util.debug('EXCEPTIONS: Others in SHIP TO Get_FOB_POINT()');
718: end;
719: ELSE
720: RETURN(l_fob_ship_site_default);
721: END IF;

Line 742: arp_util.debug('EXCEPTIONS: Others in

738: when no_data_found then
739: l_fob_bill_site_default := null;
740: when others then
741: l_fob_bill_site_default := null;
742: arp_util.debug('EXCEPTIONS: Others in
743: BILL_TO site, Get_FOB_POINT()');
744: end;
745:
746: END IF;

Line 761: arp_util.debug('EXCEPTIONS: Others in

757: when no_data_found then
758: l_fob_bill_default := null;
759: when others then
760: l_fob_bill_default := null;
761: arp_util.debug('EXCEPTIONS: Others in
762: BILL_TO , Get_FOB_POINT()');
763: end;
764: ELSE
765: RETURN(l_fob_bill_site_default);

Line 774: arp_util.debug('ar_deposit_lib_pvt.Get_FOB_POINT() -' );

770: --if nothing is in then
771: RETURN(l_fob_bill_default);
772:
773:
774: arp_util.debug('ar_deposit_lib_pvt.Get_FOB_POINT() -' );
775:
776: END Get_FOB_POINT;
777:
778: /*=======================================================================+

Line 790: arp_util.debug('ar_deposit_lib_pvt.GET_CONTACT_ID() +' );

786: )
787: RETURN VARCHAR2 IS
788: l_selected_id NUMBER;
789: BEGIN
790: arp_util.debug('ar_deposit_lib_pvt.GET_CONTACT_ID() +' );
791: begin
792: SELECT acct_role.cust_account_role_id
793: INTO l_selected_id
794: from hz_cust_account_roles acct_role,

Line 819: arp_util.debug('EXCEPTIONS:no data found , GET_CONTACT_ID()');

815:
816: exception
817: when no_data_found then
818: l_selected_id := null;
819: arp_util.debug('EXCEPTIONS:no data found , GET_CONTACT_ID()');
820: --that the customer site use id could not be defaulted.
821: p_return_status := FND_API.G_RET_STS_ERROR;
822: FND_MESSAGE.SET_NAME('AR','AR_DAPI_CUS_CONTACT_INVALID');
823: FND_MSG_PUB.Add;

Line 827: arp_util.debug('EXCEPTIONS: Others , GET_CONTACT_ID()');

823: FND_MSG_PUB.Add;
824:
825: when others then
826: l_selected_id := null;
827: arp_util.debug('EXCEPTIONS: Others , GET_CONTACT_ID()');
828: end;
829:
830: return(l_selected_id);
831: arp_util.debug('ar_deposit_lib_pvt.GET_CONTACT_ID() -' );

Line 831: arp_util.debug('ar_deposit_lib_pvt.GET_CONTACT_ID() -' );

827: arp_util.debug('EXCEPTIONS: Others , GET_CONTACT_ID()');
828: end;
829:
830: return(l_selected_id);
831: arp_util.debug('ar_deposit_lib_pvt.GET_CONTACT_ID() -' );
832: END GET_CONTACT_ID;
833:
834: /*=======================================================================+
835: | FUNCTION GET_ID will get GET_ID

Line 850: arp_util.debug('Get_Id()+ ');

846: l_index BINARY_INTEGER;
847:
848: BEGIN
849:
850: arp_util.debug('Get_Id()+ ');
851: l_selected_id := null;
852:
853: IF ( p_entity = 'CUSTOMER_NUMBER' )
854: THEN

Line 951: arp_util.debug('Get_Id()- ');

947:
948: END IF;
949:
950: RETURN( l_selected_id );
951: arp_util.debug('Get_Id()- ');
952: EXCEPTION
953:
954: WHEN NO_DATA_FOUND THEN
955: arp_util.debug('Value not found. Entity: ' ||

Line 955: arp_util.debug('Value not found. Entity: ' ||

951: arp_util.debug('Get_Id()- ');
952: EXCEPTION
953:
954: WHEN NO_DATA_FOUND THEN
955: arp_util.debug('Value not found. Entity: ' ||
956: p_entity ||' Value: ' || p_value);
957: return(null);
958: arp_util.debug('Get_Id()- ');
959:

Line 958: arp_util.debug('Get_Id()- ');

954: WHEN NO_DATA_FOUND THEN
955: arp_util.debug('Value not found. Entity: ' ||
956: p_entity ||' Value: ' || p_value);
957: return(null);
958: arp_util.debug('Get_Id()- ');
959:
960: WHEN OTHERS THEN
961: arp_util.debug('Value not found. Entity: ' ||
962: p_entity ||' Value: ' || p_value);

Line 961: arp_util.debug('Value not found. Entity: ' ||

957: return(null);
958: arp_util.debug('Get_Id()- ');
959:
960: WHEN OTHERS THEN
961: arp_util.debug('Value not found. Entity: ' ||
962: p_entity ||' Value: ' || p_value);
963: RAISE;
964:
965: END Get_Id;

Line 984: arp_util.debug('ar_deposit_lib_pvt.Get_Site_Use_Id() +' );

980: l_selected_id hz_cust_site_uses.site_use_id%type;
981: l_index BINARY_INTEGER;
982: BEGIN
983:
984: arp_util.debug('ar_deposit_lib_pvt.Get_Site_Use_Id() +' );
985: p_return_status := FND_API.G_RET_STS_SUCCESS;
986: IF p_customer_id IS NOT NULL THEN
987: IF (p_location IS NOT NULL) THEN
988: BEGIN

Line 1005: arp_util.debug('No data found in the hz_cust_site_uses

1001: AND site_use.status = 'A'
1002: AND site_use.location = p_location;
1003: EXCEPTION
1004: WHEN no_data_found THEN
1005: arp_util.debug('No data found in the hz_cust_site_uses
1006: for the location :'||p_location);
1007: p_return_status := FND_API.G_RET_STS_ERROR;
1008: FND_MESSAGE.SET_NAME('AR','AR_DAPI_CUS_LOC_INVALID');
1009: FND_MSG_PUB.Add;

Line 1035: arp_util.debug('No_data_found : Site use id could

1031: AND site_use.primary_flag = 'Y';
1032:
1033: EXCEPTION
1034: WHEN no_data_found THEN
1035: arp_util.debug('No_data_found : Site use id could
1036: not be defaulted for customer_id '
1037: ||to_char(p_customer_id));
1038: --This is the case where customer site use id is null
1039: --neither it was supplied by the user nor it could be defaulted

Line 1051: arp_util.debug('ar_deposit_lib_pvt.Get_Site_Use_Id() -' );

1047: END IF;
1048: END IF;
1049:
1050: RETURN( l_selected_id );
1051: arp_util.debug('ar_deposit_lib_pvt.Get_Site_Use_Id() -' );
1052: EXCEPTION
1053: WHEN others THEN
1054: arp_util.debug('EXCEPTION: Get_Site_Use_Id.');
1055: raise;

Line 1054: arp_util.debug('EXCEPTION: Get_Site_Use_Id.');

1050: RETURN( l_selected_id );
1051: arp_util.debug('ar_deposit_lib_pvt.Get_Site_Use_Id() -' );
1052: EXCEPTION
1053: WHEN others THEN
1054: arp_util.debug('EXCEPTION: Get_Site_Use_Id.');
1055: raise;
1056:
1057: END Get_Site_Use_Id;
1058:

Line 1073: arp_util.debug('ar_deposit_lib_pvt.Get_Cross_Validated_Id() +' );

1069: ) RETURN VARCHAR2 IS
1070: l_id_from_name VARCHAR2(100);
1071: l_id_from_num VARCHAR2(100);
1072: BEGIN
1073: arp_util.debug('ar_deposit_lib_pvt.Get_Cross_Validated_Id() +' );
1074: IF (p_number_value IS NULL) OR
1075: (p_name_value IS NULL)
1076: THEN
1077: RETURN(NULL);

Line 1098: arp_util.debug('ar_deposit_lib_pvt.Get_Cross_Validated_Id() -' );

1094: ELSE
1095:
1096: RETURN(NULL);
1097: END IF;
1098: arp_util.debug('ar_deposit_lib_pvt.Get_Cross_Validated_Id() -' );
1099: EXCEPTION
1100: WHEN others THEN
1101: arp_util.debug('EXCEPTION: Get_Cross_Validated_Id() '||p_entity);
1102: raise;

Line 1101: arp_util.debug('EXCEPTION: Get_Cross_Validated_Id() '||p_entity);

1097: END IF;
1098: arp_util.debug('ar_deposit_lib_pvt.Get_Cross_Validated_Id() -' );
1099: EXCEPTION
1100: WHEN others THEN
1101: arp_util.debug('EXCEPTION: Get_Cross_Validated_Id() '||p_entity);
1102: raise;
1103: END Get_Cross_Validated_Id;
1104:
1105:

Line 1119: arp_util.debug('ar_deposit_lib_pvt.Default_gl_date() +' );

1115: l_defaulting_rule_used VARCHAR2(50);
1116: l_default_gl_date DATE;
1117: BEGIN
1118: p_return_status := FND_API.G_RET_STS_SUCCESS;
1119: arp_util.debug('ar_deposit_lib_pvt.Default_gl_date() +' );
1120: IF p_gl_date IS NULL THEN
1121: IF (arp_util.validate_and_default_gl_date(
1122: p_entered_date,
1123: NULL,

Line 1121: IF (arp_util.validate_and_default_gl_date(

1117: BEGIN
1118: p_return_status := FND_API.G_RET_STS_SUCCESS;
1119: arp_util.debug('ar_deposit_lib_pvt.Default_gl_date() +' );
1120: IF p_gl_date IS NULL THEN
1121: IF (arp_util.validate_and_default_gl_date(
1122: p_entered_date,
1123: NULL,
1124: NULL,
1125: NULL,

Line 1139: arp_util.debug('Defaulted GL Date : '||to_char(p_gl_date,'DD-MON-YYYY'));

1135: l_defaulting_rule_used,
1136: l_error_message) = TRUE)
1137: THEN
1138: p_gl_date := l_default_gl_date;
1139: arp_util.debug('Defaulted GL Date : '||to_char(p_gl_date,'DD-MON-YYYY'));
1140: ELSE
1141: arp_util.debug('GL Date could not be defaulted ');
1142: -- Raise error message if failure in defaulting the gl_date
1143: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');

Line 1141: arp_util.debug('GL Date could not be defaulted ');

1137: THEN
1138: p_gl_date := l_default_gl_date;
1139: arp_util.debug('Defaulted GL Date : '||to_char(p_gl_date,'DD-MON-YYYY'));
1140: ELSE
1141: arp_util.debug('GL Date could not be defaulted ');
1142: -- Raise error message if failure in defaulting the gl_date
1143: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
1144: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', l_error_message);
1145: FND_MSG_PUB.Add;

Line 1149: arp_util.debug('ar_deposit_lib_pvt.Default_gl_date() -' );

1145: FND_MSG_PUB.Add;
1146: p_return_status := FND_API.G_RET_STS_ERROR;
1147: END IF;
1148: END IF;
1149: arp_util.debug('ar_deposit_lib_pvt.Default_gl_date() -' );
1150: END default_gl_date;
1151:
1152:
1153: /*=======================================================================+

Line 1169: arp_util.debug('ar_deposit_lib_pvt.Find_Exchange_Rate() +' );

1165: l_exchange_rate NUMBER;
1166: l_set_of_books_id NUMBER := arp_global.set_of_books_id;
1167: l_functional_currency VARCHAR2(100) := arp_global.functional_currency;
1168: BEGIN
1169: arp_util.debug('ar_deposit_lib_pvt.Find_Exchange_Rate() +' );
1170: IF (p_currency_code IS NOT NULL) AND
1171: (p_currency_code <> l_functional_currency) AND
1172: (p_exchange_rate_date IS NOT NULL) AND
1173: (p_exchange_rate_type IS NOT NULL) AND

Line 1188: arp_util.debug('ar_deposit_lib_pvt.Find_Exchange_Rate() -' );

1184: );
1185:
1186: END IF;
1187: RETURN( l_exchange_rate );
1188: arp_util.debug('ar_deposit_lib_pvt.Find_Exchange_Rate() -' );
1189: EXCEPTION
1190: WHEN gl_currency_api.NO_RATE THEN
1191: --rate does not exist set appropriate message.
1192: --p_return_status := FND_API.G_RET_STS_ERROR ;

Line 1194: arp_util.debug('Exception : gl_currency_api.NO_RATE ');

1190: WHEN gl_currency_api.NO_RATE THEN
1191: --rate does not exist set appropriate message.
1192: --p_return_status := FND_API.G_RET_STS_ERROR ;
1193: return(null);
1194: arp_util.debug('Exception : gl_currency_api.NO_RATE ');
1195: WHEN gl_currency_api.INVALID_CURRENCY THEN
1196: -- invalid currency set appropriate message.
1197: --p_return_status := FND_API.G_RET_STS_ERROR ;
1198: return(null);

Line 1199: arp_util.debug('Exception: gl_currency_api.INVALID_CURRENCY ');

1195: WHEN gl_currency_api.INVALID_CURRENCY THEN
1196: -- invalid currency set appropriate message.
1197: --p_return_status := FND_API.G_RET_STS_ERROR ;
1198: return(null);
1199: arp_util.debug('Exception: gl_currency_api.INVALID_CURRENCY ');
1200: WHEN others THEN
1201: arp_util.debug('EXCEPTION: Find_Exchange_Rate() ');
1202: raise;
1203: END Find_Exchange_Rate;

Line 1201: arp_util.debug('EXCEPTION: Find_Exchange_Rate() ');

1197: --p_return_status := FND_API.G_RET_STS_ERROR ;
1198: return(null);
1199: arp_util.debug('Exception: gl_currency_api.INVALID_CURRENCY ');
1200: WHEN others THEN
1201: arp_util.debug('EXCEPTION: Find_Exchange_Rate() ');
1202: raise;
1203: END Find_Exchange_Rate;
1204:
1205: /*=======================================================================+

Line 1220: arp_util.debug('ar_deposit_lib_pvt.Get_cross_rate() +' );

1216: l_relationship VARCHAR2(50);
1217: euro_code VARCHAR2(15);
1218: l_cross_rate NUMBER;
1219: BEGIN
1220: arp_util.debug('ar_deposit_lib_pvt.Get_cross_rate() +' );
1221: gl_currency_api.get_relation(
1222: p_from_currency,
1223: p_to_currency,
1224: trunc(p_exchange_rate_date),

Line 1253: arp_util.debug('ar_deposit_lib_pvt.Get_cross_rate() -' );

1249: p_exchange_rate_date,
1250: p_exchange_rate,
1251: l_euro_to_emu_rate);
1252: return(l_cross_rate);
1253: arp_util.debug('ar_deposit_lib_pvt.Get_cross_rate() -' );
1254: EXCEPTION
1255: WHEN gl_euro_user_rate_api.INVALID_RELATION THEN
1256: null;
1257: WHEN gl_euro_user_rate_api.INVALID_CURRENCY THEN

Line 1283: arp_util.debug('ar_deposit_lib_pvt.Default_Currency_info() +' );

1279: l_emu_to_other_prompt VARCHAR2(30);
1280: l_cross_rate NUMBER;
1281: l_conversion_rate NUMBER;
1282: BEGIN
1283: arp_util.debug('ar_deposit_lib_pvt.Default_Currency_info() +' );
1284: p_return_status := FND_API.G_RET_STS_SUCCESS;
1285:
1286: IF p_currency_code <> arp_global.functional_currency THEN
1287:

Line 1369: arp_util.debug('ar_deposit_lib_pvt.Default_Currency_info() -' );

1365: END IF; --rate type <> 'User'
1366: END IF; --if echange rate type IS NOT NULL
1367: END IF; --entered_currency <> functional currency
1368:
1369: arp_util.debug('ar_deposit_lib_pvt.Default_Currency_info() -' );
1370: EXCEPTION
1371: WHEN others THEN
1372: arp_util.debug('EXCEPTION: Default_Currency_Info() ');
1373: arp_util.debug('p_currency_code = '||p_currency_code);

Line 1372: arp_util.debug('EXCEPTION: Default_Currency_Info() ');

1368:
1369: arp_util.debug('ar_deposit_lib_pvt.Default_Currency_info() -' );
1370: EXCEPTION
1371: WHEN others THEN
1372: arp_util.debug('EXCEPTION: Default_Currency_Info() ');
1373: arp_util.debug('p_currency_code = '||p_currency_code);
1374: raise;
1375: END Default_Currency_Info;
1376:

Line 1373: arp_util.debug('p_currency_code = '||p_currency_code);

1369: arp_util.debug('ar_deposit_lib_pvt.Default_Currency_info() -' );
1370: EXCEPTION
1371: WHEN others THEN
1372: arp_util.debug('EXCEPTION: Default_Currency_Info() ');
1373: arp_util.debug('p_currency_code = '||p_currency_code);
1374: raise;
1375: END Default_Currency_Info;
1376:
1377: /*=======================================================================+

Line 1465: arp_util.debug('ar_deposit_lib_pvt.Default_deposit_ids() +' );

1461: l_dummy NUMBER;
1462: l_default_site_use varchar2(40);
1463:
1464: BEGIN
1465: arp_util.debug('ar_deposit_lib_pvt.Default_deposit_ids() +' );
1466: p_return_status := FND_API.G_RET_STS_SUCCESS;
1467: pg_deposit_date := p_deposit_date;
1468: l_bill_to_location := p_bill_to_location;
1469: l_ship_to_location := p_ship_to_location;

Line 1647: arp_util.debug('x_batch_source_id IS NULL');

1643: nvl(bs.end_date, nvl(p_deposit_date, trunc(sysdate)));
1644:
1645: exception
1646: when no_data_found then
1647: arp_util.debug('x_batch_source_id IS NULL');
1648: FND_MESSAGE.SET_NAME('AR','AR_DAPI_BS_NAME_INVALID');
1649: FND_MSG_PUB.Add;
1650: p_return_status := FND_API.G_RET_STS_ERROR;
1651:

Line 1658: arp_util.debug('x_batch_source_id IS ignored');

1654: END IF;
1655: ELSE
1656: --validate the id here or in vadidate_deposit routine
1657: IF p_batch_source_name IS NOT NULL then
1658: arp_util.debug('x_batch_source_id IS ignored');
1659: FND_MESSAGE.SET_NAME('AR','AR_DAPI_BS_NAME_IGN');
1660: FND_MSG_PUB.Add;
1661:
1662: END IF;

Line 1685: arp_util.debug('x_batch_source_id :no_data_found');

1681: nvl(p_deposit_date, trunc(sysdate)) between nvl(bs.start_date, nvl(p_deposit_date, trunc(sysdate))) and
1682: nvl(bs.end_date, nvl(p_deposit_date, trunc(sysdate)));
1683: exception
1684: when no_data_found then
1685: arp_util.debug('x_batch_source_id :no_data_found');
1686: FND_MESSAGE.SET_NAME('AR','AR_DAPI_BS_ID_INVALID');
1687: FND_MSG_PUB.Add;
1688: p_return_status := FND_API.G_RET_STS_ERROR;
1689:

Line 1830: arp_util.debug('EXCEPTION: Cache_Customer_id() ');

1826: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_ID_INVALID');
1827: FND_MSG_PUB.Add;
1828:
1829: WHEN OTHERS THEN
1830: arp_util.debug('EXCEPTION: Cache_Customer_id() ');
1831: arp_util.debug('p_customer_id = ' ||
1832: TO_CHAR(x_bill_to_customer_id));
1833: RAISE;
1834: END;

Line 1831: arp_util.debug('p_customer_id = ' ||

1827: FND_MSG_PUB.Add;
1828:
1829: WHEN OTHERS THEN
1830: arp_util.debug('EXCEPTION: Cache_Customer_id() ');
1831: arp_util.debug('p_customer_id = ' ||
1832: TO_CHAR(x_bill_to_customer_id));
1833: RAISE;
1834: END;
1835:

Line 1923: arp_util.debug('x_ship_to_customer_id = ' ||

1919: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_ID_INVALID');
1920: FND_MSG_PUB.Add;
1921:
1922: WHEN OTHERS THEN
1923: arp_util.debug('x_ship_to_customer_id = ' ||
1924: TO_CHAR(x_ship_to_customer_id));
1925: RAISE;
1926: END;
1927:

Line 2088: arp_util.debug('Bill_to_contact_id both last and

2084: ELSIF (p_bill_to_contact_first_name IS NULL and
2085: p_bill_to_contact_last_name IS NOT NULL) OR
2086: (p_bill_to_contact_first_name IS NOT NULL and
2087: p_bill_to_contact_last_name IS NULL) THEN
2088: arp_util.debug('Bill_to_contact_id both last and
2089: first name are required');
2090: FND_MESSAGE.SET_NAME('AR','AR_DAPI_BIll_CONTACT_NAME_INV');
2091: FND_MSG_PUB.Add;
2092: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2130: arp_util.debug('EXCEPTIONS: Others , GET_CONTACT_ID()');

2126: FND_MESSAGE.SET_NAME('AR','AR_DAPI_CUS_CONTACT_INVALID');
2127: FND_MSG_PUB.Add;
2128:
2129: when others then
2130: arp_util.debug('EXCEPTIONS: Others , GET_CONTACT_ID()');
2131: end;
2132:
2133: END IF;
2134:

Line 2173: arp_util.debug('Ship_to_contact_id both last and

2169: p_ship_to_contact_last_name IS NOT NULL) OR
2170: (p_ship_to_contact_first_name IS NOT NULL and
2171: p_ship_to_contact_last_name IS NULL) THEN
2172:
2173: arp_util.debug('Ship_to_contact_id both last and
2174: first name are required');
2175: FND_MESSAGE.SET_NAME('AR','AR_DAPI_SHIP_CONTACT_NAME_INV');
2176: FND_MSG_PUB.Add;
2177: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2213: arp_util.debug('EXCEPTIONS: Others , GET_CONTACT_ID()');

2209: FND_MESSAGE.SET_NAME('AR','AR_DAPI_CUS_CONTACT_INVALID');
2210: FND_MSG_PUB.Add;
2211:
2212: when others then
2213: arp_util.debug('EXCEPTIONS: Others , GET_CONTACT_ID()');
2214: end;
2215:
2216: END IF;
2217:

Line 2255: arp_util.debug('Invalid receipt method id ');

2251: WHEN no_data_found THEN
2252: p_return_status := FND_API.G_RET_STS_ERROR;
2253: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_MD_ID_INVALID');
2254: FND_MSG_PUB.Add;
2255: arp_util.debug('Invalid receipt method id ');
2256: END;
2257:
2258: END IF;
2259:

Line 2337: arp_util.debug('before x_remit_to_address');

2333: -- for remit_to_address_id
2334:
2335: l_match_site_use_id := x_bill_to_customer_site_use_id;
2336:
2337: arp_util.debug('before x_remit_to_address');
2338: IF x_remit_to_address_id is NULL THEN
2339: arp_util.debug('x_remit_to_address_id is null');
2340: IF p_cust_location_site_num is NULL AND l_match_site_use_id is NULL
2341: THEN

Line 2339: arp_util.debug('x_remit_to_address_id is null');

2335: l_match_site_use_id := x_bill_to_customer_site_use_id;
2336:
2337: arp_util.debug('before x_remit_to_address');
2338: IF x_remit_to_address_id is NULL THEN
2339: arp_util.debug('x_remit_to_address_id is null');
2340: IF p_cust_location_site_num is NULL AND l_match_site_use_id is NULL
2341: THEN
2342: arp_util.debug('p_cust_location_site_num is null, hence defaulted');
2343: begin

Line 2342: arp_util.debug('p_cust_location_site_num is null, hence defaulted');

2338: IF x_remit_to_address_id is NULL THEN
2339: arp_util.debug('x_remit_to_address_id is null');
2340: IF p_cust_location_site_num is NULL AND l_match_site_use_id is NULL
2341: THEN
2342: arp_util.debug('p_cust_location_site_num is null, hence defaulted');
2343: begin
2344: ARP_TRX_DEFAULTS_3.get_default_remit_to(l_dft_remit_to_address_id,
2345: l_dft_remit_to_address_rec);
2346: x_remit_to_address_id := l_dft_remit_to_address_id;

Line 2354: arp_util.debug('p_cust_location_site_num is not null, hence fetching');

2350: FND_MSG_PUB.Add;
2351: p_return_status := FND_API.G_RET_STS_ERROR;
2352: end;
2353: ELSE
2354: arp_util.debug('p_cust_location_site_num is not null, hence fetching');
2355: Begin
2356: ARP_TRX_DEFAULTS_3.get_remit_to_address(l_match_state,
2357: l_match_country,
2358: l_match_postal_code,

Line 2375: arp_util.debug('x_remit_to_address_id isnot null');

2371: end ;
2372:
2373: END IF;
2374: ELSE
2375: arp_util.debug('x_remit_to_address_id isnot null');
2376: IF p_cust_location_site_num is NOT NULL THEN
2377: --give a warning message to indicate that the
2378: --customer_number and customer_name
2379: --entered by the user have been ignored.

Line 2393: arp_util.debug('no_data_found in is x_remit_to_address');

2389: from ar_active_remit_to_addresses_v
2390: where address_id = x_remit_to_address_id;
2391: exception
2392: when no_data_found then
2393: arp_util.debug('no_data_found in is x_remit_to_address');
2394: FND_MESSAGE.SET_NAME('AR','AR_DAPI_REMIT_ADDR_ID_INVD');
2395: FND_MSG_PUB.Add;
2396: p_return_status := FND_API.G_RET_STS_ERROR;
2397: end;

Line 2401: arp_util.debug('after x_remit_to_address');

2397: end;
2398:
2399: END IF;
2400:
2401: arp_util.debug('after x_remit_to_address');
2402:
2403: IF (x_sold_to_customer_id IS NULL) THEN
2404:
2405: IF ( p_sold_to_customer_name IS NOT NULL and

Line 2490: arp_util.debug('EXCEPTION: sold to Customer_id() ');

2486: FND_MESSAGE.SET_NAME('AR','AR_DAPI_SOLD_CUST_ID_INVALID');
2487: FND_MSG_PUB.Add;
2488:
2489: WHEN OTHERS THEN
2490: arp_util.debug('EXCEPTION: sold to Customer_id() ');
2491: RAISE;
2492: END;
2493:
2494: END IF;

Line 2578: arp_util.debug('EXCEPTION: paying_Customer_id() ');

2574: FND_MESSAGE.SET_NAME('AR','AR_DAPI_PAY_CUST_ID_INVALID');
2575: FND_MSG_PUB.Add;
2576:
2577: WHEN OTHERS THEN
2578: arp_util.debug('EXCEPTION: paying_Customer_id() ');
2579: RAISE;
2580: END;
2581: END IF;
2582:

Line 2596: arp_util.debug('x_paying_customer_site_use_id'||

2592: nvl(p_paying_location,l_bill_to_location),
2593: 'BILL_TO',
2594: 'DRAWEE' ,l_site_use_return_status
2595: );
2596: arp_util.debug('x_paying_customer_site_use_id'||
2597: to_char(x_paying_customer_site_use_id));
2598: else
2599: --get default location of paying customer
2600: Begin

Line 2651: arp_util.debug('ar_deposit_lib_pvt.Default_deposit_ids() -' );

2647: END IF;
2648: END IF;
2649: END IF;
2650:
2651: arp_util.debug('ar_deposit_lib_pvt.Default_deposit_ids() -' );
2652: EXCEPTION
2653: WHEN others THEN
2654: arp_util.debug('EXCEPTION: ar_deposit_lib_pvt.Default_deposit_ids() +',
2655: G_MSG_UERROR);

Line 2654: arp_util.debug('EXCEPTION: ar_deposit_lib_pvt.Default_deposit_ids() +',

2650:
2651: arp_util.debug('ar_deposit_lib_pvt.Default_deposit_ids() -' );
2652: EXCEPTION
2653: WHEN others THEN
2654: arp_util.debug('EXCEPTION: ar_deposit_lib_pvt.Default_deposit_ids() +',
2655: G_MSG_UERROR);
2656: raise;
2657: END Default_deposit_ids;
2658:

Line 2688: arp_util.debug('ar_deposit_lib_pvt.Get_deposit_Defaults() +' );

2684: l_def_rm_return_status VARCHAR2(1);
2685: l_def_gl_dt_return_status VARCHAR2(1);
2686: l_def_comm_dt_return_status VARCHAR2(1);
2687: BEGIN
2688: arp_util.debug('ar_deposit_lib_pvt.Get_deposit_Defaults() +' );
2689: p_return_status := FND_API.G_RET_STS_SUCCESS;
2690: -- default the receipt date if NULL
2691: IF (p_deposit_date IS NULL)
2692: THEN

Line 2703: arp_util.debug('l_default_gl_date_return_status : '||

2699: IF p_gl_date IS NULL THEN
2700: Default_gl_date(p_deposit_date,
2701: p_gl_date,
2702: l_def_gl_dt_return_status);
2703: arp_util.debug('l_default_gl_date_return_status : '||
2704: l_def_gl_dt_return_status);
2705: END IF;
2706:
2707:

Line 2725: p_amount := arp_util.CurrRound( p_amount,

2721: );
2722:
2723: --Set the precision of the receipt amount as per currency
2724: IF p_amount is NOT NULL THEN
2725: p_amount := arp_util.CurrRound( p_amount,
2726: p_currency_code
2727: );
2728: END IF;
2729:

Line 2748: arp_util.debug('Cash Defaults********');

2744: l_def_curr_return_status <> FND_API.G_RET_STS_SUCCESS
2745: THEN
2746: p_return_status := FND_API.G_RET_STS_ERROR;
2747: END IF;
2748: arp_util.debug('************Cash Defaults********************');
2749: arp_util.debug('p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
2750: arp_util.debug('p_deposit_date : '||
2751: to_char(p_deposit_date,'DD-MON-YYYY'));
2752: arp_util.debug('p_currency_code : '||p_currency_code);

Line 2749: arp_util.debug('p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));

2745: THEN
2746: p_return_status := FND_API.G_RET_STS_ERROR;
2747: END IF;
2748: arp_util.debug('************Cash Defaults********************');
2749: arp_util.debug('p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
2750: arp_util.debug('p_deposit_date : '||
2751: to_char(p_deposit_date,'DD-MON-YYYY'));
2752: arp_util.debug('p_currency_code : '||p_currency_code);
2753: arp_util.debug('p_exchange_rate_date: '||

Line 2750: arp_util.debug('p_deposit_date : '||

2746: p_return_status := FND_API.G_RET_STS_ERROR;
2747: END IF;
2748: arp_util.debug('************Cash Defaults********************');
2749: arp_util.debug('p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
2750: arp_util.debug('p_deposit_date : '||
2751: to_char(p_deposit_date,'DD-MON-YYYY'));
2752: arp_util.debug('p_currency_code : '||p_currency_code);
2753: arp_util.debug('p_exchange_rate_date: '||
2754: to_char(p_exchange_rate_date,'DD-MON-YYYY'));

Line 2752: arp_util.debug('p_currency_code : '||p_currency_code);

2748: arp_util.debug('************Cash Defaults********************');
2749: arp_util.debug('p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
2750: arp_util.debug('p_deposit_date : '||
2751: to_char(p_deposit_date,'DD-MON-YYYY'));
2752: arp_util.debug('p_currency_code : '||p_currency_code);
2753: arp_util.debug('p_exchange_rate_date: '||
2754: to_char(p_exchange_rate_date,'DD-MON-YYYY'));
2755: arp_util.debug('p_exchange_rate_type: '||p_exchange_rate_type);
2756: arp_util.debug('p_exchange_rate : '||to_char(p_exchange_rate));

Line 2753: arp_util.debug('p_exchange_rate_date: '||

2749: arp_util.debug('p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
2750: arp_util.debug('p_deposit_date : '||
2751: to_char(p_deposit_date,'DD-MON-YYYY'));
2752: arp_util.debug('p_currency_code : '||p_currency_code);
2753: arp_util.debug('p_exchange_rate_date: '||
2754: to_char(p_exchange_rate_date,'DD-MON-YYYY'));
2755: arp_util.debug('p_exchange_rate_type: '||p_exchange_rate_type);
2756: arp_util.debug('p_exchange_rate : '||to_char(p_exchange_rate));
2757: arp_util.debug('ar_deposit_lib_pvt.Get_deposit_Defaults() -' );

Line 2755: arp_util.debug('p_exchange_rate_type: '||p_exchange_rate_type);

2751: to_char(p_deposit_date,'DD-MON-YYYY'));
2752: arp_util.debug('p_currency_code : '||p_currency_code);
2753: arp_util.debug('p_exchange_rate_date: '||
2754: to_char(p_exchange_rate_date,'DD-MON-YYYY'));
2755: arp_util.debug('p_exchange_rate_type: '||p_exchange_rate_type);
2756: arp_util.debug('p_exchange_rate : '||to_char(p_exchange_rate));
2757: arp_util.debug('ar_deposit_lib_pvt.Get_deposit_Defaults() -' );
2758: END Get_deposit_Defaults;
2759:

Line 2756: arp_util.debug('p_exchange_rate : '||to_char(p_exchange_rate));

2752: arp_util.debug('p_currency_code : '||p_currency_code);
2753: arp_util.debug('p_exchange_rate_date: '||
2754: to_char(p_exchange_rate_date,'DD-MON-YYYY'));
2755: arp_util.debug('p_exchange_rate_type: '||p_exchange_rate_type);
2756: arp_util.debug('p_exchange_rate : '||to_char(p_exchange_rate));
2757: arp_util.debug('ar_deposit_lib_pvt.Get_deposit_Defaults() -' );
2758: END Get_deposit_Defaults;
2759:
2760:

Line 2757: arp_util.debug('ar_deposit_lib_pvt.Get_deposit_Defaults() -' );

2753: arp_util.debug('p_exchange_rate_date: '||
2754: to_char(p_exchange_rate_date,'DD-MON-YYYY'));
2755: arp_util.debug('p_exchange_rate_type: '||p_exchange_rate_type);
2756: arp_util.debug('p_exchange_rate : '||to_char(p_exchange_rate));
2757: arp_util.debug('ar_deposit_lib_pvt.Get_deposit_Defaults() -' );
2758: END Get_deposit_Defaults;
2759:
2760:
2761: PROCEDURE get_doc_seq(p_application_id IN NUMBER,

Line 2780: arp_util.debug('ar_deposit_lib_pvt.get_doc_seq() +' );

2776: l_prd_tab_name VARCHAR2(50);
2777: l_aud_tab_name VARCHAR2(50);
2778: l_msg_flag VARCHAR2(1);
2779: BEGIN
2780: arp_util.debug('ar_deposit_lib_pvt.get_doc_seq() +' );
2781: arp_util.debug('SEQ : '||NVL( pg_profile_doc_seq, 'N'));
2782: arp_util.debug('p_document_name :'||p_document_name);
2783: arp_util.debug('p_application_id :'||to_char(p_application_id));
2784: arp_util.debug('p_sob_id :'||to_char(p_sob_id));

Line 2781: arp_util.debug('SEQ : '||NVL( pg_profile_doc_seq, 'N'));

2777: l_aud_tab_name VARCHAR2(50);
2778: l_msg_flag VARCHAR2(1);
2779: BEGIN
2780: arp_util.debug('ar_deposit_lib_pvt.get_doc_seq() +' );
2781: arp_util.debug('SEQ : '||NVL( pg_profile_doc_seq, 'N'));
2782: arp_util.debug('p_document_name :'||p_document_name);
2783: arp_util.debug('p_application_id :'||to_char(p_application_id));
2784: arp_util.debug('p_sob_id :'||to_char(p_sob_id));
2785: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2782: arp_util.debug('p_document_name :'||p_document_name);

2778: l_msg_flag VARCHAR2(1);
2779: BEGIN
2780: arp_util.debug('ar_deposit_lib_pvt.get_doc_seq() +' );
2781: arp_util.debug('SEQ : '||NVL( pg_profile_doc_seq, 'N'));
2782: arp_util.debug('p_document_name :'||p_document_name);
2783: arp_util.debug('p_application_id :'||to_char(p_application_id));
2784: arp_util.debug('p_sob_id :'||to_char(p_sob_id));
2785: p_return_status := FND_API.G_RET_STS_SUCCESS;
2786: IF ( NVL( pg_profile_doc_seq, 'N') <> 'N' )

Line 2783: arp_util.debug('p_application_id :'||to_char(p_application_id));

2779: BEGIN
2780: arp_util.debug('ar_deposit_lib_pvt.get_doc_seq() +' );
2781: arp_util.debug('SEQ : '||NVL( pg_profile_doc_seq, 'N'));
2782: arp_util.debug('p_document_name :'||p_document_name);
2783: arp_util.debug('p_application_id :'||to_char(p_application_id));
2784: arp_util.debug('p_sob_id :'||to_char(p_sob_id));
2785: p_return_status := FND_API.G_RET_STS_SUCCESS;
2786: IF ( NVL( pg_profile_doc_seq, 'N') <> 'N' )
2787: THEN

Line 2784: arp_util.debug('p_sob_id :'||to_char(p_sob_id));

2780: arp_util.debug('ar_deposit_lib_pvt.get_doc_seq() +' );
2781: arp_util.debug('SEQ : '||NVL( pg_profile_doc_seq, 'N'));
2782: arp_util.debug('p_document_name :'||p_document_name);
2783: arp_util.debug('p_application_id :'||to_char(p_application_id));
2784: arp_util.debug('p_sob_id :'||to_char(p_sob_id));
2785: p_return_status := FND_API.G_RET_STS_SUCCESS;
2786: IF ( NVL( pg_profile_doc_seq, 'N') <> 'N' )
2787: THEN
2788: BEGIN

Line 2809: arp_util.debug('Doc sequence return status :'||

2805: l_aud_tab_name,
2806: l_msg_flag,
2807: 'Y',
2808: 'Y');
2809: arp_util.debug('Doc sequence return status :'||
2810: to_char(nvl(l_doc_seq_ret_stat,-99)));
2811: arp_util.debug('l_doc_sequence_name :'||l_doc_sequence_name);
2812: arp_util.debug('l_doc_sequence_id :'||
2813: to_char(nvl(p_doc_sequence_id,-99)));

Line 2811: arp_util.debug('l_doc_sequence_name :'||l_doc_sequence_name);

2807: 'Y',
2808: 'Y');
2809: arp_util.debug('Doc sequence return status :'||
2810: to_char(nvl(l_doc_seq_ret_stat,-99)));
2811: arp_util.debug('l_doc_sequence_name :'||l_doc_sequence_name);
2812: arp_util.debug('l_doc_sequence_id :'||
2813: to_char(nvl(p_doc_sequence_id,-99)));
2814:
2815: IF l_doc_seq_ret_stat = -8 THEN

Line 2812: arp_util.debug('l_doc_sequence_id :'||

2808: 'Y');
2809: arp_util.debug('Doc sequence return status :'||
2810: to_char(nvl(l_doc_seq_ret_stat,-99)));
2811: arp_util.debug('l_doc_sequence_name :'||l_doc_sequence_name);
2812: arp_util.debug('l_doc_sequence_id :'||
2813: to_char(nvl(p_doc_sequence_id,-99)));
2814:
2815: IF l_doc_seq_ret_stat = -8 THEN
2816: --this is the case of Always Used

Line 2817: arp_util.debug('The doc sequence does not exist

2813: to_char(nvl(p_doc_sequence_id,-99)));
2814:
2815: IF l_doc_seq_ret_stat = -8 THEN
2816: --this is the case of Always Used
2817: arp_util.debug('The doc sequence does not exist
2818: for the current document');
2819: p_return_status := FND_API.G_RET_STS_ERROR;
2820: --Error message
2821: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_DOC_SEQ_NOT_EXIST_A');

Line 2825: arp_util.debug('The doc sequence does not exist

2821: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_DOC_SEQ_NOT_EXIST_A');
2822: FND_MSG_PUB.Add;
2823: ELSIF l_doc_seq_ret_stat = -2 THEN
2824: --this is the case of Partially Used
2825: arp_util.debug('The doc sequence does not exist
2826: for the current document');
2827: --Warning
2828: IF FND_MSG_PUB.Check_Msg_Level(G_MSG_SUCCESS)
2829: THEN

Line 2841: arp_util.debug('Automatic Document Numbering case ');

2837: THEN
2838: /*------------------------------------+
2839: | Automatic Document Numbering case |
2840: +------------------------------------*/
2841: arp_util.debug('Automatic Document Numbering case ');
2842: l_doc_seq_ret_stat :=
2843: fnd_seqnum.get_seq_val (
2844: p_application_id,
2845: p_document_name,

Line 2860: arp_util.debug('l_doc_sequence_value :'||

2856: FND_MESSAGE.Set_Name('AR', 'AR_RAPI_DOC_SEQ_AUTOMATIC');
2857: FND_MSG_PUB.Add;
2858: END IF;
2859: p_doc_sequence_value := l_doc_sequence_value;
2860: arp_util.debug('l_doc_sequence_value :'||
2861: to_char(nvl(p_doc_sequence_value,-99)));
2862: ELSIF (
2863: p_doc_sequence_id IS NOT NULL
2864: AND p_doc_sequence_value IS NOT NULL

Line 2913: arp_util.debug('no_data_found raised');

2909: | No document assignment was found. |
2910: | Generate an error if document numbering |
2911: | is mandatory. |
2912: +------------------------------------------*/
2913: arp_util.debug('no_data_found raised');
2914: IF (pg_profile_doc_seq = 'A' ) THEN
2915: p_return_status := FND_API.G_RET_STS_ERROR;
2916: FND_MESSAGE.Set_Name( 'FND','UNIQUE-ALWAYS USED');
2917: FND_MSG_PUB.Add;

Line 2924: arp_util.debug('Unhandled exception in doc sequence

2920: p_doc_sequence_value := NULL;
2921: END IF;
2922:
2923: WHEN OTHERS THEN
2924: arp_util.debug('Unhandled exception in doc sequence
2925: assignment');
2926: raise;
2927:
2928: END;

Line 2931: arp_util.debug('ar_deposit_lib_pvt.get_doc_seq() -' );

2927:
2928: END;
2929:
2930: END IF;
2931: arp_util.debug('ar_deposit_lib_pvt.get_doc_seq() -' );
2932: END get_doc_seq;
2933:
2934: PROCEDURE Validate_Desc_Flexfield(
2935: p_desc_flex_rec IN OUT NOCOPY ar_deposit_api_pub.attr_rec_type,

Line 2962: arp_util.debug('Exception : Others in get_flex_title function'|| sqlerrm);

2958:
2959: return l_flex_title;
2960: exception
2961: when others then
2962: arp_util.debug('Exception : Others in get_flex_title function'|| sqlerrm);
2963: return p_flex_name;
2964: end get_flex_title;
2965: /* End FP Bug 5467022 SPDIXIT */
2966: BEGIN

Line 2967: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() +' );

2963: return p_flex_name;
2964: end get_flex_title;
2965: /* End FP Bug 5467022 SPDIXIT */
2966: BEGIN
2967: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() +' );
2968: p_return_status := FND_API.G_RET_STS_SUCCESS;
2969:
2970: OPEN desc_flex_exists;
2971: FETCH desc_flex_exists INTO l_flex_exists;

Line 2979: arp_util.debug('attribute_category : '||p_desc_flex_rec.attribute_category);

2975: return;
2976: END IF;
2977: CLOSE desc_flex_exists;
2978: /* Start FP Bug 5467022 */
2979: arp_util.debug('attribute_category : '||p_desc_flex_rec.attribute_category);
2980: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
2981: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
2982: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
2983: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);

Line 2980: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);

2976: END IF;
2977: CLOSE desc_flex_exists;
2978: /* Start FP Bug 5467022 */
2979: arp_util.debug('attribute_category : '||p_desc_flex_rec.attribute_category);
2980: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
2981: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
2982: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
2983: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
2984: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);

Line 2981: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);

2977: CLOSE desc_flex_exists;
2978: /* Start FP Bug 5467022 */
2979: arp_util.debug('attribute_category : '||p_desc_flex_rec.attribute_category);
2980: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
2981: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
2982: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
2983: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
2984: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
2985: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);

Line 2982: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);

2978: /* Start FP Bug 5467022 */
2979: arp_util.debug('attribute_category : '||p_desc_flex_rec.attribute_category);
2980: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
2981: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
2982: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
2983: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
2984: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
2985: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
2986: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);

Line 2983: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);

2979: arp_util.debug('attribute_category : '||p_desc_flex_rec.attribute_category);
2980: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
2981: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
2982: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
2983: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
2984: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
2985: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
2986: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
2987: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);

Line 2984: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);

2980: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
2981: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
2982: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
2983: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
2984: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
2985: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
2986: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
2987: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
2988: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);

Line 2985: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);

2981: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
2982: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
2983: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
2984: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
2985: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
2986: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
2987: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
2988: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
2989: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);

Line 2986: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);

2982: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
2983: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
2984: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
2985: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
2986: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
2987: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
2988: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
2989: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
2990: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);

Line 2987: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);

2983: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
2984: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
2985: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
2986: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
2987: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
2988: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
2989: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
2990: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
2991: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);

Line 2988: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);

2984: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
2985: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
2986: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
2987: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
2988: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
2989: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
2990: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
2991: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
2992: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);

Line 2989: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);

2985: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
2986: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
2987: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
2988: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
2989: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
2990: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
2991: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
2992: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
2993: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);

Line 2990: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);

2986: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
2987: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
2988: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
2989: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
2990: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
2991: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
2992: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
2993: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
2994: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);

Line 2991: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);

2987: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
2988: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
2989: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
2990: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
2991: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
2992: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
2993: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
2994: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);
2995: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );

Line 2992: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);

2988: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
2989: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
2990: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
2991: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
2992: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
2993: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
2994: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);
2995: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );
2996:

Line 2993: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);

2989: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
2990: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
2991: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
2992: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
2993: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
2994: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);
2995: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );
2996:
2997: IF p_desc_flex_name = 'RA_CUSTOMER_TRX' THEN /* bug 5467021 if-else condition added and get_flex_title called in set_token*/

Line 2994: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);

2990: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
2991: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
2992: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
2993: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
2994: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);
2995: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );
2996:
2997: IF p_desc_flex_name = 'RA_CUSTOMER_TRX' THEN /* bug 5467021 if-else condition added and get_flex_title called in set_token*/
2998:

Line 2995: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );

2991: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
2992: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
2993: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
2994: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);
2995: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );
2996:
2997: IF p_desc_flex_name = 'RA_CUSTOMER_TRX' THEN /* bug 5467021 if-else condition added and get_flex_title called in set_token*/
2998:
2999: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);

Line 3252: arp_util.debug('attribute_category : '||p_desc_flex_rec.attribute_category);

3248:
3249: END IF;/* End p_desc_flex_name= */
3250: /* bug 5467021 ends */
3251:
3252: arp_util.debug('attribute_category : '||p_desc_flex_rec.attribute_category);
3253: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
3254: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
3255: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
3256: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);

Line 3253: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);

3249: END IF;/* End p_desc_flex_name= */
3250: /* bug 5467021 ends */
3251:
3252: arp_util.debug('attribute_category : '||p_desc_flex_rec.attribute_category);
3253: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
3254: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
3255: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
3256: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
3257: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);

Line 3254: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);

3250: /* bug 5467021 ends */
3251:
3252: arp_util.debug('attribute_category : '||p_desc_flex_rec.attribute_category);
3253: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
3254: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
3255: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
3256: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
3257: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
3258: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);

Line 3255: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);

3251:
3252: arp_util.debug('attribute_category : '||p_desc_flex_rec.attribute_category);
3253: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
3254: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
3255: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
3256: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
3257: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
3258: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
3259: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);

Line 3256: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);

3252: arp_util.debug('attribute_category : '||p_desc_flex_rec.attribute_category);
3253: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
3254: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
3255: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
3256: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
3257: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
3258: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
3259: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
3260: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);

Line 3257: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);

3253: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
3254: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
3255: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
3256: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
3257: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
3258: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
3259: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
3260: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
3261: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);

Line 3258: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);

3254: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
3255: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
3256: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
3257: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
3258: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
3259: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
3260: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
3261: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
3262: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);

Line 3259: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);

3255: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
3256: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
3257: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
3258: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
3259: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
3260: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
3261: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
3262: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
3263: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);

Line 3260: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);

3256: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
3257: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
3258: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
3259: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
3260: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
3261: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
3262: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
3263: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
3264: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);

Line 3261: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);

3257: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
3258: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
3259: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
3260: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
3261: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
3262: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
3263: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
3264: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
3265: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);

Line 3262: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);

3258: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
3259: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
3260: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
3261: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
3262: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
3263: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
3264: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
3265: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
3266: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);

Line 3263: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);

3259: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
3260: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
3261: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
3262: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
3263: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
3264: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
3265: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
3266: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
3267: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);

Line 3264: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);

3260: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
3261: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
3262: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
3263: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
3264: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
3265: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
3266: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
3267: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);
3268: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );

Line 3265: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);

3261: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
3262: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
3263: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
3264: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
3265: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
3266: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
3267: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);
3268: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );
3269: END Validate_Desc_Flexfield;

Line 3266: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);

3262: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
3263: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
3264: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
3265: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
3266: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
3267: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);
3268: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );
3269: END Validate_Desc_Flexfield;
3270:

Line 3267: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);

3263: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
3264: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
3265: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
3266: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
3267: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);
3268: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );
3269: END Validate_Desc_Flexfield;
3270:
3271: END ar_deposit_lib_pvt;

Line 3268: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );

3264: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
3265: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
3266: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
3267: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);
3268: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );
3269: END Validate_Desc_Flexfield;
3270:
3271: END ar_deposit_lib_pvt;
3272: