140:
141: -- If hierarchy does not require to be flattened
142: -- throws an error message .
143: if (l_flattened_rows_flag = 'N') then
144: FND_MESSAGE.SET_NAME('FEM','FEM_DHM_CANNOT_FLATTEN_HIER');
145: FND_MESSAGE.SET_TOKEN('HIER_DEFN_NAME',l_hier_defn_name );
146: FND_MSG_PUB.Add;
147: RAISE FND_API.G_EXC_ERROR ;
148: end if;
141: -- If hierarchy does not require to be flattened
142: -- throws an error message .
143: if (l_flattened_rows_flag = 'N') then
144: FND_MESSAGE.SET_NAME('FEM','FEM_DHM_CANNOT_FLATTEN_HIER');
145: FND_MESSAGE.SET_TOKEN('HIER_DEFN_NAME',l_hier_defn_name );
146: FND_MSG_PUB.Add;
147: RAISE FND_API.G_EXC_ERROR ;
148: end if;
149:
549:
550: -- If hierarchy does not require to be flattened
551: -- throws an error message .
552: if (l_flattened_rows_flag = 'N') then
553: FND_MESSAGE.SET_NAME('FEM','FEM_DHM_CANNOT_FLATTEN_HIER');
554: FND_MESSAGE.SET_TOKEN('HIER_DEFN_NAME',l_hier_defn_name );
555: FND_MSG_PUB.Add;
556: RAISE FND_API.G_EXC_ERROR ;
557: end if;
550: -- If hierarchy does not require to be flattened
551: -- throws an error message .
552: if (l_flattened_rows_flag = 'N') then
553: FND_MESSAGE.SET_NAME('FEM','FEM_DHM_CANNOT_FLATTEN_HIER');
554: FND_MESSAGE.SET_TOKEN('HIER_DEFN_NAME',l_hier_defn_name );
555: FND_MSG_PUB.Add;
556: RAISE FND_API.G_EXC_ERROR ;
557: end if;
558:
5885: WHEN NO_DATA_FOUND THEN
5886: --Bug#4878100
5887: ROLLBACK TO Hier_Operation_Pvt ;
5888: x_return_status := FND_API.G_RET_STS_ERROR;
5889: FND_MESSAGE.SET_NAME('FEM', 'FEM_DHM_MEM_DELETED_ERR');
5890: FND_MSG_PUB.ADD;
5891:
5892: --
5893: WHEN OTHERS THEN
7535:
7536: -- Message: "Addition of CHILD_DISPLAY_CODE to PARENT_DISPLAY_CODE
7537: -- causes a circular reference in the Hierarchy."
7538:
7539: FND_MESSAGE.SET_NAME('FEM','FEM_DHM_CIRC_REF_ERROR');
7540: FND_MESSAGE.SET_TOKEN('PARENT_DISPLAY_CODE',
7541: l_parent_display_code);
7542: FND_MESSAGE.SET_TOKEN('CHILD_DISPLAY_CODE',
7543: l_child_display_code);
7536: -- Message: "Addition of CHILD_DISPLAY_CODE to PARENT_DISPLAY_CODE
7537: -- causes a circular reference in the Hierarchy."
7538:
7539: FND_MESSAGE.SET_NAME('FEM','FEM_DHM_CIRC_REF_ERROR');
7540: FND_MESSAGE.SET_TOKEN('PARENT_DISPLAY_CODE',
7541: l_parent_display_code);
7542: FND_MESSAGE.SET_TOKEN('CHILD_DISPLAY_CODE',
7543: l_child_display_code);
7544:
7538:
7539: FND_MESSAGE.SET_NAME('FEM','FEM_DHM_CIRC_REF_ERROR');
7540: FND_MESSAGE.SET_TOKEN('PARENT_DISPLAY_CODE',
7541: l_parent_display_code);
7542: FND_MESSAGE.SET_TOKEN('CHILD_DISPLAY_CODE',
7543: l_child_display_code);
7544:
7545: FND_MSG_PUB.Add;
7546:
7793: WHEN FND_API.G_EXC_ERROR THEN
7794:
7795: ---- Start : Bug#5895840
7796: IF(l_cal_period_id IS NULL) THEN
7797: FND_MESSAGE.SET_NAME('FEM','FEM_DHM_CREATE_REL_PROFILE_ERR');
7798: FND_MSG_PUB.ADD;
7799: END IF;
7800:
7801: IF(l_dataset_code IS NULL) THEN
7798: FND_MSG_PUB.ADD;
7799: END IF;
7800:
7801: IF(l_dataset_code IS NULL) THEN
7802: FND_MESSAGE.SET_NAME('FEM','FEM_DHM_CREATE_REL_DATASET_ERR');
7803: FND_MSG_PUB.ADD;
7804: END IF;
7805: ---- End: Bug#5895840
7806: