12713: ************************************************************************/
12714: PROCEDURE LOG_MESSAGE(pBUFF IN VARCHAR2) IS
12715: BEGIN
12716: IF v_cp_enabled THEN
12717: IF fnd_global.conc_request_id > 0 THEN
12718: FND_FILE.PUT_LINE( FND_FILE.LOG, pBUFF);
12719: ELSE
12720: null;
12721: END IF;
15818: ((f_date(i) - trunc(f_date(i))) * 86400 ),
15819: ((t_date(i) - trunc(t_date(i))) * 86400 ),
15820: resource_count(i),
15821: sysdate,
15822: FND_GLOBAL.USER_ID,
15823: sysdate,
15824: FND_GLOBAL.USER_ID,
15825: FND_GLOBAL.USER_ID
15826: ) ;
15820: resource_count(i),
15821: sysdate,
15822: FND_GLOBAL.USER_ID,
15823: sysdate,
15824: FND_GLOBAL.USER_ID,
15825: FND_GLOBAL.USER_ID
15826: ) ;
15827:
15828: END IF; /* APS or WPS */
15821: sysdate,
15822: FND_GLOBAL.USER_ID,
15823: sysdate,
15824: FND_GLOBAL.USER_ID,
15825: FND_GLOBAL.USER_ID
15826: ) ;
15827:
15828: END IF; /* APS or WPS */
15829:
15903: ((f_date(i) - trunc(f_date(i))) * 86400 ),
15904: ((t_date(i) - trunc(t_date(i))) * 86400 ),
15905: resource_count(i),
15906: sysdate,
15907: FND_GLOBAL.USER_ID,
15908: sysdate,
15909: FND_GLOBAL.USER_ID,
15910: FND_GLOBAL.USER_ID
15911: ) ;
15905: resource_count(i),
15906: sysdate,
15907: FND_GLOBAL.USER_ID,
15908: sysdate,
15909: FND_GLOBAL.USER_ID,
15910: FND_GLOBAL.USER_ID
15911: ) ;
15912:
15913: END IF; /* APS or WPS */
15906: sysdate,
15907: FND_GLOBAL.USER_ID,
15908: sysdate,
15909: FND_GLOBAL.USER_ID,
15910: FND_GLOBAL.USER_ID
15911: ) ;
15912:
15913: END IF; /* APS or WPS */
15914:
17707: ((f_date(i) - trunc(f_date(i))) * 86400 ),
17708: ((t_date(i) - trunc(t_date(i))) * 86400 ),
17709: resource_count(i),
17710: sysdate,
17711: FND_GLOBAL.USER_ID,
17712: sysdate,
17713: FND_GLOBAL.USER_ID,
17714: FND_GLOBAL.USER_ID
17715: ) ;
17709: resource_count(i),
17710: sysdate,
17711: FND_GLOBAL.USER_ID,
17712: sysdate,
17713: FND_GLOBAL.USER_ID,
17714: FND_GLOBAL.USER_ID
17715: ) ;
17716:
17717: END IF; /* APS or WPS */
17710: sysdate,
17711: FND_GLOBAL.USER_ID,
17712: sysdate,
17713: FND_GLOBAL.USER_ID,
17714: FND_GLOBAL.USER_ID
17715: ) ;
17716:
17717: END IF; /* APS or WPS */
17718:
17793: ((f_date(i) - trunc(f_date(i))) * 86400 ),
17794: ((t_date(i) - trunc(t_date(i))) * 86400 ),
17795: resource_count(i),
17796: sysdate,
17797: FND_GLOBAL.USER_ID,
17798: sysdate,
17799: FND_GLOBAL.USER_ID,
17800: FND_GLOBAL.USER_ID
17801: ) ;
17795: resource_count(i),
17796: sysdate,
17797: FND_GLOBAL.USER_ID,
17798: sysdate,
17799: FND_GLOBAL.USER_ID,
17800: FND_GLOBAL.USER_ID
17801: ) ;
17802:
17803: END IF; /* APS or WPS */
17796: sysdate,
17797: FND_GLOBAL.USER_ID,
17798: sysdate,
17799: FND_GLOBAL.USER_ID,
17800: FND_GLOBAL.USER_ID
17801: ) ;
17802:
17803: END IF; /* APS or WPS */
17804:
18024: p_from_time,
18025: p_to_time,
18026: p_assigned_qty,
18027: sysdate,
18028: FND_GLOBAL.USER_ID,
18029: sysdate,
18030: FND_GLOBAL.USER_ID,
18031: FND_GLOBAL.USER_ID ) ;
18032: END IF;
18026: p_assigned_qty,
18027: sysdate,
18028: FND_GLOBAL.USER_ID,
18029: sysdate,
18030: FND_GLOBAL.USER_ID,
18031: FND_GLOBAL.USER_ID ) ;
18032: END IF;
18033: EXCEPTION
18034: WHEN OTHERS THEN
18027: sysdate,
18028: FND_GLOBAL.USER_ID,
18029: sysdate,
18030: FND_GLOBAL.USER_ID,
18031: FND_GLOBAL.USER_ID ) ;
18032: END IF;
18033: EXCEPTION
18034: WHEN OTHERS THEN
18035: log_message('Error in Net Resource Avail Insert ' || sqlerrm);