APPS.IBY_FREQ_OF_PURCH_PKG dependencies on IBY_DEBUG_PUB

Line 70: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

66: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.eval_factor';
67:
68:
69: BEGIN
70: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
71:
72: if ( c_get_fop_instrnum%isopen ) then
73: close c_get_fop_instrnum;
74: end if;

Line 131: iby_debug_pub.add('earliest from date:=' || TO_CHAR(l_fromDate),

127: l_ccnum_hash := iby_security_pkg.get_hash(i_ccNumber,'F');
128: l_ccnum_obfs := iby_utility_pvt.encode64(i_ccNumber);
129: end if;
130:
131: iby_debug_pub.add('earliest from date:=' || TO_CHAR(l_fromDate),
132: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
133:
134:
135: /*

Line 132: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

128: l_ccnum_obfs := iby_utility_pvt.encode64(i_ccNumber);
129: end if;
130:
131: iby_debug_pub.add('earliest from date:=' || TO_CHAR(l_fromDate),
132: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
133:
134:
135: /*
136: ** select the number of purchases after "fromDate" value

Line 146: iby_debug_pub.add('matching instr id cnt:=' || l_purchases_counter,

142: FETCH c_get_fop_instrid into l_purchases_counter;
143: CLOSE c_get_fop_instrid;
144:
145: l_no_of_purchases := l_purchases_counter + l_no_of_purchases;
146: iby_debug_pub.add('matching instr id cnt:=' || l_purchases_counter,
147: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
148: END IF;
149:
150: IF (NOT i_ccNumber IS NULL) THEN

Line 147: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

143: CLOSE c_get_fop_instrid;
144:
145: l_no_of_purchases := l_purchases_counter + l_no_of_purchases;
146: iby_debug_pub.add('matching instr id cnt:=' || l_purchases_counter,
147: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
148: END IF;
149:
150: IF (NOT i_ccNumber IS NULL) THEN
151: OPEN c_get_fop_instrnum(i_payeeid,i_ccNumber,l_ccnum_hash,l_fromdate);

Line 156: iby_debug_pub.add('matching instr id cnt:=' || l_purchases_counter,

152: FETCH c_get_fop_instrnum into l_purchases_counter;
153: CLOSE c_get_fop_instrnum;
154:
155: l_no_of_purchases := l_purchases_counter + l_no_of_purchases;
156: iby_debug_pub.add('matching instr id cnt:=' || l_purchases_counter,
157: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
158: END IF;
159:
160: iby_debug_pub.add('max purchases:=' || l_max_purchases,

Line 157: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

153: CLOSE c_get_fop_instrnum;
154:
155: l_no_of_purchases := l_purchases_counter + l_no_of_purchases;
156: iby_debug_pub.add('matching instr id cnt:=' || l_purchases_counter,
157: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
158: END IF;
159:
160: iby_debug_pub.add('max purchases:=' || l_max_purchases,
161: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 160: iby_debug_pub.add('max purchases:=' || l_max_purchases,

156: iby_debug_pub.add('matching instr id cnt:=' || l_purchases_counter,
157: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
158: END IF;
159:
160: iby_debug_pub.add('max purchases:=' || l_max_purchases,
161: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
162:
163: if ( l_no_of_purchases >= l_max_purchases ) then
164: /*

Line 161: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

157: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
158: END IF;
159:
160: iby_debug_pub.add('max purchases:=' || l_max_purchases,
161: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
162:
163: if ( l_no_of_purchases >= l_max_purchases ) then
164: /*
165: ** get the value for high risk and return