APPS.CTO_UPDATE_ITEMS_PK dependencies on CTO_MSG_PUB

Line 842: cto_msg_pub.count_and_get

838:
839: EXCEPTION
840: when NO_DATA_FOUND then
841: WriteToLog('ERROR: NDF in Update_Items_and_Sourcing::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
842: cto_msg_pub.count_and_get
843: ( p_msg_count => xMsgCount
844: , p_msg_data => xMsgData
845: );
846: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

Line 851: cto_msg_pub.count_and_get

847: --return(0);
848:
849: when FND_API.G_EXC_ERROR then
850: WriteToLog('ERROR: Expected error in Update_Items_and_Sourcing::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
851: cto_msg_pub.count_and_get
852: ( p_msg_count => xMsgCount
853: , p_msg_data => xMsgData
854: );
855: xReturnStatus := FND_API.G_RET_STS_ERROR;

Line 860: cto_msg_pub.count_and_get

856: --return(0);
857:
858: when FND_API.G_EXC_UNEXPECTED_ERROR then
859: WriteToLog('ERROR: Unxpected error in Update_Items_and_Sourcing::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
860: cto_msg_pub.count_and_get
861: ( p_msg_count => xMsgCount
862: , p_msg_data => xMsgData
863: );
864: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

Line 869: cto_msg_pub.count_and_get

865: --return(0);
866:
867: when OTHERS then
868: WriteToLog('ERROR: Others error in Update_Items_and_Sourcing::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
869: cto_msg_pub.count_and_get
870: ( p_msg_count => xMsgCount
871: , p_msg_data => xMsgData
872: );
873: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1033: cto_msg_pub.count_and_get

1029:
1030: EXCEPTION
1031: when OTHERS then
1032: WriteToLog('Others error in Update_bcso::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
1033: cto_msg_pub.count_and_get
1034: ( p_msg_count => l_msg_count
1035: , p_msg_data => l_msg_data
1036: );
1037: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1689: when no_data_found then
1690: IF PG_DEBUG <> 0 THEN
1691: oe_debug_pub.add('Create_Item: ' || ' no_data_found error for cost type id = 7 ',2);
1692: END IF;
1693: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
1694: raise FND_API.G_EXC_ERROR;
1695: when others then
1696:
1697: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3021: CTO_MSG_PUB.Count_And_Get(

3017:
3018: EXCEPTION
3019: WHEN NO_DATA_FOUND THEN
3020: WriteToLog ('ERROR:NDF in update_item_data'||to_char(lStmtNumber)||sqlerrm,1);
3021: CTO_MSG_PUB.Count_And_Get(
3022: p_msg_count => lMsgCount,
3023: p_msg_data => lMsgData
3024: );
3025: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3029: CTO_MSG_PUB.Count_And_Get(

3025: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
3026:
3027: WHEN FND_API.G_EXC_ERROR THEN
3028: WriteToLog ('ERROR:Expected error in update_item_data'||to_char(lStmtNumber)||sqlerrm,1);
3029: CTO_MSG_PUB.Count_And_Get(
3030: p_msg_count => lMsgCount,
3031: p_msg_data => lMsgData
3032: );
3033: xReturnStatus := FND_API.G_RET_STS_ERROR;

Line 3037: CTO_MSG_PUB.Count_And_Get(

3033: xReturnStatus := FND_API.G_RET_STS_ERROR;
3034:
3035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3036: WriteToLog ('ERROR:Unexpected error in update_item_data'||to_char(lStmtNumber)||sqlerrm,1);
3037: CTO_MSG_PUB.Count_And_Get(
3038: p_msg_count => lMsgCount,
3039: p_msg_data => lMsgData
3040: );
3041: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3045: CTO_MSG_PUB.Count_And_Get(

3041: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
3042:
3043: WHEN OTHERS THEN
3044: WriteToLog ('ERROR:Others error in update_item_data'||to_char(lStmtNumber)||sqlerrm,1);
3045: CTO_MSG_PUB.Count_And_Get(
3046: p_msg_count => lMsgCount,
3047: p_msg_data => lMsgData
3048: );
3049: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3839: CTO_MSG_PUB.Count_And_Get(

3835:
3836: EXCEPTION
3837: WHEN OTHERS THEN
3838: WriteToLog ('ERROR: Others error in Update_Acc_Items::'||to_char(lStmtNumber)||sqlerrm,1);
3839: CTO_MSG_PUB.Count_And_Get(
3840: p_msg_count => xMsgCount,
3841: p_msg_data => xMsgData
3842: );
3843: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4621: CTO_MSG_PUB.Count_And_Get(

4617:
4618: EXCEPTION
4619: WHEN OTHERS THEN
4620: WriteToLog ('ERROR: Others error in Update_Pc_Items::'||to_char(lStmtNumber)||sqlerrm,1);
4621: CTO_MSG_PUB.Count_And_Get(
4622: p_msg_count => xMsgCount,
4623: p_msg_data => xMsgData
4624: );
4625: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;