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

Line 32: values ('IEX_POPULATE_UWQ_SUM',FND_GLOBAL.conc_request_id);

28: where CONCURRENT_PROGRAM_NAME = 'IEX_POPULATE_UWQ_SUM';
29:
30: INSERT INTO AR_CONC_PROCESS_REQUESTS
31: (CONCURRENT_PROGRAM_NAME, REQUEST_ID)
32: values ('IEX_POPULATE_UWQ_SUM',FND_GLOBAL.conc_request_id);
33: COMMIT;
34: END insert_conc_req;
35:
36:

Line 43: if FND_GLOBAL.Conc_Request_Id is not null then

39: BEGIN
40: if (p_msg_level >= G_MSG_LEVEL) then
41:
42: FND_LOG.STRING(p_msg_level, G_PKG_NAME, p_msg);
43: if FND_GLOBAL.Conc_Request_Id is not null then
44: fnd_file.put_line(FND_FILE.LOG, p_msg);
45: end if;
46:
47: end if;

Line 2850: FND_GLOBAL.USER_ID,

2846: L_LAST_PAYMENT_AMOUNT(i),
2847: L_LAST_PAYMENT_AMOUNT_CURR(i),
2848: L_LAST_PAYMENT_NUMBER(i),
2849: sysdate,
2850: FND_GLOBAL.USER_ID,
2851: sysdate,
2852: FND_GLOBAL.USER_ID,
2853: FND_GLOBAL.CONC_LOGIN_ID,
2854: L_NUMBER_OF_DELINQUENCIES(i),

Line 2852: FND_GLOBAL.USER_ID,

2848: L_LAST_PAYMENT_NUMBER(i),
2849: sysdate,
2850: FND_GLOBAL.USER_ID,
2851: sysdate,
2852: FND_GLOBAL.USER_ID,
2853: FND_GLOBAL.CONC_LOGIN_ID,
2854: L_NUMBER_OF_DELINQUENCIES(i),
2855: L_ACTIVE_DELINQUENCIES(i),
2856: L_COMPLETE_DELINQUENCIES(i),

Line 2853: FND_GLOBAL.CONC_LOGIN_ID,

2849: sysdate,
2850: FND_GLOBAL.USER_ID,
2851: sysdate,
2852: FND_GLOBAL.USER_ID,
2853: FND_GLOBAL.CONC_LOGIN_ID,
2854: L_NUMBER_OF_DELINQUENCIES(i),
2855: L_ACTIVE_DELINQUENCIES(i),
2856: L_COMPLETE_DELINQUENCIES(i),
2857: L_PENDING_DELINQUENCIES(i),

Line 3128: last_updated_by = FND_GLOBAL.USER_ID

3124: country = L_COUNTRY(i),
3125: province = L_PROVINCE(i),
3126: postal_code = L_POSTAL_CODE(i),
3127: last_update_date = SYSDATE,
3128: last_updated_by = FND_GLOBAL.USER_ID
3129: WHERE PARTY_ID = L_PARTY_ID(i);
3130: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' Changed_Party Cursor updated ' ||L_PARTY_ID.count || ' rows ');
3131: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');
3132: COMMIT;

Line 3172: last_updated_by = FND_GLOBAL.USER_ID

3168: forall i IN L_PARTY_ID.FIRST .. L_PARTY_ID.LAST
3169: UPDATE IEX_DLN_UWQ_SUMMARY
3170: SET COLLECTOR_ID = L_COLLECTOR_ID(i),
3171: last_update_date = SYSDATE,
3172: last_updated_by = FND_GLOBAL.USER_ID
3173: WHERE
3174: PARTY_ID = L_PARTY_ID(i)
3175: AND nvl(CUST_ACCOUNT_ID,1) = nvl(L_CUST_ACCOUNT_ID(i),1)
3176: AND nvl(SITE_USE_ID,1) = nvl(L_SITE_USE_ID(i),1);

Line 3218: last_updated_by = FND_GLOBAL.USER_ID

3214: UPDATE IEX_DLN_UWQ_SUMMARY
3215: SET COLLECTOR_RESOURCE_ID = L_COLLECTOR_RESOURCE_ID(i),
3216: COLLECTOR_RES_TYPE = L_RESOURCE_TYPE(i),
3217: last_update_date = SYSDATE,
3218: last_updated_by = FND_GLOBAL.USER_ID
3219: WHERE
3220: COLLECTOR_ID = L_COLLECTOR_ID(i);
3221: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' Changed_collector updated ' || L_COLLECTOR_ID.count || ' rows ');
3222: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 3271: last_updated_by = FND_GLOBAL.USER_ID

3267: PHONE_AREA_CODE = L_PHONE_AREA_CODE(i),
3268: PHONE_NUMBER = L_PHONE_NUMBER(i),
3269: PHONE_EXTENSION = L_PHONE_EXTENSION(i),
3270: last_update_date = SYSDATE,
3271: last_updated_by = FND_GLOBAL.USER_ID
3272: WHERE PARTY_ID = L_PARTY_ID(i);
3273: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' Changed_contact Cursor updated ' ||L_PARTY_ID.count || ' rows ');
3274: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');
3275:

Line 3292: WHERE REQUEST_ID = FND_GLOBAL.conc_request_id;

3288:
3289: --Bug5701973. End.
3290:
3291: DELETE from AR_CONC_PROCESS_REQUESTS
3292: WHERE REQUEST_ID = FND_GLOBAL.conc_request_id;
3293: COMMIT;
3294:
3295:
3296: EXCEPTION

Line 3339: where REQUEST_ID = FND_GLOBAL.conc_request_id;

3335:
3336: -- End - Andre Araujo - 10/20/06 - Added dynamic sql
3337: Rollback;
3338: DELETE from AR_CONC_PROCESS_REQUESTS
3339: where REQUEST_ID = FND_GLOBAL.conc_request_id;
3340: commit;
3341:
3342: if FND_GLOBAL.Conc_Request_Id is not null then
3343: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

Line 3342: if FND_GLOBAL.Conc_Request_Id is not null then

3338: DELETE from AR_CONC_PROCESS_REQUESTS
3339: where REQUEST_ID = FND_GLOBAL.conc_request_id;
3340: commit;
3341:
3342: if FND_GLOBAL.Conc_Request_Id is not null then
3343: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
3344: status => 'ERROR',
3345: message => 'The process has failed. Please review log file.');
3346: end if;

Line 3390: where REQUEST_ID = FND_GLOBAL.conc_request_id;

3386:
3387: -- End - Andre Araujo - 10/20/06 - Added dynamic sql
3388: Rollback;
3389: DELETE from AR_CONC_PROCESS_REQUESTS
3390: where REQUEST_ID = FND_GLOBAL.conc_request_id;
3391: commit;
3392:
3393: if FND_GLOBAL.Conc_Request_Id is not null then
3394: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

Line 3393: if FND_GLOBAL.Conc_Request_Id is not null then

3389: DELETE from AR_CONC_PROCESS_REQUESTS
3390: where REQUEST_ID = FND_GLOBAL.conc_request_id;
3391: commit;
3392:
3393: if FND_GLOBAL.Conc_Request_Id is not null then
3394: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
3395: status => 'ERROR',
3396: message => 'The process has failed. Please review log file.');
3397: end if;

Line 4106: FND_GLOBAL.USER_ID,

4102: L_PAST_DUE_INV_INST_COUNT(i),
4103: L_LAST_PAYMENT_DATE(i),
4104: L_LAST_PAYMENT_AMOUNT_CURR(i),
4105: sysdate,
4106: FND_GLOBAL.USER_ID,
4107: sysdate,
4108: FND_GLOBAL.USER_ID,
4109: FND_GLOBAL.CONC_LOGIN_ID,
4110: L_ADDRESS1(i),

Line 4108: FND_GLOBAL.USER_ID,

4104: L_LAST_PAYMENT_AMOUNT_CURR(i),
4105: sysdate,
4106: FND_GLOBAL.USER_ID,
4107: sysdate,
4108: FND_GLOBAL.USER_ID,
4109: FND_GLOBAL.CONC_LOGIN_ID,
4110: L_ADDRESS1(i),
4111: L_CITY(i),
4112: L_STATE(i),

Line 4109: FND_GLOBAL.CONC_LOGIN_ID,

4105: sysdate,
4106: FND_GLOBAL.USER_ID,
4107: sysdate,
4108: FND_GLOBAL.USER_ID,
4109: FND_GLOBAL.CONC_LOGIN_ID,
4110: L_ADDRESS1(i),
4111: L_CITY(i),
4112: L_STATE(i),
4113: L_COUNTY(i),

Line 4262: last_updated_by = FND_GLOBAL.USER_ID

4258: SET COLLECTOR_RESOURCE_ID = L_COLLECTOR_RESOURCE_ID(i),
4259: COLLECTOR_RES_TYPE = L_RESOURCE_TYPE(i),
4260: collector_id = l_collector_id(i),
4261: last_update_date = SYSDATE,
4262: last_updated_by = FND_GLOBAL.USER_ID
4263: WHERE
4264: SITE_USE_ID = L_SITE_USE_ID(i);
4265: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_COLLECTOR_PROF updated ' || L_COLLECTOR_ID.count || ' rows ');
4266: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 4315: last_updated_by = FND_GLOBAL.USER_ID

4311: PHONE_AREA_CODE = L_PHONE_AREA_CODE(i),
4312: PHONE_NUMBER = L_PHONE_NUMBER(i),
4313: PHONE_EXTENSION = L_PHONE_EXTENSION(i),
4314: last_update_date = SYSDATE,
4315: last_updated_by = FND_GLOBAL.USER_ID
4316: WHERE PARTY_ID = L_PARTY_ID(i);
4317: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_contact_point Cursor updated ' ||L_PARTY_ID.count || ' rows ');
4318: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');
4319:

Line 5332: FND_GLOBAL.USER_ID,

5328: L_PAST_DUE_INV_INST_COUNT(i),
5329: L_LAST_PAYMENT_DATE(i),
5330: L_LAST_PAYMENT_AMOUNT_CURR(i),
5331: sysdate,
5332: FND_GLOBAL.USER_ID,
5333: sysdate,
5334: FND_GLOBAL.USER_ID,
5335: FND_GLOBAL.CONC_LOGIN_ID,
5336: L_ADDRESS1(i),

Line 5334: FND_GLOBAL.USER_ID,

5330: L_LAST_PAYMENT_AMOUNT_CURR(i),
5331: sysdate,
5332: FND_GLOBAL.USER_ID,
5333: sysdate,
5334: FND_GLOBAL.USER_ID,
5335: FND_GLOBAL.CONC_LOGIN_ID,
5336: L_ADDRESS1(i),
5337: L_CITY(i),
5338: L_STATE(i),

Line 5335: FND_GLOBAL.CONC_LOGIN_ID,

5331: sysdate,
5332: FND_GLOBAL.USER_ID,
5333: sysdate,
5334: FND_GLOBAL.USER_ID,
5335: FND_GLOBAL.CONC_LOGIN_ID,
5336: L_ADDRESS1(i),
5337: L_CITY(i),
5338: L_STATE(i),
5339: L_COUNTY(i),

Line 5489: last_updated_by = FND_GLOBAL.USER_ID

5485: SET COLLECTOR_RESOURCE_ID = L_COLLECTOR_RESOURCE_ID(i),
5486: COLLECTOR_RES_TYPE = L_RESOURCE_TYPE(i),
5487: collector_id = l_collector_id(i),
5488: last_update_date = SYSDATE,
5489: last_updated_by = FND_GLOBAL.USER_ID
5490: WHERE
5491: CUST_ACCOUNT_ID = L_CUST_ACCOUNT_ID(i);
5492: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_collector_prof updated ' || L_COLLECTOR_ID.count || ' rows ');
5493: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 5542: last_updated_by = FND_GLOBAL.USER_ID

5538: PHONE_AREA_CODE = L_PHONE_AREA_CODE(i),
5539: PHONE_NUMBER = L_PHONE_NUMBER(i),
5540: PHONE_EXTENSION = L_PHONE_EXTENSION(i),
5541: last_update_date = SYSDATE,
5542: last_updated_by = FND_GLOBAL.USER_ID
5543: WHERE PARTY_ID = L_PARTY_ID(i);
5544: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' Contact point Cursor updated ' ||L_PARTY_ID.count || ' rows ');
5545: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');
5546:

Line 6553: FND_GLOBAL.USER_ID,

6549: L_PAST_DUE_INV_INST_COUNT(i),
6550: L_LAST_PAYMENT_DATE(i),
6551: L_LAST_PAYMENT_AMOUNT_CURR(i),
6552: sysdate,
6553: FND_GLOBAL.USER_ID,
6554: sysdate,
6555: FND_GLOBAL.USER_ID,
6556: FND_GLOBAL.CONC_LOGIN_ID,
6557: L_ADDRESS1(i),

Line 6555: FND_GLOBAL.USER_ID,

6551: L_LAST_PAYMENT_AMOUNT_CURR(i),
6552: sysdate,
6553: FND_GLOBAL.USER_ID,
6554: sysdate,
6555: FND_GLOBAL.USER_ID,
6556: FND_GLOBAL.CONC_LOGIN_ID,
6557: L_ADDRESS1(i),
6558: L_CITY(i),
6559: L_STATE(i),

Line 6556: FND_GLOBAL.CONC_LOGIN_ID,

6552: sysdate,
6553: FND_GLOBAL.USER_ID,
6554: sysdate,
6555: FND_GLOBAL.USER_ID,
6556: FND_GLOBAL.CONC_LOGIN_ID,
6557: L_ADDRESS1(i),
6558: L_CITY(i),
6559: L_STATE(i),
6560: L_COUNTY(i),

Line 6706: last_updated_by = FND_GLOBAL.USER_ID

6702: SET COLLECTOR_RESOURCE_ID = L_COLLECTOR_RESOURCE_ID(i),
6703: COLLECTOR_RES_TYPE = L_RESOURCE_TYPE(i),
6704: collector_id = l_collector_id(i),
6705: last_update_date = SYSDATE,
6706: last_updated_by = FND_GLOBAL.USER_ID
6707: WHERE
6708: party_id = L_PARTY_ID(i);
6709: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_collector_prof updated ' || L_COLLECTOR_ID.count || ' rows ');
6710: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 6757: last_updated_by = FND_GLOBAL.USER_ID

6753: PHONE_AREA_CODE = L_PHONE_AREA_CODE(i),
6754: PHONE_NUMBER = L_PHONE_NUMBER(i),
6755: PHONE_EXTENSION = L_PHONE_EXTENSION(i),
6756: last_update_date = SYSDATE,
6757: last_updated_by = FND_GLOBAL.USER_ID
6758: WHERE PARTY_ID = L_PARTY_ID(i);
6759: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_contact_point Cursor updated ' ||L_PARTY_ID.count || ' rows ');
6760: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');
6761: