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 576: WF_CORE.Context('WF_LOCAL_SYNCH', 'Create_Stage_Indexes',

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

913: 'Begin propagate_user('||p_orig_system||', '||
914: p_orig_system_id||','||
915: 'p_attributes(wf_parameter_list_t)'||','||
916: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
917: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
918: end if;
919:
920: seedAttributes(p_attributes,
921: p_orig_system,

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

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

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

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

Line 1144: WF_CORE.Clear;

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

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

1270: last_update_login=>g_lastUpdateLogin,
1271: last_update_date=>g_lastUpdateDate);
1272: exception
1273: when OTHERS then
1274: if (WF_CORE.error_name = 'WF_INVAL_USER_ROLE') then
1275: null; --Nothing to expire
1276: else
1277: raise;
1278: end if;

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

1350: last_update_login=>g_lastUpdateLogin,
1351: last_update_date=>g_lastUpdateDate);
1352: exception
1353: when OTHERS then
1354: if (WF_CORE.error_name = 'WF_INVAL_USER_ROLE') then
1355: null; --Nothing to expire
1356: else
1357: raise;
1358: end if;

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

1395: eventParams=>g_attributes);
1396:
1397: exception
1398: when OTHERS then
1399: if (WF_CORE.error_name = 'WF_INVALID_USER') then
1400: WF_CORE.Clear;
1401: if NOT (g_delete) then
1402: l_status := nvl(g_status,'ACTIVE');
1403:

Line 1400: WF_CORE.Clear;

1396:
1397: exception
1398: when OTHERS then
1399: if (WF_CORE.error_name = 'WF_INVALID_USER') then
1400: WF_CORE.Clear;
1401: if NOT (g_delete) then
1402: l_status := nvl(g_status,'ACTIVE');
1403:
1404: WF_DIRECTORY.CreateUser( name=>g_name,

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

1479: eventParams=>g_attributes );
1480:
1481: exception
1482: when OTHERS then
1483: if (WF_CORE.error_name = 'WF_INVALID_USER') then
1484: WF_CORE.Clear;
1485: if NOT (g_delete) then
1486: l_status := nvl(g_status,'ACTIVE');
1487:

Line 1484: WF_CORE.Clear;

1480:
1481: exception
1482: when OTHERS then
1483: if (WF_CORE.error_name = 'WF_INVALID_USER') then
1484: WF_CORE.Clear;
1485: if NOT (g_delete) then
1486: l_status := nvl(g_status,'ACTIVE');
1487:
1488: WF_DIRECTORY.CreateUser( name=>g_name,

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

1531: l_modulePkg,
1532: 'End propagate_user('||p_orig_system||', '||
1533: p_orig_system_id||','||
1534: 'p_attributes(wf_parameter_list_t)'||','||
1535: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
1536: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
1537:
1538: end if;
1539:

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

1532: 'End propagate_user('||p_orig_system||', '||
1533: p_orig_system_id||','||
1534: 'p_attributes(wf_parameter_list_t)'||','||
1535: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
1536: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
1537:
1538: end if;
1539:
1540:

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

1547: end if;
1548:
1549: if (g_raiseErrors) then
1550:
1551: WF_CORE.Context('WF_LOCAL_SYNCH', 'Propagate_User',
1552: p_orig_system, p_orig_system_id);
1553: raise;
1554:
1555: else

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

1590: l_modulePkg,
1591: 'Begin propagate_role('||p_orig_system||', '||
1592: p_orig_system_id||','||
1593: 'p_attributes(wf_parameter_list_t)'||','||
1594: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
1595: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
1596:
1597: end if;
1598:

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

1591: 'Begin propagate_role('||p_orig_system||', '||
1592: p_orig_system_id||','||
1593: 'p_attributes(wf_parameter_list_t)'||','||
1594: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
1595: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
1596:
1597: end if;
1598:
1599: if (g_overWrite) then

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

1808: last_update_date=>g_lastUpdateDate );
1809:
1810: exception
1811: when OTHERS then
1812: if (WF_CORE.error_name = 'WF_INVALID_ROLE') then
1813: WF_CORE.Clear;
1814: g_updateOnly := FALSE;
1815:
1816: else

Line 1813: WF_CORE.Clear;

1809:
1810: exception
1811: when OTHERS then
1812: if (WF_CORE.error_name = 'WF_INVALID_ROLE') then
1813: WF_CORE.Clear;
1814: g_updateOnly := FALSE;
1815:
1816: else
1817: raise;

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

1857: end if;
1858:
1859: exception
1860: when OTHERS then
1861: if (WF_CORE.error_name = 'WF_DUP_ROLE') then
1862: WF_CORE.Clear;
1863: --Bug 3064439
1864: --We let the wf_directory take care of nulls
1865: --We just do update no new value other than the one passed.

Line 1862: WF_CORE.Clear;

1858:
1859: exception
1860: when OTHERS then
1861: if (WF_CORE.error_name = 'WF_DUP_ROLE') then
1862: WF_CORE.Clear;
1863: --Bug 3064439
1864: --We let the wf_directory take care of nulls
1865: --We just do update no new value other than the one passed.
1866: WF_DIRECTORY.SetRoleAttr( role_name=>g_name,

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

1896: l_modulePkg,
1897: 'End propagate_role('||p_orig_system||', '||
1898: p_orig_system_id||','||
1899: 'p_attributes(wf_parameter_list_t)'||','||
1900: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
1901: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
1902:
1903: end if;
1904:

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

1897: 'End propagate_role('||p_orig_system||', '||
1898: p_orig_system_id||','||
1899: 'p_attributes(wf_parameter_list_t)'||','||
1900: to_char(p_start_date,WF_CORE.canonical_date_mask)||','||
1901: to_char(p_expiration_date,WF_CORE.canonical_date_mask)||')');
1902:
1903: end if;
1904:
1905: exception

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

1911: end if;
1912:
1913: if (g_raiseErrors) then
1914:
1915: WF_CORE.Context('WF_LOCAL_SYNCH', 'Propagate_Role',
1916: p_orig_system, p_orig_system_id);
1917: raise;
1918:
1919: else

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

1992:
1993: exception
1994: when OTHERS then
1995: if (p_raiseErrors) then
1996: WF_CORE.Context('WF_LOCAL_SYNCH', 'Propagate_User_Role',
1997: p_user_orig_system, p_user_orig_system_id,
1998: p_role_orig_system, p_role_orig_system_id);
1999: raise;
2000:

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

2076:
2077:
2078: exception
2079: when OTHERS then
2080: if (WF_CORE.error_name = 'WF_INVAL_USER_ROLE') then
2081: WF_CORE.Clear;
2082: WF_DIRECTORY.CreateUserRole(user_name=>p_user_name,
2083: role_name=>p_role_name,
2084: start_date=>p_start_date,

Line 2081: WF_CORE.Clear;

2077:
2078: exception
2079: when OTHERS then
2080: if (WF_CORE.error_name = 'WF_INVAL_USER_ROLE') then
2081: WF_CORE.Clear;
2082: WF_DIRECTORY.CreateUserRole(user_name=>p_user_name,
2083: role_name=>p_role_name,
2084: start_date=>p_start_date,
2085: end_date=>p_expiration_date,

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

2308:
2309: --If we received a partition_id of 0, this p_orig_system cannot be
2310: --BulkSynched
2311: if (l_partitionID = 0) then
2312: WF_CORE.Token('ORIGSYS', p_orig_system);
2313: WF_CORE.Raise('WF_NOPART_ORIGSYS');
2314:
2315: end if;
2316:

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

2309: --If we received a partition_id of 0, this p_orig_system cannot be
2310: --BulkSynched
2311: if (l_partitionID = 0) then
2312: WF_CORE.Token('ORIGSYS', p_orig_system);
2313: WF_CORE.Raise('WF_NOPART_ORIGSYS');
2314:
2315: end if;
2316:
2317: --Retrieve the role and the user/role view names to be used.

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

2724:
2725: exception
2726: when DuplicateKeys then
2727: if (p_raiseErrors) then
2728: WF_CORE.Token('P_ORIG_SYSTEM', origsys.name);
2729: WF_CORE.Raise('WFDS_BULK_DUP_KEYS');
2730: else
2731: null;
2732:

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

2725: exception
2726: when DuplicateKeys then
2727: if (p_raiseErrors) then
2728: WF_CORE.Token('P_ORIG_SYSTEM', origsys.name);
2729: WF_CORE.Raise('WFDS_BULK_DUP_KEYS');
2730: else
2731: null;
2732:
2733: end if;

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

2732:
2733: end if;
2734:
2735: when OTHERS then
2736: if (WF_CORE.error_name = 'WF_NOPART_ORIGSYS') then
2737: WF_CORE.Clear;
2738: null; --If we do not have a partition for this orig_system we
2739: --ignore it and continue to the next.
2740: else

Line 2737: WF_CORE.Clear;

2733: end if;
2734:
2735: when OTHERS then
2736: if (WF_CORE.error_name = 'WF_NOPART_ORIGSYS') then
2737: WF_CORE.Clear;
2738: null; --If we do not have a partition for this orig_system we
2739: --ignore it and continue to the next.
2740: else
2741: if (p_raiseErrors) then

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

2766: if NOT (WF_ROLE_HIERARCHY.HierarchyEnabled(l_partitionName)) then
2767: syncRoles(p_orig_system);
2768: syncUserRoles(p_orig_system);
2769: else
2770: WF_CORE.Token('ORIG_SYSTEM', p_orig_system);
2771: WF_CORE.Raise('WFDS_ORIGSYS_HIERARCHY_ENABLED');
2772: end if;
2773: exception
2774: when DuplicateKeys then

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

2767: syncRoles(p_orig_system);
2768: syncUserRoles(p_orig_system);
2769: else
2770: WF_CORE.Token('ORIG_SYSTEM', p_orig_system);
2771: WF_CORE.Raise('WFDS_ORIGSYS_HIERARCHY_ENABLED');
2772: end if;
2773: exception
2774: when DuplicateKeys then
2775: if (p_raiseErrors) then

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

2772: end if;
2773: exception
2774: when DuplicateKeys then
2775: if (p_raiseErrors) then
2776: WF_CORE.Token('P_ORIG_SYSTEM', p_orig_system);
2777: WF_CORE.Raise('WFDS_BULK_DUP_KEYS');
2778: else
2779: null;
2780:

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

2773: exception
2774: when DuplicateKeys then
2775: if (p_raiseErrors) then
2776: WF_CORE.Token('P_ORIG_SYSTEM', p_orig_system);
2777: WF_CORE.Raise('WFDS_BULK_DUP_KEYS');
2778: else
2779: null;
2780:
2781: end if;

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

2843:
2844: exception
2845: when others then
2846: execute IMMEDIATE 'alter session disable parallel dml';
2847: if (wf_core.error_name = 'WFDS_ORIGSYS_HIERARCHY_ENABLED') then
2848: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
2849: retcode := '1'; -- (warning)
2850: else
2851: retcode := '2'; -- (error)

Line 2854: WF_CORE.Clear;

2850: else
2851: retcode := '2'; -- (error)
2852: errbuf := sqlerrm;
2853: end if;
2854: WF_CORE.Clear;
2855: end;
2856:
2857:
2858: ------------------------------------------------------------------------------

Line 3066: wf_core.get_error(errname, errmsg, errstack);

3062:
3063: exception
3064: when others then
3065: -- Retrieve error message into errbuf
3066: wf_core.get_error(errname, errmsg, errstack);
3067: if (errmsg is not null) then
3068: errbuf := errmsg;
3069: else
3070: errbuf := sqlerrm;