DBA Data[Home] [Help]

APPS.CN_PURGE_TABLES_PVT dependencies on FND_INSTALLATION

Line 514: l_retstatus := fnd_installation.get_app_info(l_product, l_status, l_industry, l_table_owner);

510:
511: BEGIN
512: debugmsg('CN_PURGE_TABLES_PVT.purge_cn_tables_transactions:Start ' );
513:
514: l_retstatus := fnd_installation.get_app_info(l_product, l_status, l_industry, l_table_owner);
515:
516: IF ( ( l_retstatus = FALSE ) OR ( l_table_owner IS NULL ) ) THEN
517: debugmsg('Cannot get schema name for product :'||l_product);
518: RAISE_APPLICATION_ERROR(-20001,'Cannot get schema name for product :'||l_product);

Line 820: l_retstatus := fnd_installation.get_app_info(l_product, l_status, l_industry, l_table_owner);

816:
817: BEGIN
818: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:Start ' );
819:
820: l_retstatus := fnd_installation.get_app_info(l_product, l_status, l_industry, l_table_owner);
821:
822: IF ( ( l_retstatus = FALSE ) OR ( l_table_owner IS NULL ) ) THEN
823: debugmsg('Cannot get schema name for product :'||l_product);
824: RAISE_APPLICATION_ERROR(-20001,'Cannot get schema name for product :'||l_product);

Line 1065: l_retstatus := fnd_installation.get_app_info(l_product, l_status, l_industry, l_table_owner);

1061:
1062: BEGIN
1063: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_subledgers: start ');
1064:
1065: l_retstatus := fnd_installation.get_app_info(l_product, l_status, l_industry, l_table_owner);
1066:
1067: IF ( ( l_retstatus = FALSE ) OR ( l_table_owner IS NULL ) ) THEN
1068: debugmsg('Cannot get schema name for product :'||l_product);
1069: RAISE_APPLICATION_ERROR(-20001,'Cannot get schema name for product :'||l_product);

Line 1292: l_retstatus := fnd_installation.get_app_info(l_product, l_status, l_industry, l_table_owner);

1288:
1289: BEGIN
1290: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_subledgers: start ');
1291:
1292: l_retstatus := fnd_installation.get_app_info(l_product, l_status, l_industry, l_table_owner);
1293:
1294: IF ( ( l_retstatus = FALSE ) OR ( l_table_owner IS NULL ) ) THEN
1295: debugmsg('Cannot get schema name for product :'||l_product);
1296: RAISE_APPLICATION_ERROR(-20001,'Cannot get schema name for product :'||l_product);

Line 1504: l_retstatus := fnd_installation.get_app_info(l_product, l_status, l_industry, l_table_owner);

1500:
1501: BEGIN
1502: debugmsg('CN_PURGE_TABLES_PVT.purge_cn_tables_refrences: start ');
1503:
1504: l_retstatus := fnd_installation.get_app_info(l_product, l_status, l_industry, l_table_owner);
1505:
1506: IF ( ( l_retstatus = FALSE ) OR ( l_table_owner IS NULL ) ) THEN
1507: debugmsg('Cannot get schema name for product :'||l_product);
1508: RAISE_APPLICATION_ERROR(-20001,'Cannot get schema name for product :'||l_product);

Line 1650: l_retstatus := fnd_installation.get_app_info(l_product, l_status, l_industry, l_table_owner);

1646:
1647: BEGIN
1648: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_refrences: start ');
1649:
1650: l_retstatus := fnd_installation.get_app_info(l_product, l_status, l_industry, l_table_owner);
1651:
1652: IF ( ( l_retstatus = FALSE ) OR ( l_table_owner IS NULL ) ) THEN
1653: debugmsg('Cannot get schema name for product :'||l_product);
1654: RAISE_APPLICATION_ERROR(-20001,'Cannot get schema name for product :'||l_product);

Line 1810: l_retstatus := fnd_installation.get_app_info(l_product, l_status, l_industry, l_table_owner);

1806: l_any_rows_to_process varchar2(1);
1807: BEGIN
1808: debugmsg('CN_PURGE_TABLES_PVT.purge_cn_tables_processing: start ' );
1809:
1810: l_retstatus := fnd_installation.get_app_info(l_product, l_status, l_industry, l_table_owner);
1811:
1812: IF ( ( l_retstatus = FALSE ) OR ( l_table_owner IS NULL ) ) THEN
1813: debugmsg('Cannot get schema name for product :'||l_product);
1814: RAISE_APPLICATION_ERROR(-20001,'Cannot get schema name for product :'||l_product);

Line 1923: l_retstatus := fnd_installation.get_app_info(l_product, l_status, l_industry, l_table_owner);

1919: l_any_rows_to_process varchar2(1);
1920: BEGIN
1921: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_processing: start ' );
1922:
1923: l_retstatus := fnd_installation.get_app_info(l_product, l_status, l_industry, l_table_owner);
1924:
1925: IF ( ( l_retstatus = FALSE ) OR ( l_table_owner IS NULL ) ) THEN
1926: debugmsg('Cannot get schema name for product :'||l_product);
1927: RAISE_APPLICATION_ERROR(-20001,'Cannot get schema name for product :'||l_product);