DBA Data[Home] [Help]

APPS.CTO_WORKFLOW_API_PK dependencies on CTO_MSG_PUB

Line 841: cto_msg_pub.cto_message('BOM', 'CTO_RESERVATION_INELIGIBLE');

837: end ;
838:
839: exception
840: when DROPSHIP_EXCEPTION then
841: cto_msg_pub.cto_message('BOM', 'CTO_RESERVATION_INELIGIBLE');
842:
843: raise FND_API.G_EXC_ERROR;
844:
845: when others then

Line 890: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');

886: if upper(v_activity_status_code) <> 'NOTIFIED' then
887: If PG_DEBUG <> 0 then
888: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'v_activity_status_code <> NOTIFIED');
889: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
890: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
891: End if;
892: raise FND_API.G_EXC_ERROR;
893: end if;
894: end if;

Line 911: cto_msg_pub.count_and_get(

907: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no :'|| to_char(l_stmt_num));
908: End if;
909:
910: x_return_status := FND_API.G_RET_STS_ERROR;
911: cto_msg_pub.count_and_get(
912: p_msg_count => x_msg_count,
913: p_msg_data => x_msg_data
914: );
915: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 921: cto_msg_pub.count_and_get(

917: oe_debug_pub.add('inventory_reservation_check: ' || 'unexp error in CTO_WORKFLOW_API_PK.inventory_reservation_check::stmt number '||to_char(l_stmt_num), 1);
918: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no:'|| to_char(l_stmt_num));
919: End if;
920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
921: cto_msg_pub.count_and_get(
922: p_msg_count => x_msg_count,
923: p_msg_data => x_msg_data
924: );
925:

Line 938: cto_msg_pub.count_and_get(

934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
935: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
936: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
937: END IF;
938: cto_msg_pub.count_and_get(
939: p_msg_count => x_msg_count,
940: p_msg_data => x_msg_data
941: );
942:

Line 1179: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');

1175: if return_value <> 1 then
1176: If PG_DEBUG <> 0 Then
1177: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Raising CTO_ERROR_FROM_DISPLAY_STATUS');
1178: End if;
1179: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');
1180: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1181: end if;
1182:
1183:

Line 1283: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');

1279: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_reserv', 'v_activity_status_code <> NOTIFIED');
1280: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_reserv', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1281: End if;
1282:
1283: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
1284: raise FND_API.G_EXC_ERROR;
1285: end if;
1286:
1287: END IF; /* end of v_activity_status_code check */

Line 1310: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');

1306: IF return_value <> 1 then
1307: IF PG_DEBUG <> 0 Then
1308: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Raising CTO_ERROR_FROM_DISPLAY_STATUS');
1309: End if;
1310: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');
1311: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1312: END IF;
1313:
1314: end if; /* end of item_type_code check */

Line 1335: cto_msg_pub.count_and_get(

1331: stmt no : '||to_char(l_stmt_num)||'::'||sqlerrm);
1332: End if;
1333:
1334: x_return_status := FND_API.G_RET_STS_ERROR;
1335: cto_msg_pub.count_and_get(
1336: p_msg_count => x_msg_count,
1337: p_msg_data => x_msg_data
1338: );
1339:

Line 1349: cto_msg_pub.count_and_get(

1345: stmt no : '||to_char(l_stmt_num)||'::'||sqlerrm);
1346: End if;
1347:
1348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1349: cto_msg_pub.count_and_get(
1350: p_msg_count => x_msg_count,
1351: p_msg_data => x_msg_data
1352: );
1353:

Line 1369: cto_msg_pub.count_and_get(

1365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1366: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1367: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1368: END IF;
1369: cto_msg_pub.count_and_get(
1370: p_msg_count => x_msg_count,
1371: p_msg_data => x_msg_data
1372: );
1373:

Line 1435: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');

1431: If PG_DEBUG <> 0 Then
1432: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'v_activity_status_code <> NOTIFIED');
1433: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1434: End if;
1435: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
1436: raise FND_API.G_EXC_ERROR;
1437: end if;
1438: end if;
1439:

Line 1467: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');

1463: If PG_DEBUG <> 0 Then
1464: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'v_activity_status_code <> NOTIFIED');
1465: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1466: End if;
1467: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
1468: raise FND_API.G_EXC_ERROR;
1469: else
1470: IF PG_DEBUG <> 0 THEN
1471: oe_debug_pub.add ('inventory_unreservation_check: ' || 'Quantity being unreserved ('||p_rsv_quantity||') is okay.',4);

Line 1492: cto_msg_pub.count_and_get(

1488: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1489: 'Raised FND_API.G_EXC_ERROR, stmt'||l_stmt_num);
1490: End if;
1491: x_return_status := FND_API.G_RET_STS_ERROR;
1492: cto_msg_pub.count_and_get(
1493: p_msg_count => x_msg_count,
1494: p_msg_data => x_msg_data
1495: );
1496:

Line 1504: cto_msg_pub.count_and_get(

1500: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1501: 'Raised FND_API.G_EXC_UNEXPECTED_ERROR, stmt'||l_stmt_num);
1502: End if;
1503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1504: cto_msg_pub.count_and_get(
1505: p_msg_count => x_msg_count,
1506: p_msg_data => x_msg_data
1507: );
1508:

Line 1522: cto_msg_pub.count_and_get(

1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1519: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1520: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1521: END IF;
1522: cto_msg_pub.count_and_get(
1523: p_msg_count => x_msg_count,
1524: p_msg_data => x_msg_data
1525: );
1526:

Line 2024: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');

2020:
2021: if PG_DEBUG <> 0 Then
2022: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Raising CTO_ERROR_FROM_DISPLAY_STATUS');
2023: End if;
2024: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');
2025: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2026:
2027: end if;
2028: --end of fix for bug#1895563

Line 2056: cto_msg_pub.count_and_get(

2052: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','exp erro stmt no :'|| to_char(l_stmt_num));
2053:
2054: END IF;
2055: x_return_status := FND_API.G_RET_STS_ERROR;
2056: cto_msg_pub.count_and_get(
2057: p_msg_count => x_msg_count,
2058: p_msg_data => x_msg_data
2059: );
2060:

Line 2069: cto_msg_pub.count_and_get(

2065: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','Unexp err stmt no:'|| to_char(l_stmt_num));
2066:
2067: END IF;
2068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2069: cto_msg_pub.count_and_get(
2070: p_msg_count => x_msg_count,
2071: p_msg_data => x_msg_data
2072: );
2073:

Line 2087: cto_msg_pub.count_and_get(

2083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2084: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2085: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2086: END IF;
2087: cto_msg_pub.count_and_get(
2088: p_msg_count => x_msg_count,
2089: p_msg_data => x_msg_data
2090: );
2091:

Line 3736: cto_msg_pub.count_and_get

3732: || to_char(l_stmt_num), 1);
3733: END IF;
3734: x_return_status := FND_API.G_RET_STS_ERROR;
3735: -- Get message count and data
3736: cto_msg_pub.count_and_get
3737: ( p_msg_count => x_msg_count
3738: , p_msg_data => x_msg_data
3739: );
3740: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3747: cto_msg_pub.count_and_get

3743: || to_char(l_stmt_num), 1);
3744: END IF;
3745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3746: -- Get message count and data
3747: cto_msg_pub.count_and_get
3748: ( p_msg_count => x_msg_count
3749: , p_msg_data => x_msg_data
3750: );
3751: WHEN OTHERS then

Line 3761: cto_msg_pub.count_and_get

3757: || to_char(l_stmt_num), 1);
3758: END IF;
3759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3760: -- Get message count and data
3761: cto_msg_pub.count_and_get
3762: ( p_msg_count => x_msg_count
3763: , p_msg_data => x_msg_data
3764: );
3765: