eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_OSP_QUERIES_PVT dependencies on FND_LOG

Line 126: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

122: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Search_OSP_Orders';
123:
124: BEGIN
125:
126: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
127: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
128: END IF;
129:
130: IF G_DEBUG='Y' THEN

Line 127: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');

123:
124: BEGIN
125:
126: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
127: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
128: END IF;
129:
130: IF G_DEBUG='Y' THEN
131: AHL_DEBUG_PUB.enable_debug;

Line 357: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

353: IF G_DEBUG='Y' THEN
354: AHL_DEBUG_PUB.debug(' x_results_count:-' || x_results_count);
355: END IF;
356:
357: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
358: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'End Procedure');
359: END IF;
360: */
361: EXCEPTION

Line 358: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'End Procedure');

354: AHL_DEBUG_PUB.debug(' x_results_count:-' || x_results_count);
355: END IF;
356:
357: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
358: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'End Procedure');
359: END IF;
360: */
361: EXCEPTION
362: WHEN FND_API.G_EXC_ERROR THEN

Line 370: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

366: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
367: p_data => x_msg_data,
368: p_encoded => fnd_api.g_false);
369:
370: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
371: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Exception: ' || x_msg_data);
372: END IF;
373:
374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 371: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Exception: ' || x_msg_data);

367: p_data => x_msg_data,
368: p_encoded => fnd_api.g_false);
369:
370: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
371: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Exception: ' || x_msg_data);
372: END IF;
373:
374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
375: -- dbms_output.put_line('Excep 2 ');

Line 380: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
378: p_data => x_msg_data,
379: p_encoded => fnd_api.g_false);
380: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
381: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
382: END IF;
383:
384: WHEN OTHERS THEN

Line 381: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);

377: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
378: p_data => x_msg_data,
379: p_encoded => fnd_api.g_false);
380: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
381: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
382: END IF;
383:
384: WHEN OTHERS THEN
385: -- dbms_output.put_line('Excep 3 ');

Line 396: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

392: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
393: p_data => x_msg_data,
394: p_encoded => fnd_api.g_false);
395:
396: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
397: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
398: END IF;
399:
400:

Line 397: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);

393: p_data => x_msg_data,
394: p_encoded => fnd_api.g_false);
395:
396: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
397: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
398: END IF;
399:
400:
401:

Line 499: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

495:
496: BEGIN
497:
498:
499: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
500: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
501: END IF;
502:
503: IF G_DEBUG='Y' THEN

Line 500: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');

496: BEGIN
497:
498:
499: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
500: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
501: END IF;
502:
503: IF G_DEBUG='Y' THEN
504: AHL_DEBUG_PUB.enable_debug;

Line 667: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

663: END IF;
664:
665:
666:
667: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
668: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'End Procedure');
669: END IF;
670: */
671: EXCEPTION

Line 668: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'End Procedure');

664:
665:
666:
667: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
668: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'End Procedure');
669: END IF;
670: */
671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN

Line 680: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

676: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
677: p_data => x_msg_data,
678: p_encoded => fnd_api.g_false);
679:
680: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
681: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Exception: ' || x_msg_data);
682: END IF;
683:
684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 681: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Exception: ' || x_msg_data);

677: p_data => x_msg_data,
678: p_encoded => fnd_api.g_false);
679:
680: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
681: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Exception: ' || x_msg_data);
682: END IF;
683:
684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: -- dbms_output.put_line('Excep 2 ');

Line 693: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

689: p_data => x_msg_data,
690: p_encoded => fnd_api.g_false);
691:
692:
693: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
694: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
695: END IF;
696:
697: WHEN OTHERS THEN

Line 694: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);

690: p_encoded => fnd_api.g_false);
691:
692:
693: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
694: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
695: END IF;
696:
697: WHEN OTHERS THEN
698: -- dbms_output.put_line('Excep 3 ');

Line 709: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

705: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
706: p_data => x_msg_data,
707: p_encoded => fnd_api.g_false);
708:
709: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
710: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
711: END IF;
712:
713: END Search_WO;

Line 710: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);

706: p_data => x_msg_data,
707: p_encoded => fnd_api.g_false);
708:
709: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
710: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
711: END IF;
712:
713: END Search_WO;
714:

Line 831: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

827:
828:
829: BEGIN
830:
831: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
832: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
833: END IF;
834: -- Standard call to check for call compatibility
835: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

Line 832: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');

828:
829: BEGIN
830:
831: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
832: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
833: END IF;
834: -- Standard call to check for call compatibility
835: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
836: G_PKG_NAME) THEN

Line 1057: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1053: p_data => x_msg_data,
1054: p_encoded => fnd_api.g_false
1055: );
1056:
1057: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1058: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'End Procedure');
1059: END IF;
1060:
1061: EXCEPTION

Line 1058: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'End Procedure');

1054: p_encoded => fnd_api.g_false
1055: );
1056:
1057: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1058: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'End Procedure');
1059: END IF;
1060:
1061: EXCEPTION
1062: WHEN FND_API.G_EXC_ERROR THEN

Line 1069: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1065: --Rollback to get_header_lines_pvt;
1066: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1067: p_data => x_msg_data,
1068: p_encoded => fnd_api.g_false);
1069: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1070: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Exception: ' || x_msg_data);
1071: END IF;
1072:
1073:

Line 1070: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Exception: ' || x_msg_data);

1066: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1067: p_data => x_msg_data,
1068: p_encoded => fnd_api.g_false);
1069: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1070: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Exception: ' || x_msg_data);
1071: END IF;
1072:
1073:
1074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1081: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1077: -- Rollback to get_header_lines_pvt;
1078: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1079: p_data => x_msg_data,
1080: p_encoded => fnd_api.g_false);
1081: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1082: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
1083: END IF;
1084:
1085: WHEN OTHERS THEN

Line 1082: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);

1078: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1079: p_data => x_msg_data,
1080: p_encoded => fnd_api.g_false);
1081: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1082: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
1083: END IF;
1084:
1085: WHEN OTHERS THEN
1086: --dbms_output.put_line('Excep 3 ');

Line 1096: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1092:
1093: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1094: p_data => x_msg_data,
1095: p_encoded => fnd_api.g_false);
1096: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1097: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
1098: END IF;
1099: END Get_Header_And_Lines;
1100:

Line 1097: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);

1093: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1094: p_data => x_msg_data,
1095: p_encoded => fnd_api.g_false);
1096: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1097: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
1098: END IF;
1099: END Get_Header_And_Lines;
1100:
1101:

Line 1202: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1198: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.GET_ORDER_LINES';
1199:
1200: BEGIN
1201:
1202: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1203: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
1204: END IF;
1205: IF G_DEBUG='Y' THEN
1206: AHL_DEBUG_PUB.enable_debug;

Line 1203: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');

1199:
1200: BEGIN
1201:
1202: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1203: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
1204: END IF;
1205: IF G_DEBUG='Y' THEN
1206: AHL_DEBUG_PUB.enable_debug;
1207: END IF;

Line 1447: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1443: END LOOP; -- END LOOP FOR L_LINE_CSR
1444:
1445: END IF;
1446:
1447: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1448: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'End Procedure');
1449: END IF;
1450:
1451: EXCEPTION

Line 1448: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'End Procedure');

1444:
1445: END IF;
1446:
1447: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1448: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'End Procedure');
1449: END IF;
1450:
1451: EXCEPTION
1452: WHEN FND_API.G_EXC_ERROR THEN

Line 1459: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1455: --Rollback to get_order_lines_pvt;
1456: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1457: p_data => x_msg_data,
1458: p_encoded => fnd_api.g_false);
1459: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1460: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Exception: ' || x_msg_data);
1461: END IF;
1462:
1463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1460: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Exception: ' || x_msg_data);

1456: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1457: p_data => x_msg_data,
1458: p_encoded => fnd_api.g_false);
1459: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1460: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_DEBUG_KEY, 'Execution Exception: ' || x_msg_data);
1461: END IF;
1462:
1463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1464: --dbms_output.put_line('Excep 2 ');

Line 1470: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1466: --Rollback to get_order_lines_pvt;
1467: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1468: p_data => x_msg_data,
1469: p_encoded => fnd_api.g_false);
1470: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1471: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
1472: END IF;
1473:
1474: WHEN OTHERS THEN

Line 1471: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);

1467: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1468: p_data => x_msg_data,
1469: p_encoded => fnd_api.g_false);
1470: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1471: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
1472: END IF;
1473:
1474: WHEN OTHERS THEN
1475: --dbms_output.put_line('Excep 3 ');

Line 1485: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1481:
1482: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1483: p_data => x_msg_data,
1484: p_encoded => fnd_api.g_false);
1485: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1486: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
1487: END IF;
1488:
1489:

Line 1486: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);

1482: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1483: p_data => x_msg_data,
1484: p_encoded => fnd_api.g_false);
1485: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1486: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Unexpected Exception: ' || x_msg_data);
1487: END IF;
1488:
1489:
1490:

Line 1585: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

1581: l_quant_notshippedout NUMBER;
1582:
1583: BEGIN
1584:
1585: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1586: fnd_log.string(fnd_log.level_procedure, l_debug_key || '.begin:', 'Entered Get_Onhand_Quantity Function');
1587: END IF;
1588:
1589: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 1586: fnd_log.string(fnd_log.level_procedure, l_debug_key || '.begin:', 'Entered Get_Onhand_Quantity Function');

1582:
1583: BEGIN
1584:
1585: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1586: fnd_log.string(fnd_log.level_procedure, l_debug_key || '.begin:', 'Entered Get_Onhand_Quantity Function');
1587: END IF;
1588:
1589: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1590: fnd_log.string

Line 1589: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1585: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1586: fnd_log.string(fnd_log.level_procedure, l_debug_key || '.begin:', 'Entered Get_Onhand_Quantity Function');
1587: END IF;
1588:
1589: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1590: fnd_log.string
1591: (
1592: fnd_log.level_statement, l_debug_key|| ':',
1593: 'p_org_id: '|| p_org_id ||

Line 1590: fnd_log.string

1586: fnd_log.string(fnd_log.level_procedure, l_debug_key || '.begin:', 'Entered Get_Onhand_Quantity Function');
1587: END IF;
1588:
1589: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1590: fnd_log.string
1591: (
1592: fnd_log.level_statement, l_debug_key|| ':',
1593: 'p_org_id: '|| p_org_id ||
1594: 'and p_subinventory_code :' || p_subinventory_code ||

Line 1592: fnd_log.level_statement, l_debug_key|| ':',

1588:
1589: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1590: fnd_log.string
1591: (
1592: fnd_log.level_statement, l_debug_key|| ':',
1593: 'p_org_id: '|| p_org_id ||
1594: 'and p_subinventory_code :' || p_subinventory_code ||
1595: 'and p_inventory_item_id :' || p_inventory_item_id ||
1596: --Added by mpothuku on 23rd Aug, 06 to fix the Bug 5252627

Line 1608: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1604: subinventory_code = p_subinventory_code and
1605: --Added by mpothuku on 23rd Aug, 06 to fix the Bug 5252627
1606: (p_lot_number is null or lot_number = p_lot_number);
1607:
1608: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1609: fnd_log.string(fnd_log.level_statement, l_debug_key|| ':', 'l_apparent_quantity : '|| l_apparent_quantity);
1610: END IF;
1611:
1612: --Gives the quantity of the items without ship lines reserved by osp

Line 1609: fnd_log.string(fnd_log.level_statement, l_debug_key|| ':', 'l_apparent_quantity : '|| l_apparent_quantity);

1605: --Added by mpothuku on 23rd Aug, 06 to fix the Bug 5252627
1606: (p_lot_number is null or lot_number = p_lot_number);
1607:
1608: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1609: fnd_log.string(fnd_log.level_statement, l_debug_key|| ':', 'l_apparent_quantity : '|| l_apparent_quantity);
1610: END IF;
1611:
1612: --Gives the quantity of the items without ship lines reserved by osp
1613: /***** For Bug 5673279,

Line 1637: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1633: ospl.sub_inventory = p_subinventory_code and
1634: --Added by mpothuku on 23rd Aug, 06 to fix the Bug 5252627
1635: (p_lot_number is null or ospl.lot_number = p_lot_number);
1636:
1637: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1638: fnd_log.string(fnd_log.level_statement, l_debug_key ||':', 'l_quant_withoutship : '|| l_quant_withoutship);
1639: END IF;
1640: */
1641:

Line 1638: fnd_log.string(fnd_log.level_statement, l_debug_key ||':', 'l_quant_withoutship : '|| l_quant_withoutship);

1634: --Added by mpothuku on 23rd Aug, 06 to fix the Bug 5252627
1635: (p_lot_number is null or ospl.lot_number = p_lot_number);
1636:
1637: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1638: fnd_log.string(fnd_log.level_statement, l_debug_key ||':', 'l_quant_withoutship : '|| l_quant_withoutship);
1639: END IF;
1640: */
1641:
1642: --Gives the quantity of the items that have ship lines, but whose shipments are not booked.

Line 1683: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1679: (p_lot_number is null or ospl.lot_number = p_lot_number) and
1680: not exists
1681: (select 1 from wsh_delivery_details where SOURCE_CODE = 'OE' and SOURCE_LINE_ID = OSPL.oe_ship_line_id);
1682:
1683: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1684: fnd_log.string(fnd_log.level_statement, l_debug_key||':','l_quant_ship_notbooked:'|| l_quant_ship_notbooked);
1685: END IF;
1686:
1687: --Gives the quantity of the items that have ship lines, and whose shipments are in those phases, where

Line 1684: fnd_log.string(fnd_log.level_statement, l_debug_key||':','l_quant_ship_notbooked:'|| l_quant_ship_notbooked);

1680: not exists
1681: (select 1 from wsh_delivery_details where SOURCE_CODE = 'OE' and SOURCE_LINE_ID = OSPL.oe_ship_line_id);
1682:
1683: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1684: fnd_log.string(fnd_log.level_statement, l_debug_key||':','l_quant_ship_notbooked:'|| l_quant_ship_notbooked);
1685: END IF;
1686:
1687: --Gives the quantity of the items that have ship lines, and whose shipments are in those phases, where
1688: --the quantity is not reduced from the inventory yet, but nonetheless reserved.

Line 1703: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1699: released_status in ('R','S','Y','C','B') and
1700: --Added by mpothuku on 17th May, 06 to fix the Bug 5231358
1701: (p_lot_number is null or lot_number = p_lot_number);
1702:
1703: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1704: fnd_log.string(fnd_log.level_statement, l_debug_key||':','l_quant_notshippedout : '|| l_quant_notshippedout);
1705: END IF;
1706:
1707:

Line 1704: fnd_log.string(fnd_log.level_statement, l_debug_key||':','l_quant_notshippedout : '|| l_quant_notshippedout);

1700: --Added by mpothuku on 17th May, 06 to fix the Bug 5231358
1701: (p_lot_number is null or lot_number = p_lot_number);
1702:
1703: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1704: fnd_log.string(fnd_log.level_statement, l_debug_key||':','l_quant_notshippedout : '|| l_quant_notshippedout);
1705: END IF;
1706:
1707:
1708: l_onhand_quantity := l_apparent_quantity - (l_quant_ship_notbooked + l_quant_notshippedout);

Line 1710: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1706:
1707:
1708: l_onhand_quantity := l_apparent_quantity - (l_quant_ship_notbooked + l_quant_notshippedout);
1709:
1710: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1711: fnd_log.string(fnd_log.level_statement, l_debug_key||':' , 'l_onhand_quantity : '|| l_onhand_quantity);
1712: END IF;
1713:
1714: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 1711: fnd_log.string(fnd_log.level_statement, l_debug_key||':' , 'l_onhand_quantity : '|| l_onhand_quantity);

1707:
1708: l_onhand_quantity := l_apparent_quantity - (l_quant_ship_notbooked + l_quant_notshippedout);
1709:
1710: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1711: fnd_log.string(fnd_log.level_statement, l_debug_key||':' , 'l_onhand_quantity : '|| l_onhand_quantity);
1712: END IF;
1713:
1714: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1715: fnd_log.string(fnd_log.level_procedure, l_debug_key||'.end','End Get_Onhand_Quantity Function');

Line 1714: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

1710: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1711: fnd_log.string(fnd_log.level_statement, l_debug_key||':' , 'l_onhand_quantity : '|| l_onhand_quantity);
1712: END IF;
1713:
1714: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1715: fnd_log.string(fnd_log.level_procedure, l_debug_key||'.end','End Get_Onhand_Quantity Function');
1716: END IF;
1717:
1718: return l_onhand_quantity;

Line 1715: fnd_log.string(fnd_log.level_procedure, l_debug_key||'.end','End Get_Onhand_Quantity Function');

1711: fnd_log.string(fnd_log.level_statement, l_debug_key||':' , 'l_onhand_quantity : '|| l_onhand_quantity);
1712: END IF;
1713:
1714: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1715: fnd_log.string(fnd_log.level_procedure, l_debug_key||'.end','End Get_Onhand_Quantity Function');
1716: END IF;
1717:
1718: return l_onhand_quantity;
1719:

Line 1780: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1776: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Get_Suggested_Vendor';
1777:
1778: BEGIN
1779:
1780: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Function');
1782: END IF;
1783:
1784: l_org_id := FND_PROFILE.VALUE('ORG_ID');

Line 1781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Function');

1777:
1778: BEGIN
1779:
1780: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Function');
1782: END IF;
1783:
1784: l_org_id := FND_PROFILE.VALUE('ORG_ID');
1785: IF (p_work_order_id IS NOT NULL) THEN