232: EXCEPTION
233: WHEN OTHERS
234: THEN
235: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');
236: FND_MSG_PUB.Add;
237: APP_EXCEPTION.raise_exception;
238: END;
239:
240: arp_app_pkg.fetch_p( p_ra_id, l_ra_rec );
611: EXCEPTION
612: WHEN OTHERS
613: THEN
614: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');
615: FND_MSG_PUB.Add;
616: APP_EXCEPTION.raise_exception;
617: END;
618:
619: arp_app_pkg.fetch_p( pn_ra_id, lr_ra_rec );
940: EXCEPTION
941: WHEN OTHERS
942: THEN
943: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');
944: FND_MSG_PUB.Add;
945: APP_EXCEPTION.raise_exception;
946: END;
947: arp_app_pkg.fetch_p( pn_ra_id, lr_ra_rec );
948:
1044: EXCEPTION
1045: WHEN OTHERS
1046: THEN
1047: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');
1048: FND_MSG_PUB.Add;
1049: APP_EXCEPTION.raise_exception;
1050: END;
1051:
1052: -- Fetch the UNAPP row.
5506: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
5507: l_func_amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE;
5508:
5509: l_fnd_api_constants_rec ar_bills_main.fnd_api_constants_type := ar_bills_main.get_fnd_api_constants_rec;
5510: l_fnd_msg_pub_constants_rec ar_bills_main.fnd_msg_pub_constants_type := ar_bills_main.get_fnd_msg_pub_constants_rec;
5511: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type;
5512: l_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type;
5513: l_return_status VARCHAR2(1);
5514: l_msg_count NUMBER;
5706: +-------------------------------------------------------*/
5707:
5708: FOR l_count IN 1..l_msg_count LOOP
5709:
5710: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,
5711: FND_API.G_FALSE);
5712: IF PG_DEBUG in ('Y', 'C') THEN
5713: arp_util.debug( to_char(l_count)||' : '||l_msg_data);
5714: END IF;
5747: arp_util.debug( 'API EXCEPTION: ' ||
5748: 'arp_process_application.activity_application(misc_receipt creation))'
5749: ||SQLERRM);
5750: END IF;
5751: FND_MSG_PUB.Get (FND_MSG_PUB.G_FIRST, FND_API.G_TRUE,
5752: l_msg_data, l_msg_index);
5753: FND_MESSAGE.Set_Encoded (l_msg_data);
5754: app_exception.raise_exception;
5755:
8040: +-------------------------------------------------------*/
8041:
8042: FOR l_count IN 1..l_msg_count LOOP
8043:
8044: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,
8045: FND_API.G_FALSE);
8046: IF PG_DEBUG in ('Y', 'C') THEN
8047: arp_util.debug( to_char(l_count)||' : '||l_msg_data);
8048: END IF;
8084: arp_util.debug( 'API EXCEPTION: ' ||
8085: 'arp_process_application.reverse_action_misc_receipt'
8086: ||SQLERRM);
8087: END IF;
8088: FND_MSG_PUB.Get (FND_MSG_PUB.G_FIRST, FND_API.G_TRUE,
8089: l_msg_data, l_msg_index);
8090: FND_MESSAGE.Set_Encoded (l_msg_data);
8091: app_exception.raise_exception;
8092: