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 FND_API

Line 60: x_return_status := FND_API.G_RET_STS_SUCCESS;

56: CREATE_FLOW_SCHED_ERROR exception;
57: SCHEDULE_FLOW_SCHED_ERROR exception;
58:
59: BEGIN
60: x_return_status := FND_API.G_RET_STS_SUCCESS;
61: l_stmt_num := 100;
62: cto_create_fs(p_config_line_id,
63: l_x_wip_entity_id,
64: l_x_return_status,

Line 69: if (l_x_return_status = FND_API.G_RET_STS_ERROR) then

65: l_x_msg_count,
66: l_x_msg_data,
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;

Line 73: raise FND_API.G_EXC_ERROR;

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
76: IF PG_DEBUG <> 0 THEN
77: oe_debug_pub.add('cto_fs: ' || 'UnExpected error in cto_create_fs.', 1);

Line 75: elsif (l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) 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
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;

Line 79: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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;
82:
83: IF PG_DEBUG <> 0 THEN

Line 95: if (l_x_return_status = FND_API.G_RET_STS_ERROR) then

91: l_x_msg_count,
92: l_x_msg_data,
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;

Line 99: raise FND_API.G_EXC_ERROR;

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
102: IF PG_DEBUG <> 0 THEN
103: oe_debug_pub.add('cto_fs: ' || 'UnExpected error in cto_schedule_fs.', 1);

Line 101: elsif (l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) 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
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;

Line 105: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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:
108:
109: --looking for ML supply org parameter value

Line 143: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

139: l_message_name
140: );
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;

Line 148: RAISE FND_API.G_EXC_ERROR;

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
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);

Line 149: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR 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
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;

Line 154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
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);

Line 179: when FND_API.G_EXC_ERROR then

175: END IF;
176:
177: EXCEPTION
178:
179: when FND_API.G_EXC_ERROR then
180: x_msg_txt := 'CTOFLSCB.cto_fs: raised expected error in stmt:' || to_char(l_stmt_num) || ':' ||
181: l_x_msg_data;
182: if (x_msg_name is null) then
183: x_msg_name := 'CTO_CREATE_FLOW_SCHED_ERROR';

Line 185: x_return_status :=FND_API.G_RET_STS_ERROR;

181: l_x_msg_data;
182: if (x_msg_name is null) then
183: x_msg_name := 'CTO_CREATE_FLOW_SCHED_ERROR';
184: end if;
185: x_return_status :=FND_API.G_RET_STS_ERROR;
186:
187:
188: when FND_API.G_EXC_UNEXPECTED_ERROR then
189: x_msg_txt := 'CTOFLSCB.cto_fs: raised Unexpected error in stmt:' || to_char(l_stmt_num) || ':' ||

Line 188: when FND_API.G_EXC_UNEXPECTED_ERROR then

184: end if;
185: x_return_status :=FND_API.G_RET_STS_ERROR;
186:
187:
188: when FND_API.G_EXC_UNEXPECTED_ERROR then
189: x_msg_txt := 'CTOFLSCB.cto_fs: raised Unexpected error in stmt:' || to_char(l_stmt_num) || ':' ||
190: l_x_msg_data;
191: if (x_msg_name is null) then
192: x_msg_name := 'CTO_CREATE_FLOW_SCHED_ERROR';

Line 194: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;

190: l_x_msg_data;
191: if (x_msg_name is null) then
192: x_msg_name := 'CTO_CREATE_FLOW_SCHED_ERROR';
193: end if;
194: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
195: raise;
196:
197: when OTHERS then
198: x_msg_txt := 'CTOFLSCB.cto_fs: ' || to_char(l_stmt_num) || ':' ||

Line 203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

199: substrb(sqlerrm, 1, 100);
200: if (x_msg_name is null) then
201: x_msg_name := 'CTO_CREATE_FLOW_SCHED_ERROR';
202: end if;
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204: raise;
205:
206: END cto_fs;
207:

Line 235: x_return_status := FND_API.G_RET_STS_SUCCESS;

231: CREATE_FLOW_SCHED_ERROR exception;
232:
233: BEGIN
234:
235: x_return_status := FND_API.G_RET_STS_SUCCESS;
236:
237: l_stmt_num := 90;
238: select inventory_item_id, ship_from_org_id
239: into l_config_item_id, l_org_id

Line 330: -- raise FND_API.G_EXC_ERROR;

326: since the above select will raise no-data-found
327: if no rows are selected.
328:
329: -- if (SQL%ROWCOUNT <= 0) then
330: -- raise FND_API.G_EXC_ERROR;
331: -- end if;
332:
333: ***/
334:

Line 347: p_init_msg_list => FND_API.G_TRUE,

343:
344: l_stmt_num := 110;
345: MRP_Flow_Schedule_PUB.Process_Flow_Schedule(
346: p_api_version_number => 1.0,
347: p_init_msg_list => FND_API.G_TRUE,
348: x_return_status => l_return_status,
349: x_msg_count => l_msg_count,
350: x_msg_data => l_msg_data,
351: p_flow_schedule_rec => l_flow_schedule_rec,

Line 357: if (x_return_status = FND_API.G_RET_STS_ERROR) then

353: x_flow_schedule_val_rec => l_x_flow_schedule_val_rec
354: );
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;

Line 361: raise FND_API.G_EXC_ERROR;

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
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);

Line 363: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) 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
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;

Line 367: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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
370: IF PG_DEBUG <> 0 THEN
371: oe_debug_pub.add('cto_create_fs: ' || 'Success in Process Flow Schedule.',1);

Line 384: when FND_API.G_EXC_ERROR then

380: end if; /* Create Flow Schedule Success */
381:
382: EXCEPTION
383:
384: when FND_API.G_EXC_ERROR then
385:
386: x_msg_data := 'CTOFLSCB.cto_create_fs raised expected error: ' || to_char(l_stmt_num) || ':' || l_msg_data;
387: x_msg_name := 'CTO_CREATE_FLOW_SCHED_ERROR';
388: x_return_status := FND_API.G_RET_STS_ERROR;

Line 388: x_return_status := FND_API.G_RET_STS_ERROR;

384: when FND_API.G_EXC_ERROR then
385:
386: x_msg_data := 'CTOFLSCB.cto_create_fs raised expected error: ' || to_char(l_stmt_num) || ':' || l_msg_data;
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;

Line 400: when FND_API.G_EXC_UNEXPECTED_ERROR then

396: );
397:
398:
399:
400: when FND_API.G_EXC_UNEXPECTED_ERROR then
401:
402: x_msg_data := 'CTOFLSCB.cto_create_fs raised unexp error: ' || to_char(l_stmt_num) || ':' || l_msg_data;
403: x_msg_name := 'CTO_CREATE_FLOW_SCHED_ERROR';
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

400: when FND_API.G_EXC_UNEXPECTED_ERROR then
401:
402: x_msg_data := 'CTOFLSCB.cto_create_fs raised unexp error: ' || to_char(l_stmt_num) || ':' || l_msg_data;
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;

Line 418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

414:
415: when NO_DATA_FOUND then
416: x_msg_data := 'CTOFLSCB.cto_create_fs: raised no-data-found' || to_char(l_stmt_num);
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;

Line 435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

431: x_msg_data := 'CTOFLSCB.cto_create_fs: ' ||
432: to_char(l_stmt_num) || ':' ||
433: substrb(sqlerrm, 1, 100);
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;

Line 472: x_return_status := FND_API.G_RET_STS_SUCCESS;

468: --SCHEDULE_FLOW_SCHED_ERROR exception;
469:
470: BEGIN
471:
472: x_return_status := FND_API.G_RET_STS_SUCCESS;
473:
474: l_stmt_num := 100;
475: -- Verify SQL.
476: select wfs.line_id, wfs.organization_id, oel.schedule_ship_date,

Line 505: raise FND_API.G_EXC_ERROR;

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;
508:
509: IF PG_DEBUG <> 0 THEN

Line 531: if (x_return_status = FND_API.G_RET_STS_ERROR) then

527: p_qty => l_planned_qty,
528: p_line_id => l_line_id,
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;

Line 535: raise FND_API.G_EXC_ERROR;

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
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);

Line 537: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) 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
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;

Line 541: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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;
544:
545:

Line 562: raise FND_API.G_EXC_ERROR;

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;
563:
564: end if;
565:
566:

Line 580: if (x_return_status = FND_API.G_RET_STS_ERROR) then

576: p_sched_start_date => l_completion_date,
577: p_sched_end_date => l_ship_date,
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;

Line 584: raise FND_API.G_EXC_ERROR;

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
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);

Line 586: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) 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
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;

Line 590: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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
593: IF PG_DEBUG <> 0 THEN
594: oe_debug_pub.add('cto_schedule_fs: ' || 'Success in MRP_FLOW_SCHEDULE_PUB.Line_Schedule.', 1);

Line 600: WHEN FND_API.G_EXC_ERROR THEN

596: end if;
597:
598: EXCEPTION
599:
600: WHEN FND_API.G_EXC_ERROR THEN
601:
602: x_msg_data := 'CTOFLSCB.cto_schedule_fs raised exp error: ' || to_char(l_stmt_num) || ':' || l_x_msg_data;
603: if x_msg_name is null then
604: x_msg_name := 'CTO_CREATE_FLOW_SCHED_ERROR';

Line 606: x_return_status := FND_API.G_RET_STS_ERROR;

602: x_msg_data := 'CTOFLSCB.cto_schedule_fs raised exp error: ' || to_char(l_stmt_num) || ':' || l_x_msg_data;
603: if x_msg_name is null then
604: x_msg_name := 'CTO_CREATE_FLOW_SCHED_ERROR';
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;

Line 617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

613: ,p_msg_data => x_msg_data
614: );
615:
616:
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618:
619: x_msg_data := 'CTOFLSCB.cto_schedule_fs raised unexp error: ' || to_char(l_stmt_num) || ':' || l_x_msg_data;
620: if x_msg_name is null then
621: x_msg_name := 'CTO_CREATE_FLOW_SCHED_ERROR';

Line 623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

619: x_msg_data := 'CTOFLSCB.cto_schedule_fs raised unexp error: ' || to_char(l_stmt_num) || ':' || l_x_msg_data;
620: if x_msg_name is null then
621: x_msg_name := 'CTO_CREATE_FLOW_SCHED_ERROR';
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;

Line 644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
646: (p_msg_count => x_msg_count
647: ,p_msg_data => x_msg_data
648: );