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_PAGES_BULKLOAD_PVT dependencies on ERROR_HANDLER

Line 745: error_handler.Add_error_message(p_message_name => 'EGO_PG_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,

741: x_return_status := G_RET_STS_ERROR;
742:
743: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_pg_tbl(i).transaction_id||' (PG) = ('||p_pg_tbl(i).internal_name||'). ' ||'Page is not defined in the system');
744:
745: error_handler.Add_error_message(p_message_name => 'EGO_PG_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
746: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
747: p_row_identifier => p_pg_tbl(i).transaction_id,
748: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
749: WHEN OTHERS THEN

Line 754: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,

750: x_return_status := G_RET_STS_UNEXP_ERROR;
751:
752: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_pg_tbl(i).transaction_id||' (PG) = ('||p_pg_tbl(i).internal_name||'). ' ||'Exception: '||SQLERRM);
753:
754: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
755: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
756: p_row_identifier => p_pg_tbl(i).transaction_id,
757: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
758:

Line 778: error_handler.Add_error_message(p_message_name => 'EGO_PG_ICC_INVALID',p_application_id => G_EGO_APPLICATION_ID,

774: x_return_status := G_RET_STS_ERROR;
775:
776: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_pg_tbl(i).transaction_id||' (PG,ICC) = ('||p_pg_tbl(i).internal_name||','||p_pg_tbl(i).classification_code||'). ' ||'ICC is not defined in the system');
777:
778: error_handler.Add_error_message(p_message_name => 'EGO_PG_ICC_INVALID',p_application_id => G_EGO_APPLICATION_ID,
779: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
780: p_row_identifier => p_pg_tbl(i).transaction_id,
781: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
782: WHEN OTHERS THEN

Line 787: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,

783: x_return_status := G_RET_STS_UNEXP_ERROR;
784:
785: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_pg_tbl(i).transaction_id||' (PG,ICC) = ('||p_pg_tbl(i).internal_name||','||p_pg_tbl(i).classification_code||'). ' ||'Exception: '||SQLERRM);
786:
787: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
788: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
789: p_row_identifier => p_pg_tbl(i).transaction_id,
790: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
791:

Line 840: error_handler.Add_error_message(p_message_name => 'EGO_PG_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,

836: x_return_status := G_RET_STS_ERROR;
837:
838: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG) = ('||p_ent_tbl(i).internal_name||'). ' ||'Page is not defined in the system');
839:
840: error_handler.Add_error_message(p_message_name => 'EGO_PG_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
841: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
842: p_row_identifier => p_ent_tbl(i).transaction_id,
843: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
844: WHEN OTHERS THEN

Line 849: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,

845: x_return_status := G_RET_STS_UNEXP_ERROR;
846:
847: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG) = ('||p_ent_tbl(i).internal_name||'). ' ||'Exception: '||SQLERRM);
848:
849: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
850: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
851: p_row_identifier => p_ent_tbl(i).transaction_id,
852: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
853:

Line 873: error_handler.Add_error_message(p_message_name => 'EGO_PG_ICC_INVALID',p_application_id => G_EGO_APPLICATION_ID,

869: x_return_status := G_RET_STS_ERROR;
870:
871: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG,ICC) = ('||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).classification_code||'). ' ||'ICC is not defined in the system');
872:
873: error_handler.Add_error_message(p_message_name => 'EGO_PG_ICC_INVALID',p_application_id => G_EGO_APPLICATION_ID,
874: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
875: p_row_identifier => p_ent_tbl(i).transaction_id,
876: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
877: WHEN OTHERS THEN

Line 882: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,

878: x_return_status := G_RET_STS_UNEXP_ERROR;
879:
880: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'construct_pg_entries_tbl exception when others smt 2');
881:
882: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
883: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
884: p_row_identifier => p_ent_tbl(i).transaction_id,
885: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
886:

Line 905: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,

901: x_return_status := G_RET_STS_ERROR;
902:
903: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG,AG) = ('||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).old_association_id||'). ' ||'Attribute Association is not defined in the system');
904:
905: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
906: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
907: p_row_identifier => p_ent_tbl(i).transaction_id,
908: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
909: WHEN OTHERS THEN

Line 914: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,

910: x_return_status := G_RET_STS_UNEXP_ERROR;
911:
912: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'construct_pg_entries_tbl exception when others smt 3');
913:
914: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
915: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
916: p_row_identifier => p_ent_tbl(i).transaction_id,
917: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
918:

Line 937: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,

933: x_return_status := G_RET_STS_ERROR;
934:
935: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG,ICC) = ('||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).new_association_id||'). ' ||'Attribute Association is not defined in the system');
936:
937: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
938: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
939: p_row_identifier => p_ent_tbl(i).transaction_id,
940: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
941: WHEN OTHERS THEN

Line 946: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,

942: x_return_status := G_RET_STS_UNEXP_ERROR;
943:
944: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'construct_pg_entries_tbl exception when others smt 4');
945:
946: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
947: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
948: p_row_identifier => p_ent_tbl(i).transaction_id,
949: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
950:

Line 970: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,

966: x_return_status := G_RET_STS_ERROR;
967:
968: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG,AG) = ('||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).old_association_id||'). ' ||'Attribute Association is not defined in the system');
969:
970: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
971: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
972: p_row_identifier => p_ent_tbl(i).transaction_id,
973: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
974: WHEN OTHERS THEN

Line 979: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,

975: x_return_status := G_RET_STS_UNEXP_ERROR;
976:
977: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'construct_pg_entries_tbl exception when others smt 5');
978:
979: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
980: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
981: p_row_identifier => p_ent_tbl(i).transaction_id,
982: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
983:

Line 1003: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,

999: x_return_status := G_RET_STS_ERROR;
1000:
1001: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG,ICC) = ('||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).new_association_id||'). ' ||'Attribute Association is not defined in the system');
1002:
1003: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
1004: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1005: p_row_identifier => p_ent_tbl(i).transaction_id,
1006: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1007: WHEN OTHERS THEN

Line 1012: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,

1008: x_return_status := G_RET_STS_UNEXP_ERROR;
1009:
1010: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'construct_pg_entries_tbl exception when others smt 6');
1011:
1012: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
1013: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1014: p_row_identifier => p_ent_tbl(i).transaction_id,
1015: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1016:

Line 1080: error_handler.Add_error_message(p_message_name => 'EGO_PG_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,

1076: x_return_status := G_RET_STS_ERROR;
1077:
1078: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Page is not defined in the system');
1079:
1080: error_handler.Add_error_message(p_message_name => 'EGO_PG_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
1081: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1082: p_row_identifier => p_pg_tbl(i).transaction_id,
1083: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
1084: END IF;

Line 1090: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,

1086: x_return_status := G_RET_STS_UNEXP_ERROR;
1087:
1088: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_page_tbl exception when others smt 1');
1089:
1090: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
1091: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1092: p_row_identifier => p_pg_tbl(i).transaction_id,
1093: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
1094:

Line 1151: error_handler.Add_error_message(p_message_name => 'EGO_PG_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,

1147: x_return_status := G_RET_STS_ERROR;
1148:
1149: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Page is not defined in the system');
1150:
1151: error_handler.Add_error_message(p_message_name => 'EGO_PG_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
1152: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1153: p_row_identifier => p_ent_tbl(i).transaction_id,
1154: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1155: WHEN OTHERS THEN

Line 1160: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,

1156: x_return_status := G_RET_STS_UNEXP_ERROR;
1157:
1158: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_pg_entries_tbl exception when others smt 1');
1159:
1160: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
1161: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1162: p_row_identifier => p_ent_tbl(i).transaction_id,
1163: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1164:

Line 1187: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,

1183: x_return_status := G_RET_STS_ERROR;
1184:
1185: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Association does not exist');
1186:
1187: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
1188: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1189: p_row_identifier => p_ent_tbl(i).transaction_id,
1190: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1191: WHEN OTHERS THEN

Line 1196: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,

1192: x_return_status := G_RET_STS_UNEXP_ERROR;
1193:
1194: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_pg_entries_tbl exception when others smt 2');
1195:
1196: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
1197: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1198: p_row_identifier => p_ent_tbl(i).transaction_id,
1199: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1200:

Line 1224: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,

1220: x_return_status := G_RET_STS_ERROR;
1221:
1222: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Association does not exist');
1223:
1224: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
1225: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1226: p_row_identifier => p_ent_tbl(i).transaction_id,
1227: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1228: WHEN OTHERS THEN

Line 1233: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,

1229: x_return_status := G_RET_STS_UNEXP_ERROR;
1230:
1231: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_pg_entries_tbl exception when others smt 3');
1232:
1233: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
1234: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1235: p_row_identifier => p_ent_tbl(i).transaction_id,
1236: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1237:

Line 1258: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,

1254: x_return_status := G_RET_STS_ERROR;
1255:
1256: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Association does not exist');
1257:
1258: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
1259: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1260: p_row_identifier => p_ent_tbl(i).transaction_id,
1261: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1262: WHEN OTHERS THEN

Line 1267: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,

1263: x_return_status := G_RET_STS_UNEXP_ERROR;
1264:
1265: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_pg_entries_tbl exception when others smt 4');
1266:
1267: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
1268: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1269: p_row_identifier => p_ent_tbl(i).transaction_id,
1270: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1271:

Line 1292: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,

1288: x_return_status := G_RET_STS_ERROR;
1289:
1290: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Association does not exist');
1291:
1292: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
1293: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1294: p_row_identifier => p_ent_tbl(i).transaction_id,
1295: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1296: WHEN OTHERS THEN

Line 1301: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,

1297: x_return_status := G_RET_STS_UNEXP_ERROR;
1298:
1299: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_pg_entries_tbl exception when others smt 5');
1300:
1301: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
1302: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1303: p_row_identifier => p_ent_tbl(i).transaction_id,
1304: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1305:

Line 1330: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,

1326: x_return_status := G_RET_STS_UNEXP_ERROR;
1327:
1328: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_pg_entries_tbl exception when others smt 6');
1329:
1330: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
1331: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1332: p_row_identifier => p_ent_tbl(i).transaction_id,
1333: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1334:

Line 1877: error_handler.Add_error_message(p_message_name => 'EGO_PG_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,

1873: x_return_status := G_RET_STS_ERROR;
1874:
1875: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Page is not defined in the system');
1876:
1877: error_handler.Add_error_message(p_message_name => 'EGO_PG_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
1878: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1879: p_row_identifier => p_pg_tbl(i).transaction_id,
1880: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
1881: END IF;

Line 1896: error_handler.Add_error_message(p_message_name => 'EGO_PG_SEQ_DUP',p_application_id => G_EGO_APPLICATION_ID,

1892: x_return_status := G_RET_STS_ERROR;
1893:
1894: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Sequence exists in the system');
1895:
1896: error_handler.Add_error_message(p_message_name => 'EGO_PG_SEQ_DUP',p_application_id => G_EGO_APPLICATION_ID,
1897: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1898: p_row_identifier => p_pg_tbl(i).transaction_id,
1899: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
1900: EXCEPTION

Line 1908: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,

1904: x_return_status := G_RET_STS_UNEXP_ERROR;
1905:
1906: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Additional_pg_validations exception when others smt 2');
1907:
1908: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
1909: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1910: p_row_identifier => p_pg_tbl(i).transaction_id,
1911: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
1912:

Line 1938: error_handler.Add_error_message(p_message_name => 'EGO_TRANS_TYPE_INVALID',p_application_id => 'EGO',

1934: x_return_status := G_RET_STS_ERROR;
1935:
1936: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Invalid transaction type for PG');
1937:
1938: error_handler.Add_error_message(p_message_name => 'EGO_TRANS_TYPE_INVALID',p_application_id => 'EGO',
1939: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
1940: p_row_identifier => p_pg_tbl(i).transaction_id,
1941: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
1942: END IF;

Line 1989: error_handler.Add_error_message(p_message_name => 'EGO_PG_ENT_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,

1985: x_return_status := G_RET_STS_ERROR;
1986:
1987: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Sequence exists in the system');
1988:
1989: error_handler.Add_error_message(p_message_name => 'EGO_PG_ENT_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
1990: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1991: p_row_identifier => p_ent_tbl(i).transaction_id,
1992: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1993: WHEN OTHERS THEN

Line 1998: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,

1994: x_return_status := G_RET_STS_UNEXP_ERROR;
1995:
1996: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Additional_ent_validations exception when others smt 1');
1997:
1998: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
1999: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
2000: p_row_identifier => p_ent_tbl(i).transaction_id,
2001: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2002:

Line 2022: error_handler.Add_error_message(p_message_name => 'EGO_PAGE_ENTRY_SAME_SEQ',p_application_id => G_EGO_APPLICATION_ID,

2018: x_return_status := G_RET_STS_ERROR;
2019:
2020: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Sequence exists in the system for the same page');
2021:
2022: error_handler.Add_error_message(p_message_name => 'EGO_PAGE_ENTRY_SAME_SEQ',p_application_id => G_EGO_APPLICATION_ID,
2023: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
2024: p_row_identifier => p_ent_tbl(i).transaction_id,
2025: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2026: END IF;

Line 2035: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,

2031: x_return_status := G_RET_STS_UNEXP_ERROR;
2032:
2033: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Additional_ent_validations exception when others smt 2');
2034:
2035: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
2036: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
2037: p_row_identifier => p_ent_tbl(i).transaction_id,
2038: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2039:

Line 2065: error_handler.Add_error_message(p_message_name => 'EGO_TRANS_TYPE_INVALID',p_application_id => 'EGO',

2061: x_return_status := G_RET_STS_ERROR;
2062:
2063: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Invalid transaction type for PG Entries');
2064:
2065: error_handler.Add_error_message(p_message_name => 'EGO_TRANS_TYPE_INVALID',p_application_id => 'EGO',
2066: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
2067: p_row_identifier => p_ent_tbl(i).transaction_id,
2068: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2069: END IF;

Line 2114: error_handler.Add_error_message(p_message_name => 'EGO_PG_MANDATORY',p_application_id => G_EGO_APPLICATION_ID,

2110: ||p_pg_tbl(i).internal_name||','||p_pg_tbl(i).classification_code||'). ' ||'Mandatory columns for create flow are not populated');
2111:
2112: p_pg_tbl(i).process_status := G_ERROR_RECORD;
2113:
2114: error_handler.Add_error_message(p_message_name => 'EGO_PG_MANDATORY',p_application_id => G_EGO_APPLICATION_ID,
2115: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
2116: p_row_identifier => p_pg_tbl(i).transaction_id,
2117: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
2118:

Line 2135: error_handler.Add_error_message(p_message_name => 'EGO_DL_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,

2131: ||p_pg_tbl(i).internal_name||','||p_pg_tbl(i).data_level||'). ' ||'Data Level passed is invalid');
2132:
2133: p_pg_tbl(i).process_status := G_ERROR_RECORD;
2134:
2135: error_handler.Add_error_message(p_message_name => 'EGO_DL_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
2136: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
2137: p_row_identifier => p_pg_tbl(i).transaction_id,
2138: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
2139: END IF;

Line 2148: error_handler.Add_error_message(p_message_name => 'EGO_PG_ICC_INVALID',p_application_id => G_EGO_APPLICATION_ID,

2144: ||p_pg_tbl(i).internal_name||','||p_pg_tbl(i).classification_code||'). ' ||'ICC code or name passed is invalid');
2145:
2146: p_pg_tbl(i).process_status := G_ERROR_RECORD;
2147:
2148: error_handler.Add_error_message(p_message_name => 'EGO_PG_ICC_INVALID',p_application_id => G_EGO_APPLICATION_ID,
2149: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
2150: p_row_identifier => p_pg_tbl(i).transaction_id,
2151: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
2152: END IF;

Line 2194: error_handler.Add_error_message(p_message_name => 'EGO_PG_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,

2190: ||p_ent_tbl(i).internal_name||'). ' ||'Page does not exist');
2191:
2192: p_ent_tbl(i).process_status := G_ERROR_RECORD;
2193:
2194: error_handler.Add_error_message(p_message_name => 'EGO_PG_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
2195: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
2196: p_row_identifier => p_ent_tbl(i).transaction_id,
2197: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2198: END IF;

Line 2211: error_handler.Add_error_message(p_message_name => 'EGO_PG_ICC_INVALID',p_application_id => G_EGO_APPLICATION_ID,

2207: ||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).classification_code||'). ' ||'ICC does not exist');
2208:
2209: p_ent_tbl(i).process_status := G_ERROR_RECORD;
2210:
2211: error_handler.Add_error_message(p_message_name => 'EGO_PG_ICC_INVALID',p_application_id => G_EGO_APPLICATION_ID,
2212: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
2213: p_row_identifier => p_ent_tbl(i).transaction_id,
2214: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2215: END IF;

Line 2228: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,

2224: ||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).old_association_id||'). ' ||'Old Association does not exist');
2225:
2226: p_ent_tbl(i).process_status := G_ERROR_RECORD;
2227:
2228: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
2229: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
2230: p_row_identifier => p_ent_tbl(i).transaction_id,
2231: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2232: END IF;

Line 2245: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,

2241: ||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).new_association_id||'). ' ||'New association does not exist');
2242:
2243: p_ent_tbl(i).process_status := G_ERROR_RECORD;
2244:
2245: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
2246: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
2247: p_row_identifier => p_ent_tbl(i).transaction_id,
2248: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2249: END IF;

Line 2261: error_handler.Add_error_message(p_message_name => 'EGO_PG_ENT_MANDATORY',p_application_id => G_EGO_APPLICATION_ID,

2257: ||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).classification_code||'). ' ||'Mandatory columns for Page Entry creation is not populated');
2258:
2259: p_ent_tbl(i).process_status := G_ERROR_RECORD;
2260:
2261: error_handler.Add_error_message(p_message_name => 'EGO_PG_ENT_MANDATORY',p_application_id => G_EGO_APPLICATION_ID,
2262: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
2263: p_row_identifier => p_ent_tbl(i).transaction_id,
2264: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2265: END IF;

Line 2289: error_handler.Add_error_message(p_message_name => 'EGO_ATTRIBUTE_GROUP_CONSTRAINT',p_application_id => G_EGO_APPLICATION_ID,

2285: ||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).old_association_id||'). ' ||'Cannot associate the same AG twice.');
2286:
2287: p_ent_tbl(i).process_status := G_ERROR_RECORD;
2288:
2289: error_handler.Add_error_message(p_message_name => 'EGO_ATTRIBUTE_GROUP_CONSTRAINT',p_application_id => G_EGO_APPLICATION_ID,
2290: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
2291: p_row_identifier => p_ent_tbl(i).transaction_id,
2292: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2293: END IF;

Line 2300: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,

2296: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exception'||SQLERRM);
2297:
2298: p_ent_tbl(i).process_status := G_RET_STS_UNEXP_ERROR;
2299:
2300: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
2301: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
2302: p_row_identifier => p_ent_tbl(i).transaction_id,
2303: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2304:

Line 2356: error_handler.Set_bo_identifier(G_BO_IDENTIFIER_PG);

2352: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entered import_pg_intf.');
2353:
2354: x_return_status := G_RET_STS_SUCCESS;
2355:
2356: error_handler.Set_bo_identifier(G_BO_IDENTIFIER_PG);
2357:
2358: G_SET_PROCESS_ID := p_set_process_id;
2359:
2360: Initialize(x_return_status => x_return_status, x_return_msg => x_return_msg); IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN RETURN; END IF;

Line 2445: error_handler.Set_bo_identifier(G_BO_IDENTIFIER_PG);

2441: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering Process_pages');
2442:
2443: x_return_status := G_RET_STS_SUCCESS;
2444:
2445: error_handler.Set_bo_identifier(G_BO_IDENTIFIER_PG);
2446:
2447: G_COMMIT := p_commit;
2448:
2449: IF (p_pg_tbl.COUNT <> 0) THEN

Line 2490: error_handler.Set_bo_identifier(G_BO_IDENTIFIER_PG);

2486: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering Process_pg_entries');
2487:
2488: x_return_status := G_RET_STS_SUCCESS;
2489:
2490: error_handler.Set_bo_identifier(G_BO_IDENTIFIER_PG);
2491:
2492: G_COMMIT := p_commit;
2493:
2494: IF (p_ent_tbl.COUNT <> 0) THEN

Line 2565: error_handler.Add_error_message(p_message_name => 'EGO_INTERNAL_NAME_EXISTS',p_application_id => G_EGO_APPLICATION_ID,

2561: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Page already exists');
2562:
2563: p_pg_tbl(i).process_status := G_ERROR_RECORD;
2564:
2565: error_handler.Add_error_message(p_message_name => 'EGO_INTERNAL_NAME_EXISTS',p_application_id => G_EGO_APPLICATION_ID,
2566: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
2567: p_row_identifier => p_pg_tbl(i).transaction_id,
2568: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
2569: ELSIF (lv_count_seq > 0) THEN

Line 2574: error_handler.Add_error_message(p_message_name => 'EGO_PG_SEQ_DUP',p_application_id => G_EGO_APPLICATION_ID,

2570: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Page sequence already exists');
2571:
2572: p_pg_tbl(i).process_status := G_ERROR_RECORD;
2573:
2574: error_handler.Add_error_message(p_message_name => 'EGO_PG_SEQ_DUP',p_application_id => G_EGO_APPLICATION_ID,
2575: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
2576: p_row_identifier => p_pg_tbl(i).transaction_id,
2577: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
2578: ELSE

Line 2618: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => G_EGO_APPLICATION_ID,

2614: G_TOKEN_TABLE(3).Token_Value := 'ego_ext_fwk_pub';
2615: G_TOKEN_TABLE(4).Token_Name := 'Proc_Name';
2616: G_TOKEN_TABLE(4).Token_Value := 'Create_page';
2617:
2618: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => G_EGO_APPLICATION_ID,
2619: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
2620: p_row_identifier => P_pg_tbl(i).transaction_id,
2621: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
2622:

Line 2623: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => G_EGO_APPLICATION_ID,

2619: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
2620: p_row_identifier => P_pg_tbl(i).transaction_id,
2621: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
2622:
2623: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => G_EGO_APPLICATION_ID,
2624: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
2625: p_row_identifier => P_pg_tbl(i).transaction_id,
2626: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
2627:

Line 2669: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => G_EGO_APPLICATION_ID,

2665: G_TOKEN_TABLE(3).Token_Value := 'ego_ext_fwk_pub';
2666: G_TOKEN_TABLE(4).Token_Name := 'Proc_Name';
2667: G_TOKEN_TABLE(4).Token_Value := 'Update_page';
2668:
2669: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => G_EGO_APPLICATION_ID,
2670: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
2671: p_row_identifier => P_pg_tbl(i).transaction_id,
2672: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
2673:

Line 2674: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => G_EGO_APPLICATION_ID,

2670: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
2671: p_row_identifier => P_pg_tbl(i).transaction_id,
2672: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
2673:
2674: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => G_EGO_APPLICATION_ID,
2675: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
2676: p_row_identifier => P_pg_tbl(i).transaction_id,
2677: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
2678:

Line 2716: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => G_EGO_APPLICATION_ID,

2712: G_TOKEN_TABLE(3).Token_Value := 'ego_ext_fwk_pub';
2713: G_TOKEN_TABLE(4).Token_Name := 'Proc_Name';
2714: G_TOKEN_TABLE(4).Token_Value := 'Delete_page';
2715:
2716: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => G_EGO_APPLICATION_ID,
2717: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
2718: p_row_identifier => P_pg_tbl(i).transaction_id,
2719: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
2720:

Line 2721: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => G_EGO_APPLICATION_ID,

2717: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
2718: p_row_identifier => P_pg_tbl(i).transaction_id,
2719: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
2720:
2721: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => G_EGO_APPLICATION_ID,
2722: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
2723: p_row_identifier => P_pg_tbl(i).transaction_id,
2724: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
2725:

Line 2797: error_handler.Add_error_message(p_message_name => 'EGO_PG_AG_DUP',p_application_id => G_EGO_APPLICATION_ID,

2793: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Page Entry association already exists');
2794:
2795: P_ent_tbl(i).process_status := G_ERROR_RECORD;
2796:
2797: error_handler.Add_error_message(p_message_name => 'EGO_PG_AG_DUP',p_application_id => G_EGO_APPLICATION_ID,
2798: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
2799: p_row_identifier => P_ent_tbl(i).transaction_id,
2800: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2801: ELSIF (lv_count_seq > 0) THEN

Line 2806: error_handler.Add_error_message(p_message_name => 'EGO_PAGE_ENTRY_SAME_SEQ',p_application_id => G_EGO_APPLICATION_ID,

2802: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Page Entry sequence already exists');
2803:
2804: P_ent_tbl(i).process_status := G_ERROR_RECORD;
2805:
2806: error_handler.Add_error_message(p_message_name => 'EGO_PAGE_ENTRY_SAME_SEQ',p_application_id => G_EGO_APPLICATION_ID,
2807: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
2808: p_row_identifier => P_ent_tbl(i).transaction_id,
2809: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2810: ELSE

Line 2844: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => G_EGO_APPLICATION_ID,

2840: G_TOKEN_TABLE(3).Token_Value := 'ego_ext_fwk_pub';
2841: G_TOKEN_TABLE(4).Token_Name := 'Proc_Name';
2842: G_TOKEN_TABLE(4).Token_Value := 'Create_page_entry';
2843:
2844: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => G_EGO_APPLICATION_ID,
2845: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
2846: p_row_identifier => P_ent_tbl(i).transaction_id,
2847: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2848:

Line 2849: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => G_EGO_APPLICATION_ID,

2845: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
2846: p_row_identifier => P_ent_tbl(i).transaction_id,
2847: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2848:
2849: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => G_EGO_APPLICATION_ID,
2850: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
2851: p_row_identifier => P_ent_tbl(i).transaction_id,
2852: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2853:

Line 2874: error_handler.Add_error_message(p_message_name => 'EGO_PAGE_ENTRY_SAME_SEQ',p_application_id => G_EGO_APPLICATION_ID,

2870: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Page Entry sequence already exists');
2871:
2872: P_ent_tbl(i).process_status := G_ERROR_RECORD;
2873:
2874: error_handler.Add_error_message(p_message_name => 'EGO_PAGE_ENTRY_SAME_SEQ',p_application_id => G_EGO_APPLICATION_ID,
2875: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
2876: p_row_identifier => P_ent_tbl(i).transaction_id,
2877: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2878: ELSE

Line 2912: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => G_EGO_APPLICATION_ID,

2908: G_TOKEN_TABLE(3).Token_Value := 'ego_ext_fwk_pub';
2909: G_TOKEN_TABLE(4).Token_Name := 'Proc_Name';
2910: G_TOKEN_TABLE(4).Token_Value := 'Update_page_entry';
2911:
2912: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => G_EGO_APPLICATION_ID,
2913: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
2914: p_row_identifier => P_ent_tbl(i).transaction_id,
2915: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2916:

Line 2917: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => G_EGO_APPLICATION_ID,

2913: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
2914: p_row_identifier => P_ent_tbl(i).transaction_id,
2915: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2916:
2917: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => G_EGO_APPLICATION_ID,
2918: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
2919: p_row_identifier => P_ent_tbl(i).transaction_id,
2920: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2921:

Line 2960: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => G_EGO_APPLICATION_ID,

2956: G_TOKEN_TABLE(3).Token_Value := 'ego_ext_fwk_pub';
2957: G_TOKEN_TABLE(4).Token_Name := 'Proc_Name';
2958: G_TOKEN_TABLE(4).Token_Value := 'Delete_page_entry';
2959:
2960: error_handler.Add_error_message(p_message_name => 'EGO_ENTITY_API_FAILED',p_application_id => G_EGO_APPLICATION_ID,
2961: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
2962: p_row_identifier => P_ent_tbl(i).transaction_id,
2963: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2964:

Line 2965: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => G_EGO_APPLICATION_ID,

2961: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
2962: p_row_identifier => P_ent_tbl(i).transaction_id,
2963: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2964:
2965: error_handler.Add_error_message(p_message_text => x_msg_data,p_application_id => G_EGO_APPLICATION_ID,
2966: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
2967: p_row_identifier => P_ent_tbl(i).transaction_id,
2968: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2969: