eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AST_WEBASSIST_PVT dependencies on FND_MSG_PUB

Line 68: FND_MSG_PUB.initialize;

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 */

Line 368: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

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);

Line 373: FND_MSG_PUB.Add;

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

Line 378: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) AND

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);

Line 383: FND_MSG_PUB.Add;

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 */

Line 430: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

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;

Line 433: FND_MSG_PUB.Add;

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,

Line 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: --

Line 449: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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 ;

Line 454: 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 ;
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 ;

Line 459: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_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,

Line 461: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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;

Line 463: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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(

Line 509: FND_MSG_PUB.initialize;

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 */

Line 660: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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: --

Line 673: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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 ;

Line 678: 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 ;
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 ;

Line 683: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_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,

Line 685: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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;

Line 687: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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(

Line 731: FND_MSG_PUB.initialize;

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 */

Line 912: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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: --

Line 926: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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:

Line 934: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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:

Line 942: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

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:

Line 944: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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 );

Line 947: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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:

Line 993: FND_MSG_PUB.initialize;

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 */

Line 1106: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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: --

Line 1118: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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 ;

Line 1123: 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 ;
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 ;

Line 1128: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_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,

Line 1130: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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;

Line 1132: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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;