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.AMW_ORG_HIERARCHY_PKG dependencies on AMW_ORG_HIERARCHY_PKG

Line 1: PACKAGE BODY AMW_ORG_HIERARCHY_PKG as

1: PACKAGE BODY AMW_ORG_HIERARCHY_PKG as
2: /*$Header: amwoghrb.pls 120.16.12000000.4 2007/04/19 10:34:39 shelango ship $*/
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_ORG_HIERARCHY_PKG';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_ORG_HIERARCHY_PKG';

1: PACKAGE BODY AMW_ORG_HIERARCHY_PKG as
2: /*$Header: amwoghrb.pls 120.16.12000000.4 2007/04/19 10:34:39 shelango ship $*/
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_ORG_HIERARCHY_PKG';
6: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amwoghrb.pls';
7: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
8: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
9:

Line 518: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.Begin',

514: l_log_stmt_level number := FND_LOG.LEVEL_STATEMENT;
515:
516: begin
517: if( l_log_stmt_level >= l_curr_log_level ) then
518: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.Begin',
519: 'p_org_id:'||p_org_id ||';p_parent_process_id:'||p_parent_process_id ||';p_child_process_id:'||p_child_process_id ||';p_action:'||'ADD');
520: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.produce_err_if_circular',
521: p_org_id ||';'||p_parent_process_id ||';'||p_child_process_id);
522: end if;

Line 520: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.produce_err_if_circular',

516: begin
517: if( l_log_stmt_level >= l_curr_log_level ) then
518: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.Begin',
519: 'p_org_id:'||p_org_id ||';p_parent_process_id:'||p_parent_process_id ||';p_child_process_id:'||p_child_process_id ||';p_action:'||'ADD');
520: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.produce_err_if_circular',
521: p_org_id ||';'||p_parent_process_id ||';'||p_child_process_id);
522: end if;
523:
524: -- check for potential circular hierarchy formation

Line 534: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.revise_process_if_necessary',

530:
531: -- find out if the latest revision for parent_id is approved or not.
532: -- if approved, revise it. if draft, don't do anything
533: if( l_log_stmt_level >= l_curr_log_level ) then
534: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.revise_process_if_necessary',
535: p_org_id ||';'||p_parent_process_id );
536: end if;
537: revise_process_if_necessary(p_org_id, p_parent_process_id);
538:

Line 565: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.write_approved_hierarchy',

561: -- to the amw_approved_hierarchies table.
562: if p_parent_process_id = -2 then
563: if p_action = 'ADD' then
564: if( l_log_stmt_level >= l_curr_log_level ) then
565: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.write_approved_hierarchy',
566: '-2;0;'||p_org_id ||':'||sysdate);
567: end if;
568: AMW_PROC_ORG_APPROVAL_PKG.write_approved_hierarchy(-2, 0, p_org_id,sysdate);
569: elsif p_action = 'DEL' then

Line 571: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.write_approved_hierarchy',

567: end if;
568: AMW_PROC_ORG_APPROVAL_PKG.write_approved_hierarchy(-2, 0, p_org_id,sysdate);
569: elsif p_action = 'DEL' then
570: if( l_log_stmt_level >= l_curr_log_level ) then
571: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.write_approved_hierarchy',
572: '-2;2;'||p_org_id ||':'||sysdate);
573: end if;
574: AMW_PROC_ORG_APPROVAL_PKG.write_approved_hierarchy(-2, 2, p_org_id,sysdate);
575: end if;

Line 577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.write_approved_hierarchy',

573: end if;
574: AMW_PROC_ORG_APPROVAL_PKG.write_approved_hierarchy(-2, 2, p_org_id,sysdate);
575: end if;
576: if( l_log_stmt_level >= l_curr_log_level ) then
577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.write_approved_hierarchy',
578: '-2;3;'||p_org_id ||':'||sysdate);
579: end if;
580: AMW_PROC_ORG_APPROVAL_PKG.write_approved_hierarchy(-2, 3, p_org_id,sysdate);
581:

Line 583: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.write_approved_hierarchy',

579: end if;
580: AMW_PROC_ORG_APPROVAL_PKG.write_approved_hierarchy(-2, 3, p_org_id,sysdate);
581:
582: if( l_log_stmt_level >= l_curr_log_level ) then
583: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.write_approved_hierarchy',
584: 'WRITE_APPROVED_HIERARCHY_END');
585: end if;
586: end if;
587:

Line 589: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.End',

585: end if;
586: end if;
587:
588: if( l_log_stmt_level >= l_curr_log_level ) then
589: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.End',
590: 'End');
591: end if;
592:
593: end add_delete_ex_child;

Line 728: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.IMPORT_RLPROC_AS_CHILD_OF_EX.begin',

724: l_log_stmt_level number := FND_LOG.LEVEL_STATEMENT;
725: begin
726: if( l_log_stmt_level >= l_curr_log_level ) then
727: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
728: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.IMPORT_RLPROC_AS_CHILD_OF_EX.begin',
729: 'OrgId:' ||p_org_id || ';ProcessId:'||p_child_process_id
730: ||';ParentProcessId:'||p_parent_process_id||';ApplyRCM:'||apply_rcm);
731: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
732: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.IMPORT_RLPROC_AS_CHILD_OF_EX.produce_err_if_circular','produce_err_if_circular');

Line 732: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.IMPORT_RLPROC_AS_CHILD_OF_EX.produce_err_if_circular','produce_err_if_circular');

728: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.IMPORT_RLPROC_AS_CHILD_OF_EX.begin',
729: 'OrgId:' ||p_org_id || ';ProcessId:'||p_child_process_id
730: ||';ParentProcessId:'||p_parent_process_id||';ApplyRCM:'||apply_rcm);
731: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
732: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.IMPORT_RLPROC_AS_CHILD_OF_EX.produce_err_if_circular','produce_err_if_circular');
733: end if;
734: -- check for potential circular hierarchy formation
735: produce_err_if_circular(
736: p_org_id => p_org_id,

Line 745: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.IMPORT_RLPROC_AS_CHILD_OF_EX.revise_process_if_necessary','Revise parent:'|| p_parent_process_id );

741: -- if approved, revise it. if draft, don't do anything
742:
743: if( l_log_stmt_level >= l_curr_log_level ) then
744: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
745: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.IMPORT_RLPROC_AS_CHILD_OF_EX.revise_process_if_necessary','Revise parent:'|| p_parent_process_id );
746: end if;
747: revise_process_if_necessary(p_org_id, p_parent_process_id);
748:
749: if( l_log_stmt_level >= l_curr_log_level ) then

Line 751: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.IMPORT_RLPROC_AS_CHILD_OF_EX.insert Row','Insert Row' );

747: revise_process_if_necessary(p_org_id, p_parent_process_id);
748:
749: if( l_log_stmt_level >= l_curr_log_level ) then
750: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
751: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.IMPORT_RLPROC_AS_CHILD_OF_EX.insert Row','Insert Row' );
752: end if;
753:
754: --insert into amw_process_organization table
755: insert into amw_process_organization

Line 843: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.IMPORT_RLPROC_AS_CHILD_OF_EX.insert_latest_hierarchy','insert_latest_hierarchy' );

839: and approval_end_date is null);
840:
841: if( l_log_stmt_level >= l_curr_log_level ) then
842: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
843: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.IMPORT_RLPROC_AS_CHILD_OF_EX.insert_latest_hierarchy','insert_latest_hierarchy' );
844: end if;
845: --insert into latest hierarchy table
846: insert into amw_latest_hierarchies
847: (ORGANIZATION_ID, PARENT_ID, CHILD_ID, CHILD_ORDER_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY, object_version_number)

Line 854: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.IMPORT_RLPROC_AS_CHILD_OF_EX.import_process_attributes',

850:
851:
852: -- import process objectives, key accounts, significant elements
853: if( l_log_stmt_level >= l_curr_log_level ) then
854: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.IMPORT_RLPROC_AS_CHILD_OF_EX.import_process_attributes',
855: 'p_child_process_id:' || p_child_process_id || ';p_org_id:'||p_org_id );
856: end if;
857: import_process_attributes(p_child_process_id, p_org_id);
858:

Line 862: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.IMPORT_RLPROC_AS_CHILD_OF_EX.import_rcm_for_new_orgprocess',

858:
859: -- import rcm
860: if apply_rcm = 'Y' then
861: if( l_log_stmt_level >= l_curr_log_level ) then
862: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.IMPORT_RLPROC_AS_CHILD_OF_EX.import_rcm_for_new_orgprocess',
863: 'p_child_process_id:' || p_child_process_id || ';p_org_id:'||p_org_id );
864: end if;
865: import_rcm_for_new_orgprocess(p_child_process_id, p_org_id);
866: end if;

Line 1604: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_PROCESS_TO_ORG.begin',

1600:
1601: begin
1602:
1603: if( l_log_stmt_level >= l_curr_log_level ) then
1604: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_PROCESS_TO_ORG.begin',
1605: 'OrgId:' ||p_org_id || ';ProcessId:'||p_associated_proc_id
1606: ||';ParentProcessId:'||p_parent_process_id||';reviseExisting:'||p_revise_existing||';ApplyRCM:'||p_apply_rcm);
1607: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_PROCESS_TO_ORG.does_process_exist_in_org',
1608: 'p_associated_proc_id:'||p_associated_proc_id||';p_org_id:'||p_org_id);

Line 1607: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_PROCESS_TO_ORG.does_process_exist_in_org',

1603: if( l_log_stmt_level >= l_curr_log_level ) then
1604: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_PROCESS_TO_ORG.begin',
1605: 'OrgId:' ||p_org_id || ';ProcessId:'||p_associated_proc_id
1606: ||';ParentProcessId:'||p_parent_process_id||';reviseExisting:'||p_revise_existing||';ApplyRCM:'||p_apply_rcm);
1607: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_PROCESS_TO_ORG.does_process_exist_in_org',
1608: 'p_associated_proc_id:'||p_associated_proc_id||';p_org_id:'||p_org_id);
1609: end if;
1610: pex := does_process_exist_in_org(p_associated_proc_id, p_org_id);
1611: if pex = 'N' then

Line 1615: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_PROCESS_TO_ORG.import_rlproc_as_child_of_ex',

1611: if pex = 'N' then
1612: -- The process is not existing in the organziation...
1613: -- When the process is not existing in the system, apply_rcm is always true....so pass 'Y' in the apply rcm parameter.
1614: if( l_log_stmt_level >= l_curr_log_level ) then
1615: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_PROCESS_TO_ORG.import_rlproc_as_child_of_ex',
1616: p_org_id||';'||p_parent_process_id||';'||p_associated_proc_id||';'||'Y');
1617: end if;
1618: import_rlproc_as_child_of_ex (p_org_id, p_parent_process_id, p_associated_proc_id, 'Y');
1619:

Line 1621: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_PROCESS_TO_ORG.associate_hierarchy',

1617: end if;
1618: import_rlproc_as_child_of_ex (p_org_id, p_parent_process_id, p_associated_proc_id, 'Y');
1619:
1620: if( l_log_stmt_level >= l_curr_log_level ) then
1621: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_PROCESS_TO_ORG.associate_hierarchy',
1622: p_associated_proc_id ||';'||p_org_id ||';'||p_revise_existing ||';'||p_apply_rcm);
1623: end if;
1624: associate_hierarchy(p_associated_proc_id, p_org_id, p_revise_existing, p_apply_rcm);
1625:

Line 1628: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_PROCESS_TO_ORG.undelete',

1624: associate_hierarchy(p_associated_proc_id, p_org_id, p_revise_existing, p_apply_rcm);
1625:
1626: elsif pex = 'D' then --The process is existing in the system some time back and got deleted. so undelete it and sync up..
1627: if( l_log_stmt_level >= l_curr_log_level ) then
1628: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_PROCESS_TO_ORG.undelete',
1629: p_associated_proc_id ||';'||p_org_id );
1630: end if;
1631: undelete(p_associated_proc_id, p_org_id);
1632: if( l_log_stmt_level >= l_curr_log_level ) then

Line 1633: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_PROCESS_TO_ORG.add_delete_ex_child',

1629: p_associated_proc_id ||';'||p_org_id );
1630: end if;
1631: undelete(p_associated_proc_id, p_org_id);
1632: if( l_log_stmt_level >= l_curr_log_level ) then
1633: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_PROCESS_TO_ORG.add_delete_ex_child',
1634: p_org_id ||';'||p_parent_process_id ||';'||p_associated_proc_id ||';'||'ADD');
1635: end if;
1636: add_delete_ex_child (p_org_id, p_parent_process_id, p_associated_proc_id, 'ADD');
1637: if( l_log_stmt_level >= l_curr_log_level ) then

Line 1638: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_PROCESS_TO_ORG.Synchronize_process',

1634: p_org_id ||';'||p_parent_process_id ||';'||p_associated_proc_id ||';'||'ADD');
1635: end if;
1636: add_delete_ex_child (p_org_id, p_parent_process_id, p_associated_proc_id, 'ADD');
1637: if( l_log_stmt_level >= l_curr_log_level ) then
1638: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_PROCESS_TO_ORG.Synchronize_process',
1639: p_org_id ||';'||p_associated_proc_id);
1640: end if;
1641: Synchronize_process(p_org_id => p_org_id,
1642: p_process_id => p_associated_proc_id,

Line 1650: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_PROCESS_TO_ORG.associate_hierarchy',

1646: p_sync_rcm => 'SLIB', -- Sync with the library definition...
1647: p_sync_people => 'SLIB' -- Sync with library definition....
1648: );
1649: if( l_log_stmt_level >= l_curr_log_level ) then
1650: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_PROCESS_TO_ORG.associate_hierarchy',
1651: p_associated_proc_id ||';'||p_org_id||';'||p_revise_existing||';'||p_apply_rcm);
1652: end if;
1653: associate_hierarchy(p_associated_proc_id, p_org_id, p_revise_existing, p_apply_rcm);
1654: end if;

Line 1657: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_PROCESS_TO_ORG.End',

1653: associate_hierarchy(p_associated_proc_id, p_org_id, p_revise_existing, p_apply_rcm);
1654: end if;
1655:
1656: if( l_log_stmt_level >= l_curr_log_level ) then
1657: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_PROCESS_TO_ORG.End',
1658: 'End');
1659: end if;
1660: end associate_process_to_org;
1661:

Line 1704: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_HIERARCHY.begin',

1700:
1701: begin
1702: if( l_log_stmt_level >= l_curr_log_level ) then
1703: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1704: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_HIERARCHY.begin',
1705: ' OrgId:' ||p_org_id ||';ParentProcessId:'||p_parent_process_id||';reviseExisting:'||p_revise_existing||';ApplyRCM:'||p_apply_rcm);
1706: end if;
1707:
1708: for c1_rec in c1(p_parent_process_id) loop

Line 1713: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_HIERARCHY.does_process_exist_in_org',l_child_process_id||';'||p_org_id);

1709: exit when c1%notfound;
1710: l_child_process_id := c1_rec.child_process_id;
1711: if( l_log_stmt_level >= l_curr_log_level ) then
1712: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1713: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_HIERARCHY.does_process_exist_in_org',l_child_process_id||';'||p_org_id);
1714: end if;
1715: pex := does_process_exist_in_org(l_child_process_id, p_org_id);
1716:
1717: -- case 1: l_process_id does not exist in the org

Line 1722: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_HIERARCHY.import_rlproc_as_child_of_ex',

1718: if pex = 'N' then
1719: -- Apply RCM is Yes for a new process.....
1720: if( l_log_stmt_level >= l_curr_log_level ) then
1721: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1722: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_HIERARCHY.import_rlproc_as_child_of_ex',
1723: p_org_id||';'||p_parent_process_id||';'||l_child_process_id||';'||'Y');
1724: end if;
1725: import_rlproc_as_child_of_ex(p_org_id, p_parent_process_id, l_child_process_id, 'Y');
1726: if( l_log_stmt_level >= l_curr_log_level ) then

Line 1728: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_HIERARCHY.associate_hierarchy',

1724: end if;
1725: import_rlproc_as_child_of_ex(p_org_id, p_parent_process_id, l_child_process_id, 'Y');
1726: if( l_log_stmt_level >= l_curr_log_level ) then
1727: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1728: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_HIERARCHY.associate_hierarchy',
1729: l_child_process_id||';'||p_org_id||';'||p_revise_existing||';'||p_apply_rcm);
1730: end if;
1731: associate_hierarchy(l_child_process_id, p_org_id, p_revise_existing, p_apply_rcm);
1732: -- case 2: l_process_id exists in the org

Line 1735: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_HIERARCHY.add_delete_ex_child',

1731: associate_hierarchy(l_child_process_id, p_org_id, p_revise_existing, p_apply_rcm);
1732: -- case 2: l_process_id exists in the org
1733: elsif pex = 'Y' then
1734: if( l_log_stmt_level >= l_curr_log_level ) then
1735: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_HIERARCHY.add_delete_ex_child',
1736: p_org_id ||';'||p_parent_process_id ||';'||l_child_process_id ||';'||'ADD');
1737: end if;
1738: add_delete_ex_child (p_org_id, p_parent_process_id, l_child_process_id, 'ADD');
1739: if p_revise_existing = 'Y' then

Line 1744: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_HIERARCHY.Synchronize_process',

1740: -- Don't need the following line..sync process handles this..
1741: --produce_err_if_pa_or_locked(p_org_id, l_child_process_id);
1742: -- User want to synchronize the changes..so do sync up the process..apply_rcm is passed by user for the existing processes.
1743: if( l_log_stmt_level >= l_curr_log_level ) then
1744: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_HIERARCHY.Synchronize_process',
1745: p_org_id ||';'||l_child_process_id ||';'||'PSUBP');
1746: end if;
1747: Synchronize_process(
1748: p_org_id => p_org_id,

Line 1758: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_HIERARCHY.Synchronize_process',

1754: p_sync_people => 'SLIB' -- Sync with library definition....
1755: );
1756: else
1757: if( l_log_stmt_level >= l_curr_log_level ) then
1758: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_HIERARCHY.Synchronize_process',
1759: p_org_id ||';'||l_child_process_id ||';'||'PONLY');
1760: end if;
1761: Synchronize_process( p_org_id => p_org_id,
1762: p_process_id => l_child_process_id,

Line 1776: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_HIERARCHY.produce_err_if_pa_or_locked',

1772: elsif pex = 'D' then
1773:
1774: if p_revise_existing = 'Y' then
1775: if( l_log_stmt_level >= l_curr_log_level ) then
1776: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_HIERARCHY.produce_err_if_pa_or_locked',
1777: p_org_id ||';'||l_child_process_id );
1778: end if;
1779: produce_err_if_pa_or_locked(p_org_id, l_child_process_id);
1780: if( l_log_stmt_level >= l_curr_log_level ) then

Line 1781: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_HIERARCHY.associate_process_to_org',

1777: p_org_id ||';'||l_child_process_id );
1778: end if;
1779: produce_err_if_pa_or_locked(p_org_id, l_child_process_id);
1780: if( l_log_stmt_level >= l_curr_log_level ) then
1781: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_HIERARCHY.associate_process_to_org',
1782: p_org_id ||';'||l_child_process_id ||';'||l_child_process_id);
1783: end if;
1784: associate_process_to_org ( p_org_id => p_org_id,
1785: p_parent_process_id => p_parent_process_id,

Line 1802: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_HIERARCHY.associate_process_to_org',

1798: and deletion_date is not null;
1799:
1800: -- HERE WE NEED TO ASSOCIATE THIS ONE AS NEW PROCESS..
1801: if( l_log_stmt_level >= l_curr_log_level ) then
1802: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_HIERARCHY.associate_process_to_org',
1803: p_org_id ||';'||l_child_process_id ||';'||l_child_process_id);
1804: end if;
1805: associate_process_to_org (
1806: p_org_id => p_org_id,

Line 1824: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_HIERARCHY.End',

1820: end if;
1821: end loop;
1822: if( l_log_stmt_level >= l_curr_log_level ) then
1823: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1824: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ASSOCIATE_HIERARCHY.End',
1825: 'End');
1826: end if;
1827: end associate_hierarchy;
1828:

Line 1877: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.begin',

1873: begin
1874:
1875: if( l_log_stmt_level >= l_curr_log_level ) then
1876: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1877: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.begin',
1878: ' OrgId:' ||p_org_id || ';p_parent_process_id:'||p_parent_process_id
1879: ||';p_sync_attributes:'||p_sync_attributes||';p_sync_rcm:'||p_sync_rcm||';p_sync_people:'||p_sync_people);
1880: end if;
1881:

Line 1894: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.does_process_exist_in_org',

1890: exit when c1%notfound;
1891: l_child_process_id := c1_rec.child_process_id;
1892: if( l_log_stmt_level >= l_curr_log_level ) then
1893: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1894: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.does_process_exist_in_org',
1895: l_child_process_id||';'||p_org_id);
1896: end if;
1897: pex := does_process_exist_in_org(l_child_process_id, p_org_id);
1898:

Line 1903: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.import_rlproc_as_child_of_ex',

1899: -- case 1: child does not exist in the org, associate it
1900: if pex = 'N' then
1901: if( l_log_stmt_level >= l_curr_log_level ) then
1902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1903: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.import_rlproc_as_child_of_ex',
1904: p_org_id||';'||l_child_process_id);
1905: end if;
1906: import_rlproc_as_child_of_ex(p_org_id, p_parent_process_id, l_child_process_id, 'Y');
1907: if( l_log_stmt_level >= l_curr_log_level ) then

Line 1909: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.synchronize_hierarchy',

1905: end if;
1906: import_rlproc_as_child_of_ex(p_org_id, p_parent_process_id, l_child_process_id, 'Y');
1907: if( l_log_stmt_level >= l_curr_log_level ) then
1908: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1909: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.synchronize_hierarchy',
1910: p_org_id||';'||l_child_process_id);
1911: end if;
1912:
1913: synchronize_hierarchy(p_org_id =>p_org_id,

Line 1923: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.add_delete_ex_child',

1919: -- case 2: child exists in the org
1920: elsif pex = 'Y' then
1921: if( l_log_stmt_level >= l_curr_log_level ) then
1922: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1923: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.add_delete_ex_child',
1924: p_org_id||';'||p_parent_process_id||';'||l_child_process_id||';'||'ADD');
1925: end if;
1926: add_delete_ex_child (p_org_id, p_parent_process_id, l_child_process_id, 'ADD');
1927:

Line 1931: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.synchronize_process',

1927:
1928: -- produce_err_if_pa_or_locked(p_org_id, l_child_process_id);
1929: if( l_log_stmt_level >= l_curr_log_level ) then
1930: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1931: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.synchronize_process',
1932: p_org_id||';'||l_child_process_id);
1933: end if;
1934: synchronize_process( p_org_id =>p_org_id,
1935: p_process_id =>l_child_process_id,

Line 1956: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.undelete',

1952: and approval_date is not null
1953: and deletion_date is not null;
1954: if( l_log_stmt_level >= l_curr_log_level ) then
1955: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1956: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.undelete',
1957: l_child_process_id||';'||p_org_id);
1958: end if;
1959: undelete(l_child_process_id, p_org_id);
1960: if( l_log_stmt_level >= l_curr_log_level ) then

Line 1962: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.add_delete_ex_child',

1958: end if;
1959: undelete(l_child_process_id, p_org_id);
1960: if( l_log_stmt_level >= l_curr_log_level ) then
1961: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1962: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.add_delete_ex_child',
1963: p_org_id||';'||p_parent_process_id||';'||l_child_process_id||';'||'ADD');
1964: end if;
1965: add_delete_ex_child (p_org_id, p_parent_process_id, l_child_process_id, 'ADD');
1966: if( l_log_stmt_level >= l_curr_log_level ) then

Line 1968: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.synchronize_process',

1964: end if;
1965: add_delete_ex_child (p_org_id, p_parent_process_id, l_child_process_id, 'ADD');
1966: if( l_log_stmt_level >= l_curr_log_level ) then
1967: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1968: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.synchronize_process',
1969: p_org_id||';'||l_child_process_id);
1970: end if;
1971: Synchronize_process(p_org_id => p_org_id,
1972: p_process_id => l_child_process_id,

Line 1982: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.synchronize_hierarchy',

1978: );
1979:
1980: if( l_log_stmt_level >= l_curr_log_level ) then
1981: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1982: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.synchronize_hierarchy',
1983: p_org_id||';'||l_child_process_id);
1984: end if;
1985: synchronize_hierarchy(p_org_id =>p_org_id,
1986: p_parent_process_id =>l_child_process_id,

Line 1996: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.undelete',

1992: EXCEPTION
1993: WHEN NO_DATA_FOUND THEN
1994: if( l_log_stmt_level >= l_curr_log_level ) then
1995: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1996: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.undelete',
1997: l_child_process_id||';'||p_org_id);
1998: end if;
1999: undelete(l_child_process_id, p_org_id);
2000: if( l_log_stmt_level >= l_curr_log_level ) then

Line 2002: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.add_delete_ex_child',

1998: end if;
1999: undelete(l_child_process_id, p_org_id);
2000: if( l_log_stmt_level >= l_curr_log_level ) then
2001: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2002: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.add_delete_ex_child',
2003: p_org_id||';'||p_parent_process_id||';'||l_child_process_id||';'||'ADD');
2004: end if;
2005: add_delete_ex_child (p_org_id, p_parent_process_id, l_child_process_id, 'ADD');
2006: if( l_log_stmt_level >= l_curr_log_level ) then

Line 2008: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.synchronize_process',

2004: end if;
2005: add_delete_ex_child (p_org_id, p_parent_process_id, l_child_process_id, 'ADD');
2006: if( l_log_stmt_level >= l_curr_log_level ) then
2007: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2008: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_HIERARCHY.synchronize_process',
2009: p_org_id||';'||l_child_process_id);
2010: end if;
2011: Synchronize_process(p_org_id => p_org_id,
2012: p_process_id => l_child_process_id,

Line 2301: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_org_hierarchy_pkg',

2297: when pending_approval_exception then
2298: rollback;
2299: fnd_message.set_name('AMW','AMW_ATTEMPT_MODIF_LOCKED');
2300: err_msg := fnd_message.get;
2301: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_org_hierarchy_pkg',
2302: p_procedure_name => 'produce_err_if_pa_or_locked',
2303: p_error_text => err_msg);
2304: raise;
2305:

Line 2334: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_org_hierarchy_pkg',

2330: when circular_exception then
2331: rollback;
2332: fnd_message.set_name('AMW','AMW_ATTEMPT_CIRCULAR');
2333: err_msg := fnd_message.get;
2334: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_org_hierarchy_pkg',
2335: p_procedure_name => 'produce_err_if_circular',
2336: p_error_text => err_msg);
2337: raise;
2338:

Line 2943: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_ORG_SRS.Begin','BEGIN');

2939: return;
2940: end if;
2941: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2942: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2943: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_ORG_SRS.Begin','BEGIN');
2944: end if;
2945: if p_org_range_from is not null and p_org_range_to is not null then
2946: open c3(p_process_id, p_org_range_from,p_org_range_to);
2947: fetch c3 bulk collect into l_audit_units_tbl;

Line 3040: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_ORG_SRS.Update_ORG_Counts','UPDATED');

3036: select p_process_id process_to_count from dual);
3037:
3038: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3039: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3040: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_ORG_SRS.Update_ORG_Counts','UPDATED');
3041: end if;
3042: -- commit here..
3043: COMMIT;
3044:

Line 3157: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_ORG_SRS.Update_Latest_Counts','UPDATED');

3153:
3154: end if;
3155: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3156: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3157: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_ORG_SRS.Update_Latest_Counts','UPDATED');
3158: end if;
3159: -- do a COMMIT;
3160: COMMIT;
3161:

Line 3292: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_ORG_SRS.Update_Approved_Counts','UPDATED');

3288: end if;
3289:
3290: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3291: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3292: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_ORG_SRS.Update_Approved_Counts','UPDATED');
3293: end if;
3294: end if;
3295: end if;
3296:

Line 3300: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_ORG_SRS.End','END');

3296:
3297: COMMIT;
3298: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3299: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3300: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_ORG_SRS.End','END');
3301: end if;
3302: EXCEPTION
3303:
3304: WHEN FND_API.G_EXC_ERROR THEN

Line 3490: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_ORG_CONC_REQUEST.Begin','BEGIN');

3486: errbuf := '';
3487: conc_status := TRUE;
3488: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3489: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3490: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_ORG_CONC_REQUEST.Begin','BEGIN');
3491: end if;
3492: p_org_ids:=VARCHAR_TABLETYPE(
3493: p_org_id_string1,p_org_id_string2,p_org_id_string3,p_org_id_string4,
3494: p_org_id_string5,p_org_id_string6,p_org_id_string7,p_org_id_string8,

Line 3739: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_ORG_CONC_REQUEST.End','END');

3735: COMMIT;
3736: end if;
3737: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3738: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3739: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_ORG_CONC_REQUEST.End','END');
3740: end if;
3741: EXCEPTION
3742: WHEN others THEN
3743: retcode :=2;

Line 3908: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_PER_ORG.Begin',

3904:
3905: begin
3906: if( l_log_stmt_level >= l_curr_log_level ) then
3907: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3908: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_PER_ORG.Begin',
3909: 'OrgId:' ||p_org_id || ';ProcessId:'||p_process_id
3910: ||';ParentProcessId:'||p_parent_orgprocess_id||';reviseExisting:'||p_synchronize||';ApplyRCM:'||p_apply_rcm);
3911: end if;
3912: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3923: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_PER_ORG.associate_process_to_org',

3919: END IF;
3920:
3921: if( l_log_stmt_level >= l_curr_log_level ) then
3922: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3923: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_PER_ORG.associate_process_to_org',
3924: 'OrgId:' ||p_org_id || ';p_associated_proc_id:'||p_process_id
3925: ||';ParentProcessId:'||p_parent_orgprocess_id||';reviseExisting:'||p_synchronize||';ApplyRCM:'||p_apply_rcm);
3926: end if;
3927:

Line 3944: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_PER_ORG.update_denorm',

3940: --ko removing amw_org_hierarchy_denorm usage...
3941: /*
3942: if( l_log_stmt_level >= l_curr_log_level ) then
3943: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3944: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_PER_ORG.update_denorm',
3945: 'Begin update denrom; OrgId:' ||p_org_id );
3946: end if;
3947: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => p_org_id);
3948: */

Line 3953: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_PER_ORG.update_counts',

3949: IF p_update_count = FND_API.G_TRUE THEN
3950: -- ko update the risk1 counts of the child process..
3951: if( l_log_stmt_level >= l_curr_log_level ) then
3952: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3953: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_PER_ORG.update_counts',
3954: 'Begin update counts; OrgId:' ||p_org_id );
3955: end if;
3956: upd_ltst_risk_count(p_org_id => p_org_id, p_process_id => null);
3957:

Line 3968: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_PER_ORG.End',

3964: end if;
3965:
3966: if( l_log_stmt_level >= l_curr_log_level ) then
3967: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3968: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_PER_ORG.End',
3969: 'End');
3970: end if;
3971:
3972: exception

Line 4845: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_ORG_hierarchy_pkg',

4841:
4842: if ret_val <> 'Y' then
4843: fnd_message.set_name('AMW','AMW_CANT_UNDO_DRAFT');
4844: err_msg := fnd_message.get;
4845: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_ORG_hierarchy_pkg',
4846: p_procedure_name => 'delete_draft',
4847: p_error_text => err_msg);
4848: raise FND_API.G_EXC_ERROR;
4849: end if;

Line 7533: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_PROCESS.begin',

7529:
7530: -- synchronization is only done to a process when it exists in the organization..
7531: if( l_log_stmt_level >= l_curr_log_level ) then
7532: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7533: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_PROCESS.begin',
7534: ' OrgId:' ||p_org_id || ';ProcessId:'||p_process_id
7535: ||';p_sync_mode:'||p_sync_mode||';p_sync_hierarchy:'||p_sync_hierarchy||';p_sync_attributes:'||p_sync_attributes
7536: ||';p_sync_rcm:'||p_sync_rcm||';p_sync_people:'||p_sync_people);
7537: end if;

Line 7542: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_PROCESS.End;',

7538:
7539: IF p_sync_hierarchy = 'NO' AND p_sync_attributes = 'NO' AND p_sync_rcm = 'RDEF' AND p_sync_people = 'RDEF' THEN
7540: if( l_log_stmt_level >= l_curr_log_level ) then
7541: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7542: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_PROCESS.End;',
7543: 'End');
7544: end if;
7545: return;
7546: END IF;

Line 7557: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_PROCESS.produce_err_if_pa_or_locked',

7553: and deletion_date is null;
7554:
7555: if( l_log_stmt_level >= l_curr_log_level ) then
7556: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7557: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_PROCESS.produce_err_if_pa_or_locked',
7558: ' OrgId:' ||p_org_id || ';ProcessId:'||p_process_id );
7559: end if;
7560: produce_err_if_pa_or_locked(p_org_id, p_process_id);
7561: if( l_log_stmt_level >= l_curr_log_level ) then

Line 7563: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_PROCESS.revise_process_if_necessary',

7559: end if;
7560: produce_err_if_pa_or_locked(p_org_id, p_process_id);
7561: if( l_log_stmt_level >= l_curr_log_level ) then
7562: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7563: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_PROCESS.revise_process_if_necessary',
7564: ' OrgId:' ||p_org_id || ';ProcessId:'||p_process_id );
7565: end if;
7566:
7567: --attachment bug5968299 codefix start

Line 7594: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_PROCESS.sync_process_attributes(bug5962899)',

7590: latest approved revision to the latest revision in the organization */
7591: IF p_sync_attributes = 'NO' THEN
7592: if( l_log_stmt_level >= l_curr_log_level ) then
7593: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7594: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_PROCESS.sync_process_attributes(bug5962899)',
7595: p_org_id || p_process_id );
7596: end if;
7597: if l_approval_status='A' then
7598: select process_org_rev_id into l_proc_latest

Line 7629: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_PROCESS.sync_process_attributes',

7625:
7626: IF p_sync_attributes = 'YES' THEN
7627: if( l_log_stmt_level >= l_curr_log_level ) then
7628: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7629: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_PROCESS.sync_process_attributes',
7630: p_org_id || p_process_id );
7631: end if;
7632: sync_process_attributes(p_org_id => p_org_id,
7633: p_process_id => p_process_id -- Sync up the attributes also..

Line 7641: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_PROCESS.sync_process_rcm',

7637:
7638: IF p_sync_rcm = 'SLIB' or p_sync_rcm = 'ARCM' THEN
7639: if( l_log_stmt_level >= l_curr_log_level ) then
7640: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7641: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_PROCESS.sync_process_rcm',
7642: p_org_id || p_process_id ||p_sync_rcm);
7643: end if;
7644: sync_process_rcm(p_org_id => p_org_id,
7645: p_process_id => p_process_id,

Line 7654: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_PROCESS.sync_process_people',

7650:
7651: IF p_sync_people = 'SLIB' or p_sync_people = 'APPL' THEN
7652: if( l_log_stmt_level >= l_curr_log_level ) then
7653: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7654: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_PROCESS.sync_process_people',
7655: p_org_id || p_process_id ||p_sync_people);
7656: end if;
7657: sync_process_people(p_org_id => p_org_id,
7658: p_process_id => p_process_id,

Line 7668: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_PROCESS.synchronize_hierarchy',

7664: IF p_sync_mode = 'PSUBP' THEN
7665: IF p_sync_hierarchy = 'YES' THEN
7666: if( l_log_stmt_level >= l_curr_log_level ) then
7667: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7668: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_PROCESS.synchronize_hierarchy',
7669: p_org_id || p_process_id );
7670: end if;
7671: synchronize_hierarchy( p_org_id => p_org_id,
7672: p_parent_process_id => p_process_id,

Line 7684: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_PROCESS.synchronize_process',

7680: exit when c1%notfound;
7681: l_child_process_id := c1_rec.child_process_id;
7682: if( l_log_stmt_level >= l_curr_log_level ) then
7683: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7684: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_PROCESS.synchronize_process',
7685: 'child_id:' || l_child_process_id );
7686: end if;
7687: synchronize_process(p_org_id => p_org_id,
7688: p_process_id => l_child_process_id,

Line 7701: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_PROCESS.End;',

7697: END IF;
7698: END IF;
7699: if( l_log_stmt_level >= l_curr_log_level ) then
7700: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
7701: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.SYNCHRONIZE_PROCESS.End;',
7702: 'End');
7703: end if;
7704:
7705: EXCEPTION

Line 8702: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.push_proc_org_no_count.Begin','BEGIN');

8698: return;
8699: end if;
8700: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
8701: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
8702: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.push_proc_org_no_count.Begin','BEGIN');
8703: end if;
8704:
8705: /** Following block added by dpatel on 8th Feb, 2006*/
8706: p_U_org_name := upper(p_org_name);

Line 8817: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.push_proc_org_no_count.End','END');

8813: AMW_UTILITY_PVT.unset_appr_cache;
8814: END IF;
8815: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
8816: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
8817: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.push_proc_org_no_count.End','END');
8818: end if;
8819: COMMIT;
8820: EXCEPTION
8821: WHEN same_request_exception THEN

Line 8847: end AMW_ORG_HIERARCHY_PKG;

8843: errbuf := SUBSTR(SQLERRM,1,1000);
8844: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);
8845: END push_proc_org_no_count;
8846:
8847: end AMW_ORG_HIERARCHY_PKG;