APPS.CTO_UPDATE_ITEMS_PK dependencies on CTO_MSG_PUB

Line 698: cto_msg_pub.count_and_get

694:
695: EXCEPTION
696: when NO_DATA_FOUND then
697: WriteToLog('ERROR: NDF in Update_Items_and_Sourcing::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
698: cto_msg_pub.count_and_get
699: ( p_msg_count => xMsgCount
700: , p_msg_data => xMsgData
701: );
702: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

Line 707: cto_msg_pub.count_and_get

703: --return(0);
704:
705: when FND_API.G_EXC_ERROR then
706: WriteToLog('ERROR: Expected error in Update_Items_and_Sourcing::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
707: cto_msg_pub.count_and_get
708: ( p_msg_count => xMsgCount
709: , p_msg_data => xMsgData
710: );
711: xReturnStatus := FND_API.G_RET_STS_ERROR;

Line 716: cto_msg_pub.count_and_get

712: --return(0);
713:
714: when FND_API.G_EXC_UNEXPECTED_ERROR then
715: WriteToLog('ERROR: Unxpected error in Update_Items_and_Sourcing::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
716: cto_msg_pub.count_and_get
717: ( p_msg_count => xMsgCount
718: , p_msg_data => xMsgData
719: );
720: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

Line 725: cto_msg_pub.count_and_get

721: --return(0);
722:
723: when OTHERS then
724: WriteToLog('ERROR: Others error in Update_Items_and_Sourcing::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
725: cto_msg_pub.count_and_get
726: ( p_msg_count => xMsgCount
727: , p_msg_data => xMsgData
728: );
729: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

Line 890: cto_msg_pub.count_and_get

886:
887: EXCEPTION
888: when OTHERS then
889: WriteToLog('Others error in Update_bcso::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
890: cto_msg_pub.count_and_get
891: ( p_msg_count => l_msg_count
892: , p_msg_data => l_msg_data
893: );
894: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1546: when no_data_found then
1547: IF PG_DEBUG <> 0 THEN
1548: oe_debug_pub.add('Create_Item: ' || ' no_data_found error for cost type id = 7 ',2);
1549: END IF;
1550: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
1551: raise FND_API.G_EXC_ERROR;
1552: when others then
1553:
1554: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2852: CTO_MSG_PUB.Count_And_Get(

2848:
2849: EXCEPTION
2850: WHEN NO_DATA_FOUND THEN
2851: WriteToLog ('ERROR:NDF in update_item_data'||to_char(lStmtNumber)||sqlerrm,1);
2852: CTO_MSG_PUB.Count_And_Get(
2853: p_msg_count => lMsgCount,
2854: p_msg_data => lMsgData
2855: );
2856: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2860: CTO_MSG_PUB.Count_And_Get(

2856: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
2857:
2858: WHEN FND_API.G_EXC_ERROR THEN
2859: WriteToLog ('ERROR:Expected error in update_item_data'||to_char(lStmtNumber)||sqlerrm,1);
2860: CTO_MSG_PUB.Count_And_Get(
2861: p_msg_count => lMsgCount,
2862: p_msg_data => lMsgData
2863: );
2864: xReturnStatus := FND_API.G_RET_STS_ERROR;

Line 2868: CTO_MSG_PUB.Count_And_Get(

2864: xReturnStatus := FND_API.G_RET_STS_ERROR;
2865:
2866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2867: WriteToLog ('ERROR:Unexpected error in update_item_data'||to_char(lStmtNumber)||sqlerrm,1);
2868: CTO_MSG_PUB.Count_And_Get(
2869: p_msg_count => lMsgCount,
2870: p_msg_data => lMsgData
2871: );
2872: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2876: CTO_MSG_PUB.Count_And_Get(

2872: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
2873:
2874: WHEN OTHERS THEN
2875: WriteToLog ('ERROR:Others error in update_item_data'||to_char(lStmtNumber)||sqlerrm,1);
2876: CTO_MSG_PUB.Count_And_Get(
2877: p_msg_count => lMsgCount,
2878: p_msg_data => lMsgData
2879: );
2880: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3627: CTO_MSG_PUB.Count_And_Get(

3623:
3624: EXCEPTION
3625: WHEN OTHERS THEN
3626: WriteToLog ('ERROR: Others error in Update_Acc_Items::'||to_char(lStmtNumber)||sqlerrm,1);
3627: CTO_MSG_PUB.Count_And_Get(
3628: p_msg_count => xMsgCount,
3629: p_msg_data => xMsgData
3630: );
3631: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4369: CTO_MSG_PUB.Count_And_Get(

4365:
4366: EXCEPTION
4367: WHEN OTHERS THEN
4368: WriteToLog ('ERROR: Others error in Update_Pc_Items::'||to_char(lStmtNumber)||sqlerrm,1);
4369: CTO_MSG_PUB.Count_And_Get(
4370: p_msg_count => xMsgCount,
4371: p_msg_data => xMsgData
4372: );
4373: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;