[Home] [Help]
153: G_MESSAGE_NAME := 'EGO_TRANS_TYPE_INVALID';
154: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
155: G_MESSAGE_TEXT := fnd_message.get;
156:
157: INSERT INTO mtl_interface_errors(
158: transaction_id,
159: unique_id,
160: organization_id,
161: column_name,
218: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
219: G_MESSAGE_TEXT := fnd_message.get;
220: -- restricting updation and deletion right now as we are not supporting them for now
221: -- commenting this will allow update and delete valid cases work properly
222: INSERT INTO mtl_interface_errors(
223: transaction_id,
224: unique_id,
225: organization_id,
226: column_name,
277: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
278: G_MESSAGE_TEXT := fnd_message.get;
279: -- for now not supporting creation of TA for draft.
280: -- commenting this will allow create TA on draft version
281: INSERT INTO mtl_interface_errors(
282: transaction_id,
283: unique_id,
284: organization_id,
285: column_name,
341: so not validated ICC at table level as that not be there and set to 3*/
342: /*G_MESSAGE_NAME := 'EGO_ITEMCATALOG_INVALID';
343: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
344: G_MESSAGE_TEXT := fnd_message.get;
345: INSERT INTO mtl_interface_errors(
346: transaction_id,
347: unique_id,
348: organization_id,
349: column_name,
402: G_MESSAGE_NAME := 'EGO_ICC_REQUIRED_FIELD';
403: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
404: G_MESSAGE_TEXT := fnd_message.get;
405: /* if both icc_id and icc_name are null*/
406: INSERT INTO mtl_interface_errors(
407: transaction_id,
408: unique_id,
409: organization_id,
410: column_name,
465: G_MESSAGE_NAME := 'EGO_ITEMCATALOG_INVALID';
466: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
467: G_MESSAGE_TEXT := fnd_message.get;
468: /* If passed icc_id dosent exists*/
469: INSERT INTO mtl_interface_errors(
470: transaction_id,
471: unique_id,
472: organization_id,
473: column_name,
533: G_MESSAGE_NAME := 'EGO_EF_NO_VALUE_SETS_FOUND';
534: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
535: G_MESSAGE_TEXT := fnd_message.get;
536: /*if VS name provided doesnt exists in table */
537: INSERT INTO mtl_interface_errors(
538: transaction_id,
539: unique_id,
540: organization_id,
541: column_name,
598:
599: G_MESSAGE_NAME := 'EGO_EF_NO_VALUE_SETS_FOUND';
600: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
601: G_MESSAGE_TEXT := fnd_message.get;
602: INSERT INTO mtl_interface_errors(
603: transaction_id,
604: unique_id,
605: organization_id,
606: column_name,
669: G_MESSAGE_NAME := 'EGO_ATTR_NOT_EXISTS';
670: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
671: G_MESSAGE_TEXT := fnd_message.get;
672: /* Attrname provided is valid or not*/
673: INSERT INTO mtl_interface_errors(
674: transaction_id,
675: unique_id,
676: organization_id,
677: column_name,
748: G_MESSAGE_NAME := 'EGO_INVALID_TA';
749: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
750: G_MESSAGE_TEXT := fnd_message.get;
751: /*given attr_id is invalid or not*/
752: INSERT INTO mtl_interface_errors(
753: transaction_id,
754: unique_id,
755: organization_id,
756: column_name,
895: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
896: G_MESSAGE_TEXT := fnd_message.get;
897: /* given attr_display name is valid or not and getting id or not */
898:
899: INSERT INTO mtl_interface_errors(
900: transaction_id,
901: unique_id,
902: organization_id,
903: column_name,
995: G_MESSAGE_TEXT := fnd_message.get;
996: /* Association id not able to convert in case of upate,delete,sync
997: or association id provided doesnt exists in table*/
998:
999: INSERT INTO mtl_interface_errors(
1000: transaction_id,
1001: unique_id,
1002: organization_id,
1003: column_name,
1062: G_MESSAGE_NAME := 'EGO_ASSOC_ID_MISSING';
1063: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
1064: G_MESSAGE_TEXT := fnd_message.get;
1065: /*given association is valid or not*/
1066: INSERT INTO mtl_interface_errors(
1067: transaction_id,
1068: unique_id,
1069: organization_id,
1070: column_name,
1142: G_MESSAGE_NAME := 'EGO_METADATA_FLAGS_INVALID';
1143: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
1144: G_MESSAGE_TEXT := fnd_message.get;
1145:
1146: INSERT INTO mtl_interface_errors(
1147: transaction_id,
1148: unique_id,
1149: organization_id,
1150: column_name,
1215: G_MESSAGE_NAME := 'EGO_DATA_TYPE_INVALID';
1216: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
1217: G_MESSAGE_TEXT := fnd_message.get;
1218:
1219: INSERT INTO mtl_interface_errors(
1220: transaction_id,
1221: unique_id,
1222: organization_id,
1223: column_name,
1281: G_MESSAGE_NAME := 'EGO_INCRRCT_VAL_ASSO_ATTR_ID';
1282: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
1283: G_MESSAGE_TEXT := fnd_message.get;
1284:
1285: INSERT INTO mtl_interface_errors(
1286: transaction_id,
1287: unique_id,
1288: organization_id,
1289: column_name,
1344: G_MESSAGE_NAME := 'EGO_TA_PK_NULL';
1345: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
1346: G_MESSAGE_TEXT := fnd_message.get;
1347: /* ATTR_NAME,ATTR_DISPLAY_NAME,SEQUENCE Should not be null if CREATE*/
1348: INSERT INTO mtl_interface_errors(
1349: transaction_id,
1350: unique_id,
1351: organization_id,
1352: column_name,
1407: G_MESSAGE_NAME := 'EGO_ICC_VERSION_NULL';
1408: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
1409: G_MESSAGE_TEXT := fnd_message.get;
1410: /* ICC_VERSION NUMBER should not be NULL in CREATE flow */
1411: INSERT INTO mtl_interface_errors(
1412: transaction_id,
1413: unique_id,
1414: organization_id,
1415: column_name,
1510: G_MESSAGE_NAME := 'EGO_VER_GR_ZERO';
1511: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
1512: G_MESSAGE_TEXT := fnd_message.get;
1513: /* Icc_Version_Number greater than zero not allowed while UPDATE and DELETE*/
1514: INSERT INTO mtl_interface_errors(
1515: transaction_id,
1516: unique_id,
1517: organization_id,
1518: column_name,
1573: G_MESSAGE_NAME := 'EGO_ASSO_ATTR_NULL_DEL';
1574: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
1575: G_MESSAGE_TEXT := fnd_message.get;
1576: /*Association_id and attr_id should not be null for DELETE*/
1577: INSERT INTO mtl_interface_errors(
1578: transaction_id,
1579: unique_id,
1580: organization_id,
1581: column_name,