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);
259: FND_MSG_PUB.Add;
260: END IF;
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);
259: FND_MSG_PUB.Add;
260: END IF;
261:
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);
259: FND_MSG_PUB.Add;
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);
269: FND_MSG_PUB.Add;
270: END IF;
271: -- END of API body
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);
269: FND_MSG_PUB.Add;
270: END IF;
271: -- END of API body
272:
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;
317:
318: -- Standard call to get message count and IF count is 1, get message info.
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);
515: FND_MSG_PUB.Add;
516: END IF;
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);
515: FND_MSG_PUB.Add;
516: END IF;
517:
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);
515: FND_MSG_PUB.Add;
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);
525: FND_MSG_PUB.Add;
526: END IF;
527: -- END of API body
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);
525: FND_MSG_PUB.Add;
526: END IF;
527: -- END of API body
528:
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;
574:
575: -- Standard call to get message count and IF count is 1, get message info.
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);
731: FND_MSG_PUB.Add;
732: END IF;
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);
731: FND_MSG_PUB.Add;
732: END IF;
733:
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);
731: FND_MSG_PUB.Add;
732: END IF;
733:
734: /* Vertical Post Processing section - mandatory */
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);
775: FND_MSG_PUB.Add;
776: END IF;
777: -- END of API body
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);
775: FND_MSG_PUB.Add;
776: END IF;
777: -- END of API body
778:
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;
792:
793: -- Standard call to get message count and IF count is 1, get message info.
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);
937: FND_MSG_PUB.Add;
938: END IF;
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);
937: FND_MSG_PUB.Add;
938: END IF;
939:
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);
937: FND_MSG_PUB.Add;
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);
947: FND_MSG_PUB.Add;
948: END IF;
949: -- END of API body
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);
947: FND_MSG_PUB.Add;
948: END IF;
949: -- END of API body
950:
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;
995:
996: -- Standard call to get message count and IF count is 1, get message info.