APPS.AP_WEB_DB_EXPDIST_PKG dependencies on AP_WEB_UTILITIES_PKG

Line 189: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

185:
186: l_has_dist NUMBER;
187:
188: BEGIN
189: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
190: 'start MoveDistributions');
191:
192: /* If there is no distribution line, add one. */
193: BEGIN

Line 221: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

217: SET report_header_id = p_target_report_header_id,
218: report_line_id = p_target_report_line_id
219: WHERE report_line_id = p_source_report_line_id;
220:
221: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
222: 'end MoveDistributions');
223:
224: EXCEPTION
225: WHEN NO_DATA_FOUND THEN

Line 246: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

242: p_source_report_line_id IN expDist_report_line_ID,
243: p_target_report_line_id IN expDist_report_line_ID) IS
244:
245: BEGIN
246: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
247: 'start DuplicateDistributions');
248:
249: -- For the given line, duplicate its distributions
250: INSERT INTO AP_EXP_REPORT_DISTS

Line 353: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

349: WHERE
350: report_line_id = p_source_report_line_id;
351:
352:
353: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
354: 'end DuplicateDistributions');
355:
356: EXCEPTION
357: WHEN NO_DATA_FOUND THEN

Line 753: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

749: l_sequence_num NUMBER;
750:
751: BEGIN
752:
753: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
754: 'start AddDistributionLine');
755: l_sequence_num := 0;
756:
757: -- For the given line, duplicate its distributions

Line 866: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

862:
863:
864:
865:
866: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
867: 'end AddDistributionLine');
868:
869:
870: EXCEPTION

Line 944: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

940:
941:
942: BEGIN
943:
944: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
945: 'start AddDistributionLine');
946:
947: -----------------------------------------------------
948: l_debug_info := 'AP_WEB_DB_AP_INT_PKG.GetCOAofSOB';

Line 1297: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

1293: -----------------------------------------------------
1294: l_rows := dbms_sql.execute(l_cursor);
1295:
1296:
1297: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
1298: 'end AddDistributionLine');
1299:
1300:
1301: EXCEPTION

Line 1405: l_dist_amt := AP_WEB_UTILITIES_PKG.OIE_ROUND_CURRENCY(p_line_amt * (l_dist_amt/l_dist_sum), p_currency_code);

1401:
1402: -- Ex: If the New line has an amount of 200 and the previous dists have amounts say
1403: -- 300 and 300, the new dists will be 200 * (300/600) = 100 and 100
1404: -- This logic will work in all cases and is used in ExpenseAllocationAMImpl.java as well.
1405: l_dist_amt := AP_WEB_UTILITIES_PKG.OIE_ROUND_CURRENCY(p_line_amt * (l_dist_amt/l_dist_sum), p_currency_code);
1406:
1407: update ap_exp_report_dists_all set amount = l_dist_amt
1408: where report_distribution_id = l_dist_id;
1409: l_remainder := l_remainder - l_dist_amt;

Line 1445: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

1441:
1442: RETURN l_segment_value;
1443:
1444: EXCEPTION WHEN OTHERS THEN
1445: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
1446: 'Exception getting segment value ' || SQLERRM);
1447: -- Return Null for exception.
1448: RETURN NULL;
1449: END GetCCSegmentValue;