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.ARP_DATES dependencies on ARP_GLOBAL

Line 79: arp_global.MSG_LEVEL_DEBUG);

75: arp_util.print_fcn_label('arp_dates.prepare_val_gl_pds_sql_stmt()+ ');
76:
77: arp_util.debug('p_ai_flag = ' ||
78: arp_trx_util.boolean_to_varchar2(p_ai_flag) ,
79: arp_global.MSG_LEVEL_DEBUG);
80:
81: /*------------------------------------------------------------+
82: | Don't do anything if the desired statements have already |
83: | been constructed and parsed. |

Line 99: arp_global.MSG_LEVEL_DEBUG);

95: )
96: )
97: THEN
98: arp_util.debug('No SQL statement constuction or parse is required',
99: arp_global.MSG_LEVEL_DEBUG);
100: arp_util.print_fcn_label('arp_dates.construct_val_gl_pds_sql_stmt()- ');
101: RETURN;
102:
103: END IF;

Line 324: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);

320: p1.period_set_name || p1.period_name
321: ' || l_temp_end2;
322:
323:
324: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
325: arp_util.debug('------------------ All Periods Exist SQL ---------------',
326: arp_global.MSG_LEVEL_DEBUG);
327: arp_util.debug(l_all_pds_exist_sql, arp_global.MSG_LEVEL_DEBUG);
328: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);

Line 326: arp_global.MSG_LEVEL_DEBUG);

322:
323:
324: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
325: arp_util.debug('------------------ All Periods Exist SQL ---------------',
326: arp_global.MSG_LEVEL_DEBUG);
327: arp_util.debug(l_all_pds_exist_sql, arp_global.MSG_LEVEL_DEBUG);
328: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
329: arp_util.debug('length: ' || length(l_all_pds_exist_sql),
330: arp_global.MSG_LEVEL_DEBUG);

Line 327: arp_util.debug(l_all_pds_exist_sql, arp_global.MSG_LEVEL_DEBUG);

323:
324: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
325: arp_util.debug('------------------ All Periods Exist SQL ---------------',
326: arp_global.MSG_LEVEL_DEBUG);
327: arp_util.debug(l_all_pds_exist_sql, arp_global.MSG_LEVEL_DEBUG);
328: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
329: arp_util.debug('length: ' || length(l_all_pds_exist_sql),
330: arp_global.MSG_LEVEL_DEBUG);
331:

Line 328: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);

324: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
325: arp_util.debug('------------------ All Periods Exist SQL ---------------',
326: arp_global.MSG_LEVEL_DEBUG);
327: arp_util.debug(l_all_pds_exist_sql, arp_global.MSG_LEVEL_DEBUG);
328: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
329: arp_util.debug('length: ' || length(l_all_pds_exist_sql),
330: arp_global.MSG_LEVEL_DEBUG);
331:
332: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);

Line 330: arp_global.MSG_LEVEL_DEBUG);

326: arp_global.MSG_LEVEL_DEBUG);
327: arp_util.debug(l_all_pds_exist_sql, arp_global.MSG_LEVEL_DEBUG);
328: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
329: arp_util.debug('length: ' || length(l_all_pds_exist_sql),
330: arp_global.MSG_LEVEL_DEBUG);
331:
332: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
333: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
334: arp_util.debug('----------------- Overlapping Periods SQL ---------------',

Line 332: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);

328: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
329: arp_util.debug('length: ' || length(l_all_pds_exist_sql),
330: arp_global.MSG_LEVEL_DEBUG);
331:
332: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
333: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
334: arp_util.debug('----------------- Overlapping Periods SQL ---------------',
335: arp_global.MSG_LEVEL_DEBUG);
336: arp_util.debug(l_overlapping_pds_sql, arp_global.MSG_LEVEL_DEBUG);

Line 333: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);

329: arp_util.debug('length: ' || length(l_all_pds_exist_sql),
330: arp_global.MSG_LEVEL_DEBUG);
331:
332: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
333: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
334: arp_util.debug('----------------- Overlapping Periods SQL ---------------',
335: arp_global.MSG_LEVEL_DEBUG);
336: arp_util.debug(l_overlapping_pds_sql, arp_global.MSG_LEVEL_DEBUG);
337: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);

Line 335: arp_global.MSG_LEVEL_DEBUG);

331:
332: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
333: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
334: arp_util.debug('----------------- Overlapping Periods SQL ---------------',
335: arp_global.MSG_LEVEL_DEBUG);
336: arp_util.debug(l_overlapping_pds_sql, arp_global.MSG_LEVEL_DEBUG);
337: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
338: arp_util.debug('length: ' || length(l_overlapping_pds_sql),
339: arp_global.MSG_LEVEL_DEBUG);

Line 336: arp_util.debug(l_overlapping_pds_sql, arp_global.MSG_LEVEL_DEBUG);

332: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
333: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
334: arp_util.debug('----------------- Overlapping Periods SQL ---------------',
335: arp_global.MSG_LEVEL_DEBUG);
336: arp_util.debug(l_overlapping_pds_sql, arp_global.MSG_LEVEL_DEBUG);
337: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
338: arp_util.debug('length: ' || length(l_overlapping_pds_sql),
339: arp_global.MSG_LEVEL_DEBUG);
340: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);

Line 337: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);

333: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
334: arp_util.debug('----------------- Overlapping Periods SQL ---------------',
335: arp_global.MSG_LEVEL_DEBUG);
336: arp_util.debug(l_overlapping_pds_sql, arp_global.MSG_LEVEL_DEBUG);
337: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
338: arp_util.debug('length: ' || length(l_overlapping_pds_sql),
339: arp_global.MSG_LEVEL_DEBUG);
340: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
341:

Line 339: arp_global.MSG_LEVEL_DEBUG);

335: arp_global.MSG_LEVEL_DEBUG);
336: arp_util.debug(l_overlapping_pds_sql, arp_global.MSG_LEVEL_DEBUG);
337: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
338: arp_util.debug('length: ' || length(l_overlapping_pds_sql),
339: arp_global.MSG_LEVEL_DEBUG);
340: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
341:
342: /*-----------------------------------------------+
343: | Open and Parse the All Periods Exist cursor |

Line 340: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);

336: arp_util.debug(l_overlapping_pds_sql, arp_global.MSG_LEVEL_DEBUG);
337: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
338: arp_util.debug('length: ' || length(l_overlapping_pds_sql),
339: arp_global.MSG_LEVEL_DEBUG);
340: arp_util.debug('', arp_global.MSG_LEVEL_DEBUG);
341:
342: /*-----------------------------------------------+
343: | Open and Parse the All Periods Exist cursor |
344: +-----------------------------------------------*/

Line 548: arp_global.MSG_LEVEL_DEBUG);

544:
545: l_count := dbms_sql.execute(pg_ai_pds_exist_cursor);
546:
547: arp_util.debug('AI periods exist validation count: ' || l_count,
548: arp_global.MSG_LEVEL_DEBUG);
549:
550:
551: l_count := dbms_sql.execute(pg_ai_overlapping_pds_cursor);
552:

Line 554: arp_global.MSG_LEVEL_DEBUG );

550:
551: l_count := dbms_sql.execute(pg_ai_overlapping_pds_cursor);
552:
553: arp_util.debug('AI overlapping validation count : ' || l_count,
554: arp_global.MSG_LEVEL_DEBUG );
555: ELSE
556:
557: /*---------------------------------------------------------------+
558: | Execute the periods exist validation. |

Line 569: ' result: ' || l_result, arp_global.MSG_LEVEL_DEBUG);

565:
566: dbms_sql.column_value(pg_form_pds_exist_cursor, 1, l_result);
567:
568: arp_util.debug('Form periods exist validation count: ' || l_count ||
569: ' result: ' || l_result, arp_global.MSG_LEVEL_DEBUG);
570:
571: IF (
572: l_count = 0 OR
573: l_result = 2

Line 590: arp_global.MSG_LEVEL_DEBUG);

586: l_count := dbms_sql.execute_and_fetch( pg_form_overlapping_pds_cursor,
587: FALSE);
588:
589: arp_util.debug('Form overlapping validation count: ' || l_count,
590: arp_global.MSG_LEVEL_DEBUG);
591:
592: IF ( l_count <> 0 )
593: THEN
594: arp_util.debug('Form overlapping periods validation failed');

Line 684: arp_global.MSG_LEVEL_DEBUG);

680: IF (p_invoicing_rule_id = IN_ADVANCE )
681: THEN
682:
683: arp_util.debug('Invoicing Rule: In Advance',
684: arp_global.MSG_LEVEL_DEBUG);
685:
686: SELECT MIN(rl.rule_start_date)
687: INTO p_candidate_date
688: FROM ra_customer_trx_lines rl

Line 695: arp_global.MSG_LEVEL_DEBUG);

691:
692: ELSE
693:
694: arp_util.debug('Invoicing Rule: In Arrears',
695: arp_global.MSG_LEVEL_DEBUG);
696: /*Bug 2505767, Added an additional check in the where clause to pick up only
697: those periods which match with the type defined in the set of books*/
698: SELECT COUNT(gp1.period_set_name)
699: INTO actual_num_fiscal_year

Line 942: arp_global.MSG_LEVEL_DEBUG);

938: AND ctlgd.latest_rec_flag = 'Y';
939:
940: arp_util.debug('DB trx_date: ' || l_db_trx_date ||
941: ', DB gl_date: ' || l_db_gl_date,
942: arp_global.MSG_LEVEL_DEBUG);
943: arp_util.debug('exchange rate: ' || l_exchange_rate ||
944: ', currency code: ' || l_currency_code,
945: arp_global.MSG_LEVEL_DEBUG);
946:

Line 945: arp_global.MSG_LEVEL_DEBUG);

941: ', DB gl_date: ' || l_db_gl_date,
942: arp_global.MSG_LEVEL_DEBUG);
943: arp_util.debug('exchange rate: ' || l_exchange_rate ||
944: ', currency code: ' || l_currency_code,
945: arp_global.MSG_LEVEL_DEBUG);
946:
947: arp_util.debug('invoicing_rule_id: ' || l_invoicing_rule_id,
948: arp_global.MSG_LEVEL_DEBUG);
949:

Line 948: arp_global.MSG_LEVEL_DEBUG);

944: ', currency code: ' || l_currency_code,
945: arp_global.MSG_LEVEL_DEBUG);
946:
947: arp_util.debug('invoicing_rule_id: ' || l_invoicing_rule_id,
948: arp_global.MSG_LEVEL_DEBUG);
949:
950: /*--------------------------------------------------------------------------+
951: | If the rule is In Advance, get the first date that revenue is recognized |
952: | If the rule is In Arrears, get the last date that revenue is recognized |

Line 961: arp_global.MSG_LEVEL_DEBUG);

957: l_invoicing_rule_id,
958: l_candidate_date
959: );
960: arp_util.debug('candidate date: ' || l_candidate_date,
961: arp_global.MSG_LEVEL_DEBUG);
962:
963: /*-------------------------------------------------------------------------+
964: | If l_candidate_date is null, it means that all of the lines have |
965: | null rule_start_date, or there are no lines. In this case just return |

Line 974: arp_global.MSG_LEVEL_DEBUG);

970: THEN l_trx_date := l_db_trx_date;
971: l_gl_date := l_db_gl_date;
972:
973: arp_util.debug('Candidate date is null - no action taken',
974: arp_global.MSG_LEVEL_DEBUG);
975: ELSE
976:
977: /*-------------------------------------------------------+
978: | Determine the closing status of the candidate date. |

Line 993: arp_global.MSG_LEVEL_DEBUG);

989: l_quarter_num
990: );
991:
992: arp_util.debug('closing status: ' || l_closing_status,
993: arp_global.MSG_LEVEL_DEBUG);
994:
995: IF (
996: l_closing_status = 'O' OR
997: l_closing_status = 'F' OR

Line 1006: 'validation', arp_global.MSG_LEVEL_DEBUG);

1002: )
1003: THEN
1004:
1005: arp_util.debug('candidate date passed closing status ' ||
1006: 'validation', arp_global.MSG_LEVEL_DEBUG);
1007:
1008: IF (l_db_gl_date <> l_candidate_date )
1009: THEN
1010: /* bug 5884520 Added condition to avoid re defaulting gl date*/

Line 1034: 'validation', arp_global.MSG_LEVEL_DEBUG);

1030: END IF;
1031: ELSE
1032:
1033: arp_util.debug('candidate date failed closing status ' ||
1034: 'validation', arp_global.MSG_LEVEL_DEBUG);
1035:
1036: /*----------------------------------------------------+
1037: | If the candidate date is not in a closed period, |
1038: | then it cannot be used. Exit with an error. |

Line 1062: arp_global.MSG_LEVEL_DEBUG);

1058: END IF;
1059:
1060: arp_util.debug('app_id: ' || pg_application_id ||
1061: ' , sob: ' || pg_set_of_books_id,
1062: arp_global.MSG_LEVEL_DEBUG);
1063:
1064: IF (arp_standard.validate_and_default_gl_date(
1065: l_candidate_date,
1066: null,

Line 1090: arp_global.MSG_LEVEL_DEBUG);

1086: arp_util.debug(l_error_message);
1087: app_exception.raise_exception;
1088: ELSE arp_util.debug('defaulting rule used: ' ||
1089: l_defaulting_rule_used,
1090: arp_global.MSG_LEVEL_DEBUG);
1091:
1092:
1093: arp_util.debug('validate_and_default_gl_date() returned '
1094: || ' date : ' || l_default_gl_date,

Line 1095: arp_global.MSG_LEVEL_DEBUG);

1091:
1092:
1093: arp_util.debug('validate_and_default_gl_date() returned '
1094: || ' date : ' || l_default_gl_date,
1095: arp_global.MSG_LEVEL_DEBUG);
1096:
1097: IF (l_db_gl_date <> l_default_gl_date )
1098: THEN
1099: l_gl_date := l_default_gl_date;