DBA Data[Home] [Help]

APPS.PO_VAL_DISTRIBUTIONS dependencies on PO_MESSAGE_S

Line 129: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO

125: , p_value_tbl => p_dist_num_tbl
126: , p_entity_id_tbl => p_dist_id_tbl
127: , p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
128: , p_column_name => c_DISTRIBUTION_NUM
129: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO
130: , x_results => x_results
131: , x_result_type => x_result_type
132: );
133:

Line 219: THEN PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_DEL_NA

215: , TO_CHAR(p_qty_ordered_tbl(i))
216: , (CASE
217: WHEN NVL(POD.quantity_delivered, 0) >
218: GREATEST(NVL(POD.quantity_billed, 0), NVL(POD.quantity_financed, 0))
219: THEN PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_DEL_NA
220: ELSE PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_BILLED_NA
221: END
222: )
223: --PBWC Message Change Impact: Adding a token

Line 220: ELSE PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_BILLED_NA

216: , (CASE
217: WHEN NVL(POD.quantity_delivered, 0) >
218: GREATEST(NVL(POD.quantity_billed, 0), NVL(POD.quantity_financed, 0))
219: THEN PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_DEL_NA
220: ELSE PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_BILLED_NA
221: END
222: )
223: --PBWC Message Change Impact: Adding a token
224: , (CASE

Line 227: THEN PO_MESSAGE_S.c_QTY_DEL_token

223: --PBWC Message Change Impact: Adding a token
224: , (CASE
225: WHEN NVL(POD.quantity_delivered, 0) >
226: GREATEST(NVL(POD.quantity_billed, 0), NVL(POD.quantity_financed, 0))
227: THEN PO_MESSAGE_S.c_QTY_DEL_token
228: ELSE PO_MESSAGE_S.c_QTY_BILLED_token
229: END
230: )
231: , (CASE

Line 228: ELSE PO_MESSAGE_S.c_QTY_BILLED_token

224: , (CASE
225: WHEN NVL(POD.quantity_delivered, 0) >
226: GREATEST(NVL(POD.quantity_billed, 0), NVL(POD.quantity_financed, 0))
227: THEN PO_MESSAGE_S.c_QTY_DEL_token
228: ELSE PO_MESSAGE_S.c_QTY_BILLED_token
229: END
230: )
231: , (CASE
232: WHEN NVL(POD.quantity_delivered, 0) >

Line 355: THEN PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_DEL_NA

351: , TO_CHAR(p_amt_ordered_tbl(i))
352: , (CASE
353: WHEN NVL(POD.amount_delivered, 0) >
354: GREATEST(NVL(POD.amount_billed, 0), NVL(POD.amount_financed, 0))
355: THEN PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_DEL_NA
356: ELSE PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_BILLED_NA
357: END
358: )
359: --PBWC Message Change Impact: Adding a token

Line 356: ELSE PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_BILLED_NA

352: , (CASE
353: WHEN NVL(POD.amount_delivered, 0) >
354: GREATEST(NVL(POD.amount_billed, 0), NVL(POD.amount_financed, 0))
355: THEN PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_DEL_NA
356: ELSE PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_BILLED_NA
357: END
358: )
359: --PBWC Message Change Impact: Adding a token
360: , (CASE

Line 363: THEN PO_MESSAGE_S.c_AMT_DEL_token

359: --PBWC Message Change Impact: Adding a token
360: , (CASE
361: WHEN NVL(POD.amount_delivered, 0) >
362: GREATEST(NVL(POD.amount_billed, 0), NVL(POD.amount_financed, 0))
363: THEN PO_MESSAGE_S.c_AMT_DEL_token
364: ELSE PO_MESSAGE_S.c_AMT_BILLED_token
365: END
366: )
367: , (CASE

Line 364: ELSE PO_MESSAGE_S.c_AMT_BILLED_token

360: , (CASE
361: WHEN NVL(POD.amount_delivered, 0) >
362: GREATEST(NVL(POD.amount_billed, 0), NVL(POD.amount_financed, 0))
363: THEN PO_MESSAGE_S.c_AMT_DEL_token
364: ELSE PO_MESSAGE_S.c_AMT_BILLED_token
365: END
366: )
367: , (CASE
368: WHEN NVL(POD.amount_delivered, 0) >

Line 473: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL -- Bug 5193851 - Changed the message

469: x_results.add_result(
470: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
471: , p_entity_id => p_dist_id_tbl(i)
472: , p_column_name => c_END_ITEM_UNIT_NUMBER
473: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL -- Bug 5193851 - Changed the message
474: );
475:
476: END IF;
477:

Line 554: , p_message_name => PO_MESSAGE_S.PO_OOP_ENTER_ALL_FIELDS

550: x_results.add_result(
551: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
552: , p_entity_id => p_dist_id_tbl(i)
553: , p_column_name => c_WIP_ENTITY_ID
554: , p_message_name => PO_MESSAGE_S.PO_OOP_ENTER_ALL_FIELDS
555: );
556: END IF;
557:
558: IF (p_wip_operation_seq_num_tbl(i) IS NULL)

Line 564: , p_message_name => PO_MESSAGE_S.PO_OOP_ENTER_ALL_FIELDS

560: x_results.add_result(
561: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
562: , p_entity_id => p_dist_id_tbl(i)
563: , p_column_name => c_WIP_OPERATION_SEQ_NUM
564: , p_message_name => PO_MESSAGE_S.PO_OOP_ENTER_ALL_FIELDS
565: );
566: END IF;
567:
568: -- BR says that if WIP line id is not null,

Line 581: , p_message_name => PO_MESSAGE_S.PO_OOP_ENTER_ALL_FIELDS

577: x_results.add_result(
578: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
579: , p_entity_id => p_dist_id_tbl(i)
580: , p_column_name => c_WIP_ENTITY_ID
581: , p_message_name => PO_MESSAGE_S.PO_OOP_ENTER_ALL_FIELDS
582: );
583: END IF;
584:
585: -- If OSP line, then also validate that resource sequence is not null

Line 593: , p_message_name => PO_MESSAGE_S.PO_OOP_ENTER_ALL_FIELDS

589: x_results.add_result(
590: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
591: , p_entity_id => p_dist_id_tbl(i)
592: , p_column_name => c_WIP_RESOURCE_SEQ_NUM
593: , p_message_name => PO_MESSAGE_S.PO_OOP_ENTER_ALL_FIELDS
594: );
595: END IF;
596: END IF; -- IF (p_destination_type_code_tbl(i) = c_DEST_TYPE_SHOP_FLOOR)
597:

Line 643: , p_message_name => PO_MESSAGE_S.PO_AMT_TO_ENCUM_LT_UNENCUM

639: , p_num2_tbl => p_amount_to_encumber_tbl
640: , p_entity_id_tbl => p_dist_id_tbl
641: , p_entity_type => c_entity_type_DISTRIBUTION
642: , p_column_name => c_AMOUNT_TO_ENCUMBER
643: , p_message_name => PO_MESSAGE_S.PO_AMT_TO_ENCUM_LT_UNENCUM
644: , x_results => x_results
645: , x_result_type => x_result_type
646: );
647:

Line 670: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO

666: , p_value_tbl => p_amount_to_encumber_tbl
667: , p_entity_id_tbl => p_dist_id_tbl
668: , p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
669: , p_column_name => c_AMOUNT_TO_ENCUMBER
670: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
671: , x_results => x_results
672: , x_result_type => x_result_type
673: );
674:

Line 697: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

693: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_budget_account_id_tbl)
694: , p_entity_id_tbl => p_dist_id_tbl
695: , p_entity_type => c_entity_type_DISTRIBUTION
696: , p_column_name => c_BUDGET_ACCOUNT_ID
697: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
698: , x_results => x_results
699: , x_result_type => x_result_type
700: );
701:

Line 724: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

720: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_gl_encumbered_date_tbl)
721: , p_entity_id_tbl => p_dist_id_tbl
722: , p_entity_type => c_entity_type_DISTRIBUTION
723: , p_column_name => c_GL_ENCUMBERED_DATE
724: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
725: , x_results => x_results
726: , x_result_type => x_result_type
727: );
728:

Line 770: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

766: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
767: , p_entity_id => p_dist_id_tbl(i)
768: , p_column_name => c_GL_ENCUMBERED_DATE
769: , p_column_val => NULL
770: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
771: );
772:
773: ELSE -- Verify that GL Date is in an open period.
774: po_periods_sv.get_period_name(l_sob_id,

Line 784: , p_message_name => PO_MESSAGE_S.PO_PO_ENTER_OPEN_GL_DATE

780: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
781: , p_entity_id => p_dist_id_tbl(i)
782: , p_column_name => c_GL_ENCUMBERED_DATE
783: , p_column_val => TO_CHAR(p_gl_encumbered_date_tbl(i))
784: , p_message_name => PO_MESSAGE_S.PO_PO_ENTER_OPEN_GL_DATE
785: );
786: END IF;
787:
788: END IF; -- p_gl_date_tbl(i) IS NULL

Line 849: , p_message_name => PO_MESSAGE_S.PO_WRAPPER_MESSAGE

845: x_results.add_result(
846: p_entity_type => c_entity_type_DISTRIBUTION
847: , p_entity_id => l_failure_dist_id_tbl(i)
848: , p_column_name => c_AWARD_ID
849: , p_message_name => PO_MESSAGE_S.PO_WRAPPER_MESSAGE
850: , p_token1_name => PO_MESSAGE_S.c_MESSAGE_token
851: , p_token1_value => l_failure_message_tbl(i)
852: );
853: END LOOP;

Line 850: , p_token1_name => PO_MESSAGE_S.c_MESSAGE_token

846: p_entity_type => c_entity_type_DISTRIBUTION
847: , p_entity_id => l_failure_dist_id_tbl(i)
848: , p_column_name => c_AWARD_ID
849: , p_message_name => PO_MESSAGE_S.PO_WRAPPER_MESSAGE
850: , p_token1_name => PO_MESSAGE_S.c_MESSAGE_token
851: , p_token1_value => l_failure_message_tbl(i)
852: );
853: END LOOP;
854: END IF;

Line 1077: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

1073: p_entity_type => c_entity_type_DISTRIBUTION
1074: , p_entity_id => p_dist_id_tbl(i)
1075: , p_column_name => 'TASK_ID'
1076: , p_column_val => NULL
1077: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
1078: );
1079: END IF;
1080:
1081: IF (p_dest_type_code_tbl(i) = c_DEST_TYPE_EXPENSE) THEN

Line 1111: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

1107: p_entity_type => c_entity_type_DISTRIBUTION
1108: , p_entity_id => p_dist_id_tbl(i)
1109: , p_column_name => 'EXPENDITURE_TYPE'
1110: , p_column_val => NULL
1111: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
1112: );
1113: END IF; --expenditure type validation check
1114:
1115: IF (p_expenditure_org_id_tbl(i) IS NULL) THEN

Line 1121: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

1117: p_entity_type => c_entity_type_DISTRIBUTION
1118: , p_entity_id => p_dist_id_tbl(i)
1119: , p_column_name => 'EXPENDITURE_ORGANIZATION_ID'
1120: , p_column_val => NULL
1121: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
1122: );
1123: END IF;
1124:
1125: IF (p_expenditure_item_date_tbl(i) IS NULL) THEN

Line 1131: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

1127: p_entity_type => c_entity_type_DISTRIBUTION
1128: , p_entity_id => p_dist_id_tbl(i)
1129: , p_column_name => 'EXPENDITURE_ITEM_DATE'
1130: , p_column_val => NULL
1131: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
1132: );
1133: END IF;
1134: END IF; -- destination type check
1135: END IF;