DBA Data[Home] [Help]

APPS.PJM_SEIBAN_PKG dependencies on PJM_CONC

Line 416: pjm_conc.put_line( fnd_message.get );

412: project_number_dup(X_project_number, L_Return_Status);
413:
414: if ( L_Return_Status = 'Y' ) then
415: fnd_message.set_name('PJM', 'FORM-DUPLICATE PROJECT NUM');
416: pjm_conc.put_line( fnd_message.get );
417: Raise Proj_Creation_Error;
418: end if;
419:
420: --

Line 427: pjm_conc.put_line( fnd_message.get );

423: project_name_dup(X_project_name, L_Return_Status);
424:
425: if ( L_Return_Status = 'Y' ) then
426: fnd_message.set_name('PJM', 'FORM-DUPLICATE PROJECT NAME');
427: pjm_conc.put_line( fnd_message.get );
428: Raise Proj_Creation_Error;
429: end if;
430:
431: Create_AMG_Project( X_Project_Template

Line 440: pjm_conc.put_line('Project_Number = ' || X_Project_Number);

436: , X_submit_workflow
437: , L_Project_ID
438: , L_Return_Status );
439:
440: pjm_conc.put_line('Project_Number = ' || X_Project_Number);
441: pjm_conc.put_line('Project_Name = ' || X_Project_Name);
442: pjm_conc.put_line('Project_ID = ' || to_char(L_Project_ID));
443: pjm_conc.put_line('AMG return_status = ' || L_Return_Status);
444: pjm_conc.new_line(1);

Line 441: pjm_conc.put_line('Project_Name = ' || X_Project_Name);

437: , L_Project_ID
438: , L_Return_Status );
439:
440: pjm_conc.put_line('Project_Number = ' || X_Project_Number);
441: pjm_conc.put_line('Project_Name = ' || X_Project_Name);
442: pjm_conc.put_line('Project_ID = ' || to_char(L_Project_ID));
443: pjm_conc.put_line('AMG return_status = ' || L_Return_Status);
444: pjm_conc.new_line(1);
445:

Line 442: pjm_conc.put_line('Project_ID = ' || to_char(L_Project_ID));

438: , L_Return_Status );
439:
440: pjm_conc.put_line('Project_Number = ' || X_Project_Number);
441: pjm_conc.put_line('Project_Name = ' || X_Project_Name);
442: pjm_conc.put_line('Project_ID = ' || to_char(L_Project_ID));
443: pjm_conc.put_line('AMG return_status = ' || L_Return_Status);
444: pjm_conc.new_line(1);
445:
446: if ( L_Return_Status <> 'S' ) then

Line 443: pjm_conc.put_line('AMG return_status = ' || L_Return_Status);

439:
440: pjm_conc.put_line('Project_Number = ' || X_Project_Number);
441: pjm_conc.put_line('Project_Name = ' || X_Project_Name);
442: pjm_conc.put_line('Project_ID = ' || to_char(L_Project_ID));
443: pjm_conc.put_line('AMG return_status = ' || L_Return_Status);
444: pjm_conc.new_line(1);
445:
446: if ( L_Return_Status <> 'S' ) then
447: pjm_conc.put_line( fnd_message.get );

Line 444: pjm_conc.new_line(1);

440: pjm_conc.put_line('Project_Number = ' || X_Project_Number);
441: pjm_conc.put_line('Project_Name = ' || X_Project_Name);
442: pjm_conc.put_line('Project_ID = ' || to_char(L_Project_ID));
443: pjm_conc.put_line('AMG return_status = ' || L_Return_Status);
444: pjm_conc.new_line(1);
445:
446: if ( L_Return_Status <> 'S' ) then
447: pjm_conc.put_line( fnd_message.get );
448: Raise Proj_Creation_Error;

Line 447: pjm_conc.put_line( fnd_message.get );

443: pjm_conc.put_line('AMG return_status = ' || L_Return_Status);
444: pjm_conc.new_line(1);
445:
446: if ( L_Return_Status <> 'S' ) then
447: pjm_conc.put_line( fnd_message.get );
448: Raise Proj_Creation_Error;
449: end if;
450:
451: --

Line 511: pjm_conc.put_line( sqlerrm );

507: EXCEPTION
508: WHEN NO_DATA_FOUND THEN
509: L_Task_ID := NULL;
510: WHEN OTHERS THEN
511: pjm_conc.put_line( sqlerrm );
512: Raise Task_Creation_Error;
513: END;
514:
515: if ( L_Task_ID is null ) then

Line 523: pjm_conc.put_line(

519: , L_Task_Num
520: , L_Task_ID
521: , L_Return_Status );
522:
523: pjm_conc.put_line(
524: 'Task_Number = ' || L_Task_Num || ' ' ||
525: 'Task_ID = ' || to_char(L_Task_ID) || ' ' ||
526: 'AMG return_status = ' || L_Return_Status);
527:

Line 529: pjm_conc.new_line(1);

525: 'Task_ID = ' || to_char(L_Task_ID) || ' ' ||
526: 'AMG return_status = ' || L_Return_Status);
527:
528: if ( L_Return_Status <> 'S' ) then
529: pjm_conc.new_line(1);
530: pjm_conc.put_line( fnd_message.get );
531: Raise Task_Creation_Error;
532: end if;
533:

Line 530: pjm_conc.put_line( fnd_message.get );

526: 'AMG return_status = ' || L_Return_Status);
527:
528: if ( L_Return_Status <> 'S' ) then
529: pjm_conc.new_line(1);
530: pjm_conc.put_line( fnd_message.get );
531: Raise Task_Creation_Error;
532: end if;
533:
534: commit;

Line 561: pjm_conc.put_line( errbuf );

557:
558: if ( l_err_code <> 0 ) then
559: fnd_message.set_name('PA', l_err_stage);
560: errbuf := fnd_message.get;
561: pjm_conc.put_line( errbuf );
562: commit;
563: retcode := PJM_CONC.G_conc_warning;
564: end if;
565:

Line 563: retcode := PJM_CONC.G_conc_warning;

559: fnd_message.set_name('PA', l_err_stage);
560: errbuf := fnd_message.get;
561: pjm_conc.put_line( errbuf );
562: commit;
563: retcode := PJM_CONC.G_conc_warning;
564: end if;
565:
566: commit;
567:

Line 572: retcode := PJM_CONC.G_conc_success;

568: end if; /* l_wf_status_code */
569:
570: end if; /* X_submit_workflow */
571:
572: retcode := PJM_CONC.G_conc_success;
573:
574: EXCEPTION
575: WHEN Proj_Creation_Error THEN
576: fnd_message.set_name('PJM', 'SEIB-PROJ CREATION FAILED');

Line 578: pjm_conc.put_line( errbuf );

574: EXCEPTION
575: WHEN Proj_Creation_Error THEN
576: fnd_message.set_name('PJM', 'SEIB-PROJ CREATION FAILED');
577: errbuf := fnd_message.get;
578: pjm_conc.put_line( errbuf );
579: retcode := PJM_CONC.G_conc_failure;
580:
581: WHEN Task_Creation_Error THEN
582: fnd_message.set_name('PJM', 'SEIB-TASK CREATION FAILED');

Line 579: retcode := PJM_CONC.G_conc_failure;

575: WHEN Proj_Creation_Error THEN
576: fnd_message.set_name('PJM', 'SEIB-PROJ CREATION FAILED');
577: errbuf := fnd_message.get;
578: pjm_conc.put_line( errbuf );
579: retcode := PJM_CONC.G_conc_failure;
580:
581: WHEN Task_Creation_Error THEN
582: fnd_message.set_name('PJM', 'SEIB-TASK CREATION FAILED');
583: errbuf := fnd_message.get;

Line 584: pjm_conc.put_line( errbuf );

580:
581: WHEN Task_Creation_Error THEN
582: fnd_message.set_name('PJM', 'SEIB-TASK CREATION FAILED');
583: errbuf := fnd_message.get;
584: pjm_conc.put_line( errbuf );
585: retcode := PJM_CONC.G_conc_failure;
586:
587: WHEN OTHERS THEN
588: errbuf := sqlerrm;

Line 585: retcode := PJM_CONC.G_conc_failure;

581: WHEN Task_Creation_Error THEN
582: fnd_message.set_name('PJM', 'SEIB-TASK CREATION FAILED');
583: errbuf := fnd_message.get;
584: pjm_conc.put_line( errbuf );
585: retcode := PJM_CONC.G_conc_failure;
586:
587: WHEN OTHERS THEN
588: errbuf := sqlerrm;
589: pjm_conc.put_line( sqlerrm );

Line 589: pjm_conc.put_line( sqlerrm );

585: retcode := PJM_CONC.G_conc_failure;
586:
587: WHEN OTHERS THEN
588: errbuf := sqlerrm;
589: pjm_conc.put_line( sqlerrm );
590: retcode := PJM_CONC.G_conc_failure;
591:
592: END Conc_Create;
593:

Line 590: retcode := PJM_CONC.G_conc_failure;

586:
587: WHEN OTHERS THEN
588: errbuf := sqlerrm;
589: pjm_conc.put_line( sqlerrm );
590: retcode := PJM_CONC.G_conc_failure;
591:
592: END Conc_Create;
593:
594: END pjm_seiban_pkg;