DBA Data[Home] [Help]

APPS.XLA_EXTRACT_INTEGRITY_PKG dependencies on XLA_AMB_SETUP_ERR_PKG

Line 226: Xla_amb_setup_err_pkg.initialize;

222: AND event_class_code = p_event_class_code
223: AND product_rule_code IS NULL;
224:
225: -- Initialize the error package
226: Xla_amb_setup_err_pkg.initialize;
227:
228: -- Get the extract object owner and store in GT table.
229: xla_extract_integrity_pkg.set_extract_object_owner
230: (p_application_id => l_application_id

Line 288: Xla_amb_setup_err_pkg.insert_errors;

284: END IF;
285: END IF;
286:
287: -- Insert errors into the error table from the plsql array
288: Xla_amb_setup_err_pkg.insert_errors;
289: COMMIT;
290:
291: IF ((g_log_enabled = TRUE) AND (C_LEVEL_PROCEDURE >= g_log_level)) THEN
292: trace

Line 505: Xla_amb_setup_err_pkg.stack_error

501: OPEN c_ec_obj_exist;
502: FETCH c_ec_obj_exist
503: INTO l_exist;
504: IF c_ec_obj_exist%NOTFOUND THEN
505: Xla_amb_setup_err_pkg.stack_error
506: (p_message_name => 'XLA_AB_EC_NO_EXTRACT_OBJECTS'
507: ,p_message_type => 'E'
508: ,p_message_category => 'EVENT_CLASS'
509: ,p_category_sequence => 2

Line 533: Xla_amb_setup_err_pkg.stack_error

529: ELSE
530: l_message_name := 'XLA_AB_EXT_OBJECT_NOT_DEFINED';
531: END IF;
532:
533: Xla_amb_setup_err_pkg.stack_error
534: (p_message_name => l_message_name
535: ,p_message_type => 'E'
536: ,p_message_category => 'EXTRACT_OBJECT'
537: ,p_category_sequence => 3

Line 558: Xla_amb_setup_err_pkg.stack_error

554: LOOP
555: FETCH c_aad_obj_exist
556: INTO l_aad_obj_exist;
557: EXIT WHEN c_aad_obj_exist%notfound;
558: Xla_amb_setup_err_pkg.stack_error
559: (p_message_name => 'XLA_AB_EC_NO_EXTRACT_OBJECTS'
560: ,p_message_type => 'W'
561: ,p_message_category => 'EVENT_CLASS'
562: ,p_category_sequence => 2

Line 589: Xla_amb_setup_err_pkg.stack_error

585: ELSE
586: l_message_name := 'XLA_AB_EXT_OBJECT_NOT_DEFINED';
587: END IF;
588:
589: Xla_amb_setup_err_pkg.stack_error
590: (p_message_name => 'XLA_AB_EXT_OBJECT_NOT_DEFINED'
591: ,p_message_type => 'W'
592: ,p_message_category => 'EXTRACT_OBJECT'
593: ,p_category_sequence => 3

Line 1688: Xla_amb_setup_err_pkg.stack_error

1684: LOOP
1685: FETCH c_null_obj
1686: INTO l_null_obj;
1687: EXIT WHEN c_null_obj%notfound;
1688: Xla_amb_setup_err_pkg.stack_error
1689: (p_message_name => 'XLA_AB_SRC_NOT_DEFINED_IN_EXT'
1690: ,p_message_type => 'E'
1691: ,p_message_category => 'EXTRACT_SOURCE'
1692: ,p_category_sequence => 4

Line 1714: Xla_amb_setup_err_pkg.stack_error

1710: LOOP
1711: FETCH c_datatype
1712: INTO l_datatype;
1713: EXIT WHEN c_datatype%notfound;
1714: Xla_amb_setup_err_pkg.stack_error
1715: (p_message_name => 'XLA_AB_SRC_DATATYPE_NOT_MATCH'
1716: ,p_message_type => 'E'
1717: ,p_message_category => 'EXTRACT_SOURCE'
1718: ,p_category_sequence => 4

Line 1996: Xla_amb_setup_err_pkg.stack_error

1992: VALUES(l_object_name
1993: ,l_user);
1994: EXCEPTION
1995: WHEN OTHERS THEN
1996: Xla_amb_setup_err_pkg.stack_error
1997: (p_message_name => 'XLA_AB_EXT_OBJECT_ERROR'
1998: ,p_message_type => 'E'
1999: ,p_message_category => 'EXTRACT_OBJECT'
2000: ,p_category_sequence => 3

Line 2021: Xla_amb_setup_err_pkg.stack_error

2017: VALUES(l_object_name
2018: ,l_user);
2019: EXCEPTION
2020: WHEN OTHERS THEN
2021: Xla_amb_setup_err_pkg.stack_error
2022: (p_message_name => 'XLA_AB_EXT_OBJECT_ERROR'
2023: ,p_message_type => 'E'
2024: ,p_message_category => 'EXTRACT_OBJECT'
2025: ,p_category_sequence => 3

Line 2051: Xla_amb_setup_err_pkg.stack_error

2047: VALUES(l_object_name
2048: ,l_syn_owner);
2049: EXCEPTION
2050: WHEN OTHERS THEN
2051: Xla_amb_setup_err_pkg.stack_error
2052: (p_message_name => 'XLA_AB_EXT_OBJECT_ERROR'
2053: ,p_message_type => 'E'
2054: ,p_message_category => 'EXTRACT_OBJECT'
2055: ,p_category_sequence => 3

Line 2075: Xla_amb_setup_err_pkg.stack_error

2071: VALUES(l_object_name
2072: ,l_syn_owner);
2073: EXCEPTION
2074: WHEN OTHERS THEN
2075: Xla_amb_setup_err_pkg.stack_error
2076: (p_message_name => 'XLA_AB_EXT_OBJECT_ERROR'
2077: ,p_message_type => 'E'
2078: ,p_message_category => 'EXTRACT_OBJECT'
2079: ,p_category_sequence => 3

Line 2766: Xla_amb_setup_err_pkg.stack_error

2762: FETCH c_aad_event_id
2763: INTO l_aad_event_id;
2764: EXIT WHEN c_aad_event_id%NOTFOUND;
2765:
2766: Xla_amb_setup_err_pkg.stack_error
2767: (p_message_name => 'XLA_AB_PK_EVENT_ID_NOT_DEFINED'
2768: ,p_message_type => 'E'
2769: ,p_message_category => 'EXTRACT_OBJECT'
2770: ,p_category_sequence => 3

Line 2793: Xla_amb_setup_err_pkg.stack_error

2789: FETCH c_aad_language
2790: INTO l_aad_language;
2791: EXIT WHEN c_aad_language%NOTFOUND;
2792:
2793: Xla_amb_setup_err_pkg.stack_error
2794: (p_message_name => 'XLA_AB_PK_LANGUAGE_NOT_DEFINED'
2795: ,p_message_type => 'E'
2796: ,p_message_category => 'EXTRACT_OBJECT'
2797: ,p_category_sequence => 3

Line 2820: Xla_amb_setup_err_pkg.stack_error

2816: FETCH c_aad_line_number
2817: INTO l_aad_line_number;
2818: EXIT WHEN c_aad_line_number%NOTFOUND;
2819:
2820: Xla_amb_setup_err_pkg.stack_error
2821: (p_message_name => 'XLA_AB_PK_LINE_NUM_NOT_DEFINED'
2822: ,p_message_type => 'E'
2823: ,p_message_category => 'EXTRACT_OBJECT'
2824: ,p_category_sequence => 3

Line 2847: Xla_amb_setup_err_pkg.stack_error

2843: FETCH c_aad_ledger_id
2844: INTO l_aad_ledger_id;
2845: EXIT WHEN c_aad_ledger_id%NOTFOUND;
2846:
2847: Xla_amb_setup_err_pkg.stack_error
2848: (p_message_name => 'XLA_AB_PK_LED_ID_NOT_DEFINED'
2849: ,p_message_type => 'E'
2850: ,p_message_category => 'EXTRACT_OBJECT'
2851: ,p_category_sequence => 3

Line 2876: Xla_amb_setup_err_pkg.stack_error

2872: FETCH c_event_id
2873: INTO l_event_id;
2874: EXIT WHEN c_event_id%NOTFOUND;
2875:
2876: Xla_amb_setup_err_pkg.stack_error
2877: (p_message_name => 'XLA_AB_PK_EVENT_ID_NOT_DEFINED'
2878: ,p_message_type => 'E'
2879: ,p_message_category => 'EXTRACT_OBJECT'
2880: ,p_category_sequence => 3

Line 2903: Xla_amb_setup_err_pkg.stack_error

2899: FETCH c_language
2900: INTO l_language;
2901: EXIT WHEN c_language%NOTFOUND;
2902:
2903: Xla_amb_setup_err_pkg.stack_error
2904: (p_message_name => 'XLA_AB_PK_LANGUAGE_NOT_DEFINED'
2905: ,p_message_type => 'E'
2906: ,p_message_category => 'EXTRACT_OBJECT'
2907: ,p_category_sequence => 3

Line 2930: Xla_amb_setup_err_pkg.stack_error

2926: FETCH c_line_number
2927: INTO l_line_number;
2928: EXIT WHEN c_line_number%NOTFOUND;
2929:
2930: Xla_amb_setup_err_pkg.stack_error
2931: (p_message_name => 'XLA_AB_PK_LINE_NUM_NOT_DEFINED'
2932: ,p_message_type => 'E'
2933: ,p_message_category => 'EXTRACT_OBJECT'
2934: ,p_category_sequence => 3

Line 2957: Xla_amb_setup_err_pkg.stack_error

2953: FETCH c_ledger_id
2954: INTO l_ledger_id;
2955: EXIT WHEN c_ledger_id%NOTFOUND;
2956:
2957: Xla_amb_setup_err_pkg.stack_error
2958: (p_message_name => 'XLA_AB_PK_LED_ID_NOT_DEFINED'
2959: ,p_message_type => 'E'
2960: ,p_message_category => 'EXTRACT_OBJECT'
2961: ,p_category_sequence => 3

Line 3271: Xla_amb_setup_err_pkg.stack_error

3267: FETCH c_reqd_sources
3268: INTO l_reqd_sources;
3269: EXIT WHEN c_reqd_sources%notfound;
3270:
3271: Xla_amb_setup_err_pkg.stack_error
3272: (p_message_name => 'XLA_AB_REQD_ACCT_SOURCES'
3273: ,p_message_type => 'E'
3274: ,p_message_category => 'ACCOUNTING_SOURCE'
3275: ,p_category_sequence => 5

Line 3302: Xla_amb_setup_err_pkg.stack_error

3298: LOOP
3299: FETCH c_group_sources
3300: INTO l_group_sources;
3301: EXIT WHEN c_group_sources%NOTFOUND;
3302: Xla_amb_setup_err_pkg.stack_error
3303: (p_message_name => 'XLA_AB_REQD_GRP_SOURCES'
3304: ,p_message_type => 'E'
3305: ,p_message_category => 'ACCOUNTING_SOURCE'
3306: ,p_category_sequence => 5

Line 3334: Xla_amb_setup_err_pkg.stack_error

3330: OPEN c_budget;
3331: FETCH c_budget
3332: INTO l_exist;
3333: IF c_budget%NOTFOUND THEN
3334: Xla_amb_setup_err_pkg.stack_error
3335: (p_message_name => 'XLA_AB_BUDGET_ACCTG_SRC'
3336: ,p_message_type => 'E'
3337: ,p_message_category => 'ACCOUNTING_SOURCE'
3338: ,p_category_sequence => 5

Line 3358: Xla_amb_setup_err_pkg.stack_error

3354: OPEN c_enc;
3355: FETCH c_enc
3356: INTO l_exist;
3357: IF c_enc%NOTFOUND THEN
3358: Xla_amb_setup_err_pkg.stack_error
3359: (p_message_name => 'XLA_AB_ENC_ACCTG_SRC'
3360: ,p_message_type => 'E'
3361: ,p_message_category => 'ACCOUNTING_SOURCE'
3362: ,p_category_sequence => 5

Line 3389: Xla_amb_setup_err_pkg.stack_error

3385: FETCH c_dist_2
3386: INTO l_exist;
3387: IF c_dist_2%notfound THEN
3388:
3389: Xla_amb_setup_err_pkg.stack_error
3390: (p_message_name => 'XLA_AB_EC_ACCT_REV_DIST_ID'
3391: ,p_message_type => 'E'
3392: ,p_message_category => 'ACCOUNTING_SOURCE'
3393: ,p_category_sequence => 5

Line 3416: Xla_amb_setup_err_pkg.stack_error

3412: FETCH c_dist_3
3413: INTO l_exist;
3414: IF c_dist_3%notfound THEN
3415:
3416: Xla_amb_setup_err_pkg.stack_error
3417: (p_message_name => 'XLA_AB_EC_ACCT_REV_DIST_ID'
3418: ,p_message_type => 'E'
3419: ,p_message_category => 'ACCOUNTING_SOURCE'
3420: ,p_category_sequence => 5

Line 3443: Xla_amb_setup_err_pkg.stack_error

3439: FETCH c_dist_4
3440: INTO l_exist;
3441: IF c_dist_4%notfound THEN
3442:
3443: Xla_amb_setup_err_pkg.stack_error
3444: (p_message_name => 'XLA_AB_EC_ACCT_REV_DIST_ID'
3445: ,p_message_type => 'E'
3446: ,p_message_category => 'ACCOUNTING_SOURCE'
3447: ,p_category_sequence => 5

Line 3470: Xla_amb_setup_err_pkg.stack_error

3466: FETCH c_dist_5
3467: INTO l_exist;
3468: IF c_dist_5%notfound THEN
3469:
3470: Xla_amb_setup_err_pkg.stack_error
3471: (p_message_name => 'XLA_AB_EC_ACCT_REV_DIST_ID'
3472: ,p_message_type => 'E'
3473: ,p_message_category => 'ACCOUNTING_SOURCE'
3474: ,p_category_sequence => 5

Line 3495: Xla_amb_setup_err_pkg.stack_error

3491: FETCH c_sources
3492: INTO l_sources;
3493: EXIT WHEN c_sources%notfound;
3494:
3495: Xla_amb_setup_err_pkg.stack_error
3496: (p_message_name => 'XLA_AB_EC_ACCT_ATTR_SRCE'
3497: ,p_message_type => 'E'
3498: ,p_message_category => 'ACCOUNTING_SOURCE'
3499: ,p_category_sequence => 5

Line 3528: Xla_amb_setup_err_pkg.stack_error

3524: ,p_entity_code => p_entity_code
3525: ,p_event_class_code => p_event_class_code
3526: ,p_level => 'L') = 'TRUE' THEN
3527:
3528: Xla_amb_setup_err_pkg.stack_error
3529: (p_message_name => 'XLA_AB_EC_ACCT_ATTR_SRCE'
3530: ,p_message_type => 'E'
3531: ,p_message_category => 'ACCOUNTING_SOURCE'
3532: ,p_category_sequence => 5

Line 3964: Xla_amb_setup_err_pkg.stack_error

3960: FETCH c_mls
3961: INTO l_column_name;
3962: EXIT WHEN c_mls%notfound;
3963:
3964: Xla_amb_setup_err_pkg.stack_error
3965: (p_message_name => 'XLA_AB_NUMBER_COL_IN_MLS'
3966: ,p_message_type => 'W'
3967: ,p_message_category => 'CREATE_SOURCE'
3968: ,p_category_sequence => 15

Line 4021: Xla_amb_setup_err_pkg.stack_error

4017: EXCEPTION
4018: WHEN dml_errors THEN
4019:
4020: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
4021: Xla_amb_setup_err_pkg.stack_error
4022: (p_message_name => 'XLA_AB_SAME_COL_DIFF_DATATYPE'
4023: ,p_message_type => 'W'
4024: ,p_message_category => 'CREATE_SOURCE'
4025: ,p_category_sequence => 15

Line 4083: Xla_amb_setup_err_pkg.stack_error

4079:
4080: EXCEPTION
4081: WHEN dml_errors THEN
4082: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
4083: Xla_amb_setup_err_pkg.stack_error
4084: (p_message_name => 'XLA_AB_SAME_COL_DIFF_DATATYPE'
4085: ,p_message_type => 'W'
4086: ,p_message_category => 'CREATE_SOURCE'
4087: ,p_category_sequence => 15

Line 4145: Xla_amb_setup_err_pkg.stack_error

4141: EXCEPTION
4142: WHEN dml_errors THEN
4143:
4144: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
4145: Xla_amb_setup_err_pkg.stack_error
4146: (p_message_name => 'XLA_AB_SAME_NAME_DIFF_CODE'
4147: ,p_message_type => 'E'
4148: ,p_message_category => 'CREATE_SOURCE'
4149: ,p_category_sequence => 15

Line 4209: Xla_amb_setup_err_pkg.stack_error

4205: EXCEPTION
4206: WHEN dml_errors THEN
4207:
4208: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
4209: Xla_amb_setup_err_pkg.stack_error
4210: (p_message_name => 'XLA_AB_SAME_NAME_DIFF_CODE'
4211: ,p_message_type => 'E'
4212: ,p_message_category => 'CREATE_SOURCE'
4213: ,p_category_sequence => 15