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

Line 71: oe_debug_pub.add('cto_fs: ' || 'Expected error in cto_create_fs.', 1);

67: x_msg_name);
68:
69: if (l_x_return_status = FND_API.G_RET_STS_ERROR) then
70: IF PG_DEBUG <> 0 THEN
71: oe_debug_pub.add('cto_fs: ' || 'Expected error in cto_create_fs.', 1);
72: END IF;
73: raise FND_API.G_EXC_ERROR;
74:
75: elsif (l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

Line 77: oe_debug_pub.add('cto_fs: ' || 'UnExpected error in cto_create_fs.', 1);

73: raise FND_API.G_EXC_ERROR;
74:
75: elsif (l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
76: IF PG_DEBUG <> 0 THEN
77: oe_debug_pub.add('cto_fs: ' || 'UnExpected error in cto_create_fs.', 1);
78: END IF;
79: raise FND_API.G_EXC_UNEXPECTED_ERROR;
80:
81: end if;

Line 84: oe_debug_pub.add('cto_fs: ' || 'Success in cto_create_fs.', 1);

80:
81: end if;
82:
83: IF PG_DEBUG <> 0 THEN
84: oe_debug_pub.add('cto_fs: ' || 'Success in cto_create_fs.', 1);
85: END IF;
86:
87: l_stmt_num := 110;
88: cto_schedule_fs (p_config_line_id,

Line 97: oe_debug_pub.add('cto_fs: ' || 'Expected error in cto_schedule_fs.', 1);

93: x_msg_name);
94:
95: if (l_x_return_status = FND_API.G_RET_STS_ERROR) then
96: IF PG_DEBUG <> 0 THEN
97: oe_debug_pub.add('cto_fs: ' || 'Expected error in cto_schedule_fs.', 1);
98: END IF;
99: raise FND_API.G_EXC_ERROR;
100:
101: elsif (l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

Line 103: oe_debug_pub.add('cto_fs: ' || 'UnExpected error in cto_schedule_fs.', 1);

99: raise FND_API.G_EXC_ERROR;
100:
101: elsif (l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
102: IF PG_DEBUG <> 0 THEN
103: oe_debug_pub.add('cto_fs: ' || 'UnExpected error in cto_schedule_fs.', 1);
104: END IF;
105: raise FND_API.G_EXC_UNEXPECTED_ERROR;
106: end if;
107:

Line 122: oe_debug_pub.add ('cto_fs: ' || 'before calling create sub-assembly jobs',1);

118: --ml supply code
119:
120: IF (l_mlsupply_parameter in (2,3)) THEN --auto created config =2, auto created configs + ato items = 3
121:
122: oe_debug_pub.add ('cto_fs: ' || 'before calling create sub-assembly jobs',1);
123:
124: l_stmt_num := 111;
125: CTO_SUBASSEMBLY_SUP_PK.create_subassembly_jobs(
126: l_mlsupply_parameter,

Line 145: oe_debug_pub.add ('cto_fs: ' || 'failed after CTO_SUBASSEMBLY_SUP_PK.create_subassembly_jobs ' || l_return_status ,1);

141:
142:
143: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
144: IF PG_DEBUG <> 0 THEN
145: oe_debug_pub.add ('cto_fs: ' || 'failed after CTO_SUBASSEMBLY_SUP_PK.create_subassembly_jobs ' || l_return_status ,1);
146: oe_debug_pub.add ('cto_fs: ' || 'error message' || l_error_message ,1);
147: END IF;
148: RAISE FND_API.G_EXC_ERROR;
149: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 146: oe_debug_pub.add ('cto_fs: ' || 'error message' || l_error_message ,1);

142:
143: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
144: IF PG_DEBUG <> 0 THEN
145: oe_debug_pub.add ('cto_fs: ' || 'failed after CTO_SUBASSEMBLY_SUP_PK.create_subassembly_jobs ' || l_return_status ,1);
146: oe_debug_pub.add ('cto_fs: ' || 'error message' || l_error_message ,1);
147: END IF;
148: RAISE FND_API.G_EXC_ERROR;
149: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
150: IF PG_DEBUG <> 0 THEN

Line 151: oe_debug_pub.add ('cto_fs: ' || ' failed after CTO_SUBASSEMBLY_SUP_PK.create_subassembly_jobs' || l_return_status ,1);

147: END IF;
148: RAISE FND_API.G_EXC_ERROR;
149: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
150: IF PG_DEBUG <> 0 THEN
151: oe_debug_pub.add ('cto_fs: ' || ' failed after CTO_SUBASSEMBLY_SUP_PK.create_subassembly_jobs' || l_return_status ,1);
152: oe_debug_pub.add ('cto_fs: ' || 'error message' || l_error_message ,1);
153: END IF;
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: ELSE

Line 152: oe_debug_pub.add ('cto_fs: ' || 'error message' || l_error_message ,1);

148: RAISE FND_API.G_EXC_ERROR;
149: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
150: IF PG_DEBUG <> 0 THEN
151: oe_debug_pub.add ('cto_fs: ' || ' failed after CTO_SUBASSEMBLY_SUP_PK.create_subassembly_jobs' || l_return_status ,1);
152: oe_debug_pub.add ('cto_fs: ' || 'error message' || l_error_message ,1);
153: END IF;
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: ELSE
156: IF PG_DEBUG <> 0 THEN

Line 157: oe_debug_pub.add('cto_fs: ' || 'success from CTO_SUBASSEMBLY_SUP_PK.create_subassembly_jobs' ,1);

153: END IF;
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: ELSE
156: IF PG_DEBUG <> 0 THEN
157: oe_debug_pub.add('cto_fs: ' || 'success from CTO_SUBASSEMBLY_SUP_PK.create_subassembly_jobs' ,1);
158: oe_debug_pub.add('cto_fs: ' || l_error_message ,1);
159:
160: END IF;
161: END IF;

Line 158: oe_debug_pub.add('cto_fs: ' || l_error_message ,1);

154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: ELSE
156: IF PG_DEBUG <> 0 THEN
157: oe_debug_pub.add('cto_fs: ' || 'success from CTO_SUBASSEMBLY_SUP_PK.create_subassembly_jobs' ,1);
158: oe_debug_pub.add('cto_fs: ' || l_error_message ,1);
159:
160: END IF;
161: END IF;
162:

Line 172: oe_debug_pub.add('cto_fs: ' || 'Success in cto_schedule_fs.', 1);

168:
169:
170:
171: IF PG_DEBUG <> 0 THEN
172: oe_debug_pub.add('cto_fs: ' || 'Success in cto_schedule_fs.', 1);
173:
174: oe_debug_pub.add('cto_fs: ' || 'Msg Data:' || l_x_msg_data, 1);
175: END IF;
176:

Line 174: oe_debug_pub.add('cto_fs: ' || 'Msg Data:' || l_x_msg_data, 1);

170:
171: IF PG_DEBUG <> 0 THEN
172: oe_debug_pub.add('cto_fs: ' || 'Success in cto_schedule_fs.', 1);
173:
174: oe_debug_pub.add('cto_fs: ' || 'Msg Data:' || l_x_msg_data, 1);
175: END IF;
176:
177: EXCEPTION
178:

Line 291: oe_debug_pub.add('cto_create_fs: ' || 'Header ID: ' ||

287:
288:
289:
290: IF PG_DEBUG <> 0 THEN
291: oe_debug_pub.add('cto_create_fs: ' || 'Header ID: ' ||
292: to_char(l_flow_schedule_rec.demand_source_header_id),2);
293:
294: oe_debug_pub.add('cto_create_fs: ' || 'Demand Source Line ID: ' ||
295: l_flow_schedule_rec.demand_source_line,1);

Line 294: oe_debug_pub.add('cto_create_fs: ' || 'Demand Source Line ID: ' ||

290: IF PG_DEBUG <> 0 THEN
291: oe_debug_pub.add('cto_create_fs: ' || 'Header ID: ' ||
292: to_char(l_flow_schedule_rec.demand_source_header_id),2);
293:
294: oe_debug_pub.add('cto_create_fs: ' || 'Demand Source Line ID: ' ||
295: l_flow_schedule_rec.demand_source_line,1);
296: END IF;
297: -- oe_debug_pub.add('Demand Source Delivery: ' ||
298: -- to_char(l_flow_schedule_rec.demand_source_delivery),1);

Line 297: -- oe_debug_pub.add('Demand Source Delivery: ' ||

293:
294: oe_debug_pub.add('cto_create_fs: ' || 'Demand Source Line ID: ' ||
295: l_flow_schedule_rec.demand_source_line,1);
296: END IF;
297: -- oe_debug_pub.add('Demand Source Delivery: ' ||
298: -- to_char(l_flow_schedule_rec.demand_source_delivery),1);
299: IF PG_DEBUG <> 0 THEN
300: oe_debug_pub.add('cto_create_fs: ' || 'Demand Source Type: ' ||
301: to_char(l_flow_schedule_rec.demand_source_type),2);

Line 300: oe_debug_pub.add('cto_create_fs: ' || 'Demand Source Type: ' ||

296: END IF;
297: -- oe_debug_pub.add('Demand Source Delivery: ' ||
298: -- to_char(l_flow_schedule_rec.demand_source_delivery),1);
299: IF PG_DEBUG <> 0 THEN
300: oe_debug_pub.add('cto_create_fs: ' || 'Demand Source Type: ' ||
301: to_char(l_flow_schedule_rec.demand_source_type),2);
302:
303: oe_debug_pub.add('cto_create_fs: ' || 'Line ID: ' ||
304: to_char(l_flow_schedule_rec.line_id),2);

Line 303: oe_debug_pub.add('cto_create_fs: ' || 'Line ID: ' ||

299: IF PG_DEBUG <> 0 THEN
300: oe_debug_pub.add('cto_create_fs: ' || 'Demand Source Type: ' ||
301: to_char(l_flow_schedule_rec.demand_source_type),2);
302:
303: oe_debug_pub.add('cto_create_fs: ' || 'Line ID: ' ||
304: to_char(l_flow_schedule_rec.line_id),2);
305:
306: oe_debug_pub.add('cto_create_fs: ' || 'Organization ID: ' ||
307: to_char(l_flow_schedule_rec.organization_id),2);

Line 306: oe_debug_pub.add('cto_create_fs: ' || 'Organization ID: ' ||

302:
303: oe_debug_pub.add('cto_create_fs: ' || 'Line ID: ' ||
304: to_char(l_flow_schedule_rec.line_id),2);
305:
306: oe_debug_pub.add('cto_create_fs: ' || 'Organization ID: ' ||
307: to_char(l_flow_schedule_rec.organization_id),2);
308:
309: oe_debug_pub.add('cto_create_fs: ' || 'Planed Quantity: ' ||
310: to_char(l_flow_schedule_rec.planned_quantity),2);

Line 309: oe_debug_pub.add('cto_create_fs: ' || 'Planed Quantity: ' ||

305:
306: oe_debug_pub.add('cto_create_fs: ' || 'Organization ID: ' ||
307: to_char(l_flow_schedule_rec.organization_id),2);
308:
309: oe_debug_pub.add('cto_create_fs: ' || 'Planed Quantity: ' ||
310: to_char(l_flow_schedule_rec.planned_quantity),2);
311:
312: oe_debug_pub.add('cto_create_fs: ' || 'Primary Item ID: ' ||
313: to_char(l_flow_schedule_rec.primary_item_id),2);

Line 312: oe_debug_pub.add('cto_create_fs: ' || 'Primary Item ID: ' ||

308:
309: oe_debug_pub.add('cto_create_fs: ' || 'Planed Quantity: ' ||
310: to_char(l_flow_schedule_rec.planned_quantity),2);
311:
312: oe_debug_pub.add('cto_create_fs: ' || 'Primary Item ID: ' ||
313: to_char(l_flow_schedule_rec.primary_item_id),2);
314:
315: oe_debug_pub.add('cto_create_fs: ' || 'Project ID: ' ||
316: to_char(l_flow_schedule_rec.project_id),2);

Line 315: oe_debug_pub.add('cto_create_fs: ' || 'Project ID: ' ||

311:
312: oe_debug_pub.add('cto_create_fs: ' || 'Primary Item ID: ' ||
313: to_char(l_flow_schedule_rec.primary_item_id),2);
314:
315: oe_debug_pub.add('cto_create_fs: ' || 'Project ID: ' ||
316: to_char(l_flow_schedule_rec.project_id),2);
317:
318: oe_debug_pub.add('cto_create_fs: ' || 'Schedule Completion Date: ' ||
319: to_char(l_flow_schedule_rec.scheduled_completion_date),2);

Line 318: oe_debug_pub.add('cto_create_fs: ' || 'Schedule Completion Date: ' ||

314:
315: oe_debug_pub.add('cto_create_fs: ' || 'Project ID: ' ||
316: to_char(l_flow_schedule_rec.project_id),2);
317:
318: oe_debug_pub.add('cto_create_fs: ' || 'Schedule Completion Date: ' ||
319: to_char(l_flow_schedule_rec.scheduled_completion_date),2);
320:
321: oe_debug_pub.add('cto_create_fs: ' || 'Task ID: ' ||
322: to_char(l_flow_schedule_rec.task_id),2);

Line 321: oe_debug_pub.add('cto_create_fs: ' || 'Task ID: ' ||

317:
318: oe_debug_pub.add('cto_create_fs: ' || 'Schedule Completion Date: ' ||
319: to_char(l_flow_schedule_rec.scheduled_completion_date),2);
320:
321: oe_debug_pub.add('cto_create_fs: ' || 'Task ID: ' ||
322: to_char(l_flow_schedule_rec.task_id),2);
323: END IF;
324:
325: /** the following sql%rowcount does not make sense

Line 359: oe_debug_pub.add('cto_create_fs: ' || 'Expected error in Process Flow Schedule with status: ' || l_return_status, 1);

355:
356:
357: if (x_return_status = FND_API.G_RET_STS_ERROR) then
358: IF PG_DEBUG <> 0 THEN
359: oe_debug_pub.add('cto_create_fs: ' || 'Expected error in Process Flow Schedule with status: ' || l_return_status, 1);
360: END IF;
361: raise FND_API.G_EXC_ERROR;
362:
363: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

Line 365: oe_debug_pub.add('cto_create_fs: ' || 'UnExpected error in Process Flow Schedule with status: ' || l_return_status, 1);

361: raise FND_API.G_EXC_ERROR;
362:
363: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
364: IF PG_DEBUG <> 0 THEN
365: oe_debug_pub.add('cto_create_fs: ' || 'UnExpected error in Process Flow Schedule with status: ' || l_return_status, 1);
366: END IF;
367: raise FND_API.G_EXC_UNEXPECTED_ERROR;
368:
369: else

Line 371: oe_debug_pub.add('cto_create_fs: ' || 'Success in Process Flow Schedule.',1);

367: raise FND_API.G_EXC_UNEXPECTED_ERROR;
368:
369: else
370: IF PG_DEBUG <> 0 THEN
371: oe_debug_pub.add('cto_create_fs: ' || 'Success in Process Flow Schedule.',1);
372: END IF;
373: if (l_x_flow_schedule_rec.wip_entity_id is not NULL) then
374: x_wip_entity_id := l_x_flow_schedule_rec.wip_entity_id;
375: IF PG_DEBUG <> 0 THEN

Line 376: oe_debug_pub.add('cto_create_fs: ' || 'WIP Entity ID: ' || to_char(x_wip_entity_id),2);

372: END IF;
373: if (l_x_flow_schedule_rec.wip_entity_id is not NULL) then
374: x_wip_entity_id := l_x_flow_schedule_rec.wip_entity_id;
375: IF PG_DEBUG <> 0 THEN
376: oe_debug_pub.add('cto_create_fs: ' || 'WIP Entity ID: ' || to_char(x_wip_entity_id),2);
377: END IF;
378: end if;
379:
380: end if; /* Create Flow Schedule Success */

Line 391: oe_debug_pub.add('cto_create_fs: ' || x_msg_data,1);

387: x_msg_name := 'CTO_CREATE_FLOW_SCHED_ERROR';
388: x_return_status := FND_API.G_RET_STS_ERROR;
389: cto_msg_pub.cto_message('BOM', x_msg_name);
390: IF PG_DEBUG <> 0 THEN
391: oe_debug_pub.add('cto_create_fs: ' || x_msg_data,1);
392: END IF;
393: CTO_MSG_PUB.Count_And_Get
394: (p_msg_count => x_msg_count
395: ,p_msg_data => x_msg_data

Line 407: oe_debug_pub.add('cto_create_fs: ' || x_msg_data, 1);

403: x_msg_name := 'CTO_CREATE_FLOW_SCHED_ERROR';
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405: cto_msg_pub.cto_message('BOM', x_msg_name);
406: IF PG_DEBUG <> 0 THEN
407: oe_debug_pub.add('cto_create_fs: ' || x_msg_data, 1);
408: END IF;
409: CTO_MSG_PUB.Count_And_Get
410: (p_msg_count => x_msg_count
411: ,p_msg_data => x_msg_data

Line 421: oe_debug_pub.add('cto_create_fs: ' || x_msg_data,1);

417: x_msg_name := 'CTO_CREATE_FLOW_SCHED_ERROR';
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
419: cto_msg_pub.cto_message('BOM', x_msg_name);
420: IF PG_DEBUG <> 0 THEN
421: oe_debug_pub.add('cto_create_fs: ' || x_msg_data,1);
422: END IF;
423: CTO_MSG_PUB.Count_And_Get
424: (p_msg_count => x_msg_count
425: ,p_msg_data => x_msg_data

Line 438: oe_debug_pub.add('cto_create_fs: ' || x_msg_data,1);

434: x_msg_name := 'CTO_CREATE_FLOW_SCHED_ERROR';
435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
436: cto_msg_pub.cto_message('BOM', x_msg_name);
437: IF PG_DEBUG <> 0 THEN
438: oe_debug_pub.add('cto_create_fs: ' || x_msg_data,1);
439: END IF;
440: CTO_MSG_PUB.Count_And_Get
441: (p_msg_count => x_msg_count
442: ,p_msg_data => x_msg_data

Line 503: oe_debug_pub.add ('cto_schedule_fs: ' || 'Error: Default Rule does not exist. Cannot schedule a flow schedule.',1);

499: exception
500: when no_data_found then
501: -- No Default Rule so cannot schedule a flow schedule
502: IF PG_DEBUG <> 0 THEN
503: oe_debug_pub.add ('cto_schedule_fs: ' || 'Error: Default Rule does not exist. Cannot schedule a flow schedule.',1);
504: END IF;
505: raise FND_API.G_EXC_ERROR;
506:
507: end;

Line 510: oe_debug_pub.add('cto_schedule_fs: ' || 'Rule ID: ' || to_char(l_rule_id),1);

506:
507: end;
508:
509: IF PG_DEBUG <> 0 THEN
510: oe_debug_pub.add('cto_schedule_fs: ' || 'Rule ID: ' || to_char(l_rule_id),1);
511:
512: oe_debug_pub.add('cto_schedule_fs: ' || 'Line ID: ' || to_char(l_line_id),1);
513:
514: oe_debug_pub.add('cto_schedule_fs: ' || 'Order Line ID: ' || p_config_line_id,2);

Line 512: oe_debug_pub.add('cto_schedule_fs: ' || 'Line ID: ' || to_char(l_line_id),1);

508:
509: IF PG_DEBUG <> 0 THEN
510: oe_debug_pub.add('cto_schedule_fs: ' || 'Rule ID: ' || to_char(l_rule_id),1);
511:
512: oe_debug_pub.add('cto_schedule_fs: ' || 'Line ID: ' || to_char(l_line_id),1);
513:
514: oe_debug_pub.add('cto_schedule_fs: ' || 'Order Line ID: ' || p_config_line_id,2);
515:
516: oe_debug_pub.add('cto_schedule_fs: ' || 'WIP Entity ID: ' || to_char(p_wip_entity_id),2);

Line 514: oe_debug_pub.add('cto_schedule_fs: ' || 'Order Line ID: ' || p_config_line_id,2);

510: oe_debug_pub.add('cto_schedule_fs: ' || 'Rule ID: ' || to_char(l_rule_id),1);
511:
512: oe_debug_pub.add('cto_schedule_fs: ' || 'Line ID: ' || to_char(l_line_id),1);
513:
514: oe_debug_pub.add('cto_schedule_fs: ' || 'Order Line ID: ' || p_config_line_id,2);
515:
516: oe_debug_pub.add('cto_schedule_fs: ' || 'WIP Entity ID: ' || to_char(p_wip_entity_id),2);
517: END IF;
518:

Line 516: oe_debug_pub.add('cto_schedule_fs: ' || 'WIP Entity ID: ' || to_char(p_wip_entity_id),2);

512: oe_debug_pub.add('cto_schedule_fs: ' || 'Line ID: ' || to_char(l_line_id),1);
513:
514: oe_debug_pub.add('cto_schedule_fs: ' || 'Order Line ID: ' || p_config_line_id,2);
515:
516: oe_debug_pub.add('cto_schedule_fs: ' || 'WIP Entity ID: ' || to_char(p_wip_entity_id),2);
517: END IF;
518:
519: l_stmt_num := 115;
520: l_completion_date := MRP_FLOW_SCHEDULE_PUB.get_first_unit_completion_date(

Line 533: oe_debug_pub.add('cto_schedule_fs: ' || 'Expected error in Get Completion Date with status ' || l_x_return_status,1);

529: p_start_date => sysdate);
530:
531: if (x_return_status = FND_API.G_RET_STS_ERROR) then
532: IF PG_DEBUG <> 0 THEN
533: oe_debug_pub.add('cto_schedule_fs: ' || 'Expected error in Get Completion Date with status ' || l_x_return_status,1);
534: END IF;
535: raise FND_API.G_EXC_ERROR;
536:
537: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

Line 539: oe_debug_pub.add('cto_schedule_fs: ' || 'UnExpected error in Get Completion Date with status ' || l_x_return_status,1);

535: raise FND_API.G_EXC_ERROR;
536:
537: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
538: IF PG_DEBUG <> 0 THEN
539: oe_debug_pub.add('cto_schedule_fs: ' || 'UnExpected error in Get Completion Date with status ' || l_x_return_status,1);
540: END IF;
541: raise FND_API.G_EXC_UNEXPECTED_ERROR;
542:
543: end if;

Line 547: oe_debug_pub.add('cto_schedule_fs: ' || 'Success in getting completion date: Completion Date is '

543: end if;
544:
545:
546: IF PG_DEBUG <> 0 THEN
547: oe_debug_pub.add('cto_schedule_fs: ' || 'Success in getting completion date: Completion Date is '
548: || to_char(l_completion_date), 1);
549: END IF;
550:
551: if (trunc(l_completion_date) > trunc(l_ship_date)) then

Line 554: oe_debug_pub.add('cto_schedule_fs: ' || 'Completion date is greater than ship date.',1);

550:
551: if (trunc(l_completion_date) > trunc(l_ship_date)) then
552:
553: IF PG_DEBUG <> 0 THEN
554: oe_debug_pub.add('cto_schedule_fs: ' || 'Completion date is greater than ship date.',1);
555:
556: oe_debug_pub.add('cto_schedule_fs: ' || 'Completion date is: ' || to_char(l_completion_date), 1);
557:
558: oe_debug_pub.add('cto_schedule_fs: ' || 'Ship Date is: ' || to_char(l_ship_date),1);

Line 556: oe_debug_pub.add('cto_schedule_fs: ' || 'Completion date is: ' || to_char(l_completion_date), 1);

552:
553: IF PG_DEBUG <> 0 THEN
554: oe_debug_pub.add('cto_schedule_fs: ' || 'Completion date is greater than ship date.',1);
555:
556: oe_debug_pub.add('cto_schedule_fs: ' || 'Completion date is: ' || to_char(l_completion_date), 1);
557:
558: oe_debug_pub.add('cto_schedule_fs: ' || 'Ship Date is: ' || to_char(l_ship_date),1);
559: END IF;
560:

Line 558: oe_debug_pub.add('cto_schedule_fs: ' || 'Ship Date is: ' || to_char(l_ship_date),1);

554: oe_debug_pub.add('cto_schedule_fs: ' || 'Completion date is greater than ship date.',1);
555:
556: oe_debug_pub.add('cto_schedule_fs: ' || 'Completion date is: ' || to_char(l_completion_date), 1);
557:
558: oe_debug_pub.add('cto_schedule_fs: ' || 'Ship Date is: ' || to_char(l_ship_date),1);
559: END IF;
560:
561: x_msg_name := 'CTO_LATE_COMPLETION_DATE';
562: raise FND_API.G_EXC_ERROR;

Line 582: oe_debug_pub.add('cto_schedule_fs: ' || 'Expected error in MRP_FLOW_SCHEDULE_PUB.Line Schedule with status ' || l_x_return_status,1);

578: p_update => 1.0);
579:
580: if (x_return_status = FND_API.G_RET_STS_ERROR) then
581: IF PG_DEBUG <> 0 THEN
582: oe_debug_pub.add('cto_schedule_fs: ' || 'Expected error in MRP_FLOW_SCHEDULE_PUB.Line Schedule with status ' || l_x_return_status,1);
583: END IF;
584: raise FND_API.G_EXC_ERROR;
585:
586: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

Line 588: oe_debug_pub.add('cto_schedule_fs: ' || 'UnExpected error in MRP_FLOW_SCHEDULE_PUB.Line Schedule with status ' || l_x_return_status,1);

584: raise FND_API.G_EXC_ERROR;
585:
586: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
587: IF PG_DEBUG <> 0 THEN
588: oe_debug_pub.add('cto_schedule_fs: ' || 'UnExpected error in MRP_FLOW_SCHEDULE_PUB.Line Schedule with status ' || l_x_return_status,1);
589: END IF;
590: raise FND_API.G_EXC_UNEXPECTED_ERROR;
591:
592: else

Line 594: oe_debug_pub.add('cto_schedule_fs: ' || 'Success in MRP_FLOW_SCHEDULE_PUB.Line_Schedule.', 1);

590: raise FND_API.G_EXC_UNEXPECTED_ERROR;
591:
592: else
593: IF PG_DEBUG <> 0 THEN
594: oe_debug_pub.add('cto_schedule_fs: ' || 'Success in MRP_FLOW_SCHEDULE_PUB.Line_Schedule.', 1);
595: END IF;
596: end if;
597:
598: EXCEPTION

Line 609: oe_debug_pub.add('cto_schedule_fs: ' || x_msg_data, 1);

605: end if;
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: cto_msg_pub.cto_message('BOM', x_msg_name);
608: IF PG_DEBUG <> 0 THEN
609: oe_debug_pub.add('cto_schedule_fs: ' || x_msg_data, 1);
610: END IF;
611: CTO_MSG_PUB.Count_And_Get
612: (p_msg_count => x_msg_count
613: ,p_msg_data => x_msg_data

Line 626: oe_debug_pub.add('cto_schedule_fs: ' || x_msg_data, 1);

622: end if;
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: cto_msg_pub.cto_message('BOM', x_msg_name);
625: IF PG_DEBUG <> 0 THEN
626: oe_debug_pub.add('cto_schedule_fs: ' || x_msg_data, 1);
627: END IF;
628: CTO_MSG_PUB.Count_And_Get
629: (p_msg_count => x_msg_count
630: ,p_msg_data => x_msg_data

Line 641: oe_debug_pub.add('cto_schedule_fs: ' || x_msg_data,1);

637: if x_msg_name is null then
638: x_msg_name := 'CTO_CREATE_FLOW_SCHED_ERROR';
639: end if;
640: IF PG_DEBUG <> 0 THEN
641: oe_debug_pub.add('cto_schedule_fs: ' || x_msg_data,1);
642: END IF;
643: cto_msg_pub.cto_message('BOM', x_msg_name);
644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
645: CTO_MSG_PUB.Count_And_Get