APPS.OE_CREDIT_SUMMARIES_PKG dependencies on OE_DEBUG_PUB

Line 30: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

26:
27: l_id number;
28:
29: --
30: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
31: --
32: BEGIN
33: l_id := NULL;
34: BEGIN

Line 49: oe_debug_pub.add('OEXCRSMB Exception - No data found in get_party_id ');

45: WHEN NO_DATA_FOUND
46: THEN
47:
48: l_id := NULL ;
49: oe_debug_pub.add('OEXCRSMB Exception - No data found in get_party_id ');
50:
51: END;
52:
53:

Line 54: oe_debug_pub.add(' Return l_id => '|| l_id );

50:
51: END;
52:
53:
54: oe_debug_pub.add(' Return l_id => '|| l_id );
55:
56: RETURN (l_id);
57:
58: EXCEPTION

Line 98: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

94: IS
95: l_party_id NUMBER ;
96:
97: --
98: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
99: --
100: BEGIN
101: OE_DEBUG_PUB.ADD('OEXCRSMB - IN Insert row ');
102:

Line 101: OE_DEBUG_PUB.ADD('OEXCRSMB - IN Insert row ');

97: --
98: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
99: --
100: BEGIN
101: OE_DEBUG_PUB.ADD('OEXCRSMB - IN Insert row ');
102:
103: l_party_id := NULL ;
104: l_party_id :=
105: get_party_id(p_cust_account_id => p_cust_account_id );

Line 150: OE_DEBUG_PUB.ADD('OEXCRSMB - OUT NOCOPY Insert row ');

146: , -1
147: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
148: );
149:
150: OE_DEBUG_PUB.ADD('OEXCRSMB - OUT NOCOPY Insert row ');
151:
152: EXCEPTION
153: WHEN OTHERS THEN
154: IF OE_MSG_PUB.Check_msg_level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 183: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

179: , p_request_id IN NUMBER
180: )
181: IS
182: --
183: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
184: --
185: BEGIN
186: OE_DEBUG_PUB.ADD('OEXCRSMB - IN Update row');
187: UPDATE oe_credit_summaries

Line 186: OE_DEBUG_PUB.ADD('OEXCRSMB - IN Update row');

182: --
183: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
184: --
185: BEGIN
186: OE_DEBUG_PUB.ADD('OEXCRSMB - IN Update row');
187: UPDATE oe_credit_summaries
188: SET
189: balance = p_balance
190: , last_update_date = p_last_update_date

Line 199: OE_DEBUG_PUB.ADD('OEXCRSMB - OUT NOCOPY Update row');

195: , program_update_date = p_program_update_date
196: , request_id = p_request_id
197: WHERE ROWID = CHARTOROWID(p_row_id);
198:
199: OE_DEBUG_PUB.ADD('OEXCRSMB - OUT NOCOPY Update row');
200:
201:
202: EXCEPTION
203: WHEN OTHERS THEN

Line 225: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

221: ( p_row_id IN VARCHAR2
222: )
223: IS
224: --
225: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
226: --
227: BEGIN
228: DELETE FROM oe_credit_summaries
229: WHERE ROWID = CHARTOROWID(p_row_id);