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.QA_TXN_GRP dependencies on FND_LOG

Line 611: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

607: EXECUTE IMMEDIATE l_insert_columns || l_insert_values
608: USING p_plan_id, p_org_id, p_collection_id, uid, uid, uid, uid;
609: EXCEPTION WHEN OTHERS THEN
610:
611: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
612: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
613: 'QA_TXN_GRP.INSERT_RESULTS.err', l_insert_columns || l_insert_values );
614: end if;
615:

Line 612: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

608: USING p_plan_id, p_org_id, p_collection_id, uid, uid, uid, uid;
609: EXCEPTION WHEN OTHERS THEN
610:
611: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
612: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
613: 'QA_TXN_GRP.INSERT_RESULTS.err', l_insert_columns || l_insert_values );
614: end if;
615:
616: END insert_results;

Line 1135: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

1131: )
1132: IS
1133: l_api_name CONSTANT VARCHAR2(30) := 'GET_CHILD_PLANS';
1134: BEGIN
1135: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1136: FND_LOG.string
1137: (
1138: FND_LOG.level_statement,
1139: g_pkg_name || '.' || l_api_name,

Line 1136: FND_LOG.string

1132: IS
1133: l_api_name CONSTANT VARCHAR2(30) := 'GET_CHILD_PLANS';
1134: BEGIN
1135: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1136: FND_LOG.string
1137: (
1138: FND_LOG.level_statement,
1139: g_pkg_name || '.' || l_api_name,
1140: 'BEFORE GETTING PC CRITERIA VALUES'

Line 1138: FND_LOG.level_statement,

1134: BEGIN
1135: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1136: FND_LOG.string
1137: (
1138: FND_LOG.level_statement,
1139: g_pkg_name || '.' || l_api_name,
1140: 'BEFORE GETTING PC CRITERIA VALUES'
1141: );
1142: END IF;

Line 1153: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

1149: p_organization_id => p_org_id,
1150: x_criteria_values => x_criteria_values
1151: );
1152:
1153: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1154: FND_LOG.string
1155: (
1156: FND_LOG.level_statement,
1157: g_pkg_name || '.' || l_api_name,

Line 1154: FND_LOG.string

1150: x_criteria_values => x_criteria_values
1151: );
1152:
1153: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1154: FND_LOG.string
1155: (
1156: FND_LOG.level_statement,
1157: g_pkg_name || '.' || l_api_name,
1158: 'BEFORE EVALUATING PC CRITERIA'

Line 1156: FND_LOG.level_statement,

1152:
1153: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1154: FND_LOG.string
1155: (
1156: FND_LOG.level_statement,
1157: g_pkg_name || '.' || l_api_name,
1158: 'BEFORE EVALUATING PC CRITERIA'
1159: );
1160: END IF;

Line 1279: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

1275: l_occurrences number_tab;
1276:
1277: BEGIN
1278:
1279: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1280: FND_LOG.string
1281: (
1282: FND_LOG.level_procedure,
1283: g_pkg_name || '.' || l_api_name,

Line 1280: FND_LOG.string

1276:
1277: BEGIN
1278:
1279: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1280: FND_LOG.string
1281: (
1282: FND_LOG.level_procedure,
1283: g_pkg_name || '.' || l_api_name,
1284: 'ENTERING PROCEDURE: p_txn_number: ' || p_txn_number || ' p_org_id: ' || p_org_id || ' p_txn_header_id: ' || p_txn_header_id || ' p_collection_id: ' || p_collection_id || ' p_plan_txn_ids: ' || p_plan_txn_ids

Line 1282: FND_LOG.level_procedure,

1278:
1279: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1280: FND_LOG.string
1281: (
1282: FND_LOG.level_procedure,
1283: g_pkg_name || '.' || l_api_name,
1284: 'ENTERING PROCEDURE: p_txn_number: ' || p_txn_number || ' p_org_id: ' || p_org_id || ' p_txn_header_id: ' || p_txn_header_id || ' p_collection_id: ' || p_collection_id || ' p_plan_txn_ids: ' || p_plan_txn_ids
1285: );
1286: END IF;

Line 1288: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

1284: 'ENTERING PROCEDURE: p_txn_number: ' || p_txn_number || ' p_org_id: ' || p_org_id || ' p_txn_header_id: ' || p_txn_header_id || ' p_collection_id: ' || p_collection_id || ' p_plan_txn_ids: ' || p_plan_txn_ids
1285: );
1286: END IF;
1287:
1288: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1289: FND_LOG.string
1290: (
1291: FND_LOG.level_statement,
1292: g_pkg_name || '.' || l_api_name,

Line 1289: FND_LOG.string

1285: );
1286: END IF;
1287:
1288: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1289: FND_LOG.string
1290: (
1291: FND_LOG.level_statement,
1292: g_pkg_name || '.' || l_api_name,
1293: 'BEFORE CHECKING MANDATORY COLLECTION'

Line 1291: FND_LOG.level_statement,

1287:
1288: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1289: FND_LOG.string
1290: (
1291: FND_LOG.level_statement,
1292: g_pkg_name || '.' || l_api_name,
1293: 'BEFORE CHECKING MANDATORY COLLECTION'
1294: );
1295: END IF;

Line 1332: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

1328: p_prefix => l_prefix1 || l_prefix2,
1329: p_suffix => NULL
1330: );
1331:
1332: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1333: FND_LOG.string
1334: (
1335: FND_LOG.level_procedure,
1336: g_pkg_name || '.' || l_api_name,

Line 1333: FND_LOG.string

1329: p_suffix => NULL
1330: );
1331:
1332: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1333: FND_LOG.string
1334: (
1335: FND_LOG.level_procedure,
1336: g_pkg_name || '.' || l_api_name,
1337: 'EXITING PROCEDURE: INCOMPLETE PLANS - IDS: ' || l_plan_ids || ' NAMES: ' || x_plan_names

Line 1335: FND_LOG.level_procedure,

1331:
1332: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1333: FND_LOG.string
1334: (
1335: FND_LOG.level_procedure,
1336: g_pkg_name || '.' || l_api_name,
1337: 'EXITING PROCEDURE: INCOMPLETE PLANS - IDS: ' || l_plan_ids || ' NAMES: ' || x_plan_names
1338: );
1339: END IF;

Line 1346: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

1342: END IF;
1343:
1344: l_plan_ids := '';
1345:
1346: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1347: FND_LOG.string
1348: (
1349: FND_LOG.level_statement,
1350: g_pkg_name || '.' || l_api_name,

Line 1347: FND_LOG.string

1343:
1344: l_plan_ids := '';
1345:
1346: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1347: FND_LOG.string
1348: (
1349: FND_LOG.level_statement,
1350: g_pkg_name || '.' || l_api_name,
1351: 'BEFORE VALIDATING IMMEDIATE CHILD COLLECTION'

Line 1349: FND_LOG.level_statement,

1345:
1346: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1347: FND_LOG.string
1348: (
1349: FND_LOG.level_statement,
1350: g_pkg_name || '.' || l_api_name,
1351: 'BEFORE VALIDATING IMMEDIATE CHILD COLLECTION'
1352: );
1353: END IF;

Line 1379: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

1375: IF l_plans.FIRST IS NOT NULL THEN
1376:
1377: FOR i IN l_plans.FIRST .. l_plans.LAST LOOP
1378:
1379: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1380: FND_LOG.string
1381: (
1382: FND_LOG.level_statement,
1383: g_pkg_name || '.' || l_api_name,

Line 1380: FND_LOG.string

1376:
1377: FOR i IN l_plans.FIRST .. l_plans.LAST LOOP
1378:
1379: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1380: FND_LOG.string
1381: (
1382: FND_LOG.level_statement,
1383: g_pkg_name || '.' || l_api_name,
1384: 'BEFORE GETTING CHILD PLANS FOR PLAN_ID: ' || l_plans(i) || ' OCCURRENCE: ' || l_occurrences(i)

Line 1382: FND_LOG.level_statement,

1378:
1379: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1380: FND_LOG.string
1381: (
1382: FND_LOG.level_statement,
1383: g_pkg_name || '.' || l_api_name,
1384: 'BEFORE GETTING CHILD PLANS FOR PLAN_ID: ' || l_plans(i) || ' OCCURRENCE: ' || l_occurrences(i)
1385: );
1386: END IF;

Line 1408: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

1404: );
1405:
1406: IF( l_return_status = 'T' ) THEN
1407:
1408: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1409: FND_LOG.string
1410: (
1411: FND_LOG.level_statement,
1412: g_pkg_name || '.' || l_api_name,

Line 1409: FND_LOG.string

1405:
1406: IF( l_return_status = 'T' ) THEN
1407:
1408: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1409: FND_LOG.string
1410: (
1411: FND_LOG.level_statement,
1412: g_pkg_name || '.' || l_api_name,
1413: 'BEFORE CHECKING IF COMMIT IS ALLOWED FOR IMMEDIATE CHILDREN: ' || l_child_plan_ids

Line 1411: FND_LOG.level_statement,

1407:
1408: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1409: FND_LOG.string
1410: (
1411: FND_LOG.level_statement,
1412: g_pkg_name || '.' || l_api_name,
1413: 'BEFORE CHECKING IF COMMIT IS ALLOWED FOR IMMEDIATE CHILDREN: ' || l_child_plan_ids
1414: );
1415: END IF;

Line 1433: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

1429: );
1430:
1431: IF ( l_return_status <> 'T' ) THEN
1432:
1433: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1434: FND_LOG.string
1435: (
1436: FND_LOG.level_statement,
1437: g_pkg_name || '.' || l_api_name,

Line 1434: FND_LOG.string

1430:
1431: IF ( l_return_status <> 'T' ) THEN
1432:
1433: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1434: FND_LOG.string
1435: (
1436: FND_LOG.level_statement,
1437: g_pkg_name || '.' || l_api_name,
1438: 'ALL CHILD RESULTS ARE NOT CAPTURED FOR PLAN: ' || l_plans(i)

Line 1436: FND_LOG.level_statement,

1432:
1433: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1434: FND_LOG.string
1435: (
1436: FND_LOG.level_statement,
1437: g_pkg_name || '.' || l_api_name,
1438: 'ALL CHILD RESULTS ARE NOT CAPTURED FOR PLAN: ' || l_plans(i)
1439: );
1440: END IF;

Line 1473: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

1469: -- Bug 5161719. SHKALYAN 13-Apr-2006
1470: -- Remove the leading comma
1471: x_plan_names := SUBSTR( x_plan_names , LENGTH(l_separator) + 1 );
1472:
1473: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1474: FND_LOG.string
1475: (
1476: FND_LOG.level_procedure,
1477: g_pkg_name || '.' || l_api_name,

Line 1474: FND_LOG.string

1470: -- Remove the leading comma
1471: x_plan_names := SUBSTR( x_plan_names , LENGTH(l_separator) + 1 );
1472:
1473: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1474: FND_LOG.string
1475: (
1476: FND_LOG.level_procedure,
1477: g_pkg_name || '.' || l_api_name,
1478: 'EXITING PROCEDURE: INCOMPLETE PLANS : ' || x_plan_names

Line 1476: FND_LOG.level_procedure,

1472:
1473: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1474: FND_LOG.string
1475: (
1476: FND_LOG.level_procedure,
1477: g_pkg_name || '.' || l_api_name,
1478: 'EXITING PROCEDURE: INCOMPLETE PLANS : ' || x_plan_names
1479: );
1480: END IF;

Line 1485: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

1481:
1482: return 'F';
1483: END IF;
1484:
1485: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1486: FND_LOG.string
1487: (
1488: FND_LOG.level_procedure,
1489: g_pkg_name || '.' || l_api_name,

Line 1486: FND_LOG.string

1482: return 'F';
1483: END IF;
1484:
1485: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1486: FND_LOG.string
1487: (
1488: FND_LOG.level_procedure,
1489: g_pkg_name || '.' || l_api_name,
1490: 'EXITING PROCEDURE: COMMIT IS ALLOWED'

Line 1488: FND_LOG.level_procedure,

1484:
1485: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1486: FND_LOG.string
1487: (
1488: FND_LOG.level_procedure,
1489: g_pkg_name || '.' || l_api_name,
1490: 'EXITING PROCEDURE: COMMIT IS ALLOWED'
1491: );
1492: END IF;

Line 1539: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

1535: BEGIN
1536:
1537: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
1538:
1539: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1540: FND_LOG.string
1541: (
1542: FND_LOG.level_procedure,
1543: g_pkg_name || '.' || l_api_name,

Line 1540: FND_LOG.string

1536:
1537: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
1538:
1539: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1540: FND_LOG.string
1541: (
1542: FND_LOG.level_procedure,
1543: g_pkg_name || '.' || l_api_name,
1544: 'ENTERING PROCEDURE: p_txn_number: ' || p_txn_number || ' p_org_id: ' || p_org_id || ' p_txn_header_id: ' || p_txn_header_id ||

Line 1542: FND_LOG.level_procedure,

1538:
1539: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1540: FND_LOG.string
1541: (
1542: FND_LOG.level_procedure,
1543: g_pkg_name || '.' || l_api_name,
1544: 'ENTERING PROCEDURE: p_txn_number: ' || p_txn_number || ' p_org_id: ' || p_org_id || ' p_txn_header_id: ' || p_txn_header_id ||
1545: ' p_collection_id: ' || p_collection_id || ' p_plan_txn_ids: ' || p_plan_txn_ids || ' p_context_values: ' || p_context_values || ' p_context_ids: ' || p_context_ids
1546: );

Line 1571: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

1567:
1568: -- Initialize API return status to success
1569: x_return_status := FND_API.G_RET_STS_SUCCESS;
1570:
1571: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1572: FND_LOG.string
1573: (
1574: FND_LOG.level_statement,
1575: g_pkg_name || '.' || l_api_name,

Line 1572: FND_LOG.string

1568: -- Initialize API return status to success
1569: x_return_status := FND_API.G_RET_STS_SUCCESS;
1570:
1571: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1572: FND_LOG.string
1573: (
1574: FND_LOG.level_statement,
1575: g_pkg_name || '.' || l_api_name,
1576: 'BEFORE POSTING BACKGROUND RESULTS'

Line 1574: FND_LOG.level_statement,

1570:
1571: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1572: FND_LOG.string
1573: (
1574: FND_LOG.level_statement,
1575: g_pkg_name || '.' || l_api_name,
1576: 'BEFORE POSTING BACKGROUND RESULTS'
1577: );
1578: END IF;

Line 1609: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

1605: IF l_plan_ids.FIRST IS NOT NULL THEN
1606:
1607: FOR i IN l_plan_ids.FIRST .. l_plan_ids.LAST LOOP
1608:
1609: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1610: FND_LOG.string
1611: (
1612: FND_LOG.level_statement,
1613: g_pkg_name || '.' || l_api_name,

Line 1610: FND_LOG.string

1606:
1607: FOR i IN l_plan_ids.FIRST .. l_plan_ids.LAST LOOP
1608:
1609: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1610: FND_LOG.string
1611: (
1612: FND_LOG.level_statement,
1613: g_pkg_name || '.' || l_api_name,
1614: 'BEFORE INSERTING AUTOMATIC RECORDS FOR PLAN_ID: ' || l_plan_ids(i) || ' OCCURRENCE: ' || l_occurrences(i)

Line 1612: FND_LOG.level_statement,

1608:
1609: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1610: FND_LOG.string
1611: (
1612: FND_LOG.level_statement,
1613: g_pkg_name || '.' || l_api_name,
1614: 'BEFORE INSERTING AUTOMATIC RECORDS FOR PLAN_ID: ' || l_plan_ids(i) || ' OCCURRENCE: ' || l_occurrences(i)
1615: );
1616: END IF;

Line 1630: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

1626: p_data_entry_mode => 2, -- Automatic
1627: p_txn_header_id => p_txn_header_id
1628: );
1629:
1630: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1631: FND_LOG.string
1632: (
1633: FND_LOG.level_statement,
1634: g_pkg_name || '.' || l_api_name,

Line 1631: FND_LOG.string

1627: p_txn_header_id => p_txn_header_id
1628: );
1629:
1630: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1631: FND_LOG.string
1632: (
1633: FND_LOG.level_statement,
1634: g_pkg_name || '.' || l_api_name,
1635: 'BEFORE INSERTING HISTORY RECORDS FOR PLAN_ID: ' || l_plan_ids(i) || ' OCCURRENCE: ' || l_occurrences(i)

Line 1633: FND_LOG.level_statement,

1629:
1630: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1631: FND_LOG.string
1632: (
1633: FND_LOG.level_statement,
1634: g_pkg_name || '.' || l_api_name,
1635: 'BEFORE INSERTING HISTORY RECORDS FOR PLAN_ID: ' || l_plan_ids(i) || ' OCCURRENCE: ' || l_occurrences(i)
1636: );
1637: END IF;

Line 1654: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

1650:
1651: END LOOP;
1652: END IF; -- l_plan_ids.FIRST is not null
1653:
1654: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1655: FND_LOG.string
1656: (
1657: FND_LOG.level_statement,
1658: g_pkg_name || '.' || l_api_name,

Line 1655: FND_LOG.string

1651: END LOOP;
1652: END IF; -- l_plan_ids.FIRST is not null
1653:
1654: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1655: FND_LOG.string
1656: (
1657: FND_LOG.level_statement,
1658: g_pkg_name || '.' || l_api_name,
1659: 'BEFORE ENABLING QA RESULTS'

Line 1657: FND_LOG.level_statement,

1653:
1654: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1655: FND_LOG.string
1656: (
1657: FND_LOG.level_statement,
1658: g_pkg_name || '.' || l_api_name,
1659: 'BEFORE ENABLING QA RESULTS'
1660: );
1661: END IF;

Line 1668: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

1664: UPDATE qa_results
1665: SET status = 2
1666: WHERE collection_id = p_collection_id;
1667:
1668: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1669: FND_LOG.string
1670: (
1671: FND_LOG.level_statement,
1672: g_pkg_name || '.' || l_api_name,

Line 1669: FND_LOG.string

1665: SET status = 2
1666: WHERE collection_id = p_collection_id;
1667:
1668: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1669: FND_LOG.string
1670: (
1671: FND_LOG.level_statement,
1672: g_pkg_name || '.' || l_api_name,
1673: 'BEFORE GENERATING SEQUENCES'

Line 1671: FND_LOG.level_statement,

1667:
1668: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1669: FND_LOG.string
1670: (
1671: FND_LOG.level_statement,
1672: g_pkg_name || '.' || l_api_name,
1673: 'BEFORE GENERATING SEQUENCES'
1674: );
1675: END IF;

Line 1688: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

1684: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1686: END IF;
1687:
1688: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1689: FND_LOG.string
1690: (
1691: FND_LOG.level_statement,
1692: g_pkg_name || '.' || l_api_name,

Line 1689: FND_LOG.string

1685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1686: END IF;
1687:
1688: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1689: FND_LOG.string
1690: (
1691: FND_LOG.level_statement,
1692: g_pkg_name || '.' || l_api_name,
1693: 'BEFORE FIRING BACKGROUND ACTIONS'

Line 1691: FND_LOG.level_statement,

1687:
1688: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1689: FND_LOG.string
1690: (
1691: FND_LOG.level_statement,
1692: g_pkg_name || '.' || l_api_name,
1693: 'BEFORE FIRING BACKGROUND ACTIONS'
1694: );
1695: END IF;

Line 1726: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

1722: p_count => x_msg_count,
1723: p_data => x_msg_data
1724: );
1725:
1726: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1727: FND_LOG.string
1728: (
1729: FND_LOG.level_procedure,
1730: g_pkg_name || '.' || l_api_name,

Line 1727: FND_LOG.string

1723: p_data => x_msg_data
1724: );
1725:
1726: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1727: FND_LOG.string
1728: (
1729: FND_LOG.level_procedure,
1730: g_pkg_name || '.' || l_api_name,
1731: 'EXITING PROCEDURE: SUCCESS'

Line 1729: FND_LOG.level_procedure,

1725:
1726: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1727: FND_LOG.string
1728: (
1729: FND_LOG.level_procedure,
1730: g_pkg_name || '.' || l_api_name,
1731: 'EXITING PROCEDURE: SUCCESS'
1732: );
1733: END IF;

Line 1746: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

1742: p_count => x_msg_count,
1743: p_data => x_msg_data
1744: );
1745:
1746: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1747: FND_LOG.string
1748: (
1749: FND_LOG.level_procedure,
1750: g_pkg_name || '.' || l_api_name,

Line 1747: FND_LOG.string

1743: p_data => x_msg_data
1744: );
1745:
1746: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1747: FND_LOG.string
1748: (
1749: FND_LOG.level_procedure,
1750: g_pkg_name || '.' || l_api_name,
1751: 'EXITING PROCEDURE: ERROR'

Line 1749: FND_LOG.level_procedure,

1745:
1746: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1747: FND_LOG.string
1748: (
1749: FND_LOG.level_procedure,
1750: g_pkg_name || '.' || l_api_name,
1751: 'EXITING PROCEDURE: ERROR'
1752: );
1753: END IF;

Line 1764: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

1760: p_count => x_msg_count,
1761: p_data => x_msg_data
1762: );
1763:
1764: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1765: FND_LOG.string
1766: (
1767: FND_LOG.level_procedure,
1768: g_pkg_name || '.' || l_api_name,

Line 1765: FND_LOG.string

1761: p_data => x_msg_data
1762: );
1763:
1764: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1765: FND_LOG.string
1766: (
1767: FND_LOG.level_procedure,
1768: g_pkg_name || '.' || l_api_name,
1769: 'EXITING PROCEDURE: ERROR'

Line 1767: FND_LOG.level_procedure,

1763:
1764: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1765: FND_LOG.string
1766: (
1767: FND_LOG.level_procedure,
1768: g_pkg_name || '.' || l_api_name,
1769: 'EXITING PROCEDURE: ERROR'
1770: );
1771: END IF;

Line 1791: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

1787: p_count => x_msg_count,
1788: p_data => x_msg_data
1789: );
1790:
1791: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1792: FND_LOG.string
1793: (
1794: FND_LOG.level_procedure,
1795: g_pkg_name || '.' || l_api_name,

Line 1792: FND_LOG.string

1788: p_data => x_msg_data
1789: );
1790:
1791: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1792: FND_LOG.string
1793: (
1794: FND_LOG.level_procedure,
1795: g_pkg_name || '.' || l_api_name,
1796: 'EXITING PROCEDURE: ERROR'

Line 1794: FND_LOG.level_procedure,

1790:
1791: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1792: FND_LOG.string
1793: (
1794: FND_LOG.level_procedure,
1795: g_pkg_name || '.' || l_api_name,
1796: 'EXITING PROCEDURE: ERROR'
1797: );
1798: END IF;

Line 1817: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

1813: l_api_name CONSTANT VARCHAR2(30) := 'PURGE_RECORDS';
1814: l_result_count NUMBER;
1815: BEGIN
1816:
1817: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1818: FND_LOG.string
1819: (
1820: FND_LOG.level_procedure,
1821: g_pkg_name || '.' || l_api_name,

Line 1818: FND_LOG.string

1814: l_result_count NUMBER;
1815: BEGIN
1816:
1817: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1818: FND_LOG.string
1819: (
1820: FND_LOG.level_procedure,
1821: g_pkg_name || '.' || l_api_name,
1822: 'ENTERING PROCEDURE: P_TXN_NUMBER: ' || p_txn_number || ' P_ORG_ID: ' || p_org_id || ' P_TXN_HEADER_ID: ' || p_txn_header_id || ' P_COLLECTION_ID: ' || p_collection_id

Line 1820: FND_LOG.level_procedure,

1816:
1817: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1818: FND_LOG.string
1819: (
1820: FND_LOG.level_procedure,
1821: g_pkg_name || '.' || l_api_name,
1822: 'ENTERING PROCEDURE: P_TXN_NUMBER: ' || p_txn_number || ' P_ORG_ID: ' || p_org_id || ' P_TXN_HEADER_ID: ' || p_txn_header_id || ' P_COLLECTION_ID: ' || p_collection_id
1823: );
1824: END IF;

Line 1831: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

1827: WHERE collection_id = p_collection_id;
1828:
1829: l_result_count := SQL%ROWCOUNT;
1830:
1831: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1832: FND_LOG.string
1833: (
1834: FND_LOG.level_statement,
1835: g_pkg_name || '.' || l_api_name,

Line 1832: FND_LOG.string

1828:
1829: l_result_count := SQL%ROWCOUNT;
1830:
1831: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1832: FND_LOG.string
1833: (
1834: FND_LOG.level_statement,
1835: g_pkg_name || '.' || l_api_name,
1836: 'DELETED ' || l_result_count || ' ROWS FROM QA_RESULTS'

Line 1834: FND_LOG.level_statement,

1830:
1831: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1832: FND_LOG.string
1833: (
1834: FND_LOG.level_statement,
1835: g_pkg_name || '.' || l_api_name,
1836: 'DELETED ' || l_result_count || ' ROWS FROM QA_RESULTS'
1837: );
1838: END IF;

Line 1845: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

1841: DELETE qa_pc_results_relationship
1842: WHERE parent_collection_id = p_collection_id
1843: OR child_collection_id = p_collection_id;
1844:
1845: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1846: FND_LOG.string
1847: (
1848: FND_LOG.level_statement,
1849: g_pkg_name || '.' || l_api_name,

Line 1846: FND_LOG.string

1842: WHERE parent_collection_id = p_collection_id
1843: OR child_collection_id = p_collection_id;
1844:
1845: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1846: FND_LOG.string
1847: (
1848: FND_LOG.level_statement,
1849: g_pkg_name || '.' || l_api_name,
1850: 'DELETED ' || SQL%ROWCOUNT || ' ROWS FROM QA_PC_RESULTS_RELATIONSHIP'

Line 1848: FND_LOG.level_statement,

1844:
1845: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1846: FND_LOG.string
1847: (
1848: FND_LOG.level_statement,
1849: g_pkg_name || '.' || l_api_name,
1850: 'DELETED ' || SQL%ROWCOUNT || ' ROWS FROM QA_PC_RESULTS_RELATIONSHIP'
1851: );
1852: END IF;

Line 1856: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

1852: END IF;
1853:
1854: END IF;
1855:
1856: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1857: FND_LOG.string
1858: (
1859: FND_LOG.level_procedure,
1860: g_pkg_name || '.' || l_api_name,

Line 1857: FND_LOG.string

1853:
1854: END IF;
1855:
1856: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1857: FND_LOG.string
1858: (
1859: FND_LOG.level_procedure,
1860: g_pkg_name || '.' || l_api_name,
1861: 'EXITING PROCEDURE: SUCCESS'

Line 1859: FND_LOG.level_procedure,

1855:
1856: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1857: FND_LOG.string
1858: (
1859: FND_LOG.level_procedure,
1860: g_pkg_name || '.' || l_api_name,
1861: 'EXITING PROCEDURE: SUCCESS'
1862: );
1863: END IF;

Line 1930: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

1926: BEGIN
1927:
1928: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
1929:
1930: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1931: FND_LOG.string
1932: (
1933: FND_LOG.level_procedure,
1934: g_pkg_name || '.' || l_api_name,

Line 1931: FND_LOG.string

1927:
1928: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
1929:
1930: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1931: FND_LOG.string
1932: (
1933: FND_LOG.level_procedure,
1934: g_pkg_name || '.' || l_api_name,
1935: 'ENTERING PROCEDURE: p_txn_number: ' || p_txn_number || ' p_org_id: ' || p_org_id || ' p_txn_header_id: ' || p_txn_header_id ||

Line 1933: FND_LOG.level_procedure,

1929:
1930: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1931: FND_LOG.string
1932: (
1933: FND_LOG.level_procedure,
1934: g_pkg_name || '.' || l_api_name,
1935: 'ENTERING PROCEDURE: p_txn_number: ' || p_txn_number || ' p_org_id: ' || p_org_id || ' p_txn_header_id: ' || p_txn_header_id ||
1936: ' p_collection_id: ' || p_collection_id || ' p_plan_txn_ids: ' || p_plan_txn_ids || ' p_context_values: ' || p_context_values || '
1937: p_context_ids: ' || p_context_ids

Line 1962: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

1958: END IF;
1959:
1960: -- Initialize API return status to success
1961: x_return_status := FND_API.G_RET_STS_SUCCESS;
1962: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1963: FND_LOG.string
1964: (
1965: FND_LOG.level_statement,
1966: g_pkg_name || '.' || l_api_name,

Line 1963: FND_LOG.string

1959:
1960: -- Initialize API return status to success
1961: x_return_status := FND_API.G_RET_STS_SUCCESS;
1962: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1963: FND_LOG.string
1964: (
1965: FND_LOG.level_statement,
1966: g_pkg_name || '.' || l_api_name,
1967: 'BEFORE FIRING MES ERES EVENT'

Line 1965: FND_LOG.level_statement,

1961: x_return_status := FND_API.G_RET_STS_SUCCESS;
1962: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1963: FND_LOG.string
1964: (
1965: FND_LOG.level_statement,
1966: g_pkg_name || '.' || l_api_name,
1967: 'BEFORE FIRING MES ERES EVENT'
1968: );
1969: END IF;

Line 1995: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

1991: IF l_plan_ids.FIRST IS NOT NULL THEN
1992:
1993: FOR i IN l_plan_ids.FIRST .. l_plan_ids.LAST LOOP
1994:
1995: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1996: FND_LOG.string
1997: (
1998: FND_LOG.level_statement,
1999: g_pkg_name || '.' || l_api_name,

Line 1996: FND_LOG.string

1992:
1993: FOR i IN l_plan_ids.FIRST .. l_plan_ids.LAST LOOP
1994:
1995: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1996: FND_LOG.string
1997: (
1998: FND_LOG.level_statement,
1999: g_pkg_name || '.' || l_api_name,
2000: 'BEFORE INSERTING AUTOMATIC RECORDS FOR PLAN_ID: ' || l_plan_ids(i) || ' OCCURRENCE: ' || l_occurrences(i)

Line 1998: FND_LOG.level_statement,

1994:
1995: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1996: FND_LOG.string
1997: (
1998: FND_LOG.level_statement,
1999: g_pkg_name || '.' || l_api_name,
2000: 'BEFORE INSERTING AUTOMATIC RECORDS FOR PLAN_ID: ' || l_plan_ids(i) || ' OCCURRENCE: ' || l_occurrences(i)
2001: );
2002: END IF;

Line 2016: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

2012: p_data_entry_mode => 2, -- Automatic
2013: p_txn_header_id => p_txn_header_id
2014: );
2015:
2016: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2017: FND_LOG.string
2018: (
2019: FND_LOG.level_statement,
2020: g_pkg_name || '.' || l_api_name,

Line 2017: FND_LOG.string

2013: p_txn_header_id => p_txn_header_id
2014: );
2015:
2016: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2017: FND_LOG.string
2018: (
2019: FND_LOG.level_statement,
2020: g_pkg_name || '.' || l_api_name,
2021: 'BEFORE INSERTING HISTORY RECORDS FOR PLAN_ID: ' || l_plan_ids(i) || ' OCCURRENCE: ' || l_occurrences(i)

Line 2019: FND_LOG.level_statement,

2015:
2016: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2017: FND_LOG.string
2018: (
2019: FND_LOG.level_statement,
2020: g_pkg_name || '.' || l_api_name,
2021: 'BEFORE INSERTING HISTORY RECORDS FOR PLAN_ID: ' || l_plan_ids(i) || ' OCCURRENCE: ' || l_occurrences(i)
2022: );
2023: END IF;

Line 2040: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

2036: END LOOP;
2037: END IF; -- l_plan_ids.FIRST is not null
2038:
2039:
2040: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2041: FND_LOG.string
2042: (
2043: FND_LOG.level_statement,
2044: g_pkg_name || '.' || l_api_name,

Line 2041: FND_LOG.string

2037: END IF; -- l_plan_ids.FIRST is not null
2038:
2039:
2040: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2041: FND_LOG.string
2042: (
2043: FND_LOG.level_statement,
2044: g_pkg_name || '.' || l_api_name,
2045: 'BEFORE ENABLING QA RESULTS'

Line 2043: FND_LOG.level_statement,

2039:
2040: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2041: FND_LOG.string
2042: (
2043: FND_LOG.level_statement,
2044: g_pkg_name || '.' || l_api_name,
2045: 'BEFORE ENABLING QA RESULTS'
2046: );
2047: END IF;

Line 2049: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

2045: 'BEFORE ENABLING QA RESULTS'
2046: );
2047: END IF;
2048:
2049: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2050: FND_LOG.string
2051: (
2052: FND_LOG.level_statement,
2053: g_pkg_name || '.' || l_api_name,

Line 2050: FND_LOG.string

2046: );
2047: END IF;
2048:
2049: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2050: FND_LOG.string
2051: (
2052: FND_LOG.level_statement,
2053: g_pkg_name || '.' || l_api_name,
2054: 'BEFORE GENERATING SEQUENCES'

Line 2052: FND_LOG.level_statement,

2048:
2049: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2050: FND_LOG.string
2051: (
2052: FND_LOG.level_statement,
2053: g_pkg_name || '.' || l_api_name,
2054: 'BEFORE GENERATING SEQUENCES'
2055: );
2056: END IF;

Line 2069: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

2065: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2067: END IF;
2068:
2069: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2070: FND_LOG.string
2071: (
2072: FND_LOG.level_statement,
2073: g_pkg_name || '.' || l_api_name,

Line 2070: FND_LOG.string

2066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2067: END IF;
2068:
2069: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2070: FND_LOG.string
2071: (
2072: FND_LOG.level_statement,
2073: g_pkg_name || '.' || l_api_name,
2074: 'BEFORE FIRING BACKGROUND ACTIONS'

Line 2072: FND_LOG.level_statement,

2068:
2069: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2070: FND_LOG.string
2071: (
2072: FND_LOG.level_statement,
2073: g_pkg_name || '.' || l_api_name,
2074: 'BEFORE FIRING BACKGROUND ACTIONS'
2075: );
2076: END IF;

Line 2115: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

2111: p_count => x_msg_count,
2112: p_data => x_msg_data
2113: );
2114:
2115: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2116: FND_LOG.string
2117: (
2118: FND_LOG.level_procedure,
2119: g_pkg_name || '.' || l_api_name,

Line 2116: FND_LOG.string

2112: p_data => x_msg_data
2113: );
2114:
2115: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2116: FND_LOG.string
2117: (
2118: FND_LOG.level_procedure,
2119: g_pkg_name || '.' || l_api_name,
2120: 'EXITING PROCEDURE: SUCCESS'

Line 2118: FND_LOG.level_procedure,

2114:
2115: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2116: FND_LOG.string
2117: (
2118: FND_LOG.level_procedure,
2119: g_pkg_name || '.' || l_api_name,
2120: 'EXITING PROCEDURE: SUCCESS'
2121: );
2122: END IF;

Line 2136: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

2132: p_count => x_msg_count,
2133: p_data => x_msg_data
2134: );
2135:
2136: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2137: FND_LOG.string
2138: (
2139: FND_LOG.level_procedure,
2140: g_pkg_name || '.' || l_api_name,

Line 2137: FND_LOG.string

2133: p_data => x_msg_data
2134: );
2135:
2136: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2137: FND_LOG.string
2138: (
2139: FND_LOG.level_procedure,
2140: g_pkg_name || '.' || l_api_name,
2141: 'EXITING PROCEDURE: ERROR'

Line 2139: FND_LOG.level_procedure,

2135:
2136: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2137: FND_LOG.string
2138: (
2139: FND_LOG.level_procedure,
2140: g_pkg_name || '.' || l_api_name,
2141: 'EXITING PROCEDURE: ERROR'
2142: );
2143: END IF;

Line 2154: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

2150: p_count => x_msg_count,
2151: p_data => x_msg_data
2152: );
2153:
2154: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2155: FND_LOG.string
2156: (
2157: FND_LOG.level_procedure,
2158: g_pkg_name || '.' || l_api_name,

Line 2155: FND_LOG.string

2151: p_data => x_msg_data
2152: );
2153:
2154: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2155: FND_LOG.string
2156: (
2157: FND_LOG.level_procedure,
2158: g_pkg_name || '.' || l_api_name,
2159: 'EXITING PROCEDURE: ERROR'

Line 2157: FND_LOG.level_procedure,

2153:
2154: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2155: FND_LOG.string
2156: (
2157: FND_LOG.level_procedure,
2158: g_pkg_name || '.' || l_api_name,
2159: 'EXITING PROCEDURE: ERROR'
2160: );
2161: END IF;

Line 2187: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

2183: p_count => x_msg_count,
2184: p_data => x_msg_data
2185: );
2186:
2187: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2188: FND_LOG.string
2189: (
2190: FND_LOG.level_procedure,
2191: g_pkg_name || '.' || l_api_name,

Line 2188: FND_LOG.string

2184: p_data => x_msg_data
2185: );
2186:
2187: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2188: FND_LOG.string
2189: (
2190: FND_LOG.level_procedure,
2191: g_pkg_name || '.' || l_api_name,
2192: 'EXITING PROCEDURE: ERROR'

Line 2190: FND_LOG.level_procedure,

2186:
2187: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2188: FND_LOG.string
2189: (
2190: FND_LOG.level_procedure,
2191: g_pkg_name || '.' || l_api_name,
2192: 'EXITING PROCEDURE: ERROR'
2193: );
2194: END IF;

Line 2220: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

2216: BEGIN
2217:
2218: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
2219:
2220: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2221: FND_LOG.string
2222: (
2223: FND_LOG.level_procedure,
2224: g_pkg_name || '.' || l_api_name,

Line 2221: FND_LOG.string

2217:
2218: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
2219:
2220: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2221: FND_LOG.string
2222: (
2223: FND_LOG.level_procedure,
2224: g_pkg_name || '.' || l_api_name,
2225: 'ENTERING PROCEDURE' );

Line 2223: FND_LOG.level_procedure,

2219:
2220: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2221: FND_LOG.string
2222: (
2223: FND_LOG.level_procedure,
2224: g_pkg_name || '.' || l_api_name,
2225: 'ENTERING PROCEDURE' );
2226: END IF;
2227:

Line 2249: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

2245: END IF;
2246:
2247: -- Initialize API return status to success
2248: x_return_status := FND_API.G_RET_STS_SUCCESS;
2249: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2250: FND_LOG.string
2251: (
2252: FND_LOG.level_statement,
2253: g_pkg_name || '.' || l_api_name,

Line 2250: FND_LOG.string

2246:
2247: -- Initialize API return status to success
2248: x_return_status := FND_API.G_RET_STS_SUCCESS;
2249: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2250: FND_LOG.string
2251: (
2252: FND_LOG.level_statement,
2253: g_pkg_name || '.' || l_api_name,
2254: 'BEFORE ENABLING RESULTS'

Line 2252: FND_LOG.level_statement,

2248: x_return_status := FND_API.G_RET_STS_SUCCESS;
2249: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2250: FND_LOG.string
2251: (
2252: FND_LOG.level_statement,
2253: g_pkg_name || '.' || l_api_name,
2254: 'BEFORE ENABLING RESULTS'
2255: );
2256: END IF;

Line 2262: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

2258: UPDATE qa_results
2259: SET status=2
2260: WHERE collection_id = p_collection_id;
2261:
2262: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2263: FND_LOG.string
2264: (
2265: FND_LOG.level_statement,
2266: g_pkg_name || '.' || l_api_name,

Line 2263: FND_LOG.string

2259: SET status=2
2260: WHERE collection_id = p_collection_id;
2261:
2262: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2263: FND_LOG.string
2264: (
2265: FND_LOG.level_statement,
2266: g_pkg_name || '.' || l_api_name,
2267: 'BEFORE FIRING BACKGROUND ACTIONS'

Line 2265: FND_LOG.level_statement,

2261:
2262: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2263: FND_LOG.string
2264: (
2265: FND_LOG.level_statement,
2266: g_pkg_name || '.' || l_api_name,
2267: 'BEFORE FIRING BACKGROUND ACTIONS'
2268: );
2269: END IF;

Line 2299: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

2295: p_count => x_msg_count,
2296: p_data => x_msg_data
2297: );
2298:
2299: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2300: FND_LOG.string
2301: (
2302: FND_LOG.level_procedure,
2303: g_pkg_name || '.' || l_api_name,

Line 2300: FND_LOG.string

2296: p_data => x_msg_data
2297: );
2298:
2299: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2300: FND_LOG.string
2301: (
2302: FND_LOG.level_procedure,
2303: g_pkg_name || '.' || l_api_name,
2304: 'EXITING PROCEDURE: SUCCESS'

Line 2302: FND_LOG.level_procedure,

2298:
2299: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2300: FND_LOG.string
2301: (
2302: FND_LOG.level_procedure,
2303: g_pkg_name || '.' || l_api_name,
2304: 'EXITING PROCEDURE: SUCCESS'
2305: );
2306: END IF;

Line 2319: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

2315: p_count => x_msg_count,
2316: p_data => x_msg_data
2317: );
2318:
2319: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2320: FND_LOG.string
2321: (
2322: FND_LOG.level_procedure,
2323: g_pkg_name || '.' || l_api_name,

Line 2320: FND_LOG.string

2316: p_data => x_msg_data
2317: );
2318:
2319: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2320: FND_LOG.string
2321: (
2322: FND_LOG.level_procedure,
2323: g_pkg_name || '.' || l_api_name,
2324: 'EXITING PROCEDURE: ERROR'

Line 2322: FND_LOG.level_procedure,

2318:
2319: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2320: FND_LOG.string
2321: (
2322: FND_LOG.level_procedure,
2323: g_pkg_name || '.' || l_api_name,
2324: 'EXITING PROCEDURE: ERROR'
2325: );
2326: END IF;

Line 2337: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

2333: p_count => x_msg_count,
2334: p_data => x_msg_data
2335: );
2336:
2337: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2338: FND_LOG.string
2339: (
2340: FND_LOG.level_procedure,
2341: g_pkg_name || '.' || l_api_name,

Line 2338: FND_LOG.string

2334: p_data => x_msg_data
2335: );
2336:
2337: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2338: FND_LOG.string
2339: (
2340: FND_LOG.level_procedure,
2341: g_pkg_name || '.' || l_api_name,
2342: 'EXITING PROCEDURE: ERROR'

Line 2340: FND_LOG.level_procedure,

2336:
2337: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2338: FND_LOG.string
2339: (
2340: FND_LOG.level_procedure,
2341: g_pkg_name || '.' || l_api_name,
2342: 'EXITING PROCEDURE: ERROR'
2343: );
2344: END IF;

Line 2370: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

2366: p_count => x_msg_count,
2367: p_data => x_msg_data
2368: );
2369:
2370: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2371: FND_LOG.string
2372: (
2373: FND_LOG.level_procedure,
2374: g_pkg_name || '.' || l_api_name,

Line 2371: FND_LOG.string

2367: p_data => x_msg_data
2368: );
2369:
2370: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2371: FND_LOG.string
2372: (
2373: FND_LOG.level_procedure,
2374: g_pkg_name || '.' || l_api_name,
2375: 'EXITING PROCEDURE: ERROR'

Line 2373: FND_LOG.level_procedure,

2369:
2370: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2371: FND_LOG.string
2372: (
2373: FND_LOG.level_procedure,
2374: g_pkg_name || '.' || l_api_name,
2375: 'EXITING PROCEDURE: ERROR'
2376: );
2377: END IF;