[Home] [Help]
227: PO_LOG.proc_begin(d_module, 'p_max_intf_dist_id', p_max_intf_dist_id);
228: END IF;
229:
230: OPEN x_dists_csr FOR
231: SELECT /*+ INDEX (intf_dists PO_DISTRIBUTIONS_INTERFACE_N1) */
232: intf_dists.interface_distribution_id,
233: intf_dists.interface_header_id,
234: intf_dists.interface_line_id,
235: intf_dists.interface_line_location_id,
436: intf_dists.quantity_funded,
437: intf_dists.amount_funded,
438: intf_dists.clm_misc_loa
439:
440: FROM po_distributions_interface intf_dists,
441: po_line_locations_interface intf_locs,
442: po_headers_interface intf_headers,
443: po_line_locations_draft_all draft_locs,
444: po_lines_draft_all draft_lines,
1114: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1115: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1116: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1117: p_error_message_name => 'PO_PDOI_GMS_ERROR',
1118: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1119: p_column_name => 'AWARD_NUMBER',
1120: p_column_value => x_dists.award_num_tbl(i),
1121: p_error_message => l_msg_data
1122: );
1163: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1164: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1165: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1166: p_error_message_name => 'PO_PDOI_INVALID_DEL_LOCATION',
1167: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1168: p_column_name => 'DELIVER_TO_LOCATION',
1169: p_column_value => x_dists.deliver_to_loc_tbl(i),
1170: p_token1_name => 'DELIVER_TO_LOCATION',
1171: p_token1_value => x_dists.deliver_to_loc_tbl(i)
1189: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1190: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1191: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1192: p_error_message_name => 'PO_PDOI_INVALID_DEL_PERSON',
1193: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1194: p_column_name => 'DELIVER_TO_PERSON',
1195: p_column_value => x_dists.deliver_to_person_name_tbl(i),
1196: p_token1_name => 'DELIVER_TO_PERSON',
1197: p_token1_value => x_dists.deliver_to_person_name_tbl(i)
1215: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1216: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1217: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1218: p_error_message_name => 'PO_PDOI_INVALID_DEST_TYPE',
1219: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1220: p_column_name => 'DESTINATION_TYPE',
1221: p_column_value => x_dists.dest_type_tbl(i),
1222: p_token1_name => 'DESTINATION_TYPE',
1223: p_token1_value => x_dists.dest_type_tbl(i)
1241: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1242: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1243: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1244: p_error_message_name => 'PO_PDOI_INVALID_DEST_ORG',
1245: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1246: p_column_name => 'DESTINATION_ORGANIZATION',
1247: p_column_value => x_dists.dest_org_tbl(i),
1248: p_token1_name => 'DESTINATION_ORGANIZATION',
1249: p_token1_value => x_dists.dest_org_tbl(i)
1269: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1270: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1271: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1272: p_error_message_name => 'PO_PDOI_INVALID_WIP_ENTITY',
1273: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1274: p_column_name => 'WIP_ENTITY',
1275: p_column_value => x_dists.wip_entity_tbl(i),
1276: p_token1_name => 'WIP_ENTITY',
1277: p_token1_value => x_dists.wip_entity_tbl(i)
1295: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1296: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1297: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1298: p_error_message_name => 'PO_PDOI_INVALID_WIP_LINE',
1299: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1300: p_column_name => 'WIP_LINE_CODE',
1301: p_column_value => x_dists.wip_line_code_tbl(i),
1302: p_token1_name => 'WIP_LINE_CODE',
1303: p_token1_value => x_dists.wip_line_code_tbl(i)
1322: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1323: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1324: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1325: p_error_message_name => 'PO_PDOI_INVALID_BOM_RESOURCE',
1326: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1327: p_column_name => 'BOM_RESOURCE_CODE',
1328: p_column_value => x_dists.bom_resource_code_tbl(i),
1329: p_token1_name => 'BOM_RESOURCE_CODE',
1330: p_token1_value => x_dists.bom_resource_code_tbl(i)
1347: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1348: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1349: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1350: p_error_message_name => 'PO_PDOI_INVALID_DEST_ORG',
1351: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1352: p_column_name => 'DESTINATION_ORGANIZATION',
1353: p_column_value => x_dists.dest_org_tbl(i),
1354: p_token1_name => 'DESTINATION_ORGANIZATION',
1355: p_token1_value => x_dists.dest_org_tbl(i)
1380: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1381: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1382: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1383: p_error_message_name => 'PO_PDOI_INVALID_PROJECT',
1384: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1385: p_column_name => 'PROJECT',
1386: p_column_value => x_dists.project_tbl(i),
1387: p_token1_name => 'PROJECT',
1388: p_token1_value => x_dists.project_tbl(i)
1407: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1408: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1409: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1410: p_error_message_name => 'PO_PDOI_INVALID_TASK',
1411: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1412: p_column_name => 'TASK',
1413: p_column_value => x_dists.task_tbl(i),
1414: p_token1_name => 'TASK',
1415: p_token1_value => x_dists.task_tbl(i)
1434: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1435: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1436: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1437: p_error_message_name => 'PO_PDOI_INVALID_EXPEND_TYPE',
1438: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1439: p_column_name => 'EXPENDITURE',
1440: p_column_value => x_dists.expenditure_tbl(i),
1441: p_token1_name => 'EXPENDITURE',
1442: p_token1_value => x_dists.expenditure_tbl(i)
1461: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1462: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1463: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1464: p_error_message_name => 'PO_PDOI_INVALID_EXPEND_ORG',
1465: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1466: p_column_name => 'EXPENDITURE_ORGANIZATION',
1467: p_column_value => x_dists.expenditure_org_tbl(i),
1468: p_token1_name => 'EXPENDITURE_ORGANIZATION',
1469: p_token1_value => x_dists.expenditure_org_tbl(i)
1486: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1487: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1488: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1489: p_error_message_name => 'PO_PDOI_INVALID_EXPEND_DATE',
1490: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1491: p_column_name => 'EXPENDITURE',
1492: p_column_value => x_dists.expenditure_tbl(i),
1493: p_token1_name => 'EXPENDITURE',
1494: p_token1_value => x_dists.expenditure_tbl(i)
1787: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1788: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1789: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1790: p_error_message_name => 'PO_PDOI_GMS_ERROR',
1791: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1792: p_column_name => 'AWARD_NUMBER',
1793: p_column_value => x_dists.award_num_tbl(i),
1794: p_error_message => l_msg_data
1795: );
1835: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1836: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1837: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1838: p_error_message_name => 'PO_PDOI_GMS_ERROR',
1839: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1840: p_column_name => 'AWARD_NUMBER',
1841: p_column_value => x_dists.award_num_tbl(i),
1842: p_error_message => l_msg_data
1843: );
2075: p_interface_line_id => x_dists.intf_line_id_tbl(i),
2076: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
2077: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
2078: p_error_message_name => 'PO_PDOI_CHARGE_FAILED',
2079: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
2080: p_column_name => 'CHARGE_ACCOUNT_ID',
2081: p_column_value => x_dists.charge_account_id_tbl(i)
2082: );
2083:
2090: p_interface_line_id => x_dists.intf_line_id_tbl(i),
2091: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
2092: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
2093: p_error_message_name => 'PO_PDOI_BUDGET_FAILED',
2094: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
2095: p_column_name => 'BUDGET_ACCOUNT_ID',
2096: p_column_value => x_dists.budget_account_id_tbl(i)
2097: );
2098:
2104: p_interface_line_id => x_dists.intf_line_id_tbl(i),
2105: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
2106: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
2107: p_error_message_name => 'PO_PDOI_ACCRUAL_FAILED',
2108: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
2109: p_column_name => 'ACCRUAL_ACCOUNT_ID',
2110: p_column_value => x_dists.accrual_account_id_tbl(i)
2111: );
2112:
2118: p_interface_line_id => x_dists.intf_line_id_tbl(i),
2119: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
2120: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
2121: p_error_message_name => 'PO_PDOI_VARIANCE_FAILED',
2122: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
2123: p_column_name => 'VARIANCE_ACCOUNT_ID',
2124: p_column_value => x_dists.variance_account_id_tbl(i)
2125: );
2126:
2161: p_interface_line_id => x_dists.intf_line_id_tbl(i),
2162: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
2163: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
2164: p_error_message_name => 'PO_PO_ENTER_OPEN_GL_DATE',
2165: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
2166: p_column_name => 'GL_ENCUMBERED_DATE',
2167: p_column_value => x_dists.gl_encumbered_date_tbl(i)
2168: );
2169:
2358:
2359: PO_PDOI_ERR_UTL.process_val_type_errors
2360: (
2361: x_results => l_results,
2362: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
2363: p_distributions => x_dists
2364: );
2365:
2366: d_position := 30;
3575: p_interface_line_id => x_dists.intf_line_id_tbl(p_index),
3576: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(p_index),
3577: p_interface_distribution_id => x_dists.intf_dist_id_tbl(p_index),
3578: p_error_message_name => l_error_msg,
3579: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
3580: p_column_name => 'PROJECT_ID',
3581: p_column_value => x_dists.project_id_tbl(p_index)
3582: );
3583:
3605: p_interface_line_id => x_dists.intf_line_id_tbl(p_index),
3606: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(p_index),
3607: p_interface_distribution_id => x_dists.intf_dist_id_tbl(p_index),
3608: p_error_message_name => l_error_msg,
3609: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
3610: p_column_name => 'AWARD_ID',
3611: p_column_value => x_dists.award_id_tbl(p_index)
3612: );
3613: