DBA Data[Home] [Help]

APPS.CTO_MSUTIL_PUB dependencies on CTO_MSG_PUB

Line 679: CTO_MSG_PUB.Count_And_Get

675: IF PG_DEBUG <> 0 THEN
676: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::unexp error::'||lStmtNumber||sqlerrm,1);
677: END IF;
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
679: CTO_MSG_PUB.Count_And_Get
680: (p_msg_count => x_msg_count
681: ,p_msg_data => x_msg_data
682: );
683: return(0);

Line 690: CTO_MSG_PUB.Count_And_Get

686: IF PG_DEBUG <> 0 THEN
687: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::exp error::'||lStmtNumber||sqlerrm,1);
688: END IF;
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: CTO_MSG_PUB.Count_And_Get
691: (p_msg_count => x_msg_count
692: ,p_msg_data => x_msg_data);
693: return(0);
694:

Line 706: CTO_MSG_PUB.Count_And_Get

702: (G_PKG_NAME
703: ,'populate_src_orgs'
704: );
705: END IF;
706: CTO_MSG_PUB.Count_And_Get
707: (p_msg_count => x_msg_count
708: ,p_msg_data => x_msg_data
709: );
710: return(0);

Line 1244: CTO_MSG_PUB.Count_And_Get

1240: IF PG_DEBUG <> 0 THEN
1241: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::unexp error::'||lStmtNumber||sqlerrm,1);
1242: END IF;
1243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1244: CTO_MSG_PUB.Count_And_Get
1245: (p_msg_count => x_msg_count
1246: ,p_msg_data => x_msg_data
1247: );
1248: return(0);

Line 1255: CTO_MSG_PUB.Count_And_Get

1251: IF PG_DEBUG <> 0 THEN
1252: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::exp error::'||lStmtNumber||sqlerrm,1);
1253: END IF;
1254: x_return_status := FND_API.G_RET_STS_ERROR;
1255: CTO_MSG_PUB.Count_And_Get
1256: (p_msg_count => x_msg_count
1257: ,p_msg_data => x_msg_data);
1258: return(0);
1259:

Line 1271: CTO_MSG_PUB.Count_And_Get

1267: (G_PKG_NAME
1268: ,'populate_src_orgs'
1269: );
1270: END IF;
1271: CTO_MSG_PUB.Count_And_Get
1272: (p_msg_count => x_msg_count
1273: ,p_msg_data => x_msg_data
1274: );
1275: return(0);

Line 1846: CTO_MSG_PUB.Count_And_Get

1842: IF PG_DEBUG <> 0 THEN
1843: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::exp error::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1844: END IF;
1845: x_return_status := FND_API.G_RET_STS_ERROR;
1846: CTO_MSG_PUB.Count_And_Get
1847: (p_msg_count => x_msg_count
1848: ,p_msg_data => x_msg_data
1849: );
1850: return(0);

Line 1857: CTO_MSG_PUB.Count_And_Get (

1853: IF PG_DEBUG <> 0 THEN
1854: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::unexp error::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1855: END IF;
1856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1857: CTO_MSG_PUB.Count_And_Get (
1858: p_msg_count => x_msg_count
1859: ,p_msg_data => x_msg_data
1860: );
1861: return(0);

Line 1874: CTO_MSG_PUB.Count_And_Get

1870: (G_PKG_NAME
1871: ,'Get_All_Item_Orgs'
1872: );
1873: END IF;
1874: CTO_MSG_PUB.Count_And_Get
1875: (p_msg_count => x_msg_count
1876: ,p_msg_data => x_msg_data
1877: );
1878: return(0);

Line 2200: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');

2196: || px_concat_org_id || '::' || to_char(l_curr_src_org) , 1) ;
2197:
2198: END IF;
2199:
2200: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
2201: raise FND_API.G_EXC_ERROR;
2202:
2203:
2204:

Line 2478: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');

2474: -- to OE, in both cases we need to set the message again
2475: -- This is because if we not set the token once again the
2476: -- second add will not get the message.
2477:
2478: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
2479: raise FND_API.G_EXC_ERROR;
2480:
2481: END;
2482:

Line 2603: cto_msg_pub.count_and_get

2599: || to_char(lStmtNum), 1);
2600: END IF;
2601: x_return_status := FND_API.G_RET_STS_ERROR;
2602: -- Get message count and data
2603: cto_msg_pub.count_and_get
2604: ( p_msg_count => x_msg_count
2605: , p_msg_data => x_msg_data
2606: );
2607: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2614: cto_msg_pub.count_and_get

2610: || to_char(lStmtNum), 1);
2611: END IF;
2612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2613: -- Get message count and data
2614: cto_msg_pub.count_and_get
2615: ( p_msg_count => x_msg_count
2616: , p_msg_data => x_msg_data
2617: );
2618: WHEN OTHERS then

Line 2627: cto_msg_pub.count_and_get

2623: oe_debug_pub.add('process_sourcing_chain: ' || 'errormsg='||sqlerrm, 1);
2624: END IF;
2625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2626: -- Get message count and data
2627: cto_msg_pub.count_and_get
2628: ( p_msg_count => x_msg_count
2629: , p_msg_data => x_msg_data
2630: );
2631:

Line 3512: CTO_MSG_PUB.Count_And_Get

3508: IF PG_DEBUG <> 0 THEN
3509: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3510: END IF;
3511: x_return_status := FND_API.G_RET_STS_ERROR;
3512: CTO_MSG_PUB.Count_And_Get
3513: (p_msg_count => x_msg_count
3514: ,p_msg_data => x_msg_data
3515: );
3516:

Line 3522: CTO_MSG_PUB.Count_And_Get

3518: IF PG_DEBUG <> 0 THEN
3519: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3520: END IF;
3521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3522: CTO_MSG_PUB.Count_And_Get
3523: (p_msg_count => x_msg_count
3524: ,p_msg_data => x_msg_data
3525: );
3526:

Line 3538: CTO_MSG_PUB.Count_And_Get

3534: (G_PKG_NAME
3535: ,'Create_Sourcing_Rules'
3536: );
3537: END IF;
3538: CTO_MSG_PUB.Count_And_Get
3539: (p_msg_count => x_msg_count
3540: ,p_msg_data => x_msg_data
3541: );
3542:

Line 4396: CTO_MSG_PUB.Count_And_Get

4392: IF PG_DEBUG <> 0 THEN
4393: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
4394: END IF;
4395: x_return_status := FND_API.G_RET_STS_ERROR;
4396: CTO_MSG_PUB.Count_And_Get
4397: (p_msg_count => x_msg_count
4398: ,p_msg_data => x_msg_data
4399: );
4400:

Line 4406: CTO_MSG_PUB.Count_And_Get

4402: IF PG_DEBUG <> 0 THEN
4403: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
4404: END IF;
4405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4406: CTO_MSG_PUB.Count_And_Get
4407: (p_msg_count => x_msg_count
4408: ,p_msg_data => x_msg_data
4409: );
4410:

Line 4422: CTO_MSG_PUB.Count_And_Get

4418: (G_PKG_NAME
4419: ,'Create_Sourcing_Rules'
4420: );
4421: END IF;
4422: CTO_MSG_PUB.Count_And_Get
4423: (p_msg_count => x_msg_count
4424: ,p_msg_data => x_msg_data
4425: );
4426:

Line 5557: CTO_MSG_PUB.Count_And_Get

5553: IF PG_DEBUG <> 0 THEN
5554: oe_debug_pub.add('get_other_orgs: ' || 'GET_OTHER_ORGS::unexp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5555: END IF;
5556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5557: CTO_MSG_PUB.Count_And_Get
5558: (p_msg_count => x_msg_count
5559: ,p_msg_data => x_msg_data
5560: );
5561:

Line 5567: CTO_MSG_PUB.Count_And_Get

5563: IF PG_DEBUG <> 0 THEN
5564: oe_debug_pub.add('get_other_orgs: ' || 'GET_OTHER_ORGS::exp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5565: END IF;
5566: x_return_status := FND_API.G_RET_STS_ERROR;
5567: CTO_MSG_PUB.Count_And_Get
5568: (p_msg_count => x_msg_count
5569: ,p_msg_data => x_msg_data);
5570:
5571:

Line 5581: CTO_MSG_PUB.Count_And_Get(p_msg_count => x_msg_count ,p_msg_data => x_msg_data);

5577: /* commented raise as the calling api will handle the error using x_return_status RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
5578:
5579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5580:
5581: CTO_MSG_PUB.Count_And_Get(p_msg_count => x_msg_count ,p_msg_data => x_msg_data);
5582:
5583:
5584: END get_other_orgs;
5585:

Line 5801: CTO_MSG_PUB.Count_And_Get

5797: IF PG_DEBUG <> 0 THEN
5798: oe_debug_pub.add('Get_Master_orgs: ' || 'GET_OTHER_ORGS::unexp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5799: END IF;
5800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5801: CTO_MSG_PUB.Count_And_Get
5802: (p_msg_count => x_msg_count
5803: ,p_msg_data => x_msg_data
5804: );
5805:

Line 5811: CTO_MSG_PUB.Count_And_Get

5807: IF PG_DEBUG <> 0 THEN
5808: oe_debug_pub.add('Get_Master_orgs: ' || 'GET_OTHER_ORGS::exp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5809: END IF;
5810: x_return_status := FND_API.G_RET_STS_ERROR;
5811: CTO_MSG_PUB.Count_And_Get
5812: (p_msg_count => x_msg_count
5813: ,p_msg_data => x_msg_data);
5814:
5815:

Line 5825: CTO_MSG_PUB.Count_And_Get(p_msg_count => x_msg_count ,p_msg_data => x_msg_data);

5821: /* commented raise as the calling api will handle the error using x_return_status RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
5822:
5823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5824:
5825: CTO_MSG_PUB.Count_And_Get(p_msg_count => x_msg_count ,p_msg_data => x_msg_data);
5826:
5827: End Get_Master_orgs;
5828:
5829: