54: END IF;
55:
56: -- Check p_init_msg_list
57: IF FND_API.to_Boolean( p_init_msg_list ) THEN
58: FND_MSG_PUB.initialize;
59: END IF;
60:
61: -- Implementation of User Hooks
62: /* Copy all parameters to local variables to be passed to Pre, Post and Business APIs */
250: CLOSE c2;
251:
252:
253: -- Success Message
254: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
255: THEN
256: FND_MESSAGE.Set_Name('ast', 'API_ROWS_UPDATED');
257: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
258: FND_MESSAGE.Set_Token('NUMBER', 1, FALSE);
255: THEN
256: FND_MESSAGE.Set_Name('ast', 'API_ROWS_UPDATED');
257: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
258: FND_MESSAGE.Set_Token('NUMBER', 1, FALSE);
259: FND_MSG_PUB.Add;
260: END IF;
261:
262:
263: -- Success Message
260: END IF;
261:
262:
263: -- Success Message
264: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) and
265: x_return_status = FND_API.G_RET_STS_SUCCESS
266: THEN
267: FND_MESSAGE.Set_Name('ast', 'API_SUCCESS');
268: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
265: x_return_status = FND_API.G_RET_STS_SUCCESS
266: THEN
267: FND_MESSAGE.Set_Name('ast', 'API_SUCCESS');
268: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
269: FND_MSG_PUB.Add;
270: END IF;
271: -- END of API body
272:
273: /* Vertical Post Processing section - mandatory */
308: COMMIT WORK;
309: END IF;
310:
311: -- Debug Message
312: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
313: THEN
314: FND_MESSAGE.Set_Name('ast', 'Pvt WebAssist API: End');
315: FND_MSG_PUB.Add;
316: END IF;
311: -- Debug Message
312: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
313: THEN
314: FND_MESSAGE.Set_Name('ast', 'Pvt WebAssist API: End');
315: FND_MSG_PUB.Add;
316: END IF;
317:
318: -- Standard call to get message count and IF count is 1, get message info.
319: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
315: FND_MSG_PUB.Add;
316: END IF;
317:
318: -- Standard call to get message count and IF count is 1, get message info.
319: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
320: p_data => x_msg_data );
321:
322:
323: --
329:
330: ROLLBACK TO Create_WebSwitch_PUB;
331: x_return_status := FND_API.G_RET_STS_ERROR ;
332:
333: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
334: p_data => x_msg_data );
335:
336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
337:
337:
338: ROLLBACK TO Create_WebSwitch_PUB;
339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
340:
341: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
342: p_data => x_msg_data );
343:
344: WHEN OTHERS THEN
345:
345:
346: ROLLBACK TO Create_WebSwitch_PUB;
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
348:
349: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
350: THEN
351: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
352: END IF;
353:
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
348:
349: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
350: THEN
351: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
352: END IF;
353:
354: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
355: p_data => x_msg_data );
350: THEN
351: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
352: END IF;
353:
354: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
355: p_data => x_msg_data );
356:
357: END;
358:
392: END IF;
393:
394: -- Check p_init_msg_list
395: IF FND_API.to_Boolean( p_init_msg_list ) THEN
396: FND_MSG_PUB.initialize;
397: END IF;
398:
399: -- Implementation of User Hooks
400: /* Copy all parameters to local variables to be passed to Pre, Post and Business APIs */
506: AND switch_data_id = p_switch_data_rec.switch_data_id;
507:
508:
509: -- Success Message
510: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
511: THEN
512: FND_MESSAGE.Set_Name('ast', 'API_ROWS_UPDATED');
513: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
514: FND_MESSAGE.Set_Token('NUMBER', 1, FALSE);
511: THEN
512: FND_MESSAGE.Set_Name('ast', 'API_ROWS_UPDATED');
513: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
514: FND_MESSAGE.Set_Token('NUMBER', 1, FALSE);
515: FND_MSG_PUB.Add;
516: END IF;
517:
518:
519: -- Success Message
516: END IF;
517:
518:
519: -- Success Message
520: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) and
521: x_return_status = FND_API.G_RET_STS_SUCCESS
522: THEN
523: FND_MESSAGE.Set_Name('ast', 'API_SUCCESS');
524: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
521: x_return_status = FND_API.G_RET_STS_SUCCESS
522: THEN
523: FND_MESSAGE.Set_Name('ast', 'API_SUCCESS');
524: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
525: FND_MSG_PUB.Add;
526: END IF;
527: -- END of API body
528:
529:
565: COMMIT WORK;
566: END IF;
567:
568: -- Debug Message
569: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
570: THEN
571: FND_MESSAGE.Set_Name('ast', 'Pvt WebAssist API: End');
572: FND_MSG_PUB.Add;
573: END IF;
568: -- Debug Message
569: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
570: THEN
571: FND_MESSAGE.Set_Name('ast', 'Pvt WebAssist API: End');
572: FND_MSG_PUB.Add;
573: END IF;
574:
575: -- Standard call to get message count and IF count is 1, get message info.
576: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
572: FND_MSG_PUB.Add;
573: END IF;
574:
575: -- Standard call to get message count and IF count is 1, get message info.
576: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
577: p_data => x_msg_data );
578:
579:
580: --
586:
587: ROLLBACK TO Update_WebSwitch_PVT;
588: x_return_status := FND_API.G_RET_STS_ERROR ;
589:
590: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
591: p_data => x_msg_data );
592:
593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
594:
594:
595: ROLLBACK TO Update_WebSwitch_PVT;
596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
597:
598: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
599: p_data => x_msg_data );
600:
601: WHEN OTHERS THEN
602:
602:
603: ROLLBACK TO Update_WebSwitch_PVT;
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
605:
606: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
607: THEN
608: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
609: END IF;
610:
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
605:
606: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
607: THEN
608: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
609: END IF;
610:
611: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
612: p_data => x_msg_data );
607: THEN
608: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
609: END IF;
610:
611: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
612: p_data => x_msg_data );
613:
614: END;
615:
648: END IF;
649:
650: -- Check p_init_msg_list
651: IF FND_API.to_Boolean( p_init_msg_list ) THEN
652: FND_MSG_PUB.initialize;
653: END IF;
654:
655: -- Implementation of User Hooks
656: /* Copy all parameters to local variables to be passed to Pre, Post and Business APIs */
722: END;
723:
724:
725: -- Success Message
726: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
727: THEN
728: FND_MESSAGE.Set_Name('ast', 'API_ROWS_UPDATED');
729: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
730: FND_MESSAGE.Set_Token('NUMBER', 1, FALSE);
727: THEN
728: FND_MESSAGE.Set_Name('ast', 'API_ROWS_UPDATED');
729: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
730: FND_MESSAGE.Set_Token('NUMBER', 1, FALSE);
731: FND_MSG_PUB.Add;
732: END IF;
733:
734: /* Vertical Post Processing section - mandatory */
735: IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V' ) ) THEN
766: END IF;
767: END IF;
768:
769: -- Success Message
770: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) and
771: x_return_status = FND_API.G_RET_STS_SUCCESS
772: THEN
773: FND_MESSAGE.Set_Name('ast', 'API_SUCCESS');
774: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
771: x_return_status = FND_API.G_RET_STS_SUCCESS
772: THEN
773: FND_MESSAGE.Set_Name('ast', 'API_SUCCESS');
774: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
775: FND_MSG_PUB.Add;
776: END IF;
777: -- END of API body
778:
779:
783: COMMIT WORK;
784: END IF;
785:
786: -- Debug Message
787: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
788: THEN
789: FND_MESSAGE.Set_Name('ast', 'Pvt WebAssist API: End');
790: FND_MSG_PUB.Add;
791: END IF;
786: -- Debug Message
787: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
788: THEN
789: FND_MESSAGE.Set_Name('ast', 'Pvt WebAssist API: End');
790: FND_MSG_PUB.Add;
791: END IF;
792:
793: -- Standard call to get message count and IF count is 1, get message info.
794: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
790: FND_MSG_PUB.Add;
791: END IF;
792:
793: -- Standard call to get message count and IF count is 1, get message info.
794: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
795: p_data => x_msg_data );
796:
797:
798: --
804:
805: ROLLBACK TO Lock_WebSwitch_PVT;
806: x_return_status := FND_API.G_RET_STS_ERROR ;
807:
808: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
809: p_data => x_msg_data );
810:
811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
812:
812:
813: ROLLBACK TO Lock_WebSwitch_PVT;
814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
815:
816: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
817: p_data => x_msg_data );
818:
819: WHEN OTHERS THEN
820:
820:
821: ROLLBACK TO Lock_WebSwitch_PVT;
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
823:
824: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
825: THEN
826: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
827: END IF;
828:
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
823:
824: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
825: THEN
826: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
827: END IF;
828:
829: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
830: p_data => x_msg_data );
825: THEN
826: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
827: END IF;
828:
829: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
830: p_data => x_msg_data );
831:
832: END;
833:
867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
868: END IF;
869: -- Check p_init_msg_list
870: IF FND_API.to_Boolean( p_init_msg_list ) THEN
871: FND_MSG_PUB.initialize;
872: END IF;
873:
874: -- Implementation of User Hooks
875: /* Copy all parameters to local variables to be passed to Pre, Post and Business APIs */
928: END IF;
929:
930:
931: -- Success Message
932: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
933: THEN
934: FND_MESSAGE.Set_Name('ast', 'API_ROWS_UPDATED');
935: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
936: FND_MESSAGE.Set_Token('NUMBER', 1, FALSE);
933: THEN
934: FND_MESSAGE.Set_Name('ast', 'API_ROWS_UPDATED');
935: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
936: FND_MESSAGE.Set_Token('NUMBER', 1, FALSE);
937: FND_MSG_PUB.Add;
938: END IF;
939:
940:
941: -- Success Message
938: END IF;
939:
940:
941: -- Success Message
942: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) and
943: x_return_status = FND_API.G_RET_STS_SUCCESS
944: THEN
945: FND_MESSAGE.Set_Name('ast', 'API_SUCCESS');
946: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
943: x_return_status = FND_API.G_RET_STS_SUCCESS
944: THEN
945: FND_MESSAGE.Set_Name('ast', 'API_SUCCESS');
946: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
947: FND_MSG_PUB.Add;
948: END IF;
949: -- END of API body
950:
951: /* Vertical Post Processing section - mandatory */
986: COMMIT WORK;
987: END IF;
988:
989: -- Debug Message
990: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
991: THEN
992: FND_MESSAGE.Set_Name('ast', 'Pvt WebAssist API: End');
993: FND_MSG_PUB.Add;
994: END IF;
989: -- Debug Message
990: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
991: THEN
992: FND_MESSAGE.Set_Name('ast', 'Pvt WebAssist API: End');
993: FND_MSG_PUB.Add;
994: END IF;
995:
996: -- Standard call to get message count and IF count is 1, get message info.
997: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
993: FND_MSG_PUB.Add;
994: END IF;
995:
996: -- Standard call to get message count and IF count is 1, get message info.
997: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
998: p_data => x_msg_data );
999:
1000:
1001: --
1007:
1008: ROLLBACK TO Delete_WebSwitch_PUB;
1009: x_return_status := FND_API.G_RET_STS_ERROR ;
1010:
1011: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1012: p_data => x_msg_data );
1013:
1014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1015:
1015:
1016: ROLLBACK TO Delete_WebSwitch_PUB;
1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1018:
1019: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1020: p_data => x_msg_data );
1021:
1022: WHEN OTHERS THEN
1023:
1023:
1024: ROLLBACK TO Delete_WebSwitch_PUB;
1025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1026:
1027: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1028: THEN
1029: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1030: END IF;
1031:
1025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1026:
1027: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1028: THEN
1029: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1030: END IF;
1031:
1032: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1033: p_data => x_msg_data );
1028: THEN
1029: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1030: END IF;
1031:
1032: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1033: p_data => x_msg_data );
1034:
1035: END;
1036: