DBA Data[Home] [Help]

APPS.PSB_EXCEL2_PVT dependencies on FND_MSG_PUB

Line 388: FND_MSG_PUB.initialize ;

384: END IF;
385: --
386:
387: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
388: FND_MSG_PUB.initialize ;
389: END IF;
390: --
391: p_return_status := FND_API.G_RET_STS_SUCCESS ;
392: --

Line 415: FND_MSG_PUB.Add;

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:
419: l_selected_template_id := Recinfo.selected_template_id;

Line 430: FND_MSG_PUB.Add;

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

Line 450: FND_MSG_PUB.Add;

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:
454: g_global_worksheet_flag := ws_rec.global_worksheet_flag;

Line 498: FND_MSG_PUB.Add;

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:
502: IF l_import_ws_type IN ('P','B') and

Line 512: FND_MSG_PUB.Add;

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

Line 606: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

602: WHEN FND_API.G_EXC_ERROR THEN
603: --
604: ROLLBACK TO Move_To_PSB_Pvt;
605: p_return_status := FND_API.G_RET_STS_ERROR;
606: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
607: p_data => p_msg_data );
608: --
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
610: --

Line 613: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
610: --
611: ROLLBACK TO Move_To_PSB_Pvt;
612: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
613: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
614: p_data => p_msg_data );
615: --
616: WHEN OTHERS THEN
617: --

Line 621: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

617: --
618: ROLLBACK TO Move_To_PSB_Pvt;
619: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
620: --
621: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
622: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
623: l_api_name);
624: END IF;
625: --

Line 622: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

618: ROLLBACK TO Move_To_PSB_Pvt;
619: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
620: --
621: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
622: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
623: l_api_name);
624: END IF;
625: --
626: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 626: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

622: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
623: l_api_name);
624: END IF;
625: --
626: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
627: p_data => p_msg_data );
628: --
629: END Move_To_PSB;
630:

Line 1144: FND_MSG_PUB.Add;

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:
1148: END IF; -- if not validated even once for the record

Line 1734: FND_MSG_PUB.Add;

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:
1738: old_acct := FALSE;

Line 1864: FND_MSG_PUB.Add;

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

Line 2351: FND_MSG_PUB.Add;

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:
2355: -- For each pay element

Line 3676: FND_MSG_PUB.Add;

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:
3680: elsif l_option_flag = 'N' then

Line 3689: FND_MSG_PUB.Add;

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