DBA Data[Home] [Help]

APPS.IGC_CC_COMPLETE_COVER_PKG dependencies on FND_API

Line 176: raise fnd_api.g_exc_error;

172: and set_of_books_id = x_set_of_books_id
173: and org_id = x_org_id;
174: Exception
175: When others then
176: raise fnd_api.g_exc_error;
177: End Update_releases;
178:
179:
180: -- Procedure Insert_exceptions insert validations or budgetary control errors

Line 208: raise fnd_api.g_exc_error;

204: , x_set_of_books_id
205: , x_request_id );
206: Exception
207: When others then
208: raise fnd_api.g_exc_error;
209: End Insert_exception;
210:
211: -- Procedure Submit_report submits the exception report after the Cover commitment is
212: -- processed

Line 267: Raise Fnd_api.g_exc_error;

263: Else
264: IF g_debug_mode = 'Y' THEN
265: Writelog (l_full_path,'IGCCCOVB - FAILED status of IGCCOVR request');
266: END IF;
267: Raise Fnd_api.g_exc_error;
268: End if;
269:
270:
271: ------------------------------------

Line 334: Raise Fnd_api.g_exc_error;

330: Else
331: IF g_debug_mode = 'Y' THEN
332: Writelog (l_full_path,'IGCCCOVB - FAILED status of IGCCOVR_XML request');
333: END IF;
334: Raise Fnd_api.g_exc_error;
335: End if;
336: ------------------------------------
337: ---End Of XML Report
338: ------------------------------------

Line 368: Raise Fnd_api.g_exc_error;

364: When others then
365: If C_matched_releases%isopen then
366: Close C_matched_releases;
367: End if;
368: Raise Fnd_api.g_exc_error;
369: End;
370:
371:
372: -- Begin section of the complete cover procedure

Line 487: , p_init_msg_list => fnd_api.g_false

483: , c_rel_rec.set_of_books_id
484: , c_rel_rec.org_id );
485: Igc_cc_po_interface_pkg.update_po_approved_flag (
486: p_api_version => 1.0
487: , p_init_msg_list => fnd_api.g_false
488: , p_commit => fnd_api.g_false
489: , p_validation_level => fnd_api.g_valid_level_full
490: , x_return_status => l_return_status
491: , x_msg_count => l_msg_count

Line 488: , p_commit => fnd_api.g_false

484: , c_rel_rec.org_id );
485: Igc_cc_po_interface_pkg.update_po_approved_flag (
486: p_api_version => 1.0
487: , p_init_msg_list => fnd_api.g_false
488: , p_commit => fnd_api.g_false
489: , p_validation_level => fnd_api.g_valid_level_full
490: , x_return_status => l_return_status
491: , x_msg_count => l_msg_count
492: , x_msg_data => l_msg_data

Line 489: , p_validation_level => fnd_api.g_valid_level_full

485: Igc_cc_po_interface_pkg.update_po_approved_flag (
486: p_api_version => 1.0
487: , p_init_msg_list => fnd_api.g_false
488: , p_commit => fnd_api.g_false
489: , p_validation_level => fnd_api.g_valid_level_full
490: , x_return_status => l_return_status
491: , x_msg_count => l_msg_count
492: , x_msg_data => l_msg_data
493: , p_cc_header_id => c_rel_rec.cc_header_id );

Line 494: If l_return_status = fnd_api.g_ret_sts_success then

490: , x_return_status => l_return_status
491: , x_msg_count => l_msg_count
492: , x_msg_data => l_msg_data
493: , p_cc_header_id => c_rel_rec.cc_header_id );
494: If l_return_status = fnd_api.g_ret_sts_success then
495: initialise_variables;
496: Igc_cc_budgetary_ctrl_pkg.Execute_budgetary_ctrl (
497: p_api_version => 1.0
498: , p_init_msg_list => fnd_api.g_false

Line 498: , p_init_msg_list => fnd_api.g_false

494: If l_return_status = fnd_api.g_ret_sts_success then
495: initialise_variables;
496: Igc_cc_budgetary_ctrl_pkg.Execute_budgetary_ctrl (
497: p_api_version => 1.0
498: , p_init_msg_list => fnd_api.g_false
499: , p_commit => fnd_api.g_false
500: , p_validation_level => fnd_api.g_valid_level_full
501: , x_return_status => l_return_status
502: , x_bc_status => l_bc_status

Line 499: , p_commit => fnd_api.g_false

495: initialise_variables;
496: Igc_cc_budgetary_ctrl_pkg.Execute_budgetary_ctrl (
497: p_api_version => 1.0
498: , p_init_msg_list => fnd_api.g_false
499: , p_commit => fnd_api.g_false
500: , p_validation_level => fnd_api.g_valid_level_full
501: , x_return_status => l_return_status
502: , x_bc_status => l_bc_status
503: , x_msg_count => l_msg_count

Line 500: , p_validation_level => fnd_api.g_valid_level_full

496: Igc_cc_budgetary_ctrl_pkg.Execute_budgetary_ctrl (
497: p_api_version => 1.0
498: , p_init_msg_list => fnd_api.g_false
499: , p_commit => fnd_api.g_false
500: , p_validation_level => fnd_api.g_valid_level_full
501: , x_return_status => l_return_status
502: , x_bc_status => l_bc_status
503: , x_msg_count => l_msg_count
504: , x_msg_data => l_msg_data

Line 509: If l_return_status = fnd_api.g_ret_sts_success and l_bc_status = fnd_api.g_true then

505: , p_cc_header_id => c_rel_rec.cc_header_id
506: , p_accounting_date => c_rel_rec.cc_acct_date
507: , p_mode => 'R'
508: , p_notes => null);
509: If l_return_status = fnd_api.g_ret_sts_success and l_bc_status = fnd_api.g_true then
510: Update_releases ( 'CT'
511: , 'AP'
512: , 'C'
513: , c_rel_rec.cc_header_id

Line 518: , p_init_msg_list => fnd_api.g_false

514: , c_rel_rec.set_of_books_id
515: , c_rel_rec.org_id );
516: Igc_cc_po_interface_pkg.Convert_cc_to_po(
517: p_api_version => 1.0
518: , p_init_msg_list => fnd_api.g_false
519: , p_commit => fnd_api.g_false
520: , p_validation_level => fnd_api.g_valid_level_full
521: , x_return_status => l_return_status
522: , x_msg_count => l_msg_count

Line 519: , p_commit => fnd_api.g_false

515: , c_rel_rec.org_id );
516: Igc_cc_po_interface_pkg.Convert_cc_to_po(
517: p_api_version => 1.0
518: , p_init_msg_list => fnd_api.g_false
519: , p_commit => fnd_api.g_false
520: , p_validation_level => fnd_api.g_valid_level_full
521: , x_return_status => l_return_status
522: , x_msg_count => l_msg_count
523: , x_msg_data => l_msg_data

Line 520: , p_validation_level => fnd_api.g_valid_level_full

516: Igc_cc_po_interface_pkg.Convert_cc_to_po(
517: p_api_version => 1.0
518: , p_init_msg_list => fnd_api.g_false
519: , p_commit => fnd_api.g_false
520: , p_validation_level => fnd_api.g_valid_level_full
521: , x_return_status => l_return_status
522: , x_msg_count => l_msg_count
523: , x_msg_data => l_msg_data
524: , p_cc_header_id => c_rel_rec.cc_header_id);

Line 525: If l_return_status = fnd_api.g_ret_sts_success then

521: , x_return_status => l_return_status
522: , x_msg_count => l_msg_count
523: , x_msg_data => l_msg_data
524: , p_cc_header_id => c_rel_rec.cc_header_id);
525: If l_return_status = fnd_api.g_ret_sts_success then
526: null;
527: Else
528: l_validation_error_code := 'Y';
529: Insert_exception ( l_request_id

Line 592: , p_init_msg_list => fnd_api.g_false

588: , c_cover_rec.set_of_books_id
589: , c_cover_rec.org_id );
590: Igc_cc_budgetary_ctrl_pkg.Execute_budgetary_ctrl (
591: p_api_version => 1.0
592: , p_init_msg_list => fnd_api.g_false
593: , p_commit => fnd_api.g_false
594: , p_validation_level => fnd_api.g_valid_level_full
595: , x_return_status => l_return_status
596: , x_bc_status => l_bc_status

Line 593: , p_commit => fnd_api.g_false

589: , c_cover_rec.org_id );
590: Igc_cc_budgetary_ctrl_pkg.Execute_budgetary_ctrl (
591: p_api_version => 1.0
592: , p_init_msg_list => fnd_api.g_false
593: , p_commit => fnd_api.g_false
594: , p_validation_level => fnd_api.g_valid_level_full
595: , x_return_status => l_return_status
596: , x_bc_status => l_bc_status
597: , x_msg_count => l_msg_count

Line 594: , p_validation_level => fnd_api.g_valid_level_full

590: Igc_cc_budgetary_ctrl_pkg.Execute_budgetary_ctrl (
591: p_api_version => 1.0
592: , p_init_msg_list => fnd_api.g_false
593: , p_commit => fnd_api.g_false
594: , p_validation_level => fnd_api.g_valid_level_full
595: , x_return_status => l_return_status
596: , x_bc_status => l_bc_status
597: , x_msg_count => l_msg_count
598: , x_msg_data => l_msg_data

Line 603: If l_return_status = fnd_api.g_ret_sts_success and l_bc_status = fnd_api.g_true then

599: , p_cc_header_id => c_cover_rec.cc_header_id
600: , p_accounting_date => l_acct_date
601: , p_mode => 'R'
602: , p_notes => null);
603: If l_return_status = fnd_api.g_ret_sts_success and l_bc_status = fnd_api.g_true then
604: Update_releases ( 'CT'
605: , 'AP'
606: , 'C'
607: , c_cover_rec.cc_header_id

Line 635: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);

631:
632: IF (l_msg_count > 0) THEN
633: l_error_text := '';
634: FOR l_cur IN 1..l_msg_count LOOP
635: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
636: fnd_file.put_line (FND_FILE.LOG,
637: l_error_text);
638: WriteLog(l_full_path, l_error_text, g_excep_level);
639: END LOOP;

Line 649: When Fnd_api.g_exc_error THEN

645:
646: -- Exception section of Complete_cover procedure
647:
648: Exception
649: When Fnd_api.g_exc_error THEN
650: If C_releases%isopen then
651: Close C_releases;
652: End if;
653: If C_cover%isopen then

Line 686: l_error_text := l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);

682: IF (l_msg_count > 0) THEN
683:
684: l_error_text := '';
685: FOR l_cur IN 1..l_msg_count LOOP
686: l_error_text := l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
687: IF(g_excep_level >= g_debug_level) THEN
688: FND_LOG.STRING(g_excep_level, l_full_path, l_error_text);
689: END IF;
690: fnd_file.put_line (FND_FILE.LOG,

Line 741: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);

737: IF (l_msg_count > 0) THEN
738:
739: l_error_text := '';
740: FOR l_cur IN 1..l_msg_count LOOP
741: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
742: fnd_file.put_line (FND_FILE.LOG,
743: l_error_text);
744: WriteLog(l_full_path, l_error_text, g_excep_level);
745: END LOOP;