109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
110: END IF;
111: -- Initialize message list if p_init_msg_list is set to TRUE.
112: IF FND_API.to_Boolean( p_init_msg_list ) THEN
113: FND_MSG_PUB.initialize;
114: END IF;
115:
116: FOR expiring_contracts_rec IN EXPIRING_CONTRACTS LOOP
117: OKC_REP_CONTRACT_PROCESS_PVT.repository_notifier(
148: CLOSE EXPIRING_CONTRACTS ;
149: END IF;
150:
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: FND_MSG_PUB.Count_And_Get(
153: p_count => x_msg_count,
154: p_data => x_msg_data
155: );
156:
166: CLOSE EXPIRING_CONTRACTS ;
167: END IF;
168:
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170: FND_MSG_PUB.Count_And_Get(
171: p_count => x_msg_count,
172: p_data => x_msg_data
173: );
174:
192: CLOSE EXPIRING_CONTRACTS ;
193: END IF;
194:
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: FND_MSG_PUB.Count_And_Get(
197: p_count => x_msg_count,
198: p_data => x_msg_data
199: );
200: