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 354: FND_MESSAGE.set_name('PJM' , 'GEN-PARAM RECORD EXISTS');

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

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

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

Line 366: FND_MESSAGE.set_token('DATE' , FND_DATE.date_to_displaydate(G_proj_comp_date));

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

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

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

Line 373: FND_MESSAGE.set_token('DATE' , FND_DATE.date_to_displaydate(G_proj_start_date));

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

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

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

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

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

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

397: OPEN cg ( P_param_data.organization_id , P_param_data.cost_group_id );
398: FETCH cg INTO cgrec;
399: CLOSE cg;
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;

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

398: FETCH cg INTO cgrec;
399: CLOSE cg;
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;

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

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

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

416: , 1 );
417: FETCH wac INTO wacrec;
418: CLOSE wac;
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;

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

417: FETCH wac INTO wacrec;
418: CLOSE wac;
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;

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

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

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

435: , 6 );
436: FETCH wac INTO wacrec;
437: CLOSE wac;
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;

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

436: FETCH wac INTO wacrec;
437: CLOSE wac;
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;

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

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

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

451: OPEN et ( P_param_data.ipv_expenditure_type , 1 );
452: FETCH et INTO etrec;
453: CLOSE et;
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;

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

452: FETCH et INTO etrec;
453: CLOSE et;
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;

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

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

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

464: OPEN et ( P_param_data.erv_expenditure_type , 1 );
465: FETCH et INTO etrec;
466: CLOSE et;
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;

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

465: FETCH et INTO etrec;
466: CLOSE et;
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;

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

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

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

477: OPEN et ( P_param_data.freight_expenditure_type , 1 );
478: FETCH et INTO etrec;
479: CLOSE et;
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;

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

478: FETCH et INTO etrec;
479: CLOSE et;
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;

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

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

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

490: OPEN et ( P_param_data.tax_expenditure_type , 1 );
491: FETCH et INTO etrec;
492: CLOSE et;
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;

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

491: FETCH et INTO etrec;
492: CLOSE et;
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;

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

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

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

503: OPEN et ( P_param_data.misc_expenditure_type , 1 );
504: FETCH et INTO etrec;
505: CLOSE et;
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;

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

504: FETCH et INTO etrec;
505: CLOSE et;
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;

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

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

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

516: OPEN et ( P_param_data.ppv_expenditure_type , 1 );
517: FETCH et INTO etrec;
518: CLOSE et;
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;

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

517: FETCH et INTO etrec;
518: CLOSE et;
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;

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

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

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

529: OPEN et ( P_param_data.dir_item_expenditure_type , 4 );
530: FETCH et INTO etrec;
531: CLOSE et;
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;

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

530: FETCH et INTO etrec;
531: CLOSE et;
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;

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

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

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

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

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

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

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

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