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 440: arp_util.debug('ar_deposit_lib_pvt.Default_commitment_Date() -' );

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1119: IF (arp_util.validate_and_default_gl_date(

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2060: ELSIF (p_bill_to_contact_first_name IS NULL and
2061: p_bill_to_contact_last_name IS NOT NULL) OR
2062: (p_bill_to_contact_first_name IS NOT NULL and
2063: p_bill_to_contact_last_name IS NULL) THEN
2064: arp_util.debug('Bill_to_contact_id both last and
2065: first name are required');
2066: FND_MESSAGE.SET_NAME('AR','AR_DAPI_BIll_CONTACT_NAME_INV');
2067: FND_MSG_PUB.Add;
2068: p_return_status := FND_API.G_RET_STS_ERROR;

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

2102: FND_MESSAGE.SET_NAME('AR','AR_DAPI_CUS_CONTACT_INVALID');
2103: FND_MSG_PUB.Add;
2104:
2105: when others then
2106: arp_util.debug('EXCEPTIONS: Others , GET_CONTACT_ID()');
2107: end;
2108:
2109: END IF;
2110:

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

2145: p_ship_to_contact_last_name IS NOT NULL) OR
2146: (p_ship_to_contact_first_name IS NOT NULL and
2147: p_ship_to_contact_last_name IS NULL) THEN
2148:
2149: arp_util.debug('Ship_to_contact_id both last and
2150: first name are required');
2151: FND_MESSAGE.SET_NAME('AR','AR_DAPI_SHIP_CONTACT_NAME_INV');
2152: FND_MSG_PUB.Add;
2153: p_return_status := FND_API.G_RET_STS_ERROR;

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

2185: FND_MESSAGE.SET_NAME('AR','AR_DAPI_CUS_CONTACT_INVALID');
2186: FND_MSG_PUB.Add;
2187:
2188: when others then
2189: arp_util.debug('EXCEPTIONS: Others , GET_CONTACT_ID()');
2190: end;
2191:
2192: END IF;
2193:

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

2227: WHEN no_data_found THEN
2228: p_return_status := FND_API.G_RET_STS_ERROR;
2229: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_MD_ID_INVALID');
2230: FND_MSG_PUB.Add;
2231: arp_util.debug('Invalid receipt method id ');
2232: END;
2233:
2234: END IF;
2235:

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

2307: END IF;
2308:
2309: -- for remit_to_address_id
2310:
2311: arp_util.debug('before x_remit_to_address');
2312: IF x_remit_to_address_id is NULL THEN
2313: arp_util.debug('x_remit_to_address_id is null');
2314: IF p_cust_location_site_num is NULL
2315: THEN

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

2309: -- for remit_to_address_id
2310:
2311: arp_util.debug('before x_remit_to_address');
2312: IF x_remit_to_address_id is NULL THEN
2313: arp_util.debug('x_remit_to_address_id is null');
2314: IF p_cust_location_site_num is NULL
2315: THEN
2316: arp_util.debug('p_cust_location_site_num is null, hence defaulted');
2317: begin

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

2312: IF x_remit_to_address_id is NULL THEN
2313: arp_util.debug('x_remit_to_address_id is null');
2314: IF p_cust_location_site_num is NULL
2315: THEN
2316: arp_util.debug('p_cust_location_site_num is null, hence defaulted');
2317: begin
2318: ARP_TRX_DEFAULTS_3.get_default_remit_to(l_dft_remit_to_address_id,
2319: l_dft_remit_to_address_rec);
2320: x_remit_to_address_id := l_dft_remit_to_address_id;

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

2324: FND_MSG_PUB.Add;
2325: p_return_status := FND_API.G_RET_STS_ERROR;
2326: end;
2327: ELSE
2328: arp_util.debug('p_cust_location_site_num is not null, hence fetching');
2329: Begin
2330: ARP_TRX_DEFAULTS_3.get_remit_to_address(l_match_state,
2331: l_match_country,
2332: l_match_postal_code,

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

2345: end ;
2346:
2347: END IF;
2348: ELSE
2349: arp_util.debug('x_remit_to_address_id isnot null');
2350: IF p_cust_location_site_num is NOT NULL THEN
2351: --give a warning message to indicate that the
2352: --customer_number and customer_name
2353: --entered by the user have been ignored.

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

2363: from ar_active_remit_to_addresses_v
2364: where address_id = x_remit_to_address_id;
2365: exception
2366: when no_data_found then
2367: arp_util.debug('no_data_found in is x_remit_to_address');
2368: FND_MESSAGE.SET_NAME('AR','AR_DAPI_REMIT_ADDR_ID_INVD');
2369: FND_MSG_PUB.Add;
2370: p_return_status := FND_API.G_RET_STS_ERROR;
2371: end;

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

2371: end;
2372:
2373: END IF;
2374:
2375: arp_util.debug('after x_remit_to_address');
2376:
2377: IF (x_sold_to_customer_id IS NULL) THEN
2378:
2379: IF ( p_sold_to_customer_name IS NOT NULL and

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

2460: FND_MESSAGE.SET_NAME('AR','AR_DAPI_SOLD_CUST_ID_INVALID');
2461: FND_MSG_PUB.Add;
2462:
2463: WHEN OTHERS THEN
2464: arp_util.debug('EXCEPTION: sold to Customer_id() ');
2465: RAISE;
2466: END;
2467:
2468: END IF;

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

2548: FND_MESSAGE.SET_NAME('AR','AR_DAPI_PAY_CUST_ID_INVALID');
2549: FND_MSG_PUB.Add;
2550:
2551: WHEN OTHERS THEN
2552: arp_util.debug('EXCEPTION: paying_Customer_id() ');
2553: RAISE;
2554: END;
2555: END IF;
2556:

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

2566: nvl(p_paying_location,l_bill_to_location),
2567: 'BILL_TO',
2568: 'DRAWEE' ,l_site_use_return_status
2569: );
2570: arp_util.debug('x_paying_customer_site_use_id'||
2571: to_char(x_paying_customer_site_use_id));
2572: else
2573: --get default location of paying customer
2574: Begin

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

2621: END IF;
2622: END IF;
2623: END IF;
2624:
2625: arp_util.debug('ar_deposit_lib_pvt.Default_deposit_ids() -' );
2626: EXCEPTION
2627: WHEN others THEN
2628: arp_util.debug('EXCEPTION: ar_deposit_lib_pvt.Default_deposit_ids() +',
2629: G_MSG_UERROR);

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

2624:
2625: arp_util.debug('ar_deposit_lib_pvt.Default_deposit_ids() -' );
2626: EXCEPTION
2627: WHEN others THEN
2628: arp_util.debug('EXCEPTION: ar_deposit_lib_pvt.Default_deposit_ids() +',
2629: G_MSG_UERROR);
2630: raise;
2631: END Default_deposit_ids;
2632:

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

2658: l_def_rm_return_status VARCHAR2(1);
2659: l_def_gl_dt_return_status VARCHAR2(1);
2660: l_def_comm_dt_return_status VARCHAR2(1);
2661: BEGIN
2662: arp_util.debug('ar_deposit_lib_pvt.Get_deposit_Defaults() +' );
2663: p_return_status := FND_API.G_RET_STS_SUCCESS;
2664: -- default the receipt date if NULL
2665: IF (p_deposit_date IS NULL)
2666: THEN

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

2673: IF p_gl_date IS NULL THEN
2674: Default_gl_date(p_deposit_date,
2675: p_gl_date,
2676: l_def_gl_dt_return_status);
2677: arp_util.debug('l_default_gl_date_return_status : '||
2678: l_def_gl_dt_return_status);
2679: END IF;
2680:
2681:

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

2695: );
2696:
2697: --Set the precision of the receipt amount as per currency
2698: IF p_amount is NOT NULL THEN
2699: p_amount := arp_util.CurrRound( p_amount,
2700: p_currency_code
2701: );
2702: END IF;
2703:

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

2718: l_def_curr_return_status <> FND_API.G_RET_STS_SUCCESS
2719: THEN
2720: p_return_status := FND_API.G_RET_STS_ERROR;
2721: END IF;
2722: arp_util.debug('************Cash Defaults********************');
2723: arp_util.debug('p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
2724: arp_util.debug('p_deposit_date : '||
2725: to_char(p_deposit_date,'DD-MON-YYYY'));
2726: arp_util.debug('p_currency_code : '||p_currency_code);

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

2719: THEN
2720: p_return_status := FND_API.G_RET_STS_ERROR;
2721: END IF;
2722: arp_util.debug('************Cash Defaults********************');
2723: arp_util.debug('p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
2724: arp_util.debug('p_deposit_date : '||
2725: to_char(p_deposit_date,'DD-MON-YYYY'));
2726: arp_util.debug('p_currency_code : '||p_currency_code);
2727: arp_util.debug('p_exchange_rate_date: '||

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

2720: p_return_status := FND_API.G_RET_STS_ERROR;
2721: END IF;
2722: arp_util.debug('************Cash Defaults********************');
2723: arp_util.debug('p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
2724: arp_util.debug('p_deposit_date : '||
2725: to_char(p_deposit_date,'DD-MON-YYYY'));
2726: arp_util.debug('p_currency_code : '||p_currency_code);
2727: arp_util.debug('p_exchange_rate_date: '||
2728: to_char(p_exchange_rate_date,'DD-MON-YYYY'));

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

2722: arp_util.debug('************Cash Defaults********************');
2723: arp_util.debug('p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
2724: arp_util.debug('p_deposit_date : '||
2725: to_char(p_deposit_date,'DD-MON-YYYY'));
2726: arp_util.debug('p_currency_code : '||p_currency_code);
2727: arp_util.debug('p_exchange_rate_date: '||
2728: to_char(p_exchange_rate_date,'DD-MON-YYYY'));
2729: arp_util.debug('p_exchange_rate_type: '||p_exchange_rate_type);
2730: arp_util.debug('p_exchange_rate : '||to_char(p_exchange_rate));

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

2723: arp_util.debug('p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
2724: arp_util.debug('p_deposit_date : '||
2725: to_char(p_deposit_date,'DD-MON-YYYY'));
2726: arp_util.debug('p_currency_code : '||p_currency_code);
2727: arp_util.debug('p_exchange_rate_date: '||
2728: to_char(p_exchange_rate_date,'DD-MON-YYYY'));
2729: arp_util.debug('p_exchange_rate_type: '||p_exchange_rate_type);
2730: arp_util.debug('p_exchange_rate : '||to_char(p_exchange_rate));
2731: arp_util.debug('ar_deposit_lib_pvt.Get_deposit_Defaults() -' );

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

2725: to_char(p_deposit_date,'DD-MON-YYYY'));
2726: arp_util.debug('p_currency_code : '||p_currency_code);
2727: arp_util.debug('p_exchange_rate_date: '||
2728: to_char(p_exchange_rate_date,'DD-MON-YYYY'));
2729: arp_util.debug('p_exchange_rate_type: '||p_exchange_rate_type);
2730: arp_util.debug('p_exchange_rate : '||to_char(p_exchange_rate));
2731: arp_util.debug('ar_deposit_lib_pvt.Get_deposit_Defaults() -' );
2732: END Get_deposit_Defaults;
2733:

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

2726: arp_util.debug('p_currency_code : '||p_currency_code);
2727: arp_util.debug('p_exchange_rate_date: '||
2728: to_char(p_exchange_rate_date,'DD-MON-YYYY'));
2729: arp_util.debug('p_exchange_rate_type: '||p_exchange_rate_type);
2730: arp_util.debug('p_exchange_rate : '||to_char(p_exchange_rate));
2731: arp_util.debug('ar_deposit_lib_pvt.Get_deposit_Defaults() -' );
2732: END Get_deposit_Defaults;
2733:
2734:

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

2727: arp_util.debug('p_exchange_rate_date: '||
2728: to_char(p_exchange_rate_date,'DD-MON-YYYY'));
2729: arp_util.debug('p_exchange_rate_type: '||p_exchange_rate_type);
2730: arp_util.debug('p_exchange_rate : '||to_char(p_exchange_rate));
2731: arp_util.debug('ar_deposit_lib_pvt.Get_deposit_Defaults() -' );
2732: END Get_deposit_Defaults;
2733:
2734:
2735: PROCEDURE get_doc_seq(p_application_id IN NUMBER,

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

2750: l_prd_tab_name VARCHAR2(50);
2751: l_aud_tab_name VARCHAR2(50);
2752: l_msg_flag VARCHAR2(1);
2753: BEGIN
2754: arp_util.debug('ar_deposit_lib_pvt.get_doc_seq() +' );
2755: arp_util.debug('SEQ : '||NVL( pg_profile_doc_seq, 'N'));
2756: arp_util.debug('p_document_name :'||p_document_name);
2757: arp_util.debug('p_application_id :'||to_char(p_application_id));
2758: arp_util.debug('p_sob_id :'||to_char(p_sob_id));

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

2751: l_aud_tab_name VARCHAR2(50);
2752: l_msg_flag VARCHAR2(1);
2753: BEGIN
2754: arp_util.debug('ar_deposit_lib_pvt.get_doc_seq() +' );
2755: arp_util.debug('SEQ : '||NVL( pg_profile_doc_seq, 'N'));
2756: arp_util.debug('p_document_name :'||p_document_name);
2757: arp_util.debug('p_application_id :'||to_char(p_application_id));
2758: arp_util.debug('p_sob_id :'||to_char(p_sob_id));
2759: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

2752: l_msg_flag VARCHAR2(1);
2753: BEGIN
2754: arp_util.debug('ar_deposit_lib_pvt.get_doc_seq() +' );
2755: arp_util.debug('SEQ : '||NVL( pg_profile_doc_seq, 'N'));
2756: arp_util.debug('p_document_name :'||p_document_name);
2757: arp_util.debug('p_application_id :'||to_char(p_application_id));
2758: arp_util.debug('p_sob_id :'||to_char(p_sob_id));
2759: p_return_status := FND_API.G_RET_STS_SUCCESS;
2760: IF ( NVL( pg_profile_doc_seq, 'N') <> 'N' )

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

2753: BEGIN
2754: arp_util.debug('ar_deposit_lib_pvt.get_doc_seq() +' );
2755: arp_util.debug('SEQ : '||NVL( pg_profile_doc_seq, 'N'));
2756: arp_util.debug('p_document_name :'||p_document_name);
2757: arp_util.debug('p_application_id :'||to_char(p_application_id));
2758: arp_util.debug('p_sob_id :'||to_char(p_sob_id));
2759: p_return_status := FND_API.G_RET_STS_SUCCESS;
2760: IF ( NVL( pg_profile_doc_seq, 'N') <> 'N' )
2761: THEN

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

2754: arp_util.debug('ar_deposit_lib_pvt.get_doc_seq() +' );
2755: arp_util.debug('SEQ : '||NVL( pg_profile_doc_seq, 'N'));
2756: arp_util.debug('p_document_name :'||p_document_name);
2757: arp_util.debug('p_application_id :'||to_char(p_application_id));
2758: arp_util.debug('p_sob_id :'||to_char(p_sob_id));
2759: p_return_status := FND_API.G_RET_STS_SUCCESS;
2760: IF ( NVL( pg_profile_doc_seq, 'N') <> 'N' )
2761: THEN
2762: BEGIN

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

2779: l_aud_tab_name,
2780: l_msg_flag,
2781: 'Y',
2782: 'Y');
2783: arp_util.debug('Doc sequence return status :'||
2784: to_char(nvl(l_doc_seq_ret_stat,-99)));
2785: arp_util.debug('l_doc_sequence_name :'||l_doc_sequence_name);
2786: arp_util.debug('l_doc_sequence_id :'||
2787: to_char(nvl(p_doc_sequence_id,-99)));

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

2781: 'Y',
2782: 'Y');
2783: arp_util.debug('Doc sequence return status :'||
2784: to_char(nvl(l_doc_seq_ret_stat,-99)));
2785: arp_util.debug('l_doc_sequence_name :'||l_doc_sequence_name);
2786: arp_util.debug('l_doc_sequence_id :'||
2787: to_char(nvl(p_doc_sequence_id,-99)));
2788:
2789: IF l_doc_seq_ret_stat = -8 THEN

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

2782: 'Y');
2783: arp_util.debug('Doc sequence return status :'||
2784: to_char(nvl(l_doc_seq_ret_stat,-99)));
2785: arp_util.debug('l_doc_sequence_name :'||l_doc_sequence_name);
2786: arp_util.debug('l_doc_sequence_id :'||
2787: to_char(nvl(p_doc_sequence_id,-99)));
2788:
2789: IF l_doc_seq_ret_stat = -8 THEN
2790: --this is the case of Always Used

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

2787: to_char(nvl(p_doc_sequence_id,-99)));
2788:
2789: IF l_doc_seq_ret_stat = -8 THEN
2790: --this is the case of Always Used
2791: arp_util.debug('The doc sequence does not exist
2792: for the current document');
2793: p_return_status := FND_API.G_RET_STS_ERROR;
2794: --Error message
2795: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_DOC_SEQ_NOT_EXIST_A');

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

2795: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_DOC_SEQ_NOT_EXIST_A');
2796: FND_MSG_PUB.Add;
2797: ELSIF l_doc_seq_ret_stat = -2 THEN
2798: --this is the case of Partially Used
2799: arp_util.debug('The doc sequence does not exist
2800: for the current document');
2801: --Warning
2802: IF FND_MSG_PUB.Check_Msg_Level(G_MSG_SUCCESS)
2803: THEN

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

2811: THEN
2812: /*------------------------------------+
2813: | Automatic Document Numbering case |
2814: +------------------------------------*/
2815: arp_util.debug('Automatic Document Numbering case ');
2816: l_doc_seq_ret_stat :=
2817: fnd_seqnum.get_seq_val (
2818: p_application_id,
2819: p_document_name,

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

2830: FND_MESSAGE.Set_Name('AR', 'AR_RAPI_DOC_SEQ_AUTOMATIC');
2831: FND_MSG_PUB.Add;
2832: END IF;
2833: p_doc_sequence_value := l_doc_sequence_value;
2834: arp_util.debug('l_doc_sequence_value :'||
2835: to_char(nvl(p_doc_sequence_value,-99)));
2836: ELSIF (
2837: p_doc_sequence_id IS NOT NULL
2838: AND p_doc_sequence_value IS NOT NULL

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

2883: | No document assignment was found. |
2884: | Generate an error if document numbering |
2885: | is mandatory. |
2886: +------------------------------------------*/
2887: arp_util.debug('no_data_found raised');
2888: IF (pg_profile_doc_seq = 'A' ) THEN
2889: p_return_status := FND_API.G_RET_STS_ERROR;
2890: FND_MESSAGE.Set_Name( 'FND','UNIQUE-ALWAYS USED');
2891: FND_MSG_PUB.Add;

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

2894: p_doc_sequence_value := NULL;
2895: END IF;
2896:
2897: WHEN OTHERS THEN
2898: arp_util.debug('Unhandled exception in doc sequence
2899: assignment');
2900: raise;
2901:
2902: END;

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

2901:
2902: END;
2903:
2904: END IF;
2905: arp_util.debug('ar_deposit_lib_pvt.get_doc_seq() -' );
2906: END get_doc_seq;
2907:
2908: PROCEDURE Validate_Desc_Flexfield(
2909: p_desc_flex_rec IN OUT NOCOPY ar_deposit_api_pub.attr_rec_type,

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

2932:
2933: return l_flex_title;
2934: exception
2935: when others then
2936: arp_util.debug('Exception : Others in get_flex_title function'|| sqlerrm);
2937: return p_flex_name;
2938: end get_flex_title;
2939: /* End FP Bug 5467022 SPDIXIT */
2940: BEGIN

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

2937: return p_flex_name;
2938: end get_flex_title;
2939: /* End FP Bug 5467022 SPDIXIT */
2940: BEGIN
2941: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() +' );
2942: p_return_status := FND_API.G_RET_STS_SUCCESS;
2943:
2944: OPEN desc_flex_exists;
2945: FETCH desc_flex_exists INTO l_flex_exists;

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

2949: return;
2950: END IF;
2951: CLOSE desc_flex_exists;
2952: /* Start FP Bug 5467022 */
2953: arp_util.debug('attribute_category : '||p_desc_flex_rec.attribute_category);
2954: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
2955: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
2956: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
2957: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);

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

2950: END IF;
2951: CLOSE desc_flex_exists;
2952: /* Start FP Bug 5467022 */
2953: arp_util.debug('attribute_category : '||p_desc_flex_rec.attribute_category);
2954: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
2955: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
2956: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
2957: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
2958: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);

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

2951: CLOSE desc_flex_exists;
2952: /* Start FP Bug 5467022 */
2953: arp_util.debug('attribute_category : '||p_desc_flex_rec.attribute_category);
2954: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
2955: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
2956: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
2957: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
2958: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
2959: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);

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

2952: /* Start FP Bug 5467022 */
2953: arp_util.debug('attribute_category : '||p_desc_flex_rec.attribute_category);
2954: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
2955: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
2956: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
2957: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
2958: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
2959: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
2960: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);

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

2953: arp_util.debug('attribute_category : '||p_desc_flex_rec.attribute_category);
2954: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
2955: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
2956: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
2957: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
2958: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
2959: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
2960: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
2961: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);

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

2954: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
2955: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
2956: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
2957: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
2958: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
2959: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
2960: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
2961: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
2962: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);

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

2955: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
2956: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
2957: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
2958: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
2959: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
2960: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
2961: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
2962: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
2963: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);

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

2956: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
2957: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
2958: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
2959: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
2960: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
2961: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
2962: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
2963: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
2964: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);

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

2957: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
2958: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
2959: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
2960: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
2961: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
2962: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
2963: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
2964: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
2965: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);

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

2958: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
2959: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
2960: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
2961: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
2962: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
2963: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
2964: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
2965: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
2966: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);

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

2959: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
2960: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
2961: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
2962: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
2963: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
2964: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
2965: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
2966: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
2967: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);

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

2960: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
2961: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
2962: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
2963: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
2964: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
2965: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
2966: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
2967: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
2968: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);

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

2961: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
2962: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
2963: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
2964: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
2965: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
2966: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
2967: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
2968: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);
2969: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );

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

2962: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
2963: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
2964: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
2965: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
2966: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
2967: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
2968: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);
2969: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );
2970:

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

2963: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
2964: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
2965: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
2966: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
2967: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
2968: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);
2969: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );
2970:
2971: IF p_desc_flex_name = 'RA_CUSTOMER_TRX' THEN /* bug 5467021 if-else condition added and get_flex_title called in set_token*/

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

2964: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
2965: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
2966: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
2967: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
2968: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);
2969: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );
2970:
2971: IF p_desc_flex_name = 'RA_CUSTOMER_TRX' THEN /* bug 5467021 if-else condition added and get_flex_title called in set_token*/
2972:

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

2965: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
2966: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
2967: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
2968: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);
2969: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );
2970:
2971: IF p_desc_flex_name = 'RA_CUSTOMER_TRX' THEN /* bug 5467021 if-else condition added and get_flex_title called in set_token*/
2972:
2973: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);

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

3222:
3223: END IF;/* End p_desc_flex_name= */
3224: /* bug 5467021 ends */
3225:
3226: arp_util.debug('attribute_category : '||p_desc_flex_rec.attribute_category);
3227: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
3228: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
3229: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
3230: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);

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

3223: END IF;/* End p_desc_flex_name= */
3224: /* bug 5467021 ends */
3225:
3226: arp_util.debug('attribute_category : '||p_desc_flex_rec.attribute_category);
3227: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
3228: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
3229: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
3230: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
3231: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);

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

3224: /* bug 5467021 ends */
3225:
3226: arp_util.debug('attribute_category : '||p_desc_flex_rec.attribute_category);
3227: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
3228: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
3229: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
3230: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
3231: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
3232: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);

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

3225:
3226: arp_util.debug('attribute_category : '||p_desc_flex_rec.attribute_category);
3227: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
3228: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
3229: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
3230: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
3231: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
3232: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
3233: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);

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

3226: arp_util.debug('attribute_category : '||p_desc_flex_rec.attribute_category);
3227: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
3228: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
3229: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
3230: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
3231: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
3232: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
3233: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
3234: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);

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

3227: arp_util.debug('attribute1 : '||p_desc_flex_rec.attribute1);
3228: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
3229: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
3230: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
3231: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
3232: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
3233: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
3234: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
3235: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);

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

3228: arp_util.debug('attribute2 : '||p_desc_flex_rec.attribute2);
3229: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
3230: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
3231: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
3232: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
3233: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
3234: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
3235: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
3236: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);

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

3229: arp_util.debug('attribute3 : '||p_desc_flex_rec.attribute3);
3230: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
3231: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
3232: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
3233: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
3234: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
3235: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
3236: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
3237: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);

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

3230: arp_util.debug('attribute4 : '||p_desc_flex_rec.attribute4);
3231: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
3232: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
3233: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
3234: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
3235: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
3236: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
3237: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
3238: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);

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

3231: arp_util.debug('attribute5 : '||p_desc_flex_rec.attribute5);
3232: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
3233: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
3234: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
3235: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
3236: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
3237: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
3238: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
3239: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);

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

3232: arp_util.debug('attribute6 : '||p_desc_flex_rec.attribute6);
3233: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
3234: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
3235: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
3236: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
3237: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
3238: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
3239: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
3240: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);

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

3233: arp_util.debug('attribute7 : '||p_desc_flex_rec.attribute7);
3234: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
3235: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
3236: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
3237: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
3238: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
3239: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
3240: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
3241: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);

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

3234: arp_util.debug('attribute8 : '||p_desc_flex_rec.attribute8);
3235: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
3236: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
3237: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
3238: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
3239: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
3240: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
3241: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);
3242: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );

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

3235: arp_util.debug('attribute9 : '||p_desc_flex_rec.attribute9);
3236: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
3237: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
3238: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
3239: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
3240: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
3241: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);
3242: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );
3243: END Validate_Desc_Flexfield;

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

3236: arp_util.debug('attribute10 : '||p_desc_flex_rec.attribute10);
3237: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
3238: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
3239: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
3240: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
3241: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);
3242: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );
3243: END Validate_Desc_Flexfield;
3244:

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

3237: arp_util.debug('attribute11 : '||p_desc_flex_rec.attribute11);
3238: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
3239: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
3240: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
3241: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);
3242: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );
3243: END Validate_Desc_Flexfield;
3244:
3245: END ar_deposit_lib_pvt;

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

3238: arp_util.debug('attribute12 : '||p_desc_flex_rec.attribute12);
3239: arp_util.debug('attribute13 : '||p_desc_flex_rec.attribute13);
3240: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
3241: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);
3242: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );
3243: END Validate_Desc_Flexfield;
3244:
3245: END ar_deposit_lib_pvt;
3246: