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_TCM_CONTROL_PKG dependencies on FND_API

Line 291: P_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

287: l_log_msg := 'B: p_fsc_rec.classification_category='|| p_fsc_rec.classification_category;
288: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
289: END IF;
290: --Bug fix 4774215 Case 1.Return Status must be initialized.
291: P_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
292: --End of Bug fix 4774215 Case 1.
293: -- arp_util_tax.debug('classification_type = ' || p_fsc_rec.classification_type);
294: -- arp_util_tax.debug('regime_code = ' || p_fsc_rec.tax_regime_code);
295:

Line 331: --p_return_status:=FND_API.G_RET_STS_ERROR;

327: END IF;
328: END IF; -- check inventory installed
329:
330: IF zx_global_Structures_pkg.g_inventory_installed_flag = 'N' THEN
331: --p_return_status:=FND_API.G_RET_STS_ERROR;
332: --p_error_buffer:='Inventory is not enabled';
333: fnd_message.set_name('ZX','ZX_INV_NOT_ENABLED');
334: p_fsc_rec.fsc_code:= null;
335:

Line 344: RAISE FND_API.G_EXC_ERROR;

340: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
341: END IF;
342:
343: --return;
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
346:
347: OPEN c_regime_assoc;
348: FETCH c_regime_assoc INTO l_reg_fscType_flag;

Line 374: p_return_status:= FND_API.G_RET_STS_SUCCESS;

370: l_log_msg);
371: END IF;
372:
373: IF c_parent_regime_assoc%NOTFOUND THEN
374: p_return_status:= FND_API.G_RET_STS_SUCCESS;
375: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
376: CLOSE c_parent_regime_assoc;
377:
378: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 375: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;

371: END IF;
372:
373: IF c_parent_regime_assoc%NOTFOUND THEN
374: p_return_status:= FND_API.G_RET_STS_SUCCESS;
375: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
376: CLOSE c_parent_regime_assoc;
377:
378: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
379: l_log_msg := 'Regime for the given Fiscal Type is not valid ';

Line 384: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

380: FND_LOG.STRING(G_LEVEL_STATEMENT,
381: G_MODULE_NAME || l_procedure_name,
382: l_log_msg);
383: END IF;
384: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
385: RETURN;
386: END IF;
387: ELSE
388: CLOSE c_regime_assoc;

Line 404: p_return_status:= FND_API.G_RET_STS_SUCCESS;

400: l_log_msg);
401: END IF;
402:
403: IF c_inventory_set%NOTFOUND THEN
404: p_return_status:= FND_API.G_RET_STS_SUCCESS;
405: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
406: --p_error_buffer:='Fiscal Type Code does not exits';
407: --fnd_message.set_name('ZX','ZX_FC_TYPE_NOT_EXIST');
408: CLOSE c_inventory_set;

Line 405: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;

401: END IF;
402:
403: IF c_inventory_set%NOTFOUND THEN
404: p_return_status:= FND_API.G_RET_STS_SUCCESS;
405: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
406: --p_error_buffer:='Fiscal Type Code does not exits';
407: --fnd_message.set_name('ZX','ZX_FC_TYPE_NOT_EXIST');
408: CLOSE c_inventory_set;
409: --return;

Line 417: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

413: G_MODULE_NAME || l_procedure_name,
414: l_log_msg);
415: END IF;
416: RETURN;
417: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
418: ELSE
419: CLOSE c_inventory_set;
420: END IF;
421:

Line 423: p_return_status:= FND_API.G_RET_STS_SUCCESS;

419: CLOSE c_inventory_set;
420: END IF;
421:
422: IF l_category_set_id IS NULL THEN
423: p_return_status:= FND_API.G_RET_STS_SUCCESS;
424: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
425: --p_error_buffer:='Foreign Key broken:Fiscal Type Code does not have Inventory Category Set associated';
426:
427: -- Logging Infra: YK: 3/5: Error l_category_set_id is null

Line 424: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;

420: END IF;
421:
422: IF l_category_set_id IS NULL THEN
423: p_return_status:= FND_API.G_RET_STS_SUCCESS;
424: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
425: --p_error_buffer:='Foreign Key broken:Fiscal Type Code does not have Inventory Category Set associated';
426:
427: -- Logging Infra: YK: 3/5: Error l_category_set_id is null
428: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 435: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

431: G_MODULE_NAME || l_procedure_name,
432: l_log_msg);
433: END IF;
434: RETURN;
435: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
436: END IF;
437:
438: OPEN c_inventory_structure;
439: FETCH c_inventory_structure INTO l_structure_id;

Line 442: p_return_status:= FND_API.G_RET_STS_SUCCESS; -- bugfix 9783153

438: OPEN c_inventory_structure;
439: FETCH c_inventory_structure INTO l_structure_id;
440:
441: IF c_inventory_structure%NOTFOUND THEN
442: p_return_status:= FND_API.G_RET_STS_SUCCESS; -- bugfix 9783153
443: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
444: --p_error_buffer:='Foreign Key broken: Inventory Structure ID not found';
445: CLOSE c_inventory_structure;
446:

Line 443: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;

439: FETCH c_inventory_structure INTO l_structure_id;
440:
441: IF c_inventory_structure%NOTFOUND THEN
442: p_return_status:= FND_API.G_RET_STS_SUCCESS; -- bugfix 9783153
443: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
444: --p_error_buffer:='Foreign Key broken: Inventory Structure ID not found';
445: CLOSE c_inventory_structure;
446:
447: -- Logging Infra: YK: 3/5: c_inventory_structure notfound

Line 455: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

451: G_MODULE_NAME || l_procedure_name,
452: l_log_msg);
453: END IF;
454: RETURN;
455: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
456: ELSE
457: CLOSE c_inventory_structure;
458: END IF;
459:

Line 477: p_return_status:= FND_API.G_RET_STS_SUCCESS;

473:
474: IF c_category%NOTFOUND THEN
475: --p_error_buffer:= 'Fiscal Classification Code does not have an equivalent Item Category Code';
476: fnd_message.set_name('ZX','ZX_ITEM_CAT_NOT_EXIST');
477: p_return_status:= FND_API.G_RET_STS_SUCCESS;
478: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
479: CLOSE c_category;
480: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
481: l_log_msg := 'S: CUR: c_category: notfound';

Line 478: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;

474: IF c_category%NOTFOUND THEN
475: --p_error_buffer:= 'Fiscal Classification Code does not have an equivalent Item Category Code';
476: fnd_message.set_name('ZX','ZX_ITEM_CAT_NOT_EXIST');
477: p_return_status:= FND_API.G_RET_STS_SUCCESS;
478: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
479: CLOSE c_category;
480: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
481: l_log_msg := 'S: CUR: c_category: notfound';
482: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 487: --RAISE FND_API.G_EXC_ERROR;

483: G_MODULE_NAME || l_procedure_name,
484: l_log_msg);
485: END IF;
486: RETURN;
487: --RAISE FND_API.G_EXC_ERROR;
488: ELSE
489: CLOSE c_category;
490: END IF;
491:

Line 503: p_return_status:= FND_API.G_RET_STS_SUCCESS;

499: FETCH c_item_category_child INTO l_allocated_flag;
500:
501: IF c_item_category_child%NOTFOUND THEN
502: fnd_message.set_name('ZX','ZX_FC_NOT_ALLOC_ENTITY_ID');
503: p_return_status:= FND_API.G_RET_STS_SUCCESS;
504: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
505: CLOSE c_item_category_child;
506: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
507: l_log_msg := 'S: CUR: c_item_category: notfound: category_set_id='|| l_category_set_id ||

Line 504: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;

500:
501: IF c_item_category_child%NOTFOUND THEN
502: fnd_message.set_name('ZX','ZX_FC_NOT_ALLOC_ENTITY_ID');
503: p_return_status:= FND_API.G_RET_STS_SUCCESS;
504: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
505: CLOSE c_item_category_child;
506: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
507: l_log_msg := 'S: CUR: c_item_category: notfound: category_set_id='|| l_category_set_id ||
508: ', category_id='|| l_category_id ||

Line 515: --RAISE FND_API.G_EXC_ERROR;

511: G_MODULE_NAME || l_procedure_name,
512: l_log_msg);
513: END IF;
514: RETURN;
515: --RAISE FND_API.G_EXC_ERROR;
516: ELSE
517: p_fsc_rec.fsc_code:= p_fsc_rec.condition_value;
518: CLOSE c_item_category_child;
519: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 536: --p_return_status:=FND_API.G_RET_STS_SUCCESS;

532: FND_LOG.STRING(G_LEVEL_STATEMENT,
533: G_MODULE_NAME || l_procedure_name,
534: l_log_msg);
535: END IF;
536: --p_return_status:=FND_API.G_RET_STS_SUCCESS;
537: --p_error_buffer:='Fiscal Code is allocated to the Entity ID';
538: p_fsc_rec.fsc_code:= p_fsc_rec.condition_value;
539: CLOSE c_item_category;
540: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 590: p_return_status:=FND_API.G_RET_STS_SUCCESS;

586: l_log_msg);
587: END IF;
588:
589: if c_parent_regime_assoc%notfound then
590: p_return_status:=FND_API.G_RET_STS_SUCCESS;
591: --p_error_buffer:='Regime for the given Fiscal Type is not valid ';
592: fnd_message.set_name('ZX','ZX_REGIME_NOT_VALID');
593: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
594: close c_parent_regime_assoc;

Line 593: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;

589: if c_parent_regime_assoc%notfound then
590: p_return_status:=FND_API.G_RET_STS_SUCCESS;
591: --p_error_buffer:='Regime for the given Fiscal Type is not valid ';
592: fnd_message.set_name('ZX','ZX_REGIME_NOT_VALID');
593: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
594: close c_parent_regime_assoc;
595: --return;
596: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
597: l_log_msg :='B: CUR: c_parent_regime_assoc: notfound';

Line 602: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

598: FND_LOG.STRING(G_LEVEL_STATEMENT,
599: G_MODULE_NAME || l_procedure_name,
600: l_log_msg);
601: END IF;
602: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603: return;
604: end if;
605: else
606: close c_regime_assoc;

Line 622: p_return_status:=FND_API.G_RET_STS_SUCCESS;

618: l_log_msg);
619: END IF;
620:
621: if c_tca_class_category%notfound then
622: p_return_status:=FND_API.G_RET_STS_SUCCESS;
623: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
624: --p_error_buffer:='Fiscal Type Code does not exits';
625: --fnd_message.set_name('ZX','ZX_FC_TYPE_NOT_EXIST');
626: close c_tca_class_category;

Line 623: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;

619: END IF;
620:
621: if c_tca_class_category%notfound then
622: p_return_status:=FND_API.G_RET_STS_SUCCESS;
623: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
624: --p_error_buffer:='Fiscal Type Code does not exits';
625: --fnd_message.set_name('ZX','ZX_FC_TYPE_NOT_EXIST');
626: close c_tca_class_category;
627: --return;

Line 634: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

630: FND_LOG.STRING(G_LEVEL_STATEMENT,
631: G_MODULE_NAME || l_procedure_name,
632: l_log_msg);
633: END IF;
634: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: return;
636: else
637: close c_tca_class_category;
638: end if;

Line 641: p_return_status:=FND_API.G_RET_STS_SUCCESS;

637: close c_tca_class_category;
638: end if;
639:
640: if l_tca_class_category_code is null then
641: p_return_status:=FND_API.G_RET_STS_SUCCESS;
642: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
643: --p_error_buffer:='Foreign Key broken:Fiscal Type Code does not have Class Category associated';
644: --fnd_message.set_name('ZX','ZX_FC_INV_CAT_NOT_EXIST');
645: -- Logging Infra: YK: 3/5: Error l_tca_class_category_code is null

Line 642: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;

638: end if;
639:
640: if l_tca_class_category_code is null then
641: p_return_status:=FND_API.G_RET_STS_SUCCESS;
642: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
643: --p_error_buffer:='Foreign Key broken:Fiscal Type Code does not have Class Category associated';
644: --fnd_message.set_name('ZX','ZX_FC_INV_CAT_NOT_EXIST');
645: -- Logging Infra: YK: 3/5: Error l_tca_class_category_code is null
646: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 654: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

650: G_MODULE_NAME || l_procedure_name,
651: l_log_msg);
652: END IF;
653: return;
654: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
655: end if;
656:
657: -- 3:
658: --Bug 5373773

Line 683: --p_return_status:=FND_API.G_RET_STS_ERROR;

679: l_log_msg);
680: END IF;
681:
682: if c_party_tax_profile_id%notfound then
683: --p_return_status:=FND_API.G_RET_STS_ERROR;
684: --p_error_buffer:='Party Tax Profile ID not found';
685: fnd_message.set_name('ZX','ZX_PTP_ID_NOT_EXIST');
686: p_fsc_rec.fsc_code:= null;
687: close c_party_tax_profile_id;

Line 689: RAISE FND_API.G_EXC_ERROR;

685: fnd_message.set_name('ZX','ZX_PTP_ID_NOT_EXIST');
686: p_fsc_rec.fsc_code:= null;
687: close c_party_tax_profile_id;
688: --return;
689: RAISE FND_API.G_EXC_ERROR;
690: else
691: close c_party_tax_profile_id;
692: end if;
693: END IF; -- 5373773 lxzhang

Line 708: p_fsc_rec.fsc_code := FND_API.G_MISS_CHAR;

704: l_log_msg);
705: END IF;
706:
707: if c_class_code%notfound then
708: p_fsc_rec.fsc_code := FND_API.G_MISS_CHAR;
709: p_return_status:=FND_API.G_RET_STS_SUCCESS;
710: --p_error_buffer:='Parameter value does not have a corresponding Fiscal Code';
711: fnd_message.set_name('ZX','ZX_FC_CODE_PARAM_NOT_EXIST');
712: close c_class_code;

Line 709: p_return_status:=FND_API.G_RET_STS_SUCCESS;

705: END IF;
706:
707: if c_class_code%notfound then
708: p_fsc_rec.fsc_code := FND_API.G_MISS_CHAR;
709: p_return_status:=FND_API.G_RET_STS_SUCCESS;
710: --p_error_buffer:='Parameter value does not have a corresponding Fiscal Code';
711: fnd_message.set_name('ZX','ZX_FC_CODE_PARAM_NOT_EXIST');
712: close c_class_code;
713: return;

Line 714: --RAISE FND_API.G_EXC_ERROR;

710: --p_error_buffer:='Parameter value does not have a corresponding Fiscal Code';
711: fnd_message.set_name('ZX','ZX_FC_CODE_PARAM_NOT_EXIST');
712: close c_class_code;
713: return;
714: --RAISE FND_API.G_EXC_ERROR;
715: else
716: close c_class_code;
717: end if;
718:

Line 764: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;

760:
761: end if;
762:
763: if l_c_party_category_not_found = 'Y' then
764: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
765: p_fsc_rec.effective_from := null;
766: p_fsc_rec.effective_to := null;
767: else
768: p_fsc_rec.fsc_code:= p_fsc_rec.condition_value;

Line 783: p_fsc_rec.fsc_code := FND_API.G_MISS_CHAR;

779: Open c_pty_fc_assgn_exists;
780: fetch c_pty_fc_assgn_exists into l_allocated_flag;
781:
782: IF c_pty_fc_assgn_exists%NOTFOUND THEN
783: p_fsc_rec.fsc_code := FND_API.G_MISS_CHAR;
784: -- Logging Infra: YK: 3/5: c_party_category notfound
785: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
786: l_log_msg := 'S: c_pty_fc_assgn_exists: notfound: class_category=' || l_tca_class_category_code||
787: ', class_code='|| l_class_code ||

Line 929: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;

925:
926: end if;
927:
928: if l_c_party_category_not_found = 'Y' then
929: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
930: p_fsc_rec.effective_from := null;
931: p_fsc_rec.effective_to := null;
932: else
933: p_fsc_rec.fsc_code:= p_fsc_rec.condition_value;

Line 978: p_fsc_rec.fsc_code := FND_API.G_MISS_CHAR;

974: l_table_id := l_ptp_id;
975: Open c_pty_fc_assgn_exists;
976: fetch c_pty_fc_assgn_exists into l_allocated_flag;
977: IF c_pty_fc_assgn_exists%NOTFOUND THEN
978: p_fsc_rec.fsc_code := FND_API.G_MISS_CHAR;
979: -- Logging Infra: YK: 3/4: c_party_category notfound
980: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
981: l_log_msg := 'S: CUR: c_party_category: notfound: class_category=' || l_tca_class_category_code||
982: ', class_code='|| l_class_code ||

Line 1042: p_return_status:=FND_API.G_RET_STS_SUCCESS;

1038: FND_LOG.STRING(G_LEVEL_STATEMENT,
1039: G_MODULE_NAME || l_procedure_name,
1040: l_log_msg);
1041: END IF;
1042: p_return_status:=FND_API.G_RET_STS_SUCCESS;
1043: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
1044: RETURN;
1045: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1046: else

Line 1043: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;

1039: G_MODULE_NAME || l_procedure_name,
1040: l_log_msg);
1041: END IF;
1042: p_return_status:=FND_API.G_RET_STS_SUCCESS;
1043: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
1044: RETURN;
1045: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1046: else
1047: close c_classification_type_code;

Line 1045: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1041: END IF;
1042: p_return_status:=FND_API.G_RET_STS_SUCCESS;
1043: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
1044: RETURN;
1045: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1046: else
1047: close c_classification_type_code;
1048: end if;
1049:

Line 1086: p_return_status:=FND_API.G_RET_STS_SUCCESS;

1082: FND_LOG.STRING(G_LEVEL_STATEMENT,
1083: G_MODULE_NAME || l_procedure_name,
1084: l_log_msg);
1085: END IF;
1086: p_return_status:=FND_API.G_RET_STS_SUCCESS;
1087: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
1088: return;
1089: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1090: end if;

Line 1087: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;

1083: G_MODULE_NAME || l_procedure_name,
1084: l_log_msg);
1085: END IF;
1086: p_return_status:=FND_API.G_RET_STS_SUCCESS;
1087: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
1088: return;
1089: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1090: end if;
1091: else

Line 1089: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1085: END IF;
1086: p_return_status:=FND_API.G_RET_STS_SUCCESS;
1087: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
1088: return;
1089: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1090: end if;
1091: else
1092: close c_regime_assoc;
1093: end if;

Line 1125: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;

1121: l_log_msg);
1122: END IF;
1123:
1124: if c_parent_trxbizcat_fiscalclass%notfound then
1125: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
1126: p_fsc_rec.effective_from := null;
1127: p_fsc_rec.effective_to := null;
1128: -- fnd_message.set_name('ZX','ZX_FC_NOT_ALLOC_ENTITY_ID');
1129: -- RAISE FND_API.G_EXC_ERROR;

Line 1129: -- RAISE FND_API.G_EXC_ERROR;

1125: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
1126: p_fsc_rec.effective_from := null;
1127: p_fsc_rec.effective_to := null;
1128: -- fnd_message.set_name('ZX','ZX_FC_NOT_ALLOC_ENTITY_ID');
1129: -- RAISE FND_API.G_EXC_ERROR;
1130: else
1131: p_fsc_rec.effective_from :=l_effective_from;
1132: p_fsc_rec.effective_to :=l_effective_to;
1133: p_fsc_rec.fsc_code:= p_fsc_rec.condition_value;

Line 1155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1151: G_MODULE_NAME || l_procedure_name,
1152: l_log_msg);
1153: END IF;
1154:
1155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1156: end if;
1157:
1158: -- Logging Infra: YK: 3/5: Put output value here
1159: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1171: p_return_status := FND_API.G_RET_STS_ERROR;

1167: END IF;
1168:
1169: EXCEPTION
1170: WHEN INVALID_CURSOR THEN
1171: p_return_status := FND_API.G_RET_STS_ERROR;
1172: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1173: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1174:
1175: if c_regime_assoc%isopen then close c_regime_assoc; end if;

Line 1195: WHEN FND_API.G_EXC_ERROR THEN

1191: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1192: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
1193: END IF;
1194:
1195: WHEN FND_API.G_EXC_ERROR THEN
1196: p_return_status := FND_API.G_RET_STS_ERROR;
1197: if c_regime_assoc%isopen then close c_regime_assoc; end if;
1198: if c_parent_regime_assoc%isopen then close c_parent_regime_assoc; end if;
1199: if c_inventory_set%isopen then close c_inventory_set; end if;

Line 1196: p_return_status := FND_API.G_RET_STS_ERROR;

1192: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
1193: END IF;
1194:
1195: WHEN FND_API.G_EXC_ERROR THEN
1196: p_return_status := FND_API.G_RET_STS_ERROR;
1197: if c_regime_assoc%isopen then close c_regime_assoc; end if;
1198: if c_parent_regime_assoc%isopen then close c_parent_regime_assoc; end if;
1199: if c_inventory_set%isopen then close c_inventory_set; end if;
1200: if c_inventory_structure%isopen then close c_inventory_structure; end if;

Line 1217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1213: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1214: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
1215: END IF;
1216:
1217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1218: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1219: if c_regime_assoc%isopen then close c_regime_assoc; end if;
1220: if c_parent_regime_assoc%isopen then close c_parent_regime_assoc; end if;
1221: if c_inventory_set%isopen then close c_inventory_set; end if;

Line 1218: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1214: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
1215: END IF;
1216:
1217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1218: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1219: if c_regime_assoc%isopen then close c_regime_assoc; end if;
1220: if c_parent_regime_assoc%isopen then close c_parent_regime_assoc; end if;
1221: if c_inventory_set%isopen then close c_inventory_set; end if;
1222: if c_inventory_structure%isopen then close c_inventory_structure; end if;

Line 1235: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1231: if c_classification_type_code%isopen then close c_classification_type_code; end if;
1232: if c_trxbizcat_fiscalclass%isopen then close c_trxbizcat_fiscalclass; end if;
1233:
1234: WHEN OTHERS THEN
1235: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1236: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1237: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1238:
1239: if c_regime_assoc%isopen then close c_regime_assoc; end if;

Line 1317: p_return_status := FND_API.G_RET_STS_SUCCESS;

1313: END IF;
1314:
1315: -- arp_util_tax.debug('in GET_PROD_TRX_CATE_VALUE');
1316: -- need to hard code return value here
1317: p_return_status := FND_API.G_RET_STS_SUCCESS;
1318:
1319: if p_fsc_cat_rec.classification_category = 'TRX_GENERIC_CLASSIFICATION' or
1320: p_fsc_cat_rec.classification_category = 'PRODUCT_GENERIC_CLASSIFICATION' or
1321: p_fsc_cat_rec.classification_category = 'DOCUMENT'then

Line 1335: --p_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

1331: l_log_msg);
1332: END IF;
1333:
1334: if c_delimiter%notfound then
1335: --p_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1336: --p_error_buffer:='Classification Type does not exist';
1337: --fnd_message.set_name('ZX','ZX_FC_TYPE_NOT_EXIST');
1338: close c_delimiter;
1339:

Line 1350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1346: G_MODULE_NAME || l_procedure_name,
1347: l_log_msg);
1348: END IF;
1349: --return;
1350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1351: else
1352: close c_delimiter;
1353: end if;
1354:

Line 1388: p_return_status:=FND_API.G_RET_STS_SUCCESS;

1384: if c_classification_code%notfound then
1385: p_fsc_cat_rec.condition_value := Null;
1386: p_fsc_cat_rec.effective_from := Null;
1387: p_fsc_cat_rec.effective_to := Null;
1388: p_return_status:=FND_API.G_RET_STS_SUCCESS;
1389: close c_classification_code;
1390:
1391: -- Logging Infra: YK: 3/5: c_classification_code notfound
1392: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1403: RAISE FND_API.G_EXC_ERROR;

1399: G_MODULE_NAME || l_procedure_name,
1400: l_log_msg);
1401: END IF;
1402: --return;
1403: RAISE FND_API.G_EXC_ERROR;
1404:
1405: else
1406: if p_fsc_cat_rec.condition_subclass='1' then
1407: p_fsc_cat_rec.condition_value :=l_segment1;

Line 1425: p_return_status:=FND_API.G_RET_STS_SUCCESS;

1421: end if;
1422:
1423: p_fsc_cat_rec.effective_from :=l_effective_from;
1424: p_fsc_cat_rec.effective_to :=l_effective_to;
1425: p_return_status:=FND_API.G_RET_STS_SUCCESS;
1426: --p_error_buffer:='Classification Code found';
1427: close c_classification_code;
1428:
1429: -- Logging Infra: YK:3/5: Break point for l_delimiter

Line 1447: p_return_status:=FND_API.G_RET_STS_SUCCESS;

1443: -- value is null
1444: p_fsc_cat_rec.condition_value := null;
1445: p_fsc_cat_rec.effective_from := Null;
1446: p_fsc_cat_rec.effective_to := Null;
1447: p_return_status:=FND_API.G_RET_STS_SUCCESS;
1448:
1449: end if;
1450:
1451: else

Line 1452: --p_return_status:=FND_API.G_RET_STS_ERROR;

1448:
1449: end if;
1450:
1451: else
1452: --p_return_status:=FND_API.G_RET_STS_ERROR;
1453: --p_error_buffer:='Classification Category not supported by this procedure';
1454: --fnd_message.set_name('ZX','ZX_FC_CATEG_NOT_SUPPORTED');
1455:
1456: -- Logging Infra: YK: 3/5:

Line 1464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1460: FND_LOG.STRING(G_LEVEL_STATEMENT,
1461: G_MODULE_NAME || l_procedure_name,
1462: l_log_msg);
1463: END IF;
1464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1465:
1466: end if;
1467:
1468: -- Logging Infra: YK: 3/5: Procedure level message

Line 1478: p_return_status := FND_API.G_RET_STS_ERROR;

1474: G_MODULE_NAME || l_procedure_name, l_log_msg);
1475: END IF;
1476: EXCEPTION
1477: WHEN INVALID_CURSOR THEN
1478: p_return_status := FND_API.G_RET_STS_ERROR;
1479: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1480: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1481:
1482: if c_classification_code%isopen then close c_classification_code; end if;

Line 1492: WHEN FND_API.G_EXC_ERROR THEN

1488: G_MODULE_NAME || l_procedure_name,
1489: SQLCODE || ': ' || SQLERRM);
1490: END IF;
1491:
1492: WHEN FND_API.G_EXC_ERROR THEN
1493: p_fsc_cat_rec.condition_value := Null;
1494: p_fsc_cat_rec.effective_from := Null;
1495: p_fsc_cat_rec.effective_to := Null;
1496:

Line 1507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1503: G_MODULE_NAME || l_procedure_name,
1504: SQLCODE || ': ' || SQLERRM);
1505: END IF;
1506:
1507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1508: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1509: p_fsc_cat_rec.condition_value := Null;
1510: p_fsc_cat_rec.effective_from := Null;
1511: p_fsc_cat_rec.effective_to := Null;

Line 1508: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1504: SQLCODE || ': ' || SQLERRM);
1505: END IF;
1506:
1507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1508: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1509: p_fsc_cat_rec.condition_value := Null;
1510: p_fsc_cat_rec.effective_from := Null;
1511: p_fsc_cat_rec.effective_to := Null;
1512:

Line 1517: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1513: if c_classification_code%isopen then close c_classification_code; end if;
1514: if c_delimiter%isopen then close c_delimiter; end if;
1515:
1516: WHEN OTHERS THEN
1517: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1518: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1519: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1520:
1521: if c_classification_code%isopen then close c_classification_code; end if;

Line 1764: x_return_status := FND_API.G_RET_STS_SUCCESS;

1760: -- Logging Infra: Setting up runtime level
1761: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1762:
1763: -- Initialize return status
1764: x_return_status := FND_API.G_RET_STS_SUCCESS;
1765:
1766: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1767: l_log_msg := l_procedure_name||'(+)';
1768: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

Line 1822: x_return_status := FND_API.G_RET_STS_SUCCESS;

1818: p_getone:=1;
1819: -- Bug#5520167- set status to SUCCESS as a record
1820: -- is found in cache structure and not dummy
1821: --
1822: x_return_status := FND_API.G_RET_STS_SUCCESS;
1823:
1824:
1825: IF x_get_registration_rec.tax_jurisdiction_code is NOT NULL then
1826: x_ret_record_level := 'JURISDICTION';

Line 1909: x_return_status := FND_API.G_RET_STS_SUCCESS;

1905: ZX_GLOBAL_STRUCTURES_PKG.g_registration_info_tbl(l_index) := DUMMY_REGISTRATION_REC;
1906:
1907: ELSE
1908: p_getone:=1;
1909: x_return_status := FND_API.G_RET_STS_SUCCESS;
1910:
1911: l_index := DBMS_UTILITY.get_hash_value(to_char(p_ptp_id)||
1912: nvl(x_get_registration_rec.tax_regime_code,c_tax_regime_code_dummy)||
1913: nvl(x_get_registration_rec.tax,c_tax_dummy)||

Line 1943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1939: EXCEPTION
1940: WHEN NO_DATA_FOUND THEN
1941: NULL;
1942: WHEN OTHERS THEN
1943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1944: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1945: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1946:
1947: -- Logging Infra: Statement level

Line 2020: x_return_status := FND_API.G_RET_STS_SUCCESS;

2016: -- Logging Infra: Setting up runtime level
2017: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2018:
2019: -- Initialize return status
2020: x_return_status := FND_API.G_RET_STS_SUCCESS;
2021:
2022: -- Logging Infra: Procedure level
2023: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2024: l_log_msg := l_procedure_name||'(+)';

Line 2069: x_return_status := FND_API.G_RET_STS_SUCCESS;

2065: IF c_supplier_ptp%NOTFOUND THEN
2066: p_getone := 0;
2067: ELSE
2068: p_getone:=1;
2069: x_return_status := FND_API.G_RET_STS_SUCCESS;
2070: -- Pupulate the stucture
2071: x_get_registration_rec.Rounding_Rule_Code := l_ap_tax_rounding_rule;
2072: x_get_registration_rec.process_for_applicability_flag := l_auto_tax_calc_flag;
2073: x_get_registration_rec.tax_classification_code := l_vat_code;

Line 2112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2108: EXCEPTION
2109: WHEN NO_DATA_FOUND THEN
2110: NULL;
2111: WHEN OTHERS THEN
2112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2113: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2114: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2115:
2116: -- Logging Infra: Statement level

Line 2179: x_return_status := FND_API.G_RET_STS_SUCCESS;

2175: -- Logging Infra: Setting up runtime level
2176: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2177:
2178: -- Initialize return status
2179: x_return_status := FND_API.G_RET_STS_SUCCESS;
2180:
2181: -- Logging Infra: Procedure level
2182: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2183: l_log_msg := l_procedure_name||'(+)';

Line 2222: x_return_status := FND_API.G_RET_STS_SUCCESS;

2218: ELSE
2219: For my_reg IN c_site_uses Loop
2220: -- Got registration
2221: p_getone:=1;
2222: x_return_status := FND_API.G_RET_STS_SUCCESS;
2223:
2224: -- Populate the stucture
2225: x_get_registration_rec.Rounding_Rule_Code:= my_reg.tax_rounding_rule;
2226: x_get_registration_rec.rounding_level_code := my_reg.tax_header_level_flag;

Line 2255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2251: EXCEPTION
2252: WHEN NO_DATA_FOUND THEN
2253: NULL;
2254: WHEN OTHERS THEN
2255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2256: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2257: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2258:
2259: -- Logging Infra: Statement level

Line 2311: x_return_status := FND_API.G_RET_STS_SUCCESS;

2307: -- Logging Infra: Setting up runtime level
2308: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2309:
2310: -- Initialize return status
2311: x_return_status := FND_API.G_RET_STS_SUCCESS;
2312:
2313: -- Logging Infra: Procedure level
2314: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2315: l_log_msg := l_procedure_name||'(+)';

Line 2344: x_return_status := FND_API.G_RET_STS_SUCCESS;

2340: ELSE
2341: For my_reg IN c_customer_account Loop
2342: -- Got registration
2343: p_getone:=1;
2344: x_return_status := FND_API.G_RET_STS_SUCCESS;
2345: -- Pupulate the stucture
2346: x_get_registration_rec.Rounding_Rule_Code:= my_reg.tax_rounding_rule;
2347: x_get_registration_rec.rounding_level_code := my_reg.tax_header_level_flag;
2348: x_get_registration_rec.tax_classification_code := my_reg.tax_code;

Line 2368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2364: EXCEPTION
2365: WHEN NO_DATA_FOUND THEN
2366: NULL;
2367: WHEN OTHERS THEN
2368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2369: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2370: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2371:
2372: -- Logging Infra: Statement level

Line 2408: x_return_status := FND_API.G_RET_STS_SUCCESS;

2404: -- Logging Infra: Setting up runtime level
2405: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2406:
2407: -- Initialize return status
2408: x_return_status := FND_API.G_RET_STS_SUCCESS;
2409:
2410: -- Logging Infra: Procedure level
2411: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2412: l_log_msg := l_procedure_name||'(+)';

Line 2461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2457: x_get_registration_rec.rep_registration_number :=
2458: ZX_GLOBAL_STRUCTURES_PKG.G_PARTY_TAX_PROF_INFO_TBL(p_party_tax_profile_id).rep_registration_number;
2459:
2460: ELSE
2461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2462:
2463: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2464: l_log_msg := 'Party Tax Profile Id is not valid: '||p_party_tax_profile_id;
2465: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

Line 2480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2476: EXCEPTION
2477: WHEN NO_DATA_FOUND THEN
2478: NULL;
2479: WHEN OTHERS THEN
2480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2481: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2482: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2483:
2484: -- Logging Infra: Statement level

Line 2559: p_return_status := FND_API.G_RET_STS_SUCCESS;

2555: -- Logging Infra: Statement level
2556:
2557: -- Initialize Return Status and Error Buffer
2558: --
2559: p_return_status := FND_API.G_RET_STS_SUCCESS;
2560: l_getone := 0;
2561: --
2562: -- Always PTP_ID parameter can NOT be NULL
2563: --

Line 2568: p_return_status := FND_API.G_RET_STS_ERROR;

2564: IF p_parent_ptp_id IS NULL THEN -- if 1
2565: -- Bug 4939819 - Return error only if the third party account id is also NULL.
2566: -- PTP setup is not mandatory for third parties.
2567: IF p_account_id IS NULL THEN
2568: p_return_status := FND_API.G_RET_STS_ERROR;
2569: p_ret_record_level := NULL;
2570: return;
2571: END IF;
2572: ELSE -- if 1

Line 2693: p_return_status := FND_API.G_RET_STS_ERROR;

2689: ,l_getone);
2690: IF l_getone = 1 THEN -- if15
2691: return;
2692: ELSE -- if15 getone
2693: p_return_status := FND_API.G_RET_STS_ERROR;
2694: p_ret_record_level := NULL;
2695:
2696: -- Logging Infra: Procedure level
2697: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN -- if16

Line 2717: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2713: EXCEPTION
2714: WHEN NO_DATA_FOUND THEN
2715: NULL;
2716: WHEN OTHERS THEN
2717: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2718: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2719: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2720:
2721: -- Logging Infra: Statement level

Line 2743: p_return_status := FND_API.G_RET_STS_SUCCESS;

2739: -- Logging Infra: Setting up runtime level
2740: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2741:
2742: -- Initialize return status
2743: p_return_status := FND_API.G_RET_STS_SUCCESS;
2744:
2745: -- Logging Infra: Procedure level
2746: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2747: l_log_msg := l_procedure_name||'(+)';

Line 2835: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2831: END IF;
2832:
2833:
2834: EXCEPTION WHEN OTHERS THEN
2835: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2836: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2837: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2838:
2839: -- Logging Infra: Statement level