308: EXCEPTION
309: WHEN OTHERS THEN
310: l_pay_term_return_status := FND_API.G_RET_STS_ERROR ;
311:
312: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
313: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Invalid Payment Term');
314: FND_MSG_PUB.Add;
315:
316: IF PG_DEBUG in ('Y', 'C') THEN
309: WHEN OTHERS THEN
310: l_pay_term_return_status := FND_API.G_RET_STS_ERROR ;
311:
312: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
313: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Invalid Payment Term');
314: FND_MSG_PUB.Add;
315:
316: IF PG_DEBUG in ('Y', 'C') THEN
317: arp_util.debug('Activity_application: ' || 'Invalid Payment Term. Rolling back and setting status to ERROR');
324: IF p_payment_priority < 1 OR p_payment_priority > 99 THEN
325:
326: l_pay_priority_return_status := FND_API.G_RET_STS_ERROR ;
327:
328: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
329: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Payment Priority Not In Range(1-99)');
330: FND_MSG_PUB.Add;
331:
332: IF PG_DEBUG in ('Y', 'C') THEN
325:
326: l_pay_priority_return_status := FND_API.G_RET_STS_ERROR ;
327:
328: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
329: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Payment Priority Not In Range(1-99)');
330: FND_MSG_PUB.Add;
331:
332: IF PG_DEBUG in ('Y', 'C') THEN
333: arp_util.debug('Activity_application: ' || 'Payment Priority Not In Range(1-99). Rolling back and setting status to ERROR');
443: ROLLBACK TO Activity_app_PVT;
444:
445: -- Display_Parameters;
446: x_return_status := FND_API.G_RET_STS_ERROR ;
447: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
448: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.CM_ACTIVITY_APPLICATION : '||SQLERRM);
449: FND_MSG_PUB.Add;
450:
451: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
444:
445: -- Display_Parameters;
446: x_return_status := FND_API.G_RET_STS_ERROR ;
447: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
448: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.CM_ACTIVITY_APPLICATION : '||SQLERRM);
449: FND_MSG_PUB.Add;
450:
451: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
452: p_count => x_msg_count,
531: ROLLBACK TO Activity_app_PVT;
532:
533: -- Display_Parameters;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
535: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
536: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_REFUNDS_PVT.Create_Refund : '||SQLERRM);
537: FND_MSG_PUB.Add;
538:
539: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
532:
533: -- Display_Parameters;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
535: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
536: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_REFUNDS_PVT.Create_Refund : '||SQLERRM);
537: FND_MSG_PUB.Add;
538:
539: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
540: p_count => x_msg_count,
615: --If only one error message on the stack,
616: --retrive it
617:
618: x_return_status := FND_API.G_RET_STS_ERROR ;
619: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
620: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_APPLICATION : '||SQLERRM);
621: FND_MSG_PUB.Add;
622:
623: --If only one error message on the stack,
616: --retrive it
617:
618: x_return_status := FND_API.G_RET_STS_ERROR ;
619: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
620: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_APPLICATION : '||SQLERRM);
621: FND_MSG_PUB.Add;
622:
623: --If only one error message on the stack,
624: --retrive it
631: RETURN;
632:
633: ELSE
634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
635: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
636: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_APPLICATION : '||SQLERRM);
637: FND_MSG_PUB.Add;
638: END IF;
639:
632:
633: ELSE
634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
635: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
636: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_APPLICATION : '||SQLERRM);
637: FND_MSG_PUB.Add;
638: END IF;
639:
640: IF PG_DEBUG in ('Y', 'C') THEN
870: ROLLBACK TO Activity_unapplication_PVT;
871:
872: -- Display_Parameters;
873: x_return_status := FND_API.G_RET_STS_ERROR ;
874: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
875: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);
876: FND_MSG_PUB.Add;
877:
878: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
871:
872: -- Display_Parameters;
873: x_return_status := FND_API.G_RET_STS_ERROR ;
874: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
875: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);
876: FND_MSG_PUB.Add;
877:
878: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
879: p_count => x_msg_count,
948:
949: ROLLBACK TO Activity_unapplication_PVT;
950:
951: x_return_status := FND_API.G_RET_STS_ERROR ;
952: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
953: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_UNAPPLICATION : '||SQLERRM);
954: FND_MSG_PUB.Add;
955:
956: --If only one error message on the stack,
949: ROLLBACK TO Activity_unapplication_PVT;
950:
951: x_return_status := FND_API.G_RET_STS_ERROR ;
952: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
953: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_UNAPPLICATION : '||SQLERRM);
954: FND_MSG_PUB.Add;
955:
956: --If only one error message on the stack,
957: --retrive it
963: RETURN;
964:
965: ELSE
966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
967: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
968: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_UNAPPLICATION : '||SQLERRM);
969: FND_MSG_PUB.Add;
970: END IF;
971:
964:
965: ELSE
966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
967: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
968: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_UNAPPLICATION : '||SQLERRM);
969: FND_MSG_PUB.Add;
970: END IF;
971:
972: IF PG_DEBUG in ('Y', 'C') THEN
1199: ROLLBACK TO Unapply_reg_CM;
1200:
1201: -- Display_Parameters;
1202: x_return_status := FND_API.G_RET_STS_ERROR ;
1203: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1204: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE_CM_APP : '||SQLERRM);
1205: FND_MSG_PUB.Add;
1206:
1207: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1200:
1201: -- Display_Parameters;
1202: x_return_status := FND_API.G_RET_STS_ERROR ;
1203: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1204: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE_CM_APP : '||SQLERRM);
1205: FND_MSG_PUB.Add;
1206:
1207: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1208: p_count => x_msg_count,
1283:
1284: ROLLBACK TO Unapply_reg_CM;
1285:
1286: x_return_status := FND_API.G_RET_STS_ERROR ;
1287: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1288: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY : '||SQLERRM);
1289: FND_MSG_PUB.Add;
1290:
1291: --If only one error message on the stack,retrive it
1284: ROLLBACK TO Unapply_reg_CM;
1285:
1286: x_return_status := FND_API.G_RET_STS_ERROR ;
1287: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1288: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY : '||SQLERRM);
1289: FND_MSG_PUB.Add;
1290:
1291: --If only one error message on the stack,retrive it
1292:
1298: RETURN;
1299:
1300: ELSE
1301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1302: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1303: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY : '||SQLERRM);
1304: FND_MSG_PUB.Add;
1305: END IF;
1306:
1299:
1300: ELSE
1301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1302: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1303: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UNAPPLY : '||SQLERRM);
1304: FND_MSG_PUB.Add;
1305: END IF;
1306:
1307: