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

Line 90: If FND_GLOBAL.user_id > -1 Then

86: IF Substr(pMessage,1,1) <> '+' Then
87: l_printTimeStamp := to_char(sysdate,'RRRR/MM/DD HH:MI:SS')||' ';
88: End If;
89:
90: If FND_GLOBAL.user_id > -1 Then
91: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_printTimeStamp||pMessage);
92: End If;
93:
94: END printOutput;

Line 156: printDebugLog(fnd_global.tab||'IN Parameters: '||ptype);

152: PROCEDURE getTableSpace(ptype IN Varchar2,pTabSpace OUT NOCOPY Varchar2) IS
153: Begin
154: IF (l_debug = 'Y') THEN
155: printDebugLog('getTableSpace(+)');
156: printDebugLog(fnd_global.tab||'IN Parameters: '||ptype);
157: END IF;
158: If ptype = 'INDEX' Then
159: select i.index_tablespace Into pTabSpace
160: from fnd_product_installations i, fnd_application a, fnd_oracle_userid u

Line 166: printDebugLog(fnd_global.tab||'OUT Parameters: '||pTabSpace);

162: and a.application_id = i.application_id
163: and u.oracle_id = i.oracle_id;
164: End If;
165: IF (l_debug = 'Y') THEN
166: printDebugLog(fnd_global.tab||'OUT Parameters: '||pTabSpace);
167: printDebugLog('getTableSpace(-)');
168: END IF;
169: End getTableSpace;
170:

Line 241: printDebugLog(fnd_global.tab||'IN Parameters: '||to_char(pMvlogid)||', '||pStatus||', '||to_char(pLogTime,'YYYY-MM-DD HH24:MI:SS')||', '||pCurrencyCode||', '||pErrorCode||', '||pErrorMessage);

237: Begin
238:
239: IF (l_debug = 'Y') THEN
240: printDebugLog('updateLog(+)');
241: printDebugLog(fnd_global.tab||'IN Parameters: '||to_char(pMvlogid)||', '||pStatus||', '||to_char(pLogTime,'YYYY-MM-DD HH24:MI:SS')||', '||pCurrencyCode||', '||pErrorCode||', '||pErrorMessage);
242: END IF;
243:
244: Update IBE_ECR_MVLOG
245: Set Refresh_Status = pStatus,

Line 269: printDebugLog(fnd_global.tab||'IN Parameters: '||pName||', '||pMode||', '||to_char(pFromStatus)||', '||to_char(pToStatus)||', '||pErrorCode||', '||pErrorMessage );

265: BEGIN
266:
267: IF (l_debug = 'Y') THEN
268: printDebugLog('updateLog(+)');
269: printDebugLog(fnd_global.tab||'IN Parameters: '||pName||', '||pMode||', '||to_char(pFromStatus)||', '||to_char(pToStatus)||', '||pErrorCode||', '||pErrorMessage );
270: END IF;
271:
272: Update IBE_ECR_MVLOG
273: Set Refresh_Status = pToStatus,

Line 300: printDebugLog(fnd_global.tab||'IN Parameters: '||pMviewName||', '||pMode||', '||pStatus||',

296:
297: BEGIN
298: IF (l_debug = 'Y') THEN
299: printDebugLog('makeLogEntry(+)');
300: printDebugLog(fnd_global.tab||'IN Parameters: '||pMviewName||', '||pMode||', '||pStatus||',
301: '||to_char(pBeginDate,'YYYY-MM-DD HH24:MI:SS')||', '||to_char(pEndDate,'YYYY-MM-DD HH24:MI:SS')||',
302: '||to_char(pLogTime,'YYYY-MM-DD HH24:MI:SS')||', '||pErrorCode||', '||pErrorMessage );
303:
304: END IF;

Line 314: FND_GLOBAL.user_id,pLogTime,

310: Program_application_id,Request_id,Program_id,Program_update_Date,Refresh_Mode,
311: mview_Name, Refresh_Status, Begin_Date, End_Date,Fact_Source,Error_Code, Error_Message,Refresh_Duration,
312: CONVERSION_TYPE, DAY_BIN_OFFSET,FORCE_REFRESH_FLAG, QUARTER_BEGIN_FLAG, PERIOD_SET_NAME)
313: Values (ibe_ecr_mvlog_s1.nextval,0,
314: FND_GLOBAL.user_id,pLogTime,
315: FND_GLOBAL.user_id,sysdate,
316: FND_GLOBAL.Conc_Login_ID,
317: fnd_global.prog_appl_id, fnd_global.conc_request_id,
318: fnd_global.conc_program_id,Sysdate,pmode,

Line 315: FND_GLOBAL.user_id,sysdate,

311: mview_Name, Refresh_Status, Begin_Date, End_Date,Fact_Source,Error_Code, Error_Message,Refresh_Duration,
312: CONVERSION_TYPE, DAY_BIN_OFFSET,FORCE_REFRESH_FLAG, QUARTER_BEGIN_FLAG, PERIOD_SET_NAME)
313: Values (ibe_ecr_mvlog_s1.nextval,0,
314: FND_GLOBAL.user_id,pLogTime,
315: FND_GLOBAL.user_id,sysdate,
316: FND_GLOBAL.Conc_Login_ID,
317: fnd_global.prog_appl_id, fnd_global.conc_request_id,
318: fnd_global.conc_program_id,Sysdate,pmode,
319: pMviewName, pStatus, pBeginDate, pEndDate,

Line 316: FND_GLOBAL.Conc_Login_ID,

312: CONVERSION_TYPE, DAY_BIN_OFFSET,FORCE_REFRESH_FLAG, QUARTER_BEGIN_FLAG, PERIOD_SET_NAME)
313: Values (ibe_ecr_mvlog_s1.nextval,0,
314: FND_GLOBAL.user_id,pLogTime,
315: FND_GLOBAL.user_id,sysdate,
316: FND_GLOBAL.Conc_Login_ID,
317: fnd_global.prog_appl_id, fnd_global.conc_request_id,
318: fnd_global.conc_program_id,Sysdate,pmode,
319: pMviewName, pStatus, pBeginDate, pEndDate,
320: g_data_source, pErrorCode, pErrorMessage,0,

Line 317: fnd_global.prog_appl_id, fnd_global.conc_request_id,

313: Values (ibe_ecr_mvlog_s1.nextval,0,
314: FND_GLOBAL.user_id,pLogTime,
315: FND_GLOBAL.user_id,sysdate,
316: FND_GLOBAL.Conc_Login_ID,
317: fnd_global.prog_appl_id, fnd_global.conc_request_id,
318: fnd_global.conc_program_id,Sysdate,pmode,
319: pMviewName, pStatus, pBeginDate, pEndDate,
320: g_data_source, pErrorCode, pErrorMessage,0,
321: g_ConversionType, g_dayoffset, g_ForceRefreshFlag, g_QuarterBeginFlag, g_periodSetName)

Line 318: fnd_global.conc_program_id,Sysdate,pmode,

314: FND_GLOBAL.user_id,pLogTime,
315: FND_GLOBAL.user_id,sysdate,
316: FND_GLOBAL.Conc_Login_ID,
317: fnd_global.prog_appl_id, fnd_global.conc_request_id,
318: fnd_global.conc_program_id,Sysdate,pmode,
319: pMviewName, pStatus, pBeginDate, pEndDate,
320: g_data_source, pErrorCode, pErrorMessage,0,
321: g_ConversionType, g_dayoffset, g_ForceRefreshFlag, g_QuarterBeginFlag, g_periodSetName)
322: RETURNING mvlog_id into plogid;

Line 325: printDebugLog(fnd_global.tab||'IN Parameters: '||to_char(plogid));

321: g_ConversionType, g_dayoffset, g_ForceRefreshFlag, g_QuarterBeginFlag, g_periodSetName)
322: RETURNING mvlog_id into plogid;
323:
324: IF (l_debug = 'Y') THEN
325: printDebugLog(fnd_global.tab||'IN Parameters: '||to_char(plogid));
326: printDebugLog('makeLogEntry(-)');
327: END IF;
328: EXCEPTION
329: When Others Then

Line 345: printDebugLog(fnd_global.tab||'IN Parameters: '||pMode||', '||pOwner||', '||pName);

341: And table_name = p_name;
342: Begin
343: IF (l_debug = 'Y') THEN
344: printDebugLog('dropIndex(+)');
345: printDebugLog(fnd_global.tab||'IN Parameters: '||pMode||', '||pOwner||', '||pName);
346: END IF;
347:
348: If pMode = 'COMPLETE' Then
349: for chg_tbl in dr_obj(pOwner,pName) loop

Line 370: printDebugLog(fnd_global.tab||'IN Parameters: '||pMode||', '||pName);

366: Begin
367:
368: IF (l_debug = 'Y') THEN
369: printDebugLog('createIndex(+)');
370: printDebugLog(fnd_global.tab||'IN Parameters: '||pMode||', '||pName);
371: END IF;
372:
373:
374: If pMode = 'COMPLETE' Then

Line 432: printDebugLog(fnd_global.tab||'IN Parameters: '||pFlag);

428: PROCEDURE setSessionParallel( pFlag IN Varchar2) IS
429: Begin
430: IF (l_debug = 'Y') THEN
431: printDebugLog('setSessionParallel(+)');
432: printDebugLog(fnd_global.tab||'IN Parameters: '||pFlag);
433: END IF;
434:
435: If pFlag = 'Y' Then
436:

Line 451: printDebugLog(fnd_global.tab||'IN Parameters: '||pFlag);

447: PROCEDURE resetSessionParallel( pFlag IN Varchar2) IS
448: Begin
449: IF (l_debug = 'Y') THEN
450: printDebugLog('resetSessionParallel(+)');
451: printDebugLog(fnd_global.tab||'IN Parameters: '||pFlag);
452: END IF;
453:
454: If pFlag = 'Y' Then
455: EXECUTE IMMEDIATE ' alter session disable parallel dml';

Line 472: printDebugLog(fnd_global.tab||'IN Parameters: '||pFlag||', '||pOwner||', '||pName);

468: Begin
469:
470: IF (l_debug = 'Y') THEN
471: printDebugLog('setTableParallel(+)');
472: printDebugLog(fnd_global.tab||'IN Parameters: '||pFlag||', '||pOwner||', '||pName);
473: END IF;
474:
475: If pFlag = 'Y' or pFlag is NULL Then
476: l_addOption := 'Parallel';

Line 492: printDebugLog(fnd_global.tab||'IN Parameters: '||pFlag||', '||pOwner||', '||pName);

488: Begin
489:
490: IF (l_debug = 'Y') THEN
491: printDebugLog('resetTableParallel(+)');
492: printDebugLog(fnd_global.tab||'IN Parameters: '||pFlag||', '||pOwner||', '||pName);
493: END IF;
494:
495: If pFlag = 'Y' Then
496: EXECUTE IMMEDIATE 'Alter table '||pOwner||'.'||pName||' noparallel ';

Line 514: printDebugLog(fnd_global.tab||'IN Parameters: '||pMode||', '||pNAME||', '||to_char(pFromDate,'YYYY-MM-DD HH24:MI:SS')||', '||to_char(pToDate,'YYYY-MM-DD HH24:MI:SS') );

510: l_oracle_schema_AppInfo varchar2(300) ;
511: BEGIN
512: IF (l_debug = 'Y') THEN
513: printDebugLog('removeFactData(+)');
514: printDebugLog(fnd_global.tab||'IN Parameters: '||pMode||', '||pNAME||', '||to_char(pFromDate,'YYYY-MM-DD HH24:MI:SS')||', '||to_char(pToDate,'YYYY-MM-DD HH24:MI:SS') );
515: END IF;
516:
517: If pMode = 'COMPLETE' Then
518:

Line 652: printDebugLog(fnd_global.tab||'IN Parameters: None');

648: l_type Varchar2(30) := 'IBE_BIN_NUM_ROW';
649: Begin
650: IF (l_debug = 'Y') THEN
651: printDebugLog('getBinMaxRows(+)');
652: printDebugLog(fnd_global.tab||'IN Parameters: None');
653: END IF;
654:
655: Select nvl(max(to_number(lookup_code)),20) into pRows
656: From fnd_lookups

Line 660: printDebugLog(fnd_global.tab||'OUT Parameters: '||to_char(pRows));

656: From fnd_lookups
657: Where lookup_type = l_type;
658:
659: IF (l_debug = 'Y') THEN
660: printDebugLog(fnd_global.tab||'OUT Parameters: '||to_char(pRows));
661: printDebugLog('getBinMaxRows(-)');
662: END IF;
663:
664: End getBinMaxRows;

Line 673: printDebugLog(fnd_global.tab||'No IN Parameters');

669: BEGIN
670:
671: IF (l_debug = 'Y') THEN
672: printDebugLog('getProfileValues(+)');
673: printDebugLog(fnd_global.tab||'No IN Parameters');
674: END IF;
675:
676: g_conversionType := fnd_profile.Value_Specific('IBE_GL_CONVERSION_TYPE',null,null,671);
677:

Line 702: printDebugLog(fnd_global.tab||'No OUT Parameters');

698: g_YearlyDataFlag := nvl(fnd_profile.Value_Specific('IBE_ECR_YEARLY_DATA',null,null,671),'Y');
699: g_TruncateFlag := nvl(fnd_profile.Value_Specific('IBE_TRUNC_RECORDS',null,null,671),'Y');
700:
701: IF (l_debug = 'Y') THEN
702: printDebugLog(fnd_global.tab||'No OUT Parameters');
703: printDebugLog('getProfileValues(-)');
704: END IF;
705:
706: End getProfileValues;

Line 718: printDebugLog(fnd_global.tab||'IN Parameters: '||pMode||', '||pfactName||', '||pBeginDate||', '||pEndDate);

714: BEGIN
715:
716: IF (l_debug = 'Y') THEN
717: printDebugLog('getPeriodDate(+)');
718: printDebugLog(fnd_global.tab||'IN Parameters: '||pMode||', '||pfactName||', '||pBeginDate||', '||pEndDate);
719: END IF;
720:
721: If pMode = 'COMPLETE' Then
722:

Line 792: printDebugLog(fnd_global.tab||'OUT Parameters: '||to_char(pFromDate,'YYYY/MM/DD HH24:MI:SS')||', '||to_char(pToDate,'YYYY/MM/DD HH24:MI:SS'));

788:
789:
790:
791: IF (l_debug = 'Y') THEN
792: printDebugLog(fnd_global.tab||'OUT Parameters: '||to_char(pFromDate,'YYYY/MM/DD HH24:MI:SS')||', '||to_char(pToDate,'YYYY/MM/DD HH24:MI:SS'));
793: printDebugLog('getPeriodDate(-)');
794: END IF;
795: END getPeriodDate;
796:

Line 886: printDebugLog(fnd_global.tab||'IN Parameters: '||pMode||', '||pfactName||', '||to_char(pStatus));

882: pStartDate Out NOCOPY Date,pEndDate OUT NOCOPY Date) IS
883: BEGIN
884: IF (l_debug = 'Y') THEN
885: printDebugLog('getFactDataPeriod(+)');
886: printDebugLog(fnd_global.tab||'IN Parameters: '||pMode||', '||pfactName||', '||to_char(pStatus));
887: END IF;
888:
889:
890: Select Begin_Date, End_Date

Line 897: printDebugLog(fnd_global.tab||'OUT Parameters: '||to_char(pStartDate,'YYYY/MM/DD')||', '||to_char(pEndDate,'YYYY/MM/DD'));

893: Where Refresh_Status = pStatus
894: And Mview_Name = pFactname
895: And Refresh_Mode = pMode;
896: IF (l_debug = 'Y') THEN
897: printDebugLog(fnd_global.tab||'OUT Parameters: '||to_char(pStartDate,'YYYY/MM/DD')||', '||to_char(pEndDate,'YYYY/MM/DD'));
898: printDebugLog('getFactDataPeriod(-)');
899: END IF;
900: END getFactDataPeriod;
901:

Line 909: printDebugLog(fnd_global.tab||'IN Parameters: '||p_currency_code||', '||to_char(pFromDate,'YYYY-MM-DD HH24:MI:SS')||', '||to_char(pToDate,'YYYY-MM-DD HH24:MI:SS') );

905: l_fact_source varchar2(240) := 'IBE_ECR_ORDER_SOURCE';
906: BEGIN
907: IF (l_debug = 'Y') THEN
908: printDebugLog('insertOrderHeaderFact(+)');
909: printDebugLog(fnd_global.tab||'IN Parameters: '||p_currency_code||', '||to_char(pFromDate,'YYYY-MM-DD HH24:MI:SS')||', '||to_char(pToDate,'YYYY-MM-DD HH24:MI:SS') );
910: END IF;
911:
912: Insert /*+ append */ Into IBE_ECR_ORDER_HEADERS_FACT (fact_date, object_version_number, created_by,creation_date,
913: last_updated_by, last_update_date, last_update_login, resource_id, org_id, currency_code, header_id, ordered_date,

Line 917: FND_GLOBAL.user_id Created_By,

913: last_updated_by, last_update_date, last_update_login, resource_id, org_id, currency_code, header_id, ordered_date,
914: order_number,Transactional_Curr_Code,Conversion_Rate, sold_to_org_id, invoice_to_org_id, agreement_id, salesrep_id,
915: functional_amount, reported_amount, customer_class_code, party_id ) SELECT Trunc(OH.booked_date) Fact_Date,
916: 0 Object_Version_Number,
917: FND_GLOBAL.user_id Created_By,
918: sysdate Creation_Date,
919: FND_GLOBAL.user_id Last_Updated_By,
920: sysdate Last_Updation_Date,
921: FND_GLOBAL.user_id Last_update_login,

Line 919: FND_GLOBAL.user_id Last_Updated_By,

915: functional_amount, reported_amount, customer_class_code, party_id ) SELECT Trunc(OH.booked_date) Fact_Date,
916: 0 Object_Version_Number,
917: FND_GLOBAL.user_id Created_By,
918: sysdate Creation_Date,
919: FND_GLOBAL.user_id Last_Updated_By,
920: sysdate Last_Updation_Date,
921: FND_GLOBAL.user_id Last_update_login,
922: null Resource_id,
923: oh.Org_id,

Line 921: FND_GLOBAL.user_id Last_update_login,

917: FND_GLOBAL.user_id Created_By,
918: sysdate Creation_Date,
919: FND_GLOBAL.user_id Last_Updated_By,
920: sysdate Last_Updation_Date,
921: FND_GLOBAL.user_id Last_update_login,
922: null Resource_id,
923: oh.Org_id,
924: p_currency_code Currency_Code,
925: oh.Header_id Header_id,

Line 977: printDebugLog(fnd_global.tab||'IN Parameters: '||p_currency_code||', '||to_char(pFromDate,'YYYY-MM-DD HH24:MI:SS')||', '||to_char(pToDate,'YYYY-MM-DD HH24:MI:SS') );

973: BEGIN
974:
975: IF (l_debug = 'Y') THEN
976: printDebugLog('insertOrderLineFact(+)');
977: printDebugLog(fnd_global.tab||'IN Parameters: '||p_currency_code||', '||to_char(pFromDate,'YYYY-MM-DD HH24:MI:SS')||', '||to_char(pToDate,'YYYY-MM-DD HH24:MI:SS') );
978: END IF;
979: /* The following query returns only recordss for type STANDARD, SERVICE and other parent records. */
980: Insert /*+ append */ into IBE_ECR_ORDERS_FACT (fact_date, object_version_number, created_by, creation_date,
981: last_updated_by, last_update_date, last_update_login, resource_id, org_id, msite_id, currency_code, section_id,

Line 985: FND_GLOBAL.user_id Created_By,

981: last_updated_by, last_update_date, last_update_login, resource_id, org_id, msite_id, currency_code, section_id,
982: organization_id, inventory_item_id, uom_code, sold_to_org_id, invoice_to_org_id, agreement_id, salesrep_id,
983: num_times_ordered, sale_quantity, functional_amount, reported_amount) SELECT ift.fact_date Fact_Date,
984: 0 Object_Version_Number,
985: FND_GLOBAL.user_id Created_By,
986: sysdate Creation_Date,
987: FND_GLOBAL.user_id Last_Updated_By,
988: sysdate Last_Update_Date,
989: FND_GLOBAL.user_id Last_update_login,

Line 987: FND_GLOBAL.user_id Last_Updated_By,

983: num_times_ordered, sale_quantity, functional_amount, reported_amount) SELECT ift.fact_date Fact_Date,
984: 0 Object_Version_Number,
985: FND_GLOBAL.user_id Created_By,
986: sysdate Creation_Date,
987: FND_GLOBAL.user_id Last_Updated_By,
988: sysdate Last_Update_Date,
989: FND_GLOBAL.user_id Last_update_login,
990: null Resource_id,
991: ift.Org_id,

Line 989: FND_GLOBAL.user_id Last_update_login,

985: FND_GLOBAL.user_id Created_By,
986: sysdate Creation_Date,
987: FND_GLOBAL.user_id Last_Updated_By,
988: sysdate Last_Update_Date,
989: FND_GLOBAL.user_id Last_update_login,
990: null Resource_id,
991: ift.Org_id,
992: 1 MSite_id,
993: p_currency_code Currency_Code,

Line 1036: printDebugLog(fnd_global.tab||'IN Parameters: '||to_char(pFromDate,'YYYY-MM-DD HH24:MI:SS')||', '||to_char(pToDate,'YYYY-MM-DD HH24:MI:SS') );

1032: BEGIN
1033:
1034: IF (l_debug = 'Y') THEN
1035: printDebugLog('insertQuotesFact(+)');
1036: printDebugLog(fnd_global.tab||'IN Parameters: '||to_char(pFromDate,'YYYY-MM-DD HH24:MI:SS')||', '||to_char(pToDate,'YYYY-MM-DD HH24:MI:SS') );
1037: END IF;
1038:
1039: Insert /*+ append */ into IBE_ECR_QUOTES_FACT (quote_date, object_version_number, created_by, creation_date,
1040: last_updated_by, last_update_date, last_update_login, msite_id, org_id, currency_code, section_id, organization_id,

Line 1046: FND_GLOBAL.user_id Created_By,

1042: item_ordered_frequency, order_quantity)
1043: SELECT
1044: Trunc(QH.Creation_Date) Quote_Date,
1045: 0 Object_Version_Number,
1046: FND_GLOBAL.user_id Created_By,
1047: sysdate Creation_Date,
1048: FND_GLOBAL.user_id Last_Updated_By,
1049: sysdate Last_Updation_Date,
1050: FND_GLOBAL.user_id Last_update_login,

Line 1048: FND_GLOBAL.user_id Last_Updated_By,

1044: Trunc(QH.Creation_Date) Quote_Date,
1045: 0 Object_Version_Number,
1046: FND_GLOBAL.user_id Created_By,
1047: sysdate Creation_Date,
1048: FND_GLOBAL.user_id Last_Updated_By,
1049: sysdate Last_Updation_Date,
1050: FND_GLOBAL.user_id Last_update_login,
1051: 1 Msite_ID,
1052: QH.Org_id,

Line 1050: FND_GLOBAL.user_id Last_update_login,

1046: FND_GLOBAL.user_id Created_By,
1047: sysdate Creation_Date,
1048: FND_GLOBAL.user_id Last_Updated_By,
1049: sysdate Last_Updation_Date,
1050: FND_GLOBAL.user_id Last_update_login,
1051: 1 Msite_ID,
1052: QH.Org_id,
1053: QH.Currency_Code,
1054: 1 Section_ID,

Line 1200: printDebugLog(fnd_global.tab||'IN Parameters: '||pForceRefreshFlag||', '||pMode||', '||pObjName||', '||pBeginDate||', '||pEndDate );

1196:
1197: BEGIN
1198: IF (l_debug = 'Y') THEN
1199: printDebugLog('ForceRefreshData(+)');
1200: printDebugLog(fnd_global.tab||'IN Parameters: '||pForceRefreshFlag||', '||pMode||', '||pObjName||', '||pBeginDate||', '||pEndDate );
1201: END IF;
1202:
1203: -- Set Force Data Refresh to 'Yes' by default.
1204:

Line 1222: Set Program_ID = fnd_global.conc_program_id,

1218:
1219: pForceRefreshStatus := 'N';
1220:
1221: Update IBE_ECR_MVLOG
1222: Set Program_ID = fnd_global.conc_program_id,
1223: Request_id = fnd_global.conc_request_id,
1224: Program_update_Date = SysDate,
1225: last_updated_by = FND_GLOBAL.USER_ID,
1226: last_update_date = sysdate,

Line 1223: Request_id = fnd_global.conc_request_id,

1219: pForceRefreshStatus := 'N';
1220:
1221: Update IBE_ECR_MVLOG
1222: Set Program_ID = fnd_global.conc_program_id,
1223: Request_id = fnd_global.conc_request_id,
1224: Program_update_Date = SysDate,
1225: last_updated_by = FND_GLOBAL.USER_ID,
1226: last_update_date = sysdate,
1227: Program_application_id = fnd_global.prog_appl_id

Line 1225: last_updated_by = FND_GLOBAL.USER_ID,

1221: Update IBE_ECR_MVLOG
1222: Set Program_ID = fnd_global.conc_program_id,
1223: Request_id = fnd_global.conc_request_id,
1224: Program_update_Date = SysDate,
1225: last_updated_by = FND_GLOBAL.USER_ID,
1226: last_update_date = sysdate,
1227: Program_application_id = fnd_global.prog_appl_id
1228: Where mvlog_id = l_mvlog_id;
1229:

Line 1227: Program_application_id = fnd_global.prog_appl_id

1223: Request_id = fnd_global.conc_request_id,
1224: Program_update_Date = SysDate,
1225: last_updated_by = FND_GLOBAL.USER_ID,
1226: last_update_date = sysdate,
1227: Program_application_id = fnd_global.prog_appl_id
1228: Where mvlog_id = l_mvlog_id;
1229:
1230: End if;
1231:

Line 1239: printDebugLog(fnd_global.tab||'OUT Parameters: '||pForceRefreshStatus);

1235: End;
1236: End if;
1237:
1238: IF (l_debug = 'Y') THEN
1239: printDebugLog(fnd_global.tab||'OUT Parameters: '||pForceRefreshStatus);
1240: printDebugLog('ForceRefreshData(-)');
1241: END IF;
1242: END ForceRefreshData;
1243:

Line 1282: printDebugLog(fnd_global.tab||'IN Parameters: '||pMode||', '||pBeginDate||', '||pEndDate);

1278: Begin
1279:
1280: IF (l_debug = 'Y') THEN
1281: printDebugLog('refreshFact(+)');
1282: printDebugLog(fnd_global.tab||'IN Parameters: '||pMode||', '||pBeginDate||', '||pEndDate);
1283: END IF;
1284:
1285: printOutput('+-----------------------------------------------------------------------------+');
1286: printOutput(getMessage('IBE','IBE_ECR_REFRESH_START',pfactName));

Line 1356: printDebugLog(fnd_global.tab||'OUT Parameters: None');

1352: printOutput(getMessage('IBE','IBE_ECR_REFRESH_SUCCESS',pfactName));
1353: printOutput('+-----------------------------------------------------------------------------+');
1354:
1355: IF (l_debug = 'Y') THEN
1356: printDebugLog(fnd_global.tab||'OUT Parameters: None');
1357: printDebugLog('refreshFact(-)');
1358: END IF;
1359: Exception
1360: When Others Then

Line 1406: printDebugLog(fnd_global.tab||'IN Parameters: '||pBeginDate||', '||pEndDate||', '||pMode||', '||pDayoffset);

1402: End If;
1403:
1404: IF (l_debug = 'Y') THEN
1405: printDebugLog('refreshFactMain(+)');
1406: printDebugLog(fnd_global.tab||'IN Parameters: '||pBeginDate||', '||pEndDate||', '||pMode||', '||pDayoffset);
1407: END IF;
1408:
1409: printOutput('+-----------------------------------------------------------------------------+');
1410:

Line 1502: printDebugLog(fnd_global.tab||'IN Parameters: '||pMode||', '||pOwner||', '||pName);

1498: ddl_curs integer;
1499: Begin
1500: IF (l_debug = 'Y') THEN
1501: printDebugLog('dropMview(+)');
1502: printDebugLog(fnd_global.tab||'IN Parameters: '||pMode||', '||pOwner||', '||pName);
1503: END IF;
1504:
1505: If pMode = 'COMPLETE' Then
1506: /*

Line 1532: printDebugLog(fnd_global.tab||'IN Parameters: '||pOperation||', '||pMviewName);

1528:
1529: Begin
1530: IF (l_debug = 'Y') THEN
1531: printDebugLog('registerMview(+)');
1532: printDebugLog(fnd_global.tab||'IN Parameters: '||pOperation||', '||pMviewName);
1533: END IF;
1534:
1535: If pOperation = 'CREATE' Then
1536:

Line 1561: printDebugLog(fnd_global.tab||'IN Parameters: '||pMode||', '||pName);

1557: l_mvlogStatus Number;
1558: BEGIN
1559: IF (l_debug = 'Y') THEN
1560: printDebugLog('IsFactDataAvailable(+)');
1561: printDebugLog(fnd_global.tab||'IN Parameters: '||pMode||', '||pName);
1562: END IF;
1563:
1564: l_mvlogStatus := 1; -- '1' indicates Successfull
1565:

Line 1577: printDebugLog(fnd_global.tab||'OUT Parameters: '||pStatus||', '||pBeginDate||', '||pEndDate||',

1573: And Refresh_Mode = pMode;
1574:
1575:
1576: IF (l_debug = 'Y') THEN
1577: printDebugLog(fnd_global.tab||'OUT Parameters: '||pStatus||', '||pBeginDate||', '||pEndDate||',
1578: '||pConversionType||', '||pCurrencyCode||', '||pFactSource||', '||to_char(pDayOffset)||', '||pForceRefresh||',
1579: '||pQuarterBegin||', '||pPeriodSetName);
1580:
1581: END IF;

Line 1606: printDebugLog(fnd_global.tab||'OUT Parameters: '||pStatus||', '||pBeginDate||', '||pEndDate);

1602:
1603: printOutput(pErrorMessage);
1604:
1605: IF (l_debug = 'Y') THEN
1606: printDebugLog(fnd_global.tab||'OUT Parameters: '||pStatus||', '||pBeginDate||', '||pEndDate);
1607: printDebugLog('IsDataAvailable(-):'||SQLCODE);
1608: END IF;
1609:
1610: END IsFactDataAvailable;

Line 1630: printDebugLog(fnd_global.tab||'IN Parameters: '||pMode||', '||pMViewName||', '||pFactName);

1626:
1627: BEGIN
1628: IF (l_debug = 'Y') THEN
1629: printDebugLog('refershMView(+)');
1630: printDebugLog(fnd_global.tab||'IN Parameters: '||pMode||', '||pMViewName||', '||pFactName);
1631: END IF;
1632:
1633: printOutput('+-----------------------------------------------------------------------------+');
1634:

Line 1694: printDebugLog(fnd_global.tab||'No OUT Parameters');

1690: End If;
1691:
1692:
1693: IF (l_debug = 'Y') THEN
1694: printDebugLog(fnd_global.tab||'No OUT Parameters');
1695: printDebugLog('refershMView(-)');
1696: END IF;
1697:
1698: printOutput(getMessage('IBE','IBE_ECR_REFRESH_SUCCESS',pMviewName));