390: ROLLBACK TO Activity_app_PVT;
391:
392: -- Display_Parameters;
393: x_return_status := FND_API.G_RET_STS_ERROR ;
394: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
395: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.CM_ACTIVITY_APPLICATION : '||SQLERRM);
396: FND_MSG_PUB.Add;
397:
398: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
391:
392: -- Display_Parameters;
393: x_return_status := FND_API.G_RET_STS_ERROR ;
394: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
395: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.CM_ACTIVITY_APPLICATION : '||SQLERRM);
396: FND_MSG_PUB.Add;
397:
398: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
399: p_count => x_msg_count,
473: ROLLBACK TO Activity_app_PVT;
474:
475: -- Display_Parameters;
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
477: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
478: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_REFUNDS_PVT.Create_Refund : '||SQLERRM);
479: FND_MSG_PUB.Add;
480:
481: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
474:
475: -- Display_Parameters;
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
477: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
478: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_REFUNDS_PVT.Create_Refund : '||SQLERRM);
479: FND_MSG_PUB.Add;
480:
481: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
482: p_count => x_msg_count,
557: --If only one error message on the stack,
558: --retrive it
559:
560: x_return_status := FND_API.G_RET_STS_ERROR ;
561: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
562: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_APPLICATION : '||SQLERRM);
563: FND_MSG_PUB.Add;
564:
565: --If only one error message on the stack,
558: --retrive it
559:
560: x_return_status := FND_API.G_RET_STS_ERROR ;
561: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
562: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_APPLICATION : '||SQLERRM);
563: FND_MSG_PUB.Add;
564:
565: --If only one error message on the stack,
566: --retrive it
573: RETURN;
574:
575: ELSE
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
577: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
578: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_APPLICATION : '||SQLERRM);
579: FND_MSG_PUB.Add;
580: END IF;
581:
574:
575: ELSE
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
577: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
578: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_APPLICATION : '||SQLERRM);
579: FND_MSG_PUB.Add;
580: END IF;
581:
582: IF PG_DEBUG in ('Y', 'C') THEN
812: ROLLBACK TO Activity_unapplication_PVT;
813:
814: -- Display_Parameters;
815: x_return_status := FND_API.G_RET_STS_ERROR ;
816: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
817: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);
818: FND_MSG_PUB.Add;
819:
820: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
813:
814: -- Display_Parameters;
815: x_return_status := FND_API.G_RET_STS_ERROR ;
816: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
817: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARP_PROCESS_APPLICATION.REVERSE : '||SQLERRM);
818: FND_MSG_PUB.Add;
819:
820: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
821: p_count => x_msg_count,
890:
891: ROLLBACK TO Activity_unapplication_PVT;
892:
893: x_return_status := FND_API.G_RET_STS_ERROR ;
894: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
895: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_UNAPPLICATION : '||SQLERRM);
896: FND_MSG_PUB.Add;
897:
898: --If only one error message on the stack,
891: ROLLBACK TO Activity_unapplication_PVT;
892:
893: x_return_status := FND_API.G_RET_STS_ERROR ;
894: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
895: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_UNAPPLICATION : '||SQLERRM);
896: FND_MSG_PUB.Add;
897:
898: --If only one error message on the stack,
899: --retrive it
905: RETURN;
906:
907: ELSE
908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
909: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
910: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_UNAPPLICATION : '||SQLERRM);
911: FND_MSG_PUB.Add;
912: END IF;
913:
906:
907: ELSE
908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
909: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
910: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACTIVITY_UNAPPLICATION : '||SQLERRM);
911: FND_MSG_PUB.Add;
912: END IF;
913:
914: IF PG_DEBUG in ('Y', 'C') THEN