DBA Data[Home] [Help]

APPS.CTO_ITEM_PK dependencies on CTO_MSG_PUB

Line 916: cto_msg_pub.cto_message('BOM','CTO_DELIMITER_ERROR');

912: if (length(lCiDel )<> 1 ) then
913: IF PG_DEBUG <> 0 THEN
914: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Error: Length of delimiter <> 1', 1);
915: END IF;
916: cto_msg_pub.cto_message('BOM','CTO_DELIMITER_ERROR');
917: raise FND_API.G_EXC_ERROR;
918: end if;
919: IF PG_DEBUG <> 0 THEN
920: oe_debug_pub.add('Create_And_Link_Item: ' || 'Delimiter is : ' || lCiDel,2);

Line 946: cto_msg_pub.cto_message('BOM','CTO_DELIMITER_ERROR');

942: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Error : Config Item delimiter = System Items FF segment separator. Not a valid setup.', 1);
943:
944: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Please set a different value for profile BOM:Configuration Item Delimiter.',1);
945: END IF;
946: cto_msg_pub.cto_message('BOM','CTO_DELIMITER_ERROR');
947: raise FND_API.G_EXC_ERROR;
948: end if;
949:
950:

Line 976: --cto_msg_pub.cto_message('BOM','CTO_CREATE_ITEM_ERROR');

972: IF lStatus <> 1 then
973: IF PG_DEBUG <> 0 THEN
974: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Create_All_Items returned with 0', 1);
975: END IF;
976: --cto_msg_pub.cto_message('BOM','CTO_CREATE_ITEM_ERROR');
977: raise FND_API.G_EXC_ERROR;
978: end if;
979:
980:

Line 1120: cto_msg_pub.count_and_get

1116: when NO_DATA_FOUND then
1117: IF PG_DEBUG <> 0 THEN
1118: oe_debug_pub.add('Create_And_Link_Item: ' || 'create_and_link_item::ndf::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
1119: END IF;
1120: cto_msg_pub.count_and_get
1121: ( p_msg_count => xMsgCount
1122: , p_msg_data => xMsgData
1123: );
1124: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1131: cto_msg_pub.count_and_get

1127: when FND_API.G_EXC_ERROR then
1128: IF PG_DEBUG <> 0 THEN
1129: oe_debug_pub.add('Create_And_Link_Item: ' || 'create_and_link_item::exp error in stmt '||to_char(lStmtNum), 1);
1130: END IF;
1131: cto_msg_pub.count_and_get
1132: ( p_msg_count => xMsgCount
1133: , p_msg_data => xMsgData
1134: );
1135: xReturnStatus := FND_API.G_RET_STS_ERROR;

Line 1142: cto_msg_pub.count_and_get

1138: when FND_API.G_EXC_UNEXPECTED_ERROR then
1139: IF PG_DEBUG <> 0 THEN
1140: oe_debug_pub.add('Create_And_Link_Item: ' || 'create_and_link_item::unexp error in stmt '||to_char(lStmtNum)||'::'||sqlerrm, 1);
1141: END IF;
1142: cto_msg_pub.count_and_get
1143: ( p_msg_count => xMsgCount
1144: , p_msg_data => xMsgData
1145: );
1146: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1159: cto_msg_pub.count_and_get

1155: ('CTO_ITEM_PK'
1156: ,'create_and_link_item'
1157: );
1158: END IF;
1159: cto_msg_pub.count_and_get
1160: ( p_msg_count => xMsgCount
1161: , p_msg_data => xMsgData
1162: );
1163: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1226: l_token CTO_MSG_PUB.token_tbl;

1222: v_bcmo_config_orgs bom_cto_order_lines.config_creation%type ;
1223:
1224: v_model_item_status number ;
1225: v_config_item_status number ;
1226: l_token CTO_MSG_PUB.token_tbl;
1227:
1228: v_model_item_name varchar2(2000) ;
1229: v_config_item_name varchar2(2000) ;
1230: l_lock_status number; -- bugfix 4227993

Line 1343: cto_msg_pub.cto_message('BOM','CTO_LOCK_TIMEOUT');

1339: --check for error cases
1340: if ( l_lock_status <> 0 ) THEN
1341: if (l_lock_status = 1) then -- timeout
1342: oe_debug_pub.add('l_lock_status = 1: TIMEOUT ');
1343: cto_msg_pub.cto_message('BOM','CTO_LOCK_TIMEOUT');
1344: raise fnd_api.g_exc_unexpected_error;
1345:
1346: elsif (l_lock_status = 2) then -- deadlock
1347: oe_debug_pub.add('l_lock_status = 2: DEADLOCK ');

Line 1348: cto_msg_pub.cto_message('BOM','CTO_LOCK_DEADLOCK');

1344: raise fnd_api.g_exc_unexpected_error;
1345:
1346: elsif (l_lock_status = 2) then -- deadlock
1347: oe_debug_pub.add('l_lock_status = 2: DEADLOCK ');
1348: cto_msg_pub.cto_message('BOM','CTO_LOCK_DEADLOCK');
1349: raise fnd_api.g_exc_unexpected_error;
1350:
1351: elsif (l_lock_status = 3) then -- parameter error
1352: oe_debug_pub.add('l_lock_status = 3: PARAMETER ERROR ');

Line 1353: cto_msg_pub.cto_message('BOM','CTO_LOCK_PARAM_ERROR');

1349: raise fnd_api.g_exc_unexpected_error;
1350:
1351: elsif (l_lock_status = 3) then -- parameter error
1352: oe_debug_pub.add('l_lock_status = 3: PARAMETER ERROR ');
1353: cto_msg_pub.cto_message('BOM','CTO_LOCK_PARAM_ERROR');
1354: raise fnd_api.g_exc_unexpected_error;
1355:
1356: elsif (l_lock_status = 4) then -- already locked.
1357: oe_debug_pub.add('l_lock_status = 4: ALREADY LOCKED ERROR ');

Line 1358: cto_msg_pub.cto_message('BOM','CTO_LOCK_ALREADY_LOCKED');

1354: raise fnd_api.g_exc_unexpected_error;
1355:
1356: elsif (l_lock_status = 4) then -- already locked.
1357: oe_debug_pub.add('l_lock_status = 4: ALREADY LOCKED ERROR ');
1358: cto_msg_pub.cto_message('BOM','CTO_LOCK_ALREADY_LOCKED');
1359: -- we shall not raise an error if we are already holding the lock.
1360:
1361: else -- internal error - not fault of user
1362: oe_debug_pub.add('l_lock_status = '||l_lock_status||': INTERNAL ERROR ');

Line 1363: cto_msg_pub.cto_message('BOM','CTO_LOCK_ERROR');

1359: -- we shall not raise an error if we are already holding the lock.
1360:
1361: else -- internal error - not fault of user
1362: oe_debug_pub.add('l_lock_status = '||l_lock_status||': INTERNAL ERROR ');
1363: cto_msg_pub.cto_message('BOM','CTO_LOCK_ERROR');
1364: raise fnd_api.g_exc_unexpected_error;
1365: end if;
1366: else
1367: IF PG_DEBUG <> 0 THEN

Line 1572: -- cto_msg_pub.cto_message('BOM','CTO_CREATE_ITEM_ERROR');

1568: 'Create_Item returned 0::item::'||
1569: to_char(v_model_lines.inventory_item_id), 1);
1570: END IF;
1571:
1572: -- cto_msg_pub.cto_message('BOM','CTO_CREATE_ITEM_ERROR');
1573: raise FND_API.G_EXC_ERROR;
1574:
1575:
1576: ELSE --if status is success

Line 1802: cto_msg_pub.cto_message('BOM','CTO_MATCH_ITEM_NOT_ENABLED', l_token );

1798: l_token(2).token_name := 'CONFIG_NAME';
1799: l_token(2).token_value := v_config_item_name;
1800:
1801:
1802: cto_msg_pub.cto_message('BOM','CTO_MATCH_ITEM_NOT_ENABLED', l_token );
1803:
1804: raise FND_API.G_EXC_ERROR;
1805:
1806:

Line 1894: -- cto_msg_pub.cto_message('BOM','CTO_CREATE_ITEM_ERROR');

1890: 'Create_Item returned 0::item::'||
1891: to_char(v_model_lines.inventory_item_id), 1);
1892: END IF;
1893:
1894: -- cto_msg_pub.cto_message('BOM','CTO_CREATE_ITEM_ERROR');
1895: raise FND_API.G_EXC_ERROR;
1896:
1897:
1898: ELSE --if status is success

Line 1995: cto_msg_pub.count_and_get

1991: IF PG_DEBUG <> 0 THEN
1992: oe_debug_pub.add('Create_All_Items: ' || 'create_all_items::ndf::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
1993: END IF;
1994: xReturnStatus := fnd_api.g_ret_sts_error;
1995: cto_msg_pub.count_and_get
1996: ( p_msg_count => xMsgCount
1997: , p_msg_data => xMsgData
1998: );
1999: return(0);

Line 2006: cto_msg_pub.count_and_get

2002: IF PG_DEBUG <> 0 THEN
2003: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::exp error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2004: END IF;
2005: xReturnStatus := fnd_api.g_ret_sts_error;
2006: cto_msg_pub.count_and_get
2007: ( p_msg_count => xMsgCount
2008: , p_msg_data => xMsgData
2009: );
2010: return(0);

Line 2017: cto_msg_pub.count_and_get

2013: IF PG_DEBUG <> 0 THEN
2014: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2015: END IF;
2016: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
2017: cto_msg_pub.count_and_get
2018: ( p_msg_count => xMsgCount
2019: , p_msg_data => xMsgData
2020: );
2021: return(0);

Line 2028: cto_msg_pub.count_and_get

2024: IF PG_DEBUG <> 0 THEN
2025: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::others::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2026: END IF;
2027: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
2028: cto_msg_pub.count_and_get
2029: ( p_msg_count => xMsgCount
2030: , p_msg_data => xMsgData
2031: );
2032: return(0);