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.ZPB_DC_WF dependencies on FND_GLOBAL

Line 57: l_owner := fnd_global.user_name;

53: Itemkey => ItemKey,
54: aname => 'RESPAPPID');
55:
56: -- Issue encountered related
57: l_owner := fnd_global.user_name;
58:
59: -- Get the short text from fnd messages
60: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_DC_GEN_TEMP_ISSUE_MSG');
61: l_issue_msg := FND_MESSAGE.GET;

Line 76: fnd_global.apps_initialize(l_user_id,l_resp_id,l_respapp_id);

72: aname => 'ISSUEMSG',
73: avalue => l_issue_msg);
74:
75: -- Run the CP
76: fnd_global.apps_initialize(l_user_id,l_resp_id,l_respapp_id);
77:
78: -- Set attributes
79: SELECT value
80: INTO l_template_name

Line 400: fnd_global.apps_initialize(l_user_id,l_resp_id,l_respapp_id);

396: aname => 'DC_DISTRIBUTION_MESSAGE',
397: avalue => l_distribute_message);
398:
399: -- Set the context and Run the CP
400: fnd_global.apps_initialize(l_user_id,l_resp_id,l_respapp_id);
401:
402: resultout := 'COMPLETE:Y';
403: END IF;
404:

Line 461: l_owner := fnd_global.user_name;

457: l_api_version := 1.0;
458: l_init_msg_list := FND_API.G_FALSE;
459: l_commit := FND_API.G_FALSE;
460: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
461: l_owner := fnd_global.user_name;
462:
463: IF (funcmode = 'RUN') THEN
464: resultout :='COMPLETE:N';
465:

Line 734: p_value=> fnd_global.user_id,

730: -- set fnd values so workflow process can use this values
731: -- since they can now be run in deferred mode
732:
733: wf_event.AddParameterToList(p_name=>'FND_USER_ID',
734: p_value=> fnd_global.user_id,
735: p_parameterlist=>l_parameter_list);
736:
737:
738: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',

Line 739: p_value=> fnd_global.resp_appl_id,

735: p_parameterlist=>l_parameter_list);
736:
737:
738: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',
739: p_value=> fnd_global.resp_appl_id,
740: p_parameterlist=>l_parameter_list);
741:
742: wf_event.AddParameterToList(p_name=>'FND_RESPONSIBILITY_ID',
743: p_value=> fnd_global.resp_id,

Line 743: p_value=> fnd_global.resp_id,

739: p_value=> fnd_global.resp_appl_id,
740: p_parameterlist=>l_parameter_list);
741:
742: wf_event.AddParameterToList(p_name=>'FND_RESPONSIBILITY_ID',
743: p_value=> fnd_global.resp_id,
744: p_parameterlist=>l_parameter_list);
745:
746: -- wf debugging
747: wf_log_pkg.wf_debug_flag := TRUE;

Line 822: l_user_id := fnd_global.USER_ID;

818: BEGIN
819: l_object_id := 0;
820: l_dist_list_id := 0;
821: l_req_id := 0;
822: l_user_id := fnd_global.USER_ID;
823: l_resp_id := fnd_global.RESP_ID;
824: l_respapp_id := fnd_global.RESP_APPL_ID;
825:
826: IF (funcmode = 'RUN') THEN

Line 823: l_resp_id := fnd_global.RESP_ID;

819: l_object_id := 0;
820: l_dist_list_id := 0;
821: l_req_id := 0;
822: l_user_id := fnd_global.USER_ID;
823: l_resp_id := fnd_global.RESP_ID;
824: l_respapp_id := fnd_global.RESP_APPL_ID;
825:
826: IF (funcmode = 'RUN') THEN
827: resultout :='COMPLETE:N';

Line 824: l_respapp_id := fnd_global.RESP_APPL_ID;

820: l_dist_list_id := 0;
821: l_req_id := 0;
822: l_user_id := fnd_global.USER_ID;
823: l_resp_id := fnd_global.RESP_ID;
824: l_respapp_id := fnd_global.RESP_APPL_ID;
825:
826: IF (funcmode = 'RUN') THEN
827: resultout :='COMPLETE:N';
828:

Line 922: fnd_global.apps_initialize(l_user_id,l_resp_id,l_respapp_id);

918: avalue => l_message);
919:
920:
921: -- Run the CP
922: fnd_global.apps_initialize(l_user_id,l_resp_id,l_respapp_id);
923:
924: l_req_id := FND_REQUEST.SUBMIT_REQUEST ('ZPB',
925: 'ZPB_DC_MANUAL_DISTRIBUTE', NULL, NULL, FALSE,
926: l_object_id,l_recipient_type,l_dist_list_id,

Line 1282: LAST_UPDATED_BY = fnd_global.USER_ID,

1278:
1279: UPDATE zpb_dc_objects
1280: SET status = 'SUBMITTED_TO_SHARED',
1281: freeze_flag = 'Y',
1282: LAST_UPDATED_BY = fnd_global.USER_ID,
1283: LAST_UPDATE_DATE = SYSDATE,
1284: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1285: WHERE template_id = l_template_id
1286: AND object_type in ('M','E','C');

Line 1284: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

1280: SET status = 'SUBMITTED_TO_SHARED',
1281: freeze_flag = 'Y',
1282: LAST_UPDATED_BY = fnd_global.USER_ID,
1283: LAST_UPDATE_DATE = SYSDATE,
1284: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1285: WHERE template_id = l_template_id
1286: AND object_type in ('M','E','C');
1287:
1288: resultout := 'COMPLETE';

Line 1472: LAST_UPDATED_BY = fnd_global.USER_ID,

1468: UPDATE zpb_dc_objects
1469: SET status = 'SUBMITTED',
1470: submission_date = sysdate,
1471: submitted_by = l_object_user_id,
1472: LAST_UPDATED_BY = fnd_global.USER_ID,
1473: LAST_UPDATE_DATE = SYSDATE,
1474: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1475: WHERE template_id = l_template_id
1476: AND object_type in ('M','E','C');

Line 1474: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

1470: submission_date = sysdate,
1471: submitted_by = l_object_user_id,
1472: LAST_UPDATED_BY = fnd_global.USER_ID,
1473: LAST_UPDATE_DATE = SYSDATE,
1474: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1475: WHERE template_id = l_template_id
1476: AND object_type in ('M','E','C');
1477: ELSE
1478: IF(l_distribution_method = 'DIRECT_DISTRIBUTION' AND l_multiple_submissions_flag = 'Y'

Line 1488: LAST_UPDATED_BY = fnd_global.USER_ID,

1484: submitted_by = l_object_user_id,
1485: approver_user_id = l_approver_id,
1486: create_approval_measures_flag = 'Y',
1487: delete_approval_measures_flag = 'N',
1488: LAST_UPDATED_BY = fnd_global.USER_ID,
1489: LAST_UPDATE_DATE = SYSDATE,
1490: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1491: WHERE object_id = p_object_id;
1492: ELSE

Line 1490: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

1486: create_approval_measures_flag = 'Y',
1487: delete_approval_measures_flag = 'N',
1488: LAST_UPDATED_BY = fnd_global.USER_ID,
1489: LAST_UPDATE_DATE = SYSDATE,
1490: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1491: WHERE object_id = p_object_id;
1492: ELSE
1493: UPDATE zpb_dc_objects
1494: SET status = 'SUBMITTED',

Line 1501: LAST_UPDATED_BY = fnd_global.USER_ID,

1497: submitted_by = l_object_user_id,
1498: approver_user_id = l_approver_id,
1499: create_approval_measures_flag = 'Y',
1500: delete_approval_measures_flag = 'N', --3834999--
1501: LAST_UPDATED_BY = fnd_global.USER_ID,
1502: LAST_UPDATE_DATE = SYSDATE,
1503: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1504: WHERE object_id = p_object_id;
1505: END IF;

Line 1503: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

1499: create_approval_measures_flag = 'Y',
1500: delete_approval_measures_flag = 'N', --3834999--
1501: LAST_UPDATED_BY = fnd_global.USER_ID,
1502: LAST_UPDATE_DATE = SYSDATE,
1503: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1504: WHERE object_id = p_object_id;
1505: END IF;
1506: END IF;
1507:

Line 1553: p_value=> fnd_global.user_id,

1549: -- set fnd values so workflow process can use this values
1550: -- since they can now be run in deferred mode
1551:
1552: wf_event.AddParameterToList(p_name=>'FND_USER_ID',
1553: p_value=> fnd_global.user_id,
1554: p_parameterlist=>l_parameter_list);
1555:
1556: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',
1557: p_value=> fnd_global.resp_appl_id,

Line 1557: p_value=> fnd_global.resp_appl_id,

1553: p_value=> fnd_global.user_id,
1554: p_parameterlist=>l_parameter_list);
1555:
1556: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',
1557: p_value=> fnd_global.resp_appl_id,
1558: p_parameterlist=>l_parameter_list);
1559:
1560: wf_event.AddParameterToList(p_name=>'FND_RESPONSIBILITY_ID',
1561: p_value=> fnd_global.resp_id,

Line 1561: p_value=> fnd_global.resp_id,

1557: p_value=> fnd_global.resp_appl_id,
1558: p_parameterlist=>l_parameter_list);
1559:
1560: wf_event.AddParameterToList(p_name=>'FND_RESPONSIBILITY_ID',
1561: p_value=> fnd_global.resp_id,
1562: p_parameterlist=>l_parameter_list);
1563:
1564: -- wf debugging
1565: wf_log_pkg.wf_debug_flag := TRUE;

Line 1792: LAST_UPDATED_BY = fnd_global.USER_ID,

1788:
1789: -- Set the freeze/app mea flag all records
1790: UPDATE zpb_dc_objects
1791: SET freeze_flag = 'Y',
1792: LAST_UPDATED_BY = fnd_global.USER_ID,
1793: LAST_UPDATE_DATE = SYSDATE,
1794: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1795: WHERE template_id = l_template_id;
1796:

Line 1794: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

1790: UPDATE zpb_dc_objects
1791: SET freeze_flag = 'Y',
1792: LAST_UPDATED_BY = fnd_global.USER_ID,
1793: LAST_UPDATE_DATE = SYSDATE,
1794: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1795: WHERE template_id = l_template_id;
1796:
1797: --Set template name
1798: wf_engine.SetItemAttrText(

Line 1934: LAST_UPDATED_BY = fnd_global.USER_ID,

1930: IF (l_freeze_user_id <> l_object_user_id) THEN
1931: UPDATE zpb_dc_objects
1932: SET status = 'FROZEN',
1933: freeze_flag = 'Y',
1934: LAST_UPDATED_BY = fnd_global.USER_ID,
1935: LAST_UPDATE_DATE = SYSDATE,
1936: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1937: WHERE template_id = l_template_id
1938: AND object_user_id = l_freeze_user_id;

Line 1936: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

1932: SET status = 'FROZEN',
1933: freeze_flag = 'Y',
1934: LAST_UPDATED_BY = fnd_global.USER_ID,
1935: LAST_UPDATE_DATE = SYSDATE,
1936: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1937: WHERE template_id = l_template_id
1938: AND object_user_id = l_freeze_user_id;
1939: END IF;
1940: END LOOP;

Line 2277: l_user_id := fnd_global.USER_ID;

2273: l_resp_id NUMBER ;
2274: l_respapp_id NUMBER ;
2275: BEGIN
2276:
2277: l_user_id := fnd_global.USER_ID;
2278: l_resp_id := fnd_global.RESP_ID;
2279: l_respapp_id := fnd_global.RESP_APPL_ID;
2280: l_owner := fnd_global.user_name;
2281:

Line 2278: l_resp_id := fnd_global.RESP_ID;

2274: l_respapp_id NUMBER ;
2275: BEGIN
2276:
2277: l_user_id := fnd_global.USER_ID;
2278: l_resp_id := fnd_global.RESP_ID;
2279: l_respapp_id := fnd_global.RESP_APPL_ID;
2280: l_owner := fnd_global.user_name;
2281:
2282: IF (funcmode = 'RUN') THEN

Line 2279: l_respapp_id := fnd_global.RESP_APPL_ID;

2275: BEGIN
2276:
2277: l_user_id := fnd_global.USER_ID;
2278: l_resp_id := fnd_global.RESP_ID;
2279: l_respapp_id := fnd_global.RESP_APPL_ID;
2280: l_owner := fnd_global.user_name;
2281:
2282: IF (funcmode = 'RUN') THEN
2283:

Line 2280: l_owner := fnd_global.user_name;

2276:
2277: l_user_id := fnd_global.USER_ID;
2278: l_resp_id := fnd_global.RESP_ID;
2279: l_respapp_id := fnd_global.RESP_APPL_ID;
2280: l_owner := fnd_global.user_name;
2281:
2282: IF (funcmode = 'RUN') THEN
2283:
2284: l_object_id := wf_engine.GetItemAttrNumber(

Line 2338: fnd_global.apps_initialize(l_user_id,l_resp_id,l_respapp_id);

2334: aname => 'DC_TEMPLATE_NAME',
2335: avalue => l_template_name);
2336:
2337: -- Push data to shared AW --
2338: fnd_global.apps_initialize(l_user_id,l_resp_id,l_respapp_id);
2339: zpb_wf.submit_to_shared(l_object_user_id, l_template_id, l_req_id);
2340:
2341: -- Set the values for wait for concurrent program
2342: wf_engine.SetItemAttrNumber(

Line 2554: -- working:fnd_global.apps_initialize(1005258,57124,210);

2550: p_parameterlist=> l_parameter_list);
2551:
2552: -- set fnd values so workflow process can use this values
2553: -- since they can now be run in deferred mode
2554: -- working:fnd_global.apps_initialize(1005258,57124,210);
2555:
2556: wf_event.AddParameterToList(p_name=>'FND_USER_ID',
2557: p_value=> fnd_global.user_id,
2558: p_parameterlist=>l_parameter_list);

Line 2557: p_value=> fnd_global.user_id,

2553: -- since they can now be run in deferred mode
2554: -- working:fnd_global.apps_initialize(1005258,57124,210);
2555:
2556: wf_event.AddParameterToList(p_name=>'FND_USER_ID',
2557: p_value=> fnd_global.user_id,
2558: p_parameterlist=>l_parameter_list);
2559:
2560: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',
2561: p_value=> fnd_global.resp_appl_id,

Line 2561: p_value=> fnd_global.resp_appl_id,

2557: p_value=> fnd_global.user_id,
2558: p_parameterlist=>l_parameter_list);
2559:
2560: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',
2561: p_value=> fnd_global.resp_appl_id,
2562: p_parameterlist=>l_parameter_list);
2563:
2564: wf_event.AddParameterToList(p_name=>'FND_RESPONSIBILITY_ID',
2565: p_value=> fnd_global.resp_id,

Line 2565: p_value=> fnd_global.resp_id,

2561: p_value=> fnd_global.resp_appl_id,
2562: p_parameterlist=>l_parameter_list);
2563:
2564: wf_event.AddParameterToList(p_name=>'FND_RESPONSIBILITY_ID',
2565: p_value=> fnd_global.resp_id,
2566: p_parameterlist=>l_parameter_list);
2567:
2568: -- wf debugging
2569: wf_log_pkg.wf_debug_flag := TRUE;

Line 2765: -- working:fnd_global.apps_initialize(1005258,57124,210);

2761: p_parameterlist=> l_parameter_list);
2762:
2763: -- set fnd values so workflow process can use this values
2764: -- since they can now be run in deferred mode
2765: -- working:fnd_global.apps_initialize(1005258,57124,210);
2766:
2767: wf_event.AddParameterToList(p_name=>'FND_USER_ID',
2768: p_value=> fnd_global.user_id,
2769: p_parameterlist=>l_parameter_list);

Line 2768: p_value=> fnd_global.user_id,

2764: -- since they can now be run in deferred mode
2765: -- working:fnd_global.apps_initialize(1005258,57124,210);
2766:
2767: wf_event.AddParameterToList(p_name=>'FND_USER_ID',
2768: p_value=> fnd_global.user_id,
2769: p_parameterlist=>l_parameter_list);
2770:
2771: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',
2772: p_value=> fnd_global.resp_appl_id,

Line 2772: p_value=> fnd_global.resp_appl_id,

2768: p_value=> fnd_global.user_id,
2769: p_parameterlist=>l_parameter_list);
2770:
2771: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',
2772: p_value=> fnd_global.resp_appl_id,
2773: p_parameterlist=>l_parameter_list);
2774:
2775: wf_event.AddParameterToList(p_name=>'FND_RESPONSIBILITY_ID',
2776: p_value=> fnd_global.resp_id,

Line 2776: p_value=> fnd_global.resp_id,

2772: p_value=> fnd_global.resp_appl_id,
2773: p_parameterlist=>l_parameter_list);
2774:
2775: wf_event.AddParameterToList(p_name=>'FND_RESPONSIBILITY_ID',
2776: p_value=> fnd_global.resp_id,
2777: p_parameterlist=>l_parameter_list);
2778:
2779: -- wf debugging
2780: wf_log_pkg.wf_debug_flag := TRUE;

Line 2871: LAST_UPDATED_BY = fnd_global.USER_ID,

2867: THEN
2868: UPDATE zpb_dc_objects
2869: SET status = 'SUBMITTED_TO_SHARED',
2870: freeze_flag = 'Y',
2871: LAST_UPDATED_BY = fnd_global.USER_ID,
2872: LAST_UPDATE_DATE = SYSDATE,
2873: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
2874: WHERE object_id = l_object_id;
2875: ELSE

Line 2873: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

2869: SET status = 'SUBMITTED_TO_SHARED',
2870: freeze_flag = 'Y',
2871: LAST_UPDATED_BY = fnd_global.USER_ID,
2872: LAST_UPDATE_DATE = SYSDATE,
2873: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
2874: WHERE object_id = l_object_id;
2875: ELSE
2876: UPDATE zpb_dc_objects
2877: SET status = 'SUBMITTED_TO_SHARED',

Line 2878: LAST_UPDATED_BY = fnd_global.USER_ID,

2874: WHERE object_id = l_object_id;
2875: ELSE
2876: UPDATE zpb_dc_objects
2877: SET status = 'SUBMITTED_TO_SHARED',
2878: LAST_UPDATED_BY = fnd_global.USER_ID,
2879: LAST_UPDATE_DATE = SYSDATE,
2880: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
2881: WHERE object_id = l_object_id;
2882:

Line 2880: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

2876: UPDATE zpb_dc_objects
2877: SET status = 'SUBMITTED_TO_SHARED',
2878: LAST_UPDATED_BY = fnd_global.USER_ID,
2879: LAST_UPDATE_DATE = SYSDATE,
2880: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
2881: WHERE object_id = l_object_id;
2882:
2883: END IF;
2884: