APPS.EGO_GTIN_PVT dependencies on EGO_PAGEWISE_ERROR_TABLE

Line 3686: l_error_table SYSTEM.EGO_PAGEWISE_ERROR_TABLE;

3682: l_attr1_value_uom VARCHAR2(10);
3683:
3684: l_sql VARCHAR2(15000);
3685: l_error_rec SYSTEM.EGO_PAGEWISE_ERROR_REC;
3686: l_error_table SYSTEM.EGO_PAGEWISE_ERROR_TABLE;
3687: l_unexp_err VARCHAR2(4000);
3688: l_attr1_name VARCHAR2(4000);
3689: l_attr2_name VARCHAR2(4000);
3690: l_attr3_name VARCHAR2(4000);

Line 3706: l_error_table := SYSTEM.EGO_PAGEWISE_ERROR_TABLE();

3702:
3703: column_not_found EXCEPTION;
3704: PRAGMA EXCEPTION_INIT(column_not_found, -904);
3705: BEGIN
3706: l_error_table := SYSTEM.EGO_PAGEWISE_ERROR_TABLE();
3707: l_error_rec := SYSTEM.EGO_PAGEWISE_ERROR_REC(NULL, '', '', '');
3708:
3709: BEGIN
3710: SELECT ITEM_CATALOG_GROUP_ID INTO l_catalog_group_id

Line 3721: FROM TABLE( CAST(l_error_table AS SYSTEM.EGO_PAGEWISE_ERROR_TABLE) );

3717: l_error_rec.ERROR_MESSAGE := SQLERRM;
3718: l_error_table(l_error_table.LAST) := l_error_rec;
3719: OPEN p_errors FOR
3720: SELECT *
3721: FROM TABLE( CAST(l_error_table AS SYSTEM.EGO_PAGEWISE_ERROR_TABLE) );
3722: RETURN;
3723: END;
3724:
3725: IF p_address_id IS NULL THEN

Line 3746: FROM TABLE( CAST(l_error_table AS SYSTEM.EGO_PAGEWISE_ERROR_TABLE) );

3742: l_error_rec.ERROR_LEVEL := 'C';
3743: l_error_table(l_error_table.LAST) := l_error_rec;
3744: OPEN p_errors FOR
3745: SELECT *
3746: FROM TABLE( CAST(l_error_table AS SYSTEM.EGO_PAGEWISE_ERROR_TABLE) );
3747: RETURN;
3748: WHEN OTHERS THEN
3749: l_error_table.EXTEND;
3750: l_error_rec.PAGE_ID := -1;

Line 3756: FROM TABLE( CAST(l_error_table AS SYSTEM.EGO_PAGEWISE_ERROR_TABLE) );

3752: l_error_rec.ERROR_LEVEL := 'C';
3753: l_error_table(l_error_table.LAST) := l_error_rec;
3754: OPEN p_errors FOR
3755: SELECT *
3756: FROM TABLE( CAST(l_error_table AS SYSTEM.EGO_PAGEWISE_ERROR_TABLE) );
3757: RETURN;
3758: END;
3759: END IF; -- IF l_do_tp_validations THEN
3760:

Line 4582: FROM TABLE( CAST(l_error_table AS SYSTEM.EGO_PAGEWISE_ERROR_TABLE) );

4578: END;
4579:
4580: OPEN p_errors FOR
4581: SELECT *
4582: FROM TABLE( CAST(l_error_table AS SYSTEM.EGO_PAGEWISE_ERROR_TABLE) );
4583: END Validate_SBDH_Attributes;
4584:
4585: /*
4586: * This method validates SBDH attributes. if p_address_id is null then only item level attributes