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 576: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

572: EXECUTE IMMEDIATE l_insert_columns || l_insert_values
573: USING p_plan_id, p_org_id, p_collection_id, uid, uid, uid, uid;
574: EXCEPTION WHEN OTHERS THEN
575:
576: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
577: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
578: 'QA_TXN_GRP.INSERT_RESULTS.err', l_insert_columns || l_insert_values );
579: end if;
580:

Line 577: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

573: USING p_plan_id, p_org_id, p_collection_id, uid, uid, uid, uid;
574: EXCEPTION WHEN OTHERS THEN
575:
576: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
577: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
578: 'QA_TXN_GRP.INSERT_RESULTS.err', l_insert_columns || l_insert_values );
579: end if;
580:
581: END insert_results;

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

1095: )
1096: IS
1097: l_api_name CONSTANT VARCHAR2(30) := 'GET_CHILD_PLANS';
1098: BEGIN
1099: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1100: FND_LOG.string
1101: (
1102: FND_LOG.level_statement,
1103: g_pkg_name || '.' || l_api_name,

Line 1100: FND_LOG.string

1096: IS
1097: l_api_name CONSTANT VARCHAR2(30) := 'GET_CHILD_PLANS';
1098: BEGIN
1099: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1100: FND_LOG.string
1101: (
1102: FND_LOG.level_statement,
1103: g_pkg_name || '.' || l_api_name,
1104: 'BEFORE GETTING PC CRITERIA VALUES'

Line 1102: FND_LOG.level_statement,

1098: BEGIN
1099: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1100: FND_LOG.string
1101: (
1102: FND_LOG.level_statement,
1103: g_pkg_name || '.' || l_api_name,
1104: 'BEFORE GETTING PC CRITERIA VALUES'
1105: );
1106: END IF;

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

1113: p_organization_id => p_org_id,
1114: x_criteria_values => x_criteria_values
1115: );
1116:
1117: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1118: FND_LOG.string
1119: (
1120: FND_LOG.level_statement,
1121: g_pkg_name || '.' || l_api_name,

Line 1118: FND_LOG.string

1114: x_criteria_values => x_criteria_values
1115: );
1116:
1117: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1118: FND_LOG.string
1119: (
1120: FND_LOG.level_statement,
1121: g_pkg_name || '.' || l_api_name,
1122: 'BEFORE EVALUATING PC CRITERIA'

Line 1120: FND_LOG.level_statement,

1116:
1117: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1118: FND_LOG.string
1119: (
1120: FND_LOG.level_statement,
1121: g_pkg_name || '.' || l_api_name,
1122: 'BEFORE EVALUATING PC CRITERIA'
1123: );
1124: END IF;

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

1237: l_occurrences number_tab;
1238:
1239: BEGIN
1240:
1241: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1242: FND_LOG.string
1243: (
1244: FND_LOG.level_procedure,
1245: g_pkg_name || '.' || l_api_name,

Line 1242: FND_LOG.string

1238:
1239: BEGIN
1240:
1241: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1242: FND_LOG.string
1243: (
1244: FND_LOG.level_procedure,
1245: g_pkg_name || '.' || l_api_name,
1246: '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 1244: FND_LOG.level_procedure,

1240:
1241: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1242: FND_LOG.string
1243: (
1244: FND_LOG.level_procedure,
1245: g_pkg_name || '.' || l_api_name,
1246: '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
1247: );
1248: END IF;

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

1246: '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
1247: );
1248: END IF;
1249:
1250: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1251: FND_LOG.string
1252: (
1253: FND_LOG.level_statement,
1254: g_pkg_name || '.' || l_api_name,

Line 1251: FND_LOG.string

1247: );
1248: END IF;
1249:
1250: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1251: FND_LOG.string
1252: (
1253: FND_LOG.level_statement,
1254: g_pkg_name || '.' || l_api_name,
1255: 'BEFORE CHECKING MANDATORY COLLECTION'

Line 1253: FND_LOG.level_statement,

1249:
1250: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1251: FND_LOG.string
1252: (
1253: FND_LOG.level_statement,
1254: g_pkg_name || '.' || l_api_name,
1255: 'BEFORE CHECKING MANDATORY COLLECTION'
1256: );
1257: END IF;

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

1290: p_prefix => l_prefix1 || l_prefix2,
1291: p_suffix => NULL
1292: );
1293:
1294: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1295: FND_LOG.string
1296: (
1297: FND_LOG.level_procedure,
1298: g_pkg_name || '.' || l_api_name,

Line 1295: FND_LOG.string

1291: p_suffix => NULL
1292: );
1293:
1294: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1295: FND_LOG.string
1296: (
1297: FND_LOG.level_procedure,
1298: g_pkg_name || '.' || l_api_name,
1299: 'EXITING PROCEDURE: INCOMPLETE PLANS - IDS: ' || l_plan_ids || ' NAMES: ' || x_plan_names

Line 1297: FND_LOG.level_procedure,

1293:
1294: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1295: FND_LOG.string
1296: (
1297: FND_LOG.level_procedure,
1298: g_pkg_name || '.' || l_api_name,
1299: 'EXITING PROCEDURE: INCOMPLETE PLANS - IDS: ' || l_plan_ids || ' NAMES: ' || x_plan_names
1300: );
1301: END IF;

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

1304: END IF;
1305:
1306: l_plan_ids := '';
1307:
1308: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1309: FND_LOG.string
1310: (
1311: FND_LOG.level_statement,
1312: g_pkg_name || '.' || l_api_name,

Line 1309: FND_LOG.string

1305:
1306: l_plan_ids := '';
1307:
1308: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1309: FND_LOG.string
1310: (
1311: FND_LOG.level_statement,
1312: g_pkg_name || '.' || l_api_name,
1313: 'BEFORE VALIDATING IMMEDIATE CHILD COLLECTION'

Line 1311: FND_LOG.level_statement,

1307:
1308: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1309: FND_LOG.string
1310: (
1311: FND_LOG.level_statement,
1312: g_pkg_name || '.' || l_api_name,
1313: 'BEFORE VALIDATING IMMEDIATE CHILD COLLECTION'
1314: );
1315: END IF;

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

1337: IF l_plans.FIRST IS NOT NULL THEN
1338:
1339: FOR i IN l_plans.FIRST .. l_plans.LAST LOOP
1340:
1341: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1342: FND_LOG.string
1343: (
1344: FND_LOG.level_statement,
1345: g_pkg_name || '.' || l_api_name,

Line 1342: FND_LOG.string

1338:
1339: FOR i IN l_plans.FIRST .. l_plans.LAST LOOP
1340:
1341: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1342: FND_LOG.string
1343: (
1344: FND_LOG.level_statement,
1345: g_pkg_name || '.' || l_api_name,
1346: 'BEFORE GETTING CHILD PLANS FOR PLAN_ID: ' || l_plans(i) || ' OCCURRENCE: ' || l_occurrences(i)

Line 1344: FND_LOG.level_statement,

1340:
1341: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1342: FND_LOG.string
1343: (
1344: FND_LOG.level_statement,
1345: g_pkg_name || '.' || l_api_name,
1346: 'BEFORE GETTING CHILD PLANS FOR PLAN_ID: ' || l_plans(i) || ' OCCURRENCE: ' || l_occurrences(i)
1347: );
1348: END IF;

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

1366: );
1367:
1368: IF( l_return_status = 'T' ) THEN
1369:
1370: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1371: FND_LOG.string
1372: (
1373: FND_LOG.level_statement,
1374: g_pkg_name || '.' || l_api_name,

Line 1371: FND_LOG.string

1367:
1368: IF( l_return_status = 'T' ) THEN
1369:
1370: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1371: FND_LOG.string
1372: (
1373: FND_LOG.level_statement,
1374: g_pkg_name || '.' || l_api_name,
1375: 'BEFORE CHECKING IF COMMIT IS ALLOWED FOR IMMEDIATE CHILDREN: ' || l_child_plan_ids

Line 1373: FND_LOG.level_statement,

1369:
1370: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1371: FND_LOG.string
1372: (
1373: FND_LOG.level_statement,
1374: g_pkg_name || '.' || l_api_name,
1375: 'BEFORE CHECKING IF COMMIT IS ALLOWED FOR IMMEDIATE CHILDREN: ' || l_child_plan_ids
1376: );
1377: END IF;

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

1391: );
1392:
1393: IF ( l_return_status <> 'T' ) THEN
1394:
1395: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1396: FND_LOG.string
1397: (
1398: FND_LOG.level_statement,
1399: g_pkg_name || '.' || l_api_name,

Line 1396: FND_LOG.string

1392:
1393: IF ( l_return_status <> 'T' ) THEN
1394:
1395: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1396: FND_LOG.string
1397: (
1398: FND_LOG.level_statement,
1399: g_pkg_name || '.' || l_api_name,
1400: 'ALL CHILD RESULTS ARE NOT CAPTURED FOR PLAN: ' || l_plans(i)

Line 1398: FND_LOG.level_statement,

1394:
1395: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1396: FND_LOG.string
1397: (
1398: FND_LOG.level_statement,
1399: g_pkg_name || '.' || l_api_name,
1400: 'ALL CHILD RESULTS ARE NOT CAPTURED FOR PLAN: ' || l_plans(i)
1401: );
1402: END IF;

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

1431: -- Bug 5161719. SHKALYAN 13-Apr-2006
1432: -- Remove the leading comma
1433: x_plan_names := SUBSTR( x_plan_names , LENGTH(l_separator) + 1 );
1434:
1435: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1436: FND_LOG.string
1437: (
1438: FND_LOG.level_procedure,
1439: g_pkg_name || '.' || l_api_name,

Line 1436: FND_LOG.string

1432: -- Remove the leading comma
1433: x_plan_names := SUBSTR( x_plan_names , LENGTH(l_separator) + 1 );
1434:
1435: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1436: FND_LOG.string
1437: (
1438: FND_LOG.level_procedure,
1439: g_pkg_name || '.' || l_api_name,
1440: 'EXITING PROCEDURE: INCOMPLETE PLANS : ' || x_plan_names

Line 1438: FND_LOG.level_procedure,

1434:
1435: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1436: FND_LOG.string
1437: (
1438: FND_LOG.level_procedure,
1439: g_pkg_name || '.' || l_api_name,
1440: 'EXITING PROCEDURE: INCOMPLETE PLANS : ' || x_plan_names
1441: );
1442: END IF;

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

1443:
1444: return 'F';
1445: END IF;
1446:
1447: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1448: FND_LOG.string
1449: (
1450: FND_LOG.level_procedure,
1451: g_pkg_name || '.' || l_api_name,

Line 1448: FND_LOG.string

1444: return 'F';
1445: END IF;
1446:
1447: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1448: FND_LOG.string
1449: (
1450: FND_LOG.level_procedure,
1451: g_pkg_name || '.' || l_api_name,
1452: 'EXITING PROCEDURE: COMMIT IS ALLOWED'

Line 1450: FND_LOG.level_procedure,

1446:
1447: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1448: FND_LOG.string
1449: (
1450: FND_LOG.level_procedure,
1451: g_pkg_name || '.' || l_api_name,
1452: 'EXITING PROCEDURE: COMMIT IS ALLOWED'
1453: );
1454: END IF;

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

1497: BEGIN
1498:
1499: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
1500:
1501: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1502: FND_LOG.string
1503: (
1504: FND_LOG.level_procedure,
1505: g_pkg_name || '.' || l_api_name,

Line 1502: FND_LOG.string

1498:
1499: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
1500:
1501: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1502: FND_LOG.string
1503: (
1504: FND_LOG.level_procedure,
1505: g_pkg_name || '.' || l_api_name,
1506: 'ENTERING PROCEDURE: p_txn_number: ' || p_txn_number || ' p_org_id: ' || p_org_id || ' p_txn_header_id: ' || p_txn_header_id ||

Line 1504: FND_LOG.level_procedure,

1500:
1501: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1502: FND_LOG.string
1503: (
1504: FND_LOG.level_procedure,
1505: g_pkg_name || '.' || l_api_name,
1506: 'ENTERING PROCEDURE: p_txn_number: ' || p_txn_number || ' p_org_id: ' || p_org_id || ' p_txn_header_id: ' || p_txn_header_id ||
1507: ' 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
1508: );

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

1529:
1530: -- Initialize API return status to success
1531: x_return_status := FND_API.G_RET_STS_SUCCESS;
1532:
1533: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1534: FND_LOG.string
1535: (
1536: FND_LOG.level_statement,
1537: g_pkg_name || '.' || l_api_name,

Line 1534: FND_LOG.string

1530: -- Initialize API return status to success
1531: x_return_status := FND_API.G_RET_STS_SUCCESS;
1532:
1533: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1534: FND_LOG.string
1535: (
1536: FND_LOG.level_statement,
1537: g_pkg_name || '.' || l_api_name,
1538: 'BEFORE POSTING BACKGROUND RESULTS'

Line 1536: FND_LOG.level_statement,

1532:
1533: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1534: FND_LOG.string
1535: (
1536: FND_LOG.level_statement,
1537: g_pkg_name || '.' || l_api_name,
1538: 'BEFORE POSTING BACKGROUND RESULTS'
1539: );
1540: END IF;

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

1567: IF l_plan_ids.FIRST IS NOT NULL THEN
1568:
1569: FOR i IN l_plan_ids.FIRST .. l_plan_ids.LAST LOOP
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:
1569: FOR i IN l_plan_ids.FIRST .. l_plan_ids.LAST LOOP
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 INSERTING AUTOMATIC RECORDS FOR PLAN_ID: ' || l_plan_ids(i) || ' OCCURRENCE: ' || l_occurrences(i)

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 INSERTING AUTOMATIC RECORDS FOR PLAN_ID: ' || l_plan_ids(i) || ' OCCURRENCE: ' || l_occurrences(i)
1577: );
1578: END IF;

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

1588: p_data_entry_mode => 2, -- Automatic
1589: p_txn_header_id => p_txn_header_id
1590: );
1591:
1592: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1593: FND_LOG.string
1594: (
1595: FND_LOG.level_statement,
1596: g_pkg_name || '.' || l_api_name,

Line 1593: FND_LOG.string

1589: p_txn_header_id => p_txn_header_id
1590: );
1591:
1592: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1593: FND_LOG.string
1594: (
1595: FND_LOG.level_statement,
1596: g_pkg_name || '.' || l_api_name,
1597: 'BEFORE INSERTING HISTORY RECORDS FOR PLAN_ID: ' || l_plan_ids(i) || ' OCCURRENCE: ' || l_occurrences(i)

Line 1595: FND_LOG.level_statement,

1591:
1592: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1593: FND_LOG.string
1594: (
1595: FND_LOG.level_statement,
1596: g_pkg_name || '.' || l_api_name,
1597: 'BEFORE INSERTING HISTORY RECORDS FOR PLAN_ID: ' || l_plan_ids(i) || ' OCCURRENCE: ' || l_occurrences(i)
1598: );
1599: END IF;

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

1612:
1613: END LOOP;
1614: END IF; -- l_plan_ids.FIRST is not null
1615:
1616: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1617: FND_LOG.string
1618: (
1619: FND_LOG.level_statement,
1620: g_pkg_name || '.' || l_api_name,

Line 1617: FND_LOG.string

1613: END LOOP;
1614: END IF; -- l_plan_ids.FIRST is not null
1615:
1616: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1617: FND_LOG.string
1618: (
1619: FND_LOG.level_statement,
1620: g_pkg_name || '.' || l_api_name,
1621: 'BEFORE ENABLING QA RESULTS'

Line 1619: FND_LOG.level_statement,

1615:
1616: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1617: FND_LOG.string
1618: (
1619: FND_LOG.level_statement,
1620: g_pkg_name || '.' || l_api_name,
1621: 'BEFORE ENABLING QA RESULTS'
1622: );
1623: END IF;

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

1626: UPDATE qa_results
1627: SET status = 2
1628: WHERE collection_id = p_collection_id;
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: SET status = 2
1628: WHERE collection_id = p_collection_id;
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 GENERATING SEQUENCES'

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 GENERATING SEQUENCES'
1636: );
1637: END IF;

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

1646: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1648: END IF;
1649:
1650: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1651: FND_LOG.string
1652: (
1653: FND_LOG.level_statement,
1654: g_pkg_name || '.' || l_api_name,

Line 1651: FND_LOG.string

1647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1648: END IF;
1649:
1650: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1651: FND_LOG.string
1652: (
1653: FND_LOG.level_statement,
1654: g_pkg_name || '.' || l_api_name,
1655: 'BEFORE FIRING BACKGROUND ACTIONS'

Line 1653: FND_LOG.level_statement,

1649:
1650: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1651: FND_LOG.string
1652: (
1653: FND_LOG.level_statement,
1654: g_pkg_name || '.' || l_api_name,
1655: 'BEFORE FIRING BACKGROUND ACTIONS'
1656: );
1657: END IF;

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

1684: p_count => x_msg_count,
1685: p_data => x_msg_data
1686: );
1687:
1688: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1689: FND_LOG.string
1690: (
1691: FND_LOG.level_procedure,
1692: g_pkg_name || '.' || l_api_name,

Line 1689: FND_LOG.string

1685: p_data => x_msg_data
1686: );
1687:
1688: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1689: FND_LOG.string
1690: (
1691: FND_LOG.level_procedure,
1692: g_pkg_name || '.' || l_api_name,
1693: 'EXITING PROCEDURE: SUCCESS'

Line 1691: FND_LOG.level_procedure,

1687:
1688: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1689: FND_LOG.string
1690: (
1691: FND_LOG.level_procedure,
1692: g_pkg_name || '.' || l_api_name,
1693: 'EXITING PROCEDURE: SUCCESS'
1694: );
1695: END IF;

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

1704: p_count => x_msg_count,
1705: p_data => x_msg_data
1706: );
1707:
1708: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1709: FND_LOG.string
1710: (
1711: FND_LOG.level_procedure,
1712: g_pkg_name || '.' || l_api_name,

Line 1709: FND_LOG.string

1705: p_data => x_msg_data
1706: );
1707:
1708: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1709: FND_LOG.string
1710: (
1711: FND_LOG.level_procedure,
1712: g_pkg_name || '.' || l_api_name,
1713: 'EXITING PROCEDURE: ERROR'

Line 1711: FND_LOG.level_procedure,

1707:
1708: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1709: FND_LOG.string
1710: (
1711: FND_LOG.level_procedure,
1712: g_pkg_name || '.' || l_api_name,
1713: 'EXITING PROCEDURE: ERROR'
1714: );
1715: 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: ERROR'

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: ERROR'
1732: );
1733: END IF;

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

1749: p_count => x_msg_count,
1750: p_data => x_msg_data
1751: );
1752:
1753: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1754: FND_LOG.string
1755: (
1756: FND_LOG.level_procedure,
1757: g_pkg_name || '.' || l_api_name,

Line 1754: FND_LOG.string

1750: p_data => x_msg_data
1751: );
1752:
1753: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1754: FND_LOG.string
1755: (
1756: FND_LOG.level_procedure,
1757: g_pkg_name || '.' || l_api_name,
1758: 'EXITING PROCEDURE: ERROR'

Line 1756: FND_LOG.level_procedure,

1752:
1753: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1754: FND_LOG.string
1755: (
1756: FND_LOG.level_procedure,
1757: g_pkg_name || '.' || l_api_name,
1758: 'EXITING PROCEDURE: ERROR'
1759: );
1760: END IF;

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

1775: l_api_name CONSTANT VARCHAR2(30) := 'PURGE_RECORDS';
1776: l_result_count NUMBER;
1777: BEGIN
1778:
1779: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1780: FND_LOG.string
1781: (
1782: FND_LOG.level_procedure,
1783: g_pkg_name || '.' || l_api_name,

Line 1780: FND_LOG.string

1776: l_result_count NUMBER;
1777: BEGIN
1778:
1779: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1780: FND_LOG.string
1781: (
1782: FND_LOG.level_procedure,
1783: g_pkg_name || '.' || l_api_name,
1784: '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 1782: FND_LOG.level_procedure,

1778:
1779: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1780: FND_LOG.string
1781: (
1782: FND_LOG.level_procedure,
1783: g_pkg_name || '.' || l_api_name,
1784: '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
1785: );
1786: END IF;

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

1789: WHERE collection_id = p_collection_id;
1790:
1791: l_result_count := SQL%ROWCOUNT;
1792:
1793: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1794: FND_LOG.string
1795: (
1796: FND_LOG.level_statement,
1797: g_pkg_name || '.' || l_api_name,

Line 1794: FND_LOG.string

1790:
1791: l_result_count := SQL%ROWCOUNT;
1792:
1793: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1794: FND_LOG.string
1795: (
1796: FND_LOG.level_statement,
1797: g_pkg_name || '.' || l_api_name,
1798: 'DELETED ' || l_result_count || ' ROWS FROM QA_RESULTS'

Line 1796: FND_LOG.level_statement,

1792:
1793: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1794: FND_LOG.string
1795: (
1796: FND_LOG.level_statement,
1797: g_pkg_name || '.' || l_api_name,
1798: 'DELETED ' || l_result_count || ' ROWS FROM QA_RESULTS'
1799: );
1800: END IF;

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

1803: DELETE qa_pc_results_relationship
1804: WHERE parent_collection_id = p_collection_id
1805: OR child_collection_id = p_collection_id;
1806:
1807: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1808: FND_LOG.string
1809: (
1810: FND_LOG.level_statement,
1811: g_pkg_name || '.' || l_api_name,

Line 1808: FND_LOG.string

1804: WHERE parent_collection_id = p_collection_id
1805: OR child_collection_id = p_collection_id;
1806:
1807: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1808: FND_LOG.string
1809: (
1810: FND_LOG.level_statement,
1811: g_pkg_name || '.' || l_api_name,
1812: 'DELETED ' || SQL%ROWCOUNT || ' ROWS FROM QA_PC_RESULTS_RELATIONSHIP'

Line 1810: FND_LOG.level_statement,

1806:
1807: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1808: FND_LOG.string
1809: (
1810: FND_LOG.level_statement,
1811: g_pkg_name || '.' || l_api_name,
1812: 'DELETED ' || SQL%ROWCOUNT || ' ROWS FROM QA_PC_RESULTS_RELATIONSHIP'
1813: );
1814: END IF;

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

1814: END IF;
1815:
1816: END IF;
1817:
1818: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1819: FND_LOG.string
1820: (
1821: FND_LOG.level_procedure,
1822: g_pkg_name || '.' || l_api_name,

Line 1819: FND_LOG.string

1815:
1816: END IF;
1817:
1818: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1819: FND_LOG.string
1820: (
1821: FND_LOG.level_procedure,
1822: g_pkg_name || '.' || l_api_name,
1823: 'EXITING PROCEDURE: SUCCESS'

Line 1821: FND_LOG.level_procedure,

1817:
1818: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1819: FND_LOG.string
1820: (
1821: FND_LOG.level_procedure,
1822: g_pkg_name || '.' || l_api_name,
1823: 'EXITING PROCEDURE: SUCCESS'
1824: );
1825: END IF;

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

1888: BEGIN
1889:
1890: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
1891:
1892: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1893: FND_LOG.string
1894: (
1895: FND_LOG.level_procedure,
1896: g_pkg_name || '.' || l_api_name,

Line 1893: FND_LOG.string

1889:
1890: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
1891:
1892: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1893: FND_LOG.string
1894: (
1895: FND_LOG.level_procedure,
1896: g_pkg_name || '.' || l_api_name,
1897: 'ENTERING PROCEDURE: p_txn_number: ' || p_txn_number || ' p_org_id: ' || p_org_id || ' p_txn_header_id: ' || p_txn_header_id ||

Line 1895: FND_LOG.level_procedure,

1891:
1892: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1893: FND_LOG.string
1894: (
1895: FND_LOG.level_procedure,
1896: g_pkg_name || '.' || l_api_name,
1897: 'ENTERING PROCEDURE: p_txn_number: ' || p_txn_number || ' p_org_id: ' || p_org_id || ' p_txn_header_id: ' || p_txn_header_id ||
1898: ' p_collection_id: ' || p_collection_id || ' p_plan_txn_ids: ' || p_plan_txn_ids || ' p_context_values: ' || p_context_values || '
1899: p_context_ids: ' || p_context_ids

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

1920: END IF;
1921:
1922: -- Initialize API return status to success
1923: x_return_status := FND_API.G_RET_STS_SUCCESS;
1924: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1925: FND_LOG.string
1926: (
1927: FND_LOG.level_statement,
1928: g_pkg_name || '.' || l_api_name,

Line 1925: FND_LOG.string

1921:
1922: -- Initialize API return status to success
1923: x_return_status := FND_API.G_RET_STS_SUCCESS;
1924: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1925: FND_LOG.string
1926: (
1927: FND_LOG.level_statement,
1928: g_pkg_name || '.' || l_api_name,
1929: 'BEFORE FIRING MES ERES EVENT'

Line 1927: FND_LOG.level_statement,

1923: x_return_status := FND_API.G_RET_STS_SUCCESS;
1924: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1925: FND_LOG.string
1926: (
1927: FND_LOG.level_statement,
1928: g_pkg_name || '.' || l_api_name,
1929: 'BEFORE FIRING MES ERES EVENT'
1930: );
1931: END IF;

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

1953: IF l_plan_ids.FIRST IS NOT NULL THEN
1954:
1955: FOR i IN l_plan_ids.FIRST .. l_plan_ids.LAST LOOP
1956:
1957: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1958: FND_LOG.string
1959: (
1960: FND_LOG.level_statement,
1961: g_pkg_name || '.' || l_api_name,

Line 1958: FND_LOG.string

1954:
1955: FOR i IN l_plan_ids.FIRST .. l_plan_ids.LAST LOOP
1956:
1957: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1958: FND_LOG.string
1959: (
1960: FND_LOG.level_statement,
1961: g_pkg_name || '.' || l_api_name,
1962: 'BEFORE INSERTING AUTOMATIC RECORDS FOR PLAN_ID: ' || l_plan_ids(i) || ' OCCURRENCE: ' || l_occurrences(i)

Line 1960: FND_LOG.level_statement,

1956:
1957: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1958: FND_LOG.string
1959: (
1960: FND_LOG.level_statement,
1961: g_pkg_name || '.' || l_api_name,
1962: 'BEFORE INSERTING AUTOMATIC RECORDS FOR PLAN_ID: ' || l_plan_ids(i) || ' OCCURRENCE: ' || l_occurrences(i)
1963: );
1964: END IF;

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

1974: p_data_entry_mode => 2, -- Automatic
1975: p_txn_header_id => p_txn_header_id
1976: );
1977:
1978: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1979: FND_LOG.string
1980: (
1981: FND_LOG.level_statement,
1982: g_pkg_name || '.' || l_api_name,

Line 1979: FND_LOG.string

1975: p_txn_header_id => p_txn_header_id
1976: );
1977:
1978: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1979: FND_LOG.string
1980: (
1981: FND_LOG.level_statement,
1982: g_pkg_name || '.' || l_api_name,
1983: 'BEFORE INSERTING HISTORY RECORDS FOR PLAN_ID: ' || l_plan_ids(i) || ' OCCURRENCE: ' || l_occurrences(i)

Line 1981: FND_LOG.level_statement,

1977:
1978: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1979: FND_LOG.string
1980: (
1981: FND_LOG.level_statement,
1982: g_pkg_name || '.' || l_api_name,
1983: 'BEFORE INSERTING HISTORY RECORDS FOR PLAN_ID: ' || l_plan_ids(i) || ' OCCURRENCE: ' || l_occurrences(i)
1984: );
1985: END IF;

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

1998: END LOOP;
1999: END IF; -- l_plan_ids.FIRST is not null
2000:
2001:
2002: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2003: FND_LOG.string
2004: (
2005: FND_LOG.level_statement,
2006: g_pkg_name || '.' || l_api_name,

Line 2003: FND_LOG.string

1999: END IF; -- l_plan_ids.FIRST is not null
2000:
2001:
2002: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2003: FND_LOG.string
2004: (
2005: FND_LOG.level_statement,
2006: g_pkg_name || '.' || l_api_name,
2007: 'BEFORE ENABLING QA RESULTS'

Line 2005: FND_LOG.level_statement,

2001:
2002: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2003: FND_LOG.string
2004: (
2005: FND_LOG.level_statement,
2006: g_pkg_name || '.' || l_api_name,
2007: 'BEFORE ENABLING QA RESULTS'
2008: );
2009: END IF;

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

2007: 'BEFORE ENABLING QA RESULTS'
2008: );
2009: END IF;
2010:
2011: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2012: FND_LOG.string
2013: (
2014: FND_LOG.level_statement,
2015: g_pkg_name || '.' || l_api_name,

Line 2012: FND_LOG.string

2008: );
2009: END IF;
2010:
2011: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2012: FND_LOG.string
2013: (
2014: FND_LOG.level_statement,
2015: g_pkg_name || '.' || l_api_name,
2016: 'BEFORE GENERATING SEQUENCES'

Line 2014: FND_LOG.level_statement,

2010:
2011: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2012: FND_LOG.string
2013: (
2014: FND_LOG.level_statement,
2015: g_pkg_name || '.' || l_api_name,
2016: 'BEFORE GENERATING SEQUENCES'
2017: );
2018: END IF;

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

2027: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2029: END IF;
2030:
2031: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2032: FND_LOG.string
2033: (
2034: FND_LOG.level_statement,
2035: g_pkg_name || '.' || l_api_name,

Line 2032: FND_LOG.string

2028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2029: END IF;
2030:
2031: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2032: FND_LOG.string
2033: (
2034: FND_LOG.level_statement,
2035: g_pkg_name || '.' || l_api_name,
2036: 'BEFORE FIRING BACKGROUND ACTIONS'

Line 2034: FND_LOG.level_statement,

2030:
2031: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2032: FND_LOG.string
2033: (
2034: FND_LOG.level_statement,
2035: g_pkg_name || '.' || l_api_name,
2036: 'BEFORE FIRING BACKGROUND ACTIONS'
2037: );
2038: END IF;

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

2073: p_count => x_msg_count,
2074: p_data => x_msg_data
2075: );
2076:
2077: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2078: FND_LOG.string
2079: (
2080: FND_LOG.level_procedure,
2081: g_pkg_name || '.' || l_api_name,

Line 2078: FND_LOG.string

2074: p_data => x_msg_data
2075: );
2076:
2077: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2078: FND_LOG.string
2079: (
2080: FND_LOG.level_procedure,
2081: g_pkg_name || '.' || l_api_name,
2082: 'EXITING PROCEDURE: SUCCESS'

Line 2080: FND_LOG.level_procedure,

2076:
2077: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2078: FND_LOG.string
2079: (
2080: FND_LOG.level_procedure,
2081: g_pkg_name || '.' || l_api_name,
2082: 'EXITING PROCEDURE: SUCCESS'
2083: );
2084: END IF;

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

2094: p_count => x_msg_count,
2095: p_data => x_msg_data
2096: );
2097:
2098: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2099: FND_LOG.string
2100: (
2101: FND_LOG.level_procedure,
2102: g_pkg_name || '.' || l_api_name,

Line 2099: FND_LOG.string

2095: p_data => x_msg_data
2096: );
2097:
2098: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2099: FND_LOG.string
2100: (
2101: FND_LOG.level_procedure,
2102: g_pkg_name || '.' || l_api_name,
2103: 'EXITING PROCEDURE: ERROR'

Line 2101: FND_LOG.level_procedure,

2097:
2098: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2099: FND_LOG.string
2100: (
2101: FND_LOG.level_procedure,
2102: g_pkg_name || '.' || l_api_name,
2103: 'EXITING PROCEDURE: ERROR'
2104: );
2105: END IF;

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

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

Line 2117: FND_LOG.string

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

Line 2119: FND_LOG.level_procedure,

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

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

2145: p_count => x_msg_count,
2146: p_data => x_msg_data
2147: );
2148:
2149: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2150: FND_LOG.string
2151: (
2152: FND_LOG.level_procedure,
2153: g_pkg_name || '.' || l_api_name,

Line 2150: FND_LOG.string

2146: p_data => x_msg_data
2147: );
2148:
2149: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2150: FND_LOG.string
2151: (
2152: FND_LOG.level_procedure,
2153: g_pkg_name || '.' || l_api_name,
2154: 'EXITING PROCEDURE: ERROR'

Line 2152: FND_LOG.level_procedure,

2148:
2149: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2150: FND_LOG.string
2151: (
2152: FND_LOG.level_procedure,
2153: g_pkg_name || '.' || l_api_name,
2154: 'EXITING PROCEDURE: ERROR'
2155: );
2156: END IF;

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

2178: BEGIN
2179:
2180: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
2181:
2182: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2183: FND_LOG.string
2184: (
2185: FND_LOG.level_procedure,
2186: g_pkg_name || '.' || l_api_name,

Line 2183: FND_LOG.string

2179:
2180: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
2181:
2182: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2183: FND_LOG.string
2184: (
2185: FND_LOG.level_procedure,
2186: g_pkg_name || '.' || l_api_name,
2187: 'ENTERING PROCEDURE' );

Line 2185: FND_LOG.level_procedure,

2181:
2182: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2183: FND_LOG.string
2184: (
2185: FND_LOG.level_procedure,
2186: g_pkg_name || '.' || l_api_name,
2187: 'ENTERING PROCEDURE' );
2188: END IF;
2189:

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

2207: END IF;
2208:
2209: -- Initialize API return status to success
2210: x_return_status := FND_API.G_RET_STS_SUCCESS;
2211: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2212: FND_LOG.string
2213: (
2214: FND_LOG.level_statement,
2215: g_pkg_name || '.' || l_api_name,

Line 2212: FND_LOG.string

2208:
2209: -- Initialize API return status to success
2210: x_return_status := FND_API.G_RET_STS_SUCCESS;
2211: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2212: FND_LOG.string
2213: (
2214: FND_LOG.level_statement,
2215: g_pkg_name || '.' || l_api_name,
2216: 'BEFORE ENABLING RESULTS'

Line 2214: FND_LOG.level_statement,

2210: x_return_status := FND_API.G_RET_STS_SUCCESS;
2211: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2212: FND_LOG.string
2213: (
2214: FND_LOG.level_statement,
2215: g_pkg_name || '.' || l_api_name,
2216: 'BEFORE ENABLING RESULTS'
2217: );
2218: END IF;

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

2220: UPDATE qa_results
2221: SET status=2
2222: WHERE collection_id = p_collection_id;
2223:
2224: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2225: FND_LOG.string
2226: (
2227: FND_LOG.level_statement,
2228: g_pkg_name || '.' || l_api_name,

Line 2225: FND_LOG.string

2221: SET status=2
2222: WHERE collection_id = p_collection_id;
2223:
2224: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2225: FND_LOG.string
2226: (
2227: FND_LOG.level_statement,
2228: g_pkg_name || '.' || l_api_name,
2229: 'BEFORE FIRING BACKGROUND ACTIONS'

Line 2227: FND_LOG.level_statement,

2223:
2224: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
2225: FND_LOG.string
2226: (
2227: FND_LOG.level_statement,
2228: g_pkg_name || '.' || l_api_name,
2229: 'BEFORE FIRING BACKGROUND ACTIONS'
2230: );
2231: END IF;

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

2257: p_count => x_msg_count,
2258: p_data => x_msg_data
2259: );
2260:
2261: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2262: FND_LOG.string
2263: (
2264: FND_LOG.level_procedure,
2265: g_pkg_name || '.' || l_api_name,

Line 2262: FND_LOG.string

2258: p_data => x_msg_data
2259: );
2260:
2261: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2262: FND_LOG.string
2263: (
2264: FND_LOG.level_procedure,
2265: g_pkg_name || '.' || l_api_name,
2266: 'EXITING PROCEDURE: SUCCESS'

Line 2264: FND_LOG.level_procedure,

2260:
2261: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2262: FND_LOG.string
2263: (
2264: FND_LOG.level_procedure,
2265: g_pkg_name || '.' || l_api_name,
2266: 'EXITING PROCEDURE: SUCCESS'
2267: );
2268: END IF;

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

2277: p_count => x_msg_count,
2278: p_data => x_msg_data
2279: );
2280:
2281: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2282: FND_LOG.string
2283: (
2284: FND_LOG.level_procedure,
2285: g_pkg_name || '.' || l_api_name,

Line 2282: FND_LOG.string

2278: p_data => x_msg_data
2279: );
2280:
2281: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2282: FND_LOG.string
2283: (
2284: FND_LOG.level_procedure,
2285: g_pkg_name || '.' || l_api_name,
2286: 'EXITING PROCEDURE: ERROR'

Line 2284: FND_LOG.level_procedure,

2280:
2281: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2282: FND_LOG.string
2283: (
2284: FND_LOG.level_procedure,
2285: g_pkg_name || '.' || l_api_name,
2286: 'EXITING PROCEDURE: ERROR'
2287: );
2288: 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: ERROR'

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: ERROR'
2305: );
2306: END IF;

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

2328: p_count => x_msg_count,
2329: p_data => x_msg_data
2330: );
2331:
2332: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2333: FND_LOG.string
2334: (
2335: FND_LOG.level_procedure,
2336: g_pkg_name || '.' || l_api_name,

Line 2333: FND_LOG.string

2329: p_data => x_msg_data
2330: );
2331:
2332: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2333: FND_LOG.string
2334: (
2335: FND_LOG.level_procedure,
2336: g_pkg_name || '.' || l_api_name,
2337: 'EXITING PROCEDURE: ERROR'

Line 2335: FND_LOG.level_procedure,

2331:
2332: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
2333: FND_LOG.string
2334: (
2335: FND_LOG.level_procedure,
2336: g_pkg_name || '.' || l_api_name,
2337: 'EXITING PROCEDURE: ERROR'
2338: );
2339: END IF;