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;
393: CTO_MSG_PUB.Count_And_Get
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
396: );
397:
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;
409: CTO_MSG_PUB.Count_And_Get
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
412: );
413:
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;
423: CTO_MSG_PUB.Count_And_Get
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
426: );
427: raise;
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;
440: CTO_MSG_PUB.Count_And_Get
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
443: );
444: raise;
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;
611: CTO_MSG_PUB.Count_And_Get
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
614: );
615:
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;
628: CTO_MSG_PUB.Count_And_Get
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
631: );
632:
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
646: (p_msg_count => x_msg_count
647: ,p_msg_data => x_msg_data
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: );
649: