DBA Data[Home] [Help]

APPS.CTO_ITEM_PK dependencies on CTO_MSG_PUB

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

966: if (length(lCiDel )<> 1 ) then
967: IF PG_DEBUG <> 0 THEN
968: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Error: Length of delimiter <> 1', 1);
969: END IF;
970: cto_msg_pub.cto_message('BOM','CTO_DELIMITER_ERROR');
971: raise FND_API.G_EXC_ERROR;
972: end if;
973: IF PG_DEBUG <> 0 THEN
974: oe_debug_pub.add('Create_And_Link_Item: ' || 'Delimiter is : ' || lCiDel,2);

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

996: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Error : Config Item delimiter = System Items FF segment separator. Not a valid setup.', 1);
997:
998: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Please set a different value for profile BOM:Configuration Item Delimiter.',1);
999: END IF;
1000: cto_msg_pub.cto_message('BOM','CTO_DELIMITER_ERROR');
1001: raise FND_API.G_EXC_ERROR;
1002: end if;
1003:
1004:

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

1026: IF lStatus <> 1 then
1027: IF PG_DEBUG <> 0 THEN
1028: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Create_All_Items returned with 0', 1);
1029: END IF;
1030: --cto_msg_pub.cto_message('BOM','CTO_CREATE_ITEM_ERROR');
1031: raise FND_API.G_EXC_ERROR;
1032: end if;
1033:
1034:

Line 1177: cto_msg_pub.count_and_get

1173: when NO_DATA_FOUND then
1174: IF PG_DEBUG <> 0 THEN
1175: oe_debug_pub.add('Create_And_Link_Item: ' || 'create_and_link_item::ndf::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
1176: END IF;
1177: cto_msg_pub.count_and_get
1178: ( p_msg_count => xMsgCount
1179: , p_msg_data => xMsgData
1180: );
1181: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1188: cto_msg_pub.count_and_get

1184: when FND_API.G_EXC_ERROR then
1185: IF PG_DEBUG <> 0 THEN
1186: oe_debug_pub.add('Create_And_Link_Item: ' || 'create_and_link_item::exp error in stmt '||to_char(lStmtNum), 1);
1187: END IF;
1188: cto_msg_pub.count_and_get
1189: ( p_msg_count => xMsgCount
1190: , p_msg_data => xMsgData
1191: );
1192: xReturnStatus := FND_API.G_RET_STS_ERROR;

Line 1199: cto_msg_pub.count_and_get

1195: when FND_API.G_EXC_UNEXPECTED_ERROR then
1196: IF PG_DEBUG <> 0 THEN
1197: oe_debug_pub.add('Create_And_Link_Item: ' || 'create_and_link_item::unexp error in stmt '||to_char(lStmtNum)||'::'||sqlerrm, 1);
1198: END IF;
1199: cto_msg_pub.count_and_get
1200: ( p_msg_count => xMsgCount
1201: , p_msg_data => xMsgData
1202: );
1203: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1216: cto_msg_pub.count_and_get

1212: ('CTO_ITEM_PK'
1213: ,'create_and_link_item'
1214: );
1215: END IF;
1216: cto_msg_pub.count_and_get
1217: ( p_msg_count => xMsgCount
1218: , p_msg_data => xMsgData
1219: );
1220: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1283: l_token CTO_MSG_PUB.token_tbl;

1279: v_bcmo_config_orgs bom_cto_order_lines.config_creation%type ;
1280:
1281: v_model_item_status number ;
1282: v_config_item_status number ;
1283: l_token CTO_MSG_PUB.token_tbl;
1284:
1285: v_model_item_name varchar2(2000) ;
1286: v_config_item_name varchar2(2000) ;
1287: l_lock_status number; -- bugfix 4227993

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

1396: --check for error cases
1397: if ( l_lock_status <> 0 ) THEN
1398: if (l_lock_status = 1) then -- timeout
1399: oe_debug_pub.add('l_lock_status = 1: TIMEOUT ');
1400: cto_msg_pub.cto_message('BOM','CTO_LOCK_TIMEOUT');
1401: raise fnd_api.g_exc_unexpected_error;
1402:
1403: elsif (l_lock_status = 2) then -- deadlock
1404: oe_debug_pub.add('l_lock_status = 2: DEADLOCK ');

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

1401: raise fnd_api.g_exc_unexpected_error;
1402:
1403: elsif (l_lock_status = 2) then -- deadlock
1404: oe_debug_pub.add('l_lock_status = 2: DEADLOCK ');
1405: cto_msg_pub.cto_message('BOM','CTO_LOCK_DEADLOCK');
1406: raise fnd_api.g_exc_unexpected_error;
1407:
1408: elsif (l_lock_status = 3) then -- parameter error
1409: oe_debug_pub.add('l_lock_status = 3: PARAMETER ERROR ');

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

1406: raise fnd_api.g_exc_unexpected_error;
1407:
1408: elsif (l_lock_status = 3) then -- parameter error
1409: oe_debug_pub.add('l_lock_status = 3: PARAMETER ERROR ');
1410: cto_msg_pub.cto_message('BOM','CTO_LOCK_PARAM_ERROR');
1411: raise fnd_api.g_exc_unexpected_error;
1412:
1413: elsif (l_lock_status = 4) then -- already locked.
1414: oe_debug_pub.add('l_lock_status = 4: ALREADY LOCKED ERROR ');

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

1411: raise fnd_api.g_exc_unexpected_error;
1412:
1413: elsif (l_lock_status = 4) then -- already locked.
1414: oe_debug_pub.add('l_lock_status = 4: ALREADY LOCKED ERROR ');
1415: cto_msg_pub.cto_message('BOM','CTO_LOCK_ALREADY_LOCKED');
1416: -- we shall not raise an error if we are already holding the lock.
1417:
1418: else -- internal error - not fault of user
1419: oe_debug_pub.add('l_lock_status = '||l_lock_status||': INTERNAL ERROR ');

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

1416: -- we shall not raise an error if we are already holding the lock.
1417:
1418: else -- internal error - not fault of user
1419: oe_debug_pub.add('l_lock_status = '||l_lock_status||': INTERNAL ERROR ');
1420: cto_msg_pub.cto_message('BOM','CTO_LOCK_ERROR');
1421: raise fnd_api.g_exc_unexpected_error;
1422: end if;
1423: else
1424: IF PG_DEBUG <> 0 THEN

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

1625: 'Create_Item returned 0::item::'||
1626: to_char(v_model_lines.inventory_item_id), 1);
1627: END IF;
1628:
1629: -- cto_msg_pub.cto_message('BOM','CTO_CREATE_ITEM_ERROR');
1630: raise FND_API.G_EXC_ERROR;
1631:
1632:
1633: ELSE --if status is success

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

1858: l_token(2).token_name := 'CONFIG_NAME';
1859: l_token(2).token_value := v_config_item_name;
1860:
1861:
1862: cto_msg_pub.cto_message('BOM','CTO_MATCH_ITEM_NOT_ENABLED', l_token );
1863:
1864: raise FND_API.G_EXC_ERROR;
1865:
1866:

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

1950: 'Create_Item returned 0::item::'||
1951: to_char(v_model_lines.inventory_item_id), 1);
1952: END IF;
1953:
1954: -- cto_msg_pub.cto_message('BOM','CTO_CREATE_ITEM_ERROR');
1955: raise FND_API.G_EXC_ERROR;
1956:
1957:
1958: ELSE --if status is success

Line 2063: cto_msg_pub.count_and_get

2059: IF PG_DEBUG <> 0 THEN
2060: oe_debug_pub.add('Create_All_Items: ' || 'create_all_items::ndf::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2061: END IF;
2062: xReturnStatus := fnd_api.g_ret_sts_error;
2063: cto_msg_pub.count_and_get
2064: ( p_msg_count => xMsgCount
2065: , p_msg_data => xMsgData
2066: );
2067: return(0);

Line 2074: cto_msg_pub.count_and_get

2070: IF PG_DEBUG <> 0 THEN
2071: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::exp error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2072: END IF;
2073: xReturnStatus := fnd_api.g_ret_sts_error;
2074: cto_msg_pub.count_and_get
2075: ( p_msg_count => xMsgCount
2076: , p_msg_data => xMsgData
2077: );
2078: return(0);

Line 2085: cto_msg_pub.count_and_get

2081: IF PG_DEBUG <> 0 THEN
2082: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2083: END IF;
2084: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
2085: cto_msg_pub.count_and_get
2086: ( p_msg_count => xMsgCount
2087: , p_msg_data => xMsgData
2088: );
2089: return(0);

Line 2096: cto_msg_pub.count_and_get

2092: IF PG_DEBUG <> 0 THEN
2093: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::others::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2094: END IF;
2095: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
2096: cto_msg_pub.count_and_get
2097: ( p_msg_count => xMsgCount
2098: , p_msg_data => xMsgData
2099: );
2100: return(0);