45: l_line_num VARCHAR2(1000);
46: newline CONSTANT VARCHAR2(2) := fnd_global.local_chr(10);
47:
48: --
49: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
50: --
51:
52: BEGIN
53:
193: l_eid NUMBER;
194: l_nid NUMBER;
195:
196: --
197: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
198: --
199:
200: BEGIN
201: --
248:
249: EXCEPTION
250: WHEN OTHERS THEN
251: IF l_debug_level > 0 THEN
252: Oe_debug_pub.ADD('Exception in sending notification for user : ' ||
253: G_USER_TAB(idx).user_id);
254: Oe_debug_pub.ADD('Error => ' || SQLERRM);
255: END IF;
256: -- Rollback for this user and continue sending for other users
250: WHEN OTHERS THEN
251: IF l_debug_level > 0 THEN
252: Oe_debug_pub.ADD('Exception in sending notification for user : ' ||
253: G_USER_TAB(idx).user_id);
254: Oe_debug_pub.ADD('Error => ' || SQLERRM);
255: END IF;
256: -- Rollback for this user and continue sending for other users
257: ROLLBACK TO PRE_NOTIFICATION;
258: CONTINUE;
317: l_result VARCHAR2(10);
318: l_item_type VARCHAR2(100);
319:
320: --
321: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
322: --
323:
324: BEGIN
325:
417: l_invoice_to_org_id NUMBER;
418: l_sold_to_org_id NUMBER;
419:
420: --
421: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
422: --
423:
424: BEGIN
425:
496:
497: EXCEPTION
498: WHEN NO_DATA_FOUND THEN
499: IF l_debug_level>0 THEN
500: Oe_debug_pub.ADD('No contacts found to send notification.');
501: END IF;
502: END;
503: END IF;
504: