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.PO_PDOI_LINE_PROCESS_PVT dependencies on FND_API

Line 471: p_cascade => FND_API.g_TRUE

467: PO_PDOI_UTL.reject_lines_intf
468: (
469: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
470: p_id_tbl => l_dup_intf_line_id_tbl,
471: p_cascade => FND_API.g_TRUE
472: );
473:
474: d_position := 50;
475:

Line 540: p_cascade => FND_API.g_TRUE

536: PO_PDOI_UTL.reject_lines_intf
537: (
538: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
539: p_id_tbl => l_dup_intf_line_id_tbl,
540: p_cascade => FND_API.g_TRUE
541: );
542:
543: d_position := 110;
544:

Line 660: p_cascade => FND_API.g_TRUE

656: PO_PDOI_UTL.reject_lines_intf
657: (
658: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
659: p_id_tbl => l_rej_intf_line_id_tbl,
660: p_cascade => FND_API.g_TRUE
661: );
662:
663: d_position := 50;
664:

Line 845: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl

841: intf_lines.group_line_id, --PDOI CLM Integration
842:
843: DECODE(intf_lines.process_code,
844: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
845: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
846: FND_API.g_FALSE, -- need_to_reject_flag_tbl
847: FND_API.g_FALSE, -- create_line_loc_tbl
848: -1, -- group_num
849: NULL, -- origin_line_num

Line 846: FND_API.g_FALSE, -- need_to_reject_flag_tbl

842:
843: DECODE(intf_lines.process_code,
844: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
845: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
846: FND_API.g_FALSE, -- need_to_reject_flag_tbl
847: FND_API.g_FALSE, -- create_line_loc_tbl
848: -1, -- group_num
849: NULL, -- origin_line_num
850: FND_API.g_FALSE, -- match_line_found

Line 847: FND_API.g_FALSE, -- create_line_loc_tbl

843: DECODE(intf_lines.process_code,
844: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
845: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
846: FND_API.g_FALSE, -- need_to_reject_flag_tbl
847: FND_API.g_FALSE, -- create_line_loc_tbl
848: -1, -- group_num
849: NULL, -- origin_line_num
850: FND_API.g_FALSE, -- match_line_found
851: NULL, -- allow_desc_update_flag_tbl

Line 850: FND_API.g_FALSE, -- match_line_found

846: FND_API.g_FALSE, -- need_to_reject_flag_tbl
847: FND_API.g_FALSE, -- create_line_loc_tbl
848: -1, -- group_num
849: NULL, -- origin_line_num
850: FND_API.g_FALSE, -- match_line_found
851: NULL, -- allow_desc_update_flag_tbl
852: --CLM PDOI Integration
853: intf_lines.contract_type,
854: intf_lines.cost_constraint,

Line 1029: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl

1025: intf_lines.clm_info_flag, /* 10354034 */
1026: intf_lines.group_line_id, --CLM PDOI Integration
1027:
1028: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1029: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1030: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1031: FND_API.g_FALSE, -- create_line_loc_tbl
1032: -1, -- group_num
1033: NULL, -- origin_line_num

Line 1030: FND_API.G_FALSE, -- need_to_reject_flag_tbl

1026: intf_lines.group_line_id, --CLM PDOI Integration
1027:
1028: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1029: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1030: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1031: FND_API.g_FALSE, -- create_line_loc_tbl
1032: -1, -- group_num
1033: NULL, -- origin_line_num
1034: FND_API.g_FALSE, -- match_line_found

Line 1031: FND_API.g_FALSE, -- create_line_loc_tbl

1027:
1028: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1029: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1030: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1031: FND_API.g_FALSE, -- create_line_loc_tbl
1032: -1, -- group_num
1033: NULL, -- origin_line_num
1034: FND_API.g_FALSE, -- match_line_found
1035: NULL, -- allow_desc_update_flag_tbl

Line 1034: FND_API.g_FALSE, -- match_line_found

1030: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1031: FND_API.g_FALSE, -- create_line_loc_tbl
1032: -1, -- group_num
1033: NULL, -- origin_line_num
1034: FND_API.g_FALSE, -- match_line_found
1035: NULL, -- allow_desc_update_flag_tbl
1036: --CLM PDOI Integration
1037: intf_lines.contract_type,
1038: intf_lines.cost_constraint,

Line 1215: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl

1211: intf_lines.clm_info_flag, /* 10354034 */
1212: intf_lines.group_line_id, --CLM PDOI Integration
1213:
1214: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1215: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1216: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1217: FND_API.g_FALSE, -- create_line_loc_tbl
1218: -1, -- group_num
1219: NULL, -- origin_line_num

Line 1216: FND_API.G_FALSE, -- need_to_reject_flag_tbl

1212: intf_lines.group_line_id, --CLM PDOI Integration
1213:
1214: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1215: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1216: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1217: FND_API.g_FALSE, -- create_line_loc_tbl
1218: -1, -- group_num
1219: NULL, -- origin_line_num
1220: FND_API.g_FALSE, -- match_line_found

Line 1217: FND_API.g_FALSE, -- create_line_loc_tbl

1213:
1214: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1215: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1216: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1217: FND_API.g_FALSE, -- create_line_loc_tbl
1218: -1, -- group_num
1219: NULL, -- origin_line_num
1220: FND_API.g_FALSE, -- match_line_found
1221: NULL, -- allow_desc_update_flag_tbl

Line 1220: FND_API.g_FALSE, -- match_line_found

1216: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1217: FND_API.g_FALSE, -- create_line_loc_tbl
1218: -1, -- group_num
1219: NULL, -- origin_line_num
1220: FND_API.g_FALSE, -- match_line_found
1221: NULL, -- allow_desc_update_flag_tbl
1222: --CLM PDOI Integration
1223: intf_lines.contract_type,
1224: intf_lines.cost_constraint,

Line 1405: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl

1401: intf_lines.group_line_id, --CLM PDOI Integration
1402:
1403:
1404: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1405: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1406: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1407: FND_API.g_FALSE, -- create_line_loc_tbl
1408: -1, -- group_num
1409: NULL, -- origin_line_num

Line 1406: FND_API.G_FALSE, -- need_to_reject_flag_tbl

1402:
1403:
1404: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1405: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1406: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1407: FND_API.g_FALSE, -- create_line_loc_tbl
1408: -1, -- group_num
1409: NULL, -- origin_line_num
1410: FND_API.g_FALSE, -- match_line_found

Line 1407: FND_API.g_FALSE, -- create_line_loc_tbl

1403:
1404: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1405: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1406: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1407: FND_API.g_FALSE, -- create_line_loc_tbl
1408: -1, -- group_num
1409: NULL, -- origin_line_num
1410: FND_API.g_FALSE, -- match_line_found
1411: NULL, -- allow_desc_update_flag_tbl

Line 1410: FND_API.g_FALSE, -- match_line_found

1406: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1407: FND_API.g_FALSE, -- create_line_loc_tbl
1408: -1, -- group_num
1409: NULL, -- origin_line_num
1410: FND_API.g_FALSE, -- match_line_found
1411: NULL, -- allow_desc_update_flag_tbl
1412: --clm pdoi integration
1413: intf_lines.contract_type,
1414: intf_lines.cost_constraint,

Line 1598: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl

1594: intf_lines.clm_info_flag, /* 10354034 */
1595: intf_lines.group_line_id, --CLM PDOI Integration
1596:
1597: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1598: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1599: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1600: FND_API.g_FALSE, -- create_line_loc_tbl
1601: -1, -- group_num
1602: NULL, -- origin_line_num

Line 1599: FND_API.G_FALSE, -- need_to_reject_flag_tbl

1595: intf_lines.group_line_id, --CLM PDOI Integration
1596:
1597: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1598: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1599: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1600: FND_API.g_FALSE, -- create_line_loc_tbl
1601: -1, -- group_num
1602: NULL, -- origin_line_num
1603: FND_API.g_FALSE, -- match_line_found

Line 1600: FND_API.g_FALSE, -- create_line_loc_tbl

1596:
1597: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1598: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1599: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1600: FND_API.g_FALSE, -- create_line_loc_tbl
1601: -1, -- group_num
1602: NULL, -- origin_line_num
1603: FND_API.g_FALSE, -- match_line_found
1604: NULL, -- allow_desc_update_flag_tbl

Line 1603: FND_API.g_FALSE, -- match_line_found

1599: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1600: FND_API.g_FALSE, -- create_line_loc_tbl
1601: -1, -- group_num
1602: NULL, -- origin_line_num
1603: FND_API.g_FALSE, -- match_line_found
1604: NULL, -- allow_desc_update_flag_tbl
1605: --clm pdoi integration
1606: intf_lines.contract_type,
1607: intf_lines.cost_constraint,

Line 1794: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl

1790: intf_lines.group_line_id,
1791:
1792: DECODE(intf_lines.process_code,
1793: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1794: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1795: FND_API.g_FALSE, -- need_to_reject_flag_tbl
1796: FND_API.g_FALSE, -- create_line_loc_tbl
1797: -1, -- group_num
1798: NULL, -- origin_line_num

Line 1795: FND_API.g_FALSE, -- need_to_reject_flag_tbl

1791:
1792: DECODE(intf_lines.process_code,
1793: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1794: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1795: FND_API.g_FALSE, -- need_to_reject_flag_tbl
1796: FND_API.g_FALSE, -- create_line_loc_tbl
1797: -1, -- group_num
1798: NULL, -- origin_line_num
1799: FND_API.g_FALSE, -- match_line_found

Line 1796: FND_API.g_FALSE, -- create_line_loc_tbl

1792: DECODE(intf_lines.process_code,
1793: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1794: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1795: FND_API.g_FALSE, -- need_to_reject_flag_tbl
1796: FND_API.g_FALSE, -- create_line_loc_tbl
1797: -1, -- group_num
1798: NULL, -- origin_line_num
1799: FND_API.g_FALSE, -- match_line_found
1800: NULL,

Line 1799: FND_API.g_FALSE, -- match_line_found

1795: FND_API.g_FALSE, -- need_to_reject_flag_tbl
1796: FND_API.g_FALSE, -- create_line_loc_tbl
1797: -1, -- group_num
1798: NULL, -- origin_line_num
1799: FND_API.g_FALSE, -- match_line_found
1800: NULL,
1801: intf_lines.contract_type,
1802: intf_lines.cost_constraint,
1803: intf_lines.note_to_vendor,

Line 2369: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;

2365: p_validation_id => PO_VAL_CONSTANTS.c_part_num_derv,
2366: p_lines => x_lines
2367: );
2368:
2369: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2370: END IF;
2371:
2372: -- derivation error for job_business_group_id
2373: IF (x_lines.job_business_group_name_tbl(i) IS NOT NULL AND

Line 2395: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;

2391: p_token2_name => 'VALUE',
2392: p_token2_value => x_lines.job_business_group_name_tbl(i)
2393: );
2394:
2395: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2396: ELSIF (x_lines.job_name_tbl(i) IS NOT NULL AND -- derivation error for job_id
2397: x_lines.job_id_tbl(i) IS NULL) THEN
2398: IF (PO_LOG.d_stmt) THEN
2399: PO_LOG.stmt(d_module, d_position, 'job id derivation failed');

Line 2420: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;

2416: p_validation_id => PO_VAL_CONSTANTS.c_job_name_derv,
2417: p_lines => x_lines
2418: );
2419:
2420: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2421: END IF;
2422:
2423: -- derivation error for category_id
2424: IF (x_lines.category_tbl(i) IS NOT NULL AND

Line 2448: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;

2444: p_validation_id => PO_VAL_CONSTANTS.c_category_derv,
2445: p_lines => x_lines
2446: );
2447:
2448: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2449: END IF;
2450:
2451: -- derivation error for ip_category_id
2452: IF (PO_PDOI_PARAMS.g_request.document_type IN

Line 2479: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;

2475: p_validation_id => PO_VAL_CONSTANTS.c_ip_category_derv,
2476: p_lines => x_lines
2477: );
2478:
2479: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2480: END IF;
2481: END IF;
2482:
2483: -- derivation error for unit_of_measure

Line 2508: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;

2504: p_validation_id => PO_VAL_CONSTANTS.c_uom_code_derv,
2505: p_lines => x_lines
2506: );
2507:
2508: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2509: END IF;
2510:
2511: -- derivation error for line_type_id
2512: IF (x_lines.line_type_tbl(i) IS NOT NULL AND

Line 2536: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;

2532: p_validation_id => PO_VAL_CONSTANTS.c_line_type_derv,
2533: p_lines => x_lines
2534: );
2535:
2536: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2537: END IF;
2538:
2539: -- derivation error for un_number_id
2540: IF (x_lines.un_number_tbl(i) IS NOT NULL AND

Line 2562: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;

2558: p_token2_name => 'VALUE',
2559: p_token2_value => x_lines.un_number_tbl(i)
2560: );
2561:
2562: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2563: END IF;
2564:
2565: -- derivation error for hazard_class_id
2566: IF (x_lines.hazard_class_tbl(i) IS NOT NULL AND

Line 2588: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;

2584: p_token2_name => 'VALUE',
2585: p_token2_value => x_lines.hazard_class_tbl(i)
2586: );
2587:
2588: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2589: END IF;
2590:
2591: -- derivation error for template_id
2592: IF (x_lines.template_name_tbl(i) IS NOT NULL AND

Line 2614: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;

2610: p_token2_name => 'VALUE',
2611: p_token2_value => x_lines.template_name_tbl(i)
2612: );
2613:
2614: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2615: END IF;
2616:
2617: --CLM PDOI Integration Stsrts
2618: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'

Line 2643: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;

2639: p_token2_name => 'VALUE',
2640: p_token2_value => x_lines.contract_type_display_tbl(i)
2641: );
2642:
2643: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2644: END IF;
2645:
2646: -- derivation error for cost constraint
2647: IF (x_lines.cost_constraint_display_tbl(i) IS NOT NULL AND

Line 2669: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;

2665: p_token2_name => 'VALUE',
2666: p_token2_value => x_lines.cost_constraint_display_tbl(i)
2667: );
2668:
2669: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2670: END IF;
2671:
2672: -- derivation error for clm_idc_type
2673: IF (x_lines.clm_idc_type_display_tbl(i) IS NOT NULL AND

Line 2695: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;

2691: p_token2_name => 'VALUE',
2692: p_token2_value => x_lines.clm_idc_type_display_tbl(i)
2693: );
2694:
2695: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2696: END IF;
2697:
2698: -- derivation error for clm_base_line_num
2699: IF (x_lines.clm_base_line_num_disp_tbl(i) IS NOT NULL AND

Line 2721: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;

2717: p_token2_name => 'VALUE',
2718: p_token2_value => x_lines.clm_base_line_num_disp_tbl(i)
2719: );
2720:
2721: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2722: END IF;
2723:
2724: -- derivation error for from_header_id
2725: IF (x_lines.from_header_disp_tbl(i) IS NOT NULL AND

Line 2747: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;

2743: p_token2_name => 'VALUE',
2744: p_token2_value => x_lines.from_header_disp_tbl(i)
2745: );
2746:
2747: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2748: END IF;
2749:
2750: -- derivation error for from_line_id
2751: IF (x_lines.from_line_disp_tbl(i) IS NOT NULL AND

Line 2773: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;

2769: p_token2_name => 'VALUE',
2770: p_token2_value => x_lines.from_line_disp_tbl(i)
2771: );
2772:
2773: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2774: END IF;
2775:
2776: END IF; --PO_PDOI_PARAMS.g_request.clm_flag='Y'
2777: --CLM PDOI Integration Ends

Line 2960: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;

2956: p_token2_name => 'VALUE',
2957: p_token2_value => x_lines.category_tbl(i)
2958: );
2959:
2960: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2961: END IF;
2962:
2963: -- derivation error for ip_category_id
2964: IF (PO_PDOI_PARAMS.g_request.document_type IN

Line 2989: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;

2985: p_token2_name => 'VALUE',
2986: p_token2_value => x_lines.ip_category_tbl(i)
2987: );
2988:
2989: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2990: END IF;
2991: END IF;
2992:
2993: -- derivation error for unit_of_measure

Line 3016: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;

3012: p_token2_name => 'VALUE',
3013: p_token2_value => x_lines.uom_code_tbl(i)
3014: );
3015:
3016: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
3017: END IF;
3018: END LOOP;
3019:
3020: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);

Line 3799: IF (l_update_lines.create_line_loc_tbl(i) = FND_API.g_FALSE) THEN

3795: l_update_lines.create_line_loc_tbl(i));
3796:
3797: END IF;
3798:
3799: IF (l_update_lines.create_line_loc_tbl(i) = FND_API.g_FALSE) THEN
3800: PO_PDOI_ERR_UTL.add_fatal_error
3801: (
3802: p_interface_header_id => l_update_lines.intf_header_id_tbl(i),
3803: p_interface_line_id => l_update_lines.intf_line_id_tbl(i),

Line 3830: p_cascade => FND_API.g_TRUE

3826: PO_PDOI_UTL.reject_lines_intf
3827: (
3828: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
3829: p_id_tbl => l_rej_intf_line_id_tbl,
3830: p_cascade => FND_API.g_TRUE
3831: );
3832:
3833: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_MATCH);
3834:

Line 3920: x_lines.create_line_loc_tbl(i) := FND_API.g_TRUE;

3916: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
3917: IF (x_lines.order_type_lookup_code_tbl(i) IN ('QUANTITY', 'RATE') AND
3918: x_lines.action_tbl(i) = PO_PDOI_CONSTANTS.g_ACTION_UPDATE AND
3919: (x_lines.quantity_tbl(i) > 0 OR x_lines.shipment_num_tbl(i) IS NOT NULL)) THEN
3920: x_lines.create_line_loc_tbl(i) := FND_API.g_TRUE;
3921: END IF;
3922: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
3923: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
3924: IF (x_lines.order_type_lookup_code_tbl(i) IN ('FIXED PRICE', 'RATE') OR

Line 3926: x_lines.create_line_loc_tbl(i) := FND_API.g_TRUE;

3922: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
3923: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
3924: IF (x_lines.order_type_lookup_code_tbl(i) IN ('FIXED PRICE', 'RATE') OR
3925: x_lines.quantity_tbl(i) > 0) THEN
3926: x_lines.create_line_loc_tbl(i) := FND_API.g_TRUE;
3927: END IF;
3928: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
3929: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
3930: IF (x_lines.order_type_lookup_code_tbl(i) = 'QUANTITY' AND

Line 3932: x_lines.create_line_loc_tbl(i) := FND_API.g_TRUE;

3928: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
3929: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
3930: IF (x_lines.order_type_lookup_code_tbl(i) = 'QUANTITY' AND
3931: (x_lines.quantity_tbl(i) > 0 OR x_lines.shipment_num_tbl(i) IS NOT NULL)) THEN
3932: x_lines.create_line_loc_tbl(i) := FND_API.g_TRUE;
3933: END IF;
3934: END IF;
3935:
3936: IF (PO_LOG.d_stmt) THEN

Line 3945: IF (x_lines.create_line_loc_tbl(i) = FND_API.g_FALSE) THEN

3941: d_position := 20;
3942:
3943: -- mark down locations that need to be obsoleted after the looping
3944:
3945: IF (x_lines.create_line_loc_tbl(i) = FND_API.g_FALSE) THEN
3946: l_obsolete_rec_count := l_obsolete_rec_count + 1;
3947: l_obsoleted_loc_tbl(l_obsolete_rec_count) := x_lines.intf_line_id_tbl(i);
3948: END IF;
3949:

Line 3970: p_cascade => FND_API.g_TRUE

3966: PO_PDOI_UTL.reject_line_locations_intf
3967: (
3968: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
3969: p_id_tbl => l_obsoleted_loc_tbl,
3970: p_cascade => FND_API.g_TRUE
3971: );
3972: */
3973: IF (PO_LOG.d_proc) THEN
3974: PO_LOG.proc_end (d_module);

Line 4030: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND

4026: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING AND
4027: NVL(PO_PDOI_PARAMS.g_request.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) =
4028: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN
4029:
4030: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
4031: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
4032: IF (PO_LOG.d_stmt) THEN
4033: PO_LOG.stmt(d_module, d_position, 'update line process code to ACCEPTED. Index = ', i);
4034: END IF;

Line 4031: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN

4027: NVL(PO_PDOI_PARAMS.g_request.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) =
4028: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN
4029:
4030: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
4031: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
4032: IF (PO_LOG.d_stmt) THEN
4033: PO_LOG.stmt(d_module, d_position, 'update line process code to ACCEPTED. Index = ', i);
4034: END IF;
4035:

Line 4050: DECODE(x_lines.create_line_loc_tbl(i), FND_API.g_TRUE, 'Y', NULL), NULL),

4046: po_header_id = x_lines.po_header_id_tbl(i), --vegajula line for bug 9531925
4047: price_update_tolerance = x_lines.price_update_tolerance_tbl(i),
4048: action = x_lines.action_tbl(i),
4049: price_break_flag = DECODE(x_lines.action_tbl(i), 'UPDATE',
4050: DECODE(x_lines.create_line_loc_tbl(i), FND_API.g_TRUE, 'Y', NULL), NULL),
4051: process_code = x_lines.process_code_tbl(i),
4052: parent_interface_line_id = x_lines.parent_interface_line_id_tbl(i), -- bug5149827
4053: --CLM PDOI Integration
4054: clm_base_line_num = x_lines.clm_base_line_num_tbl(i)

Line 4056: --AND x_lines.error_flag_tbl(i) = FND_API.g_FALSE

4052: parent_interface_line_id = x_lines.parent_interface_line_id_tbl(i), -- bug5149827
4053: --CLM PDOI Integration
4054: clm_base_line_num = x_lines.clm_base_line_num_tbl(i)
4055: WHERE interface_line_id = x_lines.intf_line_id_tbl(i);
4056: --AND x_lines.error_flag_tbl(i) = FND_API.g_FALSE
4057: --AND x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE;
4058:
4059: IF (PO_LOG.d_proc) THEN
4060: PO_LOG.proc_end (d_module);

Line 4057: --AND x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE;

4053: --CLM PDOI Integration
4054: clm_base_line_num = x_lines.clm_base_line_num_tbl(i)
4055: WHERE interface_line_id = x_lines.intf_line_id_tbl(i);
4056: --AND x_lines.error_flag_tbl(i) = FND_API.g_FALSE
4057: --AND x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE;
4058:
4059: IF (PO_LOG.d_proc) THEN
4060: PO_LOG.proc_end (d_module);
4061: END IF;

Line 4302: x_lines.line_num_unique_tbl(l_index) = FND_API.g_FALSE) THEN

4298: x_expire_line_id_tbl(l_count) := x_lines.po_line_id_tbl(l_index);
4299: x_lines.po_line_id_tbl(l_index) :=
4300: PO_PDOI_MAINPROC_UTL_PVT.get_next_po_line_id;
4301: IF (x_lines.origin_line_num_tbl(l_index) IS NULL OR
4302: x_lines.line_num_unique_tbl(l_index) = FND_API.g_FALSE) THEN
4303: x_lines.line_num_tbl(l_index) :=
4304: PO_PDOI_MAINPROC_UTL_PVT.get_next_line_num
4305: (
4306: p_po_header_id => x_lines.hd_po_header_id_tbl(i)

Line 4450: -- FND_API.g_TRUE.

4446: -- x_lines
4447: -- record which stores all the line rows within the batch;
4448: -- If there is error(s) on any attribute of the location row,
4449: -- corresponding value in error_flag_tbl will be set with value
4450: -- FND_API.g_TRUE.
4451: --OUT:
4452: --End of Comments
4453: ------------------------------------------------------------------------
4454: PROCEDURE validate_lines

Line 4623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4619: IF (PO_LOG.d_stmt) THEN
4620: PO_LOG.stmt(d_module, d_position, 'vaidate lines return fatal');
4621: END IF;
4622:
4623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4624: END IF;
4625:
4626: d_position := 70;
4627:

Line 4809: x_error_flag_tbl(l_index) := FND_API.G_TRUE;

4805: IF (x_item_id_tbl(l_index) IS NULL) THEN
4806: x_item_id_tbl(l_index) := l_result_tbl(i);
4807: ELSE
4808: x_item_id_tbl(l_index) := NULL;
4809: x_error_flag_tbl(l_index) := FND_API.G_TRUE;
4810: l_error_exist_tbl(l_index) := l_index;
4811: -- insert error
4812: PO_PDOI_ERR_UTL.add_fatal_error
4813: (

Line 6834: -- 3. x_lines.error_flag_tbl(i) = FND_API.G_FALSE

6830:
6831: -- First, get lines qualified. The qualified lines must satisfy the following conditions:
6832: -- 1. x_lines.line_num_tbl(i) IS NULL
6833: -- 2. x_lines.hd_actions(i) <> 'UPDATE'
6834: -- 3. x_lines.error_flag_tbl(i) = FND_API.G_FALSE
6835: -- 4. document is not AMOUNT based BLANKET
6836: FOR i IN 1..x_lines.rec_count
6837: LOOP
6838: IF (x_lines.line_num_tbl(i) IS NULL) THEN

Line 6840: x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND

6836: FOR i IN 1..x_lines.rec_count
6837: LOOP
6838: IF (x_lines.line_num_tbl(i) IS NULL) THEN
6839: IF (x_lines.hd_action_tbl(i) <> PO_PDOI_CONSTANTS.g_ACTION_UPDATE AND
6840: x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
6841: NOT (x_lines.order_type_lookup_code_tbl(i) = 'AMOUNT' AND
6842: PO_PDOI_PARAMS.g_request.document_type =
6843: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET)) THEN
6844: IF (PO_LOG.d_stmt) THEN

Line 7510: x_lines.match_line_found_tbl(l_index) := FND_API.g_TRUE;

7506: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
7507: x_lines.line_num_tbl(l_index) := l_line_num_tbl(i);
7508: x_processing_row_tbl.DELETE(l_index);
7509: IF (l_line_num_tbl(i) = x_lines.origin_line_num_tbl(l_index)) THEN
7510: x_lines.match_line_found_tbl(l_index) := FND_API.g_TRUE;
7511: END IF;
7512: ELSE
7513: IF (PO_LOG.d_stmt) THEN
7514: PO_LOG.stmt(d_module, d_position, 'multi match index', l_index);

Line 7530: x_lines.match_line_found_tbl(l_index) := FND_API.g_TRUE;

7526: IF (l_line_num_tbl(i) = x_lines.origin_line_num_tbl(l_index)) THEN
7527: -- record matching line_num is found
7528: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
7529: x_lines.line_num_tbl(l_index) := l_line_num_tbl(i);
7530: x_lines.match_line_found_tbl(l_index) := FND_API.g_TRUE;
7531: ELSIF (x_lines.match_line_found_tbl(l_index) = FND_API.g_TRUE) THEN
7532: -- need to do nothing, record with matching line num is found before
7533: NULL;
7534: ELSIF (x_lines.line_num_tbl(l_index) < l_line_num_tbl(i)) THEN

Line 7531: ELSIF (x_lines.match_line_found_tbl(l_index) = FND_API.g_TRUE) THEN

7527: -- record matching line_num is found
7528: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
7529: x_lines.line_num_tbl(l_index) := l_line_num_tbl(i);
7530: x_lines.match_line_found_tbl(l_index) := FND_API.g_TRUE;
7531: ELSIF (x_lines.match_line_found_tbl(l_index) = FND_API.g_TRUE) THEN
7532: -- need to do nothing, record with matching line num is found before
7533: NULL;
7534: ELSIF (x_lines.line_num_tbl(l_index) < l_line_num_tbl(i)) THEN
7535: -- try to update line with maximum line num if exact match can not be found

Line 7602: p_check_line_num_assign => FND_API.G_TRUE,

7598: set_action_add
7599: ( p_key => p_key,
7600: p_group_num => p_group_num,
7601: p_target_lines_index_tbl => l_index_tbl,
7602: p_check_line_num_assign => FND_API.G_TRUE,
7603: x_processing_row_tbl => x_processing_row_tbl,
7604: x_lines => x_lines
7605: );
7606:

Line 7726: NVL(draft_lines.supplier_part_auxid, FND_API.g_NULL_CHAR))=

7722: NVL(draft_lines.item_revision, -99)
7723: AND NVL(x_lines.vendor_product_num_tbl(i), NVL(draft_lines.vendor_product_num, -99)) =
7724: NVL(draft_lines.vendor_product_num, -99)
7725: AND NVL(x_lines.supplier_part_auxid_tbl(i),
7726: NVL(draft_lines.supplier_part_auxid, FND_API.g_NULL_CHAR))=
7727: NVL(draft_lines.supplier_part_auxid, FND_API.g_NULL_CHAR);
7728:
7729: d_position := 10;
7730:

Line 7727: NVL(draft_lines.supplier_part_auxid, FND_API.g_NULL_CHAR);

7723: AND NVL(x_lines.vendor_product_num_tbl(i), NVL(draft_lines.vendor_product_num, -99)) =
7724: NVL(draft_lines.vendor_product_num, -99)
7725: AND NVL(x_lines.supplier_part_auxid_tbl(i),
7726: NVL(draft_lines.supplier_part_auxid, FND_API.g_NULL_CHAR))=
7727: NVL(draft_lines.supplier_part_auxid, FND_API.g_NULL_CHAR);
7728:
7729: d_position := 10;
7730:
7731: -- check matching on txn table

Line 7763: NVL(txn_lines.supplier_part_auxid, FND_API.g_NULL_CHAR)) =

7759: NVL(txn_lines.item_revision, -99)
7760: AND NVL(x_lines.vendor_product_num_tbl(i), NVL(txn_lines.vendor_product_num, -99)) =
7761: NVL(txn_lines.vendor_product_num, -99)
7762: AND NVL(x_lines.supplier_part_auxid_tbl(i),
7763: NVL(txn_lines.supplier_part_auxid, FND_API.g_NULL_CHAR)) =
7764: NVL(txn_lines.supplier_part_auxid, FND_API.g_NULL_CHAR)
7765: AND NVL(txn_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
7766: AND NVL(txn_lines.closed_code, 'OPEN') <> 'FINALLY CLOSED'
7767: AND NVL(txn_lines.cancel_flag, 'N') <> 'Y';

Line 7764: NVL(txn_lines.supplier_part_auxid, FND_API.g_NULL_CHAR)

7760: AND NVL(x_lines.vendor_product_num_tbl(i), NVL(txn_lines.vendor_product_num, -99)) =
7761: NVL(txn_lines.vendor_product_num, -99)
7762: AND NVL(x_lines.supplier_part_auxid_tbl(i),
7763: NVL(txn_lines.supplier_part_auxid, FND_API.g_NULL_CHAR)) =
7764: NVL(txn_lines.supplier_part_auxid, FND_API.g_NULL_CHAR)
7765: AND NVL(txn_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
7766: AND NVL(txn_lines.closed_code, 'OPEN') <> 'FINALLY CLOSED'
7767: AND NVL(txn_lines.cancel_flag, 'N') <> 'Y';
7768:

Line 7800: x_lines.match_line_found_tbl(l_index) := FND_API.g_TRUE;

7796: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
7797: x_lines.line_num_tbl(l_index) := l_line_num_tbl(i);
7798: x_processing_row_tbl.DELETE(l_index);
7799: IF (l_line_num_tbl(i) = x_lines.origin_line_num_tbl(l_index)) THEN
7800: x_lines.match_line_found_tbl(l_index) := FND_API.g_TRUE;
7801: END IF;
7802: ELSE
7803: IF (PO_LOG.d_stmt) THEN
7804: PO_LOG.stmt(d_module, d_position, 'multi match index', l_index);

Line 7820: x_lines.match_line_found_tbl(l_index) := FND_API.g_TRUE;

7816: IF (l_line_num_tbl(i) = x_lines.origin_line_num_tbl(l_index)) THEN
7817: -- record matching line_num is found
7818: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
7819: x_lines.line_num_tbl(l_index) := l_line_num_tbl(i);
7820: x_lines.match_line_found_tbl(l_index) := FND_API.g_TRUE;
7821: ELSIF (x_lines.match_line_found_tbl(l_index) = FND_API.g_TRUE) THEN
7822: -- need to do nothing, record with matching line num is found before
7823: NULL;
7824: ELSIF (x_lines.line_num_tbl(l_index) < l_line_num_tbl(i)) THEN

Line 7821: ELSIF (x_lines.match_line_found_tbl(l_index) = FND_API.g_TRUE) THEN

7817: -- record matching line_num is found
7818: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
7819: x_lines.line_num_tbl(l_index) := l_line_num_tbl(i);
7820: x_lines.match_line_found_tbl(l_index) := FND_API.g_TRUE;
7821: ELSIF (x_lines.match_line_found_tbl(l_index) = FND_API.g_TRUE) THEN
7822: -- need to do nothing, record with matching line num is found before
7823: NULL;
7824: ELSIF (x_lines.line_num_tbl(l_index) < l_line_num_tbl(i)) THEN
7825: -- try to update line with maximum line num if exact match can not be found

Line 7890: NVL(gt.char4, FND_API.g_NULL_CHAR))=

7886: NVL(gt.char2, -99)
7887: AND NVL(x_lines.vendor_product_num_tbl(i), NVL(gt.char3, -99)) =
7888: NVL(gt.char3, -99)
7889: AND NVL(x_lines.supplier_part_auxid_tbl(i),
7890: NVL(gt.char4, FND_API.g_NULL_CHAR))=
7891: NVL(gt.char4, FND_API.g_NULL_CHAR));
7892:
7893: d_position := 50;
7894:

Line 7891: NVL(gt.char4, FND_API.g_NULL_CHAR));

7887: AND NVL(x_lines.vendor_product_num_tbl(i), NVL(gt.char3, -99)) =
7888: NVL(gt.char3, -99)
7889: AND NVL(x_lines.supplier_part_auxid_tbl(i),
7890: NVL(gt.char4, FND_API.g_NULL_CHAR))=
7891: NVL(gt.char4, FND_API.g_NULL_CHAR));
7892:
7893: d_position := 50;
7894:
7895: DELETE FROM po_session_gt

Line 7905: p_check_line_num_assign => FND_API.G_TRUE,

7901: set_action_add
7902: ( p_key => p_key,
7903: p_group_num => p_group_num,
7904: p_target_lines_index_tbl => l_index_tbl,
7905: p_check_line_num_assign => FND_API.G_TRUE,
7906: x_processing_row_tbl => x_processing_row_tbl,
7907: x_lines => x_lines
7908: );
7909:

Line 8000: NVL(draft_lines.supplier_part_auxid, FND_API.g_NULL_CHAR))=

7996: AND draft_lines.draft_id = x_lines.draft_id_tbl(i)
7997: AND NVL(draft_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
7998: AND draft_lines.vendor_product_num = x_lines.vendor_product_num_tbl(i)
7999: AND NVL(x_lines.supplier_part_auxid_tbl(i),
8000: NVL(draft_lines.supplier_part_auxid, FND_API.g_NULL_CHAR))=
8001: NVL(draft_lines.supplier_part_auxid, FND_API.g_NULL_CHAR);
8002:
8003: d_position := 10;
8004:

Line 8001: NVL(draft_lines.supplier_part_auxid, FND_API.g_NULL_CHAR);

7997: AND NVL(draft_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
7998: AND draft_lines.vendor_product_num = x_lines.vendor_product_num_tbl(i)
7999: AND NVL(x_lines.supplier_part_auxid_tbl(i),
8000: NVL(draft_lines.supplier_part_auxid, FND_API.g_NULL_CHAR))=
8001: NVL(draft_lines.supplier_part_auxid, FND_API.g_NULL_CHAR);
8002:
8003: d_position := 10;
8004:
8005: -- check matching on txn table

Line 8029: NVL(txn_lines.supplier_part_auxid, FND_API.g_NULL_CHAR))=

8025: WHERE draft_lines.po_line_id = txn_lines.po_line_id
8026: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
8027: AND txn_lines.vendor_product_num = x_lines.vendor_product_num_tbl(i)
8028: AND NVL(x_lines.supplier_part_auxid_tbl(i),
8029: NVL(txn_lines.supplier_part_auxid, FND_API.g_NULL_CHAR))=
8030: NVL(txn_lines.supplier_part_auxid, FND_API.g_NULL_CHAR)
8031: AND NVL(txn_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
8032: AND NVL(txn_lines.closed_code, 'OPEN') <> 'FINALLY CLOSED'
8033: AND NVL(txn_lines.cancel_flag, 'N') <> 'Y';

Line 8030: NVL(txn_lines.supplier_part_auxid, FND_API.g_NULL_CHAR)

8026: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
8027: AND txn_lines.vendor_product_num = x_lines.vendor_product_num_tbl(i)
8028: AND NVL(x_lines.supplier_part_auxid_tbl(i),
8029: NVL(txn_lines.supplier_part_auxid, FND_API.g_NULL_CHAR))=
8030: NVL(txn_lines.supplier_part_auxid, FND_API.g_NULL_CHAR)
8031: AND NVL(txn_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
8032: AND NVL(txn_lines.closed_code, 'OPEN') <> 'FINALLY CLOSED'
8033: AND NVL(txn_lines.cancel_flag, 'N') <> 'Y';
8034:

Line 8066: x_lines.match_line_found_tbl(l_index) := FND_API.g_TRUE;

8062: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
8063: x_lines.line_num_tbl(l_index) := l_line_num_tbl(i);
8064: x_processing_row_tbl.DELETE(l_index);
8065: IF (l_line_num_tbl(i) = x_lines.origin_line_num_tbl(l_index)) THEN
8066: x_lines.match_line_found_tbl(l_index) := FND_API.g_TRUE;
8067: END IF;
8068: ELSE
8069: IF (PO_LOG.d_stmt) THEN
8070: PO_LOG.stmt(d_module, d_position, 'multi match index', l_index);

Line 8086: x_lines.match_line_found_tbl(l_index) := FND_API.g_TRUE;

8082: IF (l_line_num_tbl(i) = x_lines.origin_line_num_tbl(l_index)) THEN
8083: -- record matching line_num is found
8084: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
8085: x_lines.line_num_tbl(l_index) := l_line_num_tbl(i);
8086: x_lines.match_line_found_tbl(l_index) := FND_API.g_TRUE;
8087: ELSIF (x_lines.match_line_found_tbl(l_index) = FND_API.g_TRUE) THEN
8088: -- need to do nothing, record with matching line num is found before
8089: NULL;
8090: ELSIF (x_lines.line_num_tbl(l_index) < l_line_num_tbl(i)) THEN

Line 8087: ELSIF (x_lines.match_line_found_tbl(l_index) = FND_API.g_TRUE) THEN

8083: -- record matching line_num is found
8084: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
8085: x_lines.line_num_tbl(l_index) := l_line_num_tbl(i);
8086: x_lines.match_line_found_tbl(l_index) := FND_API.g_TRUE;
8087: ELSIF (x_lines.match_line_found_tbl(l_index) = FND_API.g_TRUE) THEN
8088: -- need to do nothing, record with matching line num is found before
8089: NULL;
8090: ELSIF (x_lines.line_num_tbl(l_index) < l_line_num_tbl(i)) THEN
8091: -- try to update line with maximum line num if exact match can not be found

Line 8146: NVL(gt.char2, FND_API.g_NULL_CHAR))=

8142: AND gt.num1 < x_lines.intf_line_id_tbl(i)
8143: AND gt.num2 = x_lines.hd_po_header_id_tbl(i)
8144: AND gt.char1 = x_lines.vendor_product_num_tbl(i)
8145: AND NVL(x_lines.supplier_part_auxid_tbl(i),
8146: NVL(gt.char2, FND_API.g_NULL_CHAR))=
8147: NVL(gt.char2, FND_API.g_NULL_CHAR));
8148:
8149: d_position := 50;
8150:

Line 8147: NVL(gt.char2, FND_API.g_NULL_CHAR));

8143: AND gt.num2 = x_lines.hd_po_header_id_tbl(i)
8144: AND gt.char1 = x_lines.vendor_product_num_tbl(i)
8145: AND NVL(x_lines.supplier_part_auxid_tbl(i),
8146: NVL(gt.char2, FND_API.g_NULL_CHAR))=
8147: NVL(gt.char2, FND_API.g_NULL_CHAR));
8148:
8149: d_position := 50;
8150:
8151: DELETE FROM po_session_gt

Line 8163: p_check_line_num_assign => FND_API.G_TRUE,

8159: set_action_add
8160: ( p_key => p_key,
8161: p_group_num => p_group_num,
8162: p_target_lines_index_tbl => l_index_tbl,
8163: p_check_line_num_assign => FND_API.G_TRUE,
8164: x_processing_row_tbl => x_processing_row_tbl,
8165: x_lines => x_lines
8166: );
8167:

Line 8327: x_lines.match_line_found_tbl(l_index) := FND_API.g_TRUE;

8323: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
8324: x_lines.line_num_tbl(l_index) := l_line_num_tbl(i);
8325: x_processing_row_tbl.DELETE(l_index);
8326: IF (l_line_num_tbl(i) = x_lines.origin_line_num_tbl(l_index)) THEN
8327: x_lines.match_line_found_tbl(l_index) := FND_API.g_TRUE;
8328: END IF;
8329: ELSE
8330: IF (PO_LOG.d_stmt) THEN
8331: PO_LOG.stmt(d_module, d_position, 'multi match index', l_index);

Line 8347: x_lines.match_line_found_tbl(l_index) := FND_API.g_TRUE;

8343: IF (l_line_num_tbl(i) = x_lines.origin_line_num_tbl(l_index)) THEN
8344: -- record matching line_num is found
8345: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
8346: x_lines.line_num_tbl(l_index) := l_line_num_tbl(i);
8347: x_lines.match_line_found_tbl(l_index) := FND_API.g_TRUE;
8348: ELSIF (x_lines.match_line_found_tbl(l_index) = FND_API.g_TRUE) THEN
8349: -- need to do nothing, record with matching line num is found before
8350: NULL;
8351: ELSIF (x_lines.line_num_tbl(l_index) < l_line_num_tbl(i)) THEN

Line 8348: ELSIF (x_lines.match_line_found_tbl(l_index) = FND_API.g_TRUE) THEN

8344: -- record matching line_num is found
8345: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
8346: x_lines.line_num_tbl(l_index) := l_line_num_tbl(i);
8347: x_lines.match_line_found_tbl(l_index) := FND_API.g_TRUE;
8348: ELSIF (x_lines.match_line_found_tbl(l_index) = FND_API.g_TRUE) THEN
8349: -- need to do nothing, record with matching line num is found before
8350: NULL;
8351: ELSIF (x_lines.line_num_tbl(l_index) < l_line_num_tbl(i)) THEN
8352: -- try to update line with maximum line num if exact match can not be found

Line 8418: p_check_line_num_assign => FND_API.G_TRUE,

8414: set_action_add
8415: ( p_key => p_key,
8416: p_group_num => p_group_num,
8417: p_target_lines_index_tbl => l_index_tbl,
8418: p_check_line_num_assign => FND_API.G_TRUE,
8419: x_processing_row_tbl => x_processing_row_tbl,
8420: x_lines => x_lines
8421: );
8422:

Line 8629: p_check_line_num_assign => FND_API.G_FALSE,

8625: set_action_add
8626: ( p_key => p_key,
8627: p_group_num => p_group_num,
8628: p_target_lines_index_tbl => l_index_tbl,
8629: p_check_line_num_assign => FND_API.G_FALSE,
8630: x_processing_row_tbl => x_processing_row_tbl,
8631: x_lines => x_lines
8632: );
8633:

Line 8673: -- If FND_API.G_TRUE, then it checks whether a new line number needs

8669: -- p_target_line_index_tbl
8670: -- Table containing indexes for the lines to be assigned with action
8671: -- 'ADD'
8672: -- p_check_line_num_assign
8673: -- If FND_API.G_TRUE, then it checks whether a new line number needs
8674: -- to be assigned to the record. FND_API.G_FALSE otherwise.
8675: --IN OUT:
8676: -- x_processing_row_tbl
8677: -- index table of rows that are going to be processed

Line 8674: -- to be assigned to the record. FND_API.G_FALSE otherwise.

8670: -- Table containing indexes for the lines to be assigned with action
8671: -- 'ADD'
8672: -- p_check_line_num_assign
8673: -- If FND_API.G_TRUE, then it checks whether a new line number needs
8674: -- to be assigned to the record. FND_API.G_FALSE otherwise.
8675: --IN OUT:
8676: -- x_processing_row_tbl
8677: -- index table of rows that are going to be processed
8678: -- x_lines

Line 8718: IF (p_check_line_num_assign = FND_API.G_TRUE) THEN

8714: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_ADD;
8715: x_lines.group_num_tbl(l_index) := p_group_num;
8716: x_lines.po_line_id_tbl(l_index) := PO_PDOI_MAINPROC_UTL_PVT.get_next_po_line_id;
8717:
8718: IF (p_check_line_num_assign = FND_API.G_TRUE) THEN
8719:
8720:
8721: IF (x_lines.line_num_tbl(l_index) IS NULL OR
8722: x_lines.line_num_unique_tbl(l_index) = FND_API.g_FALSE) THEN

Line 8722: x_lines.line_num_unique_tbl(l_index) = FND_API.g_FALSE) THEN

8718: IF (p_check_line_num_assign = FND_API.G_TRUE) THEN
8719:
8720:
8721: IF (x_lines.line_num_tbl(l_index) IS NULL OR
8722: x_lines.line_num_unique_tbl(l_index) = FND_API.g_FALSE) THEN
8723:
8724: d_position := 20;
8725:
8726: x_lines.line_num_tbl(l_index) :=

Line 8872: x_lines.error_flag_tbl(l_index) := FND_API.g_TRUE;

8868: p_validation_id => PO_VAL_CONSTANTS.c_language,
8869: p_lines => x_lines
8870: );
8871:
8872: x_lines.error_flag_tbl(l_index) := FND_API.g_TRUE;
8873: END LOOP;
8874:
8875: IF (PO_LOG.d_proc) THEN
8876: PO_LOG.proc_end(d_module);

Line 8893: -- corresponding value in error_flag_tbl will be set with value FND_API.G_FALSE.

8889: -----------------------------------------------------------------------
8890: --Start of Comments
8891: --Name: populate_error_flag
8892: --Function:
8893: -- corresponding value in error_flag_tbl will be set with value FND_API.G_FALSE.
8894: --Parameters:
8895: --IN:
8896: --x_results
8897: -- The validation results that contains the errored line information.

Line 8903: -- FND_API.G_FALSE.

8899: --x_lines
8900: -- The record contains the values to be validated.
8901: -- If there is error(s) on any attribute of the price differential row,
8902: -- corresponding value in error_flag_tbl will be set with value
8903: -- FND_API.G_FALSE.
8904: --OUT:
8905: --End of Comments
8906: ------------------------------------------------------------------------
8907: PROCEDURE populate_error_flag

Line 8941: x_lines.error_flag_tbl(l_index_tbl(x_results.entity_id(i))) := FND_API.g_TRUE;

8937: PO_LOG.stmt(d_module, d_position, 'error on index',
8938: l_index_tbl(x_results.entity_id(i)));
8939: END IF;
8940:
8941: x_lines.error_flag_tbl(l_index_tbl(x_results.entity_id(i))) := FND_API.g_TRUE;
8942: END IF;
8943: END LOOP;
8944:
8945: IF (PO_LOG.d_proc) THEN

Line 9019: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).err_tolerance_exceeded = FND_API.G_TRUE ) THEN

9015:
9016: d_position := 10;
9017:
9018: IF (PO_PDOI_PARAMS.g_request.calling_module = PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND
9019: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).err_tolerance_exceeded = FND_API.G_TRUE ) THEN
9020: x_lines.need_to_reject_flag_tbl(i) := FND_API.g_TRUE;
9021:
9022: -- bug 5215781:
9023: -- collect ids of lines for which errors on them would be removed from error interface

Line 9020: x_lines.need_to_reject_flag_tbl(i) := FND_API.g_TRUE;

9016: d_position := 10;
9017:
9018: IF (PO_PDOI_PARAMS.g_request.calling_module = PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND
9019: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).err_tolerance_exceeded = FND_API.G_TRUE ) THEN
9020: x_lines.need_to_reject_flag_tbl(i) := FND_API.g_TRUE;
9021:
9022: -- bug 5215781:
9023: -- collect ids of lines for which errors on them would be removed from error interface
9024: -- table since error tolerance threshold is hit before them

Line 9037: IF x_lines.error_flag_tbl(i) = FND_API.g_TRUE THEN

9033: END IF;
9034:
9035: d_position := 20;
9036:
9037: IF x_lines.error_flag_tbl(i) = FND_API.g_TRUE THEN
9038: l_num_errored_lines := PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines + 1;
9039: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines := l_num_errored_lines;
9040:
9041: -- set corresponding line to ERROR

Line 9054: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).err_tolerance_exceeded := FND_API.g_TRUE;

9050: IF (PO_PDOI_PARAMS.g_request.calling_module =
9051: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND
9052: l_num_errored_lines = l_err_lines_tolerance) THEN
9053:
9054: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).err_tolerance_exceeded := FND_API.g_TRUE;
9055: END IF;
9056:
9057: d_position := 40;
9058: ELSE