64: END IF;
65:
66: -- Check p_init_msg_list
67: IF FND_API.to_Boolean( p_init_msg_list ) THEN
68: FND_MSG_PUB.initialize;
69: END IF;
70:
71: -- Implementation of User Hooks
72: /* Copy all parameters to local variables to be passed to Pre, Post AND Business APIs */
364: END IF;
365: END IF;
366:
367: -- Success Message
368: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
369: THEN
370: FND_MESSAGE.Set_Name('ast', 'API_ROWS_UPDATED');
371: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
372: FND_MESSAGE.Set_Token('NUMBER', 1, FALSE);
369: THEN
370: FND_MESSAGE.Set_Name('ast', 'API_ROWS_UPDATED');
371: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
372: FND_MESSAGE.Set_Token('NUMBER', 1, FALSE);
373: FND_MSG_PUB.Add;
374: END IF;
375:
376:
377: -- Success Message
374: END IF;
375:
376:
377: -- Success Message
378: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) AND
379: x_return_status = FND_API.G_RET_STS_SUCCESS
380: THEN
381: FND_MESSAGE.Set_Name('ast', 'API_SUCCESS');
382: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
379: x_return_status = FND_API.G_RET_STS_SUCCESS
380: THEN
381: FND_MESSAGE.Set_Name('ast', 'API_SUCCESS');
382: FND_MESSAGE.Set_Token('ROW', 'ast_QUERY_STRING', TRUE);
383: FND_MSG_PUB.Add;
384: END IF;
385: -- ENDof API boby
386:
387: /* Vertical Post Processing section - mandatory */
426: COMMIT WORK;
427: END IF;
428:
429: -- Debug Message
430: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
431: THEN
432: FND_MESSAGE.Set_Name('ast', 'Pvt WebAssist API: End');
433: FND_MSG_PUB.Add;
434: END IF;
429: -- Debug Message
430: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
431: THEN
432: FND_MESSAGE.Set_Name('ast', 'Pvt WebAssist API: End');
433: FND_MSG_PUB.Add;
434: END IF;
435:
436: -- Standard call to get message count AND IF count is 1, get message info.
437: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
433: FND_MSG_PUB.Add;
434: END IF;
435:
436: -- Standard call to get message count AND IF count is 1, get message info.
437: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
438: p_data => x_msg_data );
439:
440:
441: --
445:
446: WHEN FND_API.G_EXC_ERROR THEN
447: ROLLBACK TO Create_WebAssist_PVT;
448: x_return_status := FND_API.G_RET_STS_ERROR ;
449: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
450: p_data => x_msg_data );
451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
452: ROLLBACK TO Create_WebAssist_PVT;
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
450: p_data => x_msg_data );
451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
452: ROLLBACK TO Create_WebAssist_PVT;
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
454: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
455: p_data => x_msg_data );
456: WHEN OTHERS THEN
457: ROLLBACK TO Create_WebAssist_PVT;
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
455: p_data => x_msg_data );
456: WHEN OTHERS THEN
457: ROLLBACK TO Create_WebAssist_PVT;
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
459: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
460: THEN
461: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
462: END IF;
463: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
457: ROLLBACK TO Create_WebAssist_PVT;
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
459: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
460: THEN
461: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
462: END IF;
463: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
464: p_data => x_msg_data );
465: END;
459: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
460: THEN
461: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
462: END IF;
463: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
464: p_data => x_msg_data );
465: END;
466:
467: PROCEDURE Lock_WebAssist(
505: END IF;
506:
507: -- Check p_init_msg_list
508: IF FND_API.to_Boolean( p_init_msg_list ) THEN
509: FND_MSG_PUB.initialize;
510: END IF;
511:
512: -- Implementation of User Hooks
513: /* Copy all parameters to local variables to be passed to Pre, Post AND Business APIs */
656: END IF;
657:
658: -- Standard call to get message count AND IF count is 1, get message info.
659:
660: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
661: p_data => x_msg_data );
662:
663:
664: --
669:
670: WHEN FND_API.G_EXC_ERROR THEN
671: ROLLBACK TO Lock_WebAssist_PVT;
672: x_return_status := FND_API.G_RET_STS_ERROR ;
673: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
674: p_data => x_msg_data );
675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
676: ROLLBACK TO Lock_WebAssist_PVT;
677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
674: p_data => x_msg_data );
675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
676: ROLLBACK TO Lock_WebAssist_PVT;
677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
678: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
679: p_data => x_msg_data );
680: WHEN OTHERS THEN
681: ROLLBACK TO Lock_WebAssist_PVT;
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
679: p_data => x_msg_data );
680: WHEN OTHERS THEN
681: ROLLBACK TO Lock_WebAssist_PVT;
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
683: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
684: THEN
685: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
686: END IF;
687: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
681: ROLLBACK TO Lock_WebAssist_PVT;
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
683: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
684: THEN
685: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
686: END IF;
687: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
688: p_data => x_msg_data );
689: END;
683: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
684: THEN
685: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
686: END IF;
687: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
688: p_data => x_msg_data );
689: END;
690:
691: PROCEDURE Update_WebAssist(
727: END IF;
728:
729: -- Check p_init_msg_list
730: IF FND_API.to_Boolean( p_init_msg_list ) THEN
731: FND_MSG_PUB.initialize;
732: END IF;
733:
734: -- Implementation of User Hooks
735: /* Copy all parameters to local variables to be passed to Pre, Post AND Business APIs */
908: COMMIT WORK;
909: END IF;
910:
911: -- Standard call to get message count AND IF count is 1, get message info.
912: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
913: p_data => x_msg_data );
914:
915:
916: --
922:
923: ROLLBACK TO Update_WebAssist_PVT;
924: x_return_status := FND_API.G_RET_STS_ERROR ;
925:
926: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
927: p_data => x_msg_data );
928:
929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
930:
930:
931: ROLLBACK TO Update_WebAssist_PVT;
932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
933:
934: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
935: p_data => x_msg_data );
936:
937: WHEN OTHERS THEN
938:
938:
939: ROLLBACK TO Update_WebAssist_PVT;
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
941:
942: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
943: THEN
944: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
945: END IF;
946:
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
941:
942: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
943: THEN
944: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
945: END IF;
946:
947: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
948: p_data => x_msg_data );
943: THEN
944: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
945: END IF;
946:
947: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
948: p_data => x_msg_data );
949:
950: END;
951:
989: END IF;
990:
991: -- Check p_init_msg_list
992: IF FND_API.to_Boolean( p_init_msg_list ) THEN
993: FND_MSG_PUB.initialize;
994: END IF;
995:
996: -- Implementation of User Hooks
997: /* Copy all parameters to local variables to be passed to Pre, Post AND Business APIs */
1102: END IF;
1103: END IF;
1104:
1105: -- Standard call to get message count AND IF count is 1, get message info.
1106: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1107: p_data => x_msg_data );
1108:
1109:
1110: --
1114:
1115: WHEN FND_API.G_EXC_ERROR THEN
1116: ROLLBACK TO Delete_WebAssist_PVT;
1117: x_return_status := FND_API.G_RET_STS_ERROR ;
1118: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1119: p_data => x_msg_data );
1120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1121: ROLLBACK TO Delete_WebAssist_PVT;
1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1119: p_data => x_msg_data );
1120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1121: ROLLBACK TO Delete_WebAssist_PVT;
1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1123: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1124: p_data => x_msg_data );
1125: WHEN OTHERS THEN
1126: ROLLBACK TO Delete_WebAssist_PVT;
1127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1124: p_data => x_msg_data );
1125: WHEN OTHERS THEN
1126: ROLLBACK TO Delete_WebAssist_PVT;
1127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1128: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1129: THEN
1130: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1131: END IF;
1132: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1126: ROLLBACK TO Delete_WebAssist_PVT;
1127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1128: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1129: THEN
1130: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1131: END IF;
1132: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1133: p_data => x_msg_data );
1134: END;
1128: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1129: THEN
1130: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1131: END IF;
1132: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1133: p_data => x_msg_data );
1134: END;
1135: END ast_WebAssist_PVT;