DBA Data[Home] [Help]

APPS.PJM_PROJECT_PARAM_PUB dependencies on FND_MSG_PUB

Line 150: FND_MSG_PUB.add;

146: CLOSE pg;
147: ELSE
148: FND_MESSAGE.set_name('PJM' , 'GEN-PROJ ID INVALID');
149: FND_MESSAGE.set_token('ID' , X_param_data.project_id);
150: FND_MSG_PUB.add;
151: X_return_status := FND_API.G_RET_STS_ERROR;
152: return;
153: END IF;
154:

Line 185: FND_MSG_PUB.add;

181: G_organization_id := X_param_data.organization_id;
182: ELSE
183: FND_MESSAGE.set_name('PJM' , 'GEN-ORG ID INVALID');
184: FND_MESSAGE.set_token('ID' , X_param_data.organization_id);
185: FND_MSG_PUB.add;
186: X_return_status := FND_API.G_RET_STS_ERROR;
187: return;
188: END IF;
189:

Line 272: FND_MSG_PUB.add_exc_msg

268: END IF;
269:
270: EXCEPTION
271: WHEN OTHERS THEN
272: FND_MSG_PUB.add_exc_msg
273: ( p_pkg_name => G_pkg_name
274: , p_procedure_name => 'DEFAULT_VALUES' );
275: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276:

Line 362: FND_MSG_PUB.add;

358: FETCH pp INTO pprec;
359: CLOSE pp;
360: IF ( pprec.project_id is not null ) THEN
361: FND_MESSAGE.set_name('PJM' , 'GEN-PARAM RECORD EXISTS');
362: FND_MSG_PUB.add;
363: X_return_status := FND_API.G_RET_STS_ERROR;
364: return;
365: END IF;
366: END IF;

Line 374: FND_MSG_PUB.add;

370: --
371: IF ( P_param_data.start_date_active > G_proj_comp_date ) THEN
372: FND_MESSAGE.set_name('PJM' , 'FORM-PARAM START DATE INVALID');
373: FND_MESSAGE.set_token('DATE' , FND_DATE.date_to_displaydate(dateval=>G_proj_comp_date, calendar_aware=>2));
374: FND_MSG_PUB.add;
375: X_return_status := FND_API.G_RET_STS_ERROR;
376: END IF;
377:
378: IF ( P_param_data.end_date_active < G_proj_start_date ) THEN

Line 381: FND_MSG_PUB.add;

377:
378: IF ( P_param_data.end_date_active < G_proj_start_date ) THEN
379: FND_MESSAGE.set_name('PJM' , 'FORM-PARAM END DATE INVALID');
380: FND_MESSAGE.set_token('DATE' , FND_DATE.date_to_displaydate(dateval=>G_proj_start_date, calendar_aware=>2));
381: FND_MSG_PUB.add;
382: X_return_status := FND_API.G_RET_STS_ERROR;
383: END IF;
384:
385: IF ( P_param_data.start_date_active > P_param_data.end_date_active ) THEN

Line 387: FND_MSG_PUB.add;

383: END IF;
384:
385: IF ( P_param_data.start_date_active > P_param_data.end_date_active ) THEN
386: FND_MESSAGE.set_name('PJM' , 'FORM-INVALID EFFDATE PAIR');
387: FND_MSG_PUB.add;
388: X_return_status := FND_API.G_RET_STS_ERROR;
389: END IF;
390:
391: --

Line 396: FND_MSG_PUB.add;

392: -- Make sure the control level is not task if project is seiban
393: --
394: IF ( G_seiban_flag = 1 AND G_proj_ctrl_level = 2 ) THEN
395: FND_MESSAGE.set_name('PJM' , 'GEN-TASK CONTROL NO SEIBAN');
396: FND_MSG_PUB.add;
397: X_return_status := FND_API.G_RET_STS_ERROR;
398: END IF;
399:
400: --

Line 411: FND_MSG_PUB.add;

407: IF ( cgrec.cost_group_id is null ) THEN
408: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');
409: FND_MESSAGE.set_token('NAME' , 'TOKEN-COST GROUP' , TRUE);
410: FND_MESSAGE.set_token('VALUE' , P_param_data.cost_group_id);
411: FND_MSG_PUB.add;
412: X_return_status := FND_API.G_RET_STS_ERROR;
413: END IF;
414: END IF;
415:

Line 430: FND_MSG_PUB.add;

426: IF ( wacrec.class_code is null ) THEN
427: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');
428: FND_MESSAGE.set_token('NAME' , 'TOKEN-WIP ACCT CLASS' , TRUE);
429: FND_MESSAGE.set_token('VALUE' , P_param_data.wip_acct_class_code);
430: FND_MSG_PUB.add;
431: X_return_status := FND_API.G_RET_STS_ERROR;
432: END IF;
433: END IF;
434:

Line 449: FND_MSG_PUB.add;

445: IF ( wacrec.class_code is null ) THEN
446: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');
447: FND_MESSAGE.set_token('NAME' , 'TOKEN-EAM ACCT CLASS' , TRUE);
448: FND_MESSAGE.set_token('VALUE' , P_param_data.eam_acct_class_code);
449: FND_MSG_PUB.add;
450: X_return_status := FND_API.G_RET_STS_ERROR;
451: END IF;
452: END IF;
453:

Line 465: FND_MSG_PUB.add;

461: IF ( etrec.expenditure_type is null ) THEN
462: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');
463: FND_MESSAGE.set_token('NAME' , 'TOKEN-IPV EXPENDITURE TYPE' , TRUE);
464: FND_MESSAGE.set_token('VALUE' , P_param_data.ipv_expenditure_type);
465: FND_MSG_PUB.add;
466: X_return_status := FND_API.G_RET_STS_ERROR;
467: END IF;
468: END IF;
469:

Line 478: FND_MSG_PUB.add;

474: IF ( etrec.expenditure_type is null ) THEN
475: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');
476: FND_MESSAGE.set_token('NAME' , 'TOKEN-ERV EXPENDITURE TYPE' , TRUE);
477: FND_MESSAGE.set_token('VALUE' , P_param_data.erv_expenditure_type);
478: FND_MSG_PUB.add;
479: X_return_status := FND_API.G_RET_STS_ERROR;
480: END IF;
481: END IF;
482:

Line 491: FND_MSG_PUB.add;

487: IF ( etrec.expenditure_type is null ) THEN
488: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');
489: FND_MESSAGE.set_token('NAME' , 'TOKEN-FREIGHT EXPENDITURE TYPE' , TRUE);
490: FND_MESSAGE.set_token('VALUE' , P_param_data.freight_expenditure_type);
491: FND_MSG_PUB.add;
492: X_return_status := FND_API.G_RET_STS_ERROR;
493: END IF;
494: END IF;
495:

Line 504: FND_MSG_PUB.add;

500: IF ( etrec.expenditure_type is null ) THEN
501: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');
502: FND_MESSAGE.set_token('NAME' , 'TOKEN-TAX EXPENDITURE TYPE' , TRUE);
503: FND_MESSAGE.set_token('VALUE' , P_param_data.tax_expenditure_type);
504: FND_MSG_PUB.add;
505: X_return_status := FND_API.G_RET_STS_ERROR;
506: END IF;
507: END IF;
508:

Line 517: FND_MSG_PUB.add;

513: IF ( etrec.expenditure_type is null ) THEN
514: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');
515: FND_MESSAGE.set_token('NAME' , 'TOKEN-MISC EXPENDITURE TYPE' , TRUE);
516: FND_MESSAGE.set_token('VALUE' , P_param_data.misc_expenditure_type);
517: FND_MSG_PUB.add;
518: X_return_status := FND_API.G_RET_STS_ERROR;
519: END IF;
520: END IF;
521:

Line 530: FND_MSG_PUB.add;

526: IF ( etrec.expenditure_type is null ) THEN
527: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');
528: FND_MESSAGE.set_token('NAME' , 'TOKEN-PPV EXPENDITURE TYPE' , TRUE);
529: FND_MESSAGE.set_token('VALUE' , P_param_data.ppv_expenditure_type);
530: FND_MSG_PUB.add;
531: X_return_status := FND_API.G_RET_STS_ERROR;
532: END IF;
533: END IF;
534:

Line 543: FND_MSG_PUB.add;

539: IF ( etrec.expenditure_type is null ) THEN
540: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');
541: FND_MESSAGE.set_token('NAME' , 'TOKEN-DIRITEM EXPENDITURE TYPE' , TRUE);
542: FND_MESSAGE.set_token('VALUE' , P_param_data.dir_item_expenditure_type);
543: FND_MSG_PUB.add;
544: X_return_status := FND_API.G_RET_STS_ERROR;
545: END IF;
546: END IF;
547:

Line 590: FND_MSG_PUB.add_exc_msg

586: ( appl_short_name => 'PJM'
587: , desc_flex_name => 'PJM_PROJECT_PARAMETERS'
588: , values_or_ids => 'I' ) THEN
589:
590: FND_MSG_PUB.add_exc_msg
591: ( p_pkg_name => G_PKG_NAME
592: , p_procedure_name => 'VALIDATE_DATA'
593: , p_error_text => substr(FND_FLEX_DESCVAL.error_message, 1, 240 ));
594: X_return_status := FND_API.G_RET_STS_ERROR;

Line 600: FND_MSG_PUB.add_exc_msg

596: END IF;
597:
598: EXCEPTION
599: WHEN OTHERS THEN
600: FND_MSG_PUB.add_exc_msg
601: ( p_pkg_name => G_pkg_name
602: , p_procedure_name => 'VALIDATE_DATA' );
603: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
604:

Line 650: FND_MSG_PUB.initialize;

646: --
647: -- Initialize the message table if requested.
648: --
649: IF FND_API.to_boolean( P_init_msg_list ) THEN
650: FND_MSG_PUB.initialize;
651: END IF;
652:
653: --
654: -- Set API return status to success

Line 739: FND_MSG_PUB.count_and_get( p_count => X_msg_count

735: --
736: -- Standard call to get message count and if count is 1, get message
737: -- info
738: --
739: FND_MSG_PUB.count_and_get( p_count => X_msg_count
740: , p_data => X_msg_data );
741:
742: EXCEPTION
743: WHEN FND_API.G_EXC_ERROR THEN

Line 746: FND_MSG_PUB.count_and_get( p_count => X_msg_count

742: EXCEPTION
743: WHEN FND_API.G_EXC_ERROR THEN
744: ROLLBACK TO create_project_param;
745: X_Return_Status := FND_API.G_RET_STS_ERROR;
746: FND_MSG_PUB.count_and_get( p_count => X_msg_count
747: , p_data => X_msg_data );
748:
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: ROLLBACK TO create_project_param;

Line 752: FND_MSG_PUB.count_and_get( p_count => X_msg_count

748:
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: ROLLBACK TO create_project_param;
751: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
752: FND_MSG_PUB.count_and_get( p_count => X_msg_count
753: , p_data => X_msg_data );
754:
755: WHEN OTHERS THEN
756: ROLLBACK TO create_project_param;

Line 758: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

754:
755: WHEN OTHERS THEN
756: ROLLBACK TO create_project_param;
757: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
758: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
759: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name
760: , p_procedure_name => l_api_name);
761: END IF;
762: FND_MSG_PUB.count_and_get( p_count => X_msg_count

Line 759: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name

755: WHEN OTHERS THEN
756: ROLLBACK TO create_project_param;
757: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
758: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
759: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name
760: , p_procedure_name => l_api_name);
761: END IF;
762: FND_MSG_PUB.count_and_get( p_count => X_msg_count
763: , p_data => X_msg_data );

Line 762: FND_MSG_PUB.count_and_get( p_count => X_msg_count

758: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
759: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name
760: , p_procedure_name => l_api_name);
761: END IF;
762: FND_MSG_PUB.count_and_get( p_count => X_msg_count
763: , p_data => X_msg_data );
764:
765: END create_project_parameter;
766:

Line 804: FND_MSG_PUB.initialize;

800: --
801: -- Initialize the message table if requested.
802: --
803: IF FND_API.to_boolean( P_init_msg_list ) THEN
804: FND_MSG_PUB.initialize;
805: END IF;
806:
807: --
808: -- Set API return status to success

Line 843: FND_MSG_PUB.count_and_get( p_count => X_msg_count

839: --
840: -- Standard call to get message count and if count is 1, get message
841: -- info
842: --
843: FND_MSG_PUB.count_and_get( p_count => X_msg_count
844: , p_data => X_msg_data );
845:
846: EXCEPTION
847: WHEN FND_API.G_EXC_ERROR THEN

Line 850: FND_MSG_PUB.count_and_get( p_count => X_msg_count

846: EXCEPTION
847: WHEN FND_API.G_EXC_ERROR THEN
848: ROLLBACK TO create_project_param;
849: X_Return_Status := FND_API.G_RET_STS_ERROR;
850: FND_MSG_PUB.count_and_get( p_count => X_msg_count
851: , p_data => X_msg_data );
852:
853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
854: ROLLBACK TO create_project_param;

Line 856: FND_MSG_PUB.count_and_get( p_count => X_msg_count

852:
853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
854: ROLLBACK TO create_project_param;
855: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
856: FND_MSG_PUB.count_and_get( p_count => X_msg_count
857: , p_data => X_msg_data );
858:
859: WHEN OTHERS THEN
860: ROLLBACK TO create_project_param;

Line 862: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

858:
859: WHEN OTHERS THEN
860: ROLLBACK TO create_project_param;
861: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
862: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
863: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name
864: , p_procedure_name => l_api_name);
865: END IF;
866: FND_MSG_PUB.count_and_get( p_count => X_msg_count

Line 863: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name

859: WHEN OTHERS THEN
860: ROLLBACK TO create_project_param;
861: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
862: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
863: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name
864: , p_procedure_name => l_api_name);
865: END IF;
866: FND_MSG_PUB.count_and_get( p_count => X_msg_count
867: , p_data => X_msg_data );

Line 866: FND_MSG_PUB.count_and_get( p_count => X_msg_count

862: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
863: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name
864: , p_procedure_name => l_api_name);
865: END IF;
866: FND_MSG_PUB.count_and_get( p_count => X_msg_count
867: , p_data => X_msg_data );
868:
869: END create_project_parameter;
870:

Line 919: FND_MSG_PUB.initialize;

915: --
916: -- Initialize the message table if requested.
917: --
918: IF FND_API.to_boolean( P_init_msg_list ) THEN
919: FND_MSG_PUB.initialize;
920: END IF;
921:
922: --
923: -- Set API return status to success

Line 936: FND_MSG_PUB.add;

932: IF ( l_planning_group is null ) THEN
933: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');
934: FND_MESSAGE.set_token('NAME' , 'TOKEN-PLANNING GROUP' , TRUE);
935: FND_MESSAGE.set_token('VALUE' , P_planning_group);
936: FND_MSG_PUB.add;
937: RAISE FND_API.G_EXC_ERROR;
938: END IF;
939: END IF;
940:

Line 956: FND_MSG_PUB.count_and_get( p_count => X_msg_count

952: --
953: -- Standard call to get message count and if count is 1, get message
954: -- info
955: --
956: FND_MSG_PUB.count_and_get( p_count => X_msg_count
957: , p_data => X_msg_data );
958:
959: EXCEPTION
960: WHEN FND_API.G_EXC_ERROR THEN

Line 963: FND_MSG_PUB.count_and_get( p_count => X_msg_count

959: EXCEPTION
960: WHEN FND_API.G_EXC_ERROR THEN
961: ROLLBACK TO update_planning_group;
962: X_Return_Status := FND_API.G_RET_STS_ERROR;
963: FND_MSG_PUB.count_and_get( p_count => X_msg_count
964: , p_data => X_msg_data );
965:
966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
967: ROLLBACK TO update_planning_group;

Line 969: FND_MSG_PUB.count_and_get( p_count => X_msg_count

965:
966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
967: ROLLBACK TO update_planning_group;
968: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
969: FND_MSG_PUB.count_and_get( p_count => X_msg_count
970: , p_data => X_msg_data );
971:
972: WHEN OTHERS THEN
973: ROLLBACK TO update_planning_group;

Line 975: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

971:
972: WHEN OTHERS THEN
973: ROLLBACK TO update_planning_group;
974: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
975: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
976: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name
977: , p_procedure_name => l_api_name);
978: END IF;
979: FND_MSG_PUB.count_and_get( p_count => X_msg_count

Line 976: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name

972: WHEN OTHERS THEN
973: ROLLBACK TO update_planning_group;
974: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
975: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
976: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name
977: , p_procedure_name => l_api_name);
978: END IF;
979: FND_MSG_PUB.count_and_get( p_count => X_msg_count
980: , p_data => X_msg_data );

Line 979: FND_MSG_PUB.count_and_get( p_count => X_msg_count

975: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
976: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name
977: , p_procedure_name => l_api_name);
978: END IF;
979: FND_MSG_PUB.count_and_get( p_count => X_msg_count
980: , p_data => X_msg_data );
981:
982: END update_planning_group;
983: