DBA Data[Home] [Help]

APPS.HZ_AUTOMERGE_PKG dependencies on FND_MSG_PUB

Line 48: FND_MSG_PUB.Reset;

44: PROCEDURE logerror(SQLERRM VARCHAR2 DEFAULT NULL)
45: IS
46: l_msg_data VARCHAR2(2000);
47: BEGIN
48: FND_MSG_PUB.Reset;
49: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
50: l_msg_data := substr(l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ), 1, 2000) ;
51: END LOOP;
52: IF (SQLERRM IS NOT NULL) THEN

Line 49: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

45: IS
46: l_msg_data VARCHAR2(2000);
47: BEGIN
48: FND_MSG_PUB.Reset;
49: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
50: l_msg_data := substr(l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ), 1, 2000) ;
51: END LOOP;
52: IF (SQLERRM IS NOT NULL) THEN
53: l_msg_data := substr(l_msg_data || SQLERRM, 1, 2000);

Line 50: l_msg_data := substr(l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ), 1, 2000) ;

46: l_msg_data VARCHAR2(2000);
47: BEGIN
48: FND_MSG_PUB.Reset;
49: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
50: l_msg_data := substr(l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ), 1, 2000) ;
51: END LOOP;
52: IF (SQLERRM IS NOT NULL) THEN
53: l_msg_data := substr(l_msg_data || SQLERRM, 1, 2000);
54: END IF;

Line 189: FND_MSG_PUB.ADD;

185: ROLLBACK TO create_rem_batch;
186: log(SQLERRM);
187: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
188: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
189: FND_MSG_PUB.ADD;
190: RAISE;
191: END create_rem_batch;
192:
193: -- bug 4773387, non automerge dup set will be created in rem batch. Delete it from orig. batch

Line 289: FND_MSG_PUB.ADD;

285: IF (upper(l_automerge_flag) <> 'Y') THEN
286: fnd_conc_global.set_req_globals(conc_status => 'ERROR',
287: request_data => 'ERROR') ;
288: FND_MESSAGE.SET_NAME('AR', 'HZ_AM_MATCH_RULE_SUPPORT');
289: FND_MSG_PUB.ADD;
290: logerror;
291: err := fnd_message.get;
292: retcode := 2;
293: ELSE

Line 309: fnd_msg_pub.initialize;

305: --log (' l_req_type = ' || l_req_type);
306: --log(' l_no_of_workers ' || l_no_of_workers);
307: log(' l_dup_batch_id ' || l_dup_batch_id);
308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309: fnd_msg_pub.initialize;
310:
311: -- get all dup_set_id's for a particular batch. this conditions also helps in re-running
312: -- the program again for same batch.
313:

Line 445: fnd_msg_pub.count_and_get(

441: ELSE
442: l_success := FALSE;
443: retcode := 2;
444: err := SQLERRM;
445: fnd_msg_pub.count_and_get(
446: p_encoded => fnd_api.g_false,
447: p_count => x_msg_count,
448: p_data => x_msg_data);
449: ROLLBACK TO automerge;

Line 467: fnd_msg_pub.count_and_get(

463: -- if unexpected error, then error out the program
464: l_success := FALSE;
465: retcode := 2;
466: err := SQLERRM;
467: fnd_msg_pub.count_and_get(
468: p_encoded => fnd_api.g_false,
469: p_count => x_msg_count,
470: p_data => x_msg_data);
471: ROLLBACK TO automerge;

Line 546: FND_MSG_PUB.ADD;

542: err := SQLERRM;
543: log ('ERROR :: =' || SQLERRM);
544: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
545: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
546: FND_MSG_PUB.ADD;
547: FND_MSG_PUB.Count_And_Get(
548: p_encoded => FND_API.G_FALSE,
549: p_count => x_msg_count,
550: p_data => x_msg_data);

Line 547: FND_MSG_PUB.Count_And_Get(

543: log ('ERROR :: =' || SQLERRM);
544: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
545: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
546: FND_MSG_PUB.ADD;
547: FND_MSG_PUB.Count_And_Get(
548: p_encoded => FND_API.G_FALSE,
549: p_count => x_msg_count,
550: p_data => x_msg_data);
551: