DBA Data[Home] [Help]

APPS.CTO_MSUTIL_PUB dependencies on CTO_MSG_PUB

Line 676: CTO_MSG_PUB.Count_And_Get

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

Line 687: CTO_MSG_PUB.Count_And_Get

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

Line 703: CTO_MSG_PUB.Count_And_Get

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

Line 1239: CTO_MSG_PUB.Count_And_Get

1235: IF PG_DEBUG <> 0 THEN
1236: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::unexp error::'||lStmtNumber||sqlerrm,1);
1237: END IF;
1238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1239: CTO_MSG_PUB.Count_And_Get
1240: (p_msg_count => x_msg_count
1241: ,p_msg_data => x_msg_data
1242: );
1243: return(0);

Line 1250: CTO_MSG_PUB.Count_And_Get

1246: IF PG_DEBUG <> 0 THEN
1247: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::exp error::'||lStmtNumber||sqlerrm,1);
1248: END IF;
1249: x_return_status := FND_API.G_RET_STS_ERROR;
1250: CTO_MSG_PUB.Count_And_Get
1251: (p_msg_count => x_msg_count
1252: ,p_msg_data => x_msg_data);
1253: return(0);
1254:

Line 1266: CTO_MSG_PUB.Count_And_Get

1262: (G_PKG_NAME
1263: ,'populate_src_orgs'
1264: );
1265: END IF;
1266: CTO_MSG_PUB.Count_And_Get
1267: (p_msg_count => x_msg_count
1268: ,p_msg_data => x_msg_data
1269: );
1270: return(0);

Line 1896: CTO_MSG_PUB.Count_And_Get

1892: IF PG_DEBUG <> 0 THEN
1893: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::exp error::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1894: END IF;
1895: x_return_status := FND_API.G_RET_STS_ERROR;
1896: CTO_MSG_PUB.Count_And_Get
1897: (p_msg_count => x_msg_count
1898: ,p_msg_data => x_msg_data
1899: );
1900: return(0);

Line 1907: CTO_MSG_PUB.Count_And_Get (

1903: IF PG_DEBUG <> 0 THEN
1904: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::unexp error::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1905: END IF;
1906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1907: CTO_MSG_PUB.Count_And_Get (
1908: p_msg_count => x_msg_count
1909: ,p_msg_data => x_msg_data
1910: );
1911: return(0);

Line 1924: CTO_MSG_PUB.Count_And_Get

1920: (G_PKG_NAME
1921: ,'Get_All_Item_Orgs'
1922: );
1923: END IF;
1924: CTO_MSG_PUB.Count_And_Get
1925: (p_msg_count => x_msg_count
1926: ,p_msg_data => x_msg_data
1927: );
1928: return(0);

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

2209: || px_concat_org_id || '::' || to_char(l_curr_src_org) , 1) ;
2210:
2211: END IF;
2212:
2213: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
2214: raise FND_API.G_EXC_ERROR;
2215:
2216:
2217:

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

2487: -- to OE, in both cases we need to set the message again
2488: -- This is because if we not set the token once again the
2489: -- second add will not get the message.
2490:
2491: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
2492: raise FND_API.G_EXC_ERROR;
2493:
2494: END;
2495:

Line 2613: cto_msg_pub.count_and_get

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

Line 2624: cto_msg_pub.count_and_get

2620: || to_char(lStmtNum), 1);
2621: END IF;
2622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2623: -- Get message count and data
2624: cto_msg_pub.count_and_get
2625: ( p_msg_count => x_msg_count
2626: , p_msg_data => x_msg_data
2627: );
2628: WHEN OTHERS then

Line 2637: cto_msg_pub.count_and_get

2633: oe_debug_pub.add('process_sourcing_chain: ' || 'errormsg='||sqlerrm, 1);
2634: END IF;
2635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2636: -- Get message count and data
2637: cto_msg_pub.count_and_get
2638: ( p_msg_count => x_msg_count
2639: , p_msg_data => x_msg_data
2640: );
2641:

Line 3316: CTO_MSG_PUB.Count_And_Get

3312: IF PG_DEBUG <> 0 THEN
3313: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3314: END IF;
3315: x_return_status := FND_API.G_RET_STS_ERROR;
3316: CTO_MSG_PUB.Count_And_Get
3317: (p_msg_count => x_msg_count
3318: ,p_msg_data => x_msg_data
3319: );
3320:

Line 3326: CTO_MSG_PUB.Count_And_Get

3322: IF PG_DEBUG <> 0 THEN
3323: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3324: END IF;
3325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3326: CTO_MSG_PUB.Count_And_Get
3327: (p_msg_count => x_msg_count
3328: ,p_msg_data => x_msg_data
3329: );
3330:

Line 3342: CTO_MSG_PUB.Count_And_Get

3338: (G_PKG_NAME
3339: ,'Create_Sourcing_Rules'
3340: );
3341: END IF;
3342: CTO_MSG_PUB.Count_And_Get
3343: (p_msg_count => x_msg_count
3344: ,p_msg_data => x_msg_data
3345: );
3346:

Line 3879: CTO_MSG_PUB.Count_And_Get

3875: IF PG_DEBUG <> 0 THEN
3876: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3877: END IF;
3878: x_return_status := FND_API.G_RET_STS_ERROR;
3879: CTO_MSG_PUB.Count_And_Get
3880: (p_msg_count => x_msg_count
3881: ,p_msg_data => x_msg_data
3882: );
3883:

Line 3889: CTO_MSG_PUB.Count_And_Get

3885: IF PG_DEBUG <> 0 THEN
3886: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3887: END IF;
3888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3889: CTO_MSG_PUB.Count_And_Get
3890: (p_msg_count => x_msg_count
3891: ,p_msg_data => x_msg_data
3892: );
3893:

Line 3905: CTO_MSG_PUB.Count_And_Get

3901: (G_PKG_NAME
3902: ,'Create_Sourcing_Rules'
3903: );
3904: END IF;
3905: CTO_MSG_PUB.Count_And_Get
3906: (p_msg_count => x_msg_count
3907: ,p_msg_data => x_msg_data
3908: );
3909:

Line 5027: CTO_MSG_PUB.Count_And_Get

5023: IF PG_DEBUG <> 0 THEN
5024: oe_debug_pub.add('get_other_orgs: ' || 'GET_OTHER_ORGS::unexp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5025: END IF;
5026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5027: CTO_MSG_PUB.Count_And_Get
5028: (p_msg_count => x_msg_count
5029: ,p_msg_data => x_msg_data
5030: );
5031:

Line 5037: CTO_MSG_PUB.Count_And_Get

5033: IF PG_DEBUG <> 0 THEN
5034: oe_debug_pub.add('get_other_orgs: ' || 'GET_OTHER_ORGS::exp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5035: END IF;
5036: x_return_status := FND_API.G_RET_STS_ERROR;
5037: CTO_MSG_PUB.Count_And_Get
5038: (p_msg_count => x_msg_count
5039: ,p_msg_data => x_msg_data);
5040:
5041:

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

5047: /* commented raise as the calling api will handle the error using x_return_status RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
5048:
5049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5050:
5051: CTO_MSG_PUB.Count_And_Get(p_msg_count => x_msg_count ,p_msg_data => x_msg_data);
5052:
5053:
5054: END get_other_orgs;
5055:

Line 5271: CTO_MSG_PUB.Count_And_Get

5267: IF PG_DEBUG <> 0 THEN
5268: oe_debug_pub.add('Get_Master_orgs: ' || 'GET_OTHER_ORGS::unexp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5269: END IF;
5270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5271: CTO_MSG_PUB.Count_And_Get
5272: (p_msg_count => x_msg_count
5273: ,p_msg_data => x_msg_data
5274: );
5275:

Line 5281: CTO_MSG_PUB.Count_And_Get

5277: IF PG_DEBUG <> 0 THEN
5278: oe_debug_pub.add('Get_Master_orgs: ' || 'GET_OTHER_ORGS::exp error::'|| to_char(lstmt_num) ||sqlerrm,1);
5279: END IF;
5280: x_return_status := FND_API.G_RET_STS_ERROR;
5281: CTO_MSG_PUB.Count_And_Get
5282: (p_msg_count => x_msg_count
5283: ,p_msg_data => x_msg_data);
5284:
5285:

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

5291: /* commented raise as the calling api will handle the error using x_return_status RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
5292:
5293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5294:
5295: CTO_MSG_PUB.Count_And_Get(p_msg_count => x_msg_count ,p_msg_data => x_msg_data);
5296:
5297: End Get_Master_orgs;
5298:
5299: