DBA Data[Home] [Help]

APPS.CTO_CONFIG_ITEM_PK dependencies on CTO_MSG_PUB

Line 1693: CTO_MSG_PUB.Count_And_Get(

1689: when FND_API.G_EXC_ERROR then
1690:
1691: if( xMessageName is null ) then /* xMessageName can be not null in case of CTO_DELINK_SHIPPING_ERROR */
1692: /* Bugfix 2454788 */
1693: CTO_MSG_PUB.Count_And_Get(
1694: p_msg_count => lCount,
1695: p_msg_data => xErrorMessage
1696: );
1697: IF PG_DEBUG <> 0 THEN

Line 1740: CTO_MSG_PUB.Count_And_Get(

1736: return(0);
1737:
1738:
1739: when FND_API.G_EXC_UNEXPECTED_ERROR then
1740: CTO_MSG_PUB.Count_And_Get(
1741: p_msg_count => lCount,
1742: p_msg_data => xErrorMessage
1743: );
1744: IF PG_DEBUG <> 0 THEN

Line 1757: CTO_MSG_PUB.Count_And_Get(

1753: END IF;
1754: xMessageName := 'CTO_DELINK_ITEM_ERROR';
1755: xErrorMessage := 'ERROR: CTOCITMB.delink:'||to_char(lStmtNumber)||
1756: ':' || substrb(sqlerrm,1,150);
1757: CTO_MSG_PUB.Count_And_Get(
1758: p_msg_count => lCount,
1759: p_msg_data => xErrorMessage
1760: );
1761: return(0);

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

4206: end if ;
4207:
4208:
4209: if lVAlidationOrg = -99 then -- bugfix 2646849
4210: cto_msg_pub.cto_message('BOM','CTO_VALIDATION_ORG_NOT_SET');
4211: raise FND_API.G_EXC_ERROR;
4212: end if;
4213:
4214: IF PG_DEBUG <> 0 THEN

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

4246: where organization_id = lValidationOrg;
4247:
4248:
4249: if lConfigSegName is NULL then
4250: cto_msg_pub.cto_message('BOM','CTO_CONFIG_SEGMENT_ERROR');
4251: raise FND_API.G_EXC_ERROR;
4252: end if;
4253:
4254: IF PG_DEBUG <> 0 THEN

Line 5734: CTO_MSG_PUB.Count_And_Get(

5730: WHEN NO_DATA_FOUND THEN
5731: IF PG_DEBUG <> 0 THEN
5732: oe_debug_pub.add ('Create_Item: ' || 'ERROR: create_item::ndf::'||to_char(lStmtNumber)||sqlerrm,1);
5733: END IF;
5734: CTO_MSG_PUB.Count_And_Get(
5735: p_msg_count => xMsgCount,
5736: p_msg_data => xMsgData
5737: );
5738: return(0);

Line 5744: CTO_MSG_PUB.Count_And_Get(

5740: WHEN FND_API.G_EXC_ERROR THEN
5741: IF PG_DEBUG <> 0 THEN
5742: oe_debug_pub.add ('Create_Item: ' || 'ERROR: create_item::exp error::'||to_char(lStmtNumber)||sqlerrm,1);
5743: END IF;
5744: CTO_MSG_PUB.Count_And_Get(
5745: p_msg_count => xMsgCount,
5746: p_msg_data => xMsgData
5747: );
5748: return(0);

Line 5754: CTO_MSG_PUB.Count_And_Get(

5750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5751: IF PG_DEBUG <> 0 THEN
5752: oe_debug_pub.add ('Create_Item: ' || 'ERROR: create_item::unexp error::'||to_char(lStmtNumber)||sqlerrm,1);
5753: END IF;
5754: CTO_MSG_PUB.Count_And_Get(
5755: p_msg_count => xMsgCount,
5756: p_msg_data => xMsgData
5757: );
5758: return(0);

Line 5764: CTO_MSG_PUB.Count_And_Get(

5760: WHEN OTHERS THEN
5761: IF PG_DEBUG <> 0 THEN
5762: oe_debug_pub.add ('Create_Item: ' || 'ERROR: create_item::others::'||to_char(lStmtNumber)||sqlerrm,1);
5763: END IF;
5764: CTO_MSG_PUB.Count_And_Get(
5765: p_msg_count => xMsgCount,
5766: p_msg_data => xMsgData
5767: );
5768: return(0);

Line 5984: CTO_MSG_PUB.Count_And_Get(

5980: WHEN OTHERS THEN
5981: IF PG_DEBUG <> 0 THEN
5982: oe_debug_pub.add ('Create_Item: ' || 'ERROR: Ato_Weight_Volume::others::'||to_char(lStmtNumber)||':-'||sqlerrm,1);
5983: END IF;
5984: CTO_MSG_PUB.Count_And_Get(
5985: p_msg_count => lMsgCount,
5986: p_msg_data => lMsgData
5987: );
5988: status := -1;

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

6170: oe_debug_pub.add('Create_Item: ' || 'After getting validation org',2);
6171: END IF;
6172:
6173: if lVAlidationOrg = -99 then -- bugfix 2646849
6174: cto_msg_pub.cto_message('BOM','CTO_VALIDATION_ORG_NOT_SET');
6175: RAISE FND_API.G_EXC_ERROR;
6176: end if;
6177:
6178:

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

6650: when no_data_found then
6651: IF PG_DEBUG <> 0 THEN
6652: oe_debug_pub.add('Create_Item: ' || ' no_data_found error for cost type id = 7 ',2);
6653: END IF;
6654: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
6655: raise FND_API.G_EXC_ERROR;
6656: when others then
6657:
6658: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8046: CTO_MSG_PUB.Count_And_Get(

8042: WHEN NO_DATA_FOUND THEN
8043: IF PG_DEBUG <> 0 THEN
8044: oe_debug_pub.add ('Create_Item: ' || 'ERROR: create_item_data::ndf::'||to_char(lStmtNumber)||sqlerrm,1);
8045: END IF;
8046: CTO_MSG_PUB.Count_And_Get(
8047: p_msg_count => lMsgCount,
8048: p_msg_data => lMsgData
8049: );
8050: return(0);

Line 8056: CTO_MSG_PUB.Count_And_Get(

8052: WHEN FND_API.G_EXC_ERROR THEN
8053: IF PG_DEBUG <> 0 THEN
8054: oe_debug_pub.add ('Create_Item: ' || 'ERROR: create_item_data::exp error::'||to_char(lStmtNumber)||sqlerrm,1);
8055: END IF;
8056: CTO_MSG_PUB.Count_And_Get(
8057: p_msg_count => lMsgCount,
8058: p_msg_data => lMsgData
8059: );
8060: return(0);

Line 8066: CTO_MSG_PUB.Count_And_Get(

8062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8063: IF PG_DEBUG <> 0 THEN
8064: oe_debug_pub.add ('Create_Item: ' || 'ERROR: create_item_data::unexp error::'||to_char(lStmtNumber)||sqlerrm,1);
8065: END IF;
8066: CTO_MSG_PUB.Count_And_Get(
8067: p_msg_count => lMsgCount,
8068: p_msg_data => lMsgData
8069: );
8070: return(0);

Line 8077: CTO_MSG_PUB.Count_And_Get(

8073: WHEN OTHERS THEN
8074: IF PG_DEBUG <> 0 THEN
8075: oe_debug_pub.add ('Create_Item: ' || 'create_item_data::others::'||to_char(lStmtNumber)||sqlerrm,1);
8076: END IF;
8077: CTO_MSG_PUB.Count_And_Get(
8078: p_msg_count => lMsgCount,
8079: p_msg_data => lMsgData
8080: );
8081: return(0);

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

8648:
8649: IF PG_DEBUG <> 0 THEN
8650: oe_debug_pub.add('CTOCITMB: An Exception Hold applied to config line.' ,1);
8651: END IF;
8652: cto_msg_pub.cto_message('BOM','CTO_ORDER_LINE_EXCPN_HOLD');
8653:
8654: else
8655: IF PG_DEBUG <> 0 THEN
8656: oe_debug_pub.add('CTOCITMB: Line is already on Hold.' ,1);

Line 8674: CTO_MSG_PUB.Count_And_Get(

8670: WHEN NO_DATA_FOUND THEN
8671: IF PG_DEBUG <> 0 THEN
8672: oe_debug_pub.add ('link_item: ' || 'ERROR: link_item::ndf::'||to_char(lStmtNumber)||'::'||sqlerrm, 1);
8673: END IF;
8674: CTO_MSG_PUB.Count_And_Get(
8675: p_msg_count => l_Msg_Count,
8676: p_msg_data => l_Msg_Data
8677: );
8678: return(0);

Line 8684: CTO_MSG_PUB.Count_And_Get(

8680: WHEN FND_API.G_EXC_ERROR THEN
8681: IF PG_DEBUG <> 0 THEN
8682: oe_debug_pub.add ('link_item: ' || 'ERROR: link_item::exp error::'||to_char(lStmtNumber)||sqlerrm, 1);
8683: END IF;
8684: CTO_MSG_PUB.Count_And_Get(
8685: p_msg_count => l_Msg_Count,
8686: p_msg_data => l_Msg_Data
8687: );
8688: return(0);

Line 8694: CTO_MSG_PUB.Count_And_Get(

8690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8691: IF PG_DEBUG <> 0 THEN
8692: oe_debug_pub.add ('link_item: ' || 'ERROR: link_item::unexp error::'||to_char(lStmtNumber)||sqlerrm, 1);
8693: END IF;
8694: CTO_MSG_PUB.Count_And_Get(
8695: p_msg_count => l_Msg_Count,
8696: p_msg_data => l_Msg_Data
8697: );
8698: return(0);

Line 8704: CTO_MSG_PUB.Count_And_Get(

8700: WHEN OTHERS THEN
8701: IF PG_DEBUG <> 0 THEN
8702: oe_debug_pub.add ('link_item: ' || 'ERROR: link_item::others::'||to_char(lStmtNumber)||'::'||sqlerrm, 1);
8703: END IF;
8704: CTO_MSG_PUB.Count_And_Get(
8705: p_msg_count => l_Msg_Count,
8706: p_msg_data => l_Msg_Data
8707: );
8708: return(0);