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.ECE_INBOUND dependencies on ECE_RULES_PKG

Line 923: ECE_RULES_PKG.Validate_Process_Rules

919: ec_utils.i_ret_code :=2;
920: raise ec_utils.program_exit;
921: end if;
922:
923: ECE_RULES_PKG.Validate_Process_Rules
924: (
925: 1.0,
926: NULL,
927: null,

Line 991: ECE_RULES_PKG.Validate_Column_Rules

987: ec_utils.execute_stage_data ( 40, i_level);
988: end if;
989:
990: --Perform Column Exception Processing
991: ECE_RULES_PKG.Validate_Column_Rules
992: (
993: 1.0,
994: NULL,
995: null,

Line 1301: ece_rules_pkg.g_rule_violation_tbl.DELETE;

1297: ec_utils.g_stack.DELETE;
1298: ec_utils.g_direction := 'I';
1299: ec_utils.g_transaction_type := i_transaction_type;
1300: ec_utils.g_map_id := i_map_id;
1301: ece_rules_pkg.g_rule_violation_tbl.DELETE;
1302: ece_flatfile_pvt.get_tran_attributes(i_transaction_type);
1303:
1304: /**
1305: Get all the Dynamic Inbound Staging data. The data is retrieved from the

Line 1399: ece_rules_pkg.g_rule_violation_tbl.DELETE;

1395: ec_utils.g_stack(i).variable_value := NULL;
1396: end loop;
1397:
1398: ec_utils.g_stack_pointer.DELETE;
1399: ece_rules_pkg.g_rule_violation_tbl.DELETE;
1400:
1401: ec_utils.g_stack_pointer(0).start_pos :=1;
1402: ec_utils.g_stack_pointer(0).end_pos :=0;
1403: for i in 1..ec_utils.g_ext_levels.COUNT

Line 1503: for i in 1..ece_rules_pkg.g_rule_violation_tbl.COUNT

1499: where document_id = i_document_id
1500: and ignore_flag = 'N';
1501:
1502:
1503: for i in 1..ece_rules_pkg.g_rule_violation_tbl.COUNT
1504: loop
1505: INSERT into ece_rule_violations
1506: (
1507: violation_id,

Line 1525: ece_rules_pkg.g_rule_violation_tbl(i).violation_id,

1521: last_update_login
1522: )
1523: VALUES
1524: (
1525: ece_rules_pkg.g_rule_violation_tbl(i).violation_id,
1526: ece_rules_pkg.g_rule_violation_tbl(i).document_id,
1527: ece_rules_pkg.g_rule_violation_tbl(i).stage_id,
1528: ece_rules_pkg.g_rule_violation_tbl(i).interface_column_id,
1529: ece_rules_pkg.g_rule_violation_tbl(i).rule_id,

Line 1526: ece_rules_pkg.g_rule_violation_tbl(i).document_id,

1522: )
1523: VALUES
1524: (
1525: ece_rules_pkg.g_rule_violation_tbl(i).violation_id,
1526: ece_rules_pkg.g_rule_violation_tbl(i).document_id,
1527: ece_rules_pkg.g_rule_violation_tbl(i).stage_id,
1528: ece_rules_pkg.g_rule_violation_tbl(i).interface_column_id,
1529: ece_rules_pkg.g_rule_violation_tbl(i).rule_id,
1530: ece_rules_pkg.g_rule_violation_tbl(i).transaction_type,

Line 1527: ece_rules_pkg.g_rule_violation_tbl(i).stage_id,

1523: VALUES
1524: (
1525: ece_rules_pkg.g_rule_violation_tbl(i).violation_id,
1526: ece_rules_pkg.g_rule_violation_tbl(i).document_id,
1527: ece_rules_pkg.g_rule_violation_tbl(i).stage_id,
1528: ece_rules_pkg.g_rule_violation_tbl(i).interface_column_id,
1529: ece_rules_pkg.g_rule_violation_tbl(i).rule_id,
1530: ece_rules_pkg.g_rule_violation_tbl(i).transaction_type,
1531: ece_rules_pkg.g_rule_violation_tbl(i).document_number,

Line 1528: ece_rules_pkg.g_rule_violation_tbl(i).interface_column_id,

1524: (
1525: ece_rules_pkg.g_rule_violation_tbl(i).violation_id,
1526: ece_rules_pkg.g_rule_violation_tbl(i).document_id,
1527: ece_rules_pkg.g_rule_violation_tbl(i).stage_id,
1528: ece_rules_pkg.g_rule_violation_tbl(i).interface_column_id,
1529: ece_rules_pkg.g_rule_violation_tbl(i).rule_id,
1530: ece_rules_pkg.g_rule_violation_tbl(i).transaction_type,
1531: ece_rules_pkg.g_rule_violation_tbl(i).document_number,
1532: ece_rules_pkg.g_rule_violation_tbl(i).violation_level,

Line 1529: ece_rules_pkg.g_rule_violation_tbl(i).rule_id,

1525: ece_rules_pkg.g_rule_violation_tbl(i).violation_id,
1526: ece_rules_pkg.g_rule_violation_tbl(i).document_id,
1527: ece_rules_pkg.g_rule_violation_tbl(i).stage_id,
1528: ece_rules_pkg.g_rule_violation_tbl(i).interface_column_id,
1529: ece_rules_pkg.g_rule_violation_tbl(i).rule_id,
1530: ece_rules_pkg.g_rule_violation_tbl(i).transaction_type,
1531: ece_rules_pkg.g_rule_violation_tbl(i).document_number,
1532: ece_rules_pkg.g_rule_violation_tbl(i).violation_level,
1533: ece_rules_pkg.g_rule_violation_tbl(i).ignore_flag,

Line 1530: ece_rules_pkg.g_rule_violation_tbl(i).transaction_type,

1526: ece_rules_pkg.g_rule_violation_tbl(i).document_id,
1527: ece_rules_pkg.g_rule_violation_tbl(i).stage_id,
1528: ece_rules_pkg.g_rule_violation_tbl(i).interface_column_id,
1529: ece_rules_pkg.g_rule_violation_tbl(i).rule_id,
1530: ece_rules_pkg.g_rule_violation_tbl(i).transaction_type,
1531: ece_rules_pkg.g_rule_violation_tbl(i).document_number,
1532: ece_rules_pkg.g_rule_violation_tbl(i).violation_level,
1533: ece_rules_pkg.g_rule_violation_tbl(i).ignore_flag,
1534: ece_rules_pkg.g_rule_violation_tbl(i).message_text,

Line 1531: ece_rules_pkg.g_rule_violation_tbl(i).document_number,

1527: ece_rules_pkg.g_rule_violation_tbl(i).stage_id,
1528: ece_rules_pkg.g_rule_violation_tbl(i).interface_column_id,
1529: ece_rules_pkg.g_rule_violation_tbl(i).rule_id,
1530: ece_rules_pkg.g_rule_violation_tbl(i).transaction_type,
1531: ece_rules_pkg.g_rule_violation_tbl(i).document_number,
1532: ece_rules_pkg.g_rule_violation_tbl(i).violation_level,
1533: ece_rules_pkg.g_rule_violation_tbl(i).ignore_flag,
1534: ece_rules_pkg.g_rule_violation_tbl(i).message_text,
1535: sysdate,

Line 1532: ece_rules_pkg.g_rule_violation_tbl(i).violation_level,

1528: ece_rules_pkg.g_rule_violation_tbl(i).interface_column_id,
1529: ece_rules_pkg.g_rule_violation_tbl(i).rule_id,
1530: ece_rules_pkg.g_rule_violation_tbl(i).transaction_type,
1531: ece_rules_pkg.g_rule_violation_tbl(i).document_number,
1532: ece_rules_pkg.g_rule_violation_tbl(i).violation_level,
1533: ece_rules_pkg.g_rule_violation_tbl(i).ignore_flag,
1534: ece_rules_pkg.g_rule_violation_tbl(i).message_text,
1535: sysdate,
1536: fnd_global.user_id,

Line 1533: ece_rules_pkg.g_rule_violation_tbl(i).ignore_flag,

1529: ece_rules_pkg.g_rule_violation_tbl(i).rule_id,
1530: ece_rules_pkg.g_rule_violation_tbl(i).transaction_type,
1531: ece_rules_pkg.g_rule_violation_tbl(i).document_number,
1532: ece_rules_pkg.g_rule_violation_tbl(i).violation_level,
1533: ece_rules_pkg.g_rule_violation_tbl(i).ignore_flag,
1534: ece_rules_pkg.g_rule_violation_tbl(i).message_text,
1535: sysdate,
1536: fnd_global.user_id,
1537: sysdate,

Line 1534: ece_rules_pkg.g_rule_violation_tbl(i).message_text,

1530: ece_rules_pkg.g_rule_violation_tbl(i).transaction_type,
1531: ece_rules_pkg.g_rule_violation_tbl(i).document_number,
1532: ece_rules_pkg.g_rule_violation_tbl(i).violation_level,
1533: ece_rules_pkg.g_rule_violation_tbl(i).ignore_flag,
1534: ece_rules_pkg.g_rule_violation_tbl(i).message_text,
1535: sysdate,
1536: fnd_global.user_id,
1537: sysdate,
1538: fnd_global.user_id,

Line 1544: ece_rules_pkg.g_rule_violation_tbl.DELETE;

1540: );
1541: end loop;
1542: /** Clean the PL/SQL table for next set of violations.
1543: **/
1544: ece_rules_pkg.g_rule_violation_tbl.DELETE;
1545: if ec_debug.G_debug_level >= 2 then
1546: ec_debug.pop('ECE_INBOUND.INSERT_INTO_VIOLATIONS');
1547: end if;
1548: EXCEPTION