DBA Data[Home] [Help]

APPS.PO_VALIDATION_HELPER dependencies on PO_MESSAGE_S

Line 198: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO);

194: ELSE
195: l_null_not_allowed := TRUE;
196: END IF;
197:
198: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO);
199:
200: IF PO_LOG.d_stmt THEN
201: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
202: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);

Line 335: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO);

331: ELSE
332: l_null_not_allowed := TRUE;
333: END IF;
334:
335: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO);
336:
337: IF PO_LOG.d_stmt THEN
338: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
339: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);

Line 467: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_PERCENT);

463: ELSE
464: l_null_not_allowed := TRUE;
465: END IF;
466:
467: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_PERCENT);
468:
469: IF (p_token1_value_tbl IS NULL) THEN
470: l_token1_value_tbl := PO_TBL_VARCHAR4000();
471: l_token1_value_tbl.extend(p_value_tbl.COUNT);

Line 1149: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO

1145: , p_value_tbl => l_value_tbl
1146: , p_entity_id_tbl => l_entity_id_tbl
1147: , p_entity_type => p_entity_type
1148: , p_column_name => p_column_name
1149: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO
1150: , x_results => x_results
1151: , x_result_type => x_result_type
1152: );
1153:

Line 1598: l_message_name := PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_DIST_NUM;

1594:
1595: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_DISTRIBUTION) THEN
1596:
1597: l_column_name := c_DISTRIBUTION_NUM;
1598: l_message_name := PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_DIST_NUM;
1599:
1600: FORALL i IN 1 .. l_parent_id_tbl.COUNT
1601: INSERT INTO PO_SESSION_GT
1602: ( key

Line 1623: l_message_name := PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_SHIP_NUM;

1619:
1620: ELSIF (p_entity_type = PO_VALIDATIONS.c_entity_type_LINE_LOCATION) THEN
1621:
1622: l_column_name := c_SHIPMENT_NUM;
1623: l_message_name := PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_SHIP_NUM;
1624:
1625: FORALL i IN 1 .. l_parent_id_tbl.COUNT
1626: INSERT INTO PO_SESSION_GT
1627: ( key

Line 1654: l_message_name := PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_LINE_NUM;

1650:
1651: ELSE -- p_entity_type = PO_VALIDATIONS.c_entity_type_LINE
1652:
1653: l_column_name := c_LINE_NUM;
1654: l_message_name := PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_LINE_NUM;
1655:
1656: FORALL i IN 1 .. l_parent_id_tbl.COUNT
1657: INSERT INTO PO_SESSION_GT
1658: ( key

Line 1738: PO_CONSTANTS_SV.SHIP_TYPE_PRICE_BREAK, PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_PRC_BRK_NUM,

1734: , CHILD.index_num2
1735: , l_column_name
1736: , TO_CHAR(CHILD.num1)
1737: , decode(char1,
1738: PO_CONSTANTS_SV.SHIP_TYPE_PRICE_BREAK, PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_PRC_BRK_NUM,
1739: l_message_name)
1740: FROM
1741: PO_SESSION_GT CHILD
1742: WHERE

Line 2470: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO

2466: , p_value_tbl => l_value_tbl
2467: , p_entity_id_tbl => l_entity_id_tbl
2468: , p_entity_type => p_entity_type
2469: , p_column_name => p_column_name
2470: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO
2471: , x_results => x_results
2472: , x_result_type => x_result_type
2473: );
2474: