DBA Data[Home] [Help]

APPS.ZX_PRODUCT_INTEGRATION_PKG dependencies on APP_EXCEPTION

Line 891: APP_EXCEPTION.raise_exception;

887: IF (g_level_statement >= g_current_runtime_level) THEN
888: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','EXCEPTION: NO_DATA_FOUND IN SYSTEM PARAMETERS ' );
889: END IF;
890: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_SYSTEM_PARAMETERS');
891: APP_EXCEPTION.raise_exception;
892: RAISE;
893: end;
894:
895:

Line 938: APP_EXCEPTION.raise_exception;

934: IF (g_level_statement >= g_current_runtime_level) THEN
935: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','EXCEPTION: NO_DATA_FOUND IN SET OF BOOKS ' );
936: END IF;
937: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_GL_SET_OF_BOOKS');
938: APP_EXCEPTION.raise_exception;
939: RAISE;
940: end;
941:
942: -- Test 1 passed therefore currency must not be defined

Line 947: APP_EXCEPTION.raise_exception;

943: IF (g_level_statement >= g_current_runtime_level) THEN
944: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','EXCEPTION: NO_DATA_FOUND IN CURRENCIES ' );
945: END IF;
946: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_FND_CURRENCIES');
947: APP_EXCEPTION.raise_exception;
948: RAISE; --end of WHEN NO DATA FOUND
949: END;
950:
951:

Line 1008: APP_EXCEPTION.raise_exception;

1004: 'Error Getting OE Profile information');
1005: END IF;
1006: -- Bug 2185315 - added fnd_message so error will reflect on the form
1007: FND_MESSAGE.set_name('AR','AR_NO_OM_MASTER_ORG'); -- Bug 3151551
1008: APP_EXCEPTION.raise_exception;
1009: End if;
1010:
1011: profinfo.so_organization_id := l_master_org_id;
1012: --oe_profile.get('SO_ORGANIZATION_ID', profinfo.so_organization_id);

Line 2555: app_exception.raise_exception;

2551: WHEN NO_DATA_FOUND THEN
2552: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
2553: fnd_message.set_token('GENERIC_TEXT',
2554: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
2555: app_exception.raise_exception;
2556: WHEN OTHERS THEN
2557: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
2558: fnd_message.set_token('GENERIC_TEXT',
2559: 'EXCEPTION(OTHERS) : Tax Code : ' || sqlerrm);

Line 2560: app_exception.raise_exception;

2556: WHEN OTHERS THEN
2557: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
2558: fnd_message.set_token('GENERIC_TEXT',
2559: 'EXCEPTION(OTHERS) : Tax Code : ' || sqlerrm);
2560: app_exception.raise_exception;
2561: END;
2562:
2563: --tax_info_rec.amount_includes_tax_flag := 'N';
2564: end if;

Line 2581: app_exception.raise_exception;

2577: when others then
2578: IF (g_level_statement >= g_current_runtime_level) THEN
2579: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Exception while expanding Latin Tax Group');
2580: END IF;
2581: app_exception.raise_exception;
2582: End;
2583:
2584: end if;
2585:

Line 2591: app_exception.raise_exception;

2587: WHEN OTHERS THEN
2588: IF (g_level_statement >= g_current_runtime_level) THEN
2589: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','IN WHEN OTHERS OF CREATE_TAX_INFO_REC_TBL');
2590: END IF;
2591: app_exception.raise_exception;
2592: END;
2593:
2594: --
2595: --

Line 2681: app_exception.raise_exception;

2677:
2678: if tax_info_rec.tax_vendor_return_code in (TAX_RC_OERR,TAX_RC_NO_RATE,
2679: TAX_RC_SYSERR) then
2680: dump_tax_info_rec('E');
2681: app_exception.raise_exception;
2682:
2683: end if;
2684: dump_tax_info_rec('O');
2685:

Line 2946: | app_exception.raise_exception when an exception is found along with |

2942: | |
2943: | RETURNS |
2944: | tax_info_rec updated with tax rate, amount, vendor and other info. |
2945: | exceptions |
2946: | app_exception.raise_exception when an exception is found along with |
2947: | the error message. |
2948: | |
2949: | CALLED FROM |
2950: | process_tax_rec_f_sql_lte |

Line 3065: app_exception.raise_exception;

3061: --
3062: IF ( tax_info_rec.extended_amount IS NULL AND
3063: nvl(tax_info_rec.trx_line_type, 'LINE') <> 'ADJ' ) THEN
3064: fnd_message.set_name('AR', 'AR_TAX_NO_AMOUNT');
3065: app_exception.raise_exception;
3066: END IF;
3067:
3068: --
3069: -- Check that the precision field has a value

Line 3073: app_exception.raise_exception;

3069: -- Check that the precision field has a value
3070: --
3071: IF ( tax_info_rec.precision IS NULL ) THEN
3072: fnd_message.set_name('AR', 'AR_TAX_NO_PRECISION');
3073: app_exception.raise_exception;
3074: END IF;
3075:
3076: -- Copy the tax rate passed
3077: pg_tax_rate_passed := tax_info_rec.tax_rate;

Line 3170: app_exception.raise_exception;

3166: -- and raise exception.
3167: --
3168: IF tax_info_rec.tax_code IS NULL THEN
3169: fnd_message.set_name('AR', 'AR_TAX_NO_CODE');
3170: app_exception.raise_exception;
3171:
3172: END IF;
3173:
3174: /*------------------------------------------------------------------------*

Line 3245: app_exception.raise_exception;

3241: -- Raise error
3242: fnd_message.set_name('AR','AR_TAX_RATE_INVALID');
3243: fnd_message.set_token('TAX_CODE', tax_info_rec.tax_code);
3244: fnd_message.set_token('TRX_DATE', tax_info_rec.trx_date );
3245: app_exception.raise_exception;
3246: END IF;
3247:
3248: ELSE -- Adhoc Tax Code
3249: l_use_tax_rate_passed := TRUE; -- Use the tax rate passed.

Line 3363: app_exception.raise_exception;

3359: SQLCODE||';'||SQLERRM);
3360: IF (g_level_unexpected >= g_current_runtime_level) THEN
3361: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Latin Tax Engine raised error: '||SQLCODE||';'||SQLERRM);
3362: END IF;
3363: app_exception.raise_exception;
3364: END;
3365: END IF;
3366:
3367:

Line 3371: app_exception.raise_exception;

3367:
3368: IF l_tax_vendor_return_code in ( TAX_RC_OERR, TAX_RC_SYSERR,TAX_RC_NO_RATE ) THEN
3369: /* There should be a message on the message stack already */
3370: /* Raise a hard error */
3371: app_exception.raise_exception;
3372: END IF;
3373:
3374: /* Bug 636254: Once the vendor has had a chance to calculate the
3375: tax amount, if the tax amount is still NULL, then go and

Line 3493: app_exception.raise_exception;

3489: --
3490: IF ( tax_info_rec.tax_control = 'E' ) THEN
3491:
3492: fnd_message.set_name('AR','AR_TAX_NO_RATE');
3493: app_exception.raise_exception;
3494:
3495: END IF; -- Tax control is Exempt?
3496: END;
3497:

Line 3526: app_exception.raise_exception;

3522: SQLCODE||';'||SQLERRM);
3523: IF (g_level_unexpected >= g_current_runtime_level) THEN
3524: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Latin Tax Engine raised error: '||SQLCODE||';'||SQLERRM);
3525: END IF;
3526: app_exception.raise_exception;
3527: END;
3528: END IF;
3529:
3530: --

Line 3649: app_exception.raise_exception;

3645:
3646: IF l_tax_vendor_return_code in ( TAX_RC_OERR, TAX_RC_SYSERR, TAX_RC_NO_RATE ) THEN
3647: /* There should be a message on the message stack already */
3648: /* Raise a hard error */
3649: app_exception.raise_exception;
3650: END IF;
3651:
3652:
3653: END IF; -- Vendor not installed?

Line 3853: app_exception.raise_exception;

3849: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.receivables_trx_type_id(p_index) IS NULL THEN
3850: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3851: fnd_message.set_token('GENERIC_TEXT',
3852: 'Required Parameter Missing: Transaction Type Id');
3853: app_exception.raise_exception;
3854: END IF;
3855:
3856: -- Fetch Customer Trx_Type_Id and Tax Calculation Flag
3857: -- If Tax Calculation Flag is unchecked then return.

Line 3877: app_exception.raise_exception;

3873: WHEN NO_DATA_FOUND THEN
3874: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3875: fnd_message.set_token('GENERIC_TEXT',
3876: 'EXCEPTION(NO_DATA_FOUND) : Customer Trx Type Id');
3877: app_exception.raise_exception;
3878:
3879: WHEN OTHERS THEN
3880: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3881: fnd_message.set_token('GENERIC_TEXT',

Line 3883: app_exception.raise_exception;

3879: WHEN OTHERS THEN
3880: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3881: fnd_message.set_token('GENERIC_TEXT',
3882: 'EXCEPTION(OTHERS) : Customer Trx Type Id : ' || sqlerrm);
3883: app_exception.raise_exception;
3884: END;
3885:
3886: IF (NVL(l_tax_calculation_flag,'N') <> 'Y') THEN
3887: IF (g_level_statement >= g_current_runtime_level) THEN

Line 3945: app_exception.raise_exception;

3941: END IF;
3942: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3943: fnd_message.set_token('GENERIC_TEXT',
3944: 'EXCEPTION(NO_DATA_FOUND) : Organization Class');
3945: app_exception.raise_exception;
3946: WHEN OTHERS THEN
3947: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3948: fnd_message.set_token('GENERIC_TEXT',
3949: 'EXCEPTION(OTHERS) : Organization Class : ' || sqlcode||' , '||sqlerrm);

Line 3950: app_exception.raise_exception;

3946: WHEN OTHERS THEN
3947: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3948: fnd_message.set_token('GENERIC_TEXT',
3949: 'EXCEPTION(OTHERS) : Organization Class : ' || sqlcode||' , '||sqlerrm);
3950: app_exception.raise_exception;
3951: END;
3952: tax_info_rec.usern4 := l_location_id;
3953: tax_info_rec.userf10 := l_org_class;
3954:

Line 4008: app_exception.raise_exception;

4004: WHEN NO_DATA_FOUND THEN
4005: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4006: fnd_message.set_token('GENERIC_TEXT',
4007: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
4008: app_exception.raise_exception;
4009: WHEN OTHERS THEN
4010: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4011: fnd_message.set_token('GENERIC_TEXT',
4012: 'EXCEPTION(OTHERS) : Tax Code : ' || sqlerrm);

Line 4013: app_exception.raise_exception;

4009: WHEN OTHERS THEN
4010: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4011: fnd_message.set_token('GENERIC_TEXT',
4012: 'EXCEPTION(OTHERS) : Tax Code : ' || sqlerrm);
4013: app_exception.raise_exception;
4014: END;
4015: -- Bug 4028732 comment out END IF;
4016:
4017: END IF; -- bug 6824850