205: IF c_setup_opt%NOTFOUND THEN
206:
207: CLOSE c_setup_opt;
208:
209: FND_MESSAGE.SET_NAME ('IGC', 'IGC_CC_OPTION_NOT_FOUND');
210:
211: OPEN c_meaning_type ;
212: FETCH c_meaning_type INTO l_value;
213: CLOSE c_meaning_type;
210:
211: OPEN c_meaning_type ;
212: FETCH c_meaning_type INTO l_value;
213: CLOSE c_meaning_type;
214: FND_MESSAGE.SET_TOKEN ('CC_TYPE',l_value);
215:
216: OPEN c_meaning_state ;
217: FETCH c_meaning_state INTO l_value;
218: CLOSE c_meaning_state;
215:
216: OPEN c_meaning_state ;
217: FETCH c_meaning_state INTO l_value;
218: CLOSE c_meaning_state;
219: FND_MESSAGE.SET_TOKEN ('CC_STATE',l_value);
220:
221: OPEN c_org_name ;
222: FETCH c_org_name INTO l_value;
223: CLOSE c_org_name;
221: OPEN c_org_name ;
222: FETCH c_org_name INTO l_value;
223: CLOSE c_org_name;
224:
225: FND_MESSAGE.SET_TOKEN ('ORG_ID',l_value);
226:
227: FND_MSG_PUB.ADD;
228: raise FND_API.G_EXC_ERROR;
229: END IF;
277: END IF;
278: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
279: p_data => x_msg_data);
280: IF ( g_unexp_level >= g_debug_level ) THEN
281: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
282: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
283: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
284: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
285: END IF;
278: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
279: p_data => x_msg_data);
280: IF ( g_unexp_level >= g_debug_level ) THEN
281: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
282: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
283: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
284: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
285: END IF;
286:
279: p_data => x_msg_data);
280: IF ( g_unexp_level >= g_debug_level ) THEN
281: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
282: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
283: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
284: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
285: END IF;
286:
287: END Preparer_Can_Approve;
580:
581: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count ,
582: p_data => p_msg_data );
583: IF ( g_unexp_level >= g_debug_level ) THEN
584: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
585: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
586: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
587: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
588: END IF;
581: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count ,
582: p_data => p_msg_data );
583: IF ( g_unexp_level >= g_debug_level ) THEN
584: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
585: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
586: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
587: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
588: END IF;
589:
582: p_data => p_msg_data );
583: IF ( g_unexp_level >= g_debug_level ) THEN
584: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
585: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
586: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
587: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
588: END IF;
589:
590: