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;
1260:
1261: BEGIN
1262:
1263: MSC_CL_COLLECTION.v_current_date:= SYSDATE;
1264: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1265: v_current_login:= FND_GLOBAL.LOGIN_ID;
1266: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1267: v_current_application:= FND_GLOBAL.PROG_APPL_ID;
1268: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;
1261: BEGIN
1262:
1263: MSC_CL_COLLECTION.v_current_date:= SYSDATE;
1264: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1265: v_current_login:= FND_GLOBAL.LOGIN_ID;
1266: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1267: v_current_application:= FND_GLOBAL.PROG_APPL_ID;
1268: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;
1269:
1262:
1263: MSC_CL_COLLECTION.v_current_date:= SYSDATE;
1264: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1265: v_current_login:= FND_GLOBAL.LOGIN_ID;
1266: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1267: v_current_application:= FND_GLOBAL.PROG_APPL_ID;
1268: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;
1269:
1270: LOG_MESSAGE('--------------------------------------------------------');
1263: MSC_CL_COLLECTION.v_current_date:= SYSDATE;
1264: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1265: v_current_login:= FND_GLOBAL.LOGIN_ID;
1266: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1267: v_current_application:= FND_GLOBAL.PROG_APPL_ID;
1268: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;
1269:
1270: LOG_MESSAGE('--------------------------------------------------------');
1271: LOG_MESSAGE(' Populating Available Resources.........................');
1264: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1265: v_current_login:= FND_GLOBAL.LOGIN_ID;
1266: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1267: v_current_application:= FND_GLOBAL.PROG_APPL_ID;
1268: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;
1269:
1270: LOG_MESSAGE('--------------------------------------------------------');
1271: LOG_MESSAGE(' Populating Available Resources.........................');
1272: LOG_MESSAGE('--------------------------------------------------------');
1622: ,NULL /*STATUS*/
1623: ,NULL /*APPLIED*/
1624: ,2 /*UPDATED*/
1625: ,SYSDATE
1626: ,FND_GLOBAL.USER_ID
1627: ,SYSDATE
1628: ,FND_GLOBAL.USER_ID
1629: ,FND_GLOBAL.LOGIN_ID
1630: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1624: ,2 /*UPDATED*/
1625: ,SYSDATE
1626: ,FND_GLOBAL.USER_ID
1627: ,SYSDATE
1628: ,FND_GLOBAL.USER_ID
1629: ,FND_GLOBAL.LOGIN_ID
1630: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1631: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1632: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1625: ,SYSDATE
1626: ,FND_GLOBAL.USER_ID
1627: ,SYSDATE
1628: ,FND_GLOBAL.USER_ID
1629: ,FND_GLOBAL.LOGIN_ID
1630: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1631: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1632: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1633: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1626: ,FND_GLOBAL.USER_ID
1627: ,SYSDATE
1628: ,FND_GLOBAL.USER_ID
1629: ,FND_GLOBAL.LOGIN_ID
1630: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1631: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1632: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1633: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1634: ,arg_refresh_number
1627: ,SYSDATE
1628: ,FND_GLOBAL.USER_ID
1629: ,FND_GLOBAL.LOGIN_ID
1630: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1631: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1632: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1633: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1634: ,arg_refresh_number
1635: FROM msc_calendar_dates dates,
1628: ,FND_GLOBAL.USER_ID
1629: ,FND_GLOBAL.LOGIN_ID
1630: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1631: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1632: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1633: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1634: ,arg_refresh_number
1635: FROM msc_calendar_dates dates,
1636: msc_department_resources line,
1690: ,NULL /*STATUS*/
1691: ,NULL /*APPLIED*/
1692: ,2 /*UPDATED*/
1693: ,SYSDATE
1694: ,FND_GLOBAL.USER_ID
1695: ,SYSDATE
1696: ,FND_GLOBAL.USER_ID
1697: ,FND_GLOBAL.LOGIN_ID
1698: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1692: ,2 /*UPDATED*/
1693: ,SYSDATE
1694: ,FND_GLOBAL.USER_ID
1695: ,SYSDATE
1696: ,FND_GLOBAL.USER_ID
1697: ,FND_GLOBAL.LOGIN_ID
1698: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1699: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1700: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1693: ,SYSDATE
1694: ,FND_GLOBAL.USER_ID
1695: ,SYSDATE
1696: ,FND_GLOBAL.USER_ID
1697: ,FND_GLOBAL.LOGIN_ID
1698: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1699: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1700: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1701: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1694: ,FND_GLOBAL.USER_ID
1695: ,SYSDATE
1696: ,FND_GLOBAL.USER_ID
1697: ,FND_GLOBAL.LOGIN_ID
1698: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1699: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1700: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1701: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1702: ,arg_refresh_number
1695: ,SYSDATE
1696: ,FND_GLOBAL.USER_ID
1697: ,FND_GLOBAL.LOGIN_ID
1698: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1699: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1700: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1701: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1702: ,arg_refresh_number
1703: FROM
1696: ,FND_GLOBAL.USER_ID
1697: ,FND_GLOBAL.LOGIN_ID
1698: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
1699: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1700: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1701: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1702: ,arg_refresh_number
1703: FROM
1704: msc_department_resources line,
1763: SELECT
1764: APPS_VER,
1765: SYSDATE,
1766: SYSDATE,
1767: FND_GLOBAL.USER_ID,
1768: SYSDATE,
1769: FND_GLOBAL.USER_ID,
1770: UPPER(INSTANCE_CODE), /* Bug 2129155 */
1771: INSTANCE_TYPE, -- OPM
1765: SYSDATE,
1766: SYSDATE,
1767: FND_GLOBAL.USER_ID,
1768: SYSDATE,
1769: FND_GLOBAL.USER_ID,
1770: UPPER(INSTANCE_CODE), /* Bug 2129155 */
1771: INSTANCE_TYPE, -- OPM
1772: nvl(LCID,0)
1773: INTO