DBA Data[Home] [Help]

APPS.CTO_CONFIG_ITEM_PK dependencies on CTO_MSG_PUB

Line 1786: CTO_MSG_PUB.Count_And_Get(

1782: when FND_API.G_EXC_ERROR then
1783:
1784: if( xMessageName is null ) then /* xMessageName can be not null in case of CTO_DELINK_SHIPPING_ERROR */
1785: /* Bugfix 2454788 */
1786: CTO_MSG_PUB.Count_And_Get(
1787: p_msg_count => lCount,
1788: p_msg_data => xErrorMessage
1789: );
1790: IF PG_DEBUG <> 0 THEN

Line 1833: CTO_MSG_PUB.Count_And_Get(

1829: return(0);
1830:
1831:
1832: when FND_API.G_EXC_UNEXPECTED_ERROR then
1833: CTO_MSG_PUB.Count_And_Get(
1834: p_msg_count => lCount,
1835: p_msg_data => xErrorMessage
1836: );
1837: IF PG_DEBUG <> 0 THEN

Line 1850: CTO_MSG_PUB.Count_And_Get(

1846: END IF;
1847: xMessageName := 'CTO_DELINK_ITEM_ERROR';
1848: xErrorMessage := 'ERROR: CTOCITMB.delink:'||to_char(lStmtNumber)||
1849: ':' || substrb(sqlerrm,1,150);
1850: CTO_MSG_PUB.Count_And_Get(
1851: p_msg_count => lCount,
1852: p_msg_data => xErrorMessage
1853: );
1854: return(0);

Line 4305: cto_msg_pub.cto_message('BOM','CTO_VALIDATION_ORG_NOT_SET');

4301: end if ;
4302:
4303:
4304: if lVAlidationOrg = -99 then -- bugfix 2646849
4305: cto_msg_pub.cto_message('BOM','CTO_VALIDATION_ORG_NOT_SET');
4306: raise FND_API.G_EXC_ERROR;
4307: end if;
4308:
4309: IF PG_DEBUG <> 0 THEN

Line 4345: cto_msg_pub.cto_message('BOM','CTO_CONFIG_SEGMENT_ERROR');

4341: where organization_id = lValidationOrg;
4342:
4343:
4344: if lConfigSegName is NULL then
4345: cto_msg_pub.cto_message('BOM','CTO_CONFIG_SEGMENT_ERROR');
4346: raise FND_API.G_EXC_ERROR;
4347: end if;
4348:
4349: IF PG_DEBUG <> 0 THEN

Line 5893: CTO_MSG_PUB.Count_And_Get(

5889: WHEN NO_DATA_FOUND THEN
5890: IF PG_DEBUG <> 0 THEN
5891: oe_debug_pub.add ('Create_Item: ' || 'ERROR: create_item::ndf::'||to_char(lStmtNumber)||sqlerrm,1);
5892: END IF;
5893: CTO_MSG_PUB.Count_And_Get(
5894: p_msg_count => xMsgCount,
5895: p_msg_data => xMsgData
5896: );
5897: return(0);

Line 5903: CTO_MSG_PUB.Count_And_Get(

5899: WHEN FND_API.G_EXC_ERROR THEN
5900: IF PG_DEBUG <> 0 THEN
5901: oe_debug_pub.add ('Create_Item: ' || 'ERROR: create_item::exp error::'||to_char(lStmtNumber)||sqlerrm,1);
5902: END IF;
5903: CTO_MSG_PUB.Count_And_Get(
5904: p_msg_count => xMsgCount,
5905: p_msg_data => xMsgData
5906: );
5907: return(0);

Line 5913: CTO_MSG_PUB.Count_And_Get(

5909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5910: IF PG_DEBUG <> 0 THEN
5911: oe_debug_pub.add ('Create_Item: ' || 'ERROR: create_item::unexp error::'||to_char(lStmtNumber)||sqlerrm,1);
5912: END IF;
5913: CTO_MSG_PUB.Count_And_Get(
5914: p_msg_count => xMsgCount,
5915: p_msg_data => xMsgData
5916: );
5917: return(0);

Line 5923: CTO_MSG_PUB.Count_And_Get(

5919: WHEN OTHERS THEN
5920: IF PG_DEBUG <> 0 THEN
5921: oe_debug_pub.add ('Create_Item: ' || 'ERROR: create_item::others::'||to_char(lStmtNumber)||sqlerrm,1);
5922: END IF;
5923: CTO_MSG_PUB.Count_And_Get(
5924: p_msg_count => xMsgCount,
5925: p_msg_data => xMsgData
5926: );
5927: return(0);

Line 6169: CTO_MSG_PUB.Count_And_Get(

6165: WHEN OTHERS THEN
6166: IF PG_DEBUG <> 0 THEN
6167: oe_debug_pub.add ('Create_Item: ' || 'ERROR: Ato_Weight_Volume::others::'||to_char(lStmtNumber)||':-'||sqlerrm,1);
6168: END IF;
6169: CTO_MSG_PUB.Count_And_Get(
6170: p_msg_count => lMsgCount,
6171: p_msg_data => lMsgData
6172: );
6173: status := -1;

Line 6359: cto_msg_pub.cto_message('BOM','CTO_VALIDATION_ORG_NOT_SET');

6355: oe_debug_pub.add('Create_Item: ' || 'After getting validation org',2);
6356: END IF;
6357:
6358: if lVAlidationOrg = -99 then -- bugfix 2646849
6359: cto_msg_pub.cto_message('BOM','CTO_VALIDATION_ORG_NOT_SET');
6360: RAISE FND_API.G_EXC_ERROR;
6361: end if;
6362:
6363:

Line 6839: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');

6835: when no_data_found then
6836: IF PG_DEBUG <> 0 THEN
6837: oe_debug_pub.add('Create_Item: ' || ' no_data_found error for cost type id = 7 ',2);
6838: END IF;
6839: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
6840: raise FND_API.G_EXC_ERROR;
6841: when others then
6842:
6843: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8327: CTO_MSG_PUB.Count_And_Get(

8323: WHEN NO_DATA_FOUND THEN
8324: IF PG_DEBUG <> 0 THEN
8325: oe_debug_pub.add ('Create_Item: ' || 'ERROR: create_item_data::ndf::'||to_char(lStmtNumber)||sqlerrm,1);
8326: END IF;
8327: CTO_MSG_PUB.Count_And_Get(
8328: p_msg_count => lMsgCount,
8329: p_msg_data => lMsgData
8330: );
8331: return(0);

Line 8337: CTO_MSG_PUB.Count_And_Get(

8333: WHEN FND_API.G_EXC_ERROR THEN
8334: IF PG_DEBUG <> 0 THEN
8335: oe_debug_pub.add ('Create_Item: ' || 'ERROR: create_item_data::exp error::'||to_char(lStmtNumber)||sqlerrm,1);
8336: END IF;
8337: CTO_MSG_PUB.Count_And_Get(
8338: p_msg_count => lMsgCount,
8339: p_msg_data => lMsgData
8340: );
8341: return(0);

Line 8347: CTO_MSG_PUB.Count_And_Get(

8343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8344: IF PG_DEBUG <> 0 THEN
8345: oe_debug_pub.add ('Create_Item: ' || 'ERROR: create_item_data::unexp error::'||to_char(lStmtNumber)||sqlerrm,1);
8346: END IF;
8347: CTO_MSG_PUB.Count_And_Get(
8348: p_msg_count => lMsgCount,
8349: p_msg_data => lMsgData
8350: );
8351: return(0);

Line 8358: CTO_MSG_PUB.Count_And_Get(

8354: WHEN OTHERS THEN
8355: IF PG_DEBUG <> 0 THEN
8356: oe_debug_pub.add ('Create_Item: ' || 'create_item_data::others::'||to_char(lStmtNumber)||sqlerrm,1);
8357: END IF;
8358: CTO_MSG_PUB.Count_And_Get(
8359: p_msg_count => lMsgCount,
8360: p_msg_data => lMsgData
8361: );
8362: return(0);

Line 8953: cto_msg_pub.cto_message('BOM','CTO_ORDER_LINE_EXCPN_HOLD');

8949:
8950: IF PG_DEBUG <> 0 THEN
8951: oe_debug_pub.add('CTOCITMB: An Exception Hold applied to config line.' ,1);
8952: END IF;
8953: cto_msg_pub.cto_message('BOM','CTO_ORDER_LINE_EXCPN_HOLD');
8954:
8955: else
8956: IF PG_DEBUG <> 0 THEN
8957: oe_debug_pub.add('CTOCITMB: Line is already on Hold.' ,1);

Line 8975: CTO_MSG_PUB.Count_And_Get(

8971: WHEN NO_DATA_FOUND THEN
8972: IF PG_DEBUG <> 0 THEN
8973: oe_debug_pub.add ('link_item: ' || 'ERROR: link_item::ndf::'||to_char(lStmtNumber)||'::'||sqlerrm, 1);
8974: END IF;
8975: CTO_MSG_PUB.Count_And_Get(
8976: p_msg_count => l_Msg_Count,
8977: p_msg_data => l_Msg_Data
8978: );
8979: return(0);

Line 8985: CTO_MSG_PUB.Count_And_Get(

8981: WHEN FND_API.G_EXC_ERROR THEN
8982: IF PG_DEBUG <> 0 THEN
8983: oe_debug_pub.add ('link_item: ' || 'ERROR: link_item::exp error::'||to_char(lStmtNumber)||sqlerrm, 1);
8984: END IF;
8985: CTO_MSG_PUB.Count_And_Get(
8986: p_msg_count => l_Msg_Count,
8987: p_msg_data => l_Msg_Data
8988: );
8989: return(0);

Line 8995: CTO_MSG_PUB.Count_And_Get(

8991: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8992: IF PG_DEBUG <> 0 THEN
8993: oe_debug_pub.add ('link_item: ' || 'ERROR: link_item::unexp error::'||to_char(lStmtNumber)||sqlerrm, 1);
8994: END IF;
8995: CTO_MSG_PUB.Count_And_Get(
8996: p_msg_count => l_Msg_Count,
8997: p_msg_data => l_Msg_Data
8998: );
8999: return(0);

Line 9005: CTO_MSG_PUB.Count_And_Get(

9001: WHEN OTHERS THEN
9002: IF PG_DEBUG <> 0 THEN
9003: oe_debug_pub.add ('link_item: ' || 'ERROR: link_item::others::'||to_char(lStmtNumber)||'::'||sqlerrm, 1);
9004: END IF;
9005: CTO_MSG_PUB.Count_And_Get(
9006: p_msg_count => l_Msg_Count,
9007: p_msg_data => l_Msg_Data
9008: );
9009: return(0);