DBA Data[Home] [Help]

APPS.AHL_UC_APPROVALS_PVT dependencies on FND_MESSAGE

Line 112: FND_MESSAGE.set_name('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');

108: -- Begin Processing
109: --1)Validate uc_header_id is valid
110: IF (p_uc_header_id IS NULL OR p_uc_header_id = FND_API.G_MISS_NUM) THEN
111: x_return_status := FND_API.G_RET_STS_ERROR;
112: FND_MESSAGE.set_name('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
113: FND_MESSAGE.set_token('PROCEDURE', G_PKG_NAME);
114: FND_MSG_PUB.add;
115: RAISE FND_API.G_EXC_ERROR;
116: END IF;

Line 113: FND_MESSAGE.set_token('PROCEDURE', G_PKG_NAME);

109: --1)Validate uc_header_id is valid
110: IF (p_uc_header_id IS NULL OR p_uc_header_id = FND_API.G_MISS_NUM) THEN
111: x_return_status := FND_API.G_RET_STS_ERROR;
112: FND_MESSAGE.set_name('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
113: FND_MESSAGE.set_token('PROCEDURE', G_PKG_NAME);
114: FND_MSG_PUB.add;
115: RAISE FND_API.G_EXC_ERROR;
116: END IF;
117:

Line 122: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');

118: --2) Fetch the uc header details
119: OPEN get_uc_header_det(p_uc_header_id, p_object_version_number);
120: FETCH get_uc_header_det into l_uc_header_rec;
121: IF (get_uc_header_det%NOTFOUND) THEN
122: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
123: fnd_message.set_token('UC_HEADER_ID', p_uc_header_id, false);
124: FND_MSG_PUB.add;
125: CLOSE get_uc_header_det;
126: RAISE FND_API.G_EXC_ERROR;

Line 123: fnd_message.set_token('UC_HEADER_ID', p_uc_header_id, false);

119: OPEN get_uc_header_det(p_uc_header_id, p_object_version_number);
120: FETCH get_uc_header_det into l_uc_header_rec;
121: IF (get_uc_header_det%NOTFOUND) THEN
122: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
123: fnd_message.set_token('UC_HEADER_ID', p_uc_header_id, false);
124: FND_MSG_PUB.add;
125: CLOSE get_uc_header_det;
126: RAISE FND_API.G_EXC_ERROR;
127: END IF;

Line 132: fnd_message.set_name('AHL','AHL_UC_APRV_SUBUNIT');

128: CLOSE get_uc_header_det;
129:
130: --3) Make sure parent header id is null
131: IF (l_uc_header_rec.parent_uc_header_id is not null) THEN
132: fnd_message.set_name('AHL','AHL_UC_APRV_SUBUNIT');
133: FND_MSG_PUB.add;
134: RAISE FND_API.G_EXC_ERROR;
135: END IF;
136:

Line 170: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

166: WHERE unit_config_header_id=p_uc_header_id
167: And object_version_number=p_object_version_number;
168:
169: IF sql%rowcount=0 THEN
170: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
171: FND_MSG_PUB.ADD;
172: ELSE
173:
174: ahl_generic_aprv_pvt.START_WF_PROCESS(

Line 199: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

195: WHERE unit_config_header_id=p_uc_header_id
196: And object_version_number=p_object_version_number;
197:
198: IF sql%rowcount=0 THEN
199: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
200: FND_MSG_PUB.ADD;
201: ELSE
202: -- Call the Complete UC Approval API
203: AHL_UC_APPROVALS_PVT.COMPLETE_UC_APPROVAL

Line 255: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

251: WHERE unit_config_header_id=p_uc_header_id
252: And object_version_number=p_object_version_number;
253:
254: IF sql%rowcount=0 THEN
255: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
256: FND_MSG_PUB.ADD;
257: ELSE
258: ahl_generic_aprv_pvt.START_WF_PROCESS(
259: P_OBJECT =>l_object,

Line 283: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

279: WHERE unit_config_header_id=p_uc_header_id
280: And object_version_number=p_object_version_number;
281:
282: IF sql%rowcount=0 THEN
283: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
284: FND_MSG_PUB.ADD;
285: ELSE
286:
287: --Call the complete UC Approvals API

Line 307: fnd_message.set_name('AHL','AHL_UC_APRV_IN_PROGRESS');

303: END IF; --end active_status
304:
305: ELSE
306: --Not the right status to submit for approvals.
307: fnd_message.set_name('AHL','AHL_UC_APRV_IN_PROGRESS');
308: fnd_message.set_token('NAME', l_uc_header_rec.name, false);
309: FND_MSG_PUB.add;
310: RAISE FND_API.G_EXC_ERROR;
311:

Line 308: fnd_message.set_token('NAME', l_uc_header_rec.name, false);

304:
305: ELSE
306: --Not the right status to submit for approvals.
307: fnd_message.set_name('AHL','AHL_UC_APRV_IN_PROGRESS');
308: fnd_message.set_token('NAME', l_uc_header_rec.name, false);
309: FND_MSG_PUB.add;
310: RAISE FND_API.G_EXC_ERROR;
311:
312: END IF;

Line 460: FND_MESSAGE.set_name('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');

456: -- Begin Processing
457: --1) Validate uc_header_id
458: IF (p_uc_header_id IS NULL OR p_uc_header_id = FND_API.G_MISS_NUM) THEN
459: x_return_status := FND_API.G_RET_STS_ERROR;
460: FND_MESSAGE.set_name('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
461: FND_MESSAGE.set_token('PROCEDURE', G_PKG_NAME);
462: FND_MSG_PUB.add;
463: RAISE FND_API.G_EXC_ERROR;
464: END IF;

Line 461: FND_MESSAGE.set_token('PROCEDURE', G_PKG_NAME);

457: --1) Validate uc_header_id
458: IF (p_uc_header_id IS NULL OR p_uc_header_id = FND_API.G_MISS_NUM) THEN
459: x_return_status := FND_API.G_RET_STS_ERROR;
460: FND_MESSAGE.set_name('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
461: FND_MESSAGE.set_token('PROCEDURE', G_PKG_NAME);
462: FND_MSG_PUB.add;
463: RAISE FND_API.G_EXC_ERROR;
464: END IF;
465:

Line 470: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');

466: --2) Validate uc_header_id
467: OPEN get_uc_header_det(p_uc_header_id);
468: FETCH get_uc_header_det into l_uc_header_rec;
469: IF (get_uc_header_det%NOTFOUND) THEN
470: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
471: fnd_message.set_token('UC_HEADER_ID', p_uc_header_id, false);
472: FND_MSG_PUB.add;
473: CLOSE get_uc_header_det;
474: RAISE FND_API.G_EXC_ERROR;

Line 471: fnd_message.set_token('UC_HEADER_ID', p_uc_header_id, false);

467: OPEN get_uc_header_det(p_uc_header_id);
468: FETCH get_uc_header_det into l_uc_header_rec;
469: IF (get_uc_header_det%NOTFOUND) THEN
470: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
471: fnd_message.set_token('UC_HEADER_ID', p_uc_header_id, false);
472: FND_MSG_PUB.add;
473: CLOSE get_uc_header_det;
474: RAISE FND_API.G_EXC_ERROR;
475: END IF;

Line 740: FND_MESSAGE.set_name('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');

736: -- Begin Processing
737: -- Validate uc_header_id is valid
738: IF (p_uc_header_id IS NULL OR p_uc_header_id = FND_API.G_MISS_NUM) THEN
739: x_return_status := FND_API.G_RET_STS_ERROR;
740: FND_MESSAGE.set_name('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
741: FND_MESSAGE.set_token('PROCEDURE', G_PKG_NAME);
742: FND_MSG_PUB.add;
743: RAISE FND_API.G_EXC_ERROR;
744: END IF;

Line 741: FND_MESSAGE.set_token('PROCEDURE', G_PKG_NAME);

737: -- Validate uc_header_id is valid
738: IF (p_uc_header_id IS NULL OR p_uc_header_id = FND_API.G_MISS_NUM) THEN
739: x_return_status := FND_API.G_RET_STS_ERROR;
740: FND_MESSAGE.set_name('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
741: FND_MESSAGE.set_token('PROCEDURE', G_PKG_NAME);
742: FND_MSG_PUB.add;
743: RAISE FND_API.G_EXC_ERROR;
744: END IF;
745:

Line 750: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');

746: -- Fetch the uc header details
747: OPEN get_uc_header_det(p_uc_header_id, p_object_version_number);
748: FETCH get_uc_header_det into l_uc_header_rec;
749: IF (get_uc_header_det%NOTFOUND) THEN
750: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
751: fnd_message.set_token('UC_HEADER_ID', p_uc_header_id, false);
752: FND_MSG_PUB.add;
753: CLOSE get_uc_header_det;
754: RAISE FND_API.G_EXC_ERROR;

Line 751: fnd_message.set_token('UC_HEADER_ID', p_uc_header_id, false);

747: OPEN get_uc_header_det(p_uc_header_id, p_object_version_number);
748: FETCH get_uc_header_det into l_uc_header_rec;
749: IF (get_uc_header_det%NOTFOUND) THEN
750: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
751: fnd_message.set_token('UC_HEADER_ID', p_uc_header_id, false);
752: FND_MSG_PUB.add;
753: CLOSE get_uc_header_det;
754: RAISE FND_API.G_EXC_ERROR;
755: END IF;

Line 760: fnd_message.set_name('AHL','AHL_UC_APRV_SUBUNIT');

756: CLOSE get_uc_header_det;
757:
758: -- Make sure parent header id is null
759: IF (l_uc_header_rec.parent_uc_header_id is not null) THEN
760: fnd_message.set_name('AHL','AHL_UC_APRV_SUBUNIT');
761: FND_MSG_PUB.add;
762: RAISE FND_API.G_EXC_ERROR;
763: END IF;
764:

Line 803: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

799: WHERE unit_config_header_id=p_uc_header_id
800: AND object_version_number=p_object_version_number;
801:
802: IF sql%rowcount=0 THEN
803: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
804: FND_MSG_PUB.ADD;
805: -- To be verified if Error is supposed to be raised here or not.
806: ELSE
807:

Line 833: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

829: WHERE unit_config_header_id=p_uc_header_id
830: And object_version_number=p_object_version_number;
831:
832: IF sql%rowcount=0 THEN
833: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
834: FND_MSG_PUB.ADD;
835: -- To be verified if Error is supposed to be raised here or not.
836: ELSE
837: -- Call the Complete UC Approval API

Line 851: fnd_message.set_name('AHL','AHL_UC_APRV_IN_PROGRESS');

847: x_msg_data =>x_msg_data);
848: END IF; --sql%COUNT
849: END IF; -- Active Workflow Check
850: ELSE --Not the right status to submit for approvals.
851: fnd_message.set_name('AHL','AHL_UC_APRV_IN_PROGRESS');
852: fnd_message.set_token('UNIT_NAME', l_uc_header_rec.name, false);
853: FND_MSG_PUB.add;
854: RAISE FND_API.G_EXC_ERROR;
855: END IF; -- Active Status Check.

Line 852: fnd_message.set_token('UNIT_NAME', l_uc_header_rec.name, false);

848: END IF; --sql%COUNT
849: END IF; -- Active Workflow Check
850: ELSE --Not the right status to submit for approvals.
851: fnd_message.set_name('AHL','AHL_UC_APRV_IN_PROGRESS');
852: fnd_message.set_token('UNIT_NAME', l_uc_header_rec.name, false);
853: FND_MSG_PUB.add;
854: RAISE FND_API.G_EXC_ERROR;
855: END IF; -- Active Status Check.
856:

Line 1010: FND_MESSAGE.set_name('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');

1006: -- Begin Processing
1007: -- Validate uc_header_id is valid
1008: IF (p_uc_header_id IS NULL OR p_uc_header_id = FND_API.G_MISS_NUM) THEN
1009: x_return_status := FND_API.G_RET_STS_ERROR;
1010: FND_MESSAGE.set_name('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
1011: FND_MESSAGE.set_token('PROCEDURE', G_PKG_NAME);
1012: FND_MSG_PUB.add;
1013: RAISE FND_API.G_EXC_ERROR;
1014: END IF;

Line 1011: FND_MESSAGE.set_token('PROCEDURE', G_PKG_NAME);

1007: -- Validate uc_header_id is valid
1008: IF (p_uc_header_id IS NULL OR p_uc_header_id = FND_API.G_MISS_NUM) THEN
1009: x_return_status := FND_API.G_RET_STS_ERROR;
1010: FND_MESSAGE.set_name('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
1011: FND_MESSAGE.set_token('PROCEDURE', G_PKG_NAME);
1012: FND_MSG_PUB.add;
1013: RAISE FND_API.G_EXC_ERROR;
1014: END IF;
1015:

Line 1020: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');

1016: -- Fetch the uc header details
1017: OPEN get_uc_header_det(p_uc_header_id, p_object_version_number);
1018: FETCH get_uc_header_det into l_uc_header_rec;
1019: IF (get_uc_header_det%NOTFOUND) THEN
1020: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1021: fnd_message.set_token('UC_HEADER_ID', p_uc_header_id, false);
1022: FND_MSG_PUB.add;
1023: CLOSE get_uc_header_det;
1024: RAISE FND_API.G_EXC_ERROR;

Line 1021: fnd_message.set_token('UC_HEADER_ID', p_uc_header_id, false);

1017: OPEN get_uc_header_det(p_uc_header_id, p_object_version_number);
1018: FETCH get_uc_header_det into l_uc_header_rec;
1019: IF (get_uc_header_det%NOTFOUND) THEN
1020: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1021: fnd_message.set_token('UC_HEADER_ID', p_uc_header_id, false);
1022: FND_MSG_PUB.add;
1023: CLOSE get_uc_header_det;
1024: RAISE FND_API.G_EXC_ERROR;
1025: END IF;

Line 1030: fnd_message.set_name('AHL','AHL_UC_APRV_SUBUNIT');

1026: CLOSE get_uc_header_det;
1027:
1028: -- Make sure parent header id is null
1029: IF (l_uc_header_rec.parent_uc_header_id is not null) THEN
1030: fnd_message.set_name('AHL','AHL_UC_APRV_SUBUNIT');
1031: FND_MSG_PUB.add;
1032: RAISE FND_API.G_EXC_ERROR;
1033: END IF;
1034:

Line 1068: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

1064: WHERE unit_config_header_id=p_uc_header_id
1065: AND object_version_number=p_object_version_number;
1066:
1067: IF sql%rowcount=0 THEN
1068: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1069: FND_MSG_PUB.ADD;
1070: -- To be verified if Error is supposed to be raised here or not.
1071: ELSE
1072:

Line 1098: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

1094: WHERE unit_config_header_id=p_uc_header_id
1095: And object_version_number=p_object_version_number;
1096:
1097: IF sql%rowcount=0 THEN
1098: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1099: FND_MSG_PUB.ADD;
1100: -- To be verified if Error is supposed to be raised here or not.
1101: ELSE
1102: -- Call the Complete UC Approval API

Line 1116: fnd_message.set_name('AHL','AHL_UC_APRV_IN_PROGRESS');

1112: x_msg_data =>x_msg_data);
1113: END IF; --sql%COUNT
1114: END IF; -- Active Workflow Check
1115: ELSE --Not the right status to submit for approvals.
1116: fnd_message.set_name('AHL','AHL_UC_APRV_IN_PROGRESS');
1117: fnd_message.set_token('UNIT_NAME', l_uc_header_rec.name, false);
1118: FND_MSG_PUB.add;
1119: RAISE FND_API.G_EXC_ERROR;
1120: END IF; -- Active Status Check.

Line 1117: fnd_message.set_token('UNIT_NAME', l_uc_header_rec.name, false);

1113: END IF; --sql%COUNT
1114: END IF; -- Active Workflow Check
1115: ELSE --Not the right status to submit for approvals.
1116: fnd_message.set_name('AHL','AHL_UC_APRV_IN_PROGRESS');
1117: fnd_message.set_token('UNIT_NAME', l_uc_header_rec.name, false);
1118: FND_MSG_PUB.add;
1119: RAISE FND_API.G_EXC_ERROR;
1120: END IF; -- Active Status Check.
1121:

Line 1270: FND_MESSAGE.set_name('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');

1266: -- Begin Processing
1267: --1) Validate if uc_header_id is passed.
1268: IF (p_uc_header_id IS NULL OR p_uc_header_id = FND_API.G_MISS_NUM) THEN
1269: x_return_status := FND_API.G_RET_STS_ERROR;
1270: FND_MESSAGE.set_name('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
1271: FND_MESSAGE.set_token('PROCEDURE', G_PKG_NAME);
1272: FND_MSG_PUB.add;
1273: RAISE FND_API.G_EXC_ERROR;
1274: END IF;

Line 1271: FND_MESSAGE.set_token('PROCEDURE', G_PKG_NAME);

1267: --1) Validate if uc_header_id is passed.
1268: IF (p_uc_header_id IS NULL OR p_uc_header_id = FND_API.G_MISS_NUM) THEN
1269: x_return_status := FND_API.G_RET_STS_ERROR;
1270: FND_MESSAGE.set_name('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
1271: FND_MESSAGE.set_token('PROCEDURE', G_PKG_NAME);
1272: FND_MSG_PUB.add;
1273: RAISE FND_API.G_EXC_ERROR;
1274: END IF;
1275:

Line 1284: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');

1280: --2) Validate uc_header_id passed is valid
1281: OPEN get_uc_header_det(p_uc_header_id);
1282: FETCH get_uc_header_det into l_uc_header_rec;
1283: IF (get_uc_header_det%NOTFOUND) THEN
1284: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1285: fnd_message.set_token('UC_HEADER_ID', p_uc_header_id, false);
1286: FND_MSG_PUB.add;
1287: CLOSE get_uc_header_det;
1288: RAISE FND_API.G_EXC_ERROR;

Line 1285: fnd_message.set_token('UC_HEADER_ID', p_uc_header_id, false);

1281: OPEN get_uc_header_det(p_uc_header_id);
1282: FETCH get_uc_header_det into l_uc_header_rec;
1283: IF (get_uc_header_det%NOTFOUND) THEN
1284: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1285: fnd_message.set_token('UC_HEADER_ID', p_uc_header_id, false);
1286: FND_MSG_PUB.add;
1287: CLOSE get_uc_header_det;
1288: RAISE FND_API.G_EXC_ERROR;
1289: END IF;