3151: , p_item_id_tbl => p_lines.item_id
3152: , p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code
3153: , p_line_type_id_tbl => p_lines.line_type_id
3154: , p_clm_info_flag_tbl => p_lines.clm_info_flag
3155: , p_message_name => PO_MESSAGE_S.PO_PDOI_ITEM_NOT_NULL
3156: , x_result_set_id => l_result_set_id
3157: , x_result_type => l_result_type
3158: );
3159: ELSE
3162: , p_item_id_tbl => p_lines.item_id
3163: , p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code
3164: , p_line_type_id_tbl => p_lines.line_type_id
3165: , p_clm_info_flag_tbl => p_lines.clm_info_flag
3166: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
3167: , x_result_set_id => l_result_set_id
3168: , x_result_type => l_result_type
3169: );
3170: END IF;
5967: p_value_tbl => p_po_line_ucas.UNDEF_AMOUNT,
5968: p_entity_id_tbl => p_po_line_ucas.PO_LINE_UCA_ID,
5969: p_entity_type => c_entity_type_LINE_UCAS,
5970: p_column_name => 'UNDEF_AMOUNT',
5971: p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO,
5972: p_validation_id => PO_VAL_CONSTANTS.c_undef_amt_gt_zero,
5973: x_results => x_results,
5974: x_result_type => l_result_type);
5975:
5979: p_value_tbl => p_po_line_ucas.LIMIT_GOV_LIABILITY_AMT,
5980: p_entity_id_tbl => p_po_line_ucas.PO_LINE_UCA_ID,
5981: p_entity_type => c_entity_type_LINE_UCAS,
5982: p_column_name => 'LIMIT_GOV_LIABILITY_AMT',
5983: p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO,
5984: p_validation_id => PO_VAL_CONSTANTS.c_lgl_gt_zero,
5985: x_results => x_results,
5986: x_result_type => l_result_type);
5987:
5991: p_value_tbl => p_po_line_ucas.NOT_TO_EXCEED_AMOUNT,
5992: p_entity_id_tbl => p_po_line_ucas.PO_LINE_UCA_ID,
5993: p_entity_type => c_entity_type_LINE_UCAS,
5994: p_column_name => 'NOT_TO_EXCEED_AMOUNT',
5995: p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO,
5996: p_validation_id => PO_VAL_CONSTANTS.c_nte_gt_zero,
5997: x_results => x_results,
5998: x_result_type => l_result_type);
5999: WHEN c_lgl_le_nte THEN
6003: , p_num2_tbl => p_po_line_ucas.NOT_TO_EXCEED_AMOUNT
6004: , p_entity_id_tbl => p_po_line_ucas.PO_LINE_UCA_ID
6005: , p_entity_type => c_entity_type_LINE_UCAS
6006: , p_column_name => 'LIMIT_GOV_LIABILITY_AMT'
6007: , p_message_name => PO_MESSAGE_S.PO_UCA_LGL_LE_NTE
6008: , x_results => x_results
6009: , x_result_type => l_result_type);
6010: WHEN c_undef_amt_le_nte THEN
6011: PO_VALIDATION_HELPER.num1_less_or_equal_num2(
6014: , p_num2_tbl => p_po_line_ucas.NOT_TO_EXCEED_AMOUNT
6015: , p_entity_id_tbl => p_po_line_ucas.PO_LINE_UCA_ID
6016: , p_entity_type => c_entity_type_LINE_UCAS
6017: , p_column_name => 'UNDEF_AMOUNT'
6018: , p_message_name => PO_MESSAGE_S.PO_UCA_UNDEF_LE_NTE
6019: , x_results => x_results
6020: , x_result_type => l_result_type);
6021: WHEN c_undef_amt_le_line_amt THEN
6022: -- bug 16461105
6071: p_result_type => c_result_type_FATAL
6072: , p_entity_type => NULL
6073: , p_entity_id => NULL
6074: , p_column_name => NULL
6075: , p_message_name => PO_MESSAGE_S.PO_ALL_SQL_ERROR
6076: , p_token1_name => PO_MESSAGE_S.c_ROUTINE_token
6077: , p_token1_value => d_mod
6078: , p_token2_name => PO_MESSAGE_S.c_ERR_NUMBER_token
6079: , p_token2_value => TO_CHAR(d_position)
6072: , p_entity_type => NULL
6073: , p_entity_id => NULL
6074: , p_column_name => NULL
6075: , p_message_name => PO_MESSAGE_S.PO_ALL_SQL_ERROR
6076: , p_token1_name => PO_MESSAGE_S.c_ROUTINE_token
6077: , p_token1_value => d_mod
6078: , p_token2_name => PO_MESSAGE_S.c_ERR_NUMBER_token
6079: , p_token2_value => TO_CHAR(d_position)
6080: , p_token3_name => PO_MESSAGE_S.c_SQL_ERR_token
6074: , p_column_name => NULL
6075: , p_message_name => PO_MESSAGE_S.PO_ALL_SQL_ERROR
6076: , p_token1_name => PO_MESSAGE_S.c_ROUTINE_token
6077: , p_token1_value => d_mod
6078: , p_token2_name => PO_MESSAGE_S.c_ERR_NUMBER_token
6079: , p_token2_value => TO_CHAR(d_position)
6080: , p_token3_name => PO_MESSAGE_S.c_SQL_ERR_token
6081: , p_token3_value => l_val
6082: , p_token4_name => PO_MESSAGE_S.c_LSQL_ERR_token
6076: , p_token1_name => PO_MESSAGE_S.c_ROUTINE_token
6077: , p_token1_value => d_mod
6078: , p_token2_name => PO_MESSAGE_S.c_ERR_NUMBER_token
6079: , p_token2_value => TO_CHAR(d_position)
6080: , p_token3_name => PO_MESSAGE_S.c_SQL_ERR_token
6081: , p_token3_value => l_val
6082: , p_token4_name => PO_MESSAGE_S.c_LSQL_ERR_token
6083: , p_token4_value => SQLERRM
6084: );
6078: , p_token2_name => PO_MESSAGE_S.c_ERR_NUMBER_token
6079: , p_token2_value => TO_CHAR(d_position)
6080: , p_token3_name => PO_MESSAGE_S.c_SQL_ERR_token
6081: , p_token3_value => l_val
6082: , p_token4_name => PO_MESSAGE_S.c_LSQL_ERR_token
6083: , p_token4_value => SQLERRM
6084: );
6085:
6086: END;