DBA Data[Home] [Help]

APPS.OZF_VENDORMERGE_GRP dependencies on FND_MESSAGE

Line 63: FND_MESSAGE.SET_NAME('OZF','OZF_VENDOR_MERGE');

59: WHERE vendor_id = p_dup_vendor_id
60: AND vendor_site_id = p_dup_vendor_site_id;
61:
62: -- Prepare message name
63: FND_MESSAGE.SET_NAME('OZF','OZF_VENDOR_MERGE');
64: IF SQL%FOUND THEN
65: p_return_status := FND_API.G_RET_STS_SUCCESS;
66: l_row_count := SQL%ROWCOUNT;
67: ELSE

Line 71: FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);

67: ELSE
68: l_row_count := 0;
69: END IF;
70:
71: FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);
72: FND_MESSAGE.SET_TOKEN('TABLE_NAME','OZF_CLAIMS_ALL');
73: -- Add message to API message list.
74: FND_MSG_PUB.Add;
75:

Line 72: FND_MESSAGE.SET_TOKEN('TABLE_NAME','OZF_CLAIMS_ALL');

68: l_row_count := 0;
69: END IF;
70:
71: FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);
72: FND_MESSAGE.SET_TOKEN('TABLE_NAME','OZF_CLAIMS_ALL');
73: -- Add message to API message list.
74: FND_MSG_PUB.Add;
75:
76: -- Get message count and if 1, return message data.

Line 96: FND_MESSAGE.SET_NAME('OZF','OZF_VENDOR_MERGE');

92: WHERE vendor_id = p_dup_vendor_id
93: AND vendor_site_id = p_dup_vendor_site_id;
94:
95: -- Prepare message name
96: FND_MESSAGE.SET_NAME('OZF','OZF_VENDOR_MERGE');
97: IF SQL%FOUND THEN
98: p_return_status := FND_API.G_RET_STS_SUCCESS;
99: l_row_count := SQL%ROWCOUNT;
100: ELSE

Line 104: FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);

100: ELSE
101: l_row_count := 0;
102: END IF;
103:
104: FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);
105: FND_MESSAGE.SET_TOKEN('TABLE_NAME','OZF_CLAIMS_HISTORY_ALL');
106: -- Add message to API message list.
107: FND_MSG_PUB.Add;
108:

Line 105: FND_MESSAGE.SET_TOKEN('TABLE_NAME','OZF_CLAIMS_HISTORY_ALL');

101: l_row_count := 0;
102: END IF;
103:
104: FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);
105: FND_MESSAGE.SET_TOKEN('TABLE_NAME','OZF_CLAIMS_HISTORY_ALL');
106: -- Add message to API message list.
107: FND_MSG_PUB.Add;
108:
109: -- Get message count and if 1, return message data.

Line 128: FND_MESSAGE.SET_NAME('OZF','OZF_VENDOR_MERGE');

124: WHERE vendor_id = p_dup_vendor_id
125: AND vendor_site_id = p_dup_vendor_site_id;
126:
127: -- Prepare message name
128: FND_MESSAGE.SET_NAME('OZF','OZF_VENDOR_MERGE');
129: IF SQL%FOUND THEN
130: p_return_status := FND_API.G_RET_STS_SUCCESS;
131: l_row_count := SQL%ROWCOUNT;
132: ELSE

Line 136: FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);

132: ELSE
133: l_row_count := 0;
134: END IF;
135:
136: FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);
137: FND_MESSAGE.SET_TOKEN('TABLE_NAME','OZF_CLAIMS_INT_ALL');
138: -- Add message to API message list.
139: FND_MSG_PUB.Add;
140:

Line 137: FND_MESSAGE.SET_TOKEN('TABLE_NAME','OZF_CLAIMS_INT_ALL');

133: l_row_count := 0;
134: END IF;
135:
136: FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);
137: FND_MESSAGE.SET_TOKEN('TABLE_NAME','OZF_CLAIMS_INT_ALL');
138: -- Add message to API message list.
139: FND_MSG_PUB.Add;
140:
141: -- Get message count and if 1, return message data.

Line 160: FND_MESSAGE.SET_NAME('OZF','OZF_VENDOR_MERGE');

156: WHERE vendor_id = p_dup_vendor_id
157: AND vendor_site_id = p_dup_vendor_site_id;
158:
159: -- Prepare message name
160: FND_MESSAGE.SET_NAME('OZF','OZF_VENDOR_MERGE');
161: IF SQL%FOUND THEN
162: p_return_status := FND_API.G_RET_STS_SUCCESS;
163: l_row_count := SQL%ROWCOUNT;
164: ELSE

Line 168: FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);

164: ELSE
165: l_row_count := 0;
166: END IF;
167:
168: FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);
169: FND_MESSAGE.SET_TOKEN('TABLE_NAME','OZF_CUST_TRD_PRFLS_ALL');
170: -- Add message to API message list.
171: FND_MSG_PUB.Add;
172:

Line 169: FND_MESSAGE.SET_TOKEN('TABLE_NAME','OZF_CUST_TRD_PRFLS_ALL');

165: l_row_count := 0;
166: END IF;
167:
168: FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);
169: FND_MESSAGE.SET_TOKEN('TABLE_NAME','OZF_CUST_TRD_PRFLS_ALL');
170: -- Add message to API message list.
171: FND_MSG_PUB.Add;
172:
173: -- Get message count and if 1, return message data.