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.CTO_ORDER_PURGE dependencies on OE_DEBUG_PUB

Line 103: oe_debug_pub.add('cto_purge_tables: ' || 'Entering CTO_ORDER_PURGE.cto_purge_tables :

99:
100: BEGIN
101:
102: IF PG_DEBUG <> 0 THEN
103: oe_debug_pub.add('cto_purge_tables: ' || 'Entering CTO_ORDER_PURGE.cto_purge_tables :
104: header_id=> '||to_char(p_header_id),1);
105: END IF;
106:
107: --to check if rows exists for header_id in cto tables

Line 118: oe_debug_pub.add('cto_purge_tables: ' || 'No rows exist in CTO tables for header_id'||

114: EXCEPTION
115: WHEN OTHERS THEN
116: bcol_flag_1 := 'N';
117: IF PG_DEBUG <> 0 THEN
118: oe_debug_pub.add('cto_purge_tables: ' || 'No rows exist in CTO tables for header_id'||
119: p_header_id ,3);
120: END IF;
121: END;
122:

Line 132: oe_debug_pub.add('cto_purge_tables: ' || 'locked table bcol ',3);

128: OPEN c_bcol;
129:
130: CLOSE c_bcol;
131: IF PG_DEBUG <> 0 THEN
132: oe_debug_pub.add('cto_purge_tables: ' || 'locked table bcol ',3);
133: END IF;
134:
135: SELECT top_model_line_id
136: INTO l_top_model_line_id

Line 141: oe_debug_pub.add('cto_purge_tables: ' || 'select top_model_line_id for lock bom_cto_src_org',3);

137: FROM bom_cto_order_lines
138: where header_id= p_header_id
139: and rownum=1;
140: IF PG_DEBUG <> 0 THEN
141: oe_debug_pub.add('cto_purge_tables: ' || 'select top_model_line_id for lock bom_cto_src_org',3);
142: END IF;
143:
144:
145: --lock table bom_cto_src_orgs

Line 150: oe_debug_pub.add('cto_purge_tables: ' || 'locked table b_cto_src_orgs ',3);

146: OPEN c_b_src_org;
147:
148: CLOSE c_b_src_org;
149: IF PG_DEBUG <> 0 THEN
150: oe_debug_pub.add('cto_purge_tables: ' || 'locked table b_cto_src_orgs ',3);
151: END IF;
152:
153:
154: --Delete data from tables

Line 160: oe_debug_pub.add('cto_purge_tables: ' || 'deleted from bom_cto_src_orgs_b'||l_row_deleted,3);

156: DELETE FROM bom_cto_src_orgs_b --3524022
157: WHERE top_model_line_id=l_top_model_line_id;
158: l_row_deleted :=sql%rowcount;
159: IF PG_DEBUG <> 0 THEN
160: oe_debug_pub.add('cto_purge_tables: ' || 'deleted from bom_cto_src_orgs_b'||l_row_deleted,3);
161: END IF;
162:
163:
164:

Line 169: oe_debug_pub.add('cto_purge_tables: ' || 'deleted from bom_cto_order_lines'||l_row_deleted,3);

165: DELETE FROM bom_cto_order_lines
166: WHERE header_id = p_header_id;
167: l_row_deleted :=sql%rowcount;
168: IF PG_DEBUG <> 0 THEN
169: oe_debug_pub.add('cto_purge_tables: ' || 'deleted from bom_cto_order_lines'||l_row_deleted,3);
170: END IF;
171:
172:
173: END IF;

Line 180: oe_debug_pub.add('cto_purge_tables: ' || 'locked table bcod ',3);

176: OPEN c_bcod;
177:
178: CLOSE c_bcod;
179: IF PG_DEBUG <> 0 THEN
180: oe_debug_pub.add('cto_purge_tables: ' || 'locked table bcod ',3);
181: END IF;
182:
183: DELETE FROM bom_cto_order_demand
184: WHERE header_id = p_header_id;

Line 187: oe_debug_pub.add('cto_purge_tables: ' || 'deleted from bom_cto_order_demand'||l_row_deleted,3);

183: DELETE FROM bom_cto_order_demand
184: WHERE header_id = p_header_id;
185: l_row_deleted :=sql%rowcount;
186: IF PG_DEBUG <> 0 THEN
187: oe_debug_pub.add('cto_purge_tables: ' || 'deleted from bom_cto_order_demand'||l_row_deleted,3);
188: END IF;
189:
190: --bugfix#3763753
191: --Remove the pre-configure data from bcol and bcso_b

Line 200: oe_debug_pub.add('cto_purge_tables: ' || 'pre-cfg rows deleted from bom_cto_order_lines'||l_row_deleted,3);

196: delete from bom_cto_order_lines
197: where line_id < 0;
198: l_row_deleted :=sql%rowcount;
199: IF PG_DEBUG <> 0 THEN
200: oe_debug_pub.add('cto_purge_tables: ' || 'pre-cfg rows deleted from bom_cto_order_lines'||l_row_deleted,3);
201: END IF;
202:
203: delete from bom_cto_src_orgs_b
204: where line_id < 0;

Line 207: oe_debug_pub.add('cto_purge_tables: ' || 'pre-cfg rows deleted from bom_cto_src_orgs_b'||l_row_deleted,3);

203: delete from bom_cto_src_orgs_b
204: where line_id < 0;
205: l_row_deleted :=sql%rowcount;
206: IF PG_DEBUG <> 0 THEN
207: oe_debug_pub.add('cto_purge_tables: ' || 'pre-cfg rows deleted from bom_cto_src_orgs_b'||l_row_deleted,3);
208: END IF;
209: --end bugfix#3763753
210:
211: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 213: oe_debug_pub.add('cto_purge_tables: ' || 'Exiting CTO_ORDER_PURGE.cto_purge_tables :

209: --end bugfix#3763753
210:
211: x_return_status := FND_API.G_RET_STS_SUCCESS;
212: IF PG_DEBUG <> 0 THEN
213: oe_debug_pub.add('cto_purge_tables: ' || 'Exiting CTO_ORDER_PURGE.cto_purge_tables :
214: with '||x_return_status,1);
215: END IF;
216:
217:

Line 223: oe_debug_pub.add('cto_purge_tables: ' || sqlerrm,1);

219: WHEN OTHERS THEN
220: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
221: x_error_msg := 'ORDPUR:bom cto tables'||substr(sqlerrm,1,200);
222: IF PG_DEBUG <> 0 THEN
223: oe_debug_pub.add('cto_purge_tables: ' || sqlerrm,1);
224:
225: oe_debug_pub.add('cto_purge_tables: ' || 'Exiting CTO_ORDER_PURGE.cto_purge_tables : with '
226: ||x_return_status,1);
227: END IF;

Line 225: oe_debug_pub.add('cto_purge_tables: ' || 'Exiting CTO_ORDER_PURGE.cto_purge_tables : with '

221: x_error_msg := 'ORDPUR:bom cto tables'||substr(sqlerrm,1,200);
222: IF PG_DEBUG <> 0 THEN
223: oe_debug_pub.add('cto_purge_tables: ' || sqlerrm,1);
224:
225: oe_debug_pub.add('cto_purge_tables: ' || 'Exiting CTO_ORDER_PURGE.cto_purge_tables : with '
226: ||x_return_status,1);
227: END IF;
228:
229: