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.JG_ZZ_VAT_REP_UTILITY dependencies on FND_API

Line 17: fnd_api.g_ret_sts_success in get_last_processed_date procedure.

13: pv_reallocate_flag <> 'Y' in validate_process_initiation.
14:
15: 31-May-2006 Aparajita. Version#120.4. xBuild-6
16: changed comparison with 'Y' to compare against
17: fnd_api.g_ret_sts_success in get_last_processed_date procedure.
18: Also in decode, if value is not g_ret_sts_success,
19: changed from 0 to null as count function is being used.
20:
21: Added code to hanlde ALL for pv_source

Line 131: ( pv_process_name = 'SELECTION' and selection_status_flag = fnd_api.g_ret_sts_success)

127: where
128: vat_reporting_entity_id = pn_vat_reporting_entity_id
129: and ( pv_source = 'ALL' or source = pv_source)
130: and (
131: ( pv_process_name = 'SELECTION' and selection_status_flag = fnd_api.g_ret_sts_success)
132: or
133: ( pv_process_name = 'ALLOCATION' and allocation_status_flag = fnd_api.g_ret_sts_success)
134: or
135: ( pv_process_name = 'FINAL REPORTING' and

Line 133: ( pv_process_name = 'ALLOCATION' and allocation_status_flag = fnd_api.g_ret_sts_success)

129: and ( pv_source = 'ALL' or source = pv_source)
130: and (
131: ( pv_process_name = 'SELECTION' and selection_status_flag = fnd_api.g_ret_sts_success)
132: or
133: ( pv_process_name = 'ALLOCATION' and allocation_status_flag = fnd_api.g_ret_sts_success)
134: or
135: ( pv_process_name = 'FINAL REPORTING' and
136: final_reporting_status_flag = fnd_api.g_ret_sts_success)
137: );

Line 136: final_reporting_status_flag = fnd_api.g_ret_sts_success)

132: or
133: ( pv_process_name = 'ALLOCATION' and allocation_status_flag = fnd_api.g_ret_sts_success)
134: or
135: ( pv_process_name = 'FINAL REPORTING' and
136: final_reporting_status_flag = fnd_api.g_ret_sts_success)
137: );
138:
139:
140: begin

Line 248: xv_return_status := fnd_api.g_ret_sts_success;

244: if ld_last_processed_date is not null then
245:
246: if ld_last_processed_date + 1 = pd_start_date then
247: /* There is no gap in period */
248: xv_return_status := fnd_api.g_ret_sts_success;
249: xv_return_message := 'There is no gap in period';
250: else
251: xv_return_status := fnd_api.g_ret_sts_error;
252: xv_return_message := 'Processing has successfully happened till ' || ld_last_processed_date ||

Line 251: xv_return_status := fnd_api.g_ret_sts_error;

247: /* There is no gap in period */
248: xv_return_status := fnd_api.g_ret_sts_success;
249: xv_return_message := 'There is no gap in period';
250: else
251: xv_return_status := fnd_api.g_ret_sts_error;
252: xv_return_message := 'Processing has successfully happened till ' || ld_last_processed_date ||
253: '. Gap in processing period is not allowed.';
254: end if;
255:

Line 264: xv_return_status := fnd_api.g_ret_sts_success;

260: fetch c_get_first_period_start_date into ld_first_period_start_date;
261: close c_get_first_period_start_date;
262:
263: if ld_first_period_start_date = pd_start_date then
264: xv_return_status := fnd_api.g_ret_sts_success;
265: xv_return_message := 'This period is the first period in the calendar, so no gap.';
266: else
267: xv_return_status := fnd_api.g_ret_sts_error;
268: xv_return_message := 'No period has been processed, the current period is not the first period in the calendar, Cannot proceed.';

Line 267: xv_return_status := fnd_api.g_ret_sts_error;

263: if ld_first_period_start_date = pd_start_date then
264: xv_return_status := fnd_api.g_ret_sts_success;
265: xv_return_message := 'This period is the first period in the calendar, so no gap.';
266: else
267: xv_return_status := fnd_api.g_ret_sts_error;
268: xv_return_message := 'No period has been processed, the current period is not the first period in the calendar, Cannot proceed.';
269: end if;
270:
271: end if; /* ld_last_processed_date is not null */

Line 355: xv_return_status := fnd_api.g_ret_sts_success;

351: and ( (pv_source = 'ALL') OR (pv_source <> 'ALL' and source = pv_source) );
352:
353: End if;
354:
355: xv_return_status := fnd_api.g_ret_sts_success;
356: return;
357:
358: /* Exception handling is not required as this is called internally and error handling is in the outer most procedure */
359: end pre_process_update;

Line 507: xv_return_status := fnd_api.g_ret_sts_error;

503: fnd_message.set_name('JG', 'JG_ZZ_VAT_NO_SELECTION');
504: fnd_message.set_token('SOURCE', lv_source);
505: fnd_message.set_token('PROCESS_NAME', pv_process_name);
506: xv_return_message := fnd_message.get;
507: xv_return_status := fnd_api.g_ret_sts_error;
508: goto error_exit_from_procedure;
509: end if;
510:
511: /* Control comes here only Selection process is being run for the first time for a given combination */

Line 543: if xv_return_status <> fnd_api.g_ret_sts_success then

539: xv_return_status => xv_return_status,
540: xv_return_message => xv_return_message
541: );
542:
543: if xv_return_status <> fnd_api.g_ret_sts_success then
544: goto error_exit_from_procedure;
545: end if;
546:
547: */

Line 570: if cur_rec_jg_zz_vat_rep_status.final_reporting_status_flag = fnd_api.g_ret_sts_success then

566:
567: /* Record exists in jg_zz_vat_rep_status for the given combination */
568:
569: /* Validation # 2: Common validation - Final reporting should not have happened */
570: if cur_rec_jg_zz_vat_rep_status.final_reporting_status_flag = fnd_api.g_ret_sts_success then
571: fnd_message.set_name('JG', 'JG_ZZ_VAT_FINALLY_REPORTED');
572: fnd_message.set_token('SOURCE', lv_source);
573: fnd_message.set_token('PROCESS_NAME', pv_process_name);
574: xv_return_message := fnd_message.get;

Line 575: xv_return_status := fnd_api.g_ret_sts_error;

571: fnd_message.set_name('JG', 'JG_ZZ_VAT_FINALLY_REPORTED');
572: fnd_message.set_token('SOURCE', lv_source);
573: fnd_message.set_token('PROCESS_NAME', pv_process_name);
574: xv_return_message := fnd_message.get;
575: xv_return_status := fnd_api.g_ret_sts_error;
576: goto error_exit_from_procedure;
577: end if;
578:
579:

Line 600: if xv_return_status <> fnd_api.g_ret_sts_success then

596: xv_return_status => xv_return_status,
597: xv_return_message => xv_return_message
598: );
599:
600: if xv_return_status <> fnd_api.g_ret_sts_success then
601: goto error_exit_from_procedure;
602: end if;
603:
604: end if;

Line 614: if xv_return_status <> fnd_api.g_ret_sts_success then

610: p_reporting_status_id => cur_rec_jg_zz_vat_rep_status.reporting_status_id,
611: x_return_status => xv_return_status
612: );
613:
614: if xv_return_status <> fnd_api.g_ret_sts_success then
615: fnd_message.set_name('JG', 'JG_ZZ_VAT_GENERIC_ERROR');
616: fnd_message.set_token('PROCESS_DETAILS', ' during purge of previous selection data');
617: xv_return_message := fnd_message.get;
618: goto error_exit_from_procedure;

Line 624: if cur_rec_jg_zz_vat_rep_status.selection_status_flag <> fnd_api.g_ret_sts_success then

620:
621: elsif pv_process_name = 'ALLOCATION' then
622:
623: /* Check if selection has already happened successfully */
624: if cur_rec_jg_zz_vat_rep_status.selection_status_flag <> fnd_api.g_ret_sts_success then
625: fnd_message.set_name('JG', 'JG_ZZ_VAT_ERROR_SELECTION');
626: fnd_message.set_token('SOURCE', lv_source);
627: fnd_message.set_token('PROCESS_NAME', pv_process_name);
628: xv_return_message := fnd_message.get;

Line 629: xv_return_status := fnd_api.g_ret_sts_error;

625: fnd_message.set_name('JG', 'JG_ZZ_VAT_ERROR_SELECTION');
626: fnd_message.set_token('SOURCE', lv_source);
627: fnd_message.set_token('PROCESS_NAME', pv_process_name);
628: xv_return_message := fnd_message.get;
629: xv_return_status := fnd_api.g_ret_sts_error;
630: goto error_exit_from_procedure;
631: end if;
632:
633:

Line 647: if xv_return_status <> fnd_api.g_ret_sts_success then

643: xv_return_status => xv_return_status,
644: xv_return_message => xv_return_message
645: );
646:
647: if xv_return_status <> fnd_api.g_ret_sts_success then
648: goto error_exit_from_procedure;
649: end if;
650:
651: end if;

Line 666: if xv_return_status <> fnd_api.g_ret_sts_success then

662: xv_return_status => xv_return_status,
663: xv_return_message => xv_return_message
664: );
665:
666: if xv_return_status <> fnd_api.g_ret_sts_success then
667: goto error_exit_from_procedure;
668: end if;
669:
670: end if;

Line 675: if cur_rec_jg_zz_vat_rep_status.selection_status_flag <> fnd_api.g_ret_sts_success then

671:
672: elsif pv_process_name = 'FINAL REPORTING' then
673:
674: /* Check if selection has already happened successfully */
675: if cur_rec_jg_zz_vat_rep_status.selection_status_flag <> fnd_api.g_ret_sts_success then
676: fnd_message.set_name('JG', 'JG_ZZ_VAT_ERROR_SELECTION');
677: fnd_message.set_token('SOURCE', lv_source);
678: fnd_message.set_token('PROCESS_NAME', pv_process_name);
679: xv_return_message := fnd_message.get;

Line 680: xv_return_status := fnd_api.g_ret_sts_error;

676: fnd_message.set_name('JG', 'JG_ZZ_VAT_ERROR_SELECTION');
677: fnd_message.set_token('SOURCE', lv_source);
678: fnd_message.set_token('PROCESS_NAME', pv_process_name);
679: xv_return_message := fnd_message.get;
680: xv_return_status := fnd_api.g_ret_sts_error;
681: goto error_exit_from_procedure;
682: end if;
683:
684: if cur_rec_jg_zz_vat_rep_status.allocation_status_flag = 'N' then

Line 692: xv_return_status := fnd_api.g_ret_sts_error;

688: fnd_message.set_name('JG', 'JG_ZZ_VAT_NO_ALLOCATION');
689: fnd_message.set_token('SOURCE', lv_source);
690: fnd_message.set_token('PROCESS_NAME', pv_process_name);
691: xv_return_message := fnd_message.get;
692: xv_return_status := fnd_api.g_ret_sts_error;
693: goto error_exit_from_procedure;
694: end if;
695:
696: elsif cur_rec_jg_zz_vat_rep_status.allocation_status_flag <> fnd_api.g_ret_sts_success then

Line 696: elsif cur_rec_jg_zz_vat_rep_status.allocation_status_flag <> fnd_api.g_ret_sts_success then

692: xv_return_status := fnd_api.g_ret_sts_error;
693: goto error_exit_from_procedure;
694: end if;
695:
696: elsif cur_rec_jg_zz_vat_rep_status.allocation_status_flag <> fnd_api.g_ret_sts_success then
697:
698: fnd_message.set_name('JG', 'JG_ZZ_VAT_ERROR_ALLOCATION');
699: fnd_message.set_token('SOURCE', lv_source);
700: fnd_message.set_token('PROCESS_NAME', pv_process_name);

Line 702: xv_return_status := fnd_api.g_ret_sts_error;

698: fnd_message.set_name('JG', 'JG_ZZ_VAT_ERROR_ALLOCATION');
699: fnd_message.set_token('SOURCE', lv_source);
700: fnd_message.set_token('PROCESS_NAME', pv_process_name);
701: xv_return_message := fnd_message.get;
702: xv_return_status := fnd_api.g_ret_sts_error;
703: goto error_exit_from_procedure;
704:
705: end if; /* Has allocation happend successfully or is it enabled but not happened */
706:

Line 722: if xv_return_status <> fnd_api.g_ret_sts_success then

718: xv_return_status => xv_return_status,
719: xv_return_message => xv_return_message
720: );
721:
722: if xv_return_status <> fnd_api.g_ret_sts_success then
723: goto error_exit_from_procedure;
724: end if;
725:
726: Revised approach change */

Line 774: if xv_return_status =fnd_api.g_ret_sts_success then

770: xv_return_status => xv_return_status ,
771: xv_return_message => xv_return_message
772: );
773:
774: if xv_return_status =fnd_api.g_ret_sts_success then
775: return;
776: end if;
777: << exit_from_procedure >>
778:

Line 784: xv_return_status := fnd_api.g_ret_sts_unexp_error;

780: return;
781:
782: exception
783: when others then
784: xv_return_status := fnd_api.g_ret_sts_unexp_error;
785: xv_return_message := 'jg_zz_vat_rep_utility.validate_process_initiation~Unexpected Error -' || sqlerrm;
786: return;
787: end validate_process_initiation;
788: /* ================================== End of validate_process_initiation =============================== */

Line 860: xv_return_status := fnd_api.g_ret_sts_success;

856: and ( (pv_source = 'ALL') OR (pv_source <> 'ALL' and source = pv_source) );
857:
858: End if;
859:
860: xv_return_status := fnd_api.g_ret_sts_success;
861: return;
862:
863:
864: exception

Line 866: xv_return_status := fnd_api.g_ret_sts_unexp_error;

862:
863:
864: exception
865: when others then
866: xv_return_status := fnd_api.g_ret_sts_unexp_error;
867: xv_return_message := 'jg_zz_vat_rep_utility.post_process_update~Unexpected Error -' || sqlerrm;
868: return;
869: end post_process_update;
870: /* ================================== End of post_process_update =============================== */

Line 889: count(decode(final_reporting_status_flag, fnd_api.g_ret_sts_success, 1, null)) final_record

885: pv_tax_calendar_period varchar2,
886: pv_tax_calendar_year number,
887: pv_source varchar2) is
888: select count(vat_reporting_entity_id) total_record,
889: count(decode(final_reporting_status_flag, fnd_api.g_ret_sts_success, 1, null)) final_record
890: from jg_zz_vat_rep_status
891: where vat_reporting_entity_id = pn_vat_reporting_entity_id
892: and ( tax_calendar_period = nvl(pv_tax_calendar_period,'-1')
893: or tax_calendar_year=nvl(pv_tax_calendar_year,-1))

Line 1111: xv_return_status := fnd_api.g_ret_sts_error;

1107: begin
1108:
1109: if pn_vat_reporting_entity_id is null then
1110: /* This parameter is required for entities of all level*/
1111: xv_return_status := fnd_api.g_ret_sts_error;
1112: fnd_message.set_name('JG', 'JG_ZZ_VAT_INVALID_ENTITY');
1113: fnd_message.set_token('PARAMETER', 'TRN');
1114: fnd_message.set_token('LEVEL', 'pv_entity_level_code');
1115: xv_return_message := fnd_message.get;

Line 1116: xv_return_status := fnd_api.g_ret_sts_error;

1112: fnd_message.set_name('JG', 'JG_ZZ_VAT_INVALID_ENTITY');
1113: fnd_message.set_token('PARAMETER', 'TRN');
1114: fnd_message.set_token('LEVEL', 'pv_entity_level_code');
1115: xv_return_message := fnd_message.get;
1116: xv_return_status := fnd_api.g_ret_sts_error;
1117: goto exit_from_procedure;
1118: end if;
1119:
1120: if pv_entity_level_code = 'LEDGER' then

Line 1123: xv_return_status := fnd_api.g_ret_sts_error;

1119:
1120: if pv_entity_level_code = 'LEDGER' then
1121:
1122: if pn_ledger_id is null then /* Required parameter */
1123: xv_return_status := fnd_api.g_ret_sts_error;
1124: fnd_message.set_name('JG', 'JG_ZZ_VAT_INVALID_ENTITY');
1125: fnd_message.set_token('PARAMETER', 'LEDGER');
1126: fnd_message.set_token('LEVEL', 'pv_entity_level_code');
1127: xv_return_message := fnd_message.get;

Line 1137: xv_return_status := fnd_api.g_ret_sts_error;

1133:
1134: if pv_entity_level_code = 'BSV' then
1135:
1136: if pn_ledger_id is null then /* Required parameter */
1137: xv_return_status := fnd_api.g_ret_sts_error;
1138: fnd_message.set_name('JG', 'JG_ZZ_VAT_INVALID_ENTITY');
1139: fnd_message.set_token('PARAMETER', 'LEDGER');
1140: fnd_message.set_token('LEVEL', 'pv_entity_level_code');
1141: xv_return_message := fnd_message.get;

Line 1146: xv_return_status := fnd_api.g_ret_sts_error;

1142: goto exit_from_procedure;
1143: end if;
1144:
1145: if pv_balancing_segment_value is null then
1146: xv_return_status := fnd_api.g_ret_sts_error;
1147: fnd_message.set_name('JG', 'JG_ZZ_VAT_INVALID_ENTITY');
1148: fnd_message.set_token('PARAMETER', 'BSV');
1149: fnd_message.set_token('LEVEL', 'pv_entity_level_code');
1150: xv_return_message := fnd_message.get;

Line 1156: xv_return_status := fnd_api.g_ret_sts_success;

1152:
1153: end if;
1154:
1155:
1156: xv_return_status := fnd_api.g_ret_sts_success;
1157:
1158: << exit_from_procedure >>
1159: return;
1160:

Line 1163: xv_return_status := fnd_api.g_ret_sts_unexp_error;

1159: return;
1160:
1161: exception
1162: when others then
1163: xv_return_status := fnd_api.g_ret_sts_unexp_error;
1164: xv_return_message := 'jg_zz_vat_rep_utility.validate_entity_attributes~Unexpected Error -' || sqlerrm;
1165: return;
1166: end validate_entity_attributes;
1167: /* ============================== End of validate_entity_attributes =========================== */

Line 1249: xv_return_status := fnd_api.g_ret_sts_success;

1245: );
1246:
1247:
1248: << exit_from_procedure >>
1249: xv_return_status := fnd_api.g_ret_sts_success;
1250: return;
1251:
1252: exception
1253: when others then

Line 1254: xv_return_status := fnd_api.g_ret_sts_unexp_error;

1250: return;
1251:
1252: exception
1253: when others then
1254: xv_return_status := fnd_api.g_ret_sts_unexp_error;
1255: xv_return_message := 'jg_zz_vat_rep_utility.create_accounting_entity~Unexpected Error -' || sqlerrm;
1256: return;
1257: end create_accounting_entity;
1258: /* ============================ End of create_accounting_entity ============================ */

Line 1339: if lv_return_status <> fnd_api.g_ret_sts_success then

1335: xv_return_status => lv_return_status ,
1336: xv_return_message => lv_return_message
1337: );
1338:
1339: if lv_return_status <> fnd_api.g_ret_sts_success then
1340: /* Entity does not have valid attributes */
1341: lv_entity_identifier := lv_return_message;
1342: goto exit_from_procedure ;
1343: end if;

Line 1468: if xv_return_status <> fnd_api.g_ret_sts_success then

1464: xv_return_status => xv_return_status ,
1465: xv_return_message => xv_return_message
1466: );
1467:
1468: if xv_return_status <> fnd_api.g_ret_sts_success then
1469: goto exit_from_procedure;
1470: end if;
1471:
1472: if pv_entity_level_code = 'LE' then

Line 1474: xv_return_status := fnd_api.g_ret_sts_success;

1470: end if;
1471:
1472: if pv_entity_level_code = 'LE' then
1473: xn_vat_reporting_entity_id := pn_vat_reporting_entity_id;
1474: xv_return_status := fnd_api.g_ret_sts_success;
1475: goto exit_from_procedure;
1476: else
1477:
1478: xn_vat_reporting_entity_id :=

Line 1501: xv_return_status := fnd_api.g_ret_sts_success;

1497: xv_return_message => xv_return_message
1498: );
1499:
1500: else
1501: xv_return_status := fnd_api.g_ret_sts_success;
1502: end if;
1503:
1504: end if; /* pv_entity_level_code */
1505:

Line 1512: xv_return_status := fnd_api.g_ret_sts_unexp_error;

1508:
1509:
1510: exception
1511: when others then
1512: xv_return_status := fnd_api.g_ret_sts_unexp_error;
1513: xv_return_message := 'jg_zz_vat_rep_utility.maintain_selection_entities~Unexpected Error -' || sqlerrm;
1514: return;
1515: end maintain_selection_entities;
1516: /* ============================ End of maintain_selection_entities ============================ */