508: END IF ;
509:
510: p_msg_data :='Not able to fetch Employeee Number ';
511:
512: FND_MESSAGE.Set_Name('CS', p_msg_data);
513: -- --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
514: FND_MSG_PUB.Add;
515:
516:
509:
510: p_msg_data :='Not able to fetch Employeee Number ';
511:
512: FND_MESSAGE.Set_Name('CS', p_msg_data);
513: -- --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
514: FND_MSG_PUB.Add;
515:
516:
517:
528: );
529: END IF ;
530: p_msg_data :='Not able to fetch Employeee Number ';
531:
532: FND_MESSAGE.Set_Name('CS', p_msg_data);
533: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
534: FND_MSG_PUB.Add;
535:
536: RAISE l_interface_error;
529: END IF ;
530: p_msg_data :='Not able to fetch Employeee Number ';
531:
532: FND_MESSAGE.Set_Name('CS', p_msg_data);
533: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
534: FND_MSG_PUB.Add;
535:
536: RAISE l_interface_error;
537:
534: FND_MSG_PUB.Add;
535:
536: RAISE l_interface_error;
537:
538: --FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PURGSET_INV');
539: -- FND_MSG_PUB.ADD;
540:
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542:
553: END IF ;
554:
555: p_msg_data :='Not able to fetch Employeee Number ';
556:
557: FND_MESSAGE.Set_Name('CS', p_msg_data);
558: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
559: FND_MSG_PUB.Add;
560: RAISE l_interface_error;
561:
554:
555: p_msg_data :='Not able to fetch Employeee Number ';
556:
557: FND_MESSAGE.Set_Name('CS', p_msg_data);
558: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
559: FND_MSG_PUB.Add;
560: RAISE l_interface_error;
561:
562: End;
601: , 'Not able to fetch the organization name '
602: );
603: END IF ;
604: p_msg_data :='Not able to fetch organization name ';
605: FND_MESSAGE.Set_Name('CS', p_msg_data);
606: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
607: FND_MSG_PUB.Add;
608:
609: RAISE l_interface_error;
602: );
603: END IF ;
604: p_msg_data :='Not able to fetch organization name ';
605: FND_MESSAGE.Set_Name('CS', p_msg_data);
606: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
607: FND_MSG_PUB.Add;
608:
609: RAISE l_interface_error;
610:
618: , 'Not able to fetch the organization name '
619: );
620: END IF ;
621:
622: --FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PURGSET_INV');
623: -- FND_MSG_PUB.ADD;
624: p_msg_data :='Not able to fetch organization name ';
625: FND_MESSAGE.Set_Name('CS', p_msg_data);
626: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
621:
622: --FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PURGSET_INV');
623: -- FND_MSG_PUB.ADD;
624: p_msg_data :='Not able to fetch organization name ';
625: FND_MESSAGE.Set_Name('CS', p_msg_data);
626: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
627: FND_MSG_PUB.Add;
628:
629: RAISE l_interface_error;
622: --FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PURGSET_INV');
623: -- FND_MSG_PUB.ADD;
624: p_msg_data :='Not able to fetch organization name ';
625: FND_MESSAGE.Set_Name('CS', p_msg_data);
626: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
627: FND_MSG_PUB.Add;
628:
629: RAISE l_interface_error;
630:
638: , 'Not able to fetch the organization name '
639: );
640: END IF ;
641: p_msg_data :='Not able to fetch organization name ';
642: FND_MESSAGE.Set_Name('CS', p_msg_data);
643: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
644: FND_MSG_PUB.Add;
645: RAISE l_interface_error;
646:
639: );
640: END IF ;
641: p_msg_data :='Not able to fetch organization name ';
642: FND_MESSAGE.Set_Name('CS', p_msg_data);
643: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
644: FND_MSG_PUB.Add;
645: RAISE l_interface_error;
646:
647: End;
694: , 'Not able to fetch the Project Number '
695: );
696: END IF ;
697: p_msg_data :='Not able to fetch Project Number ';
698: FND_MESSAGE.Set_Name('CS', p_msg_data);
699: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
700: FND_MSG_PUB.Add;
701: RAISE l_interface_error;
702:
695: );
696: END IF ;
697: p_msg_data :='Not able to fetch Project Number ';
698: FND_MESSAGE.Set_Name('CS', p_msg_data);
699: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
700: FND_MSG_PUB.Add;
701: RAISE l_interface_error;
702:
703: WHEN NO_DATA_FOUND THEN
710: , 'Not able to fetch the Project Number '
711: );
712: END IF ;
713:
714: --FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PURGSET_INV');
715: -- FND_MSG_PUB.ADD;
716:
717: p_msg_data :='Not able to fetch Project Number ';
718: FND_MESSAGE.Set_Name('CS', p_msg_data);
714: --FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PURGSET_INV');
715: -- FND_MSG_PUB.ADD;
716:
717: p_msg_data :='Not able to fetch Project Number ';
718: FND_MESSAGE.Set_Name('CS', p_msg_data);
719: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
720: FND_MSG_PUB.Add;
721:
722: RAISE l_interface_error;
715: -- FND_MSG_PUB.ADD;
716:
717: p_msg_data :='Not able to fetch Project Number ';
718: FND_MESSAGE.Set_Name('CS', p_msg_data);
719: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
720: FND_MSG_PUB.Add;
721:
722: RAISE l_interface_error;
723: WHEN OTHERS then
730: , 'Not able to fetch the Project Number '
731: );
732: END IF ;
733: p_msg_data :='Not able to fetch Project Number ';
734: FND_MESSAGE.Set_Name('CS', p_msg_data);
735: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
736: FND_MSG_PUB.Add;
737: RAISE l_interface_error;
738:
731: );
732: END IF ;
733: p_msg_data :='Not able to fetch Project Number ';
734: FND_MESSAGE.Set_Name('CS', p_msg_data);
735: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
736: FND_MSG_PUB.Add;
737: RAISE l_interface_error;
738:
739: End;
762: , 'Not able to fetch the Project Task Number '
763: );
764: END IF ;
765: p_msg_data :='Not able to fetch Project Task Number ';
766: FND_MESSAGE.Set_Name('CS', p_msg_data);
767: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
768: FND_MSG_PUB.Add;
769:
770:
763: );
764: END IF ;
765: p_msg_data :='Not able to fetch Project Task Number ';
766: FND_MESSAGE.Set_Name('CS', p_msg_data);
767: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
768: FND_MSG_PUB.Add;
769:
770:
771:
781: , 'Not able to fetch the Project Task Number '
782: );
783: END IF ;
784:
785: --FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PURGSET_INV');
786: -- FND_MSG_PUB.ADD;
787: p_msg_data :='Not able to fetch Project Task Number ';
788: FND_MESSAGE.Set_Name('CS', p_msg_data);
789: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
784:
785: --FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PURGSET_INV');
786: -- FND_MSG_PUB.ADD;
787: p_msg_data :='Not able to fetch Project Task Number ';
788: FND_MESSAGE.Set_Name('CS', p_msg_data);
789: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
790: FND_MSG_PUB.Add;
791:
792:
785: --FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PURGSET_INV');
786: -- FND_MSG_PUB.ADD;
787: p_msg_data :='Not able to fetch Project Task Number ';
788: FND_MESSAGE.Set_Name('CS', p_msg_data);
789: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
790: FND_MSG_PUB.Add;
791:
792:
793: RAISE l_interface_error;
801: , 'Not able to fetch the Project Task Number '
802: );
803: END IF ;
804: p_msg_data :='Not able to fetch Project Task Number ';
805: FND_MESSAGE.Set_Name('CS', p_msg_data);
806: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
807: FND_MSG_PUB.Add;
808:
809:
802: );
803: END IF ;
804: p_msg_data :='Not able to fetch Project Task Number ';
805: FND_MESSAGE.Set_Name('CS', p_msg_data);
806: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
807: FND_MSG_PUB.Add;
808:
809:
810:
893: , 'Not able to fetch the Project Currency Code '
894: );
895: END IF ;
896:
897: --FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PURGSET_INV');
898: -- FND_MSG_PUB.ADD;
899: p_msg_data :='Not able to fetch Project Currency Code ';
900: FND_MESSAGE.Set_Name('CS', p_msg_data);
901: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
896:
897: --FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PURGSET_INV');
898: -- FND_MSG_PUB.ADD;
899: p_msg_data :='Not able to fetch Project Currency Code ';
900: FND_MESSAGE.Set_Name('CS', p_msg_data);
901: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
902: FND_MSG_PUB.Add;
903:
904:
897: --FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PURGSET_INV');
898: -- FND_MSG_PUB.ADD;
899: p_msg_data :='Not able to fetch Project Currency Code ';
900: FND_MESSAGE.Set_Name('CS', p_msg_data);
901: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
902: FND_MSG_PUB.Add;
903:
904:
905: RAISE l_interface_error;
913: , 'Not able to fetch the Project Currency Code '
914: );
915: END IF ;
916: p_msg_data :='Not able to fetch Project Currency Code ';
917: FND_MESSAGE.Set_Name('CS', p_msg_data);
918: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
919: FND_MSG_PUB.Add;
920:
921: RAISE l_interface_error;
914: );
915: END IF ;
916: p_msg_data :='Not able to fetch Project Currency Code ';
917: FND_MESSAGE.Set_Name('CS', p_msg_data);
918: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
919: FND_MSG_PUB.Add;
920:
921: RAISE l_interface_error;
922: End;
1263: , 'Not able to fetch the Person Id '
1264: );
1265: END IF ;
1266: p_msg_data :='Not able to fetch the Person Id';
1267: FND_MESSAGE.Set_Name('CS', p_msg_data);
1268: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
1269: FND_MSG_PUB.Add;
1270:
1271:
1264: );
1265: END IF ;
1266: p_msg_data :='Not able to fetch the Person Id';
1267: FND_MESSAGE.Set_Name('CS', p_msg_data);
1268: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
1269: FND_MSG_PUB.Add;
1270:
1271:
1272: RAISE l_interface_error;
1281: , 'Not able to fetch the Person Id '
1282: );
1283: END IF ;
1284: p_msg_data :='Not able to fetch the Person Id';
1285: FND_MESSAGE.Set_Name('CS', p_msg_data);
1286: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
1287: FND_MSG_PUB.Add;
1288:
1289: --FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PURGSET_INV');
1282: );
1283: END IF ;
1284: p_msg_data :='Not able to fetch the Person Id';
1285: FND_MESSAGE.Set_Name('CS', p_msg_data);
1286: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
1287: FND_MSG_PUB.Add;
1288:
1289: --FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PURGSET_INV');
1290: -- FND_MSG_PUB.ADD;
1285: FND_MESSAGE.Set_Name('CS', p_msg_data);
1286: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
1287: FND_MSG_PUB.Add;
1288:
1289: --FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PURGSET_INV');
1290: -- FND_MSG_PUB.ADD;
1291:
1292: RAISE l_interface_error;
1293: WHEN OTHERS then
1300: , 'Not able to fetch the Person Id '
1301: );
1302: END IF ;
1303: p_msg_data :='Not able to fetch the Person Id';
1304: FND_MESSAGE.Set_Name('CS', p_msg_data);
1305: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
1306: FND_MSG_PUB.Add;
1307:
1308: RAISE l_interface_error;
1301: );
1302: END IF ;
1303: p_msg_data :='Not able to fetch the Person Id';
1304: FND_MESSAGE.Set_Name('CS', p_msg_data);
1305: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
1306: FND_MSG_PUB.Add;
1307:
1308: RAISE l_interface_error;
1309: End;
1384: , 'Not able to fetch the business_group_id '
1385: );
1386: END IF ;
1387: p_msg_data :='Not able to fetch the business_group_id';
1388: FND_MESSAGE.Set_Name('CS', p_msg_data);
1389: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
1390: FND_MSG_PUB.Add;
1391:
1392: RAISE l_interface_error;
1385: );
1386: END IF ;
1387: p_msg_data :='Not able to fetch the business_group_id';
1388: FND_MESSAGE.Set_Name('CS', p_msg_data);
1389: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
1390: FND_MSG_PUB.Add;
1391:
1392: RAISE l_interface_error;
1393:
1401: , 'Not able to fetch the business_group_id '
1402: );
1403: END IF ;
1404:
1405: --FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PURGSET_INV');
1406: -- FND_MSG_PUB.ADD;
1407: p_msg_data :='Not able to fetch the business_group_id';
1408: FND_MESSAGE.Set_Name('CS', p_msg_data);
1409: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
1404:
1405: --FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PURGSET_INV');
1406: -- FND_MSG_PUB.ADD;
1407: p_msg_data :='Not able to fetch the business_group_id';
1408: FND_MESSAGE.Set_Name('CS', p_msg_data);
1409: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
1410: FND_MSG_PUB.Add;
1411:
1412: RAISE l_interface_error;
1405: --FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PURGSET_INV');
1406: -- FND_MSG_PUB.ADD;
1407: p_msg_data :='Not able to fetch the business_group_id';
1408: FND_MESSAGE.Set_Name('CS', p_msg_data);
1409: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
1410: FND_MSG_PUB.Add;
1411:
1412: RAISE l_interface_error;
1413: WHEN OTHERS then
1420: , 'Not able to fetch the business_group_id '
1421: );
1422: END IF ;
1423: p_msg_data :='Not able to fetch the business_group_id';
1424: FND_MESSAGE.Set_Name('CS', p_msg_data);
1425: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
1426: FND_MSG_PUB.Add;
1427:
1428: RAISE l_interface_error;
1421: );
1422: END IF ;
1423: p_msg_data :='Not able to fetch the business_group_id';
1424: FND_MESSAGE.Set_Name('CS', p_msg_data);
1425: --FND_MESSAGE.SET_TOKEN('API_NAME', p_msg_data);
1426: FND_MSG_PUB.Add;
1427:
1428: RAISE l_interface_error;
1429: End;
1515: If p_msg_type = 'E' and p_msg_data is not null then
1516:
1517:
1518: --FND_MSG_PUB.initialize;
1519: FND_MESSAGE.SET_NAME(p_msg_application,p_msg_data);
1520: ----FND_MESSAGE.SET_TOKEN('pa_transactions_pub.Validate_transaction', p_msg_token1);
1521: FND_MSG_PUB.add;
1522:
1523: RAISE l_interface_error;
1516:
1517:
1518: --FND_MSG_PUB.initialize;
1519: FND_MESSAGE.SET_NAME(p_msg_application,p_msg_data);
1520: ----FND_MESSAGE.SET_TOKEN('pa_transactions_pub.Validate_transaction', p_msg_token1);
1521: FND_MSG_PUB.add;
1522:
1523: RAISE l_interface_error;
1524: End if;
1829:
1830: End if;
1831:
1832:
1833: -- p_msg_data:=FND_MESSAGE.GET;
1834:
1835:
1836: FND_MSG_PUB.Count_And_Get(
1837: p_count => p_msg_count, --out