48: itemkey := p_credit_request_rec.credit_request_id;
49:
50: IF FND_API.to_Boolean( p_init_msg_list )
51: THEN
52: FND_MSG_PUB.initialize;
53: END IF;
54:
55: IF p_credit_request_rec.credit_request_status IS NULL
56: THEN
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
237: ROLLBACK TO UPDATE_CREDIT_REQ_PVT;
238: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
239: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UPDATE_CREDIT_REQUEST : '||SQLERRM);
240: FND_MSG_PUB.Add;
241: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
242: p_count => x_msg_count,
243: p_data => x_msg_data
244: );
237: ROLLBACK TO UPDATE_CREDIT_REQ_PVT;
238: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
239: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UPDATE_CREDIT_REQUEST : '||SQLERRM);
240: FND_MSG_PUB.Add;
241: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
242: p_count => x_msg_count,
243: p_data => x_msg_data
244: );
245:
559: SAVEPOINT UPDATE_CREDIT_REQ_STATUS;
560:
561: IF FND_API.to_Boolean( p_init_msg_list )
562: THEN
563: FND_MSG_PUB.initialize;
564: END IF;
565:
566: -- first check the status in case it was passed
567: IF p_credit_request_status NOT IN ( 'SUBMIT', 'SAVE')