DBA Data[Home] [Help]

APPS.OKC_ADOPTIONS_GRP dependencies on FND_MSG_PUB

Line 217: FND_MSG_PUB.initialize;

213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215: -- Initialize message list if p_init_msg_list is set to TRUE.
216: IF FND_API.to_Boolean( p_init_msg_list ) THEN
217: FND_MSG_PUB.initialize;
218: END IF;
219:
220: -- Initialize API return status to success
221: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 362: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

358:
359: IF (l_debug = 'Y') THEN
360: okc_debug.log('2000: Leaving check adoption', 2);
361: END IF;
362: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
363:
364: EXCEPTION
365: WHEN FND_API.G_EXC_ERROR THEN
366: IF (l_debug = 'Y') THEN

Line 370: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

366: IF (l_debug = 'Y') THEN
367: okc_debug.log('3000: Leaving Check_Adoption: OKC_API.G_EXCEPTION_ERROR Exception', 2);
368: END IF;
369: x_return_status := G_RET_STS_ERROR ;
370: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
371:
372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
373: IF (l_debug = 'Y') THEN
374: okc_debug.log('4000: Leaving Check_Adoption: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line 392: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,p_encoded=> 'F', p_data => x_msg_data );

388: IF l_unq_local_title_csr%ISOPEN THEN
389: CLOSE l_unq_local_title_csr;
390: END IF;
391: x_return_status := G_RET_STS_UNEXP_ERROR ;
392: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,p_encoded=> 'F', p_data => x_msg_data );
393:
394: WHEN OTHERS THEN
395: IF (l_debug = 'Y') THEN
396: okc_debug.log('5000: Leaving Check_Adoption because of EXCEPTION: '||sqlerrm, 2);

Line 415: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,p_encoded=> 'F', p_data => x_msg_data );

411: CLOSE l_unq_local_title_csr;
412: END IF;
413:
414: x_return_status := G_RET_STS_UNEXP_ERROR ;
415: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,p_encoded=> 'F', p_data => x_msg_data );
416:
417: END check_adoption_details;
418:
419:

Line 471: FND_MSG_PUB.initialize;

467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END IF;
469: -- Initialize message list if p_init_msg_list is set to TRUE.
470: IF FND_API.to_Boolean( p_init_msg_list ) THEN
471: FND_MSG_PUB.initialize;
472: END IF;
473: -- Initialize API return status to success
474: -- If a local article version is deleted the attached global article version
475: -- becomes available in the adoption table with adoption type as "AVAILABLE".

Line 605: FND_MSG_PUB.initialize;

601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603: -- Initialize message list if p_init_msg_list is set to TRUE.
604: IF FND_API.to_Boolean( p_init_msg_list ) THEN
605: FND_MSG_PUB.initialize;
606: END IF;
607: -- Initialize API return status to success
608: x_return_status := FND_API.G_RET_STS_SUCCESS;
609: x_adoption_type := NULL;

Line 901: FND_MSG_PUB.initialize;

897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
898: END IF;
899: -- Initialize message list if p_init_msg_list is set to TRUE.
900: IF FND_API.to_Boolean( p_init_msg_list ) THEN
901: FND_MSG_PUB.initialize;
902: END IF;
903: -- Initialize API return status to success
904: x_return_status := FND_API.G_RET_STS_SUCCESS;
905: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1124: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,p_encoded=> 'F', p_data => x_msg_data );

1120: IF FND_API.To_Boolean( p_commit ) THEN
1121: COMMIT WORK;
1122: END IF;
1123: -- Standard call to get message count and if count is 1, get message info.
1124: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,p_encoded=> 'F', p_data => x_msg_data );
1125:
1126: IF (l_debug = 'Y') THEN
1127: okc_debug.log('200: Leaving check adoption', 2);
1128: END IF;

Line 1287: FND_MSG_PUB.initialize;

1283: IF (l_debug = 'Y') THEN
1284: okc_debug.log('100: Entered auto_adoption for new org.', 2);
1285: END IF;
1286:
1287: FND_MSG_PUB.initialize;
1288: retcode := 0;
1289: l_count_ver_adopted := 0;
1290: l_count_ver_available := 0;
1291: -- The org being passed cannot be a global org.

Line 1296: FND_MSG_PUB.add;

1292:
1293: l_GLOBAL_ORG_ID := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
1294: if p_org_id = l_GLOBAL_ORG_ID or p_org_id = -99 Then
1295: FND_MESSAGE.SET_NAME(G_APP_NAME, 'OKC_ADOPT_INVALID_ORG');
1296: FND_MSG_PUB.add;
1297: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));
1298: retcode := 2;
1299: return;
1300: end if;

Line 1297: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));

1293: l_GLOBAL_ORG_ID := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
1294: if p_org_id = l_GLOBAL_ORG_ID or p_org_id = -99 Then
1295: FND_MESSAGE.SET_NAME(G_APP_NAME, 'OKC_ADOPT_INVALID_ORG');
1296: FND_MSG_PUB.add;
1297: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));
1298: retcode := 2;
1299: return;
1300: end if;
1301:

Line 1316: FND_MSG_PUB.add;

1312: IF (l_debug = 'Y') THEN
1313: okc_debug.log('200: Org row not found', 2);
1314: END IF;
1315: FND_MESSAGE.SET_NAME(G_APP_NAME, 'OKC_ADOPT_INVALID_ORG');
1316: FND_MSG_PUB.add;
1317: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));
1318: retcode := 2;
1319: return;
1320: END IF;

Line 1317: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));

1313: okc_debug.log('200: Org row not found', 2);
1314: END IF;
1315: FND_MESSAGE.SET_NAME(G_APP_NAME, 'OKC_ADOPT_INVALID_ORG');
1316: FND_MSG_PUB.add;
1317: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));
1318: retcode := 2;
1319: return;
1320: END IF;
1321:

Line 1596: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

1592: p_token3_value => l_count_ver_available,
1593: p_token4 => 'ORG_NAME',
1594: p_token4_value => l_organization_name);
1595:
1596: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
1597:
1598: okc_debug.log('500: Leaving Auto_Adoption New Org' );
1599: EXCEPTION
1600: WHEN OTHERS THEN