DBA Data[Home] [Help]

APPS.PSB_EXCEL2_PVT dependencies on FND_MESSAGE

Line 414: FND_MESSAGE.SET_NAME('PSB', 'PSB_IMPORT_NOT_ALLOWED');

410: IF exp_ws_cur%FOUND THEN
411:
412:
413: IF ( nvl(Recinfo.selected_stage_id,0) > 0 ) THEN
414: FND_MESSAGE.SET_NAME('PSB', 'PSB_IMPORT_NOT_ALLOWED');
415: FND_MSG_PUB.Add;
416: RAISE FND_API.G_EXC_ERROR ;
417: END IF;
418:

Line 428: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_ARGUMENT');

424: g_budget_by_position := Recinfo.budget_by_position;
425: g_current_stage_seq := Recinfo.stage_id;
426:
427: ELSE
428: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_ARGUMENT');
429: FND_MESSAGE.SET_TOKEN('ROUTINE', 'Import Worksheet Procedure' );
430: FND_MSG_PUB.Add;
431: RAISE FND_API.G_EXC_ERROR ;
432: END IF;

Line 429: FND_MESSAGE.SET_TOKEN('ROUTINE', 'Import Worksheet Procedure' );

425: g_current_stage_seq := Recinfo.stage_id;
426:
427: ELSE
428: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_ARGUMENT');
429: FND_MESSAGE.SET_TOKEN('ROUTINE', 'Import Worksheet Procedure' );
430: FND_MSG_PUB.Add;
431: RAISE FND_API.G_EXC_ERROR ;
432: END IF;
433: CLOSE exp_ws_cur;

Line 449: FND_MESSAGE.SET_NAME('PSB', 'PSB_IMPORT_NOT_ALLOWED');

445: LOOP
446:
447: IF g_current_stage_seq <> ws_rec.current_stage_seq
448: OR nvl(ws_rec.freeze_flag,'N') = 'Y' THEN
449: FND_MESSAGE.SET_NAME('PSB', 'PSB_IMPORT_NOT_ALLOWED');
450: FND_MSG_PUB.Add;
451: RAISE FND_API.G_EXC_ERROR ;
452: END IF;
453:

Line 497: FND_MESSAGE.SET_NAME('PSB', 'PSB_IMPORT_NOT_ALLOWED');

493: END IF;
494:
495: -- Rewritten Code
496: IF l_import_accounts and ( nvl(l_selected_template_id,0) > 0 ) THEN
497: FND_MESSAGE.SET_NAME('PSB', 'PSB_IMPORT_NOT_ALLOWED');
498: FND_MSG_PUB.Add;
499: RAISE FND_API.G_EXC_ERROR;
500: END IF;
501:

Line 510: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_ARGUMENT');

506: END IF;
507:
508: IF ( not l_import_accounts) AND
509: ( not l_import_positions) THEN
510: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_ARGUMENT');
511: FND_MESSAGE.SET_TOKEN('ROUTINE', 'Import Worksheet Procedure' );
512: FND_MSG_PUB.Add;
513: RAISE FND_API.G_EXC_ERROR ;
514: END IF;

Line 511: FND_MESSAGE.SET_TOKEN('ROUTINE', 'Import Worksheet Procedure' );

507:
508: IF ( not l_import_accounts) AND
509: ( not l_import_positions) THEN
510: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_ARGUMENT');
511: FND_MESSAGE.SET_TOKEN('ROUTINE', 'Import Worksheet Procedure' );
512: FND_MSG_PUB.Add;
513: RAISE FND_API.G_EXC_ERROR ;
514: END IF;
515:

Line 565: FND_MESSAGE.SET_NAME('PSB', 'PSB_IMPORT_SERVICE_PACKAGE');

561: p_pp_start_date => g_pp_start_date
562: );
563:
564: -- Create or Get Service Package IDs for Service Package name
565: FND_MESSAGE.SET_NAME('PSB', 'PSB_IMPORT_SERVICE_PACKAGE');
566: g_translated_sp_desc := FND_MESSAGE.GET;
567:
568: -- Get Base Service Package ID to improve performance
569: FND_MESSAGE.SET_NAME('PSB', 'PSB_BASE_SERVICE_PACKAGE');

Line 566: g_translated_sp_desc := FND_MESSAGE.GET;

562: );
563:
564: -- Create or Get Service Package IDs for Service Package name
565: FND_MESSAGE.SET_NAME('PSB', 'PSB_IMPORT_SERVICE_PACKAGE');
566: g_translated_sp_desc := FND_MESSAGE.GET;
567:
568: -- Get Base Service Package ID to improve performance
569: FND_MESSAGE.SET_NAME('PSB', 'PSB_BASE_SERVICE_PACKAGE');
570: g_translated_base_sp_name := FND_MESSAGE.GET;

Line 569: FND_MESSAGE.SET_NAME('PSB', 'PSB_BASE_SERVICE_PACKAGE');

565: FND_MESSAGE.SET_NAME('PSB', 'PSB_IMPORT_SERVICE_PACKAGE');
566: g_translated_sp_desc := FND_MESSAGE.GET;
567:
568: -- Get Base Service Package ID to improve performance
569: FND_MESSAGE.SET_NAME('PSB', 'PSB_BASE_SERVICE_PACKAGE');
570: g_translated_base_sp_name := FND_MESSAGE.GET;
571: Get_SPID(p_worksheet_id => g_global_worksheet_id,
572: p_spname => g_translated_base_sp_name,
573: p_spid => g_base_spid

Line 570: g_translated_base_sp_name := FND_MESSAGE.GET;

566: g_translated_sp_desc := FND_MESSAGE.GET;
567:
568: -- Get Base Service Package ID to improve performance
569: FND_MESSAGE.SET_NAME('PSB', 'PSB_BASE_SERVICE_PACKAGE');
570: g_translated_base_sp_name := FND_MESSAGE.GET;
571: Get_SPID(p_worksheet_id => g_global_worksheet_id,
572: p_spname => g_translated_base_sp_name,
573: p_spid => g_base_spid
574: );

Line 1142: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_CC_SEG');

1138: validated_acct := TRUE;
1139: l_budget_group_id := va_budget_group_id;
1140: ELSE
1141: l_validation_status := FND_API.G_RET_STS_ERROR;
1142: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_CC_SEG');
1143: FND_MESSAGE.SET_TOKEN('CC', l_concatenated_account );
1144: FND_MSG_PUB.Add;
1145: RAISE FND_API.G_EXC_ERROR;
1146: END IF;

Line 1143: FND_MESSAGE.SET_TOKEN('CC', l_concatenated_account );

1139: l_budget_group_id := va_budget_group_id;
1140: ELSE
1141: l_validation_status := FND_API.G_RET_STS_ERROR;
1142: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_CC_SEG');
1143: FND_MESSAGE.SET_TOKEN('CC', l_concatenated_account );
1144: FND_MSG_PUB.Add;
1145: RAISE FND_API.G_EXC_ERROR;
1146: END IF;
1147:

Line 1731: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_ELEMENT_SET');

1727: p_found_element_set => found_element_set
1728: );
1729:
1730: IF not found_element_set THEN
1731: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_ELEMENT_SET');
1732: FND_MESSAGE.SET_TOKEN('PAY_ELEMENT_ID', l_pay_element_id );
1733: FND_MESSAGE.SET_TOKEN('POSITION_LINE_ID', l_position_line_id );
1734: FND_MSG_PUB.Add;
1735: RAISE FND_API.G_EXC_ERROR ;

Line 1732: FND_MESSAGE.SET_TOKEN('PAY_ELEMENT_ID', l_pay_element_id );

1728: );
1729:
1730: IF not found_element_set THEN
1731: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_ELEMENT_SET');
1732: FND_MESSAGE.SET_TOKEN('PAY_ELEMENT_ID', l_pay_element_id );
1733: FND_MESSAGE.SET_TOKEN('POSITION_LINE_ID', l_position_line_id );
1734: FND_MSG_PUB.Add;
1735: RAISE FND_API.G_EXC_ERROR ;
1736: END IF;

Line 1733: FND_MESSAGE.SET_TOKEN('POSITION_LINE_ID', l_position_line_id );

1729:
1730: IF not found_element_set THEN
1731: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_ELEMENT_SET');
1732: FND_MESSAGE.SET_TOKEN('PAY_ELEMENT_ID', l_pay_element_id );
1733: FND_MESSAGE.SET_TOKEN('POSITION_LINE_ID', l_position_line_id );
1734: FND_MSG_PUB.Add;
1735: RAISE FND_API.G_EXC_ERROR ;
1736: END IF;
1737:

Line 1862: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_CC_SEG');

1858: validated_acct := TRUE;
1859: l_budget_group_id := va_budget_group_id;
1860: ELSE
1861: l_validation_status := FND_API.G_RET_STS_ERROR;
1862: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_CC_SEG');
1863: FND_MESSAGE.SET_TOKEN('CC', l_concatenated_account );
1864: FND_MSG_PUB.Add;
1865: RAISE FND_API.G_EXC_ERROR ;
1866: END IF;

Line 1863: FND_MESSAGE.SET_TOKEN('CC', l_concatenated_account );

1859: l_budget_group_id := va_budget_group_id;
1860: ELSE
1861: l_validation_status := FND_API.G_RET_STS_ERROR;
1862: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_CC_SEG');
1863: FND_MESSAGE.SET_TOKEN('CC', l_concatenated_account );
1864: FND_MSG_PUB.Add;
1865: RAISE FND_API.G_EXC_ERROR ;
1866: END IF;
1867:

Line 2348: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_ELEMENT_SET');

2344: p_found_element_set => found_element_set
2345: );
2346:
2347: IF not found_element_set THEN
2348: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_ELEMENT_SET');
2349: FND_MESSAGE.SET_TOKEN('PAY_ELEMENT_ID', l_pay_element_id );
2350: FND_MESSAGE.SET_TOKEN('POSITION_LINE_ID', p_position_line_id );
2351: FND_MSG_PUB.Add;
2352: RAISE FND_API.G_EXC_ERROR ;

Line 2349: FND_MESSAGE.SET_TOKEN('PAY_ELEMENT_ID', l_pay_element_id );

2345: );
2346:
2347: IF not found_element_set THEN
2348: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_ELEMENT_SET');
2349: FND_MESSAGE.SET_TOKEN('PAY_ELEMENT_ID', l_pay_element_id );
2350: FND_MESSAGE.SET_TOKEN('POSITION_LINE_ID', p_position_line_id );
2351: FND_MSG_PUB.Add;
2352: RAISE FND_API.G_EXC_ERROR ;
2353: END IF;

Line 2350: FND_MESSAGE.SET_TOKEN('POSITION_LINE_ID', p_position_line_id );

2346:
2347: IF not found_element_set THEN
2348: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_ELEMENT_SET');
2349: FND_MESSAGE.SET_TOKEN('PAY_ELEMENT_ID', l_pay_element_id );
2350: FND_MESSAGE.SET_TOKEN('POSITION_LINE_ID', p_position_line_id );
2351: FND_MSG_PUB.Add;
2352: RAISE FND_API.G_EXC_ERROR ;
2353: END IF;
2354:

Line 3673: FND_MESSAGE.SET_NAME('PSB', 'PSB_ELEMENT_OPTION_NOT_FOUND');

3669: end loop; --elem_asgn_rec
3670:
3671: if l_new_assignment_found = FND_API.G_FALSE then
3672:
3673: FND_MESSAGE.SET_NAME('PSB', 'PSB_ELEMENT_OPTION_NOT_FOUND');
3674: FND_MESSAGE.SET_TOKEN('POSITION_NAME', p_position_name);
3675: FND_MESSAGE.SET_TOKEN('PAY_ELEMENT_NAME', l_element_name);
3676: FND_MSG_PUB.Add;
3677: raise FND_API.G_EXC_ERROR;

Line 3674: FND_MESSAGE.SET_TOKEN('POSITION_NAME', p_position_name);

3670:
3671: if l_new_assignment_found = FND_API.G_FALSE then
3672:
3673: FND_MESSAGE.SET_NAME('PSB', 'PSB_ELEMENT_OPTION_NOT_FOUND');
3674: FND_MESSAGE.SET_TOKEN('POSITION_NAME', p_position_name);
3675: FND_MESSAGE.SET_TOKEN('PAY_ELEMENT_NAME', l_element_name);
3676: FND_MSG_PUB.Add;
3677: raise FND_API.G_EXC_ERROR;
3678: end if;

Line 3675: FND_MESSAGE.SET_TOKEN('PAY_ELEMENT_NAME', l_element_name);

3671: if l_new_assignment_found = FND_API.G_FALSE then
3672:
3673: FND_MESSAGE.SET_NAME('PSB', 'PSB_ELEMENT_OPTION_NOT_FOUND');
3674: FND_MESSAGE.SET_TOKEN('POSITION_NAME', p_position_name);
3675: FND_MESSAGE.SET_TOKEN('PAY_ELEMENT_NAME', l_element_name);
3676: FND_MSG_PUB.Add;
3677: raise FND_API.G_EXC_ERROR;
3678: end if;
3679:

Line 3686: FND_MESSAGE.SET_NAME('PSB', 'PSB_ELEMENT_OVERIDE_NA');

3682: -- retain the old element option if overwrite is allowed
3683: if l_overwrite_flag = 'Y' then
3684: l_new_element_option_id := l_pay_element_option_id;
3685: else
3686: FND_MESSAGE.SET_NAME('PSB', 'PSB_ELEMENT_OVERIDE_NA');
3687: FND_MESSAGE.SET_TOKEN('POSITION_NAME', p_position_name);
3688: FND_MESSAGE.SET_TOKEN('PAY_ELEMENT_NAME', l_element_name);
3689: FND_MSG_PUB.Add;
3690: raise FND_API.G_EXC_ERROR;

Line 3687: FND_MESSAGE.SET_TOKEN('POSITION_NAME', p_position_name);

3683: if l_overwrite_flag = 'Y' then
3684: l_new_element_option_id := l_pay_element_option_id;
3685: else
3686: FND_MESSAGE.SET_NAME('PSB', 'PSB_ELEMENT_OVERIDE_NA');
3687: FND_MESSAGE.SET_TOKEN('POSITION_NAME', p_position_name);
3688: FND_MESSAGE.SET_TOKEN('PAY_ELEMENT_NAME', l_element_name);
3689: FND_MSG_PUB.Add;
3690: raise FND_API.G_EXC_ERROR;
3691: end if;

Line 3688: FND_MESSAGE.SET_TOKEN('PAY_ELEMENT_NAME', l_element_name);

3684: l_new_element_option_id := l_pay_element_option_id;
3685: else
3686: FND_MESSAGE.SET_NAME('PSB', 'PSB_ELEMENT_OVERIDE_NA');
3687: FND_MESSAGE.SET_TOKEN('POSITION_NAME', p_position_name);
3688: FND_MESSAGE.SET_TOKEN('PAY_ELEMENT_NAME', l_element_name);
3689: FND_MSG_PUB.Add;
3690: raise FND_API.G_EXC_ERROR;
3691: end if;
3692: