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_TRANSFER_PRICE_PK dependencies on OE_DEBUG_PUB

Line 64: oe_debug_pub.add('get_config_details:entering');

60: lStmtNumber := 10;
61: x_return_status := FND_API.G_RET_STS_SUCCESS;
62:
63: IF PG_DEBUG <> 0 THEN
64: oe_debug_pub.add('get_config_details:entering');
65: oe_debug_pub.add('get_config_details:ItemId::'||to_char(p_item_id));
66: oe_debug_pub.add('get_config_details:ModeId::'||to_char(p_mode_id));
67: oe_debug_pub.add('get_config_details:ConfigsOnly::'||p_configs_only);
68: END IF;

Line 65: oe_debug_pub.add('get_config_details:ItemId::'||to_char(p_item_id));

61: x_return_status := FND_API.G_RET_STS_SUCCESS;
62:
63: IF PG_DEBUG <> 0 THEN
64: oe_debug_pub.add('get_config_details:entering');
65: oe_debug_pub.add('get_config_details:ItemId::'||to_char(p_item_id));
66: oe_debug_pub.add('get_config_details:ModeId::'||to_char(p_mode_id));
67: oe_debug_pub.add('get_config_details:ConfigsOnly::'||p_configs_only);
68: END IF;
69:

Line 66: oe_debug_pub.add('get_config_details:ModeId::'||to_char(p_mode_id));

62:
63: IF PG_DEBUG <> 0 THEN
64: oe_debug_pub.add('get_config_details:entering');
65: oe_debug_pub.add('get_config_details:ItemId::'||to_char(p_item_id));
66: oe_debug_pub.add('get_config_details:ModeId::'||to_char(p_mode_id));
67: oe_debug_pub.add('get_config_details:ConfigsOnly::'||p_configs_only);
68: END IF;
69:
70: g_configs_only := p_configs_only;

Line 67: oe_debug_pub.add('get_config_details:ConfigsOnly::'||p_configs_only);

63: IF PG_DEBUG <> 0 THEN
64: oe_debug_pub.add('get_config_details:entering');
65: oe_debug_pub.add('get_config_details:ItemId::'||to_char(p_item_id));
66: oe_debug_pub.add('get_config_details:ModeId::'||to_char(p_mode_id));
67: oe_debug_pub.add('get_config_details:ConfigsOnly::'||p_configs_only);
68: END IF;
69:
70: g_configs_only := p_configs_only;
71: g_item_id := p_item_id;

Line 77: oe_debug_pub.add('get_config_details:Mode is OM');

73: IF p_mode_id = 1 THEN
74: lStmtNumber := 20;
75: -- mode is OM
76: IF PG_DEBUG <> 0 THEN
77: oe_debug_pub.add('get_config_details:Mode is OM');
78: END IF;
79:
80: BEGIN
81: /*select ato_line_id

Line 103: oe_debug_pub.add('get_config_details:l_line_id::'||to_char(l_line_id));

99: l_line_id := p_line_id;
100: End if;
101:
102: IF PG_DEBUG <> 0 THEN
103: oe_debug_pub.add('get_config_details:l_line_id::'||to_char(l_line_id));
104: END IF;
105:
106: EXCEPTION
107: WHEN no_data_found THEN

Line 109: oe_debug_pub.add('get_config_details:NDF:Mode is OM and no order line for this item.', 1);

105:
106: EXCEPTION
107: WHEN no_data_found THEN
108: IF PG_DEBUG <> 0 THEN
109: oe_debug_pub.add('get_config_details:NDF:Mode is OM and no order line for this item.', 1);
110: END IF;
111: raise FND_API.G_EXC_ERROR;
112: END;
113:

Line 122: oe_debug_pub.add('get_config_details:Grp Id::'||to_char(x_group_id));

118:
119: x_group_id := x_grp_id;
120:
121: IF PG_DEBUG <> 0 THEN
122: oe_debug_pub.add('get_config_details:Grp Id::'||to_char(x_group_id));
123: END IF;
124:
125: lStmtNumber := 40;
126:

Line 136: oe_debug_pub.add('get_config_details:get_config_details_bcol returned with unexp error',1);

132: x_return_status);
133:
134: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
135: IF PG_DEBUG <> 0 THEN
136: oe_debug_pub.add('get_config_details:get_config_details_bcol returned with unexp error',1);
137: END IF;
138: raise FND_API.G_EXC_UNEXPECTED_ERROR;
139:
140: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 142: oe_debug_pub.add('get_config_details:get_config_details_bcol returned with exp error',1);

138: raise FND_API.G_EXC_UNEXPECTED_ERROR;
139:
140: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
141: IF PG_DEBUG <> 0 THEN
142: oe_debug_pub.add('get_config_details:get_config_details_bcol returned with exp error',1);
143: END IF;
144: raise FND_API.G_EXC_ERROR;
145: END IF;
146:

Line 152: oe_debug_pub.add('get_config_details:Mode is BOM');

148:
149: lStmtNumber := 50;
150: -- mode is BOM
151: IF PG_DEBUG <> 0 THEN
152: oe_debug_pub.add('get_config_details:Mode is BOM');
153: END IF;
154:
155: BEGIN
156: select organization_id

Line 163: oe_debug_pub.add('get_config_details:p_organization_id::'||to_char(p_organization_id));

159: where assembly_item_id = p_item_id
160: and rownum = 1;
161:
162: IF PG_DEBUG <> 0 THEN
163: oe_debug_pub.add('get_config_details:p_organization_id::'||to_char(p_organization_id));
164: END IF;
165:
166: EXCEPTION
167: WHEN no_data_found THEN

Line 169: oe_debug_pub.add('get_config_details:NDF:Mode is BOM and no BOM exists for this item.', 1);

165:
166: EXCEPTION
167: WHEN no_data_found THEN
168: IF PG_DEBUG <> 0 THEN
169: oe_debug_pub.add('get_config_details:NDF:Mode is BOM and no BOM exists for this item.', 1);
170: END IF;
171: raise FND_API.G_EXC_ERROR;
172: END;
173:

Line 182: oe_debug_pub.add('get_config_details:xsGrp Id::'||to_char(x_group_id));

178:
179: x_group_id := x_grp_id;
180:
181: IF PG_DEBUG <> 0 THEN
182: oe_debug_pub.add('get_config_details:xsGrp Id::'||to_char(x_group_id));
183: END IF;
184:
185: lStmtNumber := 70;
186: get_config_details_bom

Line 196: oe_debug_pub.add('get_config_details:get_config_details_bom returned with unexp error',1);

192: x_return_status);
193:
194: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
195: IF PG_DEBUG <> 0 THEN
196: oe_debug_pub.add('get_config_details:get_config_details_bom returned with unexp error',1);
197: END IF;
198: raise FND_API.G_EXC_UNEXPECTED_ERROR;
199:
200: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 202: oe_debug_pub.add('get_config_details:get_config_details_bom returned with exp error',1);

198: raise FND_API.G_EXC_UNEXPECTED_ERROR;
199:
200: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
201: IF PG_DEBUG <> 0 THEN
202: oe_debug_pub.add('get_config_details:get_config_details_bom returned with exp error',1);
203: END IF;
204: raise FND_API.G_EXC_ERROR;
205: END IF;
206:

Line 212: oe_debug_pub.add('get_config_details:Mode is BOTH');

208:
209: -- mode is BOTH, check in OM first and then BOM
210: lStmtNumber := 80;
211: IF PG_DEBUG <> 0 THEN
212: oe_debug_pub.add('get_config_details:Mode is BOTH');
213: oe_debug_pub.add(' P_line_id = '||to_char(p_line_id),1);
214: END IF;
215:
216: BEGIN

Line 213: oe_debug_pub.add(' P_line_id = '||to_char(p_line_id),1);

209: -- mode is BOTH, check in OM first and then BOM
210: lStmtNumber := 80;
211: IF PG_DEBUG <> 0 THEN
212: oe_debug_pub.add('get_config_details:Mode is BOTH');
213: oe_debug_pub.add(' P_line_id = '||to_char(p_line_id),1);
214: END IF;
215:
216: BEGIN
217: If p_line_id is null Then

Line 233: oe_debug_pub.add('get_config_details:Config found in bcol, getting details from bcol');

229: l_line_id := p_line_id;
230: End if;
231:
232: IF PG_DEBUG <> 0 THEN
233: oe_debug_pub.add('get_config_details:Config found in bcol, getting details from bcol');
234: oe_debug_pub.add('get_config_details:l_line_id::'||to_char(l_line_id));
235: END IF;
236:
237: lStmtNumber := 90;

Line 234: oe_debug_pub.add('get_config_details:l_line_id::'||to_char(l_line_id));

230: End if;
231:
232: IF PG_DEBUG <> 0 THEN
233: oe_debug_pub.add('get_config_details:Config found in bcol, getting details from bcol');
234: oe_debug_pub.add('get_config_details:l_line_id::'||to_char(l_line_id));
235: END IF;
236:
237: lStmtNumber := 90;
238: select bom_explosion_temp_s.nextval

Line 245: oe_debug_pub.add('get_config_details:Grp Id::'||to_char(x_group_id));

241:
242: x_group_id := x_grp_id;
243:
244: IF PG_DEBUG <> 0 THEN
245: oe_debug_pub.add('get_config_details:Grp Id::'||to_char(x_group_id));
246: END IF;
247:
248: lStmtNumber := 100;
249: get_config_details_bcol

Line 258: oe_debug_pub.add('get_config_details:get_config_details_bcol returned with unexp error',1);

254: x_return_status);
255:
256: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
257: IF PG_DEBUG <> 0 THEN
258: oe_debug_pub.add('get_config_details:get_config_details_bcol returned with unexp error',1);
259: END IF;
260: raise FND_API.G_EXC_UNEXPECTED_ERROR;
261:
262: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 264: oe_debug_pub.add('get_config_details:get_config_details_bcol returned with exp error',1);

260: raise FND_API.G_EXC_UNEXPECTED_ERROR;
261:
262: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
263: IF PG_DEBUG <> 0 THEN
264: oe_debug_pub.add('get_config_details:get_config_details_bcol returned with exp error',1);
265: END IF;
266: raise FND_API.G_EXC_ERROR;
267: END IF;
268:

Line 274: oe_debug_pub.add('get_config_details:Mode is BOM');

270: WHEN NO_DATA_FOUND THEN
271: -- config does not exist in bcol, check in BOM
272:
273: IF PG_DEBUG <> 0 THEN
274: oe_debug_pub.add('get_config_details:Mode is BOM');
275: END IF;
276:
277: lStmtNumber := 110;
278: BEGIN

Line 286: oe_debug_pub.add('get_config_details:p_organization_id::'||to_char(p_organization_id));

282: where assembly_item_id = p_item_id
283: and rownum = 1;
284:
285: IF PG_DEBUG <> 0 THEN
286: oe_debug_pub.add('get_config_details:p_organization_id::'||to_char(p_organization_id));
287: END IF;
288:
289: EXCEPTION
290: WHEN no_data_found THEN

Line 292: oe_debug_pub.add('get_config_details:NDF:Mode is BOTH, but no order line and no BOM exists for this item.', 1);

288:
289: EXCEPTION
290: WHEN no_data_found THEN
291: IF PG_DEBUG <> 0 THEN
292: oe_debug_pub.add('get_config_details:NDF:Mode is BOTH, but no order line and no BOM exists for this item.', 1);
293: END IF;
294: raise FND_API.G_EXC_ERROR;
295: END;
296:

Line 305: oe_debug_pub.add('get_config_details:Grp Id::'||to_char(x_group_id));

301:
302: x_group_id := x_grp_id;
303:
304: IF PG_DEBUG <> 0 THEN
305: oe_debug_pub.add('get_config_details:Grp Id::'||to_char(x_group_id));
306: END IF;
307:
308: lStmtNumber := 130;
309: get_config_details_bom

Line 319: oe_debug_pub.add('get_config_details:get_config_details_bom returned with unexp error',1);

315: x_return_status);
316:
317: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
318: IF PG_DEBUG <> 0 THEN
319: oe_debug_pub.add('get_config_details:get_config_details_bom returned with unexp error',1);
320: END IF;
321: raise FND_API.G_EXC_UNEXPECTED_ERROR;
322:
323: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 325: oe_debug_pub.add('get_config_details:get_config_details_bom returned with exp error',1);

321: raise FND_API.G_EXC_UNEXPECTED_ERROR;
322:
323: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
324: IF PG_DEBUG <> 0 THEN
325: oe_debug_pub.add('get_config_details:get_config_details_bom returned with exp error',1);
326: END IF;
327: raise FND_API.G_EXC_ERROR;
328: END IF;
329:

Line 335: oe_debug_pub.add('get_config_details:returning with status',1);

331:
332: END IF; -- mode
333:
334: IF PG_DEBUG <> 0 THEN
335: oe_debug_pub.add('get_config_details:returning with status',1);
336: END IF;
337:
338: EXCEPTION
339: WHEN NO_DATA_FOUND THEN

Line 341: oe_debug_pub.add('get_config_details:unexp error::'||lStmtNumber||sqlerrm,1);

337:
338: EXCEPTION
339: WHEN NO_DATA_FOUND THEN
340: IF PG_DEBUG <> 0 THEN
341: oe_debug_pub.add('get_config_details:unexp error::'||lStmtNumber||sqlerrm,1);
342: END IF;
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: CTO_MSG_PUB.Count_And_Get
345: (p_msg_count => x_msg_count

Line 351: oe_debug_pub.add('get_config_details:unexp error::'||lStmtNumber||sqlerrm,1);

347: );
348:
349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
350: IF PG_DEBUG <> 0 THEN
351: oe_debug_pub.add('get_config_details:unexp error::'||lStmtNumber||sqlerrm,1);
352: END IF;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: CTO_MSG_PUB.Count_And_Get
355: (p_msg_count => x_msg_count

Line 361: oe_debug_pub.add('get_config_details:exp error::'||lStmtNumber||sqlerrm,1);

357: );
358:
359: WHEN FND_API.G_EXC_ERROR THEN
360: IF PG_DEBUG <> 0 THEN
361: oe_debug_pub.add('get_config_details:exp error::'||lStmtNumber||sqlerrm,1);
362: END IF;
363: x_return_status := FND_API.G_RET_STS_ERROR;
364: CTO_MSG_PUB.Count_And_Get
365: (p_msg_count => x_msg_count

Line 370: oe_debug_pub.add('get_config_details:others::'||lStmtNumber||sqlerrm,1);

366: ,p_msg_data => x_msg_data);
367:
368: WHEN OTHERS THEN
369: IF PG_DEBUG <> 0 THEN
370: oe_debug_pub.add('get_config_details:others::'||lStmtNumber||sqlerrm,1);
371: END IF;
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
374: FND_MSG_PUB.Add_Exc_Msg

Line 439: oe_debug_pub.add('get_config_details_bcol:entering');

435: cto_wip_workflow_api_pk.cto_debug('get_config_details_bcol:', 'p_grp_id::'||to_char(p_grp_id));
436: cto_wip_workflow_api_pk.cto_debug('get_config_details_bcol:', 'p_line_id::'||to_char(p_line_id));
437: End if;
438: IF PG_DEBUG <> 0 THEN
439: oe_debug_pub.add('get_config_details_bcol:entering');
440: oe_debug_pub.add('get_config_details_bcol:p_grp_id::'||to_char(p_grp_id));
441: oe_debug_pub.add('get_config_details_bcol:p_line_id::'||to_char(p_line_id));
442: oe_debug_pub.add('get_config_details_bcol:l_oeval_org_id::'||to_char(l_oeval_org_id));
443: END IF;

Line 440: oe_debug_pub.add('get_config_details_bcol:p_grp_id::'||to_char(p_grp_id));

436: cto_wip_workflow_api_pk.cto_debug('get_config_details_bcol:', 'p_line_id::'||to_char(p_line_id));
437: End if;
438: IF PG_DEBUG <> 0 THEN
439: oe_debug_pub.add('get_config_details_bcol:entering');
440: oe_debug_pub.add('get_config_details_bcol:p_grp_id::'||to_char(p_grp_id));
441: oe_debug_pub.add('get_config_details_bcol:p_line_id::'||to_char(p_line_id));
442: oe_debug_pub.add('get_config_details_bcol:l_oeval_org_id::'||to_char(l_oeval_org_id));
443: END IF;
444:

Line 441: oe_debug_pub.add('get_config_details_bcol:p_line_id::'||to_char(p_line_id));

437: End if;
438: IF PG_DEBUG <> 0 THEN
439: oe_debug_pub.add('get_config_details_bcol:entering');
440: oe_debug_pub.add('get_config_details_bcol:p_grp_id::'||to_char(p_grp_id));
441: oe_debug_pub.add('get_config_details_bcol:p_line_id::'||to_char(p_line_id));
442: oe_debug_pub.add('get_config_details_bcol:l_oeval_org_id::'||to_char(l_oeval_org_id));
443: END IF;
444:
445: IF (g_configs_only = 'N') THEN

Line 442: oe_debug_pub.add('get_config_details_bcol:l_oeval_org_id::'||to_char(l_oeval_org_id));

438: IF PG_DEBUG <> 0 THEN
439: oe_debug_pub.add('get_config_details_bcol:entering');
440: oe_debug_pub.add('get_config_details_bcol:p_grp_id::'||to_char(p_grp_id));
441: oe_debug_pub.add('get_config_details_bcol:p_line_id::'||to_char(p_line_id));
442: oe_debug_pub.add('get_config_details_bcol:l_oeval_org_id::'||to_char(l_oeval_org_id));
443: END IF;
444:
445: IF (g_configs_only = 'N') THEN
446: -- insert details from order lines

Line 572: oe_debug_pub.add ('get_config_details_bcol:Row Count : ' || rowcount, 2);

568:
569: rowcount := SQL%ROWCOUNT;
570:
571: IF PG_DEBUG <> 0 THEN
572: oe_debug_pub.add ('get_config_details_bcol:Row Count : ' || rowcount, 2);
573: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:', 'Row Count:'||rowcount);
574:
575: END IF;
576:

Line 667: oe_debug_pub.add ('get_config_details_bom:Row Count : ' || rowcount, 2);

663:
664: rowcount := SQL%ROWCOUNT;
665:
666: IF PG_DEBUG <> 0 THEN
667: oe_debug_pub.add ('get_config_details_bom:Row Count : ' || rowcount, 2);
668: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:', 'Row Count:'||rowcount);
669:
670: END IF;
671:

Line 678: oe_debug_pub.add('get_config_details_bcol:rows inserted into bom_expl_temp::'||to_char(sql%rowcount));

674: END IF; /* configs only */
675:
676: lStmtNumber := 40;
677: IF PG_DEBUG <> 0 THEN
678: oe_debug_pub.add('get_config_details_bcol:rows inserted into bom_expl_temp::'||to_char(sql%rowcount));
679: cto_wip_workflow_api_pk.cto_debug('get_config_details_bcol:', '
680: rows inserted into bom_expl_temp::'||to_char(sql%rowcount));
681:
682: END IF;

Line 687: oe_debug_pub.add('get_config_details_bcol:unexp error::'||lStmtNumber||sqlerrm,1);

683:
684: EXCEPTION
685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
686: IF PG_DEBUG <> 0 THEN
687: oe_debug_pub.add('get_config_details_bcol:unexp error::'||lStmtNumber||sqlerrm,1);
688: END IF;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: CTO_MSG_PUB.Count_And_Get
691: (p_msg_count => x_msg_count

Line 697: oe_debug_pub.add('get_config_details_bcol:exp error::'||lStmtNumber||sqlerrm,1);

693: );
694:
695: WHEN FND_API.G_EXC_ERROR THEN
696: IF PG_DEBUG <> 0 THEN
697: oe_debug_pub.add('get_config_details_bcol:exp error::'||lStmtNumber||sqlerrm,1);
698: END IF;
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: CTO_MSG_PUB.Count_And_Get
701: (p_msg_count => x_msg_count

Line 706: oe_debug_pub.add('get_config_details_bcol:others::'||lStmtNumber||sqlerrm,1);

702: ,p_msg_data => x_msg_data);
703:
704: WHEN OTHERS THEN
705: IF PG_DEBUG <> 0 THEN
706: oe_debug_pub.add('get_config_details_bcol:others::'||lStmtNumber||sqlerrm,1);
707: END IF;
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
710: FND_MSG_PUB.Add_Exc_Msg

Line 754: oe_debug_pub.add('get_config_details_bom:entering');

750: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:','entering');
751: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:','p_grp_id::'||to_char(p_grp_id));
752: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:','p_item_id::'||to_char(p_item_id));
753:
754: oe_debug_pub.add('get_config_details_bom:entering');
755: oe_debug_pub.add('get_config_details_bom:p_grp_id::'||to_char(p_grp_id));
756: oe_debug_pub.add('get_config_details_bom:p_item_id::'||to_char(p_item_id));
757: END IF;
758:

Line 755: oe_debug_pub.add('get_config_details_bom:p_grp_id::'||to_char(p_grp_id));

751: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:','p_grp_id::'||to_char(p_grp_id));
752: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:','p_item_id::'||to_char(p_item_id));
753:
754: oe_debug_pub.add('get_config_details_bom:entering');
755: oe_debug_pub.add('get_config_details_bom:p_grp_id::'||to_char(p_grp_id));
756: oe_debug_pub.add('get_config_details_bom:p_item_id::'||to_char(p_item_id));
757: END IF;
758:
759: IF (g_configs_only = 'N') THEN

Line 756: oe_debug_pub.add('get_config_details_bom:p_item_id::'||to_char(p_item_id));

752: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:','p_item_id::'||to_char(p_item_id));
753:
754: oe_debug_pub.add('get_config_details_bom:entering');
755: oe_debug_pub.add('get_config_details_bom:p_grp_id::'||to_char(p_grp_id));
756: oe_debug_pub.add('get_config_details_bom:p_item_id::'||to_char(p_item_id));
757: END IF;
758:
759: IF (g_configs_only = 'N') THEN
760:

Line 806: oe_debug_pub.add('get_config_details_bom:rowcount::'||sql%rowcount);

802: and msi.organization_id = p_organization_id;
803:
804:
805: IF PG_DEBUG <> 0 THEN
806: oe_debug_pub.add('get_config_details_bom:rowcount::'||sql%rowcount);
807: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:', 'rowcount::'||sql%rowcount);
808:
809: END IF;
810:

Line 875: oe_debug_pub.add ('get_config_details_bom:Row Count : ' || rowcount, 2);

871:
872: rowcount := SQL%ROWCOUNT;
873:
874: IF PG_DEBUG <> 0 THEN
875: oe_debug_pub.add ('get_config_details_bom:Row Count : ' || rowcount, 2);
876: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:', 'Row Count:'||rowcount);
877:
878: END IF;
879:

Line 929: oe_debug_pub.add('get_config_details_bom:rowcount::'||sql%rowcount);

925: and msi.organization_id = p_organization_id
926: and msi.base_item_id is not null;
927:
928: IF PG_DEBUG <> 0 THEN
929: oe_debug_pub.add('get_config_details_bom:rowcount::'||sql%rowcount);
930: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:', 'rowcount::'||sql%rowcount);
931:
932: END IF;
933:

Line 993: oe_debug_pub.add ('get_config_details_bom:Row Count : ' || rowcount, 2);

989:
990: rowcount := SQL%ROWCOUNT;
991:
992: IF PG_DEBUG <> 0 THEN
993: oe_debug_pub.add ('get_config_details_bom:Row Count : ' || rowcount, 2);
994: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:', 'Row Count:'||rowcount);
995:
996: END IF;
997:

Line 1005: oe_debug_pub.add('get_config_details_bom:unexp error::'||lStmtNumber||sqlerrm,1);

1001:
1002: EXCEPTION
1003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1004: IF PG_DEBUG <> 0 THEN
1005: oe_debug_pub.add('get_config_details_bom:unexp error::'||lStmtNumber||sqlerrm,1);
1006: END IF;
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008: CTO_MSG_PUB.Count_And_Get
1009: (p_msg_count => x_msg_count

Line 1015: oe_debug_pub.add('get_config_details_bom:exp error::'||lStmtNumber||sqlerrm,1);

1011: );
1012:
1013: WHEN FND_API.G_EXC_ERROR THEN
1014: IF PG_DEBUG <> 0 THEN
1015: oe_debug_pub.add('get_config_details_bom:exp error::'||lStmtNumber||sqlerrm,1);
1016: END IF;
1017: x_return_status := FND_API.G_RET_STS_ERROR;
1018: CTO_MSG_PUB.Count_And_Get
1019: (p_msg_count => x_msg_count

Line 1024: oe_debug_pub.add('get_config_details_bom:others::'||lStmtNumber||sqlerrm,1);

1020: ,p_msg_data => x_msg_data);
1021:
1022: WHEN OTHERS THEN
1023: IF PG_DEBUG <> 0 THEN
1024: oe_debug_pub.add('get_config_details_bom:others::'||lStmtNumber||sqlerrm,1);
1025: END IF;
1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1027: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1028: FND_MSG_PUB.Add_Exc_Msg