eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_TA_BULKLOAD_PVT dependencies on EGO_METADATA_BULKLOAD_PVT

Line 24: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Import_TA_Intf');

20: l_rec_exists NUMBER :=0;
21: l_proc_name VARCHAR2(200) := 'Import_TA_Intf';
22: BEGIN
23:
24: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Import_TA_Intf');
25: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Setting G_FLOW_TYPE=G_EGO_MD_INTF');
26: -- Initializing message --
27: FND_MSG_PUB.INITIALIZE;
28: -- setting flow type as interface

Line 25: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Setting G_FLOW_TYPE=G_EGO_MD_INTF');

21: l_proc_name VARCHAR2(200) := 'Import_TA_Intf';
22: BEGIN
23:
24: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Import_TA_Intf');
25: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Setting G_FLOW_TYPE=G_EGO_MD_INTF');
26: -- Initializing message --
27: FND_MSG_PUB.INITIALIZE;
28: -- setting flow type as interface
29: G_FLOW_TYPE:=G_EGO_MD_INTF;

Line 93: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Import_TA_Intf');

89: x_return_msg:= l_return_msg;
90: -- RETURN; -- no need to return from here.
91: END IF ; --l_rec_exists=0
92: END IF;--l_err_rec=1
93: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Import_TA_Intf');
94: EXCEPTION
95: WHEN OTHERS THEN
96: x_return_status:=G_RET_STS_UNEXP_ERROR;
97: x_return_msg:= G_PKG_NAME||'.'||l_proc_name||'.'||SQLERRM;

Line 98: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception Import_TA_Intf');

94: EXCEPTION
95: WHEN OTHERS THEN
96: x_return_status:=G_RET_STS_UNEXP_ERROR;
97: x_return_msg:= G_PKG_NAME||'.'||l_proc_name||'.'||SQLERRM;
98: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception Import_TA_Intf');
99: END Import_TA_Intf ;
100:
101: ----=================Initialize =========-------
102:

Line 109: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Initialize');

105: x_return_status OUT NOCOPY VARCHAR2)
106: IS
107: l_proc_name VARCHAR2(200) := 'Initialize';
108: BEGIN
109: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Initialize');
110:
111: /*Sets the EGO application ID*/
112: SELECT application_id
113: INTO G_APPLICATION_ID

Line 136: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||SQL%ROWCOUNT||' Rows Initialize');

132: WHERE transaction_id IS NULL
133: AND process_status = G_PROCESS_RECORD
134: AND ((p_set_process_id IS NULL) OR (set_process_id = p_set_process_id));
135:
136: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||SQL%ROWCOUNT||' Rows Initialize');
137: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Initialize');
138: EXCEPTION
139: WHEN OTHERS THEN
140: x_return_status:=G_RET_STS_ERROR;

Line 137: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Initialize');

133: AND process_status = G_PROCESS_RECORD
134: AND ((p_set_process_id IS NULL) OR (set_process_id = p_set_process_id));
135:
136: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||SQL%ROWCOUNT||' Rows Initialize');
137: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Initialize');
138: EXCEPTION
139: WHEN OTHERS THEN
140: x_return_status:=G_RET_STS_ERROR;
141: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'When Others Exception while Initialize');

Line 141: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'When Others Exception while Initialize');

137: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Initialize');
138: EXCEPTION
139: WHEN OTHERS THEN
140: x_return_status:=G_RET_STS_ERROR;
141: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'When Others Exception while Initialize');
142: END Initialize;
143:
144: --=================Bulk_Validate_Trans_Attrs========
145: PROCEDURE Bulk_Validate_Trans_Attrs (p_set_process_id IN NUMBER)

Line 149: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entered Bulk_Validate_Trans_Attrs');

145: PROCEDURE Bulk_Validate_Trans_Attrs (p_set_process_id IN NUMBER)
146: IS
147: l_proc_name VARCHAR2(200) := 'Bulk_Validate_Trans_Attrs';
148: BEGIN
149: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entered Bulk_Validate_Trans_Attrs');
150: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking valid transaction types');
151:
152: /* Invalid Transaction type */
153: G_MESSAGE_NAME := 'EGO_TRANS_TYPE_INVALID';

Line 150: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking valid transaction types');

146: IS
147: l_proc_name VARCHAR2(200) := 'Bulk_Validate_Trans_Attrs';
148: BEGIN
149: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entered Bulk_Validate_Trans_Attrs');
150: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking valid transaction types');
151:
152: /* Invalid Transaction type */
153: G_MESSAGE_NAME := 'EGO_TRANS_TYPE_INVALID';
154: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);

Line 211: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Calling Value_to_Id for ICC,Value Set and Attr name');

207: AND transaction_id IS NOT NULL
208: AND process_status=G_PROCESS_RECORD
209: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
210: -------------------------------------------
211: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Calling Value_to_Id for ICC,Value Set and Attr name');
212: /* calling value to id for icc,valueset and attr name to id conversion*/
213:
214: Value_to_Id(p_set_process_id);
215:

Line 338: --ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' Checking ICC name provided doesnt exists in table');

334: AND process_status=G_PROCESS_RECORD
335: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
336:
337: --------------------------------------------------
338: --ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' Checking ICC name provided doesnt exists in table');
339:
340: /* commented as now decided to process ICC one by one
341: so not validated ICC at table level as that not be there and set to 3*/
342: /*G_MESSAGE_NAME := 'EGO_ITEMCATALOG_INVALID';

Line 400: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking if both icc_id and icc_name are null');

396: AND transaction_id IS NOT NULL
397: AND process_status=G_PROCESS_RECORD
398: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));*/
399:
400: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking if both icc_id and icc_name are null');
401:
402: G_MESSAGE_NAME := 'EGO_ICC_REQUIRED_FIELD';
403: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
404: G_MESSAGE_TEXT := fnd_message.get;

Line 463: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking if passed icc_id dosent exists');

459: AND process_status=G_PROCESS_RECORD
460: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
461:
462:
463: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking if passed icc_id dosent exists');
464:
465: G_MESSAGE_NAME := 'EGO_ITEMCATALOG_INVALID';
466: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
467: G_MESSAGE_TEXT := fnd_message.get;

Line 531: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking if VS name provided doesnt exists');

527: AND ETAVI.transaction_id IS NOT NULL
528: AND ETAVI.process_status = G_PROCESS_RECORD
529: AND ((p_set_process_id IS NULL) OR (ETAVI.set_process_id=p_set_process_id));
530: -------------------------------------------
531: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking if VS name provided doesnt exists');
532:
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;

Line 597: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking if given value set id is valid or not');

593: AND process_status = G_PROCESS_RECORD
594: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
595:
596:
597: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking if given value set id is valid or not');
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;

Line 667: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking if given attr_name is valid');

663: AND ETAVT.process_status = G_PROCESS_RECORD
664: AND ((p_set_process_id IS NULL) OR (ETAVT.set_process_id=p_set_process_id));
665:
666: -------------------------------------------
667: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking if given attr_name is valid');
668:
669: G_MESSAGE_NAME := 'EGO_ATTR_NOT_EXISTS';
670: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
671: G_MESSAGE_TEXT := fnd_message.get;

Line 731: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'if attr_name is given with sync and not exists- convert to Create');

727: AND transaction_id IS NOT NULL
728: AND process_status = G_PROCESS_RECORD
729: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
730:
731: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'if attr_name is given with sync and not exists- convert to Create');
732: /* converting sync to create or update */
733: /* if attr_name is given with sync and not exists */
734: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
735: SET transaction_type = G_CREATE,

Line 746: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking if given attr_id is valid or not');

742: AND transaction_id IS NOT NULL
743: AND process_status = G_PROCESS_RECORD
744: AND ((p_set_process_id IS NULL) OR (ETAVT.set_process_id=p_set_process_id));
745:
746: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking if given attr_id is valid or not');
747:
748: G_MESSAGE_NAME := 'EGO_INVALID_TA';
749: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
750: G_MESSAGE_TEXT := fnd_message.get;

Line 820: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking if attr_name given with sync - convert to Update');

816: AND ETAVT.transaction_id IS NOT NULL
817: AND ETAVT.process_status = G_PROCESS_RECORD
818: AND ((p_set_process_id IS NULL) OR (ETAVT.set_process_id=p_set_process_id));
819:
820: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking if attr_name given with sync - convert to Update');
821: /* if attr_name is given with sync and exists */
822: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
823: SET transaction_type = G_UPDATE,
824: last_updated_by = G_USER_ID,

Line 840: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Getting attr_name if only display_name is given');

836: AND transaction_id IS NOT NULL
837: AND process_status = G_PROCESS_RECORD
838: AND ((p_set_process_id IS NULL) OR (ETAVT.set_process_id=p_set_process_id));
839:
840: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Getting attr_name if only display_name is given');
841: /* if attr_display name and sync given and it got converted into
842: update as here we are sure we got the attr_id so populating attr_name
843: if not given*/
844: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT

Line 855: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Getting other metadata from main table if not provided by user to complete the record');

851: AND ETAVT.transaction_type IN (G_UPDATE)
852: AND ETAVT.process_status = G_PROCESS_RECORD
853: AND ((p_set_process_id IS NULL) OR (set_process_id = p_set_process_id));
854:
855: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Getting other metadata from main table if not provided by user to complete the record');
856: /* to copy rest of the meta data for same attr_id,icc_id and version */
857: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
858: SET (uom_class,
859: default_value,

Line 892: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking given attr_display name is valid or not.');

888: AND ETAVT.process_status = G_PROCESS_RECORD
889: AND ((p_set_process_id IS NULL) OR (set_process_id = p_set_process_id));
890:
891: -------------------------------------------
892: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking given attr_display name is valid or not.');
893:
894: G_MESSAGE_NAME := 'EGO_ATTR_DISP_NAME_MISSING';
895: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
896: G_MESSAGE_TEXT := fnd_message.get;

Line 958: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'If attr_display_name is given with sync and not exists- convert to Create .');

954: AND transaction_id IS NOT NULL
955: AND process_status = G_PROCESS_RECORD
956: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
957:
958: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'If attr_display_name is given with sync and not exists- convert to Create .');
959: /* converting sync to create or update */
960: /* if attr_display_name is given with sync and not exists */
961: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
962: SET transaction_type = G_CREATE,

Line 973: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking if All Attr_name, Attr_Display_Name,Attr_id are NULL For Upd,Del,Sync');

969: AND transaction_id IS NOT NULL
970: AND process_status = G_PROCESS_RECORD
971: AND ((p_set_process_id IS NULL) OR (ETAVT.set_process_id=p_set_process_id));
972:
973: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking if All Attr_name, Attr_Display_Name,Attr_id are NULL For Upd,Del,Sync');
974: /* if attr_name is null,attr_display_name is null and attr_id is null
975: with sync then error out */
976:
977: UPDATE EGO_TRANS_ATTRS_VERS_INTF

Line 991: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking if Association_id is Valid or not');

987: AND process_status = G_PROCESS_RECORD
988: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
989:
990: -------------------------------------------
991: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking if Association_id is Valid or not');
992:
993: G_MESSAGE_NAME := 'EGO_TA_ASSOC_FAILED';
994: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
995: G_MESSAGE_TEXT := fnd_message.get;

Line 1140: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking Metadata Flag Values');

1136: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
1137:
1138: -------------------------------------------
1139:
1140: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking Metadata Flag Values');
1141:
1142: G_MESSAGE_NAME := 'EGO_METADATA_FLAGS_INVALID';
1143: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
1144: G_MESSAGE_TEXT := fnd_message.get;

Line 1213: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking Valid Values for data type while CREATE');

1209: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
1210:
1211: -------------------------------------------
1212:
1213: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking Valid Values for data type while CREATE');
1214:
1215: G_MESSAGE_NAME := 'EGO_DATA_TYPE_INVALID';
1216: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
1217: G_MESSAGE_TEXT := fnd_message.get;

Line 1279: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking Association_id and attr_id should be null while T_Type is CREATE');

1275: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
1276:
1277: -------------------------------------------
1278:
1279: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking Association_id and attr_id should be null while T_Type is CREATE');
1280:
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;

Line 1342: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking ATTR_NAME,ATTR_DISPLAY_NAME,SEQUENCE Should not be null while CREATE');

1338: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id))
1339: AND ((Association_id IS NOT NULL) OR (Attr_id IS NOT NULL));
1340:
1341: -------------------------------------------
1342: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking ATTR_NAME,ATTR_DISPLAY_NAME,SEQUENCE Should not be null while CREATE');
1343:
1344: G_MESSAGE_NAME := 'EGO_TA_PK_NULL';
1345: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
1346: G_MESSAGE_TEXT := fnd_message.get;

Line 1405: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking if ICC version is NULL while CREATE');

1401: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id))
1402: AND ((attr_name IS NULL) OR (attr_display_name IS NULL) OR (SEQUENCE IS NULL));
1403:
1404: -------------------------------------------------
1405: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Checking if ICC version is NULL while CREATE');
1406:
1407: G_MESSAGE_NAME := 'EGO_ICC_VERSION_NULL';
1408: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
1409: G_MESSAGE_TEXT := fnd_message.get;

Line 1470: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Defaulting Data Type and Display Flag while CREATE');

1466: AND icc_version_number IS NULL;
1467: --AND item_catalog_group_id IS NOT NULL; /* bug 9752139 */
1468:
1469: -------------------------------------------------
1470: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Defaulting Data Type and Display Flag while CREATE');
1471:
1472: /*Defaulting data_type to'C' if not passed*/
1473: UPDATE EGO_TRANS_ATTRS_VERS_INTF
1474: SET data_type = G_CHAR_DATA_TYPE

Line 1508: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Icc_Version_Number greater than zero not allowed while UPDATE and DELETE');

1504: AND icc_version_number IS NULL;
1505:
1506:
1507: -------------------------------------------------
1508: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Icc_Version_Number greater than zero not allowed while UPDATE and DELETE');
1509:
1510: G_MESSAGE_NAME := 'EGO_VER_GR_ZERO';
1511: FND_MESSAGE.SET_NAME('EGO',G_MESSAGE_NAME);
1512: G_MESSAGE_TEXT := fnd_message.get;

Line 1571: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Association_id and attr_id should not be null for DELETE');

1567: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id))
1568: AND Nvl(icc_version_number,0)>0;
1569:
1570: -------------------------------------------------
1571: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Association_id and attr_id should not be null for DELETE');
1572:
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;

Line 1633: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Bulk_Validate_Trans_Attrs ');

1629: AND process_status = G_PROCESS_RECORD
1630: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id))
1631: AND ((association_id IS NULL) OR (attr_id IS NULL));
1632:
1633: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Bulk_Validate_Trans_Attrs ');
1634: EXCEPTION
1635: WHEN OTHERS THEN
1636: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception When Others Bulk_Validate_Trans_Attrs ');
1637: END Bulk_Validate_Trans_Attrs;

Line 1636: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception When Others Bulk_Validate_Trans_Attrs ');

1632:
1633: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Bulk_Validate_Trans_Attrs ');
1634: EXCEPTION
1635: WHEN OTHERS THEN
1636: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception When Others Bulk_Validate_Trans_Attrs ');
1637: END Bulk_Validate_Trans_Attrs;
1638:
1639: --================= Bulk_Validate_Trans_Attrs_ICC ========----
1640:

Line 1649: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Bulk_Validate_Trans_Attrs_ICC');

1645: IS
1646: l_proc_name VARCHAR2(200) := 'Bulk_Validate_Trans_Attrs_ICC';
1647: BEGIN
1648:
1649: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Bulk_Validate_Trans_Attrs_ICC');
1650: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Updating ICC name from ICC id');
1651: /* ICC name to ICC id conversion */
1652: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
1653: SET item_catalog_group_id = p_item_catalog_group_id

Line 1650: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Updating ICC name from ICC id');

1646: l_proc_name VARCHAR2(200) := 'Bulk_Validate_Trans_Attrs_ICC';
1647: BEGIN
1648:
1649: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Bulk_Validate_Trans_Attrs_ICC');
1650: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Updating ICC name from ICC id');
1651: /* ICC name to ICC id conversion */
1652: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
1653: SET item_catalog_group_id = p_item_catalog_group_id
1654: WHERE ETAVT.item_catalog_group_name IS NOT NULL

Line 1660: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' End Bulk_Validate_Trans_Attrs_ICC');

1656: AND ETAVT.process_status = G_PROCESS_RECORD
1657: AND ((p_set_process_id IS NULL) OR (set_process_id = p_set_process_id))
1658: AND Upper(ETAVT.item_catalog_group_name) =Upper(p_item_catalog_group_name); -- added to make it ICC specific.
1659:
1660: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' End Bulk_Validate_Trans_Attrs_ICC');
1661:
1662: EXCEPTION
1663: WHEN OTHERS THEN
1664: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception Bulk_Validate_Trans_Attrs_ICC');

Line 1664: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception Bulk_Validate_Trans_Attrs_ICC');

1660: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' End Bulk_Validate_Trans_Attrs_ICC');
1661:
1662: EXCEPTION
1663: WHEN OTHERS THEN
1664: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception Bulk_Validate_Trans_Attrs_ICC');
1665: END Bulk_Validate_Trans_Attrs_ICC;
1666:
1667:
1668: --================= Value_to_Id ========----

Line 1675: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Value_to_Id');

1671: p_set_process_id IN NUMBER)
1672: IS
1673: l_proc_name VARCHAR2(200) := 'Value_to_Id';
1674: BEGIN
1675: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Value_to_Id');
1676: --ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting ICC name to ICC id');
1677: /* ICC name to ICC id conversion */
1678: /* NOt Req now are we are doing this in Bulk_Validate_Trans_Attrs_ICC */
1679: /*

Line 1676: --ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting ICC name to ICC id');

1672: IS
1673: l_proc_name VARCHAR2(200) := 'Value_to_Id';
1674: BEGIN
1675: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Value_to_Id');
1676: --ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting ICC name to ICC id');
1677: /* ICC name to ICC id conversion */
1678: /* NOt Req now are we are doing this in Bulk_Validate_Trans_Attrs_ICC */
1679: /*
1680: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT

Line 1691: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting Value set name to value set id');

1687: --AND ETAVT.transaction_type IN (G_CREATE,G_UPDATE,G_DELETE_G_SYNC)
1688: AND ETAVT.process_status = G_PROCESS_RECORD
1689: AND ((p_set_process_id IS NULL) OR (set_process_id = p_set_process_id));*/
1690:
1691: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting Value set name to value set id');
1692: /*Value set name to value set id conversion*/
1693: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
1694: SET value_set_id = ( SELECT flex_value_set_id
1695: FROM fnd_flex_value_sets

Line 1704: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting Attr_Name to Attr_id');

1700: AND ETAVT.transaction_type IN (G_CREATE,G_UPDATE,G_SYNC)
1701: AND ETAVT.process_status = G_PROCESS_RECORD
1702: AND ((p_set_process_id IS NULL) OR (set_process_id = p_set_process_id));
1703:
1704: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting Attr_Name to Attr_id');
1705: /* Attr_Name to Attr_id conversion */
1706: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
1707: SET (attr_id/*,attr_display_name,sequence*/) = ( SELECT attr_id/*,attr_display_name,sequence*/
1708: FROM ego_trans_attr_vers_b

Line 1737: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting attr display name to attr_id ');

1733: AND ETAVT.process_status = G_PROCESS_RECORD
1734: AND ((p_set_process_id IS NULL) OR (set_process_id = p_set_process_id));
1735:
1736:
1737: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting attr display name to attr_id ');
1738: /*attr display name to attr_id conversion*/
1739: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
1740: SET attr_id = ( SELECT attr_id
1741: FROM EGO_TRANS_ATTR_VERS_B

Line 1752: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting associaton_id from icc_id,attr_id ');

1748: AND ETAVT.transaction_type IN (G_CREATE,G_UPDATE,G_DELETE,G_SYNC)
1749: AND ETAVT.process_status = G_PROCESS_RECORD
1750: AND ((p_set_process_id IS NULL) OR (set_process_id = p_set_process_id));
1751:
1752: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting associaton_id from icc_id,attr_id ');
1753: /* associaton_id from icc_id */
1754: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
1755: SET association_id = ( SELECT association_id
1756: FROM EGO_TRANS_ATTR_VERS_B

Line 1769: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Value_to_Id');

1765: AND ETAVT.transaction_type IN (G_UPDATE,G_DELETE,G_SYNC)
1766: AND ETAVT.process_status = G_PROCESS_RECORD
1767: AND ((p_set_process_id IS NULL) OR (set_process_id = p_set_process_id));
1768:
1769: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Value_to_Id');
1770: EXCEPTION
1771: WHEN OTHERS THEN
1772: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception Value_to_Id');
1773: END Value_to_Id;

Line 1772: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception Value_to_Id');

1768:
1769: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Value_to_Id');
1770: EXCEPTION
1771: WHEN OTHERS THEN
1772: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception Value_to_Id');
1773: END Value_to_Id;
1774:
1775: --=================Load_Trans_Attrs_recs ========
1776:

Line 1799: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Load_Trans_Attrs_recs');

1795:
1796: l_proc_name VARCHAR2(30):= 'Load_Trans_Attrs_recs';
1797:
1798: BEGIN
1799: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Load_Trans_Attrs_recs');
1800:
1801: OPEN c_ta;
1802: FETCH c_ta BULK COLLECT INTO x_ta_intf_tbl; --LIMIT 2000;
1803: CLOSE c_ta;

Line 1804: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Load_Trans_Attrs_recs.No of rec in intf pl-sql tbl :'||x_ta_intf_tbl.count );

1800:
1801: OPEN c_ta;
1802: FETCH c_ta BULK COLLECT INTO x_ta_intf_tbl; --LIMIT 2000;
1803: CLOSE c_ta;
1804: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Load_Trans_Attrs_recs.No of rec in intf pl-sql tbl :'||x_ta_intf_tbl.count );
1805:
1806: EXCEPTION
1807: WHEN OTHERS THEN
1808: x_return_status:= G_RET_STS_UNEXP_ERROR;

Line 1810: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception when Others in Load_Trans_Attrs_recs');

1806: EXCEPTION
1807: WHEN OTHERS THEN
1808: x_return_status:= G_RET_STS_UNEXP_ERROR;
1809: x_return_msg:= G_PKG_NAME||'.'||l_proc_name||'.'||SQLERRM;
1810: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception when Others in Load_Trans_Attrs_recs');
1811: END Load_Trans_Attrs_recs;
1812:
1813: --=================convert_intf_rec_to_api_rec========
1814:

Line 1821: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering convert_intf_rec_to_api_rec');

1817: x_ego_ta_tbl OUT NOCOPY ego_tran_attr_tbl)
1818: IS
1819: l_proc_name VARCHAR2(200) := 'convert_intf_rec_to_api_rec';
1820: BEGIN
1821: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering convert_intf_rec_to_api_rec');
1822: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting interface rec to prod rec type');
1823: -- Initializing table type
1824: x_ego_ta_tbl:= EGO_TRAN_ATTR_TBL(NULL);
1825:

Line 1822: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting interface rec to prod rec type');

1818: IS
1819: l_proc_name VARCHAR2(200) := 'convert_intf_rec_to_api_rec';
1820: BEGIN
1821: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering convert_intf_rec_to_api_rec');
1822: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting interface rec to prod rec type');
1823: -- Initializing table type
1824: x_ego_ta_tbl:= EGO_TRAN_ATTR_TBL(NULL);
1825:
1826: FOR i IN p_ta_intf_tbl.first..p_ta_intf_tbl.last LOOP

Line 1864: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End convert_intf_rec_to_api_rec');

1860: p_ta_intf_tbl(i).Value_Set_Name
1861: );
1862:
1863: END LOOP;
1864: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End convert_intf_rec_to_api_rec');
1865: EXCEPTION
1866: WHEN OTHERS THEN
1867: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception when Others in convert_intf_rec_to_api_rec');
1868: END convert_intf_rec_to_api_rec;

Line 1867: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception when Others in convert_intf_rec_to_api_rec');

1863: END LOOP;
1864: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End convert_intf_rec_to_api_rec');
1865: EXCEPTION
1866: WHEN OTHERS THEN
1867: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception when Others in convert_intf_rec_to_api_rec');
1868: END convert_intf_rec_to_api_rec;
1869:
1870: --=================Process_Trans_Attrs ========
1871: PROCEDURE Process_Trans_Attrs (

Line 1885: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Process_Trans_Attrs');

1881: l_ta_intf_tbl TA_Intf_Tbl;
1882: l_return_status VARCHAR2(1);
1883: l_proc_name VARCHAR2(200):= 'Process_Trans_Attrs';
1884: BEGIN
1885: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Process_Trans_Attrs');
1886:
1887: /* when coming from Public API*/
1888: IF G_FLOW_TYPE=G_EGO_MD_API THEN
1889: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'In to API Flow');

Line 1889: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'In to API Flow');

1885: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Process_Trans_Attrs');
1886:
1887: /* when coming from Public API*/
1888: IF G_FLOW_TYPE=G_EGO_MD_API THEN
1889: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'In to API Flow');
1890: l_ta_intf_tbl:= p_ta_intf_tbl;
1891:
1892: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Calling Construct_TA');
1893: /* same as initialize and value_to_id */

Line 1892: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Calling Construct_TA');

1888: IF G_FLOW_TYPE=G_EGO_MD_API THEN
1889: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'In to API Flow');
1890: l_ta_intf_tbl:= p_ta_intf_tbl;
1891:
1892: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Calling Construct_TA');
1893: /* same as initialize and value_to_id */
1894: Construct_Trans_Attrs(p_api_version=>p_api_version,
1895: p_ta_intf_tbl => l_ta_intf_tbl,
1896: x_return_status => x_return_status,

Line 1899: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Calling Validate_TA');

1895: p_ta_intf_tbl => l_ta_intf_tbl,
1896: x_return_status => x_return_status,
1897: x_return_msg => x_return_msg);
1898:
1899: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Calling Validate_TA');
1900: /* same as bulk validation*/
1901: Validate_Trans_Attrs(p_api_version => p_api_version,
1902: p_ta_intf_tbl => l_ta_intf_tbl,
1903: x_return_status => x_return_status,

Line 1908: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Loop for Transact_TA record by record');

1904: x_return_msg => x_return_msg);
1905:
1906: p_ta_intf_tbl:= l_ta_intf_tbl;
1907: END IF;
1908: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Loop for Transact_TA record by record');
1909: -- loop to transact record by record
1910: FOR i IN p_ta_intf_tbl.first..p_ta_intf_tbl.last LOOP
1911: /* Assigning intf record to process*/
1912: l_ta_intf_rec:=p_ta_intf_tbl(i);

Line 1973: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Process_Trans_Attrs');

1969: Update_Intf_Trans_Attrs(p_ta_intf_tbl => p_ta_intf_tbl,
1970: x_return_status => l_return_status,
1971: x_return_msg => x_return_msg);
1972: END IF;
1973: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Process_Trans_Attrs');
1974: EXCEPTION
1975: WHEN OTHERS THEN
1976: x_return_status:= G_RET_STS_UNEXP_ERROR;
1977: x_return_msg:= G_PKG_NAME||'.'||l_proc_name||'.'||SQLERRM;

Line 1978: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception when others Process_Trans_Attrs');

1974: EXCEPTION
1975: WHEN OTHERS THEN
1976: x_return_status:= G_RET_STS_UNEXP_ERROR;
1977: x_return_msg:= G_PKG_NAME||'.'||l_proc_name||'.'||SQLERRM;
1978: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception when others Process_Trans_Attrs');
1979:
1980: END Process_Trans_Attrs;
1981:
1982: --=================Construct_Trans_Attrs ========

Line 1992: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Construct_Trans_Attrs');

1988: x_return_msg OUT NOCOPY VARCHAR2)
1989: IS
1990: l_proc_name VARCHAR2(200):='Construct_Trans_Attrs';
1991: BEGIN
1992: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Construct_Trans_Attrs');
1993:
1994: FOR i IN p_ta_intf_tbl.first..p_ta_intf_tbl.last LOOP
1995:
1996: IF (p_ta_intf_tbl(i).process_status = G_PROCESS_RECORD) THEN

Line 2011: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Transaction Type '

2007: FROM dual;
2008:
2009: /* if not a valid transaction type*/
2010: IF p_ta_intf_tbl(i).transaction_type NOT IN (G_CREATE,G_UPDATE,G_DELETE,G_SYNC) THEN
2011: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Transaction Type '
2012: ||p_ta_intf_tbl(i).transaction_type
2013: ||'Is not Valid');
2014:
2015: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;

Line 2023: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Icc_name to Icc_id conversion');

2019: p_row_identifier => P_ag_tbl(i).transaction_id,
2020: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2021: END IF;
2022:
2023: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Icc_name to Icc_id conversion');
2024:
2025: /* Getting ICC_id from icc_name */
2026: IF (p_ta_intf_tbl(i).transaction_type IN (G_CREATE,G_UPDATE,G_DELETE,G_SYNC)
2027: AND p_ta_intf_tbl(i).item_catalog_group_id IS NULL

Line 2036: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ICC '

2032: FROM mtl_item_catalog_groups_kfv icc_kfv
2033: WHERE Upper(icc_kfv.concatenated_segments) = Upper(p_ta_intf_tbl(i).item_catalog_group_name);
2034: EXCEPTION
2035: WHEN no_data_found THEN
2036: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ICC '
2037: ||p_ta_intf_tbl(i).item_catalog_group_name
2038: ||'does not exist in the system');
2039:
2040: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;

Line 2047: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ICC_NAME to ICC_ID Exception when others');

2043: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2044: p_row_identifier => P_ag_tbl(i).transaction_id,
2045: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2046: WHEN OTHERS THEN
2047: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ICC_NAME to ICC_ID Exception when others');
2048: x_return_status := G_RET_STS_UNEXP_ERROR;
2049: END;
2050: END IF;/*icc_name to icc_id */
2051:

Line 2052: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Value_set_id from Value_set_name');

2048: x_return_status := G_RET_STS_UNEXP_ERROR;
2049: END;
2050: END IF;/*icc_name to icc_id */
2051:
2052: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Value_set_id from Value_set_name');
2053: /* Getting value_set_id from value_set_name */
2054: IF (p_ta_intf_tbl(i).transaction_type IN (G_CREATE,G_UPDATE,G_DELETE,G_SYNC)
2055: AND p_ta_intf_tbl(i).value_set_id IS NULL
2056: AND p_ta_intf_tbl(i).value_set_name IS NOT NULL) THEN

Line 2063: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Value Set '

2059: FROM fnd_flex_value_sets
2060: WHERE Upper(flex_value_set_name) = Upper(p_ta_intf_tbl(i).value_set_name);
2061: EXCEPTION
2062: WHEN no_data_found THEN
2063: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Value Set '
2064: ||p_ta_intf_tbl(i).value_set_name
2065: ||'does not exist in the system');
2066:
2067: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;

Line 2074: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Value Set Name to ID Exception when others');

2070: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2071: p_row_identifier => P_ag_tbl(i).transaction_id,
2072: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2073: WHEN OTHERS THEN
2074: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Value Set Name to ID Exception when others');
2075: x_return_status := G_RET_STS_UNEXP_ERROR;
2076: END;
2077: END IF;/*value_set_name to value_set_id */
2078:

Line 2079: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Getting Attr_id from Attr_name');

2075: x_return_status := G_RET_STS_UNEXP_ERROR;
2076: END;
2077: END IF;/*value_set_name to value_set_id */
2078:
2079: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Getting Attr_id from Attr_name');
2080: /* Getting Attr_id from Attr_name */
2081: IF (p_ta_intf_tbl(i).transaction_type IN (G_CREATE,G_UPDATE,G_DELETE,G_SYNC)
2082: AND p_ta_intf_tbl(i).attr_id IS NULL
2083: AND p_ta_intf_tbl(i).attr_name IS NOT NULL) THEN

Line 2114: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Attribute Name'

2110: WHEN no_data_found THEN
2111: IF (p_ta_intf_tbl(i).transaction_type = G_SYNC) THEN
2112: p_ta_intf_tbl(i).transaction_type := G_CREATE;
2113: ELSE
2114: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Attribute Name'
2115: ||p_ta_intf_tbl(i).attr_name
2116: ||'does not exist in the system');
2117:
2118: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;

Line 2126: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Attribute Name to ID Exception when others');

2122: p_row_identifier => P_ag_tbl(i).transaction_id,
2123: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2124: END IF;
2125: WHEN OTHERS THEN
2126: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Attribute Name to ID Exception when others');
2127: x_return_status := G_RET_STS_UNEXP_ERROR;
2128: END;
2129: END IF; /*attr_name to attr_id */
2130:

Line 2131: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Getting Attr_id from Attr_Display_name');

2127: x_return_status := G_RET_STS_UNEXP_ERROR;
2128: END;
2129: END IF; /*attr_name to attr_id */
2130:
2131: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Getting Attr_id from Attr_Display_name');
2132: /* Getting Attr_id from Attr_Display_name */
2133: IF (p_ta_intf_tbl(i).transaction_type IN (G_CREATE,G_UPDATE,G_DELETE,G_SYNC)
2134: AND p_ta_intf_tbl(i).attr_id IS NULL
2135: AND p_ta_intf_tbl(i).attr_display_name IS NOT NULL

Line 2152: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Attribute Display Name'

2148: WHEN no_data_found THEN
2149: IF (p_ta_intf_tbl(i).transaction_type = G_SYNC) THEN
2150: p_ta_intf_tbl(i).transaction_type := G_CREATE;
2151: ELSE
2152: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Attribute Display Name'
2153: ||p_ta_intf_tbl(i).attr_display_name
2154: ||'does not exist in the system');
2155:
2156: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;

Line 2164: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Attribute Name to ID Exception when others');

2160: p_row_identifier => P_ag_tbl(i).transaction_id,
2161: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2162: END IF;
2163: WHEN OTHERS THEN
2164: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Attribute Name to ID Exception when others');
2165: x_return_status := G_RET_STS_UNEXP_ERROR;
2166: END;
2167: END IF; /*attr_display_name to attr_id */
2168:

Line 2169: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Getting associaton_id from icc_id and attr_id');

2165: x_return_status := G_RET_STS_UNEXP_ERROR;
2166: END;
2167: END IF; /*attr_display_name to attr_id */
2168:
2169: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Getting associaton_id from icc_id and attr_id');
2170: /* Getting associaton_id from icc_id and attr_id, need this for update and delete*/
2171: IF (p_ta_intf_tbl(i).transaction_type IN (G_UPDATE,G_DELETE,G_SYNC)
2172: AND p_ta_intf_tbl(i).attr_id IS NOT NULL
2173: AND p_ta_intf_tbl(i).item_catalog_group_id IS NOT NULL

Line 2186: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Not able to get association id frrom '

2182:
2183:
2184: EXCEPTION
2185: WHEN no_data_found THEN
2186: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Not able to get association id frrom '
2187: ||p_ta_intf_tbl(i).attr_id ||' ' || p_ta_intf_tbl(i).item_catalog_group_id
2188: ||'Unexpected');
2189:
2190: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;

Line 2197: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Attribute Name to ID Exception when others');

2193: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2194: p_row_identifier => P_ag_tbl(i).transaction_id,
2195: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2196: WHEN OTHERS THEN
2197: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Attribute Name to ID Exception when others');
2198: x_return_status := G_RET_STS_UNEXP_ERROR;
2199: END;
2200: END IF; /*association id from attr_id and icc_id */
2201: END IF;-- process status

Line 2203: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Construct_Trans_Attrs');

2199: END;
2200: END IF; /*association id from attr_id and icc_id */
2201: END IF;-- process status
2202: END LOOP;
2203: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Construct_Trans_Attrs');
2204:
2205: EXCEPTION WHEN OTHERS THEN
2206: x_return_status:= G_RET_STS_UNEXP_ERROR;
2207: x_return_msg:= G_PKG_NAME||'.'||l_proc_name||'.'||SQLERRM;

Line 2208: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception when others Construct_Trans_Attrs');

2204:
2205: EXCEPTION WHEN OTHERS THEN
2206: x_return_status:= G_RET_STS_UNEXP_ERROR;
2207: x_return_msg:= G_PKG_NAME||'.'||l_proc_name||'.'||SQLERRM;
2208: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception when others Construct_Trans_Attrs');
2209: END Construct_Trans_Attrs;
2210:
2211: --=================Validate_Trans_Attrs ========
2212: /* This is same as Bulk Validation TA during interface flow */

Line 2227: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Validate_Trans_Attrs');

2223:
2224: l_id_exists NUMBER;
2225:
2226: BEGIN
2227: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Validate_Trans_Attrs');
2228: x_return_status := G_RET_STS_SUCCESS;
2229: x_return_msg := G_MISS_CHAR;
2230:
2231: FOR i IN p_ta_intf_tbl.first..p_ta_intf_tbl.last LOOP

Line 2236: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ICC_validations');

2232: IF (p_ta_intf_tbl(i).process_status = G_PROCESS_RECORD
2233: AND p_ta_intf_tbl(i).TRANSACTION_ID IS NOT NULL
2234: ) THEN
2235:
2236: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ICC_validations');
2237: /* ICC_validations*/
2238: IF p_ta_intf_tbl(i).transaction_type IN (G_CREATE,G_UPDATE,G_DELETE,G_SYNC) THEN
2239: IF (p_ta_intf_tbl(i).item_catalog_group_id IS NULL
2240: AND p_ta_intf_tbl(i).item_catalog_group_name IS NULL) THEN /*if both ICC_ID and ICC_NAME is NULL*/

Line 2241: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ERR : ICC Id and ICC_NAME both NULL ');

2237: /* ICC_validations*/
2238: IF p_ta_intf_tbl(i).transaction_type IN (G_CREATE,G_UPDATE,G_DELETE,G_SYNC) THEN
2239: IF (p_ta_intf_tbl(i).item_catalog_group_id IS NULL
2240: AND p_ta_intf_tbl(i).item_catalog_group_name IS NULL) THEN /*if both ICC_ID and ICC_NAME is NULL*/
2241: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ERR : ICC Id and ICC_NAME both NULL ');
2242: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2243: x_return_status := G_RET_STS_ERROR;
2244: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',
2245: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,

Line 2258: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ICC '

2254: WHERE micg.ITEM_CATALOG_GROUP_ID=p_ta_intf_tbl(i).item_catalog_group_id;
2255:
2256: EXCEPTION
2257: WHEN no_data_found THEN
2258: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ICC '
2259: ||p_ta_intf_tbl(i).item_catalog_group_id
2260: ||'does not exist in the system');
2261:
2262: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;

Line 2269: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ICC_ID provided Exception when others');

2265: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2266: p_row_identifier => P_ag_tbl(i).transaction_id,
2267: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2268: WHEN OTHERS THEN
2269: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ICC_ID provided Exception when others');
2270: x_return_status := G_RET_STS_UNEXP_ERROR;
2271: END;
2272: END IF;
2273: END IF;-- If Transaction_type in ALL

Line 2275: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Value_set_Validations ');

2271: END;
2272: END IF;
2273: END IF;-- If Transaction_type in ALL
2274:
2275: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Value_set_Validations ');
2276: /* Value_set Validations*/
2277: IF p_ta_intf_tbl(i).transaction_type IN (G_CREATE,G_UPDATE,G_SYNC) THEN
2278: /* if given value_set_id not exists */
2279: IF (p_ta_intf_tbl(i).value_set_id IS NOT NULL) THEN

Line 2287: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Value Set Id '

2283: WHERE ffvs.flex_value_set_id = p_ta_intf_tbl(i).value_set_id ;
2284:
2285: EXCEPTION
2286: WHEN no_data_found THEN
2287: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Value Set Id '
2288: ||p_ta_intf_tbl(i).value_set_id
2289: ||'does not exist in the system');
2290:
2291: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;

Line 2298: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'value_Set_id provided Exception when others');

2294: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2295: p_row_identifier => P_ag_tbl(i).transaction_id,
2296: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2297: WHEN OTHERS THEN
2298: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'value_Set_id provided Exception when others');
2299: x_return_status := G_RET_STS_UNEXP_ERROR;
2300: END;
2301: END IF;
2302: END IF;-- If Transaction_type in except delete

Line 2304: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'attr_id Validations and conversion of sync to create/update ');

2300: END;
2301: END IF;
2302: END IF;-- If Transaction_type in except delete
2303:
2304: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'attr_id Validations and conversion of sync to create/update ');
2305: /* attr_id Validations*/
2306: IF p_ta_intf_tbl(i).transaction_type IN (G_UPDATE,G_DELETE,G_SYNC) THEN
2307: /* if given attr_id not exists */
2308: IF (p_ta_intf_tbl(i).attr_id IS NOT NULL) THEN

Line 2331: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'assining rest of defaults');

2327: END IF;
2328:
2329: IF p_ta_intf_tbl(i).attr_name IS NOT NULL THEN
2330: BEGIN
2331: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'assining rest of defaults');
2332: SELECT nvl(p_ta_intf_tbl(i).uom_class,b.uom_class),nvl(p_ta_intf_tbl(i).default_value,b.default_value),
2333: nvl(p_ta_intf_tbl(i).rejected_value,b.rejected_value),nvl(p_ta_intf_tbl(i).required_flag,b.required_flag),
2334: nvl(p_ta_intf_tbl(i).readonly_flag,b.readonly_flag),nvl(p_ta_intf_tbl(i).hidden_flag,b.hidden_flag),
2335: nvl(p_ta_intf_tbl(i).searchable_flag,b.searchable_flag), nvl(p_ta_intf_tbl(i).check_eligibility,b.check_eligibility),

Line 2352: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Attr Id provided '

2348: END IF;
2349:
2350: EXCEPTION
2351: WHEN no_data_found THEN
2352: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Attr Id provided '
2353: ||p_ta_intf_tbl(i).attr_id
2354: ||'does not exist in the system');
2355:
2356: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;

Line 2363: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'attr_id provided Exception when others');

2359: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2360: p_row_identifier => P_ag_tbl(i).transaction_id,
2361: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2362: WHEN OTHERS THEN
2363: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'attr_id provided Exception when others');
2364: x_return_status := G_RET_STS_UNEXP_ERROR;
2365:
2366: END;
2367:

Line 2369: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ALL Attr_id, Attr_name and Attr_Display Name cannot be NULL for UPDATE,DEL and SYNC');

2365:
2366: END;
2367:
2368: ELSIF (p_ta_intf_tbl(i).attr_id IS NULL AND p_ta_intf_tbl(i).attr_name IS NULL AND p_ta_intf_tbl(i).attr_display_name IS NULL ) THEN
2369: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ALL Attr_id, Attr_name and Attr_Display Name cannot be NULL for UPDATE,DEL and SYNC');
2370: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2371: x_return_status := G_RET_STS_ERROR;
2372: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',
2373: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,

Line 2379: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'If association id provided is not valid');

2375: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2376:
2377: END IF; -- if attr_id is not NULL
2378:
2379: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'If association id provided is not valid');
2380: /* if association id provided is not valid*/
2381: IF ( p_ta_intf_tbl(i).association_id IS NOT NULL AND p_ta_intf_tbl(i).attr_id IS NOT NULL AND p_ta_intf_tbl(i).item_catalog_group_id IS NOT NULL) THEN
2382:
2383: BEGIN

Line 2393: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Association provided '

2389: AND attr_id=p_ta_intf_tbl(i).attr_id;
2390:
2391: EXCEPTION
2392: WHEN no_data_found THEN
2393: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Association provided '
2394: ||p_ta_intf_tbl(i).attr_id
2395: ||'does not exist in the system');
2396:
2397: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;

Line 2404: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'value_Set_id provided Exception when others');

2400: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,
2401: p_row_identifier => P_ag_tbl(i).transaction_id,
2402: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2403: WHEN OTHERS THEN
2404: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'value_Set_id provided Exception when others');
2405: x_return_status := G_RET_STS_UNEXP_ERROR;
2406:
2407: END;
2408: END IF;

Line 2413: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Create Specific Validations');

2409: END IF;-- If transaction_type
2410:
2411: /* ============ Specific Validations ======== */
2412: /* CREATE */
2413: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Create Specific Validations');
2414: IF p_ta_intf_tbl(i).transaction_type IN (G_CREATE) THEN
2415:
2416: IF (p_ta_intf_tbl(i).Association_id IS NOT NULL
2417: OR p_ta_intf_tbl(i).Attr_id IS NOT NULL ) THEN /*if association_id or attr_id is NOT NULL*/

Line 2418: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ERR : Association_Is and Attr_id shud be NULL for CREATE');

2414: IF p_ta_intf_tbl(i).transaction_type IN (G_CREATE) THEN
2415:
2416: IF (p_ta_intf_tbl(i).Association_id IS NOT NULL
2417: OR p_ta_intf_tbl(i).Attr_id IS NOT NULL ) THEN /*if association_id or attr_id is NOT NULL*/
2418: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ERR : Association_Is and Attr_id shud be NULL for CREATE');
2419: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2420: x_return_status := G_RET_STS_ERROR;
2421: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',
2422: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,

Line 2430: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Attr_Name and ATT_DISPLAY_NAM and Seq shud not be NULL for CREATE');

2426:
2427: ELSIF ((p_ta_intf_tbl(i).attr_name IS NULL)
2428: OR (p_ta_intf_tbl(i).attr_display_name IS NULL)
2429: OR (p_ta_intf_tbl(i).SEQUENCE IS NULL)) THEN /* if ICC_ID provided doesn't exists*/
2430: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Attr_Name and ATT_DISPLAY_NAM and Seq shud not be NULL for CREATE');
2431: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2432: x_return_status := G_RET_STS_ERROR;
2433: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',
2434: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,

Line 2439: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ERR : ICC_VERSION_NUMBER cannot be NULL while CREATE');

2435: p_row_identifier => P_ag_tbl(i).transaction_id,
2436: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2437:
2438: ELSIF (p_ta_intf_tbl(i).icc_version_number IS NULL) THEN /*If ICC version is NULL while create*/
2439: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ERR : ICC_VERSION_NUMBER cannot be NULL while CREATE');
2440: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2441: x_return_status := G_RET_STS_ERROR;
2442: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',
2443: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,

Line 2449: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Defaulting of data type and dispaly_name');

2445: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2446:
2447: END IF;
2448:
2449: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Defaulting of data type and dispaly_name');
2450: /* Defaulting data type to 'C' if NULL */
2451: IF (p_ta_intf_tbl(i).data_type IS NULL) THEN
2452: p_ta_intf_tbl(i).data_type:='C';
2453: END IF ;

Line 2460: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Icc_Version_Number greater than zero not allowed while UPDATE and DELETE');

2456: p_ta_intf_tbl(i).display_flag:='T';
2457: END IF ;
2458: END IF;-- If Transaction_type CREATE
2459:
2460: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Icc_Version_Number greater than zero not allowed while UPDATE and DELETE');
2461: /* Both UPDATE and DELETE NOT SYNC */
2462: IF p_ta_intf_tbl(i).transaction_type IN (G_UPDATE, G_DELETE) THEN
2463:
2464: IF (p_ta_intf_tbl(i).icc_version_number>0) then /*Icc_Version_Number greater than zero not allowed while UPDATE and DELETE*/

Line 2466: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Icc_Version_Number greater than zero not allowed while UPDATE and DELETE');

2462: IF p_ta_intf_tbl(i).transaction_type IN (G_UPDATE, G_DELETE) THEN
2463:
2464: IF (p_ta_intf_tbl(i).icc_version_number>0) then /*Icc_Version_Number greater than zero not allowed while UPDATE and DELETE*/
2465:
2466: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Icc_Version_Number greater than zero not allowed while UPDATE and DELETE');
2467: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2468: x_return_status := G_RET_STS_ERROR;
2469: /*error_handler.Add_error_message(p_message_name => 'EGO_ICC_INVALID',p_application_id => 'EGO',
2470: p_token_tbl => g_token_table,p_message_type => g_ret_sts_error,

Line 2476: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Association_id and attr_id should not be null for DELETE');

2472: p_entity_code => g_entity_ag,p_table_name => g_entity_ag_tab);*/
2473: END IF;
2474: END IF ;
2475:
2476: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Association_id and attr_id should not be null for DELETE');
2477: /* DELETE*/
2478: IF p_ta_intf_tbl(i).transaction_type IN (G_DELETE) THEN
2479:
2480: IF ((p_ta_intf_tbl(i).association_id IS NULL)

Line 2483: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ERR : Association_id and attr_id should not be null for DELETE');

2479:
2480: IF ((p_ta_intf_tbl(i).association_id IS NULL)
2481: OR (p_ta_intf_tbl(i).attr_id IS NULL)) THEN /*Association_id and attr_id should not be null for DELETE */
2482:
2483: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ERR : Association_id and attr_id should not be null for DELETE');
2484: p_ta_intf_tbl(i).process_status := G_ERROR_RECORD;
2485: x_return_status := G_RET_STS_ERROR;
2486: END IF;
2487: END IF ;

Line 2491: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Validate_Trans_Attrs');

2487: END IF ;
2488:
2489: END IF;
2490: END LOOP;
2491: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Validate_Trans_Attrs');
2492: EXCEPTION
2493: WHEN OTHERS THEN
2494: x_return_status:= G_RET_STS_UNEXP_ERROR;
2495: x_return_msg := G_PKG_NAME||'.'||l_proc_name||'.'||SQLERRM;

Line 2496: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception when others Validate_Trans_Attrs');

2492: EXCEPTION
2493: WHEN OTHERS THEN
2494: x_return_status:= G_RET_STS_UNEXP_ERROR;
2495: x_return_msg := G_PKG_NAME||'.'||l_proc_name||'.'||SQLERRM;
2496: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception when others Validate_Trans_Attrs');
2497: END Validate_Trans_Attrs;
2498:
2499: --
2500: -- Bug 9980051. Added few supporting sub functions.

Line 2631: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' Entering method with params ' ||

2627: AND flex_col.end_user_column_name = p_attr_name;
2628:
2629:
2630: BEGIN
2631: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' Entering method with params ' ||
2632: ' icc = ' || p_item_catalog_group_id ||
2633: ' attrbute name = ' || p_attr_name ||
2634: ' version = ' || p_version_seq_id);
2635:

Line 2639: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Start date = ' || l_start_date);

2635:
2636: l_start_date := get_start_active_date(p_item_catalog_group_id => p_item_catalog_group_id,
2637: p_version_seq_id => p_version_seq_id);
2638:
2639: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Start date = ' || l_start_date);
2640:
2641:
2642: FOR c_rec IN c_parents LOOP
2643: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' Checking for parent ' || c_rec.item_catalog_group_id || 'level ' || c_rec.lev);

Line 2643: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' Checking for parent ' || c_rec.item_catalog_group_id || 'level ' || c_rec.lev);

2639: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Start date = ' || l_start_date);
2640:
2641:
2642: FOR c_rec IN c_parents LOOP
2643: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' Checking for parent ' || c_rec.item_catalog_group_id || 'level ' || c_rec.lev);
2644:
2645: l_latest_vers := get_latest_version(p_item_catalog_group_id => c_rec.item_catalog_group_id,
2646: p_active_date => l_start_date);
2647:

Line 2648: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' Checking for parent ' || c_rec.item_catalog_group_id || 'latest version '|| l_latest_vers );

2644:
2645: l_latest_vers := get_latest_version(p_item_catalog_group_id => c_rec.item_catalog_group_id,
2646: p_active_date => l_start_date);
2647:
2648: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' Checking for parent ' || c_rec.item_catalog_group_id || 'latest version '|| l_latest_vers );
2649:
2650: OPEN c( c_rec.item_catalog_group_id, l_latest_vers); -- check only on the latest active version of the parent
2651: FETCH c INTO l_attr_id, l_association_id;
2652: CLOSE c;

Line 2655: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' Attribute ' || l_attr_id || ' exists in parent so returning true' );

2651: FETCH c INTO l_attr_id, l_association_id;
2652: CLOSE c;
2653:
2654: IF l_attr_id IS NOT NULL THEN
2655: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' Attribute ' || l_attr_id || ' exists in parent so returning true' );
2656: x_attr_id := l_attr_id;
2657: x_association_id := l_association_id;
2658: RETURN true;
2659: END IF;

Line 2663: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' Returning false' );

2659: END IF;
2660:
2661: END LOOP;
2662:
2663: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' Returning false' );
2664: RETURN false;
2665:
2666: END is_inherited_attribute;
2667:

Line 2695: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Transact_Trans_Attrs');

2691: e_ta_disp_name_exist EXCEPTION;
2692: e_ta_sequence_exist EXCEPTION;
2693:
2694: BEGIN
2695: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Transact_Trans_Attrs');
2696: x_return_status := G_RET_STS_SUCCESS;
2697: x_return_msg := G_MISS_CHAR ;
2698:
2699: -----================ /* MAIN LOGIC FOR TRANSACT */ =============------------

Line 2704: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering CREATE');

2700:
2701: IF p_ta_intf_rec.process_status=G_PROCESS_RECORD THEN
2702:
2703: IF p_ta_intf_rec.transaction_type=G_CREATE THEN
2704: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering CREATE');
2705:
2706:
2707: /* for passing only one record at a time to convert*/
2708: l_ta_intf_tbl(1):= p_ta_intf_rec;

Line 2724: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' The ICC ' || p_ta_intf_rec.item_catalog_group_id

2720: --
2721:
2722: l_inherited := false;
2723: IF has_parent(p_item_catalog_group_id => p_ta_intf_rec.item_catalog_group_id) THEN
2724: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' The ICC ' || p_ta_intf_rec.item_catalog_group_id
2725: ||'has parents so check for inheritance ...');
2726:
2727: IF is_inherited_attribute(p_item_catalog_group_id => p_ta_intf_rec.item_catalog_group_id,
2728: p_attr_name => p_ta_intf_rec.attr_name,

Line 2743: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' Attribute ' || p_ta_intf_rec.attr_name || ' is inherited so call Create_inherit API' );

2739: p_ta_intf_rec.process_status:=G_ERROR_RECORD;
2740: RAISE e_ta_disp_name_exist;
2741: END IF;
2742:
2743: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' Attribute ' || p_ta_intf_rec.attr_name || ' is inherited so call Create_inherit API' );
2744: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' Attr id ' || l_attr_id || ' association id ' || l_association_id );
2745: l_ego_ta_tbl(1).attrid := l_attr_id;
2746: l_ego_ta_tbl(1).associationid := l_association_id;
2747: ego_transaction_attrs_pvt.Create_Inherited_Trans_Attr (

Line 2744: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' Attr id ' || l_attr_id || ' association id ' || l_association_id );

2740: RAISE e_ta_disp_name_exist;
2741: END IF;
2742:
2743: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' Attribute ' || p_ta_intf_rec.attr_name || ' is inherited so call Create_inherit API' );
2744: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' Attr id ' || l_attr_id || ' association id ' || l_association_id );
2745: l_ego_ta_tbl(1).attrid := l_attr_id;
2746: l_ego_ta_tbl(1).associationid := l_association_id;
2747: ego_transaction_attrs_pvt.Create_Inherited_Trans_Attr (
2748: p_api_version => p_api_version,

Line 2796: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' Call create for ICC: ' || p_ta_intf_rec.item_catalog_group_id ||

2792: RAISE e_ta_sequence_exist;
2793: END IF;
2794:
2795:
2796: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||' Call create for ICC: ' || p_ta_intf_rec.item_catalog_group_id ||
2797: ' attribute ' || p_ta_intf_rec.attr_id );
2798:
2799: /* calling API to Create TA */
2800: ego_transaction_attrs_pvt.Create_Transaction_Attribute (

Line 2821: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering UPDATE');

2817: x_return_status:= G_RET_STS_SUCCESS;
2818: END IF;
2819:
2820: ELSIF p_ta_intf_rec.transaction_type=G_UPDATE THEN
2821: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering UPDATE');
2822: /* for passing only one record at a time to convert*/
2823: l_ta_intf_tbl(1):= p_ta_intf_rec;
2824:
2825: /*calling proc to convert intf collection to original which calls create api*/

Line 2895: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering DELETE');

2891: END IF;
2892:
2893: ELSIF p_ta_intf_rec.transaction_type=G_DELETE THEN
2894:
2895: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering DELETE');
2896:
2897: /* for passing only one record at a time to convert*/
2898: l_ta_intf_tbl(1):= p_ta_intf_rec;
2899:

Line 2926: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Transact_Trans_Attrs');

2922: END IF;
2923: END IF ; -- transaction type checking;
2924: END IF; --l_ego_ta_rec.process_status=G_PROCESS_RECORD
2925:
2926: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Transact_Trans_Attrs');
2927: EXCEPTION
2928: WHEN e_ta_int_name_exist THEN
2929: x_return_status := G_RET_STS_ERROR;
2930: Error_Handler.Add_Error_Message

Line 2972: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception Transact_Trans_Attrs');

2968: );
2969: WHEN OTHERS THEN
2970: x_return_status:= G_RET_STS_UNEXP_ERROR;
2971: x_return_msg := G_PKG_NAME||'.'||l_proc_name||'.'||SQLERRM;
2972: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception Transact_Trans_Attrs');
2973: END Transact_Trans_Attrs;
2974:
2975: PROCEDURE Update_Intf_Trans_Attrs(
2976: p_ta_intf_tbl IN OUT NOCOPY TA_Intf_Tbl,

Line 2983: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Update_Intf_Trans_Attrs');

2979: IS
2980: l_proc_name VARCHAR2(200):='Update_Intf_Trans_Attrs';
2981: trans_id dbms_sql.number_table; --bug 9701271
2982: BEGIN
2983: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Update_Intf_Trans_Attrs');
2984:
2985: -- bug 9701271
2986: FOR i IN p_ta_intf_tbl.FIRST..p_ta_intf_tbl.LAST LOOP
2987: trans_id(i) := p_ta_intf_tbl(i).transaction_id;

Line 2997: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Update_Intf_Trans_Attrs');

2993: SET ROW= p_ta_intf_tbl(i) -- bug 9701271
2994: WHERE
2995: transaction_id = trans_id(i);
2996:
2997: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Update_Intf_Trans_Attrs');
2998:
2999: EXCEPTION
3000: WHEN OTHERS THEN
3001: x_return_status:= G_RET_STS_UNEXP_ERROR;

Line 3003: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception Update_Intf_Trans_Attrs');

2999: EXCEPTION
3000: WHEN OTHERS THEN
3001: x_return_status:= G_RET_STS_UNEXP_ERROR;
3002: x_return_msg := G_PKG_NAME||'.'||l_proc_name||'.'||SQLERRM;
3003: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception Update_Intf_Trans_Attrs');
3004:
3005: END Update_Intf_Trans_Attrs;
3006:
3007: /* This has to be called through ICC_versions if any of the TA fails we return from here.

Line 3020: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Update_Intf_Err_Trans_Attrs');

3016: IS
3017: l_proc_name VARCHAR2(200) :='Update_Intf_Err_Trans_Attrs';
3018: BEGIN
3019: x_return_status:=G_RET_STS_SUCCESS;
3020: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Update_Intf_Err_Trans_Attrs');
3021:
3022: UPDATE EGO_TRANS_ATTRS_VERS_INTF
3023: SET process_status= G_ERROR_RECORD
3024: WHERE item_catalog_group_id = p_item_catalog_group_id

Line 3028: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Update_Intf_Err_Trans_Attrs');

3024: WHERE item_catalog_group_id = p_item_catalog_group_id
3025: AND icc_version_number = p_icc_version_number_intf
3026: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
3027:
3028: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Update_Intf_Err_Trans_Attrs');
3029:
3030: EXCEPTION
3031: WHEN OTHERS THEN
3032: x_return_status:= G_RET_STS_UNEXP_ERROR;

Line 3034: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception Update_Intf_Err_Trans_Attrs');

3030: EXCEPTION
3031: WHEN OTHERS THEN
3032: x_return_status:= G_RET_STS_UNEXP_ERROR;
3033: x_return_msg := G_PKG_NAME||'.'||l_proc_name||'.'||SQLERRM;
3034: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception Update_Intf_Err_Trans_Attrs');
3035:
3036: END Update_Intf_Err_Trans_Attrs;
3037:
3038: /* This has to be called by main API of CP based on the parameter passed by user

Line 3050: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Delete_Processed_Trans_Attrs');

3046: IS
3047: l_proc_name varchar2(200):='Delete_Processed_Trans_Attrs';
3048: BEGIN
3049: x_return_status:=G_RET_STS_SUCCESS;
3050: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Delete_Processed_Trans_Attrs');
3051:
3052: DELETE FROM EGO_TRANS_ATTRS_VERS_INTF
3053: WHERE process_status = G_SUCCESS_RECORD
3054: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));

Line 3056: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Delete_Processed_Trans_Attrs');

3052: DELETE FROM EGO_TRANS_ATTRS_VERS_INTF
3053: WHERE process_status = G_SUCCESS_RECORD
3054: AND ((p_set_process_id IS NULL) OR (set_process_id=p_set_process_id));
3055:
3056: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Delete_Processed_Trans_Attrs');
3057: EXCEPTION
3058: WHEN OTHERS THEN
3059: x_return_status:= G_RET_STS_UNEXP_ERROR;
3060: x_return_msg := G_PKG_NAME||'.'||l_proc_name||'.'||SQLERRM;

Line 3061: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception Delete_Processed_Trans_Attrs');

3057: EXCEPTION
3058: WHEN OTHERS THEN
3059: x_return_status:= G_RET_STS_UNEXP_ERROR;
3060: x_return_msg := G_PKG_NAME||'.'||l_proc_name||'.'||SQLERRM;
3061: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Exception Delete_Processed_Trans_Attrs');
3062:
3063: END Delete_Processed_Trans_Attrs;
3064:
3065: --=================Check_TA_IS_INVALID===============--------

Line 3323: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Check_TA_IS_INVALID');

3319: )
3320: AND attr_id=l_attr_id
3321: AND attr_id<>Nvl(p_attr_id,0000); --end cur_metadata
3322: BEGIN
3323: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Entering Check_TA_IS_INVALID');
3324: FOR i IN cur_list
3325: LOOP
3326: l_attr_id := i.attr_id;
3327: FOR j IN cur_metadata

Line 3361: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Check_TA_IS_INVALID');

3357: END LOOP;--FOR j IN cur_metadata
3358:
3359: END LOOP; --FOR i IN cur_list
3360: RETURN l_ta_is_invalid;
3361: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'End Check_TA_IS_INVALID');
3362: END Check_TA_IS_INVALID;
3363:
3364: END EGO_TA_BULKLOAD_PVT;