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.ZX_PRODUCT_INTEGRATION_PKG dependencies on APP_EXCEPTION

Line 928: APP_EXCEPTION.raise_exception;

924: IF (g_level_statement >= g_current_runtime_level) THEN
925: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','EXCEPTION: NO_DATA_FOUND IN SYSTEM PARAMETERS ' );
926: END IF;
927: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_SYSTEM_PARAMETERS');
928: APP_EXCEPTION.raise_exception;
929: RAISE;
930: end;
931:
932:

Line 975: APP_EXCEPTION.raise_exception;

971: IF (g_level_statement >= g_current_runtime_level) THEN
972: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','EXCEPTION: NO_DATA_FOUND IN SET OF BOOKS ' );
973: END IF;
974: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_GL_SET_OF_BOOKS');
975: APP_EXCEPTION.raise_exception;
976: RAISE;
977: end;
978:
979: -- Test 1 passed therefore currency must not be defined

Line 984: APP_EXCEPTION.raise_exception;

980: IF (g_level_statement >= g_current_runtime_level) THEN
981: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','EXCEPTION: NO_DATA_FOUND IN CURRENCIES ' );
982: END IF;
983: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_FND_CURRENCIES');
984: APP_EXCEPTION.raise_exception;
985: RAISE; --end of WHEN NO DATA FOUND
986: END;
987:
988:

Line 1045: APP_EXCEPTION.raise_exception;

1041: 'Error Getting OE Profile information');
1042: END IF;
1043: -- Bug 2185315 - added fnd_message so error will reflect on the form
1044: FND_MESSAGE.set_name('AR','AR_NO_OM_MASTER_ORG'); -- Bug 3151551
1045: APP_EXCEPTION.raise_exception;
1046: End if;
1047:
1048: profinfo.so_organization_id := l_master_org_id;
1049: --oe_profile.get('SO_ORGANIZATION_ID', profinfo.so_organization_id);

Line 2873: app_exception.raise_exception;

2869: WHEN NO_DATA_FOUND THEN
2870: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
2871: fnd_message.set_token('GENERIC_TEXT',
2872: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
2873: app_exception.raise_exception;
2874: WHEN OTHERS THEN
2875: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
2876: fnd_message.set_token('GENERIC_TEXT',
2877: 'EXCEPTION(OTHERS) : Tax Code : ' || sqlerrm);

Line 2878: app_exception.raise_exception;

2874: WHEN OTHERS THEN
2875: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
2876: fnd_message.set_token('GENERIC_TEXT',
2877: 'EXCEPTION(OTHERS) : Tax Code : ' || sqlerrm);
2878: app_exception.raise_exception;
2879: END;
2880:
2881: --tax_info_rec.amount_includes_tax_flag := 'N';
2882: END IF;

Line 2899: app_exception.raise_exception;

2895: when others then
2896: IF (g_level_statement >= g_current_runtime_level) THEN
2897: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Exception while expanding Latin Tax Group');
2898: END IF;
2899: app_exception.raise_exception;
2900: End;
2901:
2902: end if;
2903:

Line 2909: app_exception.raise_exception;

2905: WHEN OTHERS THEN
2906: IF (g_level_statement >= g_current_runtime_level) THEN
2907: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','IN WHEN OTHERS OF CREATE_TAX_INFO_REC_TBL');
2908: END IF;
2909: app_exception.raise_exception;
2910: END;
2911:
2912: --
2913: --

Line 2999: app_exception.raise_exception;

2995:
2996: if tax_info_rec.tax_vendor_return_code in (TAX_RC_OERR,TAX_RC_NO_RATE,
2997: TAX_RC_SYSERR) then
2998: dump_tax_info_rec('E');
2999: app_exception.raise_exception;
3000:
3001: end if;
3002: dump_tax_info_rec('O');
3003:

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

3260: | |
3261: | RETURNS |
3262: | tax_info_rec updated with tax rate, amount, vendor and other info. |
3263: | exceptions |
3264: | app_exception.raise_exception when an exception is found along with |
3265: | the error message. |
3266: | |
3267: | CALLED FROM |
3268: | process_tax_rec_f_sql_lte |

Line 3383: app_exception.raise_exception;

3379: --
3380: IF ( tax_info_rec.extended_amount IS NULL AND
3381: nvl(tax_info_rec.trx_line_type, 'LINE') <> 'ADJ' ) THEN
3382: fnd_message.set_name('AR', 'AR_TAX_NO_AMOUNT');
3383: app_exception.raise_exception;
3384: END IF;
3385:
3386: --
3387: -- Check that the precision field has a value

Line 3391: app_exception.raise_exception;

3387: -- Check that the precision field has a value
3388: --
3389: IF ( tax_info_rec.precision IS NULL ) THEN
3390: fnd_message.set_name('AR', 'AR_TAX_NO_PRECISION');
3391: app_exception.raise_exception;
3392: END IF;
3393:
3394: -- Copy the tax rate passed
3395: pg_tax_rate_passed := tax_info_rec.tax_rate;

Line 3489: app_exception.raise_exception;

3485: --
3486: IF tax_info_rec.tax_code IS NULL THEN
3487: fnd_message.set_name('AR', 'AR_TAX_NO_CODE');
3488: JL_ZZ_TAX_INTEGRATION_PKG.g_jl_exception_type := 'E';
3489: app_exception.raise_exception;
3490: END IF;
3491:
3492: /*------------------------------------------------------------------------*
3493: | Bugfix : 370265, 370068. |

Line 3564: app_exception.raise_exception;

3560: fnd_message.set_name('AR','AR_TAX_RATE_INVALID');
3561: fnd_message.set_token('TAX_CODE', tax_info_rec.tax_code);
3562: fnd_message.set_token('TRX_DATE', tax_info_rec.trx_date );
3563: JL_ZZ_TAX_INTEGRATION_PKG.g_jl_exception_type := 'E';
3564: app_exception.raise_exception;
3565: END IF;
3566:
3567: ELSE -- Adhoc Tax Code
3568: l_use_tax_rate_passed := TRUE; -- Use the tax rate passed.

Line 3684: app_exception.raise_exception;

3680: SQLCODE||';'||SQLERRM);
3681: IF (g_level_unexpected >= g_current_runtime_level) THEN
3682: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Latin Tax Engine raised error: '||SQLCODE||';'||SQLERRM);
3683: END IF;
3684: app_exception.raise_exception;
3685: END;
3686: END IF;
3687:
3688:

Line 3692: app_exception.raise_exception;

3688:
3689: IF l_tax_vendor_return_code in ( TAX_RC_OERR, TAX_RC_SYSERR,TAX_RC_NO_RATE ) THEN
3690: /* There should be a message on the message stack already */
3691: /* Raise a hard error */
3692: app_exception.raise_exception;
3693: END IF;
3694:
3695: /* Bug 636254: Once the vendor has had a chance to calculate the
3696: tax amount, if the tax amount is still NULL, then go and

Line 3815: app_exception.raise_exception;

3811: IF ( tax_info_rec.tax_control = 'E' ) THEN
3812:
3813: fnd_message.set_name('AR','AR_TAX_NO_RATE');
3814: JL_ZZ_TAX_INTEGRATION_PKG.g_jl_exception_type := 'E';
3815: app_exception.raise_exception;
3816:
3817: END IF; -- Tax control is Exempt?
3818: END;
3819:

Line 3848: app_exception.raise_exception;

3844: SQLCODE||';'||SQLERRM);
3845: IF (g_level_unexpected >= g_current_runtime_level) THEN
3846: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Latin Tax Engine raised error: '||SQLCODE||';'||SQLERRM);
3847: END IF;
3848: app_exception.raise_exception;
3849: END;
3850: END IF;
3851:
3852: --

Line 3971: app_exception.raise_exception;

3967:
3968: IF l_tax_vendor_return_code in ( TAX_RC_OERR, TAX_RC_SYSERR, TAX_RC_NO_RATE ) THEN
3969: /* There should be a message on the message stack already */
3970: /* Raise a hard error */
3971: app_exception.raise_exception;
3972: END IF;
3973:
3974:
3975: END IF; -- Vendor not installed?

Line 4184: app_exception.raise_exception;

4180: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4181: fnd_message.set_token('GENERIC_TEXT',
4182: 'Required Parameter Missing: Transaction Type Id');
4183: JL_ZZ_TAX_INTEGRATION_PKG.g_jl_exception_type := 'E';
4184: app_exception.raise_exception;
4185: END IF;
4186:
4187: -- Fetch Customer Trx_Type_Id and Tax Calculation Flag
4188: -- If Tax Calculation Flag is unchecked then return.

Line 4208: app_exception.raise_exception;

4204: WHEN NO_DATA_FOUND THEN
4205: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4206: fnd_message.set_token('GENERIC_TEXT',
4207: 'EXCEPTION(NO_DATA_FOUND) : Customer Trx Type Id');
4208: app_exception.raise_exception;
4209: WHEN OTHERS THEN
4210: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4211: fnd_message.set_token('GENERIC_TEXT',
4212: 'EXCEPTION(OTHERS) : Customer Trx Type Id : ' || sqlerrm);

Line 4213: app_exception.raise_exception;

4209: WHEN OTHERS THEN
4210: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4211: fnd_message.set_token('GENERIC_TEXT',
4212: 'EXCEPTION(OTHERS) : Customer Trx Type Id : ' || sqlerrm);
4213: app_exception.raise_exception;
4214: END;
4215:
4216: -- Start : Added by ssohal for Bug#8611167
4217: -- In case of CM, Copy the Output TCC, PFC, PC and TBC from Adjusted Invoice

Line 4257: app_exception.raise_exception;

4253: WHEN NO_DATA_FOUND THEN
4254: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4255: fnd_message.set_token('GENERIC_TEXT',
4256: 'EXCEPTION(NO_DATA_FOUND) : No Record found for Adjusted Doc.');
4257: app_exception.raise_exception;
4258: WHEN OTHERS THEN
4259: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4260: fnd_message.set_token('GENERIC_TEXT',
4261: 'EXCEPTION(OTHERS) : Record for Adjusted Doc : ' || sqlerrm);

Line 4262: app_exception.raise_exception;

4258: WHEN OTHERS THEN
4259: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4260: fnd_message.set_token('GENERIC_TEXT',
4261: 'EXCEPTION(OTHERS) : Record for Adjusted Doc : ' || sqlerrm);
4262: app_exception.raise_exception;
4263: END;
4264: END IF;
4265: -- End : Added by ssohal for Bug#8611167
4266:

Line 4322: app_exception.raise_exception;

4318: END IF;
4319: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4320: fnd_message.set_token('GENERIC_TEXT',
4321: 'EXCEPTION(NO_DATA_FOUND) : Organization Class');
4322: app_exception.raise_exception;
4323: WHEN OTHERS THEN
4324: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4325: fnd_message.set_token('GENERIC_TEXT',
4326: 'EXCEPTION(OTHERS) : Organization Class : ' || sqlcode||' , '||sqlerrm);

Line 4327: app_exception.raise_exception;

4323: WHEN OTHERS THEN
4324: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4325: fnd_message.set_token('GENERIC_TEXT',
4326: 'EXCEPTION(OTHERS) : Organization Class : ' || sqlcode||' , '||sqlerrm);
4327: app_exception.raise_exception;
4328: END;
4329: */
4330: -- Start : Code added for Bug#8260273 by ssohal
4331: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_org_id(p_index) IS NOT NULL THEN

Line 4358: app_exception.raise_exception;

4354: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id(p_index));
4355: END IF;
4356: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4357: fnd_message.set_token('GENERIC_TEXT','EXCEPTION(NO_DATA_FOUND) : Organization Class');
4358: app_exception.raise_exception;
4359: ELSE
4360: CLOSE get_org_class;
4361: END IF;
4362: END IF;

Line 4424: app_exception.raise_exception;

4420: WHEN NO_DATA_FOUND THEN
4421: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4422: fnd_message.set_token('GENERIC_TEXT',
4423: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
4424: app_exception.raise_exception;
4425: WHEN OTHERS THEN
4426: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4427: fnd_message.set_token('GENERIC_TEXT',
4428: 'EXCEPTION(OTHERS) : Tax Code : ' || sqlerrm);

Line 4429: app_exception.raise_exception;

4425: WHEN OTHERS THEN
4426: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4427: fnd_message.set_token('GENERIC_TEXT',
4428: 'EXCEPTION(OTHERS) : Tax Code : ' || sqlerrm);
4429: app_exception.raise_exception;
4430: END;
4431: -- Bug 4028732 comment out END IF;
4432:
4433: END IF; -- bug 6824850