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.WF_LOCAL_SYNCH dependencies on WF_CORE

Line 71: to_char(p_expDate, WF_CORE.canonical_date_mask)||')');

67: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
68: 'Begin seedAttributes(p_attributes '||
69: '(wf_parameter_list_t), '||p_origSystem||', '||
70: to_char(p_origSystemID)||', '||
71: to_char(p_expDate, WF_CORE.canonical_date_mask)||')');
72:
73: g_name := NULL;
74: g_displayName := NULL;
75: g_origSystem := NULL;

Line 195: WF_CORE.canonical_date_mask);

191: g_lastUpdatedBy := to_number(p_attributes(i).getValue());
192:
193: elsif (upper(p_attributes(i).getName()) = 'LAST_UPDATE_DATE') then
194: g_lastUpdateDate := to_date(p_attributes(i).getValue(),
195: WF_CORE.canonical_date_mask);
196:
197: elsif (upper(p_attributes(i).getName()) = 'LAST_UPDATE_LOGIN') then
198: g_lastUpdateLogin := to_number(p_attributes(i).getValue());
199:

Line 206: WF_CORE.canonical_date_mask);

202:
203:
204: elsif (upper(p_attributes(i).getName()) = 'CREATION_DATE') then
205: g_creationDate := to_date(p_attributes(i).getValue(),
206: WF_CORE.canonical_date_mask);
207:
208: else
209: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
210: 'Parameter: '||p_attributes(i).getName()||

Line 288: to_char(p_expDate, WF_CORE.canonical_date_mask)||')');

284: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
285: 'End seedAttributes(p_attributes '||
286: '(wf_parameter_list_t), '||p_origSystem||', '||
287: to_char(p_origSystemID)||', '||
288: to_char(p_expDate, WF_CORE.canonical_date_mask)||')');
289:
290: exception
291: when OTHERS then
292: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED, l_modulePkg,

Line 294: WF_CORE.Context('WF_LOCAL_SYNCH', 'seedAttributes', p_origSystem,

290: exception
291: when OTHERS then
292: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED, l_modulePkg,
293: 'Exception: '||sqlerrm);
294: WF_CORE.Context('WF_LOCAL_SYNCH', 'seedAttributes', p_origSystem,
295: to_char(p_origSystemID), to_char(p_expDate,
296: WF_CORE.canonical_date_mask));
297: raise;
298:

Line 296: WF_CORE.canonical_date_mask));

292: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED, l_modulePkg,
293: 'Exception: '||sqlerrm);
294: WF_CORE.Context('WF_LOCAL_SYNCH', 'seedAttributes', p_origSystem,
295: to_char(p_origSystemID), to_char(p_expDate,
296: WF_CORE.canonical_date_mask));
297: raise;
298:
299:
300: end;

Line 310: g_wf_schema := WF_CORE.Translate('WF_SCHEMA');

306: */
307: function wf_schema return varchar2 is
308: begin
309: if (g_wf_schema is NULL) then
310: g_wf_schema := WF_CORE.Translate('WF_SCHEMA');
311: end if;
312:
313: return g_wf_schema;
314:

Line 574: WF_CORE.Context('WF_LOCAL_SYNCH', 'Create_Stage_Indexes',

570:
571: end if;
572:
573:
574: WF_CORE.Context('WF_LOCAL_SYNCH', 'Create_Stage_Indexes',
575: p_sourceTable, p_targetTable);
576: raise;
577:
578: end;

Line 830: WF_CORE.Token('COLNAME', l_stageTableDesc(stageIND).COL_NAME);

826: elsif (NOT l_colExists) then
827: if (l_stageTableDesc(stageIND).COL_NULL_OK) then
828: p_selectList := (p_selectList||'NULL, ');
829: else
830: WF_CORE.Token('COLNAME', l_stageTableDesc(stageIND).COL_NAME);
831: WF_CORE.Token('VIEWNAME', p_seed_view);
832: WF_CORE.Token('STAGETABLE', p_stage_table);
833: WF_CORE.Raise('WFDS_SEED_COLUMN');
834: end if;

Line 831: WF_CORE.Token('VIEWNAME', p_seed_view);

827: if (l_stageTableDesc(stageIND).COL_NULL_OK) then
828: p_selectList := (p_selectList||'NULL, ');
829: else
830: WF_CORE.Token('COLNAME', l_stageTableDesc(stageIND).COL_NAME);
831: WF_CORE.Token('VIEWNAME', p_seed_view);
832: WF_CORE.Token('STAGETABLE', p_stage_table);
833: WF_CORE.Raise('WFDS_SEED_COLUMN');
834: end if;
835:

Line 832: WF_CORE.Token('STAGETABLE', p_stage_table);

828: p_selectList := (p_selectList||'NULL, ');
829: else
830: WF_CORE.Token('COLNAME', l_stageTableDesc(stageIND).COL_NAME);
831: WF_CORE.Token('VIEWNAME', p_seed_view);
832: WF_CORE.Token('STAGETABLE', p_stage_table);
833: WF_CORE.Raise('WFDS_SEED_COLUMN');
834: end if;
835:
836: else

Line 833: WF_CORE.Raise('WFDS_SEED_COLUMN');

829: else
830: WF_CORE.Token('COLNAME', l_stageTableDesc(stageIND).COL_NAME);
831: WF_CORE.Token('VIEWNAME', p_seed_view);
832: WF_CORE.Token('STAGETABLE', p_stage_table);
833: WF_CORE.Raise('WFDS_SEED_COLUMN');
834: end if;
835:
836: else
837: p_selectList := (p_selectList||l_colName||', ');

Line 861: WF_CORE.Token('VIEWNAME', p_seed_view);

857: ', '||p_seed_view||') [Returning False]');
858: return FALSE;
859:
860: else
861: WF_CORE.Token('VIEWNAME', p_seed_view);
862: WF_CORE.Token('PARTITION_NAME', p_orig_system);
863: WF_CORE.Raise('WFDS_BSYNC_VIEW');
864: end if;
865: end;

Line 862: WF_CORE.Token('PARTITION_NAME', p_orig_system);

858: return FALSE;
859:
860: else
861: WF_CORE.Token('VIEWNAME', p_seed_view);
862: WF_CORE.Token('PARTITION_NAME', p_orig_system);
863: WF_CORE.Raise('WFDS_BSYNC_VIEW');
864: end if;
865: end;
866:

Line 863: WF_CORE.Raise('WFDS_BSYNC_VIEW');

859:
860: else
861: WF_CORE.Token('VIEWNAME', p_seed_view);
862: WF_CORE.Token('PARTITION_NAME', p_orig_system);
863: WF_CORE.Raise('WFDS_BSYNC_VIEW');
864: end if;
865: end;
866:
867: /*

Line 912: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||

908: l_modulePkg,
909: 'Begin propagate_user('||p_orig_system||', '||
910: p_orig_system_id||','||
911: 'p_attributes(wf_parameter_list_t)'||','||
912: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
913: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
914: end if;
915:
916: seedAttributes(p_attributes,

Line 913: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');

909: 'Begin propagate_user('||p_orig_system||', '||
910: p_orig_system_id||','||
911: 'p_attributes(wf_parameter_list_t)'||','||
912: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
913: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
914: end if;
915:
916: seedAttributes(p_attributes,
917: p_orig_system,

Line 1058: to_char(SYSDATE, wf_core.canonical_date_mask) ,

1054: end if;
1055: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.wf.ds.user.nameChanged',
1056: p_event_key=>'NameChanged:'||p_orig_system||':'||
1057: to_char(p_orig_system_id)||'|'||
1058: to_char(SYSDATE, wf_core.canonical_date_mask) ,
1059: p_parameters=>l_params);
1060: end if;
1061:
1062: -- If the calling orig_system is 'FND_USR' and g_employeeID is not null, we

Line 1139: if (WF_CORE.error_name = 'WF_INVALID_USER') then

1135: eventParams=>g_attributes);
1136:
1137: exception
1138: when OTHERS then
1139: if (WF_CORE.error_name = 'WF_INVALID_USER') then
1140: WF_CORE.Clear;
1141: if NOT (g_delete) then --No reason to create a deleted user.
1142: l_status := nvl(g_status,'ACTIVE');
1143:

Line 1140: WF_CORE.Clear;

1136:
1137: exception
1138: when OTHERS then
1139: if (WF_CORE.error_name = 'WF_INVALID_USER') then
1140: WF_CORE.Clear;
1141: if NOT (g_delete) then --No reason to create a deleted user.
1142: l_status := nvl(g_status,'ACTIVE');
1143:
1144: -- <6817561>

Line 1266: if (WF_CORE.error_name = 'WF_INVAL_USER_ROLE') then

1262: last_update_login=>g_lastUpdateLogin,
1263: last_update_date=>g_lastUpdateDate);
1264: exception
1265: when OTHERS then
1266: if (WF_CORE.error_name = 'WF_INVAL_USER_ROLE') then
1267: null; --Nothing to expire
1268: else
1269: raise;
1270: end if;

Line 1346: if (WF_CORE.error_name = 'WF_INVAL_USER_ROLE') then

1342: last_update_login=>g_lastUpdateLogin,
1343: last_update_date=>g_lastUpdateDate);
1344: exception
1345: when OTHERS then
1346: if (WF_CORE.error_name = 'WF_INVAL_USER_ROLE') then
1347: null; --Nothing to expire
1348: else
1349: raise;
1350: end if;

Line 1391: if (WF_CORE.error_name = 'WF_INVALID_USER') then

1387: eventParams=>g_attributes);
1388:
1389: exception
1390: when OTHERS then
1391: if (WF_CORE.error_name = 'WF_INVALID_USER') then
1392: WF_CORE.Clear;
1393: if NOT (g_delete) then
1394: l_status := nvl(g_status,'ACTIVE');
1395:

Line 1392: WF_CORE.Clear;

1388:
1389: exception
1390: when OTHERS then
1391: if (WF_CORE.error_name = 'WF_INVALID_USER') then
1392: WF_CORE.Clear;
1393: if NOT (g_delete) then
1394: l_status := nvl(g_status,'ACTIVE');
1395:
1396: WF_DIRECTORY.CreateUser( name=>g_name,

Line 1475: if (WF_CORE.error_name = 'WF_INVALID_USER') then

1471: eventParams=>g_attributes );
1472:
1473: exception
1474: when OTHERS then
1475: if (WF_CORE.error_name = 'WF_INVALID_USER') then
1476: WF_CORE.Clear;
1477: if NOT (g_delete) then
1478: l_status := nvl(g_status,'ACTIVE');
1479:

Line 1476: WF_CORE.Clear;

1472:
1473: exception
1474: when OTHERS then
1475: if (WF_CORE.error_name = 'WF_INVALID_USER') then
1476: WF_CORE.Clear;
1477: if NOT (g_delete) then
1478: l_status := nvl(g_status,'ACTIVE');
1479:
1480: WF_DIRECTORY.CreateUser( name=>g_name,

Line 1527: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||

1523: l_modulePkg,
1524: 'End propagate_user('||p_orig_system||', '||
1525: p_orig_system_id||','||
1526: 'p_attributes(wf_parameter_list_t)'||','||
1527: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
1528: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
1529:
1530: end if;
1531:

Line 1528: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');

1524: 'End propagate_user('||p_orig_system||', '||
1525: p_orig_system_id||','||
1526: 'p_attributes(wf_parameter_list_t)'||','||
1527: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
1528: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
1529:
1530: end if;
1531:
1532:

Line 1543: WF_CORE.Context('WF_LOCAL_SYNCH', 'Propagate_User',

1539: 'Exception: '||sqlerrm);
1540:
1541: end if;
1542:
1543: WF_CORE.Context('WF_LOCAL_SYNCH', 'Propagate_User',
1544: p_orig_system, p_orig_system_id);
1545: raise;
1546:
1547: else

Line 1585: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||

1581: l_modulePkg,
1582: 'Begin propagate_role('||p_orig_system||', '||
1583: p_orig_system_id||','||
1584: 'p_attributes(wf_parameter_list_t)'||','||
1585: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
1586: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
1587:
1588: end if;
1589:

Line 1586: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');

1582: 'Begin propagate_role('||p_orig_system||', '||
1583: p_orig_system_id||','||
1584: 'p_attributes(wf_parameter_list_t)'||','||
1585: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
1586: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
1587:
1588: end if;
1589:
1590: seedAttributes(p_attributes,

Line 1763: if (WF_CORE.error_name = 'WF_INVALID_ROLE') then

1759: last_update_date=>g_lastUpdateDate );
1760:
1761: exception
1762: when OTHERS then
1763: if (WF_CORE.error_name = 'WF_INVALID_ROLE') then
1764: WF_CORE.Clear;
1765: g_updateOnly := FALSE;
1766:
1767: else

Line 1764: WF_CORE.Clear;

1760:
1761: exception
1762: when OTHERS then
1763: if (WF_CORE.error_name = 'WF_INVALID_ROLE') then
1764: WF_CORE.Clear;
1765: g_updateOnly := FALSE;
1766:
1767: else
1768: raise;

Line 1812: if (WF_CORE.error_name = 'WF_DUP_ROLE') then

1808: end if;
1809:
1810: exception
1811: when OTHERS then
1812: if (WF_CORE.error_name = 'WF_DUP_ROLE') then
1813: WF_CORE.Clear;
1814: --Bug 3064439
1815: --We let the wf_directory take care of nulls
1816: --We just do update no new value other than the one passed.

Line 1813: WF_CORE.Clear;

1809:
1810: exception
1811: when OTHERS then
1812: if (WF_CORE.error_name = 'WF_DUP_ROLE') then
1813: WF_CORE.Clear;
1814: --Bug 3064439
1815: --We let the wf_directory take care of nulls
1816: --We just do update no new value other than the one passed.
1817: WF_DIRECTORY.SetRoleAttr( role_name=>g_name,

Line 1851: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||

1847: l_modulePkg,
1848: 'End propagate_role('||p_orig_system||', '||
1849: p_orig_system_id||','||
1850: 'p_attributes(wf_parameter_list_t)'||','||
1851: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
1852: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
1853:
1854: end if;
1855:

Line 1852: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');

1848: 'End propagate_role('||p_orig_system||', '||
1849: p_orig_system_id||','||
1850: 'p_attributes(wf_parameter_list_t)'||','||
1851: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
1852: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
1853:
1854: end if;
1855:
1856: exception

Line 1865: WF_CORE.Context('WF_LOCAL_SYNCH', 'Propagate_Role',

1861: 'Exception: '||sqlerrm);
1862:
1863: end if;
1864:
1865: WF_CORE.Context('WF_LOCAL_SYNCH', 'Propagate_Role',
1866: p_orig_system, p_orig_system_id);
1867: raise;
1868:
1869: else

Line 1946: WF_CORE.Context('WF_LOCAL_SYNCH', 'Propagate_User_Role',

1942:
1943: exception
1944: when OTHERS then
1945: if (p_raiseErrors) then
1946: WF_CORE.Context('WF_LOCAL_SYNCH', 'Propagate_User_Role',
1947: p_user_orig_system, p_user_orig_system_id,
1948: p_role_orig_system, p_role_orig_system_id);
1949: raise;
1950:

Line 2030: if (WF_CORE.error_name = 'WF_INVAL_USER_ROLE') then

2026:
2027:
2028: exception
2029: when OTHERS then
2030: if (WF_CORE.error_name = 'WF_INVAL_USER_ROLE') then
2031: WF_CORE.Clear;
2032: WF_DIRECTORY.CreateUserRole(user_name=>p_user_name,
2033: role_name=>p_role_name,
2034: start_date=>p_start_date,

Line 2031: WF_CORE.Clear;

2027:
2028: exception
2029: when OTHERS then
2030: if (WF_CORE.error_name = 'WF_INVAL_USER_ROLE') then
2031: WF_CORE.Clear;
2032: WF_DIRECTORY.CreateUserRole(user_name=>p_user_name,
2033: role_name=>p_role_name,
2034: start_date=>p_start_date,
2035: end_date=>p_expiration_date,

Line 2258: WF_CORE.Token('ORIGSYS', p_orig_system);

2254:
2255: --If we received a partition_id of 0, this p_orig_system cannot be
2256: --BulkSynched
2257: if (l_partitionID = 0) then
2258: WF_CORE.Token('ORIGSYS', p_orig_system);
2259: WF_CORE.Raise('WF_NOPART_ORIGSYS');
2260:
2261: end if;
2262:

Line 2259: WF_CORE.Raise('WF_NOPART_ORIGSYS');

2255: --If we received a partition_id of 0, this p_orig_system cannot be
2256: --BulkSynched
2257: if (l_partitionID = 0) then
2258: WF_CORE.Token('ORIGSYS', p_orig_system);
2259: WF_CORE.Raise('WF_NOPART_ORIGSYS');
2260:
2261: end if;
2262:
2263: --Retrieve the role and the user/role view names to be used.

Line 2662: WF_CORE.Token('P_ORIG_SYSTEM', origsys.name);

2658:
2659: exception
2660: when DuplicateKeys then
2661: if (p_raiseErrors) then
2662: WF_CORE.Token('P_ORIG_SYSTEM', origsys.name);
2663: WF_CORE.Raise('WFDS_BULK_DUP_KEYS');
2664: else
2665: null;
2666:

Line 2663: WF_CORE.Raise('WFDS_BULK_DUP_KEYS');

2659: exception
2660: when DuplicateKeys then
2661: if (p_raiseErrors) then
2662: WF_CORE.Token('P_ORIG_SYSTEM', origsys.name);
2663: WF_CORE.Raise('WFDS_BULK_DUP_KEYS');
2664: else
2665: null;
2666:
2667: end if;

Line 2670: if (WF_CORE.error_name = 'WF_NOPART_ORIGSYS') then

2666:
2667: end if;
2668:
2669: when OTHERS then
2670: if (WF_CORE.error_name = 'WF_NOPART_ORIGSYS') then
2671: WF_CORE.Clear;
2672: null; --If we do not have a partition for this orig_system we
2673: --ignore it and continue to the next.
2674: else

Line 2671: WF_CORE.Clear;

2667: end if;
2668:
2669: when OTHERS then
2670: if (WF_CORE.error_name = 'WF_NOPART_ORIGSYS') then
2671: WF_CORE.Clear;
2672: null; --If we do not have a partition for this orig_system we
2673: --ignore it and continue to the next.
2674: else
2675: if (p_raiseErrors) then

Line 2704: WF_CORE.Token('ORIG_SYSTEM', p_orig_system);

2700: if NOT (WF_ROLE_HIERARCHY.HierarchyEnabled(l_partitionName)) then
2701: syncRoles(p_orig_system);
2702: syncUserRoles(p_orig_system);
2703: else
2704: WF_CORE.Token('ORIG_SYSTEM', p_orig_system);
2705: WF_CORE.Raise('WFDS_ORIGSYS_HIERARCHY_ENABLED');
2706: end if;
2707: exception
2708: when DuplicateKeys then

Line 2705: WF_CORE.Raise('WFDS_ORIGSYS_HIERARCHY_ENABLED');

2701: syncRoles(p_orig_system);
2702: syncUserRoles(p_orig_system);
2703: else
2704: WF_CORE.Token('ORIG_SYSTEM', p_orig_system);
2705: WF_CORE.Raise('WFDS_ORIGSYS_HIERARCHY_ENABLED');
2706: end if;
2707: exception
2708: when DuplicateKeys then
2709: if (p_raiseErrors) then

Line 2710: WF_CORE.Token('P_ORIG_SYSTEM', p_orig_system);

2706: end if;
2707: exception
2708: when DuplicateKeys then
2709: if (p_raiseErrors) then
2710: WF_CORE.Token('P_ORIG_SYSTEM', p_orig_system);
2711: WF_CORE.Raise('WFDS_BULK_DUP_KEYS');
2712: else
2713: null;
2714:

Line 2711: WF_CORE.Raise('WFDS_BULK_DUP_KEYS');

2707: exception
2708: when DuplicateKeys then
2709: if (p_raiseErrors) then
2710: WF_CORE.Token('P_ORIG_SYSTEM', p_orig_system);
2711: WF_CORE.Raise('WFDS_BULK_DUP_KEYS');
2712: else
2713: null;
2714:
2715: end if;

Line 2781: if (wf_core.error_name = 'WFDS_ORIGSYS_HIERARCHY_ENABLED') then

2777:
2778: exception
2779: when others then
2780: execute IMMEDIATE 'alter session disable parallel dml';
2781: if (wf_core.error_name = 'WFDS_ORIGSYS_HIERARCHY_ENABLED') then
2782: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
2783: retcode := '1'; -- (warning)
2784: else
2785: retcode := '2'; -- (error)

Line 2788: WF_CORE.Clear;

2784: else
2785: retcode := '2'; -- (error)
2786: errbuf := sqlerrm;
2787: end if;
2788: WF_CORE.Clear;
2789: end;
2790:
2791:
2792: ------------------------------------------------------------------------------