DBA Data[Home] [Help]

APPS.CSI_T_UTILITIES_PVT dependencies on FND_MESSAGE

Line 604: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

600:
601: IF l_partner_rec.IB_OWNER = 'END_CUSTOMER'
602: THEN
603: IF l_partner_rec.END_CUSTOMER_ID is null Then
604: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
605: fnd_msg_pub.add;
606: raise fnd_api.g_exc_error;
607: ELSE
608: l_ib_owner := l_partner_rec.ib_owner;

Line 635: FND_MESSAGE.set_name('CSI','CSI_TXN_SOURCE_ID_INVALID');

631:
632: EXCEPTION
633: WHEN no_data_found THEN
634:
635: FND_MESSAGE.set_name('CSI','CSI_TXN_SOURCE_ID_INVALID');
636: FND_MESSAGE.set_token('SRC_NAME',px_txn_line_rec.source_transaction_table);
637: FND_MESSAGE.set_token('SRC_LINE_ID',px_txn_line_rec.source_transaction_id);
638: FND_MSG_PUB.add;
639: RAISE fnd_api.g_exc_error;

Line 636: FND_MESSAGE.set_token('SRC_NAME',px_txn_line_rec.source_transaction_table);

632: EXCEPTION
633: WHEN no_data_found THEN
634:
635: FND_MESSAGE.set_name('CSI','CSI_TXN_SOURCE_ID_INVALID');
636: FND_MESSAGE.set_token('SRC_NAME',px_txn_line_rec.source_transaction_table);
637: FND_MESSAGE.set_token('SRC_LINE_ID',px_txn_line_rec.source_transaction_id);
638: FND_MSG_PUB.add;
639: RAISE fnd_api.g_exc_error;
640:

Line 637: FND_MESSAGE.set_token('SRC_LINE_ID',px_txn_line_rec.source_transaction_id);

633: WHEN no_data_found THEN
634:
635: FND_MESSAGE.set_name('CSI','CSI_TXN_SOURCE_ID_INVALID');
636: FND_MESSAGE.set_token('SRC_NAME',px_txn_line_rec.source_transaction_table);
637: FND_MESSAGE.set_token('SRC_LINE_ID',px_txn_line_rec.source_transaction_id);
638: FND_MSG_PUB.add;
639: RAISE fnd_api.g_exc_error;
640:
641: END;

Line 686: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_TABLE_INVALID');

682: ELSIF px_txn_line_rec.source_transaction_table = 'ASO_QUOTE_LINES_ALL' THEN
683: null;
684: ELSE
685:
686: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_TABLE_INVALID');
687: FND_MESSAGE.set_token('SRC_TABLE',px_txn_line_rec.source_transaction_table);
688: FND_MSG_PUB.add;
689: RAISE FND_API.g_exc_error;
690: END IF;

Line 687: FND_MESSAGE.set_token('SRC_TABLE',px_txn_line_rec.source_transaction_table);

683: null;
684: ELSE
685:
686: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_TABLE_INVALID');
687: FND_MESSAGE.set_token('SRC_TABLE',px_txn_line_rec.source_transaction_table);
688: FND_MSG_PUB.add;
689: RAISE FND_API.g_exc_error;
690: END IF;
691:

Line 728: FND_MESSAGE.set_name('CSI','CSI_TXN_TYPE_ID_INVALID');

724:
725: EXCEPTION
726: WHEN no_data_found THEN
727:
728: FND_MESSAGE.set_name('CSI','CSI_TXN_TYPE_ID_INVALID');
729: FND_MESSAGE.set_token('TXN_TYPE_ID',px_txn_line_rec.source_transaction_type_id);
730: FND_MSG_PUB.add;
731: RAISE fnd_api.g_exc_error;
732:

Line 729: FND_MESSAGE.set_token('TXN_TYPE_ID',px_txn_line_rec.source_transaction_type_id);

725: EXCEPTION
726: WHEN no_data_found THEN
727:
728: FND_MESSAGE.set_name('CSI','CSI_TXN_TYPE_ID_INVALID');
729: FND_MESSAGE.set_token('TXN_TYPE_ID',px_txn_line_rec.source_transaction_type_id);
730: FND_MSG_PUB.add;
731: RAISE fnd_api.g_exc_error;
732:
733: WHEN too_many_rows THEN

Line 735: FND_MESSAGE.set_name('CSI','CSI_TXN_TYPE_ID_INVALID');

731: RAISE fnd_api.g_exc_error;
732:
733: WHEN too_many_rows THEN
734:
735: FND_MESSAGE.set_name('CSI','CSI_TXN_TYPE_ID_INVALID');
736: FND_MESSAGE.set_token('TXN_TYPE_ID',px_txn_line_rec.source_transaction_type_id);
737: FND_MSG_PUB.add;
738: RAISE fnd_api.g_exc_error;
739:

Line 736: FND_MESSAGE.set_token('TXN_TYPE_ID',px_txn_line_rec.source_transaction_type_id);

732:
733: WHEN too_many_rows THEN
734:
735: FND_MESSAGE.set_name('CSI','CSI_TXN_TYPE_ID_INVALID');
736: FND_MESSAGE.set_token('TXN_TYPE_ID',px_txn_line_rec.source_transaction_type_id);
737: FND_MSG_PUB.add;
738: RAISE fnd_api.g_exc_error;
739:
740: END;

Line 912: FND_MESSAGE.set_name('CSI','CSI_TXN_TYPE_ID_INVALID');

908:
909: EXCEPTION
910: WHEN no_data_found THEN
911:
912: FND_MESSAGE.set_name('CSI','CSI_TXN_TYPE_ID_INVALID');
913: FND_MESSAGE.set_token('TXN_TYPE_ID',p_txn_source_param_rec.source_transaction_type_id);
914: FND_MSG_PUB.add;
915: RAISE fnd_api.g_exc_error;
916:

Line 913: FND_MESSAGE.set_token('TXN_TYPE_ID',p_txn_source_param_rec.source_transaction_type_id);

909: EXCEPTION
910: WHEN no_data_found THEN
911:
912: FND_MESSAGE.set_name('CSI','CSI_TXN_TYPE_ID_INVALID');
913: FND_MESSAGE.set_token('TXN_TYPE_ID',p_txn_source_param_rec.source_transaction_type_id);
914: FND_MSG_PUB.add;
915: RAISE fnd_api.g_exc_error;
916:
917: WHEN too_many_rows THEN

Line 919: FND_MESSAGE.set_name('CSI','CSI_TXN_TYPE_ID_INVALID');

915: RAISE fnd_api.g_exc_error;
916:
917: WHEN too_many_rows THEN
918:
919: FND_MESSAGE.set_name('CSI','CSI_TXN_TYPE_ID_INVALID');
920: FND_MESSAGE.set_token('TXN_TYPE_ID',p_txn_source_param_rec.source_transaction_type_id);
921: FND_MSG_PUB.add;
922: RAISE fnd_api.g_exc_error;
923:

Line 920: FND_MESSAGE.set_token('TXN_TYPE_ID',p_txn_source_param_rec.source_transaction_type_id);

916:
917: WHEN too_many_rows THEN
918:
919: FND_MESSAGE.set_name('CSI','CSI_TXN_TYPE_ID_INVALID');
920: FND_MESSAGE.set_token('TXN_TYPE_ID',p_txn_source_param_rec.source_transaction_type_id);
921: FND_MSG_PUB.add;
922: RAISE fnd_api.g_exc_error;
923:
924: END;

Line 1080: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');

1076: EXCEPTION
1077: WHEN fnd_api.g_exc_error THEN
1078: x_return_status := fnd_api.g_ret_sts_error;
1079: WHEN others THEN
1080: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
1081: fnd_message.set_token('MESSAGE',sqlerrm);
1082: fnd_msg_pub.add;
1083: x_return_status := fnd_api.g_ret_sts_error;
1084: END get_source_dtls;

Line 1081: fnd_message.set_token('MESSAGE',sqlerrm);

1077: WHEN fnd_api.g_exc_error THEN
1078: x_return_status := fnd_api.g_ret_sts_error;
1079: WHEN others THEN
1080: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
1081: fnd_message.set_token('MESSAGE',sqlerrm);
1082: fnd_msg_pub.add;
1083: x_return_status := fnd_api.g_ret_sts_error;
1084: END get_source_dtls;
1085:

Line 1265: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');

1261: FROM oe_order_lines_all
1262: WHERE line_id=l_parent_source_id;
1263: EXCEPTION
1264: WHEN no_data_found THEN
1265: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
1266: fnd_message.set_token('OE_LINE_ID', l_parent_source_id);
1267: fnd_msg_pub.add;
1268: RAISE fnd_api.g_exc_error;
1269: END;

Line 1266: fnd_message.set_token('OE_LINE_ID', l_parent_source_id);

1262: WHERE line_id=l_parent_source_id;
1263: EXCEPTION
1264: WHEN no_data_found THEN
1265: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
1266: fnd_message.set_token('OE_LINE_ID', l_parent_source_id);
1267: fnd_msg_pub.add;
1268: RAISE fnd_api.g_exc_error;
1269: END;
1270: IF l_model_remnant_flag = 'Y' THEN

Line 1278: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');

1274: FROM oe_order_lines_all
1275: WHERE line_id=l_child_source_id;
1276: EXCEPTION
1277: WHEN no_data_found THEN
1278: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
1279: fnd_message.set_token('OE_LINE_ID', l_child_source_id);
1280: fnd_msg_pub.add;
1281: RAISE fnd_api.g_exc_error;
1282: END;

Line 1279: fnd_message.set_token('OE_LINE_ID', l_child_source_id);

1275: WHERE line_id=l_child_source_id;
1276: EXCEPTION
1277: WHEN no_data_found THEN
1278: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
1279: fnd_message.set_token('OE_LINE_ID', l_child_source_id);
1280: fnd_msg_pub.add;
1281: RAISE fnd_api.g_exc_error;
1282: END;
1283: IF l_link_to_line_id <> -99 THEN

Line 1292: fnd_message.set_name('CSI','CSI_OE_LINK_TO_LINE_ID_INVALID');

1288: AND inventory_item_id = l_inventory_item_id;
1289:
1290: l_quantity_ratio := l_sum_qty/l_model_qty;
1291: ELSE
1292: fnd_message.set_name('CSI','CSI_OE_LINK_TO_LINE_ID_INVALID');
1293: fnd_message.set_token('OE_LINK_TO_LINE_ID', l_child_source_id);
1294: fnd_msg_pub.add;
1295: RAISE fnd_api.g_exc_error;
1296: END IF;

Line 1293: fnd_message.set_token('OE_LINK_TO_LINE_ID', l_child_source_id);

1289:
1290: l_quantity_ratio := l_sum_qty/l_model_qty;
1291: ELSE
1292: fnd_message.set_name('CSI','CSI_OE_LINK_TO_LINE_ID_INVALID');
1293: fnd_message.set_token('OE_LINK_TO_LINE_ID', l_child_source_id);
1294: fnd_msg_pub.add;
1295: RAISE fnd_api.g_exc_error;
1296: END IF;
1297: END IF;

Line 1332: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

1328: EXCEPTION
1329: WHEN fnd_api.g_exc_error THEN
1330: x_return_status := fnd_api.g_ret_sts_error;
1331: WHEN others THEN
1332: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1333: fnd_message.set_token('MESSAGE', 'Error in cascade_child: '||substr(sqlerrm, 1, 240));
1334: fnd_msg_pub.add;
1335: x_return_status := fnd_api.g_ret_sts_unexp_error;
1336: END cascade_child;

Line 1333: fnd_message.set_token('MESSAGE', 'Error in cascade_child: '||substr(sqlerrm, 1, 240));

1329: WHEN fnd_api.g_exc_error THEN
1330: x_return_status := fnd_api.g_ret_sts_error;
1331: WHEN others THEN
1332: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1333: fnd_message.set_token('MESSAGE', 'Error in cascade_child: '||substr(sqlerrm, 1, 240));
1334: fnd_msg_pub.add;
1335: x_return_status := fnd_api.g_ret_sts_unexp_error;
1336: END cascade_child;
1337:

Line 1376: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');

1372:
1373: EXCEPTION
1374: WHEN no_data_found THEN
1375:
1376: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
1377: fnd_message.set_token('OE_LINE_ID', p_model_line_id);
1378: fnd_msg_pub.add;
1379: RAISE fnd_api.g_exc_error;
1380:

Line 1377: fnd_message.set_token('OE_LINE_ID', p_model_line_id);

1373: EXCEPTION
1374: WHEN no_data_found THEN
1375:
1376: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
1377: fnd_message.set_token('OE_LINE_ID', p_model_line_id);
1378: fnd_msg_pub.add;
1379: RAISE fnd_api.g_exc_error;
1380:
1381: END;

Line 1681: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');

1677: End If;
1678: End If;
1679: EXCEPTION
1680: WHEN no_data_found THEN
1681: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
1682: fnd_message.set_token('OE_LINE_ID', p_txn_cascade_tbl(1).parent_source_id);
1683: fnd_msg_pub.add;
1684: RAISE fnd_api.g_exc_error;
1685: END;

Line 1682: fnd_message.set_token('OE_LINE_ID', p_txn_cascade_tbl(1).parent_source_id);

1678: End If;
1679: EXCEPTION
1680: WHEN no_data_found THEN
1681: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
1682: fnd_message.set_token('OE_LINE_ID', p_txn_cascade_tbl(1).parent_source_id);
1683: fnd_msg_pub.add;
1684: RAISE fnd_api.g_exc_error;
1685: END;
1686: END IF;