DBA Data[Home] [Help]

APPS.OE_MESSAGE_PURGE_PVT dependencies on OE_DEBUG_PUB

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

56: l_customer NUMBER := NULL;
57: l_debug_file VARCHAR2(500);
58:
59: --
60: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
61: --
62: BEGIN
63: --Bug#4220950
64: errbuf := '';

Line 69: l_debug_file := OE_DEBUG_PUB.set_debug_mode ('FILE');

65: retcode := 0;
66:
67: FND_FILE.Put_Line(FND_FILE.OUTPUT,'Order Management Message Purge Concurrent Program');
68: FND_FILE.Put_Line(FND_FILE.OUTPUT, '');
69: l_debug_file := OE_DEBUG_PUB.set_debug_mode ('FILE');
70: FND_FILE.Put_Line(FND_FILE.OUTPUT,'Debug File: ' || l_debug_file);
71: FND_FILE.Put_Line(FND_FILE.OUTPUT, '');
72:
73: IF l_debug_level > 0 THEN

Line 74: oe_debug_pub.add( 'ENTER MESSAGE PURGE' ) ;

70: FND_FILE.Put_Line(FND_FILE.OUTPUT,'Debug File: ' || l_debug_file);
71: FND_FILE.Put_Line(FND_FILE.OUTPUT, '');
72:
73: IF l_debug_level > 0 THEN
74: oe_debug_pub.add( 'ENTER MESSAGE PURGE' ) ;
75: END IF;
76: IF l_debug_level > 0 THEN
77: oe_debug_pub.add( 'P_COMMIT:'||TO_CHAR ( P_COMMIT ) ||'.' ) ;
78: END IF;

Line 77: oe_debug_pub.add( 'P_COMMIT:'||TO_CHAR ( P_COMMIT ) ||'.' ) ;

73: IF l_debug_level > 0 THEN
74: oe_debug_pub.add( 'ENTER MESSAGE PURGE' ) ;
75: END IF;
76: IF l_debug_level > 0 THEN
77: oe_debug_pub.add( 'P_COMMIT:'||TO_CHAR ( P_COMMIT ) ||'.' ) ;
78: END IF;
79: IF l_debug_level > 0 THEN
80: oe_debug_pub.add( 'P_START_DATE:'||P_START_DATE||'.' ) ;
81: END IF;

Line 80: oe_debug_pub.add( 'P_START_DATE:'||P_START_DATE||'.' ) ;

76: IF l_debug_level > 0 THEN
77: oe_debug_pub.add( 'P_COMMIT:'||TO_CHAR ( P_COMMIT ) ||'.' ) ;
78: END IF;
79: IF l_debug_level > 0 THEN
80: oe_debug_pub.add( 'P_START_DATE:'||P_START_DATE||'.' ) ;
81: END IF;
82: IF l_debug_level > 0 THEN
83: oe_debug_pub.add( 'P_END_DATE:'||P_END_DATE||'.' ) ;
84: END IF;

Line 83: oe_debug_pub.add( 'P_END_DATE:'||P_END_DATE||'.' ) ;

79: IF l_debug_level > 0 THEN
80: oe_debug_pub.add( 'P_START_DATE:'||P_START_DATE||'.' ) ;
81: END IF;
82: IF l_debug_level > 0 THEN
83: oe_debug_pub.add( 'P_END_DATE:'||P_END_DATE||'.' ) ;
84: END IF;
85: IF l_debug_level > 0 THEN
86: oe_debug_pub.add( 'P_MESSAGE_SOURCE:'||P_MESSAGE_SOURCE||'.' ) ;
87: END IF;

Line 86: oe_debug_pub.add( 'P_MESSAGE_SOURCE:'||P_MESSAGE_SOURCE||'.' ) ;

82: IF l_debug_level > 0 THEN
83: oe_debug_pub.add( 'P_END_DATE:'||P_END_DATE||'.' ) ;
84: END IF;
85: IF l_debug_level > 0 THEN
86: oe_debug_pub.add( 'P_MESSAGE_SOURCE:'||P_MESSAGE_SOURCE||'.' ) ;
87: END IF;
88: IF l_debug_level > 0 THEN
89: oe_debug_pub.add( 'P_CUSTOMER_ID_NAME:'||P_CUSTOMER_ID_NAME||'.' ) ;
90: END IF;

Line 89: oe_debug_pub.add( 'P_CUSTOMER_ID_NAME:'||P_CUSTOMER_ID_NAME||'.' ) ;

85: IF l_debug_level > 0 THEN
86: oe_debug_pub.add( 'P_MESSAGE_SOURCE:'||P_MESSAGE_SOURCE||'.' ) ;
87: END IF;
88: IF l_debug_level > 0 THEN
89: oe_debug_pub.add( 'P_CUSTOMER_ID_NAME:'||P_CUSTOMER_ID_NAME||'.' ) ;
90: END IF;
91: IF l_debug_level > 0 THEN
92: oe_debug_pub.add( 'P_CUSTOMER_ID_NUMBER:'||P_CUSTOMER_ID_NUMBER||'.' ) ;
93: END IF;

Line 92: oe_debug_pub.add( 'P_CUSTOMER_ID_NUMBER:'||P_CUSTOMER_ID_NUMBER||'.' ) ;

88: IF l_debug_level > 0 THEN
89: oe_debug_pub.add( 'P_CUSTOMER_ID_NAME:'||P_CUSTOMER_ID_NAME||'.' ) ;
90: END IF;
91: IF l_debug_level > 0 THEN
92: oe_debug_pub.add( 'P_CUSTOMER_ID_NUMBER:'||P_CUSTOMER_ID_NUMBER||'.' ) ;
93: END IF;
94: IF l_debug_level > 0 THEN
95: oe_debug_pub.add( 'P_ORDER_TYPE_ID:'||TO_CHAR ( P_ORDER_TYPE_ID ) ||'.' ) ;
96: END IF;

Line 95: oe_debug_pub.add( 'P_ORDER_TYPE_ID:'||TO_CHAR ( P_ORDER_TYPE_ID ) ||'.' ) ;

91: IF l_debug_level > 0 THEN
92: oe_debug_pub.add( 'P_CUSTOMER_ID_NUMBER:'||P_CUSTOMER_ID_NUMBER||'.' ) ;
93: END IF;
94: IF l_debug_level > 0 THEN
95: oe_debug_pub.add( 'P_ORDER_TYPE_ID:'||TO_CHAR ( P_ORDER_TYPE_ID ) ||'.' ) ;
96: END IF;
97: IF l_debug_level > 0 THEN
98: oe_debug_pub.add( 'P_START_ORDER_NUM:'||TO_CHAR ( P_START_ORDER_NUM ) ||'.' ) ;
99: END IF;

Line 98: oe_debug_pub.add( 'P_START_ORDER_NUM:'||TO_CHAR ( P_START_ORDER_NUM ) ||'.' ) ;

94: IF l_debug_level > 0 THEN
95: oe_debug_pub.add( 'P_ORDER_TYPE_ID:'||TO_CHAR ( P_ORDER_TYPE_ID ) ||'.' ) ;
96: END IF;
97: IF l_debug_level > 0 THEN
98: oe_debug_pub.add( 'P_START_ORDER_NUM:'||TO_CHAR ( P_START_ORDER_NUM ) ||'.' ) ;
99: END IF;
100: IF l_debug_level > 0 THEN
101: oe_debug_pub.add( 'P_END_ORDER_NUM:'||TO_CHAR ( P_END_ORDER_NUM ) ||'.' ) ;
102: END IF;

Line 101: oe_debug_pub.add( 'P_END_ORDER_NUM:'||TO_CHAR ( P_END_ORDER_NUM ) ||'.' ) ;

97: IF l_debug_level > 0 THEN
98: oe_debug_pub.add( 'P_START_ORDER_NUM:'||TO_CHAR ( P_START_ORDER_NUM ) ||'.' ) ;
99: END IF;
100: IF l_debug_level > 0 THEN
101: oe_debug_pub.add( 'P_END_ORDER_NUM:'||TO_CHAR ( P_END_ORDER_NUM ) ||'.' ) ;
102: END IF;
103:
104: l_start := TRUNC(TO_DATE(p_start_date,'YYYY/MM/DD HH24:MI:SS'));
105: l_end := TRUNC(TO_DATE(p_end_date,'YYYY/MM/DD HH24:MI:SS'));

Line 133: oe_debug_pub.add( 'EXIT MESSAGE PURGE' ) ;

129:
130: COMMIT;
131:
132: IF l_debug_level > 0 THEN
133: oe_debug_pub.add( 'EXIT MESSAGE PURGE' ) ;
134: END IF;
135: FND_FILE.Put_Line(FND_FILE.OUTPUT, '');
136: FND_FILE.Put_Line(FND_FILE.OUTPUT,'End of Message Purge Concurrent Program');
137: