DBA Data[Home] [Help]

APPS.CTO_WORKFLOW_API_PK dependencies on CTO_MSG_PUB

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

846: end ;
847:
848: exception
849: when DROPSHIP_EXCEPTION then
850: cto_msg_pub.cto_message('BOM', 'CTO_RESERVATION_INELIGIBLE');
851:
852: raise FND_API.G_EXC_ERROR;
853:
854: when others then

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

895: if upper(v_activity_status_code) <> 'NOTIFIED' then
896: If PG_DEBUG <> 0 then
897: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'v_activity_status_code <> NOTIFIED');
898: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
899: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
900: End if;
901: raise FND_API.G_EXC_ERROR;
902: end if;
903: end if;

Line 920: cto_msg_pub.count_and_get(

916: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no :'|| to_char(l_stmt_num));
917: End if;
918:
919: x_return_status := FND_API.G_RET_STS_ERROR;
920: cto_msg_pub.count_and_get(
921: p_msg_count => x_msg_count,
922: p_msg_data => x_msg_data
923: );
924: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 930: cto_msg_pub.count_and_get(

926: 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);
927: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no:'|| to_char(l_stmt_num));
928: End if;
929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
930: cto_msg_pub.count_and_get(
931: p_msg_count => x_msg_count,
932: p_msg_data => x_msg_data
933: );
934:

Line 947: cto_msg_pub.count_and_get(

943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
944: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
945: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
946: END IF;
947: cto_msg_pub.count_and_get(
948: p_msg_count => x_msg_count,
949: p_msg_data => x_msg_data
950: );
951:

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

1191: if return_value <> 1 then
1192: If PG_DEBUG <> 0 Then
1193: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Raising CTO_ERROR_FROM_DISPLAY_STATUS');
1194: End if;
1195: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');
1196: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1197: end if;
1198:
1199:

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

1295: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_reserv', 'v_activity_status_code <> NOTIFIED');
1296: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_reserv', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1297: End if;
1298:
1299: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
1300: raise FND_API.G_EXC_ERROR;
1301: end if;
1302:
1303: END IF; /* end of v_activity_status_code check */

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

1322: IF return_value <> 1 then
1323: IF PG_DEBUG <> 0 Then
1324: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Raising CTO_ERROR_FROM_DISPLAY_STATUS');
1325: End if;
1326: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');
1327: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1328: END IF;
1329:
1330: end if; /* end of item_type_code check */

Line 1351: cto_msg_pub.count_and_get(

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

Line 1365: cto_msg_pub.count_and_get(

1361: stmt no : '||to_char(l_stmt_num)||'::'||sqlerrm);
1362: End if;
1363:
1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1365: cto_msg_pub.count_and_get(
1366: p_msg_count => x_msg_count,
1367: p_msg_data => x_msg_data
1368: );
1369:

Line 1385: cto_msg_pub.count_and_get(

1381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1382: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1383: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1384: END IF;
1385: cto_msg_pub.count_and_get(
1386: p_msg_count => x_msg_count,
1387: p_msg_data => x_msg_data
1388: );
1389:

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

1447: If PG_DEBUG <> 0 Then
1448: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'v_activity_status_code <> NOTIFIED');
1449: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1450: End if;
1451: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
1452: raise FND_API.G_EXC_ERROR;
1453: end if;
1454: end if;
1455:

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

1484: If PG_DEBUG <> 0 Then
1485: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'v_activity_status_code <> NOTIFIED');
1486: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1487: End if;
1488: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
1489: raise FND_API.G_EXC_ERROR;
1490: else
1491: IF PG_DEBUG <> 0 THEN
1492: oe_debug_pub.add ('inventory_unreservation_check: ' || 'Quantity being unreserved ('||p_rsv_quantity||') is okay.',4);

Line 1513: cto_msg_pub.count_and_get(

1509: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1510: 'Raised FND_API.G_EXC_ERROR, stmt'||l_stmt_num);
1511: End if;
1512: x_return_status := FND_API.G_RET_STS_ERROR;
1513: cto_msg_pub.count_and_get(
1514: p_msg_count => x_msg_count,
1515: p_msg_data => x_msg_data
1516: );
1517:

Line 1525: cto_msg_pub.count_and_get(

1521: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1522: 'Raised FND_API.G_EXC_UNEXPECTED_ERROR, stmt'||l_stmt_num);
1523: End if;
1524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1525: cto_msg_pub.count_and_get(
1526: p_msg_count => x_msg_count,
1527: p_msg_data => x_msg_data
1528: );
1529:

Line 1543: cto_msg_pub.count_and_get(

1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1540: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1541: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1542: END IF;
1543: cto_msg_pub.count_and_get(
1544: p_msg_count => x_msg_count,
1545: p_msg_data => x_msg_data
1546: );
1547:

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

2047:
2048: if PG_DEBUG <> 0 Then
2049: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Raising CTO_ERROR_FROM_DISPLAY_STATUS');
2050: End if;
2051: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');
2052: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2053:
2054: end if;
2055: --end of fix for bug#1895563

Line 2083: cto_msg_pub.count_and_get(

2079: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','exp erro stmt no :'|| to_char(l_stmt_num));
2080:
2081: END IF;
2082: x_return_status := FND_API.G_RET_STS_ERROR;
2083: cto_msg_pub.count_and_get(
2084: p_msg_count => x_msg_count,
2085: p_msg_data => x_msg_data
2086: );
2087:

Line 2096: cto_msg_pub.count_and_get(

2092: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','Unexp err stmt no:'|| to_char(l_stmt_num));
2093:
2094: END IF;
2095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2096: cto_msg_pub.count_and_get(
2097: p_msg_count => x_msg_count,
2098: p_msg_data => x_msg_data
2099: );
2100:

Line 2114: cto_msg_pub.count_and_get(

2110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2111: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2112: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2113: END IF;
2114: cto_msg_pub.count_and_get(
2115: p_msg_count => x_msg_count,
2116: p_msg_data => x_msg_data
2117: );
2118:

Line 3768: cto_msg_pub.count_and_get

3764: || to_char(l_stmt_num), 1);
3765: END IF;
3766: x_return_status := FND_API.G_RET_STS_ERROR;
3767: -- Get message count and data
3768: cto_msg_pub.count_and_get
3769: ( p_msg_count => x_msg_count
3770: , p_msg_data => x_msg_data
3771: );
3772: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3779: cto_msg_pub.count_and_get

3775: || to_char(l_stmt_num), 1);
3776: END IF;
3777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3778: -- Get message count and data
3779: cto_msg_pub.count_and_get
3780: ( p_msg_count => x_msg_count
3781: , p_msg_data => x_msg_data
3782: );
3783: WHEN OTHERS then

Line 3793: cto_msg_pub.count_and_get

3789: || to_char(l_stmt_num), 1);
3790: END IF;
3791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3792: -- Get message count and data
3793: cto_msg_pub.count_and_get
3794: ( p_msg_count => x_msg_count
3795: , p_msg_data => x_msg_data
3796: );
3797: