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 351: -- Note: oe_debug_pub is part of 11i baseline

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1662: WHERE organization_id = l_org_id;
1663:
1664: EXCEPTION
1665: WHEN NO_DATA_FOUND THEN
1666: oe_debug_pub.add( 'Organization ' || l_org_id || ' has no Item Master'
1667: , 2 );
1668: RETURN 'N';
1669: WHEN OTHERS THEN
1670: oe_debug_pub.add( '(SQL EXCEPTION: Item Master for Organization '

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

1666: oe_debug_pub.add( 'Organization ' || l_org_id || ' has no Item Master'
1667: , 2 );
1668: RETURN 'N';
1669: WHEN OTHERS THEN
1670: oe_debug_pub.add( '(SQL EXCEPTION: Item Master for Organization '
1671: || l_org_id || ')', 2 );
1672: RAISE;
1673: END;
1674:

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

1692:
1693: IF l_master_org_count = 0 THEN
1694: RETURN 'Y';
1695: ELSE
1696: oe_debug_pub.add( 'Organizations do not share unique Item Master', 2 );
1697: RETURN 'N';
1698: END IF;
1699:
1700:

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

1720: AND set_of_books_id = TO_NUMBER(org_information1);
1721:
1722: EXCEPTION
1723: WHEN NO_DATA_FOUND THEN
1724: oe_debug_pub.add( 'Organization ' || l_org_id || ' has no GL Calendar'
1725: , 2 );
1726: RETURN 'N';
1727: WHEN OTHERS THEN
1728: oe_debug_pub.add( '(SQL EXCEPTION: period_set_name for organization '

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

1724: oe_debug_pub.add( 'Organization ' || l_org_id || ' has no GL Calendar'
1725: , 2 );
1726: RETURN 'N';
1727: WHEN OTHERS THEN
1728: oe_debug_pub.add( '(SQL EXCEPTION: period_set_name for organization '
1729: || l_org_id || ')', 2 );
1730: RAISE;
1731: END;
1732:

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

1757:
1758: IF l_calendar_count = 0 THEN
1759: RETURN 'Y';
1760: ELSE
1761: oe_debug_pub.add( 'Organizations do not share unique GL calendar', 2 );
1762: RETURN 'N';
1763: END IF;
1764:
1765:

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

1784: AND set_of_books_id = TO_NUMBER(org_information1);
1785:
1786: EXCEPTION
1787: WHEN NO_DATA_FOUND THEN
1788: oe_debug_pub.add( 'Organization ' || l_org_id || ' has no COA', 2 );
1789: RETURN 'N';
1790: WHEN OTHERS THEN
1791: oe_debug_pub.add( '(SQL EXCEPTION: COA for organization ' || l_org_id || ')', 2 );
1792: RAISE;

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

1787: WHEN NO_DATA_FOUND THEN
1788: oe_debug_pub.add( 'Organization ' || l_org_id || ' has no COA', 2 );
1789: RETURN 'N';
1790: WHEN OTHERS THEN
1791: oe_debug_pub.add( '(SQL EXCEPTION: COA for organization ' || l_org_id || ')', 2 );
1792: RAISE;
1793: END;
1794:
1795: -- Bug :3296392 : Modified the following logic to exit immedidately after

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

1818:
1819: IF l_chart_of_accounts_count = 0 THEN
1820: RETURN 'Y';
1821: ELSE
1822: oe_debug_pub.add( 'Organizations do not share unique COA', 2 );
1823: RETURN 'N';
1824: END IF;
1825:
1826: END IF;

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

1827: EXCEPTION
1828: WHEN OTHERS THEN
1829: l_errorcode := SQLCODE;
1830: l_errortext := SUBSTR( SQLERRM, 1, 200 );
1831: oe_debug_pub.add( to_char( l_errorcode ) || l_errortext, 1 );
1832:
1833: RETURN 'N';
1834:
1835: END validate_property;