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 355: FND_MSG_PUB.add;

351: FETCH pp INTO pprec;
352: CLOSE pp;
353: IF ( pprec.project_id is not null ) THEN
354: FND_MESSAGE.set_name('PJM' , 'GEN-PARAM RECORD EXISTS');
355: FND_MSG_PUB.add;
356: X_return_status := FND_API.G_RET_STS_ERROR;
357: return;
358: END IF;
359: END IF;

Line 367: FND_MSG_PUB.add;

363: --
364: IF ( P_param_data.start_date_active > G_proj_comp_date ) THEN
365: FND_MESSAGE.set_name('PJM' , 'FORM-PARAM START DATE INVALID');
366: FND_MESSAGE.set_token('DATE' , FND_DATE.date_to_displaydate(G_proj_comp_date));
367: FND_MSG_PUB.add;
368: X_return_status := FND_API.G_RET_STS_ERROR;
369: END IF;
370:
371: IF ( P_param_data.end_date_active < G_proj_start_date ) THEN

Line 374: FND_MSG_PUB.add;

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

Line 380: FND_MSG_PUB.add;

376: END IF;
377:
378: IF ( P_param_data.start_date_active > P_param_data.end_date_active ) THEN
379: FND_MESSAGE.set_name('PJM' , 'FORM-INVALID EFFDATE PAIR');
380: FND_MSG_PUB.add;
381: X_return_status := FND_API.G_RET_STS_ERROR;
382: END IF;
383:
384: --

Line 389: FND_MSG_PUB.add;

385: -- Make sure the control level is not task if project is seiban
386: --
387: IF ( G_seiban_flag = 1 AND G_proj_ctrl_level = 2 ) THEN
388: FND_MESSAGE.set_name('PJM' , 'GEN-TASK CONTROL NO SEIBAN');
389: FND_MSG_PUB.add;
390: X_return_status := FND_API.G_RET_STS_ERROR;
391: END IF;
392:
393: --

Line 404: FND_MSG_PUB.add;

400: IF ( cgrec.cost_group_id is null ) THEN
401: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');
402: FND_MESSAGE.set_token('NAME' , 'TOKEN-COST GROUP' , TRUE);
403: FND_MESSAGE.set_token('VALUE' , P_param_data.cost_group_id);
404: FND_MSG_PUB.add;
405: X_return_status := FND_API.G_RET_STS_ERROR;
406: END IF;
407: END IF;
408:

Line 423: FND_MSG_PUB.add;

419: IF ( wacrec.class_code is null ) THEN
420: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');
421: FND_MESSAGE.set_token('NAME' , 'TOKEN-WIP ACCT CLASS' , TRUE);
422: FND_MESSAGE.set_token('VALUE' , P_param_data.wip_acct_class_code);
423: FND_MSG_PUB.add;
424: X_return_status := FND_API.G_RET_STS_ERROR;
425: END IF;
426: END IF;
427:

Line 442: FND_MSG_PUB.add;

438: IF ( wacrec.class_code is null ) THEN
439: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');
440: FND_MESSAGE.set_token('NAME' , 'TOKEN-EAM ACCT CLASS' , TRUE);
441: FND_MESSAGE.set_token('VALUE' , P_param_data.eam_acct_class_code);
442: FND_MSG_PUB.add;
443: X_return_status := FND_API.G_RET_STS_ERROR;
444: END IF;
445: END IF;
446:

Line 458: FND_MSG_PUB.add;

454: IF ( etrec.expenditure_type is null ) THEN
455: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');
456: FND_MESSAGE.set_token('NAME' , 'TOKEN-IPV EXPENDITURE TYPE' , TRUE);
457: FND_MESSAGE.set_token('VALUE' , P_param_data.ipv_expenditure_type);
458: FND_MSG_PUB.add;
459: X_return_status := FND_API.G_RET_STS_ERROR;
460: END IF;
461: END IF;
462:

Line 471: FND_MSG_PUB.add;

467: IF ( etrec.expenditure_type is null ) THEN
468: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');
469: FND_MESSAGE.set_token('NAME' , 'TOKEN-ERV EXPENDITURE TYPE' , TRUE);
470: FND_MESSAGE.set_token('VALUE' , P_param_data.erv_expenditure_type);
471: FND_MSG_PUB.add;
472: X_return_status := FND_API.G_RET_STS_ERROR;
473: END IF;
474: END IF;
475:

Line 484: FND_MSG_PUB.add;

480: IF ( etrec.expenditure_type is null ) THEN
481: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');
482: FND_MESSAGE.set_token('NAME' , 'TOKEN-FREIGHT EXPENDITURE TYPE' , TRUE);
483: FND_MESSAGE.set_token('VALUE' , P_param_data.freight_expenditure_type);
484: FND_MSG_PUB.add;
485: X_return_status := FND_API.G_RET_STS_ERROR;
486: END IF;
487: END IF;
488:

Line 497: FND_MSG_PUB.add;

493: IF ( etrec.expenditure_type is null ) THEN
494: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');
495: FND_MESSAGE.set_token('NAME' , 'TOKEN-TAX EXPENDITURE TYPE' , TRUE);
496: FND_MESSAGE.set_token('VALUE' , P_param_data.tax_expenditure_type);
497: FND_MSG_PUB.add;
498: X_return_status := FND_API.G_RET_STS_ERROR;
499: END IF;
500: END IF;
501:

Line 510: FND_MSG_PUB.add;

506: IF ( etrec.expenditure_type is null ) THEN
507: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');
508: FND_MESSAGE.set_token('NAME' , 'TOKEN-MISC EXPENDITURE TYPE' , TRUE);
509: FND_MESSAGE.set_token('VALUE' , P_param_data.misc_expenditure_type);
510: FND_MSG_PUB.add;
511: X_return_status := FND_API.G_RET_STS_ERROR;
512: END IF;
513: END IF;
514:

Line 523: FND_MSG_PUB.add;

519: IF ( etrec.expenditure_type is null ) THEN
520: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');
521: FND_MESSAGE.set_token('NAME' , 'TOKEN-PPV EXPENDITURE TYPE' , TRUE);
522: FND_MESSAGE.set_token('VALUE' , P_param_data.ppv_expenditure_type);
523: FND_MSG_PUB.add;
524: X_return_status := FND_API.G_RET_STS_ERROR;
525: END IF;
526: END IF;
527:

Line 536: FND_MSG_PUB.add;

532: IF ( etrec.expenditure_type is null ) THEN
533: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');
534: FND_MESSAGE.set_token('NAME' , 'TOKEN-DIRITEM EXPENDITURE TYPE' , TRUE);
535: FND_MESSAGE.set_token('VALUE' , P_param_data.dir_item_expenditure_type);
536: FND_MSG_PUB.add;
537: X_return_status := FND_API.G_RET_STS_ERROR;
538: END IF;
539: END IF;
540:

Line 596: FND_MSG_PUB.add_exc_msg

592: ( appl_short_name => 'PJM'
593: , desc_flex_name => 'PJM_PROJECT_PARAMETERS'
594: , values_or_ids => 'I' ) THEN
595:
596: FND_MSG_PUB.add_exc_msg
597: ( p_pkg_name => G_PKG_NAME
598: , p_procedure_name => 'VALIDATE_DATA'
599: , p_error_text => FND_FLEX_DESCVAL.error_message );
600: X_return_status := FND_API.G_RET_STS_ERROR;

Line 606: FND_MSG_PUB.add_exc_msg

602: END IF;
603:
604: EXCEPTION
605: WHEN OTHERS THEN
606: FND_MSG_PUB.add_exc_msg
607: ( p_pkg_name => G_pkg_name
608: , p_procedure_name => 'VALIDATE_DATA' );
609: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
610:

Line 656: FND_MSG_PUB.initialize;

652: --
653: -- Initialize the message table if requested.
654: --
655: IF FND_API.to_boolean( P_init_msg_list ) THEN
656: FND_MSG_PUB.initialize;
657: END IF;
658:
659: --
660: -- Set API return status to success

Line 745: FND_MSG_PUB.count_and_get( p_count => X_msg_count

741: --
742: -- Standard call to get message count and if count is 1, get message
743: -- info
744: --
745: FND_MSG_PUB.count_and_get( p_count => X_msg_count
746: , p_data => X_msg_data );
747:
748: EXCEPTION
749: WHEN FND_API.G_EXC_ERROR THEN

Line 752: FND_MSG_PUB.count_and_get( p_count => X_msg_count

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

Line 758: FND_MSG_PUB.count_and_get( p_count => X_msg_count

754:
755: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
756: ROLLBACK TO create_project_param;
757: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
758: FND_MSG_PUB.count_and_get( p_count => X_msg_count
759: , p_data => X_msg_data );
760:
761: WHEN OTHERS THEN
762: ROLLBACK TO create_project_param;

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

760:
761: WHEN OTHERS THEN
762: ROLLBACK TO create_project_param;
763: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
764: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
765: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name
766: , p_procedure_name => l_api_name);
767: END IF;
768: FND_MSG_PUB.count_and_get( p_count => X_msg_count

Line 765: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name

761: WHEN OTHERS THEN
762: ROLLBACK TO create_project_param;
763: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
764: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
765: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name
766: , p_procedure_name => l_api_name);
767: END IF;
768: FND_MSG_PUB.count_and_get( p_count => X_msg_count
769: , p_data => X_msg_data );

Line 768: FND_MSG_PUB.count_and_get( p_count => X_msg_count

764: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
765: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name
766: , p_procedure_name => l_api_name);
767: END IF;
768: FND_MSG_PUB.count_and_get( p_count => X_msg_count
769: , p_data => X_msg_data );
770:
771: END create_project_parameter;
772:

Line 810: FND_MSG_PUB.initialize;

806: --
807: -- Initialize the message table if requested.
808: --
809: IF FND_API.to_boolean( P_init_msg_list ) THEN
810: FND_MSG_PUB.initialize;
811: END IF;
812:
813: --
814: -- Set API return status to success

Line 849: FND_MSG_PUB.count_and_get( p_count => X_msg_count

845: --
846: -- Standard call to get message count and if count is 1, get message
847: -- info
848: --
849: FND_MSG_PUB.count_and_get( p_count => X_msg_count
850: , p_data => X_msg_data );
851:
852: EXCEPTION
853: WHEN FND_API.G_EXC_ERROR THEN

Line 856: FND_MSG_PUB.count_and_get( p_count => X_msg_count

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

Line 862: FND_MSG_PUB.count_and_get( p_count => X_msg_count

858:
859: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
860: ROLLBACK TO create_project_param;
861: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
862: FND_MSG_PUB.count_and_get( p_count => X_msg_count
863: , p_data => X_msg_data );
864:
865: WHEN OTHERS THEN
866: ROLLBACK TO create_project_param;

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

864:
865: WHEN OTHERS THEN
866: ROLLBACK TO create_project_param;
867: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
868: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
869: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name
870: , p_procedure_name => l_api_name);
871: END IF;
872: FND_MSG_PUB.count_and_get( p_count => X_msg_count

Line 869: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name

865: WHEN OTHERS THEN
866: ROLLBACK TO create_project_param;
867: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
868: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
869: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name
870: , p_procedure_name => l_api_name);
871: END IF;
872: FND_MSG_PUB.count_and_get( p_count => X_msg_count
873: , p_data => X_msg_data );

Line 872: FND_MSG_PUB.count_and_get( p_count => X_msg_count

868: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
869: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name
870: , p_procedure_name => l_api_name);
871: END IF;
872: FND_MSG_PUB.count_and_get( p_count => X_msg_count
873: , p_data => X_msg_data );
874:
875: END create_project_parameter;
876:

Line 925: FND_MSG_PUB.initialize;

921: --
922: -- Initialize the message table if requested.
923: --
924: IF FND_API.to_boolean( P_init_msg_list ) THEN
925: FND_MSG_PUB.initialize;
926: END IF;
927:
928: --
929: -- Set API return status to success

Line 942: FND_MSG_PUB.add;

938: IF ( l_planning_group is null ) THEN
939: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');
940: FND_MESSAGE.set_token('NAME' , 'TOKEN-PLANNING GROUP' , TRUE);
941: FND_MESSAGE.set_token('VALUE' , P_planning_group);
942: FND_MSG_PUB.add;
943: RAISE FND_API.G_EXC_ERROR;
944: END IF;
945: END IF;
946:

Line 962: FND_MSG_PUB.count_and_get( p_count => X_msg_count

958: --
959: -- Standard call to get message count and if count is 1, get message
960: -- info
961: --
962: FND_MSG_PUB.count_and_get( p_count => X_msg_count
963: , p_data => X_msg_data );
964:
965: EXCEPTION
966: WHEN FND_API.G_EXC_ERROR THEN

Line 969: FND_MSG_PUB.count_and_get( p_count => X_msg_count

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

Line 975: FND_MSG_PUB.count_and_get( p_count => X_msg_count

971:
972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
973: ROLLBACK TO update_planning_group;
974: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
975: FND_MSG_PUB.count_and_get( p_count => X_msg_count
976: , p_data => X_msg_data );
977:
978: WHEN OTHERS THEN
979: ROLLBACK TO update_planning_group;

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

977:
978: WHEN OTHERS THEN
979: ROLLBACK TO update_planning_group;
980: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
981: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
982: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name
983: , p_procedure_name => l_api_name);
984: END IF;
985: FND_MSG_PUB.count_and_get( p_count => X_msg_count

Line 982: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name

978: WHEN OTHERS THEN
979: ROLLBACK TO update_planning_group;
980: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
981: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
982: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name
983: , p_procedure_name => l_api_name);
984: END IF;
985: FND_MSG_PUB.count_and_get( p_count => X_msg_count
986: , p_data => X_msg_data );

Line 985: FND_MSG_PUB.count_and_get( p_count => X_msg_count

981: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
982: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_pkg_name
983: , p_procedure_name => l_api_name);
984: END IF;
985: FND_MSG_PUB.count_and_get( p_count => X_msg_count
986: , p_data => X_msg_data );
987:
988: END update_planning_group;
989: