DBA Data[Home] [Help]

APPS.PO_VALIDATION_HELPER dependencies on PO_MESSAGE_S

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

204: ELSE
205: l_null_not_allowed := TRUE;
206: END IF;
207:
208: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO);
209:
210: IF PO_LOG.d_stmt THEN
211: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
212: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);

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

341: ELSE
342: l_null_not_allowed := TRUE;
343: END IF;
344:
345: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO);
346:
347: IF PO_LOG.d_stmt THEN
348: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
349: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);

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

473: ELSE
474: l_null_not_allowed := TRUE;
475: END IF;
476:
477: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_PERCENT);
478:
479: IF (p_token1_value_tbl IS NULL) THEN
480: l_token1_value_tbl := PO_TBL_VARCHAR4000();
481: l_token1_value_tbl.extend(p_value_tbl.COUNT);

Line 1194: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO

1190: , p_value_tbl => l_value_tbl
1191: , p_entity_id_tbl => l_entity_id_tbl
1192: , p_entity_type => p_entity_type
1193: , p_column_name => p_column_name
1194: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
1195: , x_results => x_results
1196: , x_result_type => x_result_type
1197: );
1198:

Line 1208: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO

1204: , p_value_tbl => l_value_tbl
1205: , p_entity_id_tbl => l_entity_id_tbl
1206: , p_entity_type => p_entity_type
1207: , p_column_name => p_column_name
1208: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO
1209: , x_results => x_results
1210: , x_result_type => x_result_type
1211: );
1212:

Line 1303: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO

1299: , p_value_tbl => l_value_tbl
1300: , p_entity_id_tbl => l_entity_id_tbl
1301: , p_entity_type => p_entity_type
1302: , p_column_name => p_column_name
1303: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO
1304: , x_results => x_results
1305: , x_result_type => x_result_type
1306: );
1307:

Line 1755: l_message_name := PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_DIST_NUM;

1751:
1752: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_DISTRIBUTION) THEN
1753:
1754: l_column_name := c_DISTRIBUTION_NUM;
1755: l_message_name := PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_DIST_NUM;
1756:
1757: FOR i IN 1 .. l_parent_id_tbl.Count LOOP
1758: -- Extract Par Line ids of this distribution
1759: extract_par_draft_id_tbl(p_par_draft_id_tbl(i), l_par_draft_id_tbl);

Line 1791: l_message_name := PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_SHIP_NUM;

1787:
1788: ELSIF (p_entity_type = PO_VALIDATIONS.c_entity_type_LINE_LOCATION) THEN
1789:
1790: l_column_name := c_SHIPMENT_NUM;
1791: l_message_name := PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_SHIP_NUM;
1792:
1793: FOR i IN 1 .. l_parent_id_tbl.COUNT LOOP
1794: -- Extract Par Line ids of this shipment
1795: extract_par_draft_id_tbl(p_par_draft_id_tbl(i), l_par_draft_id_tbl);

Line 1830: l_message_name := PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_LINE_NUM;

1826:
1827: ELSE -- p_entity_type = PO_VALIDATIONS.c_entity_type_LINE
1828:
1829: l_column_name := c_LINE_NUM;
1830: l_message_name := PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_LINE_NUM;
1831:
1832: FOR i IN 1 .. l_parent_id_tbl.COUNT LOOP
1833: -- Extract Par Line ids of this line
1834: extract_par_draft_id_tbl(p_par_draft_id_tbl(i), l_par_draft_id_tbl);

Line 1923: PO_CONSTANTS_SV.SHIP_TYPE_PRICE_BREAK, PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_PRC_BRK_NUM,

1919: , CHILD.index_num2
1920: , l_column_name
1921: , TO_CHAR(CHILD.num1)
1922: , decode(char1,
1923: PO_CONSTANTS_SV.SHIP_TYPE_PRICE_BREAK, PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_PRC_BRK_NUM,
1924: l_message_name)
1925: FROM
1926: PO_SESSION_GT CHILD
1927: WHERE

Line 2655: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO

2651: , p_value_tbl => l_value_tbl
2652: , p_entity_id_tbl => l_entity_id_tbl
2653: , p_entity_type => p_entity_type
2654: , p_column_name => p_column_name
2655: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO
2656: , x_results => x_results
2657: , x_result_type => x_result_type
2658: );
2659: