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.FV_IPAC_DISBURSEMENT_PKG dependencies on PO_DISTRIBUTIONS

Line 2324: --* : po_distributions SELECT *--

2320: --* : insert_error *--
2321: --* : fv_utility.debug_mesg *--
2322: --* : fv_utility.log_mesg *--
2323: --* Tables Used : po_headers SELECT *--
2324: --* : po_distributions SELECT *--
2325: --* : po_lines SELECT *--
2326: --* : ap_invoice_distributions SELECT *--
2327: --* : ap_recurring_payments_v SELECT *--
2328: --* Logic : *--

Line 2424: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from po_distributions and lines');

2420:
2421: IF (p_error_code = g_SUCCESS AND l_validation_code IS NULL) THEN
2422: BEGIN
2423: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2424: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from po_distributions and lines');
2425: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'po_header_id='||p_ap_inv_lines_rec.po_header_id);
2426: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'set_of_books_id='||g_set_of_books_id);
2427: END IF;
2428:

Line 2431: FROM po_distributions pd,

2427: END IF;
2428:
2429: SELECT COUNT(*)
2430: INTO l_count_po_disb_lines
2431: FROM po_distributions pd,
2432: po_lines pl
2433: WHERE pd.po_header_id = p_ap_inv_lines_rec.po_header_id
2434: AND pl.po_line_id = pd.po_line_id
2435: AND pd.set_of_books_id = g_set_of_books_id;

Line 2445: l_location := l_module_name||'.select_po_distributions1';

2441: EXCEPTION
2442: WHEN OTHERS THEN
2443: p_error_code := g_FAILURE;
2444: p_error_desc := SQLERRM;
2445: l_location := l_module_name||'.select_po_distributions1';
2446: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
2447: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
2448: END;
2449: END IF;

Line 2454: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from po_distributions, lines and ap_invoice_distributions');

2450:
2451: IF (p_error_code = g_SUCCESS AND l_validation_code IS NULL) THEN
2452: BEGIN
2453: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2454: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from po_distributions, lines and ap_invoice_distributions');
2455: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'po_header_id='||p_ap_inv_lines_rec.po_header_id);
2456: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'set_of_books_id='||g_set_of_books_id);
2457: END IF;
2458:

Line 2462: po_distributions pd ,

2458:
2459: SELECT COUNT(*)
2460: INTO l_count_matched_disb_lines
2461: FROM ap_invoice_distributions aid ,
2462: po_distributions pd ,
2463: po_lines pl
2464: WHERE aid.po_distribution_id = pd.po_distribution_id
2465: AND pd.po_header_id = p_ap_inv_lines_rec.po_header_id
2466: AND pl.po_line_id = pd.po_line_id

Line 2478: l_location := l_module_name||'.select_po_distributions2';

2474: EXCEPTION
2475: WHEN OTHERS THEN
2476: p_error_code := g_FAILURE;
2477: p_error_desc := SQLERRM;
2478: l_location := l_module_name||'.select_po_distributions2';
2479: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
2480: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
2481: END;
2482: END IF;

Line 2572: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from po_distributions');

2568:
2569: IF (p_error_code = g_SUCCESS AND l_validation_code IS NULL) THEN
2570: BEGIN
2571: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2572: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from po_distributions');
2573: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'po_line_id = '||p_ap_inv_lines_rec.po_line_id);
2574: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'set_of_books_id = '||g_set_of_books_id);
2575: END IF;
2576:

Line 2579: FROM po_distributions pd

2575: END IF;
2576:
2577: SELECT COUNT(*)
2578: INTO l_count_po_disb_lines
2579: FROM po_distributions pd
2580: WHERE pd.po_line_id = p_ap_inv_lines_rec.po_line_id
2581: AND pd.set_of_books_id = g_set_of_books_id;
2582:
2583: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 2591: l_location := l_module_name||'.select_po_distributions3';

2587: EXCEPTION
2588: WHEN OTHERS THEN
2589: p_error_code := g_FAILURE;
2590: p_error_desc := SQLERRM;
2591: l_location := l_module_name||'.select_po_distributions3';
2592: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
2593: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
2594: END;
2595: END IF;

Line 2600: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from po_distributions and ap_invoice_distributions');

2596:
2597: IF (p_error_code = g_SUCCESS AND l_validation_code IS NULL) THEN
2598: BEGIN
2599: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2600: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from po_distributions and ap_invoice_distributions');
2601: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'po_line_id = '||p_ap_inv_lines_rec.po_line_id);
2602: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'set_of_books_id = '||g_set_of_books_id);
2603: END IF;
2604: SELECT COUNT(*)

Line 2607: po_distributions pd

2603: END IF;
2604: SELECT COUNT(*)
2605: INTO l_count_matched_disb_lines
2606: FROM ap_invoice_distributions aid ,
2607: po_distributions pd
2608: WHERE aid.po_distribution_id = pd.po_distribution_id
2609: AND pd.po_line_id = p_ap_inv_lines_rec.po_line_id
2610: AND aid.final_match_flag = 'D'
2611: AND aid.set_of_books_id = pd.set_of_books_id

Line 2620: l_location := l_module_name||'.select_po_distributions4';

2616: EXCEPTION
2617: WHEN OTHERS THEN
2618: p_error_code := g_FAILURE;
2619: p_error_desc := SQLERRM;
2620: l_location := l_module_name||'.select_po_distributions4';
2621: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
2622: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
2623: END;
2624: END IF;