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.INV_ORGHIERARCHY_PVT dependencies on OE_DEBUG_PUB

Line 348: -- Note: oe_debug_pub is part of 11i baseline

344: l_business_group_id :=
345: TO_NUMBER( FND_PROFILE.VALUE( 'PER_BUSINESS_GROUP_ID' ) );
346:
347:
348: -- Note: oe_debug_pub is part of 11i baseline
349: oe_debug_pub.add( 'Responsibility Id: ' || l_responsibility_id, 2 );
350: oe_debug_pub.add( 'Security Profile Id: ' || l_security_profile_id, 2 );
351: oe_debug_pub.add( 'Business Group Id: ' || l_business_group_id, 2 );
352:

Line 349: oe_debug_pub.add( 'Responsibility Id: ' || l_responsibility_id, 2 );

345: TO_NUMBER( FND_PROFILE.VALUE( 'PER_BUSINESS_GROUP_ID' ) );
346:
347:
348: -- Note: oe_debug_pub is part of 11i baseline
349: oe_debug_pub.add( 'Responsibility Id: ' || l_responsibility_id, 2 );
350: oe_debug_pub.add( 'Security Profile Id: ' || l_security_profile_id, 2 );
351: oe_debug_pub.add( 'Business Group Id: ' || l_business_group_id, 2 );
352:
353:

Line 350: oe_debug_pub.add( 'Security Profile Id: ' || l_security_profile_id, 2 );

346:
347:
348: -- Note: oe_debug_pub is part of 11i baseline
349: oe_debug_pub.add( 'Responsibility Id: ' || l_responsibility_id, 2 );
350: oe_debug_pub.add( 'Security Profile Id: ' || l_security_profile_id, 2 );
351: oe_debug_pub.add( 'Business Group Id: ' || l_business_group_id, 2 );
352:
353:
354:

Line 351: oe_debug_pub.add( 'Business Group Id: ' || l_business_group_id, 2 );

347:
348: -- Note: oe_debug_pub is part of 11i baseline
349: oe_debug_pub.add( 'Responsibility Id: ' || l_responsibility_id, 2 );
350: oe_debug_pub.add( 'Security Profile Id: ' || l_security_profile_id, 2 );
351: oe_debug_pub.add( 'Business Group Id: ' || l_business_group_id, 2 );
352:
353:
354:
355: SELECT

Line 375: oe_debug_pub.add( 'View All:' || l_view_all_flag, 2 );

371: prof.security_profile_id = l_security_profile_id
372: AND hier.organization_structure_id (+) = prof.organization_structure_id
373: ;
374:
375: oe_debug_pub.add( 'View All:' || l_view_all_flag, 2 );
376: oe_debug_pub.add( 'Include Origin:' || l_include_origin_flag, 2 );
377: oe_debug_pub.add( 'Security Hieararchy Name:' || l_sec_hierarchy_name, 2 );
378:
379:

Line 376: oe_debug_pub.add( 'Include Origin:' || l_include_origin_flag, 2 );

372: AND hier.organization_structure_id (+) = prof.organization_structure_id
373: ;
374:
375: oe_debug_pub.add( 'View All:' || l_view_all_flag, 2 );
376: oe_debug_pub.add( 'Include Origin:' || l_include_origin_flag, 2 );
377: oe_debug_pub.add( 'Security Hieararchy Name:' || l_sec_hierarchy_name, 2 );
378:
379:
380: SELECT

Line 377: oe_debug_pub.add( 'Security Hieararchy Name:' || l_sec_hierarchy_name, 2 );

373: ;
374:
375: oe_debug_pub.add( 'View All:' || l_view_all_flag, 2 );
376: oe_debug_pub.add( 'Include Origin:' || l_include_origin_flag, 2 );
377: oe_debug_pub.add( 'Security Hieararchy Name:' || l_sec_hierarchy_name, 2 );
378:
379:
380: SELECT
381: hierv.org_structure_version_id

Line 395: oe_debug_pub.add( 'Hierarchy Version Id:' || l_hierarchy_version_id, 2 );

391: AND hierv.date_from <= SYSDATE
392: ;
393:
394:
395: oe_debug_pub.add( 'Hierarchy Version Id:' || l_hierarchy_version_id, 2 );
396:
397:
398: BEGIN
399: SELECT

Line 421: oe_debug_pub.add( 'Security Hierarchy Version Id:' || l_sec_hierarchy_version_id, 2 );

417: -- l_sec_origin_org_id := p_origin_org_id;
418: l_include_origin_flag := 'Y';
419: END;
420:
421: oe_debug_pub.add( 'Security Hierarchy Version Id:' || l_sec_hierarchy_version_id, 2 );
422: oe_debug_pub.add( 'Security Origin Org Id:' || l_sec_origin_org_id, 2 );
423:
424:
425: IF l_sec_hierarchy_version_id IS NOT NULL

Line 422: oe_debug_pub.add( 'Security Origin Org Id:' || l_sec_origin_org_id, 2 );

418: l_include_origin_flag := 'Y';
419: END;
420:
421: oe_debug_pub.add( 'Security Hierarchy Version Id:' || l_sec_hierarchy_version_id, 2 );
422: oe_debug_pub.add( 'Security Origin Org Id:' || l_sec_origin_org_id, 2 );
423:
424:
425: IF l_sec_hierarchy_version_id IS NOT NULL
426: AND l_sec_origin_org_id IS NOT NULL

Line 434: -- oe_debug_pub.add( ' org id: ' || l_org_id.organization_id_child, 2 );

430:
431: x_org_id_tbl( NVL( x_org_id_tbl.LAST, 0 ) + 1 ) :=
432: l_org_id.organization_id_child;
433:
434: -- oe_debug_pub.add( ' org id: ' || l_org_id.organization_id_child, 2 );
435: END LOOP;
436:
437: ELSIF l_sec_hierarchy_version_id IS NOT NULL
438: AND l_sec_origin_org_id IS NULL

Line 1289: oe_debug_pub.add( 'Organization ' || l_org_id || ' has no Item Master'

1285: WHERE organization_id = l_org_id;
1286:
1287: EXCEPTION
1288: WHEN NO_DATA_FOUND THEN
1289: oe_debug_pub.add( 'Organization ' || l_org_id || ' has no Item Master'
1290: , 2 );
1291: RETURN 'N';
1292: WHEN OTHERS THEN
1293: oe_debug_pub.add( '(SQL EXCEPTION: Item Master for Organization '

Line 1293: oe_debug_pub.add( '(SQL EXCEPTION: Item Master for Organization '

1289: oe_debug_pub.add( 'Organization ' || l_org_id || ' has no Item Master'
1290: , 2 );
1291: RETURN 'N';
1292: WHEN OTHERS THEN
1293: oe_debug_pub.add( '(SQL EXCEPTION: Item Master for Organization '
1294: || l_org_id || ')', 2 );
1295: RAISE;
1296: END;
1297:

Line 1319: oe_debug_pub.add( 'Organizations do not share unique Item Master', 2 );

1315:
1316: IF l_master_org_count = 0 THEN
1317: RETURN 'Y';
1318: ELSE
1319: oe_debug_pub.add( 'Organizations do not share unique Item Master', 2 );
1320: RETURN 'N';
1321: END IF;
1322:
1323:

Line 1347: oe_debug_pub.add( 'Organization ' || l_org_id || ' has no GL Calendar'

1343: AND set_of_books_id = TO_NUMBER(org_information1);
1344:
1345: EXCEPTION
1346: WHEN NO_DATA_FOUND THEN
1347: oe_debug_pub.add( 'Organization ' || l_org_id || ' has no GL Calendar'
1348: , 2 );
1349: RETURN 'N';
1350: WHEN OTHERS THEN
1351: oe_debug_pub.add( '(SQL EXCEPTION: period_set_name for organization '

Line 1351: oe_debug_pub.add( '(SQL EXCEPTION: period_set_name for organization '

1347: oe_debug_pub.add( 'Organization ' || l_org_id || ' has no GL Calendar'
1348: , 2 );
1349: RETURN 'N';
1350: WHEN OTHERS THEN
1351: oe_debug_pub.add( '(SQL EXCEPTION: period_set_name for organization '
1352: || l_org_id || ')', 2 );
1353: RAISE;
1354: END;
1355:

Line 1384: oe_debug_pub.add( 'Organizations do not share unique GL calendar', 2 );

1380:
1381: IF l_calendar_count = 0 THEN
1382: RETURN 'Y';
1383: ELSE
1384: oe_debug_pub.add( 'Organizations do not share unique GL calendar', 2 );
1385: RETURN 'N';
1386: END IF;
1387:
1388:

Line 1411: oe_debug_pub.add( 'Organization ' || l_org_id || ' has no COA', 2 );

1407: AND set_of_books_id = TO_NUMBER(org_information1);
1408:
1409: EXCEPTION
1410: WHEN NO_DATA_FOUND THEN
1411: oe_debug_pub.add( 'Organization ' || l_org_id || ' has no COA', 2 );
1412: RETURN 'N';
1413: WHEN OTHERS THEN
1414: oe_debug_pub.add( '(SQL EXCEPTION: COA for organization ' || l_org_id || ')', 2 );
1415: RAISE;

Line 1414: oe_debug_pub.add( '(SQL EXCEPTION: COA for organization ' || l_org_id || ')', 2 );

1410: WHEN NO_DATA_FOUND THEN
1411: oe_debug_pub.add( 'Organization ' || l_org_id || ' has no COA', 2 );
1412: RETURN 'N';
1413: WHEN OTHERS THEN
1414: oe_debug_pub.add( '(SQL EXCEPTION: COA for organization ' || l_org_id || ')', 2 );
1415: RAISE;
1416: END;
1417:
1418: -- Bug :3296392 : Modified the following logic to exit immedidately after

Line 1445: oe_debug_pub.add( 'Organizations do not share unique COA', 2 );

1441:
1442: IF l_chart_of_accounts_count = 0 THEN
1443: RETURN 'Y';
1444: ELSE
1445: oe_debug_pub.add( 'Organizations do not share unique COA', 2 );
1446: RETURN 'N';
1447: END IF;
1448:
1449: END IF;

Line 1454: oe_debug_pub.add( to_char( l_errorcode ) || l_errortext, 1 );

1450: EXCEPTION
1451: WHEN OTHERS THEN
1452: l_errorcode := SQLCODE;
1453: l_errortext := SUBSTR( SQLERRM, 1, 200 );
1454: oe_debug_pub.add( to_char( l_errorcode ) || l_errortext, 1 );
1455:
1456: RETURN 'N';
1457:
1458: END validate_property;