DBA Data[Home] [Help]

APPS.OKC_ADOPTIONS_GRP dependencies on FND_FILE

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 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 1398: FND_FILE.PUT_LINE(FND_FILE.LOG,sqlerrm);

1394: okc_debug.log('500: Leaving Auto_Adoption because of EXCEPTION: '||sqlerrm, 2);
1395: END IF;
1396: l_adp_record_status_tbl(i) := 'U';
1397: l_return_status := G_RET_STS_UNEXP_ERROR ;
1398: FND_FILE.PUT_LINE(FND_FILE.LOG,sqlerrm);
1399: errbuf := substr(sqlerrm,1,200);
1400: rollback to adoption_dml;
1401: END;
1402: **/

Line 1455: FND_FILE.PUT_LINE(FND_FILE.LOG,sqlerrm);

1451: IF l_adoptions_csr%ISOPEN THEN
1452: CLOSE l_adoptions_csr;
1453: END IF;
1454: l_return_status := G_RET_STS_UNEXP_ERROR ;
1455: FND_FILE.PUT_LINE(FND_FILE.LOG,sqlerrm);
1456: retcode := 2;
1457: errbuf := substr(sqlerrm,1,200);
1458: exit; -- Fatal error must exit....
1459: END;

Line 1563: FND_FILE.PUT_LINE(FND_FILE.LOG,sqlerrm);

1559: okc_debug.log('500: Auto_Adoption New Org EXCEPTION: ' ||sqlerrm, 2);
1560: END IF;
1561: l_adp_record_status_tbl(i) := 'U';
1562: l_return_status := G_RET_STS_UNEXP_ERROR ;
1563: FND_FILE.PUT_LINE(FND_FILE.LOG,sqlerrm);
1564: errbuf := substr(sqlerrm,1,200);
1565: rollback to adoption_dml;
1566: END;
1567: -- END;

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

Line 1608: FND_FILE.PUT_LINE(FND_FILE.LOG,sqlerrm);

1604: l_return_status := G_RET_STS_UNEXP_ERROR ;
1605: IF l_adoptions_csr%ISOPEN Then
1606: close l_adoptions_csr;
1607: END IF;
1608: FND_FILE.PUT_LINE(FND_FILE.LOG,sqlerrm);
1609: errbuf := substr(sqlerrm,1,200);
1610: retcode := 2;
1611: END AUTO_ADOPT_NEWORG;
1612: