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.HZP_CPROF_PKG dependencies on STANDARD

Line 118: p_standard_terms in number,

114: --
115: --
116:
117: PROCEDURE update_customer_alt_names(p_rowid in varchar2,
118: p_standard_terms in number,
119: p_customer_id in number,
120: p_site_use_id in number
121: )
122: IS

Line 123: l_standard_terms number := null ;

119: p_customer_id in number,
120: p_site_use_id in number
121: )
122: IS
123: l_standard_terms number := null ;
124:
125: CURSOR c1 is
126: select standard_terms
127: from hz_customer_profiles

Line 126: select standard_terms

122: IS
123: l_standard_terms number := null ;
124:
125: CURSOR c1 is
126: select standard_terms
127: from hz_customer_profiles
128: where rowid = p_rowid;
129: BEGIN
130: --

Line 135: FETCH c1 INTO l_standard_terms;

131: --
132: -- if ( nvl ( fnd_profile.value('AR_ALT_NAME_SEARCH') , 'N' ) = 'Y' ) then
133: --
134: OPEN c1;
135: FETCH c1 INTO l_standard_terms;
136: IF c1%FOUND THEN
137: --
138: IF (
139: ( l_standard_terms IS NULL AND p_standard_terms IS NOT NULL )

Line 139: ( l_standard_terms IS NULL AND p_standard_terms IS NOT NULL )

135: FETCH c1 INTO l_standard_terms;
136: IF c1%FOUND THEN
137: --
138: IF (
139: ( l_standard_terms IS NULL AND p_standard_terms IS NOT NULL )
140: OR ( l_standard_terms IS NOT NULL and p_standard_terms IS NULL )
141: OR ( l_standard_terms <> p_standard_terms )
142: )
143: THEN

Line 140: OR ( l_standard_terms IS NOT NULL and p_standard_terms IS NULL )

136: IF c1%FOUND THEN
137: --
138: IF (
139: ( l_standard_terms IS NULL AND p_standard_terms IS NOT NULL )
140: OR ( l_standard_terms IS NOT NULL and p_standard_terms IS NULL )
141: OR ( l_standard_terms <> p_standard_terms )
142: )
143: THEN
144: --

Line 141: OR ( l_standard_terms <> p_standard_terms )

137: --
138: IF (
139: ( l_standard_terms IS NULL AND p_standard_terms IS NOT NULL )
140: OR ( l_standard_terms IS NOT NULL and p_standard_terms IS NULL )
141: OR ( l_standard_terms <> p_standard_terms )
142: )
143: THEN
144: --
145: arp_cust_alt_match_pkg.update_pay_term_id ( p_customer_id,

Line 146: p_site_use_id , p_standard_terms );

142: )
143: THEN
144: --
145: arp_cust_alt_match_pkg.update_pay_term_id ( p_customer_id,
146: p_site_use_id , p_standard_terms );
147: --
148: END IF;
149: --
150: END IF;

Line 158: arp_standard.debug('EXCEPTION: hzp_cprof_pkg.update_customer_alt_names');

154: --
155: --
156: EXCEPTION
157: WHEN OTHERS THEN
158: arp_standard.debug('EXCEPTION: hzp_cprof_pkg.update_customer_alt_names');
159: END update_customer_alt_names;
160:
161: --
162: --

Line 196: X_Standard_Terms NUMBER,

192: X_Payment_Grace_Days NUMBER,
193: X_Percent_Collectable NUMBER,
194: X_Risk_Code VARCHAR2,
195: X_Site_Use_Id NUMBER,
196: X_Standard_Terms NUMBER,
197: X_Statement_Cycle_Id NUMBER,
198: X_Attribute_Category VARCHAR2,
199: X_Attribute1 VARCHAR2,
200: X_Attribute2 VARCHAR2,

Line 329: prof_rec.standard_terms := x_standard_terms;

325: prof_rec.profile_class_id := X_Customer_Profile_Class_Id;
326: prof_rec.site_use_id := X_Site_Use_Id;
327: prof_rec.credit_rating := x_credit_rating;
328: prof_rec.risk_code := x_risk_code;
329: prof_rec.standard_terms := x_standard_terms;
330: prof_rec.override_terms := x_override_terms;
331: prof_rec.dunning_letter_set_id := x_dunning_letter_set_id;
332: prof_rec.interest_period_days := x_interest_period_days;
333: prof_rec.payment_grace_days := x_payment_grace_days;

Line 494: x_cust_prof_rec.standard_terms := lrec.standard_terms;

490: x_cust_prof_rec.send_statements := lrec.statements;
491: x_cust_prof_rec.credit_balance_statements:= lrec.credit_balance_statements;
492: x_cust_prof_rec.credit_hold := 'N';
493: x_cust_prof_rec.profile_class_id := lrec.profile_class_id;
494: x_cust_prof_rec.standard_terms := lrec.standard_terms;
495: x_cust_prof_rec.override_terms := lrec.override_terms;
496: x_cust_prof_rec.dunning_letter_set_id := lrec.dunning_letter_set_id;
497: x_cust_prof_rec.interest_period_days := lrec.interest_period_days;
498: x_cust_prof_rec.payment_grace_days := lrec.payment_grace_days;

Line 606: X_Standard_Terms NUMBER,

602: X_Payment_Grace_Days NUMBER,
603: X_Percent_Collectable NUMBER,
604: X_Risk_Code VARCHAR2,
605: X_Site_Use_Id NUMBER,
606: X_Standard_Terms NUMBER,
607: X_Statement_Cycle_Id NUMBER,
608: X_Attribute_Category VARCHAR2,
609: X_Attribute1 VARCHAR2,
610: X_Attribute2 VARCHAR2,

Line 729: hzp_cprof_pkg.update_customer_alt_names( X_Rowid , X_Standard_Terms ,

725: p_site_use_id => x_site_use_id,
726: p_credit_hold => x_credit_hold
727: );
728: --
729: hzp_cprof_pkg.update_customer_alt_names( X_Rowid , X_Standard_Terms ,
730: X_Customer_Id , X_Site_Use_Id ) ;
731: --
732: l_cp_rec.cust_account_profile_id := INIT_SWITCH(X_Customer_Profile_Id);
733: l_cp_rec.auto_rec_incl_disputed_flag := INIT_SWITCH(X_Auto_Rec_Incl_Disputed_Flag);

Line 761: l_cp_rec.standard_terms := INIT_SWITCH( X_Standard_Terms);

757: l_cp_rec.payment_grace_days := INIT_SWITCH( X_Payment_Grace_Days);
758: l_cp_rec.percent_collectable := INIT_SWITCH( X_Percent_Collectable);
759: l_cp_rec.risk_code := INIT_SWITCH( X_Risk_Code);
760: l_cp_rec.site_use_id := INIT_SWITCH( X_Site_Use_Id);
761: l_cp_rec.standard_terms := INIT_SWITCH( X_Standard_Terms);
762: l_cp_rec.statement_cycle_id := INIT_SWITCH( X_Statement_Cycle_Id);
763: l_cp_rec.attribute_category := INIT_SWITCH( X_Attribute_Category);
764: l_cp_rec.attribute1 := INIT_SWITCH( X_Attribute1);
765: l_cp_rec.attribute2 := INIT_SWITCH( X_Attribute2);

Line 916: x_standard_terms out NOCOPY number,

912: x_statements out NOCOPY varchar2,
913: x_statement_cycle_id out NOCOPY number,
914: x_statement_cycle_name out NOCOPY varchar2,
915: x_credit_balance_statements out NOCOPY varchar2,
916: x_standard_terms out NOCOPY number,
917: x_standard_terms_name out NOCOPY varchar2,
918: x_override_terms out NOCOPY varchar2,
919: x_payment_grace_days out NOCOPY number,
920: x_dunning_letters out NOCOPY varchar2,

Line 917: x_standard_terms_name out NOCOPY varchar2,

913: x_statement_cycle_id out NOCOPY number,
914: x_statement_cycle_name out NOCOPY varchar2,
915: x_credit_balance_statements out NOCOPY varchar2,
916: x_standard_terms out NOCOPY number,
917: x_standard_terms_name out NOCOPY varchar2,
918: x_override_terms out NOCOPY varchar2,
919: x_payment_grace_days out NOCOPY number,
920: x_dunning_letters out NOCOPY varchar2,
921: x_dunning_letter_set_id out NOCOPY number,

Line 997: standard_terms,

993: statements,
994: statement_cycle_id,
995: statement_cycle_name,
996: credit_balance_statements,
997: standard_terms,
998: standard_terms_name,
999: override_terms,
1000: payment_grace_days,
1001: dunning_letters,

Line 998: standard_terms_name,

994: statement_cycle_id,
995: statement_cycle_name,
996: credit_balance_statements,
997: standard_terms,
998: standard_terms_name,
999: override_terms,
1000: payment_grace_days,
1001: dunning_letters,
1002: dunning_letter_set_id,

Line 1148: x_standard_terms,

1144: x_statements,
1145: x_statement_cycle_id,
1146: x_statement_cycle_name,
1147: x_credit_balance_statements,
1148: x_standard_terms,
1149: x_standard_terms_name,
1150: x_override_terms,
1151: x_payment_grace_days,
1152: x_dunning_letters,

Line 1149: x_standard_terms_name,

1145: x_statement_cycle_id,
1146: x_statement_cycle_name,
1147: x_credit_balance_statements,
1148: x_standard_terms,
1149: x_standard_terms_name,
1150: x_override_terms,
1151: x_payment_grace_days,
1152: x_dunning_letters,
1153: x_dunning_letter_set_id,

Line 1426: x_standard_terms out NOCOPY number,

1422: x_statements out NOCOPY varchar2,
1423: x_statement_cycle_id out NOCOPY number,
1424: x_statement_cycle_name out NOCOPY varchar2,
1425: x_credit_balance_statements out NOCOPY varchar2,
1426: x_standard_terms out NOCOPY number,
1427: x_standard_terms_name out NOCOPY varchar2,
1428: x_override_terms out NOCOPY varchar2,
1429: x_payment_grace_days out NOCOPY number,
1430: x_dunning_letters out NOCOPY varchar2,

Line 1427: x_standard_terms_name out NOCOPY varchar2,

1423: x_statement_cycle_id out NOCOPY number,
1424: x_statement_cycle_name out NOCOPY varchar2,
1425: x_credit_balance_statements out NOCOPY varchar2,
1426: x_standard_terms out NOCOPY number,
1427: x_standard_terms_name out NOCOPY varchar2,
1428: x_override_terms out NOCOPY varchar2,
1429: x_payment_grace_days out NOCOPY number,
1430: x_dunning_letters out NOCOPY varchar2,
1431: x_dunning_letter_set_id out NOCOPY number,

Line 1514: standard_terms,

1510: statements,
1511: statement_cycle_id,
1512: statement_cycle_name,
1513: credit_balance_statements,
1514: standard_terms,
1515: standard_terms_name,
1516: override_terms,
1517: payment_grace_days,
1518: dunning_letters,

Line 1515: standard_terms_name,

1511: statement_cycle_id,
1512: statement_cycle_name,
1513: credit_balance_statements,
1514: standard_terms,
1515: standard_terms_name,
1516: override_terms,
1517: payment_grace_days,
1518: dunning_letters,
1519: dunning_letter_set_id,

Line 1667: x_standard_terms,

1663: x_statements,
1664: x_statement_cycle_id,
1665: x_statement_cycle_name,
1666: x_credit_balance_statements,
1667: x_standard_terms,
1668: x_standard_terms_name,
1669: x_override_terms,
1670: x_payment_grace_days,
1671: x_dunning_letters,

Line 1668: x_standard_terms_name,

1664: x_statement_cycle_id,
1665: x_statement_cycle_name,
1666: x_credit_balance_statements,
1667: x_standard_terms,
1668: x_standard_terms_name,
1669: x_override_terms,
1670: x_payment_grace_days,
1671: x_dunning_letters,
1672: x_dunning_letter_set_id,

Line 2031: arp_standard.debug('create_profile_amount (+)');

2027: tmp_var VARCHAR2(2000);
2028: i NUMBER;
2029: tmp_var1 VARCHAR2(2000);
2030: BEGIN
2031: arp_standard.debug('create_profile_amount (+)');
2032: x_return_status := FND_API.G_RET_STS_SUCCESS;
2033:
2034: l_rec.cust_acct_profile_amt_id := x_cust_acct_profile_amt_id;
2035: l_rec.cust_account_profile_id := p_cust_account_profile_id;

Line 2121: arp_standard.debug(x_msg_data);

2117: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2118: END LOOP;
2119: x_msg_data := tmp_var1;
2120: END IF;
2121: arp_standard.debug(x_msg_data);
2122: END IF;
2123:
2124: arp_standard.debug('create_profile_amount(-)');
2125: EXCEPTION

Line 2124: arp_standard.debug('create_profile_amount(-)');

2120: END IF;
2121: arp_standard.debug(x_msg_data);
2122: END IF;
2123:
2124: arp_standard.debug('create_profile_amount(-)');
2125: EXCEPTION
2126: WHEN OTHERS THEN
2127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2128: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

Line 2135: arp_standard.debug('EXCEPTION: hzp_cprof_pkg.delete_profile_amout'||x_msg_data);

2131: FND_MSG_PUB.Count_And_Get(
2132: p_encoded => FND_API.G_FALSE,
2133: p_count => x_msg_count,
2134: p_data => x_msg_data );
2135: arp_standard.debug('EXCEPTION: hzp_cprof_pkg.delete_profile_amout'||x_msg_data);
2136: END;
2137:
2138: /*---------------------------------------------------------------+
2139: | PROCEDURE : UPDATE_PROFILE_AMOUNT |

Line 2246: arp_standard.debug('update_profile_amount (+)');

2242: l_last_update_date DATE;
2243: l_exception EXCEPTION;
2244: tca_exception EXCEPTION;
2245: BEGIN
2246: arp_standard.debug('update_profile_amount (+)');
2247: arp_standard.debug('Object_version_number:'||p_object_version);
2248: arp_standard.debug('last_update_date:'||X_Last_Update_Date );
2249:
2250: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2247: arp_standard.debug('Object_version_number:'||p_object_version);

2243: l_exception EXCEPTION;
2244: tca_exception EXCEPTION;
2245: BEGIN
2246: arp_standard.debug('update_profile_amount (+)');
2247: arp_standard.debug('Object_version_number:'||p_object_version);
2248: arp_standard.debug('last_update_date:'||X_Last_Update_Date );
2249:
2250: x_return_status := FND_API.G_RET_STS_SUCCESS;
2251:

Line 2248: arp_standard.debug('last_update_date:'||X_Last_Update_Date );

2244: tca_exception EXCEPTION;
2245: BEGIN
2246: arp_standard.debug('update_profile_amount (+)');
2247: arp_standard.debug('Object_version_number:'||p_object_version);
2248: arp_standard.debug('last_update_date:'||X_Last_Update_Date );
2249:
2250: x_return_status := FND_API.G_RET_STS_SUCCESS;
2251:
2252: l_rec.cust_acct_profile_amt_id := INIT_SWITCH(p_cust_acct_profile_amt_id);

Line 2330: arp_standard.debug('Last_update_date:'||to_char(l_last_update_date));

2326: OPEN cu_version_prof_amt;
2327: FETCH cu_version_prof_amt INTO l_rowid,
2328: l_object_version,
2329: l_last_update_date;
2330: arp_standard.debug('Last_update_date:'||to_char(l_last_update_date));
2331:
2332: IF cu_version_prof_amt%NOTFOUND THEN
2333: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
2334: FND_MESSAGE.SET_TOKEN('RECORD','HZ_CUST_PROFILE_AMTS');

Line 2344: arp_standard.debug('x_return_status :'||x_return_status);

2340: CLOSE cu_version_prof_amt;
2341:
2342: END IF;
2343:
2344: arp_standard.debug('x_return_status :'||x_return_status);
2345:
2346: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2347:
2348: HZ_CUSTOMER_PROFILE_V2PUB.update_cust_profile_amt

Line 2361: arp_standard.debug('update_profile_amount (-)');

2357: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2358: RAISE tca_exception;
2359: END IF;
2360:
2361: arp_standard.debug('update_profile_amount (-)');
2362: EXCEPTION
2363: WHEN l_exception THEN
2364: x_return_status := FND_API.G_RET_STS_ERROR;
2365: fnd_msg_pub.count_and_get(

Line 2376: arp_standard.debug('Exception hzp_cprof_pkg.update_profile_amount:'||x_msg_data);

2372: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2373: END LOOP;
2374: x_msg_data := tmp_var1;
2375: END IF;
2376: arp_standard.debug('Exception hzp_cprof_pkg.update_profile_amount:'||x_msg_data);
2377:
2378: WHEN tca_Exception THEN
2379: IF x_msg_count > 1 THEN
2380: FOR i IN 1..x_msg_count LOOP

Line 2386: arp_standard.debug('Exception hzp_cprof_pkg.update_profile_amount:'||x_msg_data);

2382: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2383: END LOOP;
2384: x_msg_data := tmp_var1;
2385: END IF;
2386: arp_standard.debug('Exception hzp_cprof_pkg.update_profile_amount:'||x_msg_data);
2387:
2388: WHEN OTHERS THEN
2389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2390: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

Line 2397: arp_standard.debug('EXCEPTION OTHERS: hzp_cprof_pkg.update_profile_amout'||x_msg_data);

2393: FND_MSG_PUB.Count_And_Get(
2394: p_encoded => FND_API.G_FALSE,
2395: p_count => x_msg_count,
2396: p_data => x_msg_data );
2397: arp_standard.debug('EXCEPTION OTHERS: hzp_cprof_pkg.update_profile_amout'||x_msg_data);
2398: END;
2399:
2400:
2401: /*---------------------------------------------------------------+

Line 2420: arp_standard.debug('delete_profile_amount(+)');

2416: x_msg_count OUT NOCOPY NUMBER,
2417: x_msg_data OUT NOCOPY VARCHAR2)
2418: IS
2419: BEGIN
2420: arp_standard.debug('delete_profile_amount(+)');
2421:
2422: x_return_status := FND_API.G_RET_STS_SUCCESS;
2423:
2424: DELETE FROM hz_cust_profile_amts

Line 2431: arp_standard.debug('delete_profile_amount(-)');

2427: IF (SQL%NOTFOUND) THEN
2428: Raise NO_DATA_FOUND;
2429: END IF;
2430:
2431: arp_standard.debug('delete_profile_amount(-)');
2432:
2433: EXCEPTION
2434: WHEN NO_DATA_FOUND THEN
2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2443: arp_standard.debug('EXCEPTION NO_DATA_FOUND: hzp_cprof_pkg.delete_profile_amout');

2439: FND_MSG_PUB.Count_And_Get(
2440: p_encoded => FND_API.G_FALSE,
2441: p_count => x_msg_count,
2442: p_data => x_msg_data );
2443: arp_standard.debug('EXCEPTION NO_DATA_FOUND: hzp_cprof_pkg.delete_profile_amout');
2444:
2445: WHEN OTHERS THEN
2446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2447: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

Line 2454: arp_standard.debug('EXCEPTION OTHERS: hzp_cprof_pkg.delete_profile_amout'||x_msg_data);

2450: FND_MSG_PUB.Count_And_Get(
2451: p_encoded => FND_API.G_FALSE,
2452: p_count => x_msg_count,
2453: p_data => x_msg_data );
2454: arp_standard.debug('EXCEPTION OTHERS: hzp_cprof_pkg.delete_profile_amout'||x_msg_data);
2455: END;
2456:
2457: END hzp_cprof_pkg;