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 AR_DEPOSIT_LIB_PVT

Line 1: PACKAGE BODY ar_deposit_lib_pvt AS

1: PACKAGE BODY ar_deposit_lib_pvt AS
2: /* $Header: ARXDEPLB.pls 120.15 2011/07/19 00:47:09 dgaurab ship $ */
3: /*=======================================================================+
4: | Package Global Constants
5: +=======================================================================*/

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_DEPOSIT_LIB_PVT';

3: /*=======================================================================+
4: | Package Global Constants
5: +=======================================================================*/
6:
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_DEPOSIT_LIB_PVT';
8:
9: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
10: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
11: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;

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 52: ar_deposit_lib_pvt.get_salesrep_name_id(OTHERS)' );

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;
56:

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 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 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 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 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 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 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 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 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 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 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 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 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 2074: AR_DEPOSIT_LIB_PVT.GET_CONTACT_ID(x_bill_to_customer_id,

2070:
2071: THEN
2072:
2073: x_bill_to_contact_id :=
2074: AR_DEPOSIT_LIB_PVT.GET_CONTACT_ID(x_bill_to_customer_id,
2075: p_bill_to_contact_first_name,
2076: p_bill_to_contact_last_name,
2077: l_contact_return_status);
2078: if x_bill_to_contact_id is null then

Line 2158: AR_DEPOSIT_LIB_PVT.GET_CONTACT_ID(x_ship_to_customer_id,

2154:
2155: THEN
2156:
2157: x_ship_to_contact_id :=
2158: AR_DEPOSIT_LIB_PVT.GET_CONTACT_ID(x_ship_to_customer_id,
2159: p_ship_to_contact_first_name,
2160: p_ship_to_contact_last_name,
2161: l_contact_return_status);
2162: if x_ship_to_contact_id is null then

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 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 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 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 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 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:

Line 3271: END ar_deposit_lib_pvt;

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: