DBA Data[Home] [Help]

APPS.PJM_PROJECT_PARAM_PUB dependencies on FND_MESSAGE

Line 148: FND_MESSAGE.set_name('PJM' , 'GEN-PROJ ID INVALID');

144: OPEN pg ( G_project_id );
145: FETCH pg INTO G_planning_group;
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;

Line 149: FND_MESSAGE.set_token('ID' , X_param_data.project_id);

145: FETCH pg INTO G_planning_group;
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;

Line 183: FND_MESSAGE.set_name('PJM' , 'GEN-ORG ID INVALID');

179:
180: IF ( G_proj_ctrl_level is not null ) THEN
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;

Line 184: FND_MESSAGE.set_token('ID' , X_param_data.organization_id);

180: IF ( G_proj_ctrl_level is not null ) THEN
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;

Line 361: FND_MESSAGE.set_name('PJM' , 'GEN-PARAM RECORD EXISTS');

357: OPEN pp ( P_param_data.organization_id , P_param_data.project_id );
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;

Line 372: FND_MESSAGE.set_name('PJM' , 'FORM-PARAM START DATE INVALID');

368: --
369: -- Make sure start / end dates are valid
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;

Line 373: FND_MESSAGE.set_token('DATE' , FND_DATE.date_to_displaydate(dateval=>G_proj_comp_date, calendar_aware=>2));

369: -- Make sure start / end dates are valid
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:

Line 379: FND_MESSAGE.set_name('PJM' , 'FORM-PARAM END DATE INVALID');

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
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;

Line 380: FND_MESSAGE.set_token('DATE' , FND_DATE.date_to_displaydate(dateval=>G_proj_start_date, calendar_aware=>2));

376: END IF;
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:

Line 386: FND_MESSAGE.set_name('PJM' , 'FORM-INVALID EFFDATE PAIR');

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
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:

Line 395: FND_MESSAGE.set_name('PJM' , 'GEN-TASK CONTROL NO SEIBAN');

391: --
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:

Line 408: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');

404: OPEN cg ( P_param_data.organization_id , P_param_data.cost_group_id );
405: FETCH cg INTO cgrec;
406: CLOSE cg;
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;

Line 409: FND_MESSAGE.set_token('NAME' , 'TOKEN-COST GROUP' , TRUE);

405: FETCH cg INTO cgrec;
406: CLOSE cg;
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;

Line 410: FND_MESSAGE.set_token('VALUE' , P_param_data.cost_group_id);

406: CLOSE cg;
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;

Line 427: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');

423: , 1 );
424: FETCH wac INTO wacrec;
425: CLOSE wac;
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;

Line 428: FND_MESSAGE.set_token('NAME' , 'TOKEN-WIP ACCT CLASS' , TRUE);

424: FETCH wac INTO wacrec;
425: CLOSE wac;
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;

Line 429: FND_MESSAGE.set_token('VALUE' , P_param_data.wip_acct_class_code);

425: CLOSE wac;
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;

Line 446: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');

442: , 6 );
443: FETCH wac INTO wacrec;
444: CLOSE wac;
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;

Line 447: FND_MESSAGE.set_token('NAME' , 'TOKEN-EAM ACCT CLASS' , TRUE);

443: FETCH wac INTO wacrec;
444: CLOSE wac;
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;

Line 448: FND_MESSAGE.set_token('VALUE' , P_param_data.eam_acct_class_code);

444: CLOSE wac;
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;

Line 462: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');

458: OPEN et ( P_param_data.ipv_expenditure_type , 1 );
459: FETCH et INTO etrec;
460: CLOSE et;
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;

Line 463: FND_MESSAGE.set_token('NAME' , 'TOKEN-IPV EXPENDITURE TYPE' , TRUE);

459: FETCH et INTO etrec;
460: CLOSE et;
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;

Line 464: FND_MESSAGE.set_token('VALUE' , P_param_data.ipv_expenditure_type);

460: CLOSE et;
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;

Line 475: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');

471: OPEN et ( P_param_data.erv_expenditure_type , 1 );
472: FETCH et INTO etrec;
473: CLOSE et;
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;

Line 476: FND_MESSAGE.set_token('NAME' , 'TOKEN-ERV EXPENDITURE TYPE' , TRUE);

472: FETCH et INTO etrec;
473: CLOSE et;
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;

Line 477: FND_MESSAGE.set_token('VALUE' , P_param_data.erv_expenditure_type);

473: CLOSE et;
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;

Line 488: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');

484: OPEN et ( P_param_data.freight_expenditure_type , 1 );
485: FETCH et INTO etrec;
486: CLOSE et;
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;

Line 489: FND_MESSAGE.set_token('NAME' , 'TOKEN-FREIGHT EXPENDITURE TYPE' , TRUE);

485: FETCH et INTO etrec;
486: CLOSE et;
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;

Line 490: FND_MESSAGE.set_token('VALUE' , P_param_data.freight_expenditure_type);

486: CLOSE et;
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;

Line 501: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');

497: OPEN et ( P_param_data.tax_expenditure_type , 1 );
498: FETCH et INTO etrec;
499: CLOSE et;
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;

Line 502: FND_MESSAGE.set_token('NAME' , 'TOKEN-TAX EXPENDITURE TYPE' , TRUE);

498: FETCH et INTO etrec;
499: CLOSE et;
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;

Line 503: FND_MESSAGE.set_token('VALUE' , P_param_data.tax_expenditure_type);

499: CLOSE et;
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;

Line 514: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');

510: OPEN et ( P_param_data.misc_expenditure_type , 1 );
511: FETCH et INTO etrec;
512: CLOSE et;
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;

Line 515: FND_MESSAGE.set_token('NAME' , 'TOKEN-MISC EXPENDITURE TYPE' , TRUE);

511: FETCH et INTO etrec;
512: CLOSE et;
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;

Line 516: FND_MESSAGE.set_token('VALUE' , P_param_data.misc_expenditure_type);

512: CLOSE et;
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;

Line 527: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');

523: OPEN et ( P_param_data.ppv_expenditure_type , 1 );
524: FETCH et INTO etrec;
525: CLOSE et;
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;

Line 528: FND_MESSAGE.set_token('NAME' , 'TOKEN-PPV EXPENDITURE TYPE' , TRUE);

524: FETCH et INTO etrec;
525: CLOSE et;
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;

Line 529: FND_MESSAGE.set_token('VALUE' , P_param_data.ppv_expenditure_type);

525: CLOSE et;
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;

Line 540: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');

536: OPEN et ( P_param_data.dir_item_expenditure_type , 4 );
537: FETCH et INTO etrec;
538: CLOSE et;
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;

Line 541: FND_MESSAGE.set_token('NAME' , 'TOKEN-DIRITEM EXPENDITURE TYPE' , TRUE);

537: FETCH et INTO etrec;
538: CLOSE et;
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;

Line 542: FND_MESSAGE.set_token('VALUE' , P_param_data.dir_item_expenditure_type);

538: CLOSE et;
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;

Line 933: FND_MESSAGE.set_name('PJM' , 'GEN-INVALID VALUE');

929: --
930: IF ( P_planning_group is not null ) THEN
931: OPEN pg; FETCH pg INTO l_planning_group; CLOSE pg;
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;

Line 934: FND_MESSAGE.set_token('NAME' , 'TOKEN-PLANNING GROUP' , TRUE);

930: IF ( P_planning_group is not null ) THEN
931: OPEN pg; FETCH pg INTO l_planning_group; CLOSE pg;
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;

Line 935: FND_MESSAGE.set_token('VALUE' , P_planning_group);

931: OPEN pg; FETCH pg INTO l_planning_group; CLOSE pg;
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;