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.HZ_MGD_MASS_UPDATE_MEDIATOR dependencies on HZ_MGD_MASS_UPDATE_REP_GEN

Line 58: HZ_MGD_MASS_UPDATE_REP_GEN.log

54: l_site_name hz_cust_site_uses.location%TYPE;
55:
56: BEGIN
57:
58: HZ_MGD_MASS_UPDATE_REP_GEN.log
59: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
60: , p_msg => '>> Get_entity_name ' );
61:
62: HZ_MGD_MASS_UPDATE_REP_GEN.Log

Line 59: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE

55:
56: BEGIN
57:
58: HZ_MGD_MASS_UPDATE_REP_GEN.log
59: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
60: , p_msg => '>> Get_entity_name ' );
61:
62: HZ_MGD_MASS_UPDATE_REP_GEN.Log
63: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT

Line 62: HZ_MGD_MASS_UPDATE_REP_GEN.Log

58: HZ_MGD_MASS_UPDATE_REP_GEN.log
59: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
60: , p_msg => '>> Get_entity_name ' );
61:
62: HZ_MGD_MASS_UPDATE_REP_GEN.Log
63: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
64: , p_msg => 'entity= '||p_entity
65: || ' entity_id= '||TO_CHAR(p_entity_id));
66:

Line 63: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT

59: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
60: , p_msg => '>> Get_entity_name ' );
61:
62: HZ_MGD_MASS_UPDATE_REP_GEN.Log
63: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
64: , p_msg => 'entity= '||p_entity
65: || ' entity_id= '||TO_CHAR(p_entity_id));
66:
67: ----if entity=PARTY-----------

Line 80: HZ_MGD_MASS_UPDATE_REP_GEN.Log

76:
77: x_cust_name:=' ';
78: x_site_name:=' ';
79:
80: HZ_MGD_MASS_UPDATE_REP_GEN.Log
81: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
82: , p_msg => 'party_name= '||x_party_name
83: );
84:

Line 81: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT

77: x_cust_name:=' ';
78: x_site_name:=' ';
79:
80: HZ_MGD_MASS_UPDATE_REP_GEN.Log
81: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
82: , p_msg => 'party_name= '||x_party_name
83: );
84:
85: ----if entity=CUSTOMER-----------

Line 104: HZ_MGD_MASS_UPDATE_REP_GEN.Log

100: x_party_name:=' ';
101: x_cust_name:=l_cust_name||'('||l_cust_num||')';
102: x_site_name:=' ';
103:
104: HZ_MGD_MASS_UPDATE_REP_GEN.Log
105: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
106: , p_msg => 'customer_name= '||x_cust_name
107: );
108:

Line 105: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT

101: x_cust_name:=l_cust_name||'('||l_cust_num||')';
102: x_site_name:=' ';
103:
104: HZ_MGD_MASS_UPDATE_REP_GEN.Log
105: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
106: , p_msg => 'customer_name= '||x_cust_name
107: );
108:
109: ----if entity=SITE-----------

Line 135: HZ_MGD_MASS_UPDATE_REP_GEN.Log

131: AND hca.cust_account_id=p_cust_account_id;
132:
133: x_cust_name:=l_cust_name||'('||l_cust_num||')';
134:
135: HZ_MGD_MASS_UPDATE_REP_GEN.Log
136: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
137: , p_msg => 'site_name= '||x_site_name
138: );
139:

Line 136: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT

132:
133: x_cust_name:=l_cust_name||'('||l_cust_num||')';
134:
135: HZ_MGD_MASS_UPDATE_REP_GEN.Log
136: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
137: , p_msg => 'site_name= '||x_site_name
138: );
139:
140: END IF;

Line 143: HZ_MGD_MASS_UPDATE_REP_GEN.log

139:
140: END IF;
141:
142:
143: HZ_MGD_MASS_UPDATE_REP_GEN.log
144: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
145: , p_msg => '<< Get_entity_name ' );
146:
147: END Get_entity_name;

Line 144: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE

140: END IF;
141:
142:
143: HZ_MGD_MASS_UPDATE_REP_GEN.log
144: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
145: , p_msg => '<< Get_entity_name ' );
146:
147: END Get_entity_name;
148:

Line 1010: HZ_MGD_MASS_UPDATE_REP_GEN.log

1006: BEGIN
1007: -- Delete the Rule set assigned for a given
1008: -- profile amt id
1009:
1010: HZ_MGD_MASS_UPDATE_REP_GEN.log
1011: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
1012: , p_msg => '>> delete_credit_usages' );
1013:
1014: X_return_status := 'S' ;

Line 1011: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE

1007: -- Delete the Rule set assigned for a given
1008: -- profile amt id
1009:
1010: HZ_MGD_MASS_UPDATE_REP_GEN.log
1011: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
1012: , p_msg => '>> delete_credit_usages' );
1013:
1014: X_return_status := 'S' ;
1015:

Line 1021: HZ_MGD_MASS_UPDATE_REP_GEN.log

1017: HZ_CREDIT_USAGES
1018: WHERE CUST_ACCT_PROFILE_AMT_ID
1019: = p_cust_acct_profile_amt_id ;
1020:
1021: HZ_MGD_MASS_UPDATE_REP_GEN.log
1022: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
1023: , p_msg => '<< delete_credit_usages' );
1024:
1025: EXCEPTION

Line 1022: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE

1018: WHERE CUST_ACCT_PROFILE_AMT_ID
1019: = p_cust_acct_profile_amt_id ;
1020:
1021: HZ_MGD_MASS_UPDATE_REP_GEN.log
1022: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
1023: , p_msg => '<< delete_credit_usages' );
1024:
1025: EXCEPTION
1026: WHEN OTHERS THEN

Line 1078: HZ_MGD_MASS_UPDATE_REP_GEN.log

1074: l_cust_account_profile_id NUMBER;
1075:
1076: BEGIN
1077:
1078: HZ_MGD_MASS_UPDATE_REP_GEN.log
1079: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
1080: , p_msg => '>> cascade_credit_usage_rules' );
1081:
1082: -- The API will duplicate the rule set assignments

Line 1079: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE

1075:
1076: BEGIN
1077:
1078: HZ_MGD_MASS_UPDATE_REP_GEN.log
1079: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
1080: , p_msg => '>> cascade_credit_usage_rules' );
1081:
1082: -- The API will duplicate the rule set assignments
1083: -- made with the profile class limit currency with

Line 1198: HZ_MGD_MASS_UPDATE_REP_GEN.log

1194: , x_duplicate => l_duplicate
1195: , x_dupl_curr => l_duplicate_curr
1196: );
1197:
1198: HZ_MGD_MASS_UPDATE_REP_GEN.log
1199: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
1200: , p_msg => ' Check_Duplicate_all returns '||l_duplicate);
1201:
1202:

Line 1199: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT

1195: , x_dupl_curr => l_duplicate_curr
1196: );
1197:
1198: HZ_MGD_MASS_UPDATE_REP_GEN.log
1199: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
1200: , p_msg => ' Check_Duplicate_all returns '||l_duplicate);
1201:
1202:
1203: IF l_duplicate = 'Y'

Line 1216: HZ_MGD_MASS_UPDATE_REP_GEN.Add_Exp_Item

1212: , x_cust_name => l_cust_name
1213: , x_site_name => l_site_name
1214: );
1215:
1216: HZ_MGD_MASS_UPDATE_REP_GEN.Add_Exp_Item
1217: ( p_party => l_party_name
1218: , p_customer => NULL
1219: , p_site => NULL
1220: );

Line 1233: HZ_MGD_MASS_UPDATE_REP_GEN.Add_Exp_Item

1229: , x_cust_name => l_cust_name
1230: , x_site_name => l_site_name
1231: );
1232:
1233: HZ_MGD_MASS_UPDATE_REP_GEN.Add_Exp_Item
1234: ( p_party => NULL
1235: , p_customer => l_cust_name
1236: , p_site => NULL
1237: );

Line 1250: HZ_MGD_MASS_UPDATE_REP_GEN.Add_Exp_Item

1246: , x_cust_name => l_cust_name
1247: , x_site_name => l_site_name
1248: );
1249:
1250: HZ_MGD_MASS_UPDATE_REP_GEN.Add_Exp_Item
1251: ( p_party => NULL
1252: , p_customer => l_cust_name
1253: , p_site => l_site_name
1254: );

Line 1356: HZ_MGD_MASS_UPDATE_REP_GEN.log

1352: EXCEPTION
1353: WHEN OTHERS THEN
1354: X_return_status := 'U' ;
1355:
1356: HZ_MGD_MASS_UPDATE_REP_GEN.log
1357: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
1358: , p_msg => '<< cascade_credit_usage_rules' );
1359:
1360: END cascade_credit_usage_rules ;

Line 1357: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE

1353: WHEN OTHERS THEN
1354: X_return_status := 'U' ;
1355:
1356: HZ_MGD_MASS_UPDATE_REP_GEN.log
1357: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
1358: , p_msg => '<< cascade_credit_usage_rules' );
1359:
1360: END cascade_credit_usage_rules ;
1361:

Line 1407: HZ_MGD_MASS_UPDATE_REP_GEN.log

1403:
1404:
1405:
1406: BEGIN
1407: HZ_MGD_MASS_UPDATE_REP_GEN.log
1408: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
1409: , p_msg => '>> Mass_Update_Usage_Rules' );
1410:
1411: HZ_MGD_MASS_UPDATE_REP_GEN.log

Line 1408: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE

1404:
1405:
1406: BEGIN
1407: HZ_MGD_MASS_UPDATE_REP_GEN.log
1408: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
1409: , p_msg => '>> Mass_Update_Usage_Rules' );
1410:
1411: HZ_MGD_MASS_UPDATE_REP_GEN.log
1412: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT

Line 1411: HZ_MGD_MASS_UPDATE_REP_GEN.log

1407: HZ_MGD_MASS_UPDATE_REP_GEN.log
1408: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
1409: , p_msg => '>> Mass_Update_Usage_Rules' );
1410:
1411: HZ_MGD_MASS_UPDATE_REP_GEN.log
1412: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
1413: , p_msg => ' Starting loop for customer profiles for
1414: p_profile_class_id='||TO_CHAR(p_profile_class_id)
1415: ||'p_currency_code='||p_currency_code

Line 1412: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT

1408: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
1409: , p_msg => '>> Mass_Update_Usage_Rules' );
1410:
1411: HZ_MGD_MASS_UPDATE_REP_GEN.log
1412: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
1413: , p_msg => ' Starting loop for customer profiles for
1414: p_profile_class_id='||TO_CHAR(p_profile_class_id)
1415: ||'p_currency_code='||p_currency_code
1416: );

Line 1425: HZ_MGD_MASS_UPDATE_REP_GEN.log

1421: --Cascade insert usages for customer/site profiles
1422: FOR cust_prof_csr_rec IN cust_prof_csr( p_profile_class_id=> p_profile_class_id
1423: , p_currency_code => p_currency_code)
1424: LOOP
1425: HZ_MGD_MASS_UPDATE_REP_GEN.log
1426: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
1427: , p_msg => ' HZ_CREDIT_USAGES_CASCADE_PKG.Cascade_credit_usage_rules for
1428: p_cust_acct_profile_amt_id='||TO_CHAR(cust_prof_csr_rec.cust_acct_profile_amt_id)
1429: ||' p_profile_class_amt_id='||TO_CHAR(p_profile_class_amount_id)

Line 1426: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT

1422: FOR cust_prof_csr_rec IN cust_prof_csr( p_profile_class_id=> p_profile_class_id
1423: , p_currency_code => p_currency_code)
1424: LOOP
1425: HZ_MGD_MASS_UPDATE_REP_GEN.log
1426: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
1427: , p_msg => ' HZ_CREDIT_USAGES_CASCADE_PKG.Cascade_credit_usage_rules for
1428: p_cust_acct_profile_amt_id='||TO_CHAR(cust_prof_csr_rec.cust_acct_profile_amt_id)
1429: ||' p_profile_class_amt_id='||TO_CHAR(p_profile_class_amount_id)
1430: );

Line 1477: HZ_MGD_MASS_UPDATE_REP_GEN.G_PROF_NUMBER:=l_cust_count;

1473: END IF;
1474:
1475: END LOOP;
1476:
1477: HZ_MGD_MASS_UPDATE_REP_GEN.G_PROF_NUMBER:=l_cust_count;
1478:
1479:
1480:
1481: HZ_MGD_MASS_UPDATE_REP_GEN.log

Line 1481: HZ_MGD_MASS_UPDATE_REP_GEN.log

1477: HZ_MGD_MASS_UPDATE_REP_GEN.G_PROF_NUMBER:=l_cust_count;
1478:
1479:
1480:
1481: HZ_MGD_MASS_UPDATE_REP_GEN.log
1482: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
1483: , p_msg => ' End loop for customer profiles ');
1484:
1485: HZ_MGD_MASS_UPDATE_REP_GEN.log

Line 1482: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT

1478:
1479:
1480:
1481: HZ_MGD_MASS_UPDATE_REP_GEN.log
1482: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
1483: , p_msg => ' End loop for customer profiles ');
1484:
1485: HZ_MGD_MASS_UPDATE_REP_GEN.log
1486: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE

Line 1485: HZ_MGD_MASS_UPDATE_REP_GEN.log

1481: HZ_MGD_MASS_UPDATE_REP_GEN.log
1482: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
1483: , p_msg => ' End loop for customer profiles ');
1484:
1485: HZ_MGD_MASS_UPDATE_REP_GEN.log
1486: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
1487: , p_msg => '<< Mass_Update_Usage_Rules' );
1488:
1489:

Line 1486: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE

1482: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
1483: , p_msg => ' End loop for customer profiles ');
1484:
1485: HZ_MGD_MASS_UPDATE_REP_GEN.log
1486: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
1487: , p_msg => '<< Mass_Update_Usage_Rules' );
1488:
1489:
1490: EXCEPTION

Line 1492: HZ_MGD_MASS_UPDATE_REP_GEN.Log( HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_EXCEPTION,'SQLERRM '|| SQLERRM) ;

1488:
1489:
1490: EXCEPTION
1491: WHEN OTHERS THEN
1492: HZ_MGD_MASS_UPDATE_REP_GEN.Log( HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_EXCEPTION,'SQLERRM '|| SQLERRM) ;
1493:
1494: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1495: THEN
1496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, 'Mass_Update_Usage_Rules');