36: PROCEDURE LOG_MESSAGE( pBUFF IN VARCHAR2)
37: IS
38: BEGIN
39:
40: IF fnd_global.conc_request_id > 0 THEN -- concurrent program
41: FND_FILE.PUT_LINE( FND_FILE.LOG, pBUFF);
42: ELSE
43: --DBMS_OUTPUT.PUT_LINE( pBUFF);
44: NULL;
1272:
1273: BEGIN
1274:
1275: MSC_CL_COLLECTION.v_current_date:= SYSDATE;
1276: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1277: v_current_login:= FND_GLOBAL.LOGIN_ID;
1278: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1279: v_current_application:= FND_GLOBAL.PROG_APPL_ID;
1280: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;
1273: BEGIN
1274:
1275: MSC_CL_COLLECTION.v_current_date:= SYSDATE;
1276: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1277: v_current_login:= FND_GLOBAL.LOGIN_ID;
1278: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1279: v_current_application:= FND_GLOBAL.PROG_APPL_ID;
1280: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;
1281:
1274:
1275: MSC_CL_COLLECTION.v_current_date:= SYSDATE;
1276: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1277: v_current_login:= FND_GLOBAL.LOGIN_ID;
1278: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1279: v_current_application:= FND_GLOBAL.PROG_APPL_ID;
1280: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;
1281:
1282: LOG_MESSAGE('--------------------------------------------------------');
1275: MSC_CL_COLLECTION.v_current_date:= SYSDATE;
1276: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1277: v_current_login:= FND_GLOBAL.LOGIN_ID;
1278: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1279: v_current_application:= FND_GLOBAL.PROG_APPL_ID;
1280: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;
1281:
1282: LOG_MESSAGE('--------------------------------------------------------');
1283: LOG_MESSAGE(' Populating Available Resources.........................');
1276: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1277: v_current_login:= FND_GLOBAL.LOGIN_ID;
1278: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1279: v_current_application:= FND_GLOBAL.PROG_APPL_ID;
1280: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;
1281:
1282: LOG_MESSAGE('--------------------------------------------------------');
1283: LOG_MESSAGE(' Populating Available Resources.........................');
1284: LOG_MESSAGE('--------------------------------------------------------');
1634: ,NULL /*STATUS*/
1635: ,NULL /*APPLIED*/
1636: ,2 /*UPDATED*/
1637: ,SYSDATE
1638: ,FND_GLOBAL.USER_ID
1639: ,SYSDATE
1640: ,FND_GLOBAL.USER_ID
1641: ,FND_GLOBAL.LOGIN_ID
1642: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1636: ,2 /*UPDATED*/
1637: ,SYSDATE
1638: ,FND_GLOBAL.USER_ID
1639: ,SYSDATE
1640: ,FND_GLOBAL.USER_ID
1641: ,FND_GLOBAL.LOGIN_ID
1642: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1643: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1644: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1637: ,SYSDATE
1638: ,FND_GLOBAL.USER_ID
1639: ,SYSDATE
1640: ,FND_GLOBAL.USER_ID
1641: ,FND_GLOBAL.LOGIN_ID
1642: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1643: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1644: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1645: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1638: ,FND_GLOBAL.USER_ID
1639: ,SYSDATE
1640: ,FND_GLOBAL.USER_ID
1641: ,FND_GLOBAL.LOGIN_ID
1642: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1643: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1644: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1645: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1646: ,arg_refresh_number
1639: ,SYSDATE
1640: ,FND_GLOBAL.USER_ID
1641: ,FND_GLOBAL.LOGIN_ID
1642: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1643: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1644: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1645: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1646: ,arg_refresh_number
1647: FROM msc_calendar_dates dates,
1640: ,FND_GLOBAL.USER_ID
1641: ,FND_GLOBAL.LOGIN_ID
1642: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1643: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1644: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1645: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1646: ,arg_refresh_number
1647: FROM msc_calendar_dates dates,
1648: msc_department_resources line,
1702: ,NULL /*STATUS*/
1703: ,NULL /*APPLIED*/
1704: ,2 /*UPDATED*/
1705: ,SYSDATE
1706: ,FND_GLOBAL.USER_ID
1707: ,SYSDATE
1708: ,FND_GLOBAL.USER_ID
1709: ,FND_GLOBAL.LOGIN_ID
1710: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1704: ,2 /*UPDATED*/
1705: ,SYSDATE
1706: ,FND_GLOBAL.USER_ID
1707: ,SYSDATE
1708: ,FND_GLOBAL.USER_ID
1709: ,FND_GLOBAL.LOGIN_ID
1710: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1711: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1712: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1705: ,SYSDATE
1706: ,FND_GLOBAL.USER_ID
1707: ,SYSDATE
1708: ,FND_GLOBAL.USER_ID
1709: ,FND_GLOBAL.LOGIN_ID
1710: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1711: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1712: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1713: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1706: ,FND_GLOBAL.USER_ID
1707: ,SYSDATE
1708: ,FND_GLOBAL.USER_ID
1709: ,FND_GLOBAL.LOGIN_ID
1710: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1711: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1712: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1713: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1714: ,arg_refresh_number
1707: ,SYSDATE
1708: ,FND_GLOBAL.USER_ID
1709: ,FND_GLOBAL.LOGIN_ID
1710: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1711: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1712: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1713: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1714: ,arg_refresh_number
1715: FROM
1708: ,FND_GLOBAL.USER_ID
1709: ,FND_GLOBAL.LOGIN_ID
1710: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1711: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1712: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1713: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1714: ,arg_refresh_number
1715: FROM
1716: msc_department_resources line,
1775: SELECT
1776: APPS_VER,
1777: SYSDATE,
1778: SYSDATE,
1779: FND_GLOBAL.USER_ID,
1780: SYSDATE,
1781: FND_GLOBAL.USER_ID,
1782: UPPER(INSTANCE_CODE), /* Bug 2129155 */
1783: INSTANCE_TYPE, -- OPM
1777: SYSDATE,
1778: SYSDATE,
1779: FND_GLOBAL.USER_ID,
1780: SYSDATE,
1781: FND_GLOBAL.USER_ID,
1782: UPPER(INSTANCE_CODE), /* Bug 2129155 */
1783: INSTANCE_TYPE, -- OPM
1784: nvl(LCID,0)
1785: INTO
2728:
2729: BEGIN
2730:
2731: v_current_date := SYSDATE;
2732: v_current_user := FND_GLOBAL.USER_ID;
2733: v_current_login := FND_GLOBAL.LOGIN_ID;
2734: lv_plan_name := fnd_profile.VALUE ('AHL_MSC_RES_CPCTY_PLAN');
2735: LV_SOURCE_APPLICATION := 'MSC';
2736: lv_ahl_schema := MSC_UTIL.GET_SCHEMA_NAME(867);
2729: BEGIN
2730:
2731: v_current_date := SYSDATE;
2732: v_current_user := FND_GLOBAL.USER_ID;
2733: v_current_login := FND_GLOBAL.LOGIN_ID;
2734: lv_plan_name := fnd_profile.VALUE ('AHL_MSC_RES_CPCTY_PLAN');
2735: LV_SOURCE_APPLICATION := 'MSC';
2736: lv_ahl_schema := MSC_UTIL.GET_SCHEMA_NAME(867);
2737: