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.11.12000000.2 2007/04/11 11:06:32 spdixit 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 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 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 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 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 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 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 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 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 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 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 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 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 2050: AR_DEPOSIT_LIB_PVT.GET_CONTACT_ID(x_bill_to_customer_id,

2046:
2047: THEN
2048:
2049: x_bill_to_contact_id :=
2050: AR_DEPOSIT_LIB_PVT.GET_CONTACT_ID(x_bill_to_customer_id,
2051: p_bill_to_contact_first_name,
2052: p_bill_to_contact_last_name,
2053: l_contact_return_status);
2054: if x_bill_to_contact_id is null then

Line 2134: AR_DEPOSIT_LIB_PVT.GET_CONTACT_ID(x_ship_to_customer_id,

2130:
2131: THEN
2132:
2133: x_ship_to_contact_id :=
2134: AR_DEPOSIT_LIB_PVT.GET_CONTACT_ID(x_ship_to_customer_id,
2135: p_ship_to_contact_first_name,
2136: p_ship_to_contact_last_name,
2137: l_contact_return_status);
2138: if x_ship_to_contact_id is null then

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

Line 3245: END ar_deposit_lib_pvt;

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: