DBA Data[Home] [Help]

APPS.QP_VALIDATE_FNA dependencies on OE_MSG_PUB

Line 60: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

56: THEN
57:
58: l_return_status := FND_API.G_RET_STS_ERROR;
59:
60: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
61: THEN
62:
63: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
64: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PTE_SOURCESYSTEM_FNAREA_ID');

Line 65: OE_MSG_PUB.Add;

61: THEN
62:
63: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
64: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PTE_SOURCESYSTEM_FNAREA_ID');
65: OE_MSG_PUB.Add;
66:
67: END IF;
68:
69: END IF;

Line 80: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

76: THEN
77:
78: l_return_status := FND_API.G_RET_STS_ERROR;
79:
80: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
81: THEN
82:
83: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
84: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PTE_SOURCE_SYSTEM_ID');

Line 85: OE_MSG_PUB.Add;

81: THEN
82:
83: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
84: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PTE_SOURCE_SYSTEM_ID');
85: OE_MSG_PUB.Add;
86:
87: END IF;
88:
89: END IF;

Line 96: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

92: THEN
93:
94: l_return_status := FND_API.G_RET_STS_ERROR;
95:
96: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
97: THEN
98:
99: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
100: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','FUNCTIONAL_AREA_ID');

Line 101: OE_MSG_PUB.Add;

97: THEN
98:
99: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
100: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','FUNCTIONAL_AREA_ID');
101: OE_MSG_PUB.Add;
102:
103: END IF;
104:
105: END IF;

Line 138: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

134: EXCEPTION
135: WHEN NO_DATA_FOUND THEN
136: l_return_status := FND_API.G_RET_STS_ERROR;
137:
138: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
139: THEN
140: select pte_code, application_short_name
141: into l_pte, l_ss
142: from qp_pte_source_systems

Line 149: OE_MSG_PUB.Add;

145: FND_MESSAGE.SET_NAME('QP','QP_INVALID_FUNC_AREA');
146: FND_MESSAGE.SET_TOKEN('FNID', p_FNA_rec.functional_area_id);
147: FND_MESSAGE.SET_TOKEN('PTE', l_pte);
148: FND_MESSAGE.SET_TOKEN('SS', l_ss);
149: OE_MSG_PUB.Add;
150: END IF;
151: END;
152:
153:

Line 161: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

157: p_FNA_rec.pte_source_system_id) THEN
158:
159: l_return_status := FND_API.G_RET_STS_ERROR;
160:
161: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
162: THEN
163: select pte_code, application_short_name
164: into l_pte, l_ss
165: from qp_pte_source_systems

Line 177: OE_MSG_PUB.Add;

173: FND_MESSAGE.SET_NAME('QP','QP_DUP_FUNC_AREA_WITHIN_PTE');
174: FND_MESSAGE.SET_TOKEN('FNAREA', l_fnarea);
175: FND_MESSAGE.SET_TOKEN('PTE', l_pte);
176: FND_MESSAGE.SET_TOKEN('SS', l_ss);
177: OE_MSG_PUB.Add;
178: END IF;
179:
180: END IF;
181:

Line 222: IF l_seed_err AND OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

218: END IF;
219: END IF;
220:
221:
222: IF l_seed_err AND OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
223: THEN
224: l_return_status := FND_API.G_RET_STS_ERROR;
225: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_SEED_FUNC_AREAS');
226: OE_MSG_PUB.Add;

Line 226: OE_MSG_PUB.Add;

222: IF l_seed_err AND OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
223: THEN
224: l_return_status := FND_API.G_RET_STS_ERROR;
225: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_SEED_FUNC_AREAS');
226: OE_MSG_PUB.Add;
227: END IF;
228: END IF;
229:
230:

Line 257: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

253: WHEN OTHERS THEN
254:
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
256:
257: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
258: THEN
259: OE_MSG_PUB.Add_Exc_Msg
260: ( G_PKG_NAME
261: , 'Entity'

Line 259: OE_MSG_PUB.Add_Exc_Msg

255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
256:
257: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
258: THEN
259: OE_MSG_PUB.Add_Exc_Msg
260: ( G_PKG_NAME
261: , 'Entity'
262: );
263: END IF;

Line 582: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

578: WHEN OTHERS THEN
579:
580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581:
582: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
583: THEN
584: OE_MSG_PUB.Add_Exc_Msg
585: ( G_PKG_NAME
586: , 'Attributes'

Line 584: OE_MSG_PUB.Add_Exc_Msg

580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581:
582: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
583: THEN
584: OE_MSG_PUB.Add_Exc_Msg
585: ( G_PKG_NAME
586: , 'Attributes'
587: );
588: END IF;

Line 620: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

616: into l_fnarea
617: from mtl_default_category_sets_fk_v
618: where functional_area_id = p_FNA_rec.functional_area_id;
619:
620: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
621: THEN
622:
623: FND_MESSAGE.SET_NAME('QP', 'QP_DEL_FUNC_AREA_NOT_ALLOW');
624: FND_MESSAGE.SET_TOKEN('FNAREA', l_fnarea);

Line 627: OE_MSG_PUB.Add;

623: FND_MESSAGE.SET_NAME('QP', 'QP_DEL_FUNC_AREA_NOT_ALLOW');
624: FND_MESSAGE.SET_TOKEN('FNAREA', l_fnarea);
625: FND_MESSAGE.SET_TOKEN('PTE', l_pte);
626: FND_MESSAGE.SET_TOKEN('SS', l_ss);
627: OE_MSG_PUB.Add;
628: END IF;
629: END IF;
630:
631: -- Done.

Line 649: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

645: WHEN OTHERS THEN
646:
647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
648:
649: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
650: THEN
651: OE_MSG_PUB.Add_Exc_Msg
652: ( G_PKG_NAME
653: , 'Entity_Delete'

Line 651: OE_MSG_PUB.Add_Exc_Msg

647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
648:
649: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
650: THEN
651: OE_MSG_PUB.Add_Exc_Msg
652: ( G_PKG_NAME
653: , 'Entity_Delete'
654: );
655: END IF;