APPS.AMS_GEN_SUP_LIST_PVT dependencies on FND_MSG_PUB

Line 21: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

17: -- PROCEDURE
18: -- Schedule_Suppression_List
19: -- HISTORY
20: -----------------------------------------------------------
21: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
22: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
23: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
24:
25: PROCEDURE Schedule_Suppression_List(

Line 22: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

18: -- Schedule_Suppression_List
19: -- HISTORY
20: -----------------------------------------------------------
21: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
22: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
23: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
24:
25: PROCEDURE Schedule_Suppression_List(
26: errbuf OUT NOCOPY VARCHAR2,

Line 23: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

19: -- HISTORY
20: -----------------------------------------------------------
21: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
22: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
23: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
24:
25: PROCEDURE Schedule_Suppression_List(
26: errbuf OUT NOCOPY VARCHAR2,
27: retcode OUT NOCOPY NUMBER

Line 77: FND_MSG_PUB.Add;

73:
74: IF l_return_status <> FND_API.g_ret_sts_success THEN
75: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
76: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
77: FND_MSG_PUB.Add;
78: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION in list gen package: AMS_Gen_Sup_List_PVT.Schedule_Suppression_List ');
79:
80: l_msg_count := FND_MSG_PUB.count_msg;
81: FOR i IN 1..FND_MSG_PUB.count_msg LOOP

Line 80: l_msg_count := FND_MSG_PUB.count_msg;

76: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
77: FND_MSG_PUB.Add;
78: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION in list gen package: AMS_Gen_Sup_List_PVT.Schedule_Suppression_List ');
79:
80: l_msg_count := FND_MSG_PUB.count_msg;
81: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
82: l_msg_data := FND_MSG_PUB.get(i, FND_API.G_FALSE);
83: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : AMS_Gen_Sup_List_PVT.Schedule_Suppression_List '|| l_msg_data);
84: END LOOP;

Line 81: FOR i IN 1..FND_MSG_PUB.count_msg LOOP

77: FND_MSG_PUB.Add;
78: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION in list gen package: AMS_Gen_Sup_List_PVT.Schedule_Suppression_List ');
79:
80: l_msg_count := FND_MSG_PUB.count_msg;
81: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
82: l_msg_data := FND_MSG_PUB.get(i, FND_API.G_FALSE);
83: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : AMS_Gen_Sup_List_PVT.Schedule_Suppression_List '|| l_msg_data);
84: END LOOP;
85:

Line 82: l_msg_data := FND_MSG_PUB.get(i, FND_API.G_FALSE);

78: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION in list gen package: AMS_Gen_Sup_List_PVT.Schedule_Suppression_List ');
79:
80: l_msg_count := FND_MSG_PUB.count_msg;
81: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
82: l_msg_data := FND_MSG_PUB.get(i, FND_API.G_FALSE);
83: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : AMS_Gen_Sup_List_PVT.Schedule_Suppression_List '|| l_msg_data);
84: END LOOP;
85:
86: -- clear message buffer

Line 88: FND_MSG_PUB.initialize;

84: END LOOP;
85:
86: -- clear message buffer
87: l_return_status := FND_API.g_ret_sts_success ;
88: FND_MSG_PUB.initialize;
89: END IF;
90:
91: END LOOP;
92: CLOSE c_sup_list;

Line 101: FND_MSG_PUB.Add;

97: EXCEPTION
98: WHEN FND_API.G_EXC_ERROR THEN
99: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
100: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
101: FND_MSG_PUB.Add;
102: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION in list gen package: AMS_Gen_Sup_List_PVT.Schedule_Suppression_List ');
103:
104: l_msg_count := FND_MSG_PUB.count_msg;
105: FOR i IN 1..FND_MSG_PUB.count_msg LOOP

Line 104: l_msg_count := FND_MSG_PUB.count_msg;

100: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
101: FND_MSG_PUB.Add;
102: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION in list gen package: AMS_Gen_Sup_List_PVT.Schedule_Suppression_List ');
103:
104: l_msg_count := FND_MSG_PUB.count_msg;
105: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
106: l_msg_data := FND_MSG_PUB.get(i, FND_API.G_FALSE);
107: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : AMS_Gen_Sup_List_PVT.Schedule_Suppression_List '|| l_msg_data);
108: END LOOP;

Line 105: FOR i IN 1..FND_MSG_PUB.count_msg LOOP

101: FND_MSG_PUB.Add;
102: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION in list gen package: AMS_Gen_Sup_List_PVT.Schedule_Suppression_List ');
103:
104: l_msg_count := FND_MSG_PUB.count_msg;
105: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
106: l_msg_data := FND_MSG_PUB.get(i, FND_API.G_FALSE);
107: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : AMS_Gen_Sup_List_PVT.Schedule_Suppression_List '|| l_msg_data);
108: END LOOP;
109:

Line 106: l_msg_data := FND_MSG_PUB.get(i, FND_API.G_FALSE);

102: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION in list gen package: AMS_Gen_Sup_List_PVT.Schedule_Suppression_List ');
103:
104: l_msg_count := FND_MSG_PUB.count_msg;
105: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
106: l_msg_data := FND_MSG_PUB.get(i, FND_API.G_FALSE);
107: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : AMS_Gen_Sup_List_PVT.Schedule_Suppression_List '|| l_msg_data);
108: END LOOP;
109:
110: -- clear message buffer

Line 111: FND_MSG_PUB.initialize;

107: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : AMS_Gen_Sup_List_PVT.Schedule_Suppression_List '|| l_msg_data);
108: END LOOP;
109:
110: -- clear message buffer
111: FND_MSG_PUB.initialize;
112:
113: WHEN FND_FILE.UTL_FILE_ERROR THEN
114: errbuf:= substr(FND_MESSAGE.get,1,254);
115: retcode:=2;