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.PQH_CBR_ENGINE dependencies on PQH_BDGT_REALLOC_LOG_PKG

Line 693: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => 'F',

689: p_effective_date => p_effective_date,
690: l_rule_matx => l_rule_matx);
691: hr_utility.set_location('valid_rule matrix populated',30);
692: -- folder process logging started
693: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => 'F',
694: p_folder_id => p_transaction_id);
695: hr_utility.set_location('rules to apply are :'||l_rule_matx.count,40);
696: for rule_counter in 1..l_rule_matx.count loop
697: hr_utility.set_location('applying rule '||l_rule_matx(rule_counter).rule_set_id,20);

Line 715: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => l_prev_txn_type,

711: hr_utility.set_location('inside itxn chk',25);
712: if l_prev_txn_id <> nvl(l_rule_matx(rule_counter).txn_id,-1) then
713: hr_utility.set_location('inside entity chk',28);
714: -- different txn is being started
715: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => l_prev_txn_type,
716: p_folder_id => p_transaction_id,
717: p_transaction_id => l_prev_txn_id,
718: p_entity_id => l_prev_entity_id);
719: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => 'T',

Line 719: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => 'T',

715: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => l_prev_txn_type,
716: p_folder_id => p_transaction_id,
717: p_transaction_id => l_prev_txn_id,
718: p_entity_id => l_prev_entity_id);
719: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => 'T',
720: p_folder_id => p_transaction_id,
721: p_transaction_id => l_prev_txn_id);
722: hr_utility.set_location('old log ended, new being started ',29);
723: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => 'T',

Line 723: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => 'T',

719: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => 'T',
720: p_folder_id => p_transaction_id,
721: p_transaction_id => l_prev_txn_id);
722: hr_utility.set_location('old log ended, new being started ',29);
723: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => 'T',
724: p_folder_id => p_transaction_id,
725: p_transaction_id => l_prev_txn_id);
726: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => l_txn_type, --line modified by kgowripe
727: -- l_rule_matx(rule_counter).rule_applicability,

Line 726: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => l_txn_type, --line modified by kgowripe

722: hr_utility.set_location('old log ended, new being started ',29);
723: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => 'T',
724: p_folder_id => p_transaction_id,
725: p_transaction_id => l_prev_txn_id);
726: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => l_txn_type, --line modified by kgowripe
727: -- l_rule_matx(rule_counter).rule_applicability,
728: p_folder_id => p_transaction_id,
729: p_transaction_id => l_rule_matx(rule_counter).txn_id,
730: --Added by kgowripe

Line 741: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => l_prev_txn_type,

737: hr_utility.set_location('same txn ',35);
738: if l_prev_entity_id <> l_rule_matx(rule_counter).entity_id then
739: -- different entity getting start
740: hr_utility.set_location('different txn ',40);
741: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => l_prev_txn_type,
742: p_folder_id => p_transaction_id,
743: p_transaction_id => l_prev_txn_id,
744: p_entity_id => l_prev_entity_id);
745: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => l_txn_type,-- line modified by kgowripe

Line 745: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => l_txn_type,-- line modified by kgowripe

741: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => l_prev_txn_type,
742: p_folder_id => p_transaction_id,
743: p_transaction_id => l_prev_txn_id,
744: p_entity_id => l_prev_entity_id);
745: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => l_txn_type,-- line modified by kgowripe
746: --l_rule_matx(rule_counter).rule_applicability,
747: p_folder_id => p_transaction_id,
748: p_transaction_id => l_rule_matx(rule_counter).txn_id,
749: --Added by kgowripe

Line 762: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => 'T',

758: end if;
759: else
760: -- 1st time in loop so start the txn and entity, nothing is there to end.
761: hr_utility.set_location('1st time in rule chk ',60);
762: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => 'T',
763: p_folder_id => p_transaction_id,
764: p_transaction_id => l_rule_matx(rule_counter).txn_id);
765: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => l_txn_type,
766: p_folder_id => p_transaction_id,

Line 765: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => l_txn_type,

761: hr_utility.set_location('1st time in rule chk ',60);
762: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => 'T',
763: p_folder_id => p_transaction_id,
764: p_transaction_id => l_rule_matx(rule_counter).txn_id);
765: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => l_txn_type,
766: p_folder_id => p_transaction_id,
767: p_transaction_id => l_rule_matx(rule_counter).txn_id,
768: --Added by kgowripe
769: p_bdgt_entity_type=> g_budget_entity,

Line 811: pqh_bdgt_realloc_log_pkg.log_rule_for_entity

807: p_status_flag := 'W';
808: end if;
809: l_rule_message := build_message (p_application_id => 8302,
810: p_message_cd => l_rule_matx(rule_counter).message_cd);
811: pqh_bdgt_realloc_log_pkg.log_rule_for_entity
812: (p_folder_id => p_transaction_id,
813: p_transaction_id => l_rule_matx(rule_counter).txn_id,
814: p_txn_entity_type => l_txn_type, -- line modified by kgowripe
815: --l_rule_matx(rule_counter).rule_applicability,

Line 852: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => l_prev_txn_type,

848: hr_utility.set_location('going for next rule',140);
849: end loop; -- rules for all entities of a folder
850: hr_utility.set_location('all rule applied '||l_final_stat,145);
851: -- close the entity, txn and folder processing
852: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => l_prev_txn_type,
853: p_folder_id => p_transaction_id,
854: p_transaction_id => l_prev_txn_id,
855: p_entity_id => l_prev_entity_id);
856: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => 'T', --modified by kgowripe l_prev_txn_type,

Line 856: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => 'T', --modified by kgowripe l_prev_txn_type,

852: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => l_prev_txn_type,
853: p_folder_id => p_transaction_id,
854: p_transaction_id => l_prev_txn_id,
855: p_entity_id => l_prev_entity_id);
856: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => 'T', --modified by kgowripe l_prev_txn_type,
857: p_folder_id => p_transaction_id,
858: p_transaction_id => l_prev_txn_id);
859: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => 'F', --modified by kgowripe l_prev_txn_type,
860: p_folder_id => p_transaction_id);

Line 859: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => 'F', --modified by kgowripe l_prev_txn_type,

855: p_entity_id => l_prev_entity_id);
856: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => 'T', --modified by kgowripe l_prev_txn_type,
857: p_folder_id => p_transaction_id,
858: p_transaction_id => l_prev_txn_id);
859: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => 'F', --modified by kgowripe l_prev_txn_type,
860: p_folder_id => p_transaction_id);
861: p_status_flag := l_final_stat;
862: hr_utility.set_location('leaving '||l_proc,200);
863: exception

Line 926: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => 'F',

922: l_prd_bgt_amt number;
923: begin
924: hr_utility.set_location('inside'||l_proc,10);
925: p_status_flag := TRUE;
926: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => 'F',
927: p_folder_id => p_transaction_id);
928: hr_utility.set_location('plg flder started'||l_proc,20);
929: select count(*) into l_num_txns
930: from pqh_budget_pools

Line 942: pqh_bdgt_realloc_log_pkg.log_rule_for_entity

938: The error condition is being handled here, just in case.
939: */
940: l_rule_message := build_message (p_application_id => 8302,
941: p_message_cd => 'PQH_BGT_REALLOC_NO_TXN');
942: pqh_bdgt_realloc_log_pkg.log_rule_for_entity
943: (p_folder_id => p_transaction_id,
944: p_transaction_id => p_transaction_id,
945: p_txn_entity_type => 'F',
946: p_rule_level => 'E',

Line 953: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => 'T',

949: end if;
950: if p_status_flag then
951: for l_txn_rec in csr_txn_rec(p_folder_id => p_transaction_id) loop
952: hr_utility.set_location('txn is '||l_txn_rec.name,30);
953: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => 'T',
954: p_folder_id => p_transaction_id,
955: p_transaction_id => l_txn_rec.txn_id);
956: hr_utility.set_location('plg txn started'||l_proc,40);
957: -- Many-many rule checked here

Line 973: pqh_bdgt_realloc_log_pkg.log_rule_for_entity

969: hr_utility.set_Location('Many rcvrs exist in txn',60);
970: p_status_flag := FALSE;
971: l_rule_message := build_message (p_application_id => 8302,
972: p_message_cd => 'PQH_BGT_REALLOC_MANY_MANY');
973: pqh_bdgt_realloc_log_pkg.log_rule_for_entity
974: (p_folder_id => p_transaction_id,
975: p_transaction_id => l_txn_rec.txn_id,
976: p_txn_entity_type => 'T',
977: p_rule_level => 'E',

Line 999: pqh_bdgt_realloc_log_pkg.log_rule_for_entity

995: hr_utility.set_Location('donor has reserved amount only ',65);
996: p_status_flag := FALSE;
997: l_rule_message := build_message (p_application_id => 8302,
998: p_message_cd => 'PQH_BGT_REALLOC_RESERVED_AMT');
999: pqh_bdgt_realloc_log_pkg.log_rule_for_entity
1000: (p_folder_id => p_transaction_id,
1001: p_transaction_id => l_txn_rec.txn_id,
1002: p_txn_entity_type => 'T',
1003: p_rule_level => 'E',

Line 1011: pqh_bdgt_realloc_log_pkg.log_rule_for_entity

1007: -- error condition , No receiver
1008: hr_utility.set_Location('No rcvrs exist in txn',30);
1009: l_rule_message := build_message (p_application_id => 8302,
1010: p_message_cd => 'PQH_BGT_REALLOC_NO_RCVR');
1011: pqh_bdgt_realloc_log_pkg.log_rule_for_entity
1012: (p_folder_id => p_transaction_id,
1013: p_transaction_id => l_txn_rec.txn_id,
1014: p_txn_entity_type => 'T',
1015: p_rule_level => 'E',

Line 1025: pqh_bdgt_realloc_log_pkg.log_rule_for_entity

1021: hr_utility.set_Location('No donor exist in txn',40);
1022: p_status_flag := FALSE;
1023: l_rule_message := build_message (p_application_id => 8302,
1024: p_message_cd => 'PQH_BGT_REALLOC_NO_DONOR');
1025: pqh_bdgt_realloc_log_pkg.log_rule_for_entity
1026: (p_folder_id => p_transaction_id,
1027: p_transaction_id => l_txn_rec.txn_id,
1028: p_txn_entity_type => 'T',
1029: p_rule_level => 'E',

Line 1052: pqh_bdgt_realloc_log_pkg.log_rule_for_entity

1048: hr_utility.set_Location('donor has reserved amount only ',55);
1049: p_status_flag := FALSE;
1050: l_rule_message := build_message (p_application_id => 8302,
1051: p_message_cd => 'PQH_BGT_REALLOC_RESERVED_AMT');
1052: pqh_bdgt_realloc_log_pkg.log_rule_for_entity
1053: (p_folder_id => p_transaction_id,
1054: p_transaction_id => l_txn_rec.txn_id,
1055: p_txn_entity_type => 'T',
1056: p_rule_level => 'E',

Line 1065: pqh_bdgt_realloc_log_pkg.log_rule_for_entity

1061: -- error condition , No receiver
1062: hr_utility.set_Location('No rcvrs exist in txn',30);
1063: l_rule_message := build_message (p_application_id => 8302,
1064: p_message_cd => 'PQH_BGT_REALLOC_NO_RCVR');
1065: pqh_bdgt_realloc_log_pkg.log_rule_for_entity
1066: (p_folder_id => p_transaction_id,
1067: p_transaction_id => l_txn_rec.txn_id,
1068: p_txn_entity_type => 'T',
1069: p_rule_level => 'E',

Line 1087: pqh_bdgt_realloc_log_pkg.log_rule_for_entity

1083: hr_utility.set_Location('donor or rcvr null ',52);
1084: p_status_flag := FALSE;
1085: l_rule_message := build_message (p_application_id => 8302,
1086: p_message_cd => 'PQH_BGT_REALLOC_UNBAL_TXN');
1087: pqh_bdgt_realloc_log_pkg.log_rule_for_entity
1088: (p_folder_id => p_transaction_id,
1089: p_transaction_id => l_txn_rec.txn_id,
1090: p_txn_entity_type => 'T',
1091: p_rule_level => 'E',

Line 1099: pqh_bdgt_realloc_log_pkg.log_rule_for_entity

1095: hr_utility.set_Location('txn not balanced',50);
1096: p_status_flag := FALSE;
1097: l_rule_message := build_message (p_application_id => 8302,
1098: p_message_cd => 'PQH_BGT_REALLOC_UNBAL_TXN');
1099: pqh_bdgt_realloc_log_pkg.log_rule_for_entity
1100: (p_folder_id => p_transaction_id,
1101: p_transaction_id => l_txn_rec.txn_id,
1102: p_txn_entity_type => 'T',
1103: p_rule_level => 'E',

Line 1110: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => 'D',

1106: if p_status_flag then
1107: hr_utility.set_Location('validate donors '||l_proc,60);
1108: for l_donor_rec in csr_donor_rec(p_txn_id => l_txn_rec.txn_id) loop
1109: hr_utility.set_Location('donor log started '||l_proc,70);
1110: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => 'D',
1111: p_folder_id => p_transaction_id,
1112: p_transaction_id => l_txn_rec.txn_id,
1113: p_bdgt_entity_type => g_budget_entity,
1114: p_entity_id => l_donor_rec.entity_id); --modified by kgowripe l_donor_rec.donor_id);

Line 1125: pqh_bdgt_realloc_log_pkg.log_rule_for_entity

1121: p_status_flag := FALSE;
1122: l_rule_message := build_message (p_application_id => 8302,
1123: p_message_cd => 'PQH_BGT_REALLOC_DONOR_REA_NEG');
1124: hr_utility.set_Location('log rule '||l_proc,100);
1125: pqh_bdgt_realloc_log_pkg.log_rule_for_entity
1126: (p_folder_id => p_transaction_id,
1127: p_transaction_id => l_txn_rec.txn_id,
1128: p_txn_entity_type => 'DP',--modified by kgowripe 'D',
1129: p_entity_id => l_donor_rec.entity_id, --modified by kgowripe l_donor_rec.donor_id,

Line 1140: pqh_bdgt_realloc_log_pkg.log_rule_for_entity

1136: hr_utility.set_Location('donorperiod reserve negative',70);
1137: p_status_flag := FALSE;
1138: l_rule_message := build_message (p_application_id => 8302,
1139: p_message_cd => 'PQH_BGT_REALLOC_DONOR_RES_NEG');
1140: pqh_bdgt_realloc_log_pkg.log_rule_for_entity
1141: (p_folder_id => p_transaction_id,
1142: p_transaction_id => l_txn_rec.txn_id,
1143: p_txn_entity_type => 'DP',--modified by kgowripe 'D',
1144: p_entity_id => l_donor_rec.entity_id,--modified by kgowripe l_donor_rec.donor_id,

Line 1167: pqh_bdgt_realloc_log_pkg.log_rule_for_entity

1163: hr_utility.set_Location('donorperiod available is less',80);
1164: p_status_flag := FALSE;
1165: l_rule_message := build_message (p_application_id => 8302,
1166: p_message_cd => 'PQH_BGT_REALLOC_DONOR_LESS_AVL');
1167: pqh_bdgt_realloc_log_pkg.log_rule_for_entity
1168: (p_folder_id => p_transaction_id,
1169: p_transaction_id => l_txn_rec.txn_id,
1170: p_txn_entity_type => 'DP',--Modified by kgowripe 'D',
1171: p_entity_id => l_donor_rec.entity_id,--modified by kgowripe l_donor_rec.donor_id,

Line 1185: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => 'D',

1181: if not p_status_flag then
1182: exit;
1183: end if;
1184: end loop; -- donor periods inside the donor loop
1185: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => 'D',
1186: p_folder_id => p_transaction_id,
1187: p_transaction_id => l_txn_rec.txn_id,
1188: p_entity_id => l_donor_rec.entity_id);--modified by kgowripe l_donor_rec.donor_id);
1189: if not p_status_flag then

Line 1195: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => 'R',

1191: end if;
1192: end loop; -- donors inside the txn loop
1193: if p_status_flag then
1194: for l_rcvr_rec in csr_rcvr_rec(p_txn_id => l_txn_rec.txn_id) loop
1195: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => 'R',
1196: p_folder_id => p_transaction_id,
1197: p_transaction_id => l_txn_rec.txn_id,
1198: p_bdgt_entity_type => g_budget_entity,
1199: p_entity_id => l_rcvr_rec.entity_id);--modified by kgowripe l_rcvr_rec.rcvr_id);

Line 1207: pqh_bdgt_realloc_log_pkg.log_rule_for_entity

1203: hr_utility.set_Location('rcvrperiod starting 1204: p_status_flag := FALSE;
1205: l_rule_message := build_message (p_application_id => 8302,
1206: p_message_cd => 'PQH_BGT_REALLOC_RCVR_START_BGT');
1207: pqh_bdgt_realloc_log_pkg.log_rule_for_entity
1208: (p_folder_id => p_transaction_id,
1209: p_transaction_id => l_txn_rec.txn_id,
1210: p_txn_entity_type => 'RP',
1211: p_entity_id => l_rcvr_rec.entity_id,--modified by kgowripe l_rcvr_rec.rcvr_id,

Line 1222: pqh_bdgt_realloc_log_pkg.log_rule_for_entity

1218: hr_utility.set_Location('rcvrperiod ending >budget',110);
1219: p_status_flag := FALSE;
1220: l_rule_message := build_message (p_application_id => 8302,
1221: p_message_cd => 'PQH_BGT_REALLOC_RCVR_END_BGT');
1222: pqh_bdgt_realloc_log_pkg.log_rule_for_entity
1223: (p_folder_id => p_transaction_id,
1224: p_transaction_id => l_txn_rec.txn_id,
1225: p_txn_entity_type => 'RP',
1226: p_entity_id => l_rcvr_rec.entity_id,--modified by kgowripe l_rcvr_rec.rcvr_id,

Line 1237: pqh_bdgt_realloc_log_pkg.log_rule_for_entity

1233: hr_utility.set_Location('rcvrperiod starting 1234: p_status_flag := FALSE;
1235: l_rule_message := build_message (p_application_id => 8302,
1236: p_message_cd => 'PQH_BGT_REALLOC_RCVR_START_DON');
1237: pqh_bdgt_realloc_log_pkg.log_rule_for_entity
1238: (p_folder_id => p_transaction_id,
1239: p_transaction_id => l_txn_rec.txn_id,
1240: p_txn_entity_type => 'RP',
1241: p_entity_id => l_rcvr_rec.entity_id,--modified by kgowripe l_rcvr_rec.rcvr_id,

Line 1252: pqh_bdgt_realloc_log_pkg.log_rule_for_entity

1248: hr_utility.set_Location('rcvrperiod realloc negative',120);
1249: p_status_flag := FALSE;
1250: l_rule_message := build_message (p_application_id => 8302,
1251: p_message_cd => 'PQH_BGT_REALLOC_RCVR_REA_NEG');
1252: pqh_bdgt_realloc_log_pkg.log_rule_for_entity
1253: (p_folder_id => p_transaction_id,
1254: p_transaction_id => l_txn_rec.txn_id,
1255: p_txn_entity_type => 'RP',
1256: p_entity_id => l_rcvr_rec.entity_id,--modified by kgowripe l_rcvr_rec.rcvr_id,

Line 1265: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => 'R',

1261: if not p_status_flag then
1262: exit;
1263: end if;
1264: end loop; -- rcvr periods inside the rcvr loop
1265: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => 'R',
1266: p_folder_id => p_transaction_id,
1267: p_transaction_id => l_txn_rec.txn_id,
1268: p_entity_id => l_rcvr_rec.entity_id);
1269: if not p_status_flag then

Line 1276: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => 'T',

1272: end loop; -- rcvrs inside the txn loop
1273: else
1274: hr_utility.set_location('not going for rcvr, as error exist',140);
1275: end if;
1276: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => 'T',
1277: p_folder_id => p_transaction_id,
1278: p_transaction_id => l_txn_rec.txn_id);
1279: end if; -- endif, if txn had balance errors
1280: end if; -- endif, if txn had num errors

Line 1286: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => 'F',

1282: exit;
1283: end if;
1284: end loop; -- transactions inside the folder loop
1285: end if; -- if folder had txns
1286: pqh_bdgt_realloc_log_pkg.end_log(p_txn_entity_type => 'F',
1287: p_folder_id => p_transaction_id);
1288: hr_utility.set_location('done business rules',150);
1289: end apply_business_rules;
1290: