DBA Data[Home] [Help]

APPS.QP_VALIDATE_FNA dependencies on FND_MESSAGE

Line 63: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');

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');
65: OE_MSG_PUB.Add;
66:
67: END IF;

Line 64: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PTE_SOURCESYSTEM_FNAREA_ID');

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');
65: OE_MSG_PUB.Add;
66:
67: END IF;
68:

Line 83: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');

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');
85: OE_MSG_PUB.Add;
86:
87: END IF;

Line 84: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PTE_SOURCE_SYSTEM_ID');

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');
85: OE_MSG_PUB.Add;
86:
87: END IF;
88:

Line 99: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');

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');
101: OE_MSG_PUB.Add;
102:
103: END IF;

Line 100: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','FUNCTIONAL_AREA_ID');

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');
101: OE_MSG_PUB.Add;
102:
103: END IF;
104:

Line 145: FND_MESSAGE.SET_NAME('QP','QP_INVALID_FUNC_AREA');

141: into l_pte, l_ss
142: from qp_pte_source_systems
143: where pte_source_system_id = p_FNA_rec.pte_source_system_id;
144:
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;

Line 146: FND_MESSAGE.SET_TOKEN('FNID', p_FNA_rec.functional_area_id);

142: from qp_pte_source_systems
143: where pte_source_system_id = p_FNA_rec.pte_source_system_id;
144:
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;

Line 147: FND_MESSAGE.SET_TOKEN('PTE', l_pte);

143: where pte_source_system_id = p_FNA_rec.pte_source_system_id;
144:
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;

Line 148: FND_MESSAGE.SET_TOKEN('SS', l_ss);

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

Line 173: FND_MESSAGE.SET_NAME('QP','QP_DUP_FUNC_AREA_WITHIN_PTE');

169: into l_fnarea
170: from mtl_default_category_sets_fk_v
171: where functional_area_id = p_FNA_rec.functional_area_id;
172:
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;

Line 174: FND_MESSAGE.SET_TOKEN('FNAREA', l_fnarea);

170: from mtl_default_category_sets_fk_v
171: where functional_area_id = p_FNA_rec.functional_area_id;
172:
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;

Line 175: FND_MESSAGE.SET_TOKEN('PTE', l_pte);

171: where functional_area_id = p_FNA_rec.functional_area_id;
172:
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:

Line 176: FND_MESSAGE.SET_TOKEN('SS', l_ss);

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

Line 225: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_SEED_FUNC_AREAS');

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;
227: END IF;
228: END IF;
229:

Line 623: FND_MESSAGE.SET_NAME('QP', 'QP_DEL_FUNC_AREA_NOT_ALLOW');

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);
625: FND_MESSAGE.SET_TOKEN('PTE', l_pte);
626: FND_MESSAGE.SET_TOKEN('SS', l_ss);
627: OE_MSG_PUB.Add;

Line 624: FND_MESSAGE.SET_TOKEN('FNAREA', l_fnarea);

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);
625: FND_MESSAGE.SET_TOKEN('PTE', l_pte);
626: FND_MESSAGE.SET_TOKEN('SS', l_ss);
627: OE_MSG_PUB.Add;
628: END IF;

Line 625: FND_MESSAGE.SET_TOKEN('PTE', l_pte);

621: THEN
622:
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;

Line 626: FND_MESSAGE.SET_TOKEN('SS', l_ss);

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